update20230212.sql 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188
  1. ALTER TABLE `zh_project_account` CHANGE `stamp_path` `stamp_path` VARCHAR(5000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户签章oss地址';
  2. ALTER TABLE `zh_revise_price`
  3. ADD COLUMN `rela_lid` varchar(1000) NOT NULL DEFAULT '' COMMENT '关联台账id(zh_ledger.ledger_id)' AFTER `use_stage_order`;
  4. ALTER TABLE `zh_revise_price`
  5. ADD COLUMN `rela_cid` varchar(5000) NOT NULL DEFAULT '' COMMENT '关联变更令id(zh_change.cid)' AFTER `rela_lid`;
  6. ALTER TABLE `zh_revise_price`
  7. ADD COLUMN `his_rela_cid` varchar(5000) NOT NULL DEFAULT '' COMMENT '审批通过后,关联变更令id(zh_change.cid)' AFTER `rela_cid`;
  8. CREATE TABLE `zh_audit_ass` (
  9. `id` bigint(20) NOT NULL AUTO_INCREMENT,
  10. `pid` int(11) unsigned NOT NULL COMMENT '项目id',
  11. `tid` int(11) unsigned NOT NULL COMMENT '标段id',
  12. `user_id` int(11) unsigned NOT NULL COMMENT '主账号id',
  13. `ass_user_id` int(11) unsigned NOT NULL COMMENT '协审账号id',
  14. `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '用户名',
  15. `company` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '单位',
  16. `role` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '角色',
  17. `ass_ledger_id` varchar(1000) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '协审台账id(zh_ledger.ledger_id)',
  18. PRIMARY KEY (`id`),
  19. KEY `idx_tid` (`tid`) USING BTREE,
  20. KEY `idx_tid_user` (`tid`,`user_id`) USING BTREE
  21. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  22. CREATE TABLE `zh_stage_audit_ass` (
  23. `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  24. `pid` int(11) unsigned NOT NULL COMMENT '项目id',
  25. `tid` int(11) unsigned NOT NULL COMMENT '标段id',
  26. `sid` int(11) unsigned NOT NULL COMMENT '期id',
  27. `times` int(11) unsigned NOT NULL DEFAULT '1' COMMENT '审批次',
  28. `user_id` int(11) unsigned NOT NULL COMMENT '主账号id',
  29. `ass_user_id` int(11) unsigned NOT NULL COMMENT '协审人账号id',
  30. `ass_ledger_id` varchar(5000) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '协审台账id(zh_ledger.ledger_id)',
  31. `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '名称',
  32. `company` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '单位',
  33. `role` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '角色',
  34. `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  35. `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  36. `confirm` tinyint(4) unsigned NOT NULL DEFAULT '1',
  37. `locked` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '锁定',
  38. PRIMARY KEY (`id`),
  39. KEY `idx_sid_times` (`sid`,`times`) USING BTREE,
  40. KEY `idx_sid_times_user` (`sid`,`times`,`user_id`) USING BTREE
  41. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  42. ALTER TABLE `zh_budget_final`
  43. ADD COLUMN `deal_dgn_qty1` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '决算-合同-数量1' AFTER `dgn_qty`,
  44. ADD COLUMN `deal_dgn_qty2` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '决算-合同-数量2' AFTER `deal_dgn_qty1`,
  45. ADD COLUMN `c_dgn_qty1` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '决算-变更-数量1' AFTER `deal_dgn_qty2`,
  46. ADD COLUMN `c_dgn_qty2` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '决算-变更-数量2' AFTER `c_dgn_qty1`,
  47. ADD COLUMN `final_contract_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '决算-合同金额' AFTER `final_dgn_qty2`,
  48. ADD COLUMN `final_qc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '决算-变更金额' AFTER `final_contract_tp`;
  49. ALTER TABLE `zh_tender`
  50. ADD COLUMN `rpt_show_level` varchar(50) NOT NULL DEFAULT 'last' AFTER `c_plan_list_rule`;
  51. ALTER TABLE `zh_ledger_0`
  52. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  53. ALTER TABLE `zh_ledger_1`
  54. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  55. ALTER TABLE `zh_ledger_2`
  56. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  57. ALTER TABLE `zh_ledger_3`
  58. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  59. ALTER TABLE `zh_ledger_4`
  60. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  61. ALTER TABLE `zh_ledger_5`
  62. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  63. ALTER TABLE `zh_ledger_6`
  64. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  65. ALTER TABLE `zh_ledger_7`
  66. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  67. ALTER TABLE `zh_ledger_8`
  68. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  69. ALTER TABLE `zh_ledger_9`
  70. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  71. ALTER TABLE `zh_pos_0`
  72. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  73. ALTER TABLE `zh_pos_1`
  74. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  75. ALTER TABLE `zh_pos_2`
  76. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  77. ALTER TABLE `zh_pos_3`
  78. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  79. ALTER TABLE `zh_pos_4`
  80. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  81. ALTER TABLE `zh_pos_5`
  82. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  83. ALTER TABLE `zh_pos_6`
  84. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  85. ALTER TABLE `zh_pos_7`
  86. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  87. ALTER TABLE `zh_pos_8`
  88. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  89. ALTER TABLE `zh_pos_9`
  90. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  91. ALTER TABLE `zh_pos_10`
  92. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  93. ALTER TABLE `zh_pos_11`
  94. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  95. ALTER TABLE `zh_pos_12`
  96. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  97. ALTER TABLE `zh_pos_13`
  98. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  99. ALTER TABLE `zh_pos_14`
  100. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  101. ALTER TABLE `zh_pos_15`
  102. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  103. ALTER TABLE `zh_pos_16`
  104. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  105. ALTER TABLE `zh_pos_17`
  106. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  107. ALTER TABLE `zh_pos_18`
  108. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  109. ALTER TABLE `zh_pos_19`
  110. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  111. ALTER TABLE `zh_revise_bills_0`
  112. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  113. ALTER TABLE `zh_revise_bills_1`
  114. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  115. ALTER TABLE `zh_revise_bills_2`
  116. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  117. ALTER TABLE `zh_revise_bills_3`
  118. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  119. ALTER TABLE `zh_revise_bills_4`
  120. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  121. ALTER TABLE `zh_revise_bills_5`
  122. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  123. ALTER TABLE `zh_revise_bills_6`
  124. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  125. ALTER TABLE `zh_revise_bills_7`
  126. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  127. ALTER TABLE `zh_revise_bills_8`
  128. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  129. ALTER TABLE `zh_revise_bills_9`
  130. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  131. ALTER TABLE `zh_revise_pos_0`
  132. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  133. ALTER TABLE `zh_revise_pos_1`
  134. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  135. ALTER TABLE `zh_revise_pos_2`
  136. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  137. ALTER TABLE `zh_revise_pos_3`
  138. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  139. ALTER TABLE `zh_revise_pos_4`
  140. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  141. ALTER TABLE `zh_revise_pos_5`
  142. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  143. ALTER TABLE `zh_revise_pos_6`
  144. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  145. ALTER TABLE `zh_revise_pos_7`
  146. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  147. ALTER TABLE `zh_revise_pos_8`
  148. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  149. ALTER TABLE `zh_revise_pos_9`
  150. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  151. ALTER TABLE `zh_revise_pos_10`
  152. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  153. ALTER TABLE `zh_revise_pos_11`
  154. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  155. ALTER TABLE `zh_revise_pos_12`
  156. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  157. ALTER TABLE `zh_revise_pos_13`
  158. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  159. ALTER TABLE `zh_revise_pos_14`
  160. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  161. ALTER TABLE `zh_revise_pos_15`
  162. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  163. ALTER TABLE `zh_revise_pos_16`
  164. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  165. ALTER TABLE `zh_revise_pos_17`
  166. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  167. ALTER TABLE `zh_revise_pos_18`
  168. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  169. ALTER TABLE `zh_revise_pos_19`
  170. ADD COLUMN `ccid` varchar(36) NULL DEFAULT '' COMMENT 'create_change_id(uuid)' AFTER `crid`;
  171. ALTER TABLE `zh_stage_pay`
  172. ADD COLUMN `porder` tinyint(4) NOT NULL DEFAULT '0' COMMENT '排序' AFTER `sorder`;
  173. UPDATE zh_stage_pay sp LEFT JOIN zh_pay p ON sp.pid = p.id SET sp.porder = IF(ISNull(p.`order`), 0, p.`order`);
  174. ALTER TABLE `zh_change_ledger` ADD `formc` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '是否为变更新增(用于区分台账)' AFTER `ccid`;
  175. ALTER TABLE `zh_change_pos` ADD `formc` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '是否为变更新增(用于区分台账)' AFTER `ccid`;
  176. ALTER TABLE `zh_stage_audit` ADD `is_old` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '是否为旧流程(用于管理员修改流程时旧数据保留但不影响新流程)' AFTER `opinion`;