update20221010.sql 38 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530
  1. ALTER TABLE `zh_stage_rela_bills`
  2. ADD COLUMN `qc_minus_qty` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '不计价' AFTER `qc_tp`;
  3. ALTER TABLE `zh_stage_rela_bills_final`
  4. ADD COLUMN `qc_minus_qty` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '不计价' AFTER `qc_tp`;
  5. ALTER TABLE `zh_stage_rela_pos`
  6. ADD COLUMN `qc_minus_qty` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '不计价' AFTER `qc_qty`;
  7. ALTER TABLE `zh_stage_rela_pos_final`
  8. ADD COLUMN `qc_minus_qty` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '不计价' AFTER `qc_qty`;
  9. ALTER TABLE `zh_stage_rela_im`
  10. ADD COLUMN `qc_minus_jl` decimal(24,8) NULL DEFAULT 0 COMMENT '不计价' AFTER `qc_jl`,
  11. ADD COLUMN `pre_qc_minus_jl` decimal(24,8) NULL DEFAULT 0 COMMENT '截止上期-不计价' AFTER `pre_qc_jl`,
  12. ADD COLUMN `end_qc_minus_jl` decimal(24,8) NULL DEFAULT 0 COMMENT '截止本期-不计价' AFTER `end_qc_jl`;
  13. ALTER TABLE `zh_stage_rela_im_bills`
  14. ADD COLUMN `qc_minus_jl` decimal(24,8) NULL DEFAULT 0 COMMENT '不计价' AFTER `qc_jl`,
  15. ADD COLUMN `pre_qc_minus_jl` decimal(24,8) NULL DEFAULT 0 COMMENT '截止上期-不计价' AFTER `pre_qc_jl`,
  16. ADD COLUMN `end_qc_minus_jl` decimal(24,8) NULL DEFAULT 0 COMMENT '截止本期-不计价' AFTER `end_qc_jl`;
  17. ALTER TABLE `zh_material` ADD `is_stage_self` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '多期共用单价还是独立单价,默认是共用0' AFTER `is_new`;
  18. ALTER TABLE `zh_material_list` ADD `ms_id` INT NULL DEFAULT NULL COMMENT '调差多期单独计价期id' AFTER `mb_id`;
  19. CREATE TABLE `zh_material_stage` (
  20. `id` int(11) NOT NULL AUTO_INCREMENT,
  21. `tid` int(11) NOT NULL COMMENT '标段id',
  22. `mid` int(11) NOT NULL COMMENT '调差id',
  23. `sid` int(11) NOT NULL COMMENT '计量期id',
  24. `order` tinyint(4) NOT NULL COMMENT '计量期期数',
  25. `m_tp` decimal(30, 8) NULL DEFAULT NULL COMMENT '本期金额',
  26. `m_tax_tp` decimal(30, 8) NULL DEFAULT NULL COMMENT '材料含税总金额',
  27. PRIMARY KEY (`id`) USING BTREE,
  28. INDEX `tid`(`tid`) USING BTREE,
  29. INDEX `mid`(`mid`) USING BTREE
  30. ) ENGINE = InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  31. CREATE TABLE `zh_material_stage_bills` (
  32. `id` int(11) NOT NULL AUTO_INCREMENT,
  33. `tid` int(11) NOT NULL COMMENT '标段id',
  34. `mid` int(11) NOT NULL COMMENT '调差id',
  35. `ms_id` int(11) NOT NULL COMMENT '调差多期单独计价期id',
  36. `mb_id` int(11) NOT NULL COMMENT '工料id',
  37. `quantity` decimal(30, 8) NULL DEFAULT NULL COMMENT '本期应耗数量',
  38. `msg_tp` decimal(30, 8) NULL DEFAULT NULL COMMENT '本期信息价单价',
  39. `msg_times` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '本期信息价时间',
  40. `msg_spread` decimal(30, 8) NULL DEFAULT NULL COMMENT '本期信息价价差',
  41. `m_spread` decimal(30, 8) NULL DEFAULT NULL COMMENT '本期材料调差有效价差',
  42. `m_tp` decimal(30, 8) NULL DEFAULT NULL COMMENT '本期金额',
  43. `m_tax_tp` decimal(30, 8) NULL DEFAULT NULL COMMENT '调差金额(材料税)',
  44. `is_summary` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否汇总',
  45. `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '备注',
  46. PRIMARY KEY (`id`) USING BTREE,
  47. INDEX `tid`(`tid`) USING BTREE,
  48. INDEX `mid`(`mid`) USING BTREE
  49. ) ENGINE = InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  50. ALTER TABLE `zh_project_account`
  51. ADD COLUMN `invalid_time` varchar(50) NOT NULL DEFAULT '' AFTER `wx_name`;
  52. ALTER TABLE `zh_valuation_list` ADD `glj_lib_id` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '(0号台账模式)zh_glj_lib_list id列表,逗号分隔' AFTER `chapter_id`;
  53. ALTER TABLE `zh_valuation_list` ADD `list_glj_lib_id` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '(工程量清单模式)zh_glj_lib_list id列表,逗号分隔' AFTER `list_chapter_id`;
  54. CREATE TABLE `zh_revise_price` (
  55. `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  56. `pid` bigint(20) unsigned NOT NULL COMMENT '项目id',
  57. `tid` bigint(20) unsigned NOT NULL COMMENT '标段id',
  58. `rid` varchar(36) COLLATE utf8_unicode_ci NOT NULL COMMENT '台账修订id',
  59. `order` int(11) unsigned NOT NULL COMMENT '排序',
  60. `b_code` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '清单编号',
  61. `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '名称',
  62. `unit` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '单位',
  63. `org_price` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '旧单价',
  64. `new_price` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '变更单价',
  65. `memo` varchar(1000) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '备注',
  66. `valid` tinyint(4) unsigned NOT NULL DEFAULT '1' COMMENT '是否有效',
  67. `use_stage` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '使用期',
  68. `use_stage_order` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '使用期序号',
  69. PRIMARY KEY (`id`),
  70. KEY `idx_rid` (`rid`) USING BTREE,
  71. KEY `idx_tid_valid_stage` (`rid`,`valid`,`use_stage`) USING BTREE
  72. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='台账修订-单价调整';
  73. CREATE TABLE `zh_stage_bills_pc` (
  74. `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  75. `tid` int(11) unsigned NOT NULL COMMENT '标段id',
  76. `sid` int(11) UNSIGNED NOT NULL COMMENT '期id',
  77. `sorder` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '第几期',
  78. `lid` varchar(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '项目节id',
  79. `org_price` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '原单价',
  80. `unit_price` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期单价',
  81. `contract_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(合同)',
  82. `qc_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(变更)',
  83. `pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差',
  84. `positive_qc_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(正变更)',
  85. `negative_qc_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(负变更)',
  86. PRIMARY KEY (`id`),
  87. KEY `idx_sid` (`sid`) USING BTREE
  88. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='期-补差数据';
  89. ALTER TABLE `zh_stage_bills_final_0`
  90. ADD COLUMN `unit_price` decimal(24,8) UNSIGNED NOT NULL DEFAULT 0 COMMENT '本期单价' AFTER `contract_expr`,
  91. ADD COLUMN `contract_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(合同)' AFTER `used`,
  92. ADD COLUMN `qc_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(变更)' AFTER `contract_pc_tp`,
  93. ADD COLUMN `pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差' AFTER `qc_pc_tp`;
  94. ALTER TABLE `zh_stage_bills_final_1`
  95. ADD COLUMN `unit_price` decimal(24,8) UNSIGNED NOT NULL DEFAULT 0 COMMENT '本期单价' AFTER `contract_expr`,
  96. ADD COLUMN `contract_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(合同)' AFTER `used`,
  97. ADD COLUMN `qc_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(变更)' AFTER `contract_pc_tp`,
  98. ADD COLUMN `pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差' AFTER `qc_pc_tp`;
  99. ALTER TABLE `zh_stage_bills_final_2`
  100. ADD COLUMN `unit_price` decimal(24,8) UNSIGNED NOT NULL DEFAULT 0 COMMENT '本期单价' AFTER `contract_expr`,
  101. ADD COLUMN `contract_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(合同)' AFTER `used`,
  102. ADD COLUMN `qc_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(变更)' AFTER `contract_pc_tp`,
  103. ADD COLUMN `pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差' AFTER `qc_pc_tp`;
  104. ALTER TABLE `zh_stage_bills_final_3`
  105. ADD COLUMN `unit_price` decimal(24,8) UNSIGNED NOT NULL DEFAULT 0 COMMENT '本期单价' AFTER `contract_expr`,
  106. ADD COLUMN `contract_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(合同)' AFTER `used`,
  107. ADD COLUMN `qc_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(变更)' AFTER `contract_pc_tp`,
  108. ADD COLUMN `pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差' AFTER `qc_pc_tp`;
  109. ALTER TABLE `zh_stage_bills_final_4`
  110. ADD COLUMN `unit_price` decimal(24,8) UNSIGNED NOT NULL DEFAULT 0 COMMENT '本期单价' AFTER `contract_expr`,
  111. ADD COLUMN `contract_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(合同)' AFTER `used`,
  112. ADD COLUMN `qc_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(变更)' AFTER `contract_pc_tp`,
  113. ADD COLUMN `pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差' AFTER `qc_pc_tp`;
  114. ALTER TABLE `zh_stage_bills_final_5`
  115. ADD COLUMN `unit_price` decimal(24,8) UNSIGNED NOT NULL DEFAULT 0 COMMENT '本期单价' AFTER `contract_expr`,
  116. ADD COLUMN `contract_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(合同)' AFTER `used`,
  117. ADD COLUMN `qc_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(变更)' AFTER `contract_pc_tp`,
  118. ADD COLUMN `pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差' AFTER `qc_pc_tp`;
  119. ALTER TABLE `zh_stage_bills_final_6`
  120. ADD COLUMN `unit_price` decimal(24,8) UNSIGNED NOT NULL DEFAULT 0 COMMENT '本期单价' AFTER `contract_expr`,
  121. ADD COLUMN `contract_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(合同)' AFTER `used`,
  122. ADD COLUMN `qc_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(变更)' AFTER `contract_pc_tp`,
  123. ADD COLUMN `pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差' AFTER `qc_pc_tp`;
  124. ALTER TABLE `zh_stage_bills_final_7`
  125. ADD COLUMN `unit_price` decimal(24,8) UNSIGNED NOT NULL DEFAULT 0 COMMENT '本期单价' AFTER `contract_expr`,
  126. ADD COLUMN `contract_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(合同)' AFTER `used`,
  127. ADD COLUMN `qc_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(变更)' AFTER `contract_pc_tp`,
  128. ADD COLUMN `pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差' AFTER `qc_pc_tp`;
  129. ALTER TABLE `zh_stage_bills_final_8`
  130. ADD COLUMN `unit_price` decimal(24,8) UNSIGNED NOT NULL DEFAULT 0 COMMENT '本期单价' AFTER `contract_expr`,
  131. ADD COLUMN `contract_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(合同)' AFTER `used`,
  132. ADD COLUMN `qc_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(变更)' AFTER `contract_pc_tp`,
  133. ADD COLUMN `pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差' AFTER `qc_pc_tp`;
  134. ALTER TABLE `zh_stage_bills_final_9`
  135. ADD COLUMN `unit_price` decimal(24,8) UNSIGNED NOT NULL DEFAULT 0 COMMENT '本期单价' AFTER `contract_expr`,
  136. ADD COLUMN `contract_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(合同)' AFTER `used`,
  137. ADD COLUMN `qc_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(变更)' AFTER `contract_pc_tp`,
  138. ADD COLUMN `pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差' AFTER `qc_pc_tp`;
  139. ALTER TABLE `zh_stage_pos_final_0`
  140. ADD COLUMN `contract_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(合同)' AFTER `contract_expr`,
  141. ADD COLUMN `qc_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(变更)' AFTER `contract_pc_tp`,
  142. ADD COLUMN `pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差' AFTER `qc_pc_tp`;
  143. ALTER TABLE `zh_stage_pos_final_1`
  144. ADD COLUMN `contract_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(合同)' AFTER `contract_expr`,
  145. ADD COLUMN `qc_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(变更)' AFTER `contract_pc_tp`,
  146. ADD COLUMN `pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差' AFTER `qc_pc_tp`;
  147. ALTER TABLE `zh_stage_pos_final_2`
  148. ADD COLUMN `contract_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(合同)' AFTER `contract_expr`,
  149. ADD COLUMN `qc_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(变更)' AFTER `contract_pc_tp`,
  150. ADD COLUMN `pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差' AFTER `qc_pc_tp`;
  151. ALTER TABLE `zh_stage_pos_final_3`
  152. ADD COLUMN `contract_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(合同)' AFTER `contract_expr`,
  153. ADD COLUMN `qc_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(变更)' AFTER `contract_pc_tp`,
  154. ADD COLUMN `pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差' AFTER `qc_pc_tp`;
  155. ALTER TABLE `zh_stage_pos_final_4`
  156. ADD COLUMN `contract_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(合同)' AFTER `contract_expr`,
  157. ADD COLUMN `qc_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(变更)' AFTER `contract_pc_tp`,
  158. ADD COLUMN `pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差' AFTER `qc_pc_tp`;
  159. ALTER TABLE `zh_stage_pos_final_5`
  160. ADD COLUMN `contract_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(合同)' AFTER `contract_expr`,
  161. ADD COLUMN `qc_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(变更)' AFTER `contract_pc_tp`,
  162. ADD COLUMN `pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差' AFTER `qc_pc_tp`;
  163. ALTER TABLE `zh_stage_pos_final_6`
  164. ADD COLUMN `contract_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(合同)' AFTER `contract_expr`,
  165. ADD COLUMN `qc_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(变更)' AFTER `contract_pc_tp`,
  166. ADD COLUMN `pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差' AFTER `qc_pc_tp`;
  167. ALTER TABLE `zh_stage_pos_final_7`
  168. ADD COLUMN `contract_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(合同)' AFTER `contract_expr`,
  169. ADD COLUMN `qc_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(变更)' AFTER `contract_pc_tp`,
  170. ADD COLUMN `pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差' AFTER `qc_pc_tp`;
  171. ALTER TABLE `zh_stage_pos_final_8`
  172. ADD COLUMN `contract_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(合同)' AFTER `contract_expr`,
  173. ADD COLUMN `qc_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(变更)' AFTER `contract_pc_tp`,
  174. ADD COLUMN `pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差' AFTER `qc_pc_tp`;
  175. ALTER TABLE `zh_stage_pos_final_9`
  176. ADD COLUMN `contract_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(合同)' AFTER `contract_expr`,
  177. ADD COLUMN `qc_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(变更)' AFTER `contract_pc_tp`,
  178. ADD COLUMN `pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差' AFTER `qc_pc_tp`;
  179. ALTER TABLE `zh_stage_pos_final_10`
  180. ADD COLUMN `contract_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(合同)' AFTER `contract_expr`,
  181. ADD COLUMN `qc_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(变更)' AFTER `contract_pc_tp`,
  182. ADD COLUMN `pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差' AFTER `qc_pc_tp`;
  183. ALTER TABLE `zh_stage_pos_final_11`
  184. ADD COLUMN `contract_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(合同)' AFTER `contract_expr`,
  185. ADD COLUMN `qc_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(变更)' AFTER `contract_pc_tp`,
  186. ADD COLUMN `pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差' AFTER `qc_pc_tp`;
  187. ALTER TABLE `zh_stage_pos_final_12`
  188. ADD COLUMN `contract_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(合同)' AFTER `contract_expr`,
  189. ADD COLUMN `qc_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(变更)' AFTER `contract_pc_tp`,
  190. ADD COLUMN `pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差' AFTER `qc_pc_tp`;
  191. ALTER TABLE `zh_stage_pos_final_13`
  192. ADD COLUMN `contract_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(合同)' AFTER `contract_expr`,
  193. ADD COLUMN `qc_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(变更)' AFTER `contract_pc_tp`,
  194. ADD COLUMN `pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差' AFTER `qc_pc_tp`;
  195. ALTER TABLE `zh_stage_pos_final_14`
  196. ADD COLUMN `contract_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(合同)' AFTER `contract_expr`,
  197. ADD COLUMN `qc_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(变更)' AFTER `contract_pc_tp`,
  198. ADD COLUMN `pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差' AFTER `qc_pc_tp`;
  199. ALTER TABLE `zh_stage_pos_final_15`
  200. ADD COLUMN `contract_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(合同)' AFTER `contract_expr`,
  201. ADD COLUMN `qc_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(变更)' AFTER `contract_pc_tp`,
  202. ADD COLUMN `pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差' AFTER `qc_pc_tp`;
  203. ALTER TABLE `zh_stage_pos_final_16`
  204. ADD COLUMN `contract_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(合同)' AFTER `contract_expr`,
  205. ADD COLUMN `qc_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(变更)' AFTER `contract_pc_tp`,
  206. ADD COLUMN `pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差' AFTER `qc_pc_tp`;
  207. ALTER TABLE `zh_stage_pos_final_17`
  208. ADD COLUMN `contract_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(合同)' AFTER `contract_expr`,
  209. ADD COLUMN `qc_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(变更)' AFTER `contract_pc_tp`,
  210. ADD COLUMN `pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差' AFTER `qc_pc_tp`;
  211. ALTER TABLE `zh_stage_pos_final_18`
  212. ADD COLUMN `contract_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(合同)' AFTER `contract_expr`,
  213. ADD COLUMN `qc_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(变更)' AFTER `contract_pc_tp`,
  214. ADD COLUMN `pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差' AFTER `qc_pc_tp`;
  215. ALTER TABLE `zh_stage_pos_final_19`
  216. ADD COLUMN `contract_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(合同)' AFTER `contract_expr`,
  217. ADD COLUMN `qc_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(变更)' AFTER `contract_pc_tp`,
  218. ADD COLUMN `pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差' AFTER `qc_pc_tp`;
  219. Update zh_stage_bills_final_0 sp LEFT JOIN zh_ledger_0 p on sp.lid = p.id Set sp.unit_price = IFNULL(p.unit_price, 0);
  220. Update zh_stage_bills_final_1 sp LEFT JOIN zh_ledger_1 p on sp.lid = p.id Set sp.unit_price = IFNULL(p.unit_price, 0);
  221. Update zh_stage_bills_final_2 sp LEFT JOIN zh_ledger_2 p on sp.lid = p.id Set sp.unit_price = IFNULL(p.unit_price, 0);
  222. Update zh_stage_bills_final_3 sp LEFT JOIN zh_ledger_3 p on sp.lid = p.id Set sp.unit_price = IFNULL(p.unit_price, 0);
  223. Update zh_stage_bills_final_4 sp LEFT JOIN zh_ledger_4 p on sp.lid = p.id Set sp.unit_price = IFNULL(p.unit_price, 0);
  224. Update zh_stage_bills_final_5 sp LEFT JOIN zh_ledger_5 p on sp.lid = p.id Set sp.unit_price = IFNULL(p.unit_price, 0);
  225. Update zh_stage_bills_final_6 sp LEFT JOIN zh_ledger_6 p on sp.lid = p.id Set sp.unit_price = IFNULL(p.unit_price, 0);
  226. Update zh_stage_bills_final_7 sp LEFT JOIN zh_ledger_7 p on sp.lid = p.id Set sp.unit_price = IFNULL(p.unit_price, 0);
  227. Update zh_stage_bills_final_8 sp LEFT JOIN zh_ledger_8 p on sp.lid = p.id Set sp.unit_price = IFNULL(p.unit_price, 0);
  228. Update zh_stage_bills_final_9 sp LEFT JOIN zh_ledger_9 p on sp.lid = p.id Set sp.unit_price = IFNULL(p.unit_price, 0);
  229. ALTER TABLE `zh_stage`
  230. ADD COLUMN `contract_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(合同)' AFTER `qc_tp`,
  231. ADD COLUMN `qc_pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差(变更)' AFTER `contract_pc_tp`,
  232. ADD COLUMN `pc_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '本期补差' AFTER `qc_pc_tp`;
  233. ALTER TABLE `zh_ledger_revise`
  234. ADD COLUMN `sum` varchar(255) NOT NULL DEFAULT '' COMMENT 'sum统计数据' AFTER `pre_his_id`;
  235. ALTER TABLE `zh_project` ADD `fun_set` VARCHAR(1000) NULL DEFAULT NULL COMMENT '项目设置页内容json' AFTER `map_json`;
  236. ALTER TABLE `zh_change`
  237. ADD COLUMN `positive_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '正变更金额' AFTER `order_by`,
  238. ADD COLUMN `negative_tp` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '负变更金额' AFTER `positive_tp`;
  239. ALTER TABLE `zh_stage_bills_0`
  240. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  241. ADD COLUMN `positive_qc_tp` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`,
  242. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_tp`,
  243. ADD COLUMN `negative_qc_tp` decimal(24,8) NOT NULL DEFAULT 0 AFTER `negative_qc_qty`;
  244. ALTER TABLE `zh_stage_bills_1`
  245. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  246. ADD COLUMN `positive_qc_tp` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`,
  247. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_tp`,
  248. ADD COLUMN `negative_qc_tp` decimal(24,8) NOT NULL DEFAULT 0 AFTER `negative_qc_qty`;
  249. ALTER TABLE `zh_stage_bills_2`
  250. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  251. ADD COLUMN `positive_qc_tp` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`,
  252. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_tp`,
  253. ADD COLUMN `negative_qc_tp` decimal(24,8) NOT NULL DEFAULT 0 AFTER `negative_qc_qty`;
  254. ALTER TABLE `zh_stage_bills_3`
  255. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  256. ADD COLUMN `positive_qc_tp` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`,
  257. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_tp`,
  258. ADD COLUMN `negative_qc_tp` decimal(24,8) NOT NULL DEFAULT 0 AFTER `negative_qc_qty`;
  259. ALTER TABLE `zh_stage_bills_4`
  260. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  261. ADD COLUMN `positive_qc_tp` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`,
  262. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_tp`,
  263. ADD COLUMN `negative_qc_tp` decimal(24,8) NOT NULL DEFAULT 0 AFTER `negative_qc_qty`;
  264. ALTER TABLE `zh_stage_bills_5`
  265. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  266. ADD COLUMN `positive_qc_tp` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`,
  267. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_tp`,
  268. ADD COLUMN `negative_qc_tp` decimal(24,8) NOT NULL DEFAULT 0 AFTER `negative_qc_qty`;
  269. ALTER TABLE `zh_stage_bills_6`
  270. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  271. ADD COLUMN `positive_qc_tp` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`,
  272. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_tp`,
  273. ADD COLUMN `negative_qc_tp` decimal(24,8) NOT NULL DEFAULT 0 AFTER `negative_qc_qty`;
  274. ALTER TABLE `zh_stage_bills_7`
  275. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  276. ADD COLUMN `positive_qc_tp` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`,
  277. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_tp`,
  278. ADD COLUMN `negative_qc_tp` decimal(24,8) NOT NULL DEFAULT 0 AFTER `negative_qc_qty`;
  279. ALTER TABLE `zh_stage_bills_8`
  280. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  281. ADD COLUMN `positive_qc_tp` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`,
  282. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_tp`,
  283. ADD COLUMN `negative_qc_tp` decimal(24,8) NOT NULL DEFAULT 0 AFTER `negative_qc_qty`;
  284. ALTER TABLE `zh_stage_bills_9`
  285. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  286. ADD COLUMN `positive_qc_tp` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`,
  287. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_tp`,
  288. ADD COLUMN `negative_qc_tp` decimal(24,8) NOT NULL DEFAULT 0 AFTER `negative_qc_qty`;
  289. ALTER TABLE `zh_stage_bills_final_0`
  290. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  291. ADD COLUMN `positive_qc_tp` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`,
  292. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_tp`,
  293. ADD COLUMN `negative_qc_tp` decimal(24,8) NOT NULL DEFAULT 0 AFTER `negative_qc_qty`;
  294. ALTER TABLE `zh_stage_bills_final_1`
  295. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  296. ADD COLUMN `positive_qc_tp` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`,
  297. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_tp`,
  298. ADD COLUMN `negative_qc_tp` decimal(24,8) NOT NULL DEFAULT 0 AFTER `negative_qc_qty`;
  299. ALTER TABLE `zh_stage_bills_final_2`
  300. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  301. ADD COLUMN `positive_qc_tp` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`,
  302. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_tp`,
  303. ADD COLUMN `negative_qc_tp` decimal(24,8) NOT NULL DEFAULT 0 AFTER `negative_qc_qty`;
  304. ALTER TABLE `zh_stage_bills_final_3`
  305. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  306. ADD COLUMN `positive_qc_tp` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`,
  307. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_tp`,
  308. ADD COLUMN `negative_qc_tp` decimal(24,8) NOT NULL DEFAULT 0 AFTER `negative_qc_qty`;
  309. ALTER TABLE `zh_stage_bills_final_4`
  310. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  311. ADD COLUMN `positive_qc_tp` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`,
  312. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_tp`,
  313. ADD COLUMN `negative_qc_tp` decimal(24,8) NOT NULL DEFAULT 0 AFTER `negative_qc_qty`;
  314. ALTER TABLE `zh_stage_bills_final_5`
  315. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  316. ADD COLUMN `positive_qc_tp` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`,
  317. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_tp`,
  318. ADD COLUMN `negative_qc_tp` decimal(24,8) NOT NULL DEFAULT 0 AFTER `negative_qc_qty`;
  319. ALTER TABLE `zh_stage_bills_final_6`
  320. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  321. ADD COLUMN `positive_qc_tp` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`,
  322. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_tp`,
  323. ADD COLUMN `negative_qc_tp` decimal(24,8) NOT NULL DEFAULT 0 AFTER `negative_qc_qty`;
  324. ALTER TABLE `zh_stage_bills_final_7`
  325. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  326. ADD COLUMN `positive_qc_tp` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`,
  327. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_tp`,
  328. ADD COLUMN `negative_qc_tp` decimal(24,8) NOT NULL DEFAULT 0 AFTER `negative_qc_qty`;
  329. ALTER TABLE `zh_stage_bills_final_8`
  330. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  331. ADD COLUMN `positive_qc_tp` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`,
  332. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_tp`,
  333. ADD COLUMN `negative_qc_tp` decimal(24,8) NOT NULL DEFAULT 0 AFTER `negative_qc_qty`;
  334. ALTER TABLE `zh_stage_bills_final_9`
  335. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  336. ADD COLUMN `positive_qc_tp` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`,
  337. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_tp`,
  338. ADD COLUMN `negative_qc_tp` decimal(24,8) NOT NULL DEFAULT 0 AFTER `negative_qc_qty`;
  339. ALTER TABLE `zh_stage_pos_0`
  340. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  341. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`;
  342. ALTER TABLE `zh_stage_pos_1`
  343. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  344. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`;
  345. ALTER TABLE `zh_stage_pos_2`
  346. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  347. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`;
  348. ALTER TABLE `zh_stage_pos_3`
  349. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  350. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`;
  351. ALTER TABLE `zh_stage_pos_4`
  352. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  353. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`;
  354. ALTER TABLE `zh_stage_pos_5`
  355. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  356. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`;
  357. ALTER TABLE `zh_stage_pos_6`
  358. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  359. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`;
  360. ALTER TABLE `zh_stage_pos_7`
  361. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  362. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`;
  363. ALTER TABLE `zh_stage_pos_8`
  364. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  365. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`;
  366. ALTER TABLE `zh_stage_pos_9`
  367. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  368. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`;
  369. ALTER TABLE `zh_stage_pos_10`
  370. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  371. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`;
  372. ALTER TABLE `zh_stage_pos_11`
  373. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  374. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`;
  375. ALTER TABLE `zh_stage_pos_12`
  376. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  377. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`;
  378. ALTER TABLE `zh_stage_pos_13`
  379. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  380. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`;
  381. ALTER TABLE `zh_stage_pos_14`
  382. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  383. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`;
  384. ALTER TABLE `zh_stage_pos_15`
  385. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  386. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`;
  387. ALTER TABLE `zh_stage_pos_16`
  388. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  389. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`;
  390. ALTER TABLE `zh_stage_pos_17`
  391. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  392. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`;
  393. ALTER TABLE `zh_stage_pos_18`
  394. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  395. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`;
  396. ALTER TABLE `zh_stage_pos_19`
  397. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  398. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`;
  399. ALTER TABLE `zh_stage_pos_final_0`
  400. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  401. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`;
  402. ALTER TABLE `zh_stage_pos_final_1`
  403. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  404. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`;
  405. ALTER TABLE `zh_stage_pos_final_2`
  406. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  407. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`;
  408. ALTER TABLE `zh_stage_pos_final_3`
  409. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  410. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`;
  411. ALTER TABLE `zh_stage_pos_final_4`
  412. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  413. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`;
  414. ALTER TABLE `zh_stage_pos_final_5`
  415. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  416. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`;
  417. ALTER TABLE `zh_stage_pos_final_6`
  418. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  419. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`;
  420. ALTER TABLE `zh_stage_pos_final_7`
  421. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  422. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`;
  423. ALTER TABLE `zh_stage_pos_final_8`
  424. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  425. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`;
  426. ALTER TABLE `zh_stage_pos_final_9`
  427. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  428. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`;
  429. ALTER TABLE `zh_stage_pos_final_10`
  430. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  431. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`;
  432. ALTER TABLE `zh_stage_pos_final_11`
  433. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  434. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`;
  435. ALTER TABLE `zh_stage_pos_final_12`
  436. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  437. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`;
  438. ALTER TABLE `zh_stage_pos_final_13`
  439. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  440. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`;
  441. ALTER TABLE `zh_stage_pos_final_14`
  442. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  443. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`;
  444. ALTER TABLE `zh_stage_pos_final_15`
  445. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  446. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`;
  447. ALTER TABLE `zh_stage_pos_final_16`
  448. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  449. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`;
  450. ALTER TABLE `zh_stage_pos_final_17`
  451. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  452. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`;
  453. ALTER TABLE `zh_stage_pos_final_18`
  454. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  455. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`;
  456. ALTER TABLE `zh_stage_pos_final_19`
  457. ADD COLUMN `positive_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `qc_minus_qty`,
  458. ADD COLUMN `negative_qc_qty` decimal(24,8) NOT NULL DEFAULT 0 AFTER `positive_qc_qty`;
  459. ALTER TABLE `zh_stage`
  460. ADD COLUMN `positive_qc_tp` decimal(24,8) NULL DEFAULT 0 COMMENT '本期-正-变更金额' AFTER `his_id`,
  461. ADD COLUMN `pre_positive_qc_tp` decimal(24,8) NULL DEFAULT 0 COMMENT '截止上期-正-变更金额' AFTER `positive_qc_tp`,
  462. ADD COLUMN `positive_qc_pc_tp` decimal(24,8) NULL DEFAULT 0 COMMENT '本期-正-变更补差金额' AFTER `pre_positive_qc_tp`,
  463. ADD COLUMN `negative_qc_tp` decimal(24,8) NULL DEFAULT 0 COMMENT '本期-负-变更金额' AFTER `pre_positive_qc_tp`,
  464. ADD COLUMN `pre_negative_qc_tp` decimal(24,8) NULL DEFAULT 0 COMMENT '截止上期-负-变更金额' AFTER `negative_qc_tp`,
  465. ADD COLUMN `negative_qc_pc_tp` decimal(24,8) NULL DEFAULT 0 COMMENT '本期-负-变更补差金额' AFTER `pre_negative_qc_tp`;
  466. ALTER TABLE `zh_stage_change`
  467. ADD COLUMN `unit_price` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '清单单价' AFTER `no_value`;
  468. ALTER TABLE `zh_stage_change_final`
  469. ADD COLUMN `unit_price` decimal(24,8) NOT NULL DEFAULT 0 COMMENT '清单单价' AFTER `no_value`;
  470. Update `zh_stage_change` sc LEFT JOIN zh_change_audit_list cal ON sc.cbid = cal.id Set sc.unit_price = IFNULL(cal.unit_price, 0);
  471. Update `zh_stage_change_final` sc LEFT JOIN zh_change_audit_list cal ON sc.cbid = cal.id Set sc.unit_price = IFNULL(cal.unit_price, 0);
  472. CREATE TABLE `zh_glj_lib` (
  473. `id` int(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id',
  474. `list_id` int(8) NOT NULL COMMENT '工料机列表id',
  475. `glj_id` int(8) NOT NULL COMMENT '导入的工料机id',
  476. `glj_pid` int(8) NOT NULL COMMENT '父节点id',
  477. `level` tinyint(2) NOT NULL DEFAULT '1' COMMENT '目录层级',
  478. `is_leaf` tinyint(1) NOT NULL,
  479. `full_path` text NOT NULL,
  480. `order` tinyint(5) NOT NULL,
  481. `code` varchar(30) NOT NULL DEFAULT '' COMMENT '编号',
  482. `name` varchar(255) NOT NULL DEFAULT '' COMMENT '名称',
  483. `unit` varchar(18) NOT NULL DEFAULT '' COMMENT '单位',
  484. `rise_range` decimal(24,8) NOT NULL DEFAULT '0.00000000',
  485. `fall_range` decimal(24,8) NOT NULL DEFAULT '0.00000000',
  486. `spec` varchar(50) NOT NULL DEFAULT '' COMMENT '规格',
  487. `type` int(8) unsigned NOT NULL DEFAULT '0' COMMENT '工料分类',
  488. `memo` varchar(255) NOT NULL DEFAULT '' COMMENT '备注',
  489. PRIMARY KEY (`id`),
  490. KEY `idx_pid` (`glj_pid`) USING BTREE,
  491. KEY `idx_list_id` (`list_id`) USING BTREE,
  492. KEY `idx_level` (`level`) USING BTREE,
  493. KEY `idx_chapter_id` (`glj_id`) USING BTREE
  494. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='工料机数据表';
  495. CREATE TABLE `zh_glj_lib_list` (
  496. `id` int(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id',
  497. `name` varchar(60) NOT NULL COMMENT '项目章节名称',
  498. `remark` varchar(60) DEFAULT '' COMMENT '备注',
  499. `create_time` int(10) NOT NULL COMMENT '创建时间',
  500. PRIMARY KEY (`id`)
  501. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='工料机列表数据表';
  502. INSERT INTO `calculation`.`zh_permission` (`id`, `name`, `controller`, `action`, `pid`, `icon_class`, `create_time`, `isshow`) VALUES ('73', '工料机库', 'glj-lib', 'all', '44', '', '13', '1');