v2.0.0.sql 8.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154
  1. SET FOREIGN_KEY_CHECKS=0;
  2. ALTER TABLE `t_documentary` ADD COLUMN IF NOT EXISTS `documentary_number` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' AFTER `documentary_id`;
  3. ALTER TABLE `t_documentary` ADD COLUMN IF NOT EXISTS `documentary_number_pid` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' AFTER `documentary_number`;
  4. ALTER TABLE `t_documentary` ADD COLUMN IF NOT EXISTS `documentary_product_id` int(11) NULL DEFAULT NULL AFTER `documentary_number_pid`;
  5. ALTER TABLE `t_documentary` ADD COLUMN IF NOT EXISTS `documentary_object` varchar(13) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' AFTER `documentary_product_id`;
  6. ALTER TABLE `t_documentary` ADD COLUMN IF NOT EXISTS `data_id` varchar(25) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' AFTER `documentary_state`;
  7. ALTER TABLE `t_documentary` ADD COLUMN IF NOT EXISTS `companyId` int(11) NULL DEFAULT NULL AFTER `data_id`;
  8. ALTER TABLE `t_documentary` MODIFY COLUMN IF EXISTS `documentary_id` int(11) NOT NULL FIRST;
  9. ALTER TABLE `t_documentary` DROP PRIMARY KEY;
  10. ALTER TABLE `t_documentary` ADD PRIMARY KEY (`documentary_id`, `documentary_number`) USING BTREE;
  11. ALTER TABLE `t_documentary` ADD UNIQUE INDEX IF NOT EXISTS `documentary_number`(`documentary_number`) USING BTREE;
  12. ALTER TABLE `t_documentary` MODIFY COLUMN IF EXISTS `documentary_id` int(11) NOT NULL AUTO_INCREMENT FIRST;
  13. CREATE TABLE IF NOT EXISTS `t_documentary_statistics` (
  14. `statistics_id` int(11) NOT NULL AUTO_INCREMENT,
  15. `statistics_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  16. `statistics_number` int(11) NOT NULL DEFAULT 0,
  17. `permission` tinyint(1) NULL DEFAULT 0,
  18. `user_ids` text CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  19. `companyId` int(11) NULL DEFAULT NULL,
  20. PRIMARY KEY (`statistics_id`) USING BTREE
  21. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
  22. CREATE TABLE IF NOT EXISTS `t_documentary_step` (
  23. `step_id` int(11) NOT NULL AUTO_INCREMENT,
  24. `step_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '',
  25. `step_number` int(11) NOT NULL,
  26. `affairIds` text CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  27. `companyId` int(11) NULL DEFAULT 0,
  28. `ctime` datetime(0) NULL DEFAULT NULL,
  29. `utime` datetime(0) NULL DEFAULT NULL,
  30. `tag_ids` text CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  31. PRIMARY KEY (`step_id`) USING BTREE
  32. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
  33. ALTER TABLE `t_rule_new` ADD COLUMN IF NOT EXISTS `documentary_modular_statistics` tinyint(1) NULL DEFAULT 0 AFTER `material_modular_push`;
  34. ALTER TABLE `t_rule_new` ADD COLUMN IF NOT EXISTS `documentary_modular_remove` tinyint(1) NULL DEFAULT 0 AFTER `documentary_modular_statistics`;
  35. CREATE TABLE IF NOT EXISTS `t_report_account` (
  36. `account_id` int(11) NOT NULL AUTO_INCREMENT,
  37. `account_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  38. `account_bank_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
  39. `account_bank_number` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
  40. `account_cumulative` double(13, 2) NULL DEFAULT 0,
  41. `ctime` datetime(0) NULL DEFAULT NULL,
  42. `utime` datetime(0) NULL DEFAULT NULL,
  43. `user_id` int(11) NULL DEFAULT NULL,
  44. `permission` tinyint(1) NULL DEFAULT 1,
  45. `see_user_ids` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  46. PRIMARY KEY (`account_id`) USING BTREE
  47. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  48. ALTER TABLE `t_report_forms` ADD COLUMN IF NOT EXISTS `set_company_account` tinyint(1) NULL DEFAULT 2 AFTER `set_achievements`;
  49. ALTER TABLE `t_statement_calculation` ADD COLUMN IF NOT EXISTS `calculation_account_category_out` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `calculation_product_color`;
  50. ALTER TABLE `t_statement_calculation` ADD COLUMN IF NOT EXISTS `calculation_receivables_payment_category` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `calculation_account_category_out`;
  51. ALTER TABLE `t_statement_calculation` ADD COLUMN IF NOT EXISTS `receivables_mode` tinyint(1) NOT NULL AFTER `calculation_receivables_payment_category`;
  52. ALTER TABLE `t_statement_calculation` ADD COLUMN IF NOT EXISTS `bill_order_number` varchar(255) NULL AFTER `receivables_mode`;
  53. ALTER TABLE `t_affair` ADD COLUMN IF NOT EXISTS `lock_user` int(11) NULL DEFAULT NULL AFTER `lock_time`;
  54. ALTER TABLE `t_bill` ADD COLUMN IF NOT EXISTS `bill_number_user_defined` varchar(255) NULL AFTER `bill_name`;
  55. ALTER TABLE `t_bill_order` ADD COLUMN IF NOT EXISTS `bill_amount` decimal(18, 3) NULL DEFAULT NULL AFTER `bill_object`;
  56. UPDATE `t_affair_system_column` SET `column_control` = 35 WHERE `column_id` = 247;
  57. ALTER TABLE `t_bill_order`
  58. ADD COLUMN IF NOT EXISTS `bill_pnames` text NULL AFTER `bill_amount`;
  59. CREATE TABLE IF NOT EXISTS `t_inventory_frequently` (
  60. `frequently_id` int(11) NOT NULL AUTO_INCREMENT,
  61. `user_id` int(11) NULL DEFAULT NULL,
  62. `inventory_user_ids` text CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  63. `utime` varchar(25) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '',
  64. UNIQUE INDEX `frequently_id`(`frequently_id`) USING BTREE
  65. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Compact;
  66. CREATE TABLE IF NOT EXISTS `t_inventory_notice` (
  67. `notice_id` int(11) NOT NULL AUTO_INCREMENT,
  68. `user_id` int(11) NULL DEFAULT NULL,
  69. `data_ids` text CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  70. `ctime` varchar(25) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '',
  71. `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  72. `data_count` int(11) NULL DEFAULT NULL,
  73. PRIMARY KEY (`notice_id`) USING BTREE,
  74. UNIQUE INDEX `frequently_id`(`notice_id`) USING BTREE
  75. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Compact;
  76. CREATE TABLE IF NOT EXISTS `t_inventory_notice_user` (
  77. `id` int(11) NOT NULL AUTO_INCREMENT,
  78. `notice_id` int(11) NOT NULL,
  79. `user_id` int(11) NOT NULL,
  80. `ctime` varchar(25) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '',
  81. `notice_state` tinyint(1) NULL DEFAULT NULL,
  82. PRIMARY KEY (`id`) USING BTREE,
  83. UNIQUE INDEX `id`(`id`) USING BTREE
  84. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Compact;
  85. CREATE TABLE IF NOT EXISTS `t_screen` (
  86. `screen_id` int(11) NOT NULL AUTO_INCREMENT,
  87. `user_id` int(11) NULL DEFAULT NULL,
  88. `column_ids` text CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  89. `utime` varchar(25) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '',
  90. `screen_type` tinyint(1) NULL DEFAULT 1,
  91. UNIQUE INDEX `frequently_id`(`screen_id`) USING BTREE
  92. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Compact;
  93. ALTER TABLE `t_rule_new`
  94. ADD COLUMN IF NOT EXISTS `affair_all_modify_record_see` tinyint(1) NULL DEFAULT 0 AFTER `product_modular_private_see`;
  95. UPDATE `t_report_forms` SET `report_forms_title`='账户金额核算表' WHERE (`report_forms_title`='帐户金额核算表') LIMIT 1;
  96. ALTER TABLE `t_statement_calculation` MODIFY COLUMN IF EXISTS `calculation_ctime` datetime(0) NULL DEFAULT NULL AFTER `day`;
  97. ALTER TABLE `t_documentary_step`
  98. ADD COLUMN IF NOT EXISTS `tag_ids` text CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL AFTER `utime`;
  99. ALTER TABLE `t_report_account`
  100. MODIFY COLUMN IF EXISTS `account_cumulative` double(13, 2) NULL DEFAULT 0 AFTER `account_bank_number`;
  101. ALTER TABLE `t_user`
  102. ADD COLUMN IF NOT EXISTS `report_password` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL AFTER `report_header`;
  103. CREATE TABLE IF NOT EXISTS `t_user_reminder` (
  104. `user_id` int(11) NOT NULL,
  105. `sale_price_reminder` tinyint(1) DEFAULT 0,
  106. `purchase_price_reminder` tinyint(1) DEFAULT 0,
  107. `documentary_add_reminder` tinyint(1) DEFAULT 0,
  108. `documentary_add_son_reminder` tinyint(1) DEFAULT 0,
  109. `documentary_join_reminder` tinyint(1) DEFAULT 0,
  110. PRIMARY KEY (`user_id`),
  111. UNIQUE KEY `user_id` (`user_id`) USING BTREE
  112. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=COMPACT;
  113. ALTER TABLE `t_user`
  114. ADD COLUMN IF NOT EXISTS `report_password_type` tinyint(1) NULL DEFAULT 0 AFTER `report_password`;
  115. ALTER TABLE `t_user_reminder`
  116. ADD COLUMN IF NOT EXISTS `documentary_new_affair_join_reminder` tinyint(1) NULL DEFAULT 0 AFTER `documentary_join_reminder`;
  117. SET FOREIGN_KEY_CHECKS=1;