테이블-unixtime-created.sql 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125
  1. ALTER TABLE bcs_contract_sol CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  2. ALTER TABLE bcs_block CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  3. ALTER TABLE bcs_token_add CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  4. ALTER TABLE bcs_contract_abi CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  5. ALTER TABLE bcs_token_holder CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  6. ALTER TABLE crm_account CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  7. ALTER TABLE crm_account_item CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  8. ALTER TABLE dbr_acc_slip CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  9. ALTER TABLE dbr_acc_slip_bd CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  10. ALTER TABLE dbr_agroup CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  11. ALTER TABLE dbr_app_slip CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  12. ALTER TABLE dbr_bal_buyer CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  13. ALTER TABLE dbr_bal_item CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  14. ALTER TABLE dbr_bal_supplier CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  15. ALTER TABLE dbr_branch CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  16. ALTER TABLE pro_post CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  17. ALTER TABLE pro_wish CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  18. ALTER TABLE dbr_cgroup CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  19. ALTER TABLE pro_sorder_shop CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  20. ALTER TABLE dbr_coupon CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  21. ALTER TABLE dbr_cpack CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  22. ALTER TABLE dbr_credit CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  23. ALTER TABLE users CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  24. ALTER TABLE dbr_credit_bd CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  25. ALTER TABLE dbr_bal_credit CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  26. ALTER TABLE dbr_customer_tie CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  27. ALTER TABLE dbr_customer_tie_bd CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  28. ALTER TABLE dbr_deal_type CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  29. ALTER TABLE dbr_etc CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  30. ALTER TABLE dbr_genio CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  31. ALTER TABLE dbr_genio_bd CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  32. ALTER TABLE dbr_global CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  33. ALTER TABLE dbr_rpt_custom CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  34. ALTER TABLE dbr_iheader CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  35. ALTER TABLE dbr_item CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  36. ALTER TABLE dbr_last_slip_no CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  37. ALTER TABLE dbr_media CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  38. ALTER TABLE dbr_media_bd CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  39. ALTER TABLE dbr_porder CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  40. ALTER TABLE dbr_stock_io CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  41. ALTER TABLE bcs_trans_inter CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  42. ALTER TABLE dbr_pquote CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  43. ALTER TABLE pro_widget_taxo CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  44. ALTER TABLE dbr_pquote_bd CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  45. ALTER TABLE pro_item_taxo CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  46. ALTER TABLE dbr_purch CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  47. ALTER TABLE dbr_purch_bd CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  48. ALTER TABLE dbr_sales CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  49. ALTER TABLE dbr_sales_bd CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  50. ALTER TABLE crm_project CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  51. ALTER TABLE dbr_sgroup CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  52. ALTER TABLE upt_dbupdate CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  53. ALTER TABLE dbt_list_sum CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  54. ALTER TABLE dbr_pos_closing CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  55. ALTER TABLE dbr_sorder_bd CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  56. ALTER TABLE zdb_sorder CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  57. ALTER TABLE dbt_upload_type1 CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  58. ALTER TABLE main_sso_app_bd CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  59. ALTER TABLE dbr_storage CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  60. ALTER TABLE dbr_text_template CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  61. ALTER TABLE bcs_tranxn CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  62. ALTER TABLE zdb_eyetest CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  63. ALTER TABLE dbr_sorder CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  64. ALTER TABLE dbr_user_ext CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  65. ALTER TABLE zdb_sales CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  66. ALTER TABLE dbr_user_perm CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  67. ALTER TABLE dbr_user_perm_bd CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  68. ALTER TABLE dbr_vat_rate CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  69. ALTER TABLE zdb_item CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  70. ALTER TABLE pro_app_guest CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  71. ALTER TABLE upt_encrypt CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  72. ALTER TABLE main_sso_app_log CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  73. ALTER TABLE crp_net_group CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  74. ALTER TABLE pro_cart CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  75. ALTER TABLE pro_guest_log CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  76. ALTER TABLE pro_member_ext CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  77. ALTER TABLE pro_member_perm CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  78. ALTER TABLE pro_member_perm_bd CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  79. ALTER TABLE bcs_uncle_block CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  80. ALTER TABLE pro_ticket_bd CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  81. ALTER TABLE pro_widget_taxo_bd CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  82. ALTER TABLE pro_member_app CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  83. ALTER TABLE pro_member CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  84. ALTER TABLE bcs_contract CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  85. ALTER TABLE bcs_token CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  86. ALTER TABLE dbr_bal_acc CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  87. ALTER TABLE dbr_reward_bd CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  88. ALTER TABLE pro_app_perm CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  89. ALTER TABLE crp_token_group CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  90. ALTER TABLE dbt_webcat_cart CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  91. ALTER TABLE main_sso_app CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  92. ALTER TABLE dbt_log_access CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  93. ALTER TABLE crp_wallet_token CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  94. ALTER TABLE dbr_daily_calc CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  95. ALTER TABLE dbr_reward CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  96. ALTER TABLE bcs_nft CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  97. ALTER TABLE pro_post_bd CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  98. ALTER TABLE pro_app_perm_bd CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  99. ALTER TABLE bcs_last_sync_no CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  100. ALTER TABLE bcm_contract CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  101. ALTER TABLE pro_app_api CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  102. ALTER TABLE pro_company_contact_bd CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  103. ALTER TABLE dbr_bal_reward CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  104. ALTER TABLE crp_wallet CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  105. ALTER TABLE dbr_acc_code CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  106. ALTER TABLE log_branch_closing CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  107. ALTER TABLE dbr_setup CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  108. ALTER TABLE dbr_company CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  109. ALTER TABLE pro_member_dormant CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  110. ALTER TABLE dbr_squote CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  111. ALTER TABLE zdb_supplier CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  112. ALTER TABLE pro_post_type CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  113. ALTER TABLE pro_item_taxo_bd CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  114. ALTER TABLE dbr_squote_bd CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  115. ALTER TABLE zdb_buyer CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  116. ALTER TABLE dbr_sorder_bd_ship CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  117. ALTER TABLE dbr_igroup CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  118. ALTER TABLE dbr_user_menu CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  119. ALTER TABLE pro_company_crcard_bd CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  120. ALTER TABLE dbt_list_type1 CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  121. ALTER TABLE pro_company_destina_bd CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  122. ALTER TABLE log_procedure_run CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  123. ALTER TABLE dbr_porder_bd CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  124. ALTER TABLE pro_member_menu CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';
  125. ALTER TABLE zdb_nonitem CHANGE `created_on` `created_on` BIGINT(20) NULL DEFAULT '0';