useful-qry/table-controls/테이블-unixtime-created.sql

ALTER TABLE bcs_contract_sol CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE bcs_block CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE bcs_token_add CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE bcs_contract_abi CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE bcs_token_holder CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE crm_account CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE crm_account_item CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_acc_slip CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_acc_slip_bd CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_agroup CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_app_slip CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_bal_buyer CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_bal_item CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_bal_supplier CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_branch CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE pro_post CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE pro_wish CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_cgroup CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE pro_sorder_shop CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_coupon CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_cpack CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_credit CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE users CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_credit_bd CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_bal_credit CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_customer_tie CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_customer_tie_bd CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_deal_type CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_etc CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_genio CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_genio_bd CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_global CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_rpt_custom CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_iheader CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_item CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_last_slip_no CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_media CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_media_bd CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_porder CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_stock_io CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE bcs_trans_inter CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_pquote CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE pro_widget_taxo CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_pquote_bd CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE pro_item_taxo CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_purch CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_purch_bd CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_sales CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_sales_bd CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE crm_project CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_sgroup CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE upt_dbupdate CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbt_list_sum CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_pos_closing CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_sorder_bd CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE zdb_sorder CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbt_upload_type1 CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE main_sso_app_bd CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_storage CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_text_template CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE bcs_tranxn CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE zdb_eyetest CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_sorder CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_user_ext CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE zdb_sales CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_user_perm CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_user_perm_bd CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_vat_rate CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE zdb_item CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE pro_app_guest CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE upt_encrypt CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE main_sso_app_log CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE crp_net_group CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE pro_cart CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE pro_guest_log CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE pro_member_ext CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE pro_member_perm CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE pro_member_perm_bd CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE bcs_uncle_block CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE pro_ticket_bd CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE pro_widget_taxo_bd CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE pro_member_app CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE pro_member CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE bcs_contract CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE bcs_token CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_bal_acc CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_reward_bd CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE pro_app_perm CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE crp_token_group CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbt_webcat_cart CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE main_sso_app CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbt_log_access CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE crp_wallet_token CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_daily_calc CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_reward CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE bcs_nft CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE pro_post_bd CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE pro_app_perm_bd CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE bcs_last_sync_no CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE bcm_contract CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE pro_app_api CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE pro_company_contact_bd CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_bal_reward CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE crp_wallet CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_acc_code CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE log_branch_closing CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_setup CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_company CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE pro_member_dormant CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_squote CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE zdb_supplier CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE pro_post_type CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE pro_item_taxo_bd CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_squote_bd CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE zdb_buyer CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_sorder_bd_ship CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_igroup CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_user_menu CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE pro_company_crcard_bd CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbt_list_type1 CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE pro_company_destina_bd CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE log_procedure_run CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE dbr_porder_bd CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE pro_member_menu CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
ALTER TABLE zdb_nonitem CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';