update.sql 90 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385
  1. -- 请按如下分类提交sql!!!
  2. -- Version V3.5.50.xxxx
  3. -- uat 2025-xx-xx
  4. -- prod 2025-xx-xx
  5. ------------------------------------
  6. -- 表结构
  7. ------------------------------------
  8. ALTER TABLE `zh_construction_unit`
  9. MODIFY COLUMN `sign_path` mediumtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT '签章图片地址,以逗号分隔' AFTER `basic`,
  10. ADD COLUMN `sign_permission` tinyint(1) NULL DEFAULT 1 COMMENT '授权所有人使用单位章' AFTER `sign_path`;
  11. ALTER TABLE `zh_project_account`
  12. ADD COLUMN `unit_sign_path` mediumtext NULL COMMENT '单位章图片地址' AFTER `stamp_path`;
  13. ALTER TABLE `zh_filing`
  14. ADD COLUMN `file_company` varchar(100) NOT NULL DEFAULT '' COMMENT '归档单位' AFTER `tips`;
  15. ALTER TABLE `zh_filing_template`
  16. ADD COLUMN `file_company` varchar(100) NOT NULL DEFAULT '' COMMENT '归档单位' AFTER `tips`;
  17. ALTER TABLE `zh_sub_project_permission`
  18. ADD COLUMN `last_time` timestamp NULL DEFAULT NULL COMMENT '最近使用时间' AFTER `tp_cache_time`;
  19. ALTER TABLE `zh_tender_info`
  20. ADD COLUMN `calc_type` varchar(20) NOT NULL DEFAULT 'up' COMMENT '计价类型(单价up,总价tp)' AFTER `s_type`;
  21. CREATE TABLE `zh_multi_limit` (
  22. `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  23. `pid` int(11) UNSIGNED NOT NULL COMMENT '项目id',
  24. `limit_id` varchar(36) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'uuid',
  25. `user_id` int(11) NOT NULL COMMENT '创建人',
  26. `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  27. `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后更新时间',
  28. `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '名称',
  29. `limit` tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '限制计量',
  30. `lower` tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '计量下限',
  31. `upper` tinyint(4) UNSIGNED NOT NULL DEFAULT 100 COMMENT '计量上限',
  32. `condition` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT '判断条件',
  33. `hint` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '提示文本',
  34. PRIMARY KEY (`id`) USING BTREE
  35. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;
  36. ALTER TABLE `zh_tender`
  37. ADD COLUMN `s2b_multi_check` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '联动计量-检查计量' AFTER `map_pic`,
  38. ADD COLUMN `s2b_multi_limit` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '联动计量-限制上报' AFTER `s2b_multi_check`;
  39. ALTER TABLE `zh_ledger_extra_0`
  40. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  41. ALTER TABLE `zh_ledger_extra_1`
  42. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  43. ALTER TABLE `zh_ledger_extra_2`
  44. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  45. ALTER TABLE `zh_ledger_extra_3`
  46. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  47. ALTER TABLE `zh_ledger_extra_4`
  48. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  49. ALTER TABLE `zh_ledger_extra_5`
  50. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  51. ALTER TABLE `zh_ledger_extra_6`
  52. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  53. ALTER TABLE `zh_ledger_extra_7`
  54. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  55. ALTER TABLE `zh_ledger_extra_8`
  56. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  57. ALTER TABLE `zh_ledger_extra_9`
  58. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  59. ALTER TABLE `zh_ledger_extra_10`
  60. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  61. ALTER TABLE `zh_ledger_extra_11`
  62. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  63. ALTER TABLE `zh_ledger_extra_12`
  64. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  65. ALTER TABLE `zh_ledger_extra_13`
  66. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  67. ALTER TABLE `zh_ledger_extra_14`
  68. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  69. ALTER TABLE `zh_ledger_extra_15`
  70. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  71. ALTER TABLE `zh_ledger_extra_16`
  72. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  73. ALTER TABLE `zh_ledger_extra_17`
  74. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  75. ALTER TABLE `zh_ledger_extra_18`
  76. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  77. ALTER TABLE `zh_ledger_extra_19`
  78. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  79. ALTER TABLE `zh_ledger_extra_20`
  80. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  81. ALTER TABLE `zh_ledger_extra_21`
  82. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  83. ALTER TABLE `zh_ledger_extra_22`
  84. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  85. ALTER TABLE `zh_ledger_extra_23`
  86. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  87. ALTER TABLE `zh_ledger_extra_24`
  88. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  89. ALTER TABLE `zh_ledger_extra_25`
  90. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  91. ALTER TABLE `zh_ledger_extra_26`
  92. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  93. ALTER TABLE `zh_ledger_extra_27`
  94. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  95. ALTER TABLE `zh_ledger_extra_28`
  96. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  97. ALTER TABLE `zh_ledger_extra_29`
  98. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  99. ALTER TABLE `zh_ledger_extra_30`
  100. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  101. ALTER TABLE `zh_ledger_extra_31`
  102. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  103. ALTER TABLE `zh_ledger_extra_32`
  104. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  105. ALTER TABLE `zh_ledger_extra_33`
  106. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  107. ALTER TABLE `zh_ledger_extra_34`
  108. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  109. ALTER TABLE `zh_ledger_extra_35`
  110. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  111. ALTER TABLE `zh_ledger_extra_36`
  112. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  113. ALTER TABLE `zh_ledger_extra_37`
  114. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  115. ALTER TABLE `zh_ledger_extra_38`
  116. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  117. ALTER TABLE `zh_ledger_extra_39`
  118. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  119. ALTER TABLE `zh_ledger_extra_40`
  120. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  121. ALTER TABLE `zh_ledger_extra_41`
  122. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  123. ALTER TABLE `zh_ledger_extra_42`
  124. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  125. ALTER TABLE `zh_ledger_extra_43`
  126. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  127. ALTER TABLE `zh_ledger_extra_44`
  128. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  129. ALTER TABLE `zh_ledger_extra_45`
  130. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  131. ALTER TABLE `zh_ledger_extra_46`
  132. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  133. ALTER TABLE `zh_ledger_extra_47`
  134. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  135. ALTER TABLE `zh_ledger_extra_48`
  136. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  137. ALTER TABLE `zh_ledger_extra_49`
  138. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  139. ALTER TABLE `zh_ledger_extra_50`
  140. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  141. ALTER TABLE `zh_ledger_extra_51`
  142. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  143. ALTER TABLE `zh_ledger_extra_52`
  144. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  145. ALTER TABLE `zh_ledger_extra_53`
  146. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  147. ALTER TABLE `zh_ledger_extra_54`
  148. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  149. ALTER TABLE `zh_ledger_extra_55`
  150. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  151. ALTER TABLE `zh_ledger_extra_56`
  152. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  153. ALTER TABLE `zh_ledger_extra_57`
  154. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  155. ALTER TABLE `zh_ledger_extra_58`
  156. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  157. ALTER TABLE `zh_ledger_extra_59`
  158. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  159. ALTER TABLE `zh_ledger_extra_60`
  160. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  161. ALTER TABLE `zh_ledger_extra_61`
  162. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  163. ALTER TABLE `zh_ledger_extra_62`
  164. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  165. ALTER TABLE `zh_ledger_extra_63`
  166. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  167. ALTER TABLE `zh_ledger_extra_64`
  168. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  169. ALTER TABLE `zh_ledger_extra_65`
  170. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  171. ALTER TABLE `zh_ledger_extra_66`
  172. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  173. ALTER TABLE `zh_ledger_extra_67`
  174. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  175. ALTER TABLE `zh_ledger_extra_68`
  176. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  177. ALTER TABLE `zh_ledger_extra_69`
  178. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  179. ALTER TABLE `zh_ledger_extra_70`
  180. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  181. ALTER TABLE `zh_ledger_extra_71`
  182. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  183. ALTER TABLE `zh_ledger_extra_72`
  184. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  185. ALTER TABLE `zh_ledger_extra_73`
  186. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  187. ALTER TABLE `zh_ledger_extra_74`
  188. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  189. ALTER TABLE `zh_ledger_extra_75`
  190. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  191. ALTER TABLE `zh_ledger_extra_76`
  192. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  193. ALTER TABLE `zh_ledger_extra_77`
  194. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  195. ALTER TABLE `zh_ledger_extra_78`
  196. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  197. ALTER TABLE `zh_ledger_extra_79`
  198. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  199. ALTER TABLE `zh_ledger_extra_80`
  200. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  201. ALTER TABLE `zh_ledger_extra_81`
  202. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  203. ALTER TABLE `zh_ledger_extra_82`
  204. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  205. ALTER TABLE `zh_ledger_extra_83`
  206. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  207. ALTER TABLE `zh_ledger_extra_84`
  208. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  209. ALTER TABLE `zh_ledger_extra_85`
  210. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  211. ALTER TABLE `zh_ledger_extra_86`
  212. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  213. ALTER TABLE `zh_ledger_extra_87`
  214. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  215. ALTER TABLE `zh_ledger_extra_88`
  216. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  217. ALTER TABLE `zh_ledger_extra_89`
  218. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  219. ALTER TABLE `zh_ledger_extra_90`
  220. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  221. ALTER TABLE `zh_ledger_extra_91`
  222. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  223. ALTER TABLE `zh_ledger_extra_92`
  224. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  225. ALTER TABLE `zh_ledger_extra_93`
  226. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  227. ALTER TABLE `zh_ledger_extra_94`
  228. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  229. ALTER TABLE `zh_ledger_extra_95`
  230. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  231. ALTER TABLE `zh_ledger_extra_96`
  232. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  233. ALTER TABLE `zh_ledger_extra_97`
  234. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  235. ALTER TABLE `zh_ledger_extra_98`
  236. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  237. ALTER TABLE `zh_ledger_extra_99`
  238. ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  239. ALTER TABLE `zh_financial_transfer_tender`
  240. MODIFY COLUMN `sorder` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT '期数,以逗号分隔' AFTER `tid`,
  241. ADD COLUMN `source` varchar(255) NULL DEFAULT '' COMMENT '资金来源' AFTER `is_lock`,
  242. ADD COLUMN `pre_hb_tp` decimal(30, 8) NULL DEFAULT 0 COMMENT '截止上次划拨' AFTER `hb_tp`;
  243. ALTER TABLE `zh_financial_transfer`
  244. ADD COLUMN `pre_hb_tp` decimal(30, 8) NULL DEFAULT 0 COMMENT '截止上次划拨金额' AFTER `total_price`;
  245. ALTER TABLE `zh_financial_pay`
  246. ADD COLUMN `fpsid` int NULL COMMENT '资金支付单位期id' AFTER `tid`;
  247. ALTER TABLE `zh_financial_pay_audit`
  248. ADD COLUMN `fpsid` int NULL COMMENT '资金支付单位期id' AFTER `fpid`;
  249. CREATE TABLE `zh_financial_pay_stage` (
  250. `id` int NOT NULL AUTO_INCREMENT,
  251. `spid` varchar(100) NULL COMMENT '项目id',
  252. `company_id` int NULL DEFAULT NULL COMMENT '单位id',
  253. `order` smallint(5) NULL COMMENT '期数',
  254. `uid` int NULL COMMENT '申请人id',
  255. `total_price` decimal(30, 8) NULL DEFAULT 0 COMMENT '本期金额',
  256. `pre_tp` decimal(30, 8) NULL DEFAULT 0 COMMENT '截止上期金额',
  257. `can_del` tinyint(1) NULL DEFAULT 1 COMMENT '是否可删除',
  258. `create_time` datetime NULL DEFAULT NULL COMMENT '申请时间',
  259. PRIMARY KEY (`id`)
  260. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT = '资金支付单位期数表';
  261. CREATE TABLE `zh_tender_permission` (
  262. `id` varchar(36) NOT NULL COMMENT 'uuid',
  263. `pid` int(11) NOT NULL COMMENT '项目id(zh_project.id)',
  264. `spid` varchar(36) NOT NULL COMMENT '子项目id(zh_sub_project.id)',
  265. `tid` int(11) NOT NULL COMMENT '标段id(zh_tender.id)',
  266. `uid` int(11) NOT NULL COMMENT '授权用户id(zh_project_account.id)',
  267. `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  268. `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后编辑时间',
  269. `quality` varchar(255) NOT NULL DEFAULT '' COMMENT '质量管理权限(,分隔,具体见代码定义)',
  270. PRIMARY KEY (`id`)
  271. );
  272. CREATE TABLE `zh_quality_rule` (
  273. `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id',
  274. `pid` int(11) NOT NULL COMMENT '项目id',
  275. `spid` varchar(36) NOT NULL COMMENT '子项目id(zh_sub_project.id)',
  276. `group_id` varchar(36) NOT NULL COMMENT 'uuid(分组id)',
  277. `group_name` varchar(50) NOT NULL COMMENT '分组名称',
  278. `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  279. `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后更新时间',
  280. `user_id` int(11) UNSIGNED NOT NULL COMMENT '创建人',
  281. `name` varchar(50) NOT NULL DEFAULT '' COMMENT '规则名称',
  282. `condition` text NULL COMMENT '条件',
  283. `push_status` varchar(255) NOT NULL DEFAULT '' COMMENT '推送状态',
  284. `memo` varchar(255) NOT NULL DEFAULT '' COMMENT '备注',
  285. PRIMARY KEY (`id`)
  286. );
  287. CREATE TABLE `zh_quality` (
  288. `id` varchar(36) NOT NULL COMMENT 'uuid',
  289. `tid` int(11) NOT NULL COMMENT '标段id(zh_tender.id)',
  290. `rela_type` varchar(10) NOT NULL COMMENT '台账类型(xmj/pos)',
  291. `rela_id` varchar(36) NOT NULL COMMENT '台账id(zh_ledger.id/zh_pos.id)',
  292. `rela_name` varchar(36) NOT NULL COMMENT '计量单元名称(zh_pos.name)',
  293. `gxby_status` tinyint(4) NOT NULL DEFAULT -1 COMMENT '工序报验状态',
  294. `gxby_date` timestamp NULL COMMENT '完工日期',
  295. `gxby_limit` tinyint(4) NOT NULL DEFAULT 0 COMMENT '计量是否受限',
  296. `dagl_status` tinyint(4) NOT NULL DEFAULT -1 COMMENT '档案管理状态',
  297. `dagl_limit` tinyint(4) NOT NULL DEFAULT 0 COMMENT '计量是否受限',
  298. `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  299. `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后更新时间',
  300. `create_uid` int(11) NOT NULL COMMENT '创建人',
  301. `update_uid` int(11) NOT NULL COMMENT '最后修改人',
  302. `is_used` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否使用',
  303. `group_id` varchar(36) NOT NULL DEFAULT '' COMMENT '规则判断组id(zh_quality_rule.group_id)',
  304. `kaigong_name` varchar(50) NOT NULL DEFAULT '' COMMENT '开工-名称',
  305. `kaigong_date` varchar(20) NOT NULL DEFAULT '' COMMENT '开工-计划开工日期',
  306. `kaigong_uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '开工-创建人',
  307. `kaigong_time` timestamp NULL COMMENT '开工-创建时间',
  308. PRIMARY KEY (`id`)
  309. );
  310. CREATE TABLE `zh_quality_file` (
  311. `id` varchar(36) NOT NULL COMMENT 'uuid',
  312. `tid` int(11) NOT NULL COMMENT '标段id(zh_tender.id)',
  313. `quality_id` varchar(36) NOT NULL COMMENT '质量管理id(zh_quality.id)',
  314. `rela_type` varchar(20) NOT NULL COMMENT '关联台账类型(xmj/pos)',
  315. `rela_id` varchar(36) NOT NULL COMMENT '关联台账id(zh_ledger.id/zh_pos.id)',
  316. `block_type` varchar(20) NOT NULL COMMENT '质量管理模块(kaigong/gongxu/...)',
  317. `block_id` varchar(36) NOT NULL COMMENT '质量管理模块id(zh_quality_gongxu.id/zh_quality_yinbi.id/...)',
  318. `user_id` int(11) UNSIGNED NOT NULL COMMENT '用户id(zh_project_account.id)',
  319. `user_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '用户名(缓存)',
  320. `user_company` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '公司(缓存)',
  321. `user_role` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '角色(缓存)',
  322. `filename` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '文件名',
  323. `fileext` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '文件类型',
  324. `filesize` int(11) UNSIGNED NOT NULL COMMENT '文件大小',
  325. `filepath` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '文件路径(oss路径)',
  326. `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  327. `update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最后更新时间',
  328. `is_deleted` tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否删除',
  329. `spec_type` varchar(20) NOT NULL DEFAULT '' COMMENT '特殊文件类型(质检qa)',
  330. PRIMARY KEY (`id`)
  331. );
  332. CREATE TABLE `zh_quality_gongxu` (
  333. `id` varchar(36) NOT NULL COMMENT 'uuid',
  334. `tid` int(11) NOT NULL COMMENT '标段id(zh_tender.id)',
  335. `quality_id` varchar(36) NOT NULL COMMENT '质量管理id(zh_quality.id)',
  336. `user_id` int(11) NOT NULL COMMENT '创建人id',
  337. `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  338. `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间',
  339. `name` varchar(100) NOT NULL DEFAULT '' COMMENT '名称',
  340. PRIMARY KEY (`id`)
  341. );
  342. CREATE TABLE `zh_quality_yinbi` (
  343. `id` varchar(36) NOT NULL COMMENT 'uuid',
  344. `tid` int(11) NOT NULL COMMENT '标段id(zh_tender.id)',
  345. `quality_id` varchar(36) NOT NULL COMMENT '质量管理id(zh_quality.id)',
  346. `user_id` int(11) NOT NULL COMMENT '创建人id',
  347. `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  348. `update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最后修改时间',
  349. `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '名称',
  350. `gongxu_id` varchar(36) NOT NULL DEFAULT '' COMMENT '工序id(zh_quality_gongxu.id)',
  351. `gcbw` varchar(1000) NOT NULL DEFAULT '' COMMENT '工程部位',
  352. `content` varchar(1000) NOT NULL DEFAULT '' COMMENT '说明',
  353. PRIMARY KEY (`id`)
  354. );
  355. ALTER TABLE `zh_ledger_extra_0`
  356. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  357. ALTER TABLE `zh_ledger_extra_1`
  358. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  359. ALTER TABLE `zh_ledger_extra_2`
  360. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  361. ALTER TABLE `zh_ledger_extra_3`
  362. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  363. ALTER TABLE `zh_ledger_extra_4`
  364. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  365. ALTER TABLE `zh_ledger_extra_5`
  366. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  367. ALTER TABLE `zh_ledger_extra_6`
  368. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  369. ALTER TABLE `zh_ledger_extra_7`
  370. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  371. ALTER TABLE `zh_ledger_extra_8`
  372. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  373. ALTER TABLE `zh_ledger_extra_9`
  374. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  375. ALTER TABLE `zh_ledger_extra_10`
  376. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  377. ALTER TABLE `zh_ledger_extra_11`
  378. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  379. ALTER TABLE `zh_ledger_extra_12`
  380. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  381. ALTER TABLE `zh_ledger_extra_13`
  382. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  383. ALTER TABLE `zh_ledger_extra_14`
  384. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  385. ALTER TABLE `zh_ledger_extra_15`
  386. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  387. ALTER TABLE `zh_ledger_extra_16`
  388. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  389. ALTER TABLE `zh_ledger_extra_17`
  390. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  391. ALTER TABLE `zh_ledger_extra_18`
  392. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  393. ALTER TABLE `zh_ledger_extra_19`
  394. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  395. ALTER TABLE `zh_ledger_extra_20`
  396. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  397. ALTER TABLE `zh_ledger_extra_21`
  398. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  399. ALTER TABLE `zh_ledger_extra_22`
  400. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  401. ALTER TABLE `zh_ledger_extra_23`
  402. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  403. ALTER TABLE `zh_ledger_extra_24`
  404. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  405. ALTER TABLE `zh_ledger_extra_25`
  406. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  407. ALTER TABLE `zh_ledger_extra_26`
  408. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  409. ALTER TABLE `zh_ledger_extra_27`
  410. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  411. ALTER TABLE `zh_ledger_extra_28`
  412. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  413. ALTER TABLE `zh_ledger_extra_29`
  414. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  415. ALTER TABLE `zh_ledger_extra_30`
  416. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  417. ALTER TABLE `zh_ledger_extra_31`
  418. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  419. ALTER TABLE `zh_ledger_extra_32`
  420. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  421. ALTER TABLE `zh_ledger_extra_33`
  422. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  423. ALTER TABLE `zh_ledger_extra_34`
  424. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  425. ALTER TABLE `zh_ledger_extra_35`
  426. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  427. ALTER TABLE `zh_ledger_extra_36`
  428. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  429. ALTER TABLE `zh_ledger_extra_37`
  430. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  431. ALTER TABLE `zh_ledger_extra_38`
  432. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  433. ALTER TABLE `zh_ledger_extra_39`
  434. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  435. ALTER TABLE `zh_ledger_extra_40`
  436. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  437. ALTER TABLE `zh_ledger_extra_41`
  438. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  439. ALTER TABLE `zh_ledger_extra_42`
  440. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  441. ALTER TABLE `zh_ledger_extra_43`
  442. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  443. ALTER TABLE `zh_ledger_extra_44`
  444. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  445. ALTER TABLE `zh_ledger_extra_45`
  446. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  447. ALTER TABLE `zh_ledger_extra_46`
  448. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  449. ALTER TABLE `zh_ledger_extra_47`
  450. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  451. ALTER TABLE `zh_ledger_extra_48`
  452. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  453. ALTER TABLE `zh_ledger_extra_49`
  454. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  455. ALTER TABLE `zh_ledger_extra_50`
  456. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  457. ALTER TABLE `zh_ledger_extra_51`
  458. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  459. ALTER TABLE `zh_ledger_extra_52`
  460. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  461. ALTER TABLE `zh_ledger_extra_53`
  462. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  463. ALTER TABLE `zh_ledger_extra_54`
  464. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  465. ALTER TABLE `zh_ledger_extra_55`
  466. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  467. ALTER TABLE `zh_ledger_extra_56`
  468. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  469. ALTER TABLE `zh_ledger_extra_57`
  470. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  471. ALTER TABLE `zh_ledger_extra_58`
  472. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  473. ALTER TABLE `zh_ledger_extra_59`
  474. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  475. ALTER TABLE `zh_ledger_extra_60`
  476. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  477. ALTER TABLE `zh_ledger_extra_61`
  478. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  479. ALTER TABLE `zh_ledger_extra_62`
  480. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  481. ALTER TABLE `zh_ledger_extra_63`
  482. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  483. ALTER TABLE `zh_ledger_extra_64`
  484. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  485. ALTER TABLE `zh_ledger_extra_65`
  486. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  487. ALTER TABLE `zh_ledger_extra_66`
  488. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  489. ALTER TABLE `zh_ledger_extra_67`
  490. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  491. ALTER TABLE `zh_ledger_extra_68`
  492. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  493. ALTER TABLE `zh_ledger_extra_69`
  494. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  495. ALTER TABLE `zh_ledger_extra_70`
  496. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  497. ALTER TABLE `zh_ledger_extra_71`
  498. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  499. ALTER TABLE `zh_ledger_extra_72`
  500. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  501. ALTER TABLE `zh_ledger_extra_73`
  502. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  503. ALTER TABLE `zh_ledger_extra_74`
  504. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  505. ALTER TABLE `zh_ledger_extra_75`
  506. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  507. ALTER TABLE `zh_ledger_extra_76`
  508. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  509. ALTER TABLE `zh_ledger_extra_77`
  510. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  511. ALTER TABLE `zh_ledger_extra_78`
  512. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  513. ALTER TABLE `zh_ledger_extra_79`
  514. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  515. ALTER TABLE `zh_ledger_extra_80`
  516. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  517. ALTER TABLE `zh_ledger_extra_81`
  518. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  519. ALTER TABLE `zh_ledger_extra_82`
  520. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  521. ALTER TABLE `zh_ledger_extra_83`
  522. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  523. ALTER TABLE `zh_ledger_extra_84`
  524. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  525. ALTER TABLE `zh_ledger_extra_85`
  526. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  527. ALTER TABLE `zh_ledger_extra_86`
  528. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  529. ALTER TABLE `zh_ledger_extra_87`
  530. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  531. ALTER TABLE `zh_ledger_extra_88`
  532. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  533. ALTER TABLE `zh_ledger_extra_89`
  534. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  535. ALTER TABLE `zh_ledger_extra_90`
  536. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  537. ALTER TABLE `zh_ledger_extra_91`
  538. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  539. ALTER TABLE `zh_ledger_extra_92`
  540. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  541. ALTER TABLE `zh_ledger_extra_93`
  542. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  543. ALTER TABLE `zh_ledger_extra_94`
  544. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  545. ALTER TABLE `zh_ledger_extra_95`
  546. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  547. ALTER TABLE `zh_ledger_extra_96`
  548. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  549. ALTER TABLE `zh_ledger_extra_97`
  550. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  551. ALTER TABLE `zh_ledger_extra_98`
  552. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  553. ALTER TABLE `zh_ledger_extra_99`
  554. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  555. ALTER TABLE `zh_pos_extra_0`
  556. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  557. ALTER TABLE `zh_pos_extra_1`
  558. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  559. ALTER TABLE `zh_pos_extra_2`
  560. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  561. ALTER TABLE `zh_pos_extra_3`
  562. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  563. ALTER TABLE `zh_pos_extra_4`
  564. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  565. ALTER TABLE `zh_pos_extra_5`
  566. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  567. ALTER TABLE `zh_pos_extra_6`
  568. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  569. ALTER TABLE `zh_pos_extra_7`
  570. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  571. ALTER TABLE `zh_pos_extra_8`
  572. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  573. ALTER TABLE `zh_pos_extra_9`
  574. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  575. ALTER TABLE `zh_pos_extra_10`
  576. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  577. ALTER TABLE `zh_pos_extra_11`
  578. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  579. ALTER TABLE `zh_pos_extra_12`
  580. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  581. ALTER TABLE `zh_pos_extra_13`
  582. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  583. ALTER TABLE `zh_pos_extra_14`
  584. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  585. ALTER TABLE `zh_pos_extra_15`
  586. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  587. ALTER TABLE `zh_pos_extra_16`
  588. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  589. ALTER TABLE `zh_pos_extra_17`
  590. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  591. ALTER TABLE `zh_pos_extra_18`
  592. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  593. ALTER TABLE `zh_pos_extra_19`
  594. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  595. ALTER TABLE `zh_pos_extra_20`
  596. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  597. ALTER TABLE `zh_pos_extra_21`
  598. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  599. ALTER TABLE `zh_pos_extra_22`
  600. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  601. ALTER TABLE `zh_pos_extra_23`
  602. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  603. ALTER TABLE `zh_pos_extra_24`
  604. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  605. ALTER TABLE `zh_pos_extra_25`
  606. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  607. ALTER TABLE `zh_pos_extra_26`
  608. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  609. ALTER TABLE `zh_pos_extra_27`
  610. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  611. ALTER TABLE `zh_pos_extra_28`
  612. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  613. ALTER TABLE `zh_pos_extra_29`
  614. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  615. ALTER TABLE `zh_pos_extra_30`
  616. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  617. ALTER TABLE `zh_pos_extra_31`
  618. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  619. ALTER TABLE `zh_pos_extra_32`
  620. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  621. ALTER TABLE `zh_pos_extra_33`
  622. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  623. ALTER TABLE `zh_pos_extra_34`
  624. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  625. ALTER TABLE `zh_pos_extra_35`
  626. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  627. ALTER TABLE `zh_pos_extra_36`
  628. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  629. ALTER TABLE `zh_pos_extra_37`
  630. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  631. ALTER TABLE `zh_pos_extra_38`
  632. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  633. ALTER TABLE `zh_pos_extra_39`
  634. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  635. ALTER TABLE `zh_pos_extra_40`
  636. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  637. ALTER TABLE `zh_pos_extra_41`
  638. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  639. ALTER TABLE `zh_pos_extra_42`
  640. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  641. ALTER TABLE `zh_pos_extra_43`
  642. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  643. ALTER TABLE `zh_pos_extra_44`
  644. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  645. ALTER TABLE `zh_pos_extra_45`
  646. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  647. ALTER TABLE `zh_pos_extra_46`
  648. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  649. ALTER TABLE `zh_pos_extra_47`
  650. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  651. ALTER TABLE `zh_pos_extra_48`
  652. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  653. ALTER TABLE `zh_pos_extra_49`
  654. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  655. ALTER TABLE `zh_pos_extra_50`
  656. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  657. ALTER TABLE `zh_pos_extra_51`
  658. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  659. ALTER TABLE `zh_pos_extra_52`
  660. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  661. ALTER TABLE `zh_pos_extra_53`
  662. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  663. ALTER TABLE `zh_pos_extra_54`
  664. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  665. ALTER TABLE `zh_pos_extra_55`
  666. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  667. ALTER TABLE `zh_pos_extra_56`
  668. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  669. ALTER TABLE `zh_pos_extra_57`
  670. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  671. ALTER TABLE `zh_pos_extra_58`
  672. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  673. ALTER TABLE `zh_pos_extra_59`
  674. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  675. ALTER TABLE `zh_pos_extra_60`
  676. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  677. ALTER TABLE `zh_pos_extra_61`
  678. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  679. ALTER TABLE `zh_pos_extra_62`
  680. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  681. ALTER TABLE `zh_pos_extra_63`
  682. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  683. ALTER TABLE `zh_pos_extra_64`
  684. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  685. ALTER TABLE `zh_pos_extra_65`
  686. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  687. ALTER TABLE `zh_pos_extra_66`
  688. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  689. ALTER TABLE `zh_pos_extra_67`
  690. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  691. ALTER TABLE `zh_pos_extra_68`
  692. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  693. ALTER TABLE `zh_pos_extra_69`
  694. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  695. ALTER TABLE `zh_pos_extra_70`
  696. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  697. ALTER TABLE `zh_pos_extra_71`
  698. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  699. ALTER TABLE `zh_pos_extra_72`
  700. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  701. ALTER TABLE `zh_pos_extra_73`
  702. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  703. ALTER TABLE `zh_pos_extra_74`
  704. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  705. ALTER TABLE `zh_pos_extra_75`
  706. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  707. ALTER TABLE `zh_pos_extra_76`
  708. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  709. ALTER TABLE `zh_pos_extra_77`
  710. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  711. ALTER TABLE `zh_pos_extra_78`
  712. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  713. ALTER TABLE `zh_pos_extra_79`
  714. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  715. ALTER TABLE `zh_pos_extra_80`
  716. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  717. ALTER TABLE `zh_pos_extra_81`
  718. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  719. ALTER TABLE `zh_pos_extra_82`
  720. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  721. ALTER TABLE `zh_pos_extra_83`
  722. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  723. ALTER TABLE `zh_pos_extra_84`
  724. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  725. ALTER TABLE `zh_pos_extra_85`
  726. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  727. ALTER TABLE `zh_pos_extra_86`
  728. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  729. ALTER TABLE `zh_pos_extra_87`
  730. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  731. ALTER TABLE `zh_pos_extra_88`
  732. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  733. ALTER TABLE `zh_pos_extra_89`
  734. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  735. ALTER TABLE `zh_pos_extra_90`
  736. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  737. ALTER TABLE `zh_pos_extra_91`
  738. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  739. ALTER TABLE `zh_pos_extra_92`
  740. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  741. ALTER TABLE `zh_pos_extra_93`
  742. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  743. ALTER TABLE `zh_pos_extra_94`
  744. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  745. ALTER TABLE `zh_pos_extra_95`
  746. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  747. ALTER TABLE `zh_pos_extra_96`
  748. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  749. ALTER TABLE `zh_pos_extra_97`
  750. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  751. ALTER TABLE `zh_pos_extra_98`
  752. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  753. ALTER TABLE `zh_pos_extra_99`
  754. ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
  755. ALTER TABLE `zh_stage_bills_final_0`
  756. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  757. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  758. ALTER TABLE `zh_stage_bills_final_1`
  759. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  760. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  761. ALTER TABLE `zh_stage_bills_final_2`
  762. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  763. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  764. ALTER TABLE `zh_stage_bills_final_3`
  765. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  766. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  767. ALTER TABLE `zh_stage_bills_final_4`
  768. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  769. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  770. ALTER TABLE `zh_stage_bills_final_5`
  771. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  772. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  773. ALTER TABLE `zh_stage_bills_final_6`
  774. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  775. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  776. ALTER TABLE `zh_stage_bills_final_7`
  777. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  778. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  779. ALTER TABLE `zh_stage_bills_final_8`
  780. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  781. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  782. ALTER TABLE `zh_stage_bills_final_9`
  783. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  784. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  785. ALTER TABLE `zh_stage_bills_final_10`
  786. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  787. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  788. ALTER TABLE `zh_stage_bills_final_11`
  789. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  790. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  791. ALTER TABLE `zh_stage_bills_final_12`
  792. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  793. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  794. ALTER TABLE `zh_stage_bills_final_13`
  795. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  796. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  797. ALTER TABLE `zh_stage_bills_final_14`
  798. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  799. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  800. ALTER TABLE `zh_stage_bills_final_15`
  801. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  802. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  803. ALTER TABLE `zh_stage_bills_final_16`
  804. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  805. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  806. ALTER TABLE `zh_stage_bills_final_17`
  807. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  808. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  809. ALTER TABLE `zh_stage_bills_final_18`
  810. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  811. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  812. ALTER TABLE `zh_stage_bills_final_19`
  813. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  814. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  815. ALTER TABLE `zh_stage_bills_final_20`
  816. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  817. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  818. ALTER TABLE `zh_stage_bills_final_21`
  819. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  820. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  821. ALTER TABLE `zh_stage_bills_final_22`
  822. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  823. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  824. ALTER TABLE `zh_stage_bills_final_23`
  825. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  826. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  827. ALTER TABLE `zh_stage_bills_final_24`
  828. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  829. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  830. ALTER TABLE `zh_stage_bills_final_25`
  831. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  832. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  833. ALTER TABLE `zh_stage_bills_final_26`
  834. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  835. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  836. ALTER TABLE `zh_stage_bills_final_27`
  837. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  838. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  839. ALTER TABLE `zh_stage_bills_final_28`
  840. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  841. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  842. ALTER TABLE `zh_stage_bills_final_29`
  843. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  844. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  845. ALTER TABLE `zh_stage_bills_final_30`
  846. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  847. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  848. ALTER TABLE `zh_stage_bills_final_31`
  849. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  850. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  851. ALTER TABLE `zh_stage_bills_final_32`
  852. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  853. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  854. ALTER TABLE `zh_stage_bills_final_33`
  855. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  856. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  857. ALTER TABLE `zh_stage_bills_final_34`
  858. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  859. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  860. ALTER TABLE `zh_stage_bills_final_35`
  861. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  862. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  863. ALTER TABLE `zh_stage_bills_final_36`
  864. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  865. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  866. ALTER TABLE `zh_stage_bills_final_37`
  867. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  868. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  869. ALTER TABLE `zh_stage_bills_final_38`
  870. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  871. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  872. ALTER TABLE `zh_stage_bills_final_39`
  873. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  874. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  875. ALTER TABLE `zh_stage_bills_final_40`
  876. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  877. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  878. ALTER TABLE `zh_stage_bills_final_41`
  879. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  880. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  881. ALTER TABLE `zh_stage_bills_final_42`
  882. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  883. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  884. ALTER TABLE `zh_stage_bills_final_43`
  885. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  886. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  887. ALTER TABLE `zh_stage_bills_final_44`
  888. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  889. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  890. ALTER TABLE `zh_stage_bills_final_45`
  891. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  892. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  893. ALTER TABLE `zh_stage_bills_final_46`
  894. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  895. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  896. ALTER TABLE `zh_stage_bills_final_47`
  897. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  898. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  899. ALTER TABLE `zh_stage_bills_final_48`
  900. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  901. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  902. ALTER TABLE `zh_stage_bills_final_49`
  903. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  904. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  905. ALTER TABLE `zh_stage_bills_final_50`
  906. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  907. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  908. ALTER TABLE `zh_stage_bills_final_51`
  909. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  910. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  911. ALTER TABLE `zh_stage_bills_final_52`
  912. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  913. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  914. ALTER TABLE `zh_stage_bills_final_53`
  915. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  916. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  917. ALTER TABLE `zh_stage_bills_final_54`
  918. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  919. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  920. ALTER TABLE `zh_stage_bills_final_55`
  921. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  922. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  923. ALTER TABLE `zh_stage_bills_final_56`
  924. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  925. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  926. ALTER TABLE `zh_stage_bills_final_57`
  927. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  928. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  929. ALTER TABLE `zh_stage_bills_final_58`
  930. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  931. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  932. ALTER TABLE `zh_stage_bills_final_59`
  933. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  934. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  935. ALTER TABLE `zh_stage_bills_final_60`
  936. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  937. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  938. ALTER TABLE `zh_stage_bills_final_61`
  939. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  940. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  941. ALTER TABLE `zh_stage_bills_final_62`
  942. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  943. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  944. ALTER TABLE `zh_stage_bills_final_63`
  945. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  946. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  947. ALTER TABLE `zh_stage_bills_final_64`
  948. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  949. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  950. ALTER TABLE `zh_stage_bills_final_65`
  951. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  952. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  953. ALTER TABLE `zh_stage_bills_final_66`
  954. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  955. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  956. ALTER TABLE `zh_stage_bills_final_67`
  957. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  958. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  959. ALTER TABLE `zh_stage_bills_final_68`
  960. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  961. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  962. ALTER TABLE `zh_stage_bills_final_69`
  963. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  964. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  965. ALTER TABLE `zh_stage_bills_final_70`
  966. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  967. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  968. ALTER TABLE `zh_stage_bills_final_71`
  969. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  970. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  971. ALTER TABLE `zh_stage_bills_final_72`
  972. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  973. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  974. ALTER TABLE `zh_stage_bills_final_73`
  975. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  976. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  977. ALTER TABLE `zh_stage_bills_final_74`
  978. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  979. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  980. ALTER TABLE `zh_stage_bills_final_75`
  981. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  982. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  983. ALTER TABLE `zh_stage_bills_final_76`
  984. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  985. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  986. ALTER TABLE `zh_stage_bills_final_77`
  987. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  988. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  989. ALTER TABLE `zh_stage_bills_final_78`
  990. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  991. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  992. ALTER TABLE `zh_stage_bills_final_79`
  993. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  994. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  995. ALTER TABLE `zh_stage_bills_final_80`
  996. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  997. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  998. ALTER TABLE `zh_stage_bills_final_81`
  999. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1000. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1001. ALTER TABLE `zh_stage_bills_final_82`
  1002. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1003. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1004. ALTER TABLE `zh_stage_bills_final_83`
  1005. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1006. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1007. ALTER TABLE `zh_stage_bills_final_84`
  1008. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1009. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1010. ALTER TABLE `zh_stage_bills_final_85`
  1011. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1012. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1013. ALTER TABLE `zh_stage_bills_final_86`
  1014. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1015. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1016. ALTER TABLE `zh_stage_bills_final_87`
  1017. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1018. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1019. ALTER TABLE `zh_stage_bills_final_88`
  1020. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1021. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1022. ALTER TABLE `zh_stage_bills_final_89`
  1023. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1024. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1025. ALTER TABLE `zh_stage_bills_final_90`
  1026. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1027. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1028. ALTER TABLE `zh_stage_bills_final_91`
  1029. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1030. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1031. ALTER TABLE `zh_stage_bills_final_92`
  1032. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1033. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1034. ALTER TABLE `zh_stage_bills_final_93`
  1035. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1036. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1037. ALTER TABLE `zh_stage_bills_final_94`
  1038. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1039. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1040. ALTER TABLE `zh_stage_bills_final_95`
  1041. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1042. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1043. ALTER TABLE `zh_stage_bills_final_96`
  1044. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1045. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1046. ALTER TABLE `zh_stage_bills_final_97`
  1047. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1048. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1049. ALTER TABLE `zh_stage_bills_final_98`
  1050. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1051. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1052. ALTER TABLE `zh_stage_bills_final_99`
  1053. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1054. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1055. ALTER TABLE `zh_stage_pos_final_0`
  1056. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1057. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1058. ALTER TABLE `zh_stage_pos_final_1`
  1059. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1060. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1061. ALTER TABLE `zh_stage_pos_final_2`
  1062. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1063. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1064. ALTER TABLE `zh_stage_pos_final_3`
  1065. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1066. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1067. ALTER TABLE `zh_stage_pos_final_4`
  1068. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1069. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1070. ALTER TABLE `zh_stage_pos_final_5`
  1071. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1072. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1073. ALTER TABLE `zh_stage_pos_final_6`
  1074. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1075. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1076. ALTER TABLE `zh_stage_pos_final_7`
  1077. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1078. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1079. ALTER TABLE `zh_stage_pos_final_8`
  1080. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1081. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1082. ALTER TABLE `zh_stage_pos_final_9`
  1083. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1084. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1085. ALTER TABLE `zh_stage_pos_final_10`
  1086. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1087. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1088. ALTER TABLE `zh_stage_pos_final_11`
  1089. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1090. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1091. ALTER TABLE `zh_stage_pos_final_12`
  1092. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1093. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1094. ALTER TABLE `zh_stage_pos_final_13`
  1095. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1096. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1097. ALTER TABLE `zh_stage_pos_final_14`
  1098. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1099. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1100. ALTER TABLE `zh_stage_pos_final_15`
  1101. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1102. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1103. ALTER TABLE `zh_stage_pos_final_16`
  1104. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1105. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1106. ALTER TABLE `zh_stage_pos_final_17`
  1107. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1108. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1109. ALTER TABLE `zh_stage_pos_final_18`
  1110. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1111. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1112. ALTER TABLE `zh_stage_pos_final_19`
  1113. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1114. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1115. ALTER TABLE `zh_stage_pos_final_20`
  1116. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1117. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1118. ALTER TABLE `zh_stage_pos_final_21`
  1119. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1120. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1121. ALTER TABLE `zh_stage_pos_final_22`
  1122. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1123. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1124. ALTER TABLE `zh_stage_pos_final_23`
  1125. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1126. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1127. ALTER TABLE `zh_stage_pos_final_24`
  1128. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1129. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1130. ALTER TABLE `zh_stage_pos_final_25`
  1131. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1132. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1133. ALTER TABLE `zh_stage_pos_final_26`
  1134. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1135. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1136. ALTER TABLE `zh_stage_pos_final_27`
  1137. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1138. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1139. ALTER TABLE `zh_stage_pos_final_28`
  1140. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1141. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1142. ALTER TABLE `zh_stage_pos_final_29`
  1143. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1144. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1145. ALTER TABLE `zh_stage_pos_final_30`
  1146. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1147. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1148. ALTER TABLE `zh_stage_pos_final_31`
  1149. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1150. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1151. ALTER TABLE `zh_stage_pos_final_32`
  1152. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1153. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1154. ALTER TABLE `zh_stage_pos_final_33`
  1155. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1156. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1157. ALTER TABLE `zh_stage_pos_final_34`
  1158. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1159. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1160. ALTER TABLE `zh_stage_pos_final_35`
  1161. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1162. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1163. ALTER TABLE `zh_stage_pos_final_36`
  1164. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1165. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1166. ALTER TABLE `zh_stage_pos_final_37`
  1167. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1168. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1169. ALTER TABLE `zh_stage_pos_final_38`
  1170. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1171. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1172. ALTER TABLE `zh_stage_pos_final_39`
  1173. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1174. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1175. ALTER TABLE `zh_stage_pos_final_40`
  1176. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1177. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1178. ALTER TABLE `zh_stage_pos_final_41`
  1179. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1180. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1181. ALTER TABLE `zh_stage_pos_final_42`
  1182. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1183. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1184. ALTER TABLE `zh_stage_pos_final_43`
  1185. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1186. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1187. ALTER TABLE `zh_stage_pos_final_44`
  1188. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1189. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1190. ALTER TABLE `zh_stage_pos_final_45`
  1191. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1192. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1193. ALTER TABLE `zh_stage_pos_final_46`
  1194. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1195. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1196. ALTER TABLE `zh_stage_pos_final_47`
  1197. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1198. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1199. ALTER TABLE `zh_stage_pos_final_48`
  1200. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1201. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1202. ALTER TABLE `zh_stage_pos_final_49`
  1203. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1204. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1205. ALTER TABLE `zh_stage_pos_final_50`
  1206. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1207. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1208. ALTER TABLE `zh_stage_pos_final_51`
  1209. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1210. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1211. ALTER TABLE `zh_stage_pos_final_52`
  1212. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1213. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1214. ALTER TABLE `zh_stage_pos_final_53`
  1215. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1216. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1217. ALTER TABLE `zh_stage_pos_final_54`
  1218. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1219. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1220. ALTER TABLE `zh_stage_pos_final_55`
  1221. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1222. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1223. ALTER TABLE `zh_stage_pos_final_56`
  1224. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1225. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1226. ALTER TABLE `zh_stage_pos_final_57`
  1227. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1228. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1229. ALTER TABLE `zh_stage_pos_final_58`
  1230. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1231. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1232. ALTER TABLE `zh_stage_pos_final_59`
  1233. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1234. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1235. ALTER TABLE `zh_stage_pos_final_60`
  1236. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1237. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1238. ALTER TABLE `zh_stage_pos_final_61`
  1239. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1240. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1241. ALTER TABLE `zh_stage_pos_final_62`
  1242. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1243. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1244. ALTER TABLE `zh_stage_pos_final_63`
  1245. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1246. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1247. ALTER TABLE `zh_stage_pos_final_64`
  1248. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1249. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1250. ALTER TABLE `zh_stage_pos_final_65`
  1251. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1252. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1253. ALTER TABLE `zh_stage_pos_final_66`
  1254. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1255. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1256. ALTER TABLE `zh_stage_pos_final_67`
  1257. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1258. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1259. ALTER TABLE `zh_stage_pos_final_68`
  1260. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1261. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1262. ALTER TABLE `zh_stage_pos_final_69`
  1263. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1264. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1265. ALTER TABLE `zh_stage_pos_final_70`
  1266. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1267. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1268. ALTER TABLE `zh_stage_pos_final_71`
  1269. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1270. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1271. ALTER TABLE `zh_stage_pos_final_72`
  1272. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1273. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1274. ALTER TABLE `zh_stage_pos_final_73`
  1275. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1276. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1277. ALTER TABLE `zh_stage_pos_final_74`
  1278. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1279. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1280. ALTER TABLE `zh_stage_pos_final_75`
  1281. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1282. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1283. ALTER TABLE `zh_stage_pos_final_76`
  1284. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1285. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1286. ALTER TABLE `zh_stage_pos_final_77`
  1287. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1288. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1289. ALTER TABLE `zh_stage_pos_final_78`
  1290. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1291. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1292. ALTER TABLE `zh_stage_pos_final_79`
  1293. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1294. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1295. ALTER TABLE `zh_stage_pos_final_80`
  1296. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1297. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1298. ALTER TABLE `zh_stage_pos_final_81`
  1299. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1300. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1301. ALTER TABLE `zh_stage_pos_final_82`
  1302. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1303. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1304. ALTER TABLE `zh_stage_pos_final_83`
  1305. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1306. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1307. ALTER TABLE `zh_stage_pos_final_84`
  1308. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1309. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1310. ALTER TABLE `zh_stage_pos_final_85`
  1311. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1312. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1313. ALTER TABLE `zh_stage_pos_final_86`
  1314. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1315. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1316. ALTER TABLE `zh_stage_pos_final_87`
  1317. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1318. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1319. ALTER TABLE `zh_stage_pos_final_88`
  1320. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1321. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1322. ALTER TABLE `zh_stage_pos_final_89`
  1323. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1324. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1325. ALTER TABLE `zh_stage_pos_final_90`
  1326. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1327. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1328. ALTER TABLE `zh_stage_pos_final_91`
  1329. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1330. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1331. ALTER TABLE `zh_stage_pos_final_92`
  1332. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1333. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1334. ALTER TABLE `zh_stage_pos_final_93`
  1335. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1336. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1337. ALTER TABLE `zh_stage_pos_final_94`
  1338. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1339. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1340. ALTER TABLE `zh_stage_pos_final_95`
  1341. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1342. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1343. ALTER TABLE `zh_stage_pos_final_96`
  1344. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1345. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1346. ALTER TABLE `zh_stage_pos_final_97`
  1347. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1348. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1349. ALTER TABLE `zh_stage_pos_final_98`
  1350. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1351. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1352. ALTER TABLE `zh_stage_pos_final_99`
  1353. ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
  1354. ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
  1355. ------------------------------------
  1356. -- 表数据
  1357. ------------------------------------