update2022xxxx.sql 21 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322
  1. ALTER TABLE `zh_pos_0`
  2. MODIFY COLUMN `add_stage` int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
  3. ADD COLUMN `add_stage_order` tinyint(4) NOT NULL DEFAULT 0 COMMENT '新增期序号' AFTER `add_stage`;
  4. ALTER TABLE `zh_pos_1`
  5. MODIFY COLUMN `add_stage` int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
  6. ADD COLUMN `add_stage_order` tinyint(4) NOT NULL DEFAULT 0 COMMENT '新增期序号' AFTER `add_stage`;
  7. ALTER TABLE `zh_pos_2`
  8. MODIFY COLUMN `add_stage` int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
  9. ADD COLUMN `add_stage_order` tinyint(4) NOT NULL DEFAULT 0 COMMENT '新增期序号' AFTER `add_stage`;
  10. ALTER TABLE `zh_pos_3`
  11. MODIFY COLUMN `add_stage` int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
  12. ADD COLUMN `add_stage_order` tinyint(4) NOT NULL DEFAULT 0 COMMENT '新增期序号' AFTER `add_stage`;
  13. ALTER TABLE `zh_pos_4`
  14. MODIFY COLUMN `add_stage` int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
  15. ADD COLUMN `add_stage_order` tinyint(4) NOT NULL DEFAULT 0 COMMENT '新增期序号' AFTER `add_stage`;
  16. ALTER TABLE `zh_pos_5`
  17. MODIFY COLUMN `add_stage` int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
  18. ADD COLUMN `add_stage_order` tinyint(4) NOT NULL DEFAULT 0 COMMENT '新增期序号' AFTER `add_stage`;
  19. ALTER TABLE `zh_pos_6`
  20. MODIFY COLUMN `add_stage` int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
  21. ADD COLUMN `add_stage_order` tinyint(4) NOT NULL DEFAULT 0 COMMENT '新增期序号' AFTER `add_stage`;
  22. ALTER TABLE `zh_pos_7`
  23. MODIFY COLUMN `add_stage` int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
  24. ADD COLUMN `add_stage_order` tinyint(4) NOT NULL DEFAULT 0 COMMENT '新增期序号' AFTER `add_stage`;
  25. ALTER TABLE `zh_pos_8`
  26. MODIFY COLUMN `add_stage` int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
  27. ADD COLUMN `add_stage_order` tinyint(4) NOT NULL DEFAULT 0 COMMENT '新增期序号' AFTER `add_stage`;
  28. ALTER TABLE `zh_pos_9`
  29. MODIFY COLUMN `add_stage` int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
  30. ADD COLUMN `add_stage_order` tinyint(4) NOT NULL DEFAULT 0 COMMENT '新增期序号' AFTER `add_stage`;
  31. ALTER TABLE `zh_pos_10`
  32. MODIFY COLUMN `add_stage` int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
  33. ADD COLUMN `add_stage_order` tinyint(4) NOT NULL DEFAULT 0 COMMENT '新增期序号' AFTER `add_stage`;
  34. ALTER TABLE `zh_pos_11`
  35. MODIFY COLUMN `add_stage` int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
  36. ADD COLUMN `add_stage_order` tinyint(4) NOT NULL DEFAULT 0 COMMENT '新增期序号' AFTER `add_stage`;
  37. ALTER TABLE `zh_pos_12`
  38. MODIFY COLUMN `add_stage` int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
  39. ADD COLUMN `add_stage_order` tinyint(4) NOT NULL DEFAULT 0 COMMENT '新增期序号' AFTER `add_stage`;
  40. ALTER TABLE `zh_pos_13`
  41. MODIFY COLUMN `add_stage` int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
  42. ADD COLUMN `add_stage_order` tinyint(4) NOT NULL DEFAULT 0 COMMENT '新增期序号' AFTER `add_stage`;
  43. ALTER TABLE `zh_pos_14`
  44. MODIFY COLUMN `add_stage` int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
  45. ADD COLUMN `add_stage_order` tinyint(4) NOT NULL DEFAULT 0 COMMENT '新增期序号' AFTER `add_stage`;
  46. ALTER TABLE `zh_pos_15`
  47. MODIFY COLUMN `add_stage` int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
  48. ADD COLUMN `add_stage_order` tinyint(4) NOT NULL DEFAULT 0 COMMENT '新增期序号' AFTER `add_stage`;
  49. ALTER TABLE `zh_pos_16`
  50. MODIFY COLUMN `add_stage` int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
  51. ADD COLUMN `add_stage_order` tinyint(4) NOT NULL DEFAULT 0 COMMENT '新增期序号' AFTER `add_stage`;
  52. ALTER TABLE `zh_pos_17`
  53. MODIFY COLUMN `add_stage` int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
  54. ADD COLUMN `add_stage_order` tinyint(4) NOT NULL DEFAULT 0 COMMENT '新增期序号' AFTER `add_stage`;
  55. ALTER TABLE `zh_pos_18`
  56. MODIFY COLUMN `add_stage` int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
  57. ADD COLUMN `add_stage_order` tinyint(4) NOT NULL DEFAULT 0 COMMENT '新增期序号' AFTER `add_stage`;
  58. ALTER TABLE `zh_pos_19`
  59. MODIFY COLUMN `add_stage` int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
  60. ADD COLUMN `add_stage_order` tinyint(4) NOT NULL DEFAULT 0 COMMENT '新增期序号' AFTER `add_stage`;
  61. Update zh_pos_0 p Left Join zh_stage s ON p.add_stage = s.id Set p.add_stage_order = s.order where p.add_stage_order > 0;
  62. Update zh_pos_1 p Left Join zh_stage s ON p.add_stage = s.id Set p.add_stage_order = s.order where p.add_stage_order > 0;
  63. Update zh_pos_2 p Left Join zh_stage s ON p.add_stage = s.id Set p.add_stage_order = s.order where p.add_stage_order > 0;
  64. Update zh_pos_3 p Left Join zh_stage s ON p.add_stage = s.id Set p.add_stage_order = s.order where p.add_stage_order > 0;
  65. Update zh_pos_4 p Left Join zh_stage s ON p.add_stage = s.id Set p.add_stage_order = s.order where p.add_stage_order > 0;
  66. Update zh_pos_5 p Left Join zh_stage s ON p.add_stage = s.id Set p.add_stage_order = s.order where p.add_stage_order > 0;
  67. Update zh_pos_6 p Left Join zh_stage s ON p.add_stage = s.id Set p.add_stage_order = s.order where p.add_stage_order > 0;
  68. Update zh_pos_7 p Left Join zh_stage s ON p.add_stage = s.id Set p.add_stage_order = s.order where p.add_stage_order > 0;
  69. Update zh_pos_8 p Left Join zh_stage s ON p.add_stage = s.id Set p.add_stage_order = s.order where p.add_stage_order > 0;
  70. Update zh_pos_9 p Left Join zh_stage s ON p.add_stage = s.id Set p.add_stage_order = s.order where p.add_stage_order > 0;
  71. Update zh_pos_10 p Left Join zh_stage s ON p.add_stage = s.id Set p.add_stage_order = s.order where p.add_stage_order > 0;
  72. Update zh_pos_11 p Left Join zh_stage s ON p.add_stage = s.id Set p.add_stage_order = s.order where p.add_stage_order > 0;
  73. Update zh_pos_12 p Left Join zh_stage s ON p.add_stage = s.id Set p.add_stage_order = s.order where p.add_stage_order > 0;
  74. Update zh_pos_13 p Left Join zh_stage s ON p.add_stage = s.id Set p.add_stage_order = s.order where p.add_stage_order > 0;
  75. Update zh_pos_14 p Left Join zh_stage s ON p.add_stage = s.id Set p.add_stage_order = s.order where p.add_stage_order > 0;
  76. Update zh_pos_15 p Left Join zh_stage s ON p.add_stage = s.id Set p.add_stage_order = s.order where p.add_stage_order > 0;
  77. Update zh_pos_16 p Left Join zh_stage s ON p.add_stage = s.id Set p.add_stage_order = s.order where p.add_stage_order > 0;
  78. Update zh_pos_17 p Left Join zh_stage s ON p.add_stage = s.id Set p.add_stage_order = s.order where p.add_stage_order > 0;
  79. Update zh_pos_18 p Left Join zh_stage s ON p.add_stage = s.id Set p.add_stage_order = s.order where p.add_stage_order > 0;
  80. Update zh_pos_19 p Left Join zh_stage s ON p.add_stage = s.id Set p.add_stage_order = s.order where p.add_stage_order > 0;
  81. ALTER TABLE `zh_revise_pos_0`
  82. MODIFY COLUMN `add_stage` int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
  83. ADD COLUMN `add_stage_order` tinyint(4) NOT NULL DEFAULT 0 COMMENT '新增期序号' AFTER `add_stage`;
  84. ALTER TABLE `zh_revise_pos_1`
  85. MODIFY COLUMN `add_stage` int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
  86. ADD COLUMN `add_stage_order` tinyint(4) NOT NULL DEFAULT 0 COMMENT '新增期序号' AFTER `add_stage`;
  87. ALTER TABLE `zh_revise_pos_2`
  88. MODIFY COLUMN `add_stage` int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
  89. ADD COLUMN `add_stage_order` tinyint(4) NOT NULL DEFAULT 0 COMMENT '新增期序号' AFTER `add_stage`;
  90. ALTER TABLE `zh_revise_pos_3`
  91. MODIFY COLUMN `add_stage` int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
  92. ADD COLUMN `add_stage_order` tinyint(4) NOT NULL DEFAULT 0 COMMENT '新增期序号' AFTER `add_stage`;
  93. ALTER TABLE `zh_revise_pos_4`
  94. MODIFY COLUMN `add_stage` int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
  95. ADD COLUMN `add_stage_order` tinyint(4) NOT NULL DEFAULT 0 COMMENT '新增期序号' AFTER `add_stage`;
  96. ALTER TABLE `zh_revise_pos_5`
  97. MODIFY COLUMN `add_stage` int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
  98. ADD COLUMN `add_stage_order` tinyint(4) NOT NULL DEFAULT 0 COMMENT '新增期序号' AFTER `add_stage`;
  99. ALTER TABLE `zh_revise_pos_6`
  100. MODIFY COLUMN `add_stage` int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
  101. ADD COLUMN `add_stage_order` tinyint(4) NOT NULL DEFAULT 0 COMMENT '新增期序号' AFTER `add_stage`;
  102. ALTER TABLE `zh_revise_pos_7`
  103. MODIFY COLUMN `add_stage` int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
  104. ADD COLUMN `add_stage_order` tinyint(4) NOT NULL DEFAULT 0 COMMENT '新增期序号' AFTER `add_stage`;
  105. ALTER TABLE `zh_revise_pos_8`
  106. MODIFY COLUMN `add_stage` int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
  107. ADD COLUMN `add_stage_order` tinyint(4) NOT NULL DEFAULT 0 COMMENT '新增期序号' AFTER `add_stage`;
  108. ALTER TABLE `zh_revise_pos_9`
  109. MODIFY COLUMN `add_stage` int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
  110. ADD COLUMN `add_stage_order` tinyint(4) NOT NULL DEFAULT 0 COMMENT '新增期序号' AFTER `add_stage`;
  111. ALTER TABLE `zh_revise_pos_10`
  112. MODIFY COLUMN `add_stage` int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
  113. ADD COLUMN `add_stage_order` tinyint(4) NOT NULL DEFAULT 0 COMMENT '新增期序号' AFTER `add_stage`;
  114. ALTER TABLE `zh_revise_pos_11`
  115. MODIFY COLUMN `add_stage` int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
  116. ADD COLUMN `add_stage_order` tinyint(4) NOT NULL DEFAULT 0 COMMENT '新增期序号' AFTER `add_stage`;
  117. ALTER TABLE `zh_revise_pos_12`
  118. MODIFY COLUMN `add_stage` int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
  119. ADD COLUMN `add_stage_order` tinyint(4) NOT NULL DEFAULT 0 COMMENT '新增期序号' AFTER `add_stage`;
  120. ALTER TABLE `zh_revise_pos_13`
  121. MODIFY COLUMN `add_stage` int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
  122. ADD COLUMN `add_stage_order` tinyint(4) NOT NULL DEFAULT 0 COMMENT '新增期序号' AFTER `add_stage`;
  123. ALTER TABLE `zh_revise_pos_14`
  124. MODIFY COLUMN `add_stage` int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
  125. ADD COLUMN `add_stage_order` tinyint(4) NOT NULL DEFAULT 0 COMMENT '新增期序号' AFTER `add_stage`;
  126. ALTER TABLE `zh_revise_pos_15`
  127. MODIFY COLUMN `add_stage` int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
  128. ADD COLUMN `add_stage_order` tinyint(4) NOT NULL DEFAULT 0 COMMENT '新增期序号' AFTER `add_stage`;
  129. ALTER TABLE `zh_revise_pos_16`
  130. MODIFY COLUMN `add_stage` int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
  131. ADD COLUMN `add_stage_order` tinyint(4) NOT NULL DEFAULT 0 COMMENT '新增期序号' AFTER `add_stage`;
  132. ALTER TABLE `zh_revise_pos_17`
  133. MODIFY COLUMN `add_stage` int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
  134. ADD COLUMN `add_stage_order` tinyint(4) NOT NULL DEFAULT 0 COMMENT '新增期序号' AFTER `add_stage`;
  135. ALTER TABLE `zh_revise_pos_18`
  136. MODIFY COLUMN `add_stage` int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
  137. ADD COLUMN `add_stage_order` tinyint(4) NOT NULL DEFAULT 0 COMMENT '新增期序号' AFTER `add_stage`;
  138. ALTER TABLE `zh_revise_pos_19`
  139. MODIFY COLUMN `add_stage` int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
  140. ADD COLUMN `add_stage_order` tinyint(4) NOT NULL DEFAULT 0 COMMENT '新增期序号' AFTER `add_stage`;
  141. Update zh_revise_pos_0 p Left Join zh_stage s ON p.add_stage = s.id Set p.add_stage_order = s.order where p.add_stage_order > 0;
  142. Update zh_revise_pos_1 p Left Join zh_stage s ON p.add_stage = s.id Set p.add_stage_order = s.order where p.add_stage_order > 0;
  143. Update zh_revise_pos_2 p Left Join zh_stage s ON p.add_stage = s.id Set p.add_stage_order = s.order where p.add_stage_order > 0;
  144. Update zh_revise_pos_3 p Left Join zh_stage s ON p.add_stage = s.id Set p.add_stage_order = s.order where p.add_stage_order > 0;
  145. Update zh_revise_pos_4 p Left Join zh_stage s ON p.add_stage = s.id Set p.add_stage_order = s.order where p.add_stage_order > 0;
  146. Update zh_revise_pos_5 p Left Join zh_stage s ON p.add_stage = s.id Set p.add_stage_order = s.order where p.add_stage_order > 0;
  147. Update zh_revise_pos_6 p Left Join zh_stage s ON p.add_stage = s.id Set p.add_stage_order = s.order where p.add_stage_order > 0;
  148. Update zh_revise_pos_7 p Left Join zh_stage s ON p.add_stage = s.id Set p.add_stage_order = s.order where p.add_stage_order > 0;
  149. Update zh_revise_pos_8 p Left Join zh_stage s ON p.add_stage = s.id Set p.add_stage_order = s.order where p.add_stage_order > 0;
  150. Update zh_revise_pos_9 p Left Join zh_stage s ON p.add_stage = s.id Set p.add_stage_order = s.order where p.add_stage_order > 0;
  151. Update zh_revise_pos_10 p Left Join zh_stage s ON p.add_stage = s.id Set p.add_stage_order = s.order where p.add_stage_order > 0;
  152. Update zh_revise_pos_11 p Left Join zh_stage s ON p.add_stage = s.id Set p.add_stage_order = s.order where p.add_stage_order > 0;
  153. Update zh_revise_pos_12 p Left Join zh_stage s ON p.add_stage = s.id Set p.add_stage_order = s.order where p.add_stage_order > 0;
  154. Update zh_revise_pos_13 p Left Join zh_stage s ON p.add_stage = s.id Set p.add_stage_order = s.order where p.add_stage_order > 0;
  155. Update zh_revise_pos_14 p Left Join zh_stage s ON p.add_stage = s.id Set p.add_stage_order = s.order where p.add_stage_order > 0;
  156. Update zh_revise_pos_15 p Left Join zh_stage s ON p.add_stage = s.id Set p.add_stage_order = s.order where p.add_stage_order > 0;
  157. Update zh_revise_pos_16 p Left Join zh_stage s ON p.add_stage = s.id Set p.add_stage_order = s.order where p.add_stage_order > 0;
  158. Update zh_revise_pos_17 p Left Join zh_stage s ON p.add_stage = s.id Set p.add_stage_order = s.order where p.add_stage_order > 0;
  159. Update zh_revise_pos_18 p Left Join zh_stage s ON p.add_stage = s.id Set p.add_stage_order = s.order where p.add_stage_order > 0;
  160. Update zh_revise_pos_19 p Left Join zh_stage s ON p.add_stage = s.id Set p.add_stage_order = s.order where p.add_stage_order > 0;
  161. CREATE TABLE `zh_change_revise_log` (
  162. `id` int(11) NOT NULL AUTO_INCREMENT,
  163. `tid` int(11) NOT NULL,
  164. `cid` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '变更令id',
  165. `lid` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '插入的清单uuid',
  166. `pid` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '插入的计量单元uuid',
  167. `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '清单名称或计量单元编号',
  168. `create_time` datetime NOT NULL COMMENT '入库时间',
  169. PRIMARY KEY (`id`) USING BTREE
  170. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '变更新增部位记录表';
  171. ALTER TABLE `zh_change_pos`
  172. MODIFY COLUMN `add_stage` int(11) NOT NULL COMMENT '新增期id' AFTER `quantity`,
  173. ADD COLUMN `add_stage_order` tinyint(4) NOT NULL DEFAULT 0 COMMENT '新增期序号' AFTER `add_stage`;
  174. Update zh_change_pos p Left Join zh_stage s ON p.add_stage = s.id Set p.add_stage_order = s.order where p.add_stage_order > 0;
  175. ALTER TABLE `zh_tender`
  176. ADD COLUMN `bills_file` varchar(255) NOT NULL DEFAULT '' COMMENT '台账-清单文件' AFTER `has_rela`,
  177. ADD COLUMN `pos_file` varchar(255) NOT NULL DEFAULT '' COMMENT '台账-计量单元文件' AFTER `bills_file`;
  178. CREATE TABLE `zh_material_checklist` (
  179. `id` int(11) NOT NULL AUTO_INCREMENT,
  180. `tid` int(11) NOT NULL COMMENT '标段id',
  181. `mid` int(11) NOT NULL COMMENT '调差期id',
  182. `b_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '清单编号',
  183. `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '清单名称',
  184. `unit` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '单位',
  185. `unit_price` decimal(30, 8) NOT NULL COMMENT '单价',
  186. `quantity` decimal(30, 8) NOT NULL COMMENT '数量(工程量)',
  187. `total_price` decimal(30, 8) NOT NULL COMMENT '金额',
  188. `had_bills` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否已添加工料',
  189. PRIMARY KEY (`id`) USING BTREE
  190. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '默认清单设置功能';
  191. CREATE TABLE `zh_ledger_history` (
  192. `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  193. `pid` bigint(20) unsigned NOT NULL COMMENT '项目id',
  194. `tid` bigint(20) unsigned NOT NULL COMMENT '标段id',
  195. `rid` varchar(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '修订id',
  196. `rorder` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '修订序号',
  197. `cid` varchar(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '工程变更id',
  198. `in_time` datetime NOT NULL,
  199. `bills_file` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '项目节数据文件',
  200. `pos_file` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '计量单元数据文件',
  201. `valid` tinyint(4) UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否有效',
  202. PRIMARY KEY (`id`),
  203. KEY `idx_tid_valid_time` (`tid`,`valid`,`in_time`) USING BTREE
  204. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  205. ALTER TABLE `zh_ledger_revise`
  206. ADD COLUMN `his_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT '修订后,台账历史数据id' AFTER `content`,
  207. ADD COLUMN `pre_his_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT '修订前,台账历史数据id' AFTER `his_id`;
  208. ALTER TABLE `zh_tender`
  209. ADD COLUMN `his_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT '台账历史数据id' AFTER `s2b_dagl_limit`;
  210. ALTER TABLE `zh_stage`
  211. ADD COLUMN `his_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT '历史台账id' AFTER `tp_history`;
  212. ALTER TABLE `zh_stage_pay`
  213. ADD COLUMN `postil` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '本期批注' AFTER `start_stage_order`;
  214. ALTER TABLE `zh_tender` ADD `c_code_rules` TEXT NULL DEFAULT NULL COMMENT '变更立项及申请的编号规则json' AFTER `c_rule_first`;
  215. CREATE TABLE `zh_change_project` (
  216. `id` int(11) NOT NULL AUTO_INCREMENT,
  217. `tid` int(11) NOT NULL COMMENT '标段id',
  218. `uid` int(11) NOT NULL COMMENT '发起人',
  219. `code` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '立项书编号',
  220. `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '立项书名称',
  221. `in_time` datetime NOT NULL COMMENT '发起时间',
  222. `status` tinyint(2) NOT NULL COMMENT '立项状态',
  223. `times` tinyint(2) NOT NULL COMMENT '审批次数',
  224. `type` tinyint(1) NOT NULL COMMENT '立项书类型',
  225. `org_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '原设计图名称',
  226. `peg` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '桩号',
  227. `new_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '图号',
  228. `class` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '变更类别',
  229. `quality` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '变更性质',
  230. `org_price` decimal(30, 8) NULL DEFAULT NULL COMMENT '原工程造价(元)',
  231. `change_price` decimal(30, 8) NULL DEFAULT NULL COMMENT '预计变更造价(元)',
  232. `crease_price` decimal(30, 8) NULL DEFAULT NULL COMMENT '预计造价增减(元)',
  233. `reason` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT '变更原因',
  234. `content` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT '内容摘要',
  235. PRIMARY KEY (`id`) USING BTREE
  236. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '变更立项表';
  237. CREATE TABLE `zh_change_project_attachment` (
  238. `id` int(11) NOT NULL AUTO_INCREMENT,
  239. `tid` int(11) NOT NULL COMMENT '标段id',
  240. `cpid` int(11) NOT NULL COMMENT '立项id',
  241. `uid` int(11) NOT NULL COMMENT '上传者id',
  242. `filename` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '文件名称',
  243. `fileext` varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '文件后缀',
  244. `filesize` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '文件大小',
  245. `filepath` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '文件存储路径',
  246. `upload_time` datetime NOT NULL COMMENT '上传时间',
  247. `extra_upload` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否为审核通过后再次上传的文件,0为否',
  248. PRIMARY KEY (`id`) USING BTREE,
  249. INDEX `idx_cid`(`cpid`) USING BTREE
  250. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '变更立项附件表';
  251. CREATE TABLE `zh_change_project_audit` (
  252. `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  253. `tid` int(11) NOT NULL COMMENT '标段id',
  254. `cpid` int(11) NOT NULL COMMENT '立项id',
  255. `aid` int(11) NOT NULL COMMENT '审批人id',
  256. `order` int(11) NOT NULL COMMENT '审批顺序',
  257. `times` int(11) NOT NULL COMMENT '审批次数',
  258. `status` tinyint(1) NOT NULL COMMENT '审批状态',
  259. `begin_time` datetime NULL DEFAULT NULL COMMENT '开始审批时间',
  260. `end_time` datetime NULL DEFAULT NULL COMMENT '结束审批时间',
  261. `opinion` varchar(1000) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '审批意见',
  262. PRIMARY KEY (`id`) USING BTREE
  263. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '变更立项审批表';
  264. UPDATE `zh_ledger_revise` SET bills_file = replace(bills_file, '/revise', 'revise') WHERE not ISNULL(bills_file);
  265. UPDATE `zh_ledger_revise` SET pos_file = replace(pos_file, '/revise', 'revise') WHERE not ISNULL(pos_file);