update20250404.sql 143 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124
  1. -- 请按如下分类提交sql!!!
  2. -- Version V3.5.48.0401
  3. -- uat 2025-4-1
  4. -- prod 2025-4-4
  5. ------------------------------------
  6. -- 表结构
  7. ------------------------------------
  8. ALTER TABLE `zh_sub_project`
  9. ADD COLUMN `page_show` varchar(5000) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '{\"bwtz\":\"1\"}' COMMENT '前台页面或功能展示与隐藏' AFTER `lock_file`,
  10. ADD COLUMN `fun_rela` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '功能设置(json.stringify)' AFTER `page_show`,
  11. ADD COLUMN `data_collect` tinyint(1) NOT NULL DEFAULT 0 COMMENT '决策大屏是否显示及对应大屏编号' AFTER `fun_rela`,
  12. ADD COLUMN `data_collect_pages` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '需要展示的大屏字符串,以,分隔' AFTER `data_collect`,
  13. ADD COLUMN `fun_set` varchar(5000) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '项目设置页内容json' AFTER `data_collect_pages`,
  14. ADD COLUMN `payment_setting` JSON NULL DEFAULT NULL COMMENT '支付审批模块设置' AFTER `fun_set`,
  15. ADD COLUMN `common_json` json NULL COMMENT '通用json,没有sql查询值必要的可放这' AFTER `payment_setting`;
  16. ALTER TABLE `zh_category`
  17. ADD COLUMN `spid` varchar(36) NOT NULL DEFAULT '' COMMENT '子项目id(uuid)' AFTER `pid`;
  18. ALTER TABLE `zh_category_value`
  19. ADD COLUMN `spid` varchar(36) NOT NULL DEFAULT '' COMMENT '子项目id(uuid)' AFTER `pid`;
  20. ALTER TABLE `zh_sub_project_permission`
  21. ADD COLUMN `self_category_level` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' AFTER `update_time`;
  22. ALTER TABLE `zh_project_log`
  23. ADD COLUMN `spid` varchar(36) NOT NULL DEFAULT '' COMMENT '操作子项目' AFTER `pid`;
  24. ALTER TABLE `zh_sub_project`
  25. MODIFY COLUMN `rela_tender` varchar(5000) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT '关联标段id(\',\'分隔)' AFTER `user_id`;
  26. ALTER TABLE `zh_budget`
  27. MODIFY COLUMN `rela_tender` varchar(5000) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT '关联标段id(\',\'分隔)' AFTER `std_id`;
  28. ALTER TABLE `zh_sub_project_permission`
  29. ADD COLUMN `info_permission` varchar(255) NOT NULL DEFAULT '' COMMENT '项目概况,权限id列表(\',\'分隔)' AFTER `self_category_level`,
  30. ADD COLUMN `fund_trans_permission` varchar(255) NOT NULL DEFAULT '' COMMENT '资金划拨,权限id列表(\',\'分隔)' AFTER `info_permission`,
  31. ADD COLUMN `fund_pay_permission` varchar(255) NOT NULL DEFAULT '' COMMENT '资金支付,权限id列表(\',\'分隔)' AFTER `fund_trans_permission`,
  32. ADD COLUMN `contract_permission` varchar(255) NOT NULL DEFAULT '' COMMENT '合同管理,权限id列表(\',\'分隔)' AFTER `fund_pay_permission`,
  33. ADD COLUMN `datacollect_permission` varchar(255) NOT NULL DEFAULT '' COMMENT '决策大屏,权限id列表(\',\'分隔)' AFTER `contract_permission`,
  34. ADD COLUMN `payment_permission` varchar(255) NOT NULL DEFAULT '' COMMENT '支付审批,权限id列表(\',\'分隔)' AFTER `datacollect_permission`;
  35. ALTER TABLE `zh_file_reference_list`
  36. ADD COLUMN `file_type` tinyint(4) UNSIGNED NOT NULL DEFAULT 1 COMMENT '文件类型' AFTER `remark`,
  37. ADD COLUMN `file_type_str` varchar(50) NOT NULL DEFAULT '资料归集' COMMENT '文件类型-文本' AFTER `file_type`;
  38. ALTER TABLE `zh_file_reference`
  39. MODIFY COLUMN `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '名称' AFTER `is_leaf`,
  40. ADD COLUMN `code` varchar(50) NOT NULL DEFAULT '' COMMENT '序号/编号' AFTER `name`,
  41. MODIFY COLUMN `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '备注' AFTER `name`;
  42. ALTER TABLE `zh_budget_std`
  43. ADD COLUMN `progress_template_id` varchar(255) NOT NULL DEFAULT '' COMMENT '项目概况-阶段进度-新建模板id列表(‘,’分隔)' AFTER `ht_tender_template_id`;
  44. ALTER TABLE `zh_project_col_set`
  45. ADD COLUMN `pid` int(11) NOT NULL DEFAULT 0 COMMENT 'zh_project.id' AFTER `id`,
  46. ADD COLUMN `spid` varchar(36) NOT NULL DEFAULT '' COMMENT 'zh_sub_project.id' AFTER `pid`,
  47. ADD COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `info`,
  48. ADD COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间' AFTER `create_time`;
  49. ALTER TABLE `zh_payment_tender`
  50. ADD COLUMN `spid` varchar(36) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '子项目id' AFTER `pid`;
  51. ALTER TABLE `zh_payment_folder`
  52. MODIFY COLUMN `id` varchar(36) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL FIRST,
  53. ADD COLUMN `spid` varchar(36) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '子项目id' AFTER `pid`,
  54. ADD COLUMN `folder_id` int(11) NOT NULL DEFAULT 0 COMMENT '节点id' AFTER `name`;
  55. ALTER TABLE `zh_tender`
  56. ADD COLUMN `filter_budget` tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '动态投资-是否过滤' AFTER `spid`,
  57. ADD COLUMN `filter_fund` tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '资金监管-是否过滤' AFTER `filter_budget`;
  58. ALTER TABLE `zh_notice`
  59. ADD COLUMN `spid` varchar(36) NULL DEFAULT '' COMMENT '子项目id' AFTER `pid`,
  60. ADD COLUMN `tid` int(11) NULL DEFAULT NULL COMMENT '标段id' AFTER `spid`;
  61. ALTER TABLE `zh_message`
  62. ADD COLUMN `spid` varchar(36) NULL DEFAULT '' COMMENT '子项目id' AFTER `project_id`;
  63. ALTER TABLE `zh_filing_template`
  64. ADD COLUMN `is_rela` tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '可否导入文件' AFTER `tips`;
  65. ALTER TABLE `zh_filing`
  66. ADD COLUMN `is_rela` tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '可否导入文件' AFTER `tips`;
  67. ALTER TABLE `zh_ledger_0`
  68. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  69. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  70. ALTER TABLE `zh_ledger_1`
  71. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  72. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  73. ALTER TABLE `zh_ledger_2`
  74. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  75. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  76. ALTER TABLE `zh_ledger_3`
  77. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  78. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  79. ALTER TABLE `zh_ledger_4`
  80. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  81. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  82. ALTER TABLE `zh_ledger_5`
  83. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  84. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  85. ALTER TABLE `zh_ledger_6`
  86. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  87. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  88. ALTER TABLE `zh_ledger_7`
  89. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  90. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  91. ALTER TABLE `zh_ledger_8`
  92. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  93. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  94. ALTER TABLE `zh_ledger_9`
  95. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  96. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  97. ALTER TABLE `zh_ledger_10`
  98. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  99. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  100. ALTER TABLE `zh_ledger_11`
  101. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  102. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  103. ALTER TABLE `zh_ledger_12`
  104. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  105. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  106. ALTER TABLE `zh_ledger_13`
  107. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  108. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  109. ALTER TABLE `zh_ledger_14`
  110. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  111. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  112. ALTER TABLE `zh_ledger_15`
  113. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  114. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  115. ALTER TABLE `zh_ledger_16`
  116. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  117. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  118. ALTER TABLE `zh_ledger_17`
  119. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  120. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  121. ALTER TABLE `zh_ledger_18`
  122. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  123. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  124. ALTER TABLE `zh_ledger_19`
  125. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  126. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  127. ALTER TABLE `zh_ledger_20`
  128. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  129. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  130. ALTER TABLE `zh_ledger_21`
  131. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  132. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  133. ALTER TABLE `zh_ledger_22`
  134. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  135. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  136. ALTER TABLE `zh_ledger_23`
  137. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  138. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  139. ALTER TABLE `zh_ledger_24`
  140. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  141. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  142. ALTER TABLE `zh_ledger_25`
  143. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  144. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  145. ALTER TABLE `zh_ledger_26`
  146. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  147. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  148. ALTER TABLE `zh_ledger_27`
  149. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  150. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  151. ALTER TABLE `zh_ledger_28`
  152. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  153. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  154. ALTER TABLE `zh_ledger_29`
  155. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  156. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  157. ALTER TABLE `zh_ledger_30`
  158. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  159. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  160. ALTER TABLE `zh_ledger_31`
  161. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  162. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  163. ALTER TABLE `zh_ledger_32`
  164. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  165. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  166. ALTER TABLE `zh_ledger_33`
  167. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  168. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  169. ALTER TABLE `zh_ledger_34`
  170. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  171. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  172. ALTER TABLE `zh_ledger_35`
  173. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  174. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  175. ALTER TABLE `zh_ledger_36`
  176. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  177. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  178. ALTER TABLE `zh_ledger_37`
  179. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  180. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  181. ALTER TABLE `zh_ledger_38`
  182. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  183. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  184. ALTER TABLE `zh_ledger_39`
  185. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  186. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  187. ALTER TABLE `zh_ledger_40`
  188. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  189. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  190. ALTER TABLE `zh_ledger_41`
  191. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  192. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  193. ALTER TABLE `zh_ledger_42`
  194. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  195. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  196. ALTER TABLE `zh_ledger_43`
  197. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  198. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  199. ALTER TABLE `zh_ledger_44`
  200. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  201. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  202. ALTER TABLE `zh_ledger_45`
  203. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  204. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  205. ALTER TABLE `zh_ledger_46`
  206. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  207. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  208. ALTER TABLE `zh_ledger_47`
  209. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  210. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  211. ALTER TABLE `zh_ledger_48`
  212. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  213. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  214. ALTER TABLE `zh_ledger_49`
  215. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  216. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  217. ALTER TABLE `zh_ledger_50`
  218. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  219. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  220. ALTER TABLE `zh_ledger_51`
  221. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  222. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  223. ALTER TABLE `zh_ledger_52`
  224. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  225. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  226. ALTER TABLE `zh_ledger_53`
  227. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  228. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  229. ALTER TABLE `zh_ledger_54`
  230. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  231. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  232. ALTER TABLE `zh_ledger_55`
  233. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  234. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  235. ALTER TABLE `zh_ledger_56`
  236. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  237. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  238. ALTER TABLE `zh_ledger_57`
  239. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  240. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  241. ALTER TABLE `zh_ledger_58`
  242. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  243. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  244. ALTER TABLE `zh_ledger_59`
  245. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  246. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  247. ALTER TABLE `zh_ledger_60`
  248. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  249. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  250. ALTER TABLE `zh_ledger_61`
  251. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  252. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  253. ALTER TABLE `zh_ledger_62`
  254. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  255. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  256. ALTER TABLE `zh_ledger_63`
  257. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  258. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  259. ALTER TABLE `zh_ledger_64`
  260. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  261. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  262. ALTER TABLE `zh_ledger_65`
  263. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  264. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  265. ALTER TABLE `zh_ledger_66`
  266. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  267. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  268. ALTER TABLE `zh_ledger_67`
  269. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  270. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  271. ALTER TABLE `zh_ledger_68`
  272. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  273. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  274. ALTER TABLE `zh_ledger_69`
  275. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  276. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  277. ALTER TABLE `zh_ledger_70`
  278. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  279. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  280. ALTER TABLE `zh_ledger_71`
  281. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  282. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  283. ALTER TABLE `zh_ledger_72`
  284. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  285. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  286. ALTER TABLE `zh_ledger_73`
  287. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  288. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  289. ALTER TABLE `zh_ledger_74`
  290. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  291. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  292. ALTER TABLE `zh_ledger_75`
  293. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  294. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  295. ALTER TABLE `zh_ledger_76`
  296. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  297. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  298. ALTER TABLE `zh_ledger_77`
  299. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  300. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  301. ALTER TABLE `zh_ledger_78`
  302. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  303. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  304. ALTER TABLE `zh_ledger_79`
  305. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  306. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  307. ALTER TABLE `zh_ledger_80`
  308. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  309. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  310. ALTER TABLE `zh_ledger_81`
  311. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  312. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  313. ALTER TABLE `zh_ledger_82`
  314. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  315. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  316. ALTER TABLE `zh_ledger_83`
  317. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  318. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  319. ALTER TABLE `zh_ledger_84`
  320. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  321. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  322. ALTER TABLE `zh_ledger_85`
  323. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  324. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  325. ALTER TABLE `zh_ledger_86`
  326. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  327. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  328. ALTER TABLE `zh_ledger_87`
  329. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  330. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  331. ALTER TABLE `zh_ledger_88`
  332. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  333. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  334. ALTER TABLE `zh_ledger_89`
  335. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  336. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  337. ALTER TABLE `zh_ledger_90`
  338. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  339. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  340. ALTER TABLE `zh_ledger_91`
  341. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  342. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  343. ALTER TABLE `zh_ledger_92`
  344. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  345. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  346. ALTER TABLE `zh_ledger_93`
  347. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  348. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  349. ALTER TABLE `zh_ledger_94`
  350. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  351. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  352. ALTER TABLE `zh_ledger_95`
  353. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  354. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  355. ALTER TABLE `zh_ledger_96`
  356. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  357. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  358. ALTER TABLE `zh_ledger_97`
  359. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  360. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  361. ALTER TABLE `zh_ledger_98`
  362. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  363. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  364. ALTER TABLE `zh_ledger_99`
  365. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  366. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  367. ALTER TABLE `zh_revise_bills_0`
  368. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  369. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  370. ALTER TABLE `zh_revise_bills_1`
  371. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  372. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  373. ALTER TABLE `zh_revise_bills_2`
  374. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  375. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  376. ALTER TABLE `zh_revise_bills_3`
  377. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  378. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  379. ALTER TABLE `zh_revise_bills_4`
  380. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  381. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  382. ALTER TABLE `zh_revise_bills_5`
  383. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  384. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  385. ALTER TABLE `zh_revise_bills_6`
  386. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  387. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  388. ALTER TABLE `zh_revise_bills_7`
  389. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  390. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  391. ALTER TABLE `zh_revise_bills_8`
  392. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  393. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  394. ALTER TABLE `zh_revise_bills_9`
  395. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  396. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  397. ALTER TABLE `zh_revise_bills_10`
  398. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  399. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  400. ALTER TABLE `zh_revise_bills_11`
  401. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  402. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  403. ALTER TABLE `zh_revise_bills_12`
  404. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  405. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  406. ALTER TABLE `zh_revise_bills_13`
  407. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  408. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  409. ALTER TABLE `zh_revise_bills_14`
  410. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  411. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  412. ALTER TABLE `zh_revise_bills_15`
  413. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  414. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  415. ALTER TABLE `zh_revise_bills_16`
  416. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  417. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  418. ALTER TABLE `zh_revise_bills_17`
  419. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  420. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  421. ALTER TABLE `zh_revise_bills_18`
  422. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  423. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  424. ALTER TABLE `zh_revise_bills_19`
  425. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  426. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  427. ALTER TABLE `zh_revise_bills_20`
  428. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  429. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  430. ALTER TABLE `zh_revise_bills_21`
  431. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  432. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  433. ALTER TABLE `zh_revise_bills_22`
  434. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  435. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  436. ALTER TABLE `zh_revise_bills_23`
  437. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  438. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  439. ALTER TABLE `zh_revise_bills_24`
  440. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  441. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  442. ALTER TABLE `zh_revise_bills_25`
  443. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  444. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  445. ALTER TABLE `zh_revise_bills_26`
  446. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  447. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  448. ALTER TABLE `zh_revise_bills_27`
  449. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  450. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  451. ALTER TABLE `zh_revise_bills_28`
  452. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  453. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  454. ALTER TABLE `zh_revise_bills_29`
  455. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  456. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  457. ALTER TABLE `zh_revise_bills_30`
  458. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  459. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  460. ALTER TABLE `zh_revise_bills_31`
  461. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  462. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  463. ALTER TABLE `zh_revise_bills_32`
  464. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  465. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  466. ALTER TABLE `zh_revise_bills_33`
  467. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  468. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  469. ALTER TABLE `zh_revise_bills_34`
  470. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  471. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  472. ALTER TABLE `zh_revise_bills_35`
  473. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  474. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  475. ALTER TABLE `zh_revise_bills_36`
  476. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  477. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  478. ALTER TABLE `zh_revise_bills_37`
  479. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  480. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  481. ALTER TABLE `zh_revise_bills_38`
  482. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  483. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  484. ALTER TABLE `zh_revise_bills_39`
  485. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  486. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  487. ALTER TABLE `zh_revise_bills_40`
  488. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  489. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  490. ALTER TABLE `zh_revise_bills_41`
  491. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  492. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  493. ALTER TABLE `zh_revise_bills_42`
  494. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  495. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  496. ALTER TABLE `zh_revise_bills_43`
  497. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  498. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  499. ALTER TABLE `zh_revise_bills_44`
  500. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  501. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  502. ALTER TABLE `zh_revise_bills_45`
  503. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  504. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  505. ALTER TABLE `zh_revise_bills_46`
  506. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  507. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  508. ALTER TABLE `zh_revise_bills_47`
  509. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  510. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  511. ALTER TABLE `zh_revise_bills_48`
  512. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  513. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  514. ALTER TABLE `zh_revise_bills_49`
  515. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  516. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  517. ALTER TABLE `zh_revise_bills_50`
  518. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  519. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  520. ALTER TABLE `zh_revise_bills_51`
  521. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  522. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  523. ALTER TABLE `zh_revise_bills_52`
  524. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  525. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  526. ALTER TABLE `zh_revise_bills_53`
  527. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  528. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  529. ALTER TABLE `zh_revise_bills_54`
  530. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  531. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  532. ALTER TABLE `zh_revise_bills_55`
  533. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  534. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  535. ALTER TABLE `zh_revise_bills_56`
  536. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  537. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  538. ALTER TABLE `zh_revise_bills_57`
  539. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  540. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  541. ALTER TABLE `zh_revise_bills_58`
  542. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  543. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  544. ALTER TABLE `zh_revise_bills_59`
  545. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  546. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  547. ALTER TABLE `zh_revise_bills_60`
  548. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  549. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  550. ALTER TABLE `zh_revise_bills_61`
  551. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  552. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  553. ALTER TABLE `zh_revise_bills_62`
  554. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  555. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  556. ALTER TABLE `zh_revise_bills_63`
  557. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  558. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  559. ALTER TABLE `zh_revise_bills_64`
  560. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  561. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  562. ALTER TABLE `zh_revise_bills_65`
  563. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  564. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  565. ALTER TABLE `zh_revise_bills_66`
  566. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  567. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  568. ALTER TABLE `zh_revise_bills_67`
  569. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  570. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  571. ALTER TABLE `zh_revise_bills_68`
  572. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  573. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  574. ALTER TABLE `zh_revise_bills_69`
  575. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  576. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  577. ALTER TABLE `zh_revise_bills_70`
  578. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  579. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  580. ALTER TABLE `zh_revise_bills_71`
  581. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  582. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  583. ALTER TABLE `zh_revise_bills_72`
  584. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  585. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  586. ALTER TABLE `zh_revise_bills_73`
  587. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  588. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  589. ALTER TABLE `zh_revise_bills_74`
  590. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  591. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  592. ALTER TABLE `zh_revise_bills_75`
  593. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  594. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  595. ALTER TABLE `zh_revise_bills_76`
  596. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  597. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  598. ALTER TABLE `zh_revise_bills_77`
  599. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  600. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  601. ALTER TABLE `zh_revise_bills_78`
  602. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  603. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  604. ALTER TABLE `zh_revise_bills_79`
  605. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  606. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  607. ALTER TABLE `zh_revise_bills_80`
  608. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  609. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  610. ALTER TABLE `zh_revise_bills_81`
  611. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  612. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  613. ALTER TABLE `zh_revise_bills_82`
  614. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  615. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  616. ALTER TABLE `zh_revise_bills_83`
  617. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  618. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  619. ALTER TABLE `zh_revise_bills_84`
  620. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  621. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  622. ALTER TABLE `zh_revise_bills_85`
  623. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  624. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  625. ALTER TABLE `zh_revise_bills_86`
  626. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  627. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  628. ALTER TABLE `zh_revise_bills_87`
  629. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  630. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  631. ALTER TABLE `zh_revise_bills_88`
  632. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  633. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  634. ALTER TABLE `zh_revise_bills_89`
  635. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  636. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  637. ALTER TABLE `zh_revise_bills_90`
  638. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  639. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  640. ALTER TABLE `zh_revise_bills_91`
  641. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  642. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  643. ALTER TABLE `zh_revise_bills_92`
  644. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  645. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  646. ALTER TABLE `zh_revise_bills_93`
  647. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  648. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  649. ALTER TABLE `zh_revise_bills_94`
  650. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  651. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  652. ALTER TABLE `zh_revise_bills_95`
  653. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  654. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  655. ALTER TABLE `zh_revise_bills_96`
  656. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  657. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  658. ALTER TABLE `zh_revise_bills_97`
  659. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  660. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  661. ALTER TABLE `zh_revise_bills_98`
  662. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  663. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  664. ALTER TABLE `zh_revise_bills_99`
  665. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  666. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  667. ALTER TABLE `zh_change_ledger`
  668. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
  669. ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
  670. ALTER TABLE `zh_pos_0`
  671. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  672. ALTER TABLE `zh_pos_1`
  673. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  674. ALTER TABLE `zh_pos_2`
  675. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  676. ALTER TABLE `zh_pos_3`
  677. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  678. ALTER TABLE `zh_pos_4`
  679. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  680. ALTER TABLE `zh_pos_5`
  681. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  682. ALTER TABLE `zh_pos_6`
  683. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  684. ALTER TABLE `zh_pos_7`
  685. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  686. ALTER TABLE `zh_pos_8`
  687. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  688. ALTER TABLE `zh_pos_9`
  689. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  690. ALTER TABLE `zh_pos_10`
  691. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  692. ALTER TABLE `zh_pos_11`
  693. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  694. ALTER TABLE `zh_pos_12`
  695. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  696. ALTER TABLE `zh_pos_13`
  697. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  698. ALTER TABLE `zh_pos_14`
  699. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  700. ALTER TABLE `zh_pos_15`
  701. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  702. ALTER TABLE `zh_pos_16`
  703. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  704. ALTER TABLE `zh_pos_17`
  705. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  706. ALTER TABLE `zh_pos_18`
  707. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  708. ALTER TABLE `zh_pos_19`
  709. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  710. ALTER TABLE `zh_pos_20`
  711. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  712. ALTER TABLE `zh_pos_21`
  713. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  714. ALTER TABLE `zh_pos_22`
  715. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  716. ALTER TABLE `zh_pos_23`
  717. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  718. ALTER TABLE `zh_pos_24`
  719. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  720. ALTER TABLE `zh_pos_25`
  721. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  722. ALTER TABLE `zh_pos_26`
  723. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  724. ALTER TABLE `zh_pos_27`
  725. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  726. ALTER TABLE `zh_pos_28`
  727. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  728. ALTER TABLE `zh_pos_29`
  729. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  730. ALTER TABLE `zh_pos_30`
  731. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  732. ALTER TABLE `zh_pos_31`
  733. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  734. ALTER TABLE `zh_pos_32`
  735. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  736. ALTER TABLE `zh_pos_33`
  737. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  738. ALTER TABLE `zh_pos_34`
  739. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  740. ALTER TABLE `zh_pos_35`
  741. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  742. ALTER TABLE `zh_pos_36`
  743. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  744. ALTER TABLE `zh_pos_37`
  745. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  746. ALTER TABLE `zh_pos_38`
  747. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  748. ALTER TABLE `zh_pos_39`
  749. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  750. ALTER TABLE `zh_pos_40`
  751. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  752. ALTER TABLE `zh_pos_41`
  753. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  754. ALTER TABLE `zh_pos_42`
  755. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  756. ALTER TABLE `zh_pos_43`
  757. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  758. ALTER TABLE `zh_pos_44`
  759. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  760. ALTER TABLE `zh_pos_45`
  761. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  762. ALTER TABLE `zh_pos_46`
  763. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  764. ALTER TABLE `zh_pos_47`
  765. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  766. ALTER TABLE `zh_pos_48`
  767. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  768. ALTER TABLE `zh_pos_49`
  769. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  770. ALTER TABLE `zh_pos_50`
  771. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  772. ALTER TABLE `zh_pos_51`
  773. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  774. ALTER TABLE `zh_pos_52`
  775. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  776. ALTER TABLE `zh_pos_53`
  777. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  778. ALTER TABLE `zh_pos_54`
  779. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  780. ALTER TABLE `zh_pos_55`
  781. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  782. ALTER TABLE `zh_pos_56`
  783. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  784. ALTER TABLE `zh_pos_57`
  785. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  786. ALTER TABLE `zh_pos_58`
  787. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  788. ALTER TABLE `zh_pos_59`
  789. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  790. ALTER TABLE `zh_pos_60`
  791. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  792. ALTER TABLE `zh_pos_61`
  793. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  794. ALTER TABLE `zh_pos_62`
  795. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  796. ALTER TABLE `zh_pos_63`
  797. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  798. ALTER TABLE `zh_pos_64`
  799. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  800. ALTER TABLE `zh_pos_65`
  801. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  802. ALTER TABLE `zh_pos_66`
  803. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  804. ALTER TABLE `zh_pos_67`
  805. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  806. ALTER TABLE `zh_pos_68`
  807. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  808. ALTER TABLE `zh_pos_69`
  809. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  810. ALTER TABLE `zh_pos_70`
  811. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  812. ALTER TABLE `zh_pos_71`
  813. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  814. ALTER TABLE `zh_pos_72`
  815. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  816. ALTER TABLE `zh_pos_73`
  817. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  818. ALTER TABLE `zh_pos_74`
  819. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  820. ALTER TABLE `zh_pos_75`
  821. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  822. ALTER TABLE `zh_pos_76`
  823. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  824. ALTER TABLE `zh_pos_77`
  825. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  826. ALTER TABLE `zh_pos_78`
  827. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  828. ALTER TABLE `zh_pos_79`
  829. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  830. ALTER TABLE `zh_pos_80`
  831. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  832. ALTER TABLE `zh_pos_81`
  833. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  834. ALTER TABLE `zh_pos_82`
  835. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  836. ALTER TABLE `zh_pos_83`
  837. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  838. ALTER TABLE `zh_pos_84`
  839. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  840. ALTER TABLE `zh_pos_85`
  841. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  842. ALTER TABLE `zh_pos_86`
  843. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  844. ALTER TABLE `zh_pos_87`
  845. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  846. ALTER TABLE `zh_pos_88`
  847. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  848. ALTER TABLE `zh_pos_89`
  849. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  850. ALTER TABLE `zh_pos_90`
  851. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  852. ALTER TABLE `zh_pos_91`
  853. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  854. ALTER TABLE `zh_pos_92`
  855. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  856. ALTER TABLE `zh_pos_93`
  857. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  858. ALTER TABLE `zh_pos_94`
  859. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  860. ALTER TABLE `zh_pos_95`
  861. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  862. ALTER TABLE `zh_pos_96`
  863. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  864. ALTER TABLE `zh_pos_97`
  865. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  866. ALTER TABLE `zh_pos_98`
  867. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  868. ALTER TABLE `zh_pos_99`
  869. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  870. ALTER TABLE `zh_revise_pos_0`
  871. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  872. ALTER TABLE `zh_revise_pos_1`
  873. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  874. ALTER TABLE `zh_revise_pos_2`
  875. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  876. ALTER TABLE `zh_revise_pos_3`
  877. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  878. ALTER TABLE `zh_revise_pos_4`
  879. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  880. ALTER TABLE `zh_revise_pos_5`
  881. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  882. ALTER TABLE `zh_revise_pos_6`
  883. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  884. ALTER TABLE `zh_revise_pos_7`
  885. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  886. ALTER TABLE `zh_revise_pos_8`
  887. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  888. ALTER TABLE `zh_revise_pos_9`
  889. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  890. ALTER TABLE `zh_revise_pos_10`
  891. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  892. ALTER TABLE `zh_revise_pos_11`
  893. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  894. ALTER TABLE `zh_revise_pos_12`
  895. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  896. ALTER TABLE `zh_revise_pos_13`
  897. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  898. ALTER TABLE `zh_revise_pos_14`
  899. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  900. ALTER TABLE `zh_revise_pos_15`
  901. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  902. ALTER TABLE `zh_revise_pos_16`
  903. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  904. ALTER TABLE `zh_revise_pos_17`
  905. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  906. ALTER TABLE `zh_revise_pos_18`
  907. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  908. ALTER TABLE `zh_revise_pos_19`
  909. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  910. ALTER TABLE `zh_revise_pos_20`
  911. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  912. ALTER TABLE `zh_revise_pos_21`
  913. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  914. ALTER TABLE `zh_revise_pos_22`
  915. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  916. ALTER TABLE `zh_revise_pos_23`
  917. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  918. ALTER TABLE `zh_revise_pos_24`
  919. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  920. ALTER TABLE `zh_revise_pos_25`
  921. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  922. ALTER TABLE `zh_revise_pos_26`
  923. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  924. ALTER TABLE `zh_revise_pos_27`
  925. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  926. ALTER TABLE `zh_revise_pos_28`
  927. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  928. ALTER TABLE `zh_revise_pos_29`
  929. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  930. ALTER TABLE `zh_revise_pos_30`
  931. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  932. ALTER TABLE `zh_revise_pos_31`
  933. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  934. ALTER TABLE `zh_revise_pos_32`
  935. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  936. ALTER TABLE `zh_revise_pos_33`
  937. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  938. ALTER TABLE `zh_revise_pos_34`
  939. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  940. ALTER TABLE `zh_revise_pos_35`
  941. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  942. ALTER TABLE `zh_revise_pos_36`
  943. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  944. ALTER TABLE `zh_revise_pos_37`
  945. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  946. ALTER TABLE `zh_revise_pos_38`
  947. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  948. ALTER TABLE `zh_revise_pos_39`
  949. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  950. ALTER TABLE `zh_revise_pos_40`
  951. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  952. ALTER TABLE `zh_revise_pos_41`
  953. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  954. ALTER TABLE `zh_revise_pos_42`
  955. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  956. ALTER TABLE `zh_revise_pos_43`
  957. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  958. ALTER TABLE `zh_revise_pos_44`
  959. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  960. ALTER TABLE `zh_revise_pos_45`
  961. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  962. ALTER TABLE `zh_revise_pos_46`
  963. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  964. ALTER TABLE `zh_revise_pos_47`
  965. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  966. ALTER TABLE `zh_revise_pos_48`
  967. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  968. ALTER TABLE `zh_revise_pos_49`
  969. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  970. ALTER TABLE `zh_revise_pos_50`
  971. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  972. ALTER TABLE `zh_revise_pos_51`
  973. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  974. ALTER TABLE `zh_revise_pos_52`
  975. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  976. ALTER TABLE `zh_revise_pos_53`
  977. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  978. ALTER TABLE `zh_revise_pos_54`
  979. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  980. ALTER TABLE `zh_revise_pos_55`
  981. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  982. ALTER TABLE `zh_revise_pos_56`
  983. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  984. ALTER TABLE `zh_revise_pos_57`
  985. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  986. ALTER TABLE `zh_revise_pos_58`
  987. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  988. ALTER TABLE `zh_revise_pos_59`
  989. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  990. ALTER TABLE `zh_revise_pos_60`
  991. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  992. ALTER TABLE `zh_revise_pos_61`
  993. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  994. ALTER TABLE `zh_revise_pos_62`
  995. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  996. ALTER TABLE `zh_revise_pos_63`
  997. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  998. ALTER TABLE `zh_revise_pos_64`
  999. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  1000. ALTER TABLE `zh_revise_pos_65`
  1001. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  1002. ALTER TABLE `zh_revise_pos_66`
  1003. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  1004. ALTER TABLE `zh_revise_pos_67`
  1005. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  1006. ALTER TABLE `zh_revise_pos_68`
  1007. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  1008. ALTER TABLE `zh_revise_pos_69`
  1009. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  1010. ALTER TABLE `zh_revise_pos_70`
  1011. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  1012. ALTER TABLE `zh_revise_pos_71`
  1013. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  1014. ALTER TABLE `zh_revise_pos_72`
  1015. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  1016. ALTER TABLE `zh_revise_pos_73`
  1017. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  1018. ALTER TABLE `zh_revise_pos_74`
  1019. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  1020. ALTER TABLE `zh_revise_pos_75`
  1021. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  1022. ALTER TABLE `zh_revise_pos_76`
  1023. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  1024. ALTER TABLE `zh_revise_pos_77`
  1025. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  1026. ALTER TABLE `zh_revise_pos_78`
  1027. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  1028. ALTER TABLE `zh_revise_pos_79`
  1029. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  1030. ALTER TABLE `zh_revise_pos_80`
  1031. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  1032. ALTER TABLE `zh_revise_pos_81`
  1033. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  1034. ALTER TABLE `zh_revise_pos_82`
  1035. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  1036. ALTER TABLE `zh_revise_pos_83`
  1037. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  1038. ALTER TABLE `zh_revise_pos_84`
  1039. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  1040. ALTER TABLE `zh_revise_pos_85`
  1041. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  1042. ALTER TABLE `zh_revise_pos_86`
  1043. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  1044. ALTER TABLE `zh_revise_pos_87`
  1045. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  1046. ALTER TABLE `zh_revise_pos_88`
  1047. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  1048. ALTER TABLE `zh_revise_pos_89`
  1049. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  1050. ALTER TABLE `zh_revise_pos_90`
  1051. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  1052. ALTER TABLE `zh_revise_pos_91`
  1053. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  1054. ALTER TABLE `zh_revise_pos_92`
  1055. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  1056. ALTER TABLE `zh_revise_pos_93`
  1057. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  1058. ALTER TABLE `zh_revise_pos_94`
  1059. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  1060. ALTER TABLE `zh_revise_pos_95`
  1061. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  1062. ALTER TABLE `zh_revise_pos_96`
  1063. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  1064. ALTER TABLE `zh_revise_pos_97`
  1065. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  1066. ALTER TABLE `zh_revise_pos_98`
  1067. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  1068. ALTER TABLE `zh_revise_pos_99`
  1069. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  1070. ALTER TABLE `zh_change_pos`
  1071. ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
  1072. ALTER TABLE `zh_stage_bills_0`
  1073. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1074. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1075. ALTER TABLE `zh_stage_bills_1`
  1076. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1077. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1078. ALTER TABLE `zh_stage_bills_2`
  1079. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1080. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1081. ALTER TABLE `zh_stage_bills_3`
  1082. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1083. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1084. ALTER TABLE `zh_stage_bills_4`
  1085. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1086. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1087. ALTER TABLE `zh_stage_bills_5`
  1088. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1089. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1090. ALTER TABLE `zh_stage_bills_6`
  1091. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1092. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1093. ALTER TABLE `zh_stage_bills_7`
  1094. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1095. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1096. ALTER TABLE `zh_stage_bills_8`
  1097. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1098. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1099. ALTER TABLE `zh_stage_bills_9`
  1100. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1101. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1102. ALTER TABLE `zh_stage_bills_10`
  1103. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1104. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1105. ALTER TABLE `zh_stage_bills_11`
  1106. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1107. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1108. ALTER TABLE `zh_stage_bills_12`
  1109. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1110. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1111. ALTER TABLE `zh_stage_bills_13`
  1112. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1113. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1114. ALTER TABLE `zh_stage_bills_14`
  1115. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1116. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1117. ALTER TABLE `zh_stage_bills_15`
  1118. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1119. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1120. ALTER TABLE `zh_stage_bills_16`
  1121. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1122. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1123. ALTER TABLE `zh_stage_bills_17`
  1124. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1125. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1126. ALTER TABLE `zh_stage_bills_18`
  1127. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1128. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1129. ALTER TABLE `zh_stage_bills_19`
  1130. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1131. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1132. ALTER TABLE `zh_stage_bills_20`
  1133. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1134. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1135. ALTER TABLE `zh_stage_bills_21`
  1136. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1137. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1138. ALTER TABLE `zh_stage_bills_22`
  1139. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1140. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1141. ALTER TABLE `zh_stage_bills_23`
  1142. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1143. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1144. ALTER TABLE `zh_stage_bills_24`
  1145. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1146. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1147. ALTER TABLE `zh_stage_bills_25`
  1148. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1149. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1150. ALTER TABLE `zh_stage_bills_26`
  1151. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1152. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1153. ALTER TABLE `zh_stage_bills_27`
  1154. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1155. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1156. ALTER TABLE `zh_stage_bills_28`
  1157. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1158. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1159. ALTER TABLE `zh_stage_bills_29`
  1160. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1161. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1162. ALTER TABLE `zh_stage_bills_30`
  1163. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1164. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1165. ALTER TABLE `zh_stage_bills_31`
  1166. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1167. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1168. ALTER TABLE `zh_stage_bills_32`
  1169. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1170. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1171. ALTER TABLE `zh_stage_bills_33`
  1172. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1173. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1174. ALTER TABLE `zh_stage_bills_34`
  1175. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1176. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1177. ALTER TABLE `zh_stage_bills_35`
  1178. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1179. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1180. ALTER TABLE `zh_stage_bills_36`
  1181. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1182. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1183. ALTER TABLE `zh_stage_bills_37`
  1184. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1185. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1186. ALTER TABLE `zh_stage_bills_38`
  1187. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1188. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1189. ALTER TABLE `zh_stage_bills_39`
  1190. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1191. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1192. ALTER TABLE `zh_stage_bills_40`
  1193. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1194. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1195. ALTER TABLE `zh_stage_bills_41`
  1196. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1197. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1198. ALTER TABLE `zh_stage_bills_42`
  1199. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1200. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1201. ALTER TABLE `zh_stage_bills_43`
  1202. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1203. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1204. ALTER TABLE `zh_stage_bills_44`
  1205. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1206. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1207. ALTER TABLE `zh_stage_bills_45`
  1208. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1209. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1210. ALTER TABLE `zh_stage_bills_46`
  1211. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1212. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1213. ALTER TABLE `zh_stage_bills_47`
  1214. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1215. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1216. ALTER TABLE `zh_stage_bills_48`
  1217. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1218. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1219. ALTER TABLE `zh_stage_bills_49`
  1220. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1221. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1222. ALTER TABLE `zh_stage_bills_50`
  1223. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1224. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1225. ALTER TABLE `zh_stage_bills_51`
  1226. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1227. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1228. ALTER TABLE `zh_stage_bills_52`
  1229. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1230. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1231. ALTER TABLE `zh_stage_bills_53`
  1232. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1233. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1234. ALTER TABLE `zh_stage_bills_54`
  1235. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1236. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1237. ALTER TABLE `zh_stage_bills_55`
  1238. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1239. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1240. ALTER TABLE `zh_stage_bills_56`
  1241. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1242. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1243. ALTER TABLE `zh_stage_bills_57`
  1244. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1245. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1246. ALTER TABLE `zh_stage_bills_58`
  1247. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1248. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1249. ALTER TABLE `zh_stage_bills_59`
  1250. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1251. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1252. ALTER TABLE `zh_stage_bills_60`
  1253. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1254. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1255. ALTER TABLE `zh_stage_bills_61`
  1256. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1257. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1258. ALTER TABLE `zh_stage_bills_62`
  1259. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1260. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1261. ALTER TABLE `zh_stage_bills_63`
  1262. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1263. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1264. ALTER TABLE `zh_stage_bills_64`
  1265. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1266. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1267. ALTER TABLE `zh_stage_bills_65`
  1268. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1269. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1270. ALTER TABLE `zh_stage_bills_66`
  1271. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1272. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1273. ALTER TABLE `zh_stage_bills_67`
  1274. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1275. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1276. ALTER TABLE `zh_stage_bills_68`
  1277. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1278. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1279. ALTER TABLE `zh_stage_bills_69`
  1280. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1281. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1282. ALTER TABLE `zh_stage_bills_70`
  1283. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1284. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1285. ALTER TABLE `zh_stage_bills_71`
  1286. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1287. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1288. ALTER TABLE `zh_stage_bills_72`
  1289. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1290. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1291. ALTER TABLE `zh_stage_bills_73`
  1292. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1293. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1294. ALTER TABLE `zh_stage_bills_74`
  1295. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1296. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1297. ALTER TABLE `zh_stage_bills_75`
  1298. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1299. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1300. ALTER TABLE `zh_stage_bills_76`
  1301. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1302. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1303. ALTER TABLE `zh_stage_bills_77`
  1304. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1305. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1306. ALTER TABLE `zh_stage_bills_78`
  1307. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1308. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1309. ALTER TABLE `zh_stage_bills_79`
  1310. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1311. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1312. ALTER TABLE `zh_stage_bills_80`
  1313. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1314. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1315. ALTER TABLE `zh_stage_bills_81`
  1316. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1317. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1318. ALTER TABLE `zh_stage_bills_82`
  1319. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1320. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1321. ALTER TABLE `zh_stage_bills_83`
  1322. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1323. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1324. ALTER TABLE `zh_stage_bills_84`
  1325. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1326. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1327. ALTER TABLE `zh_stage_bills_85`
  1328. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1329. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1330. ALTER TABLE `zh_stage_bills_86`
  1331. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1332. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1333. ALTER TABLE `zh_stage_bills_87`
  1334. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1335. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1336. ALTER TABLE `zh_stage_bills_88`
  1337. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1338. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1339. ALTER TABLE `zh_stage_bills_89`
  1340. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1341. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1342. ALTER TABLE `zh_stage_bills_90`
  1343. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1344. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1345. ALTER TABLE `zh_stage_bills_91`
  1346. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1347. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1348. ALTER TABLE `zh_stage_bills_92`
  1349. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1350. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1351. ALTER TABLE `zh_stage_bills_93`
  1352. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1353. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1354. ALTER TABLE `zh_stage_bills_94`
  1355. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1356. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1357. ALTER TABLE `zh_stage_bills_95`
  1358. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1359. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1360. ALTER TABLE `zh_stage_bills_96`
  1361. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1362. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1363. ALTER TABLE `zh_stage_bills_97`
  1364. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1365. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1366. ALTER TABLE `zh_stage_bills_98`
  1367. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1368. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1369. ALTER TABLE `zh_stage_bills_99`
  1370. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
  1371. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1372. ALTER TABLE `zh_stage_bills_final_0`
  1373. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1374. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1375. ALTER TABLE `zh_stage_bills_final_1`
  1376. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1377. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1378. ALTER TABLE `zh_stage_bills_final_2`
  1379. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1380. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1381. ALTER TABLE `zh_stage_bills_final_3`
  1382. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1383. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1384. ALTER TABLE `zh_stage_bills_final_4`
  1385. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1386. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1387. ALTER TABLE `zh_stage_bills_final_5`
  1388. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1389. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1390. ALTER TABLE `zh_stage_bills_final_6`
  1391. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1392. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1393. ALTER TABLE `zh_stage_bills_final_7`
  1394. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1395. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1396. ALTER TABLE `zh_stage_bills_final_8`
  1397. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1398. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1399. ALTER TABLE `zh_stage_bills_final_9`
  1400. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1401. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1402. ALTER TABLE `zh_stage_bills_final_10`
  1403. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1404. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1405. ALTER TABLE `zh_stage_bills_final_11`
  1406. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1407. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1408. ALTER TABLE `zh_stage_bills_final_12`
  1409. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1410. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1411. ALTER TABLE `zh_stage_bills_final_13`
  1412. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1413. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1414. ALTER TABLE `zh_stage_bills_final_14`
  1415. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1416. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1417. ALTER TABLE `zh_stage_bills_final_15`
  1418. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1419. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1420. ALTER TABLE `zh_stage_bills_final_16`
  1421. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1422. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1423. ALTER TABLE `zh_stage_bills_final_17`
  1424. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1425. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1426. ALTER TABLE `zh_stage_bills_final_18`
  1427. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1428. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1429. ALTER TABLE `zh_stage_bills_final_19`
  1430. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1431. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1432. ALTER TABLE `zh_stage_bills_final_20`
  1433. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1434. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1435. ALTER TABLE `zh_stage_bills_final_21`
  1436. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1437. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1438. ALTER TABLE `zh_stage_bills_final_22`
  1439. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1440. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1441. ALTER TABLE `zh_stage_bills_final_23`
  1442. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1443. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1444. ALTER TABLE `zh_stage_bills_final_24`
  1445. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1446. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1447. ALTER TABLE `zh_stage_bills_final_25`
  1448. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1449. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1450. ALTER TABLE `zh_stage_bills_final_26`
  1451. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1452. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1453. ALTER TABLE `zh_stage_bills_final_27`
  1454. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1455. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1456. ALTER TABLE `zh_stage_bills_final_28`
  1457. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1458. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1459. ALTER TABLE `zh_stage_bills_final_29`
  1460. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1461. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1462. ALTER TABLE `zh_stage_bills_final_30`
  1463. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1464. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1465. ALTER TABLE `zh_stage_bills_final_31`
  1466. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1467. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1468. ALTER TABLE `zh_stage_bills_final_32`
  1469. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1470. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1471. ALTER TABLE `zh_stage_bills_final_33`
  1472. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1473. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1474. ALTER TABLE `zh_stage_bills_final_34`
  1475. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1476. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1477. ALTER TABLE `zh_stage_bills_final_35`
  1478. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1479. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1480. ALTER TABLE `zh_stage_bills_final_36`
  1481. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1482. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1483. ALTER TABLE `zh_stage_bills_final_37`
  1484. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1485. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1486. ALTER TABLE `zh_stage_bills_final_38`
  1487. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1488. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1489. ALTER TABLE `zh_stage_bills_final_39`
  1490. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1491. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1492. ALTER TABLE `zh_stage_bills_final_40`
  1493. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1494. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1495. ALTER TABLE `zh_stage_bills_final_41`
  1496. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1497. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1498. ALTER TABLE `zh_stage_bills_final_42`
  1499. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1500. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1501. ALTER TABLE `zh_stage_bills_final_43`
  1502. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1503. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1504. ALTER TABLE `zh_stage_bills_final_44`
  1505. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1506. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1507. ALTER TABLE `zh_stage_bills_final_45`
  1508. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1509. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1510. ALTER TABLE `zh_stage_bills_final_46`
  1511. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1512. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1513. ALTER TABLE `zh_stage_bills_final_47`
  1514. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1515. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1516. ALTER TABLE `zh_stage_bills_final_48`
  1517. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1518. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1519. ALTER TABLE `zh_stage_bills_final_49`
  1520. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1521. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1522. ALTER TABLE `zh_stage_bills_final_50`
  1523. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1524. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1525. ALTER TABLE `zh_stage_bills_final_51`
  1526. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1527. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1528. ALTER TABLE `zh_stage_bills_final_52`
  1529. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1530. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1531. ALTER TABLE `zh_stage_bills_final_53`
  1532. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1533. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1534. ALTER TABLE `zh_stage_bills_final_54`
  1535. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1536. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1537. ALTER TABLE `zh_stage_bills_final_55`
  1538. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1539. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1540. ALTER TABLE `zh_stage_bills_final_56`
  1541. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1542. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1543. ALTER TABLE `zh_stage_bills_final_57`
  1544. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1545. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1546. ALTER TABLE `zh_stage_bills_final_58`
  1547. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1548. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1549. ALTER TABLE `zh_stage_bills_final_59`
  1550. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1551. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1552. ALTER TABLE `zh_stage_bills_final_60`
  1553. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1554. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1555. ALTER TABLE `zh_stage_bills_final_61`
  1556. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1557. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1558. ALTER TABLE `zh_stage_bills_final_62`
  1559. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1560. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1561. ALTER TABLE `zh_stage_bills_final_63`
  1562. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1563. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1564. ALTER TABLE `zh_stage_bills_final_64`
  1565. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1566. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1567. ALTER TABLE `zh_stage_bills_final_65`
  1568. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1569. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1570. ALTER TABLE `zh_stage_bills_final_66`
  1571. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1572. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1573. ALTER TABLE `zh_stage_bills_final_67`
  1574. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1575. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1576. ALTER TABLE `zh_stage_bills_final_68`
  1577. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1578. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1579. ALTER TABLE `zh_stage_bills_final_69`
  1580. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1581. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1582. ALTER TABLE `zh_stage_bills_final_70`
  1583. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1584. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1585. ALTER TABLE `zh_stage_bills_final_71`
  1586. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1587. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1588. ALTER TABLE `zh_stage_bills_final_72`
  1589. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1590. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1591. ALTER TABLE `zh_stage_bills_final_73`
  1592. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1593. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1594. ALTER TABLE `zh_stage_bills_final_74`
  1595. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1596. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1597. ALTER TABLE `zh_stage_bills_final_75`
  1598. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1599. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1600. ALTER TABLE `zh_stage_bills_final_76`
  1601. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1602. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1603. ALTER TABLE `zh_stage_bills_final_77`
  1604. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1605. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1606. ALTER TABLE `zh_stage_bills_final_78`
  1607. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1608. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1609. ALTER TABLE `zh_stage_bills_final_79`
  1610. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1611. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1612. ALTER TABLE `zh_stage_bills_final_80`
  1613. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1614. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1615. ALTER TABLE `zh_stage_bills_final_81`
  1616. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1617. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1618. ALTER TABLE `zh_stage_bills_final_82`
  1619. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1620. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1621. ALTER TABLE `zh_stage_bills_final_83`
  1622. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1623. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1624. ALTER TABLE `zh_stage_bills_final_84`
  1625. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1626. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1627. ALTER TABLE `zh_stage_bills_final_85`
  1628. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1629. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1630. ALTER TABLE `zh_stage_bills_final_86`
  1631. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1632. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1633. ALTER TABLE `zh_stage_bills_final_87`
  1634. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1635. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1636. ALTER TABLE `zh_stage_bills_final_88`
  1637. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1638. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1639. ALTER TABLE `zh_stage_bills_final_89`
  1640. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1641. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1642. ALTER TABLE `zh_stage_bills_final_90`
  1643. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1644. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1645. ALTER TABLE `zh_stage_bills_final_91`
  1646. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1647. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1648. ALTER TABLE `zh_stage_bills_final_92`
  1649. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1650. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1651. ALTER TABLE `zh_stage_bills_final_93`
  1652. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1653. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1654. ALTER TABLE `zh_stage_bills_final_94`
  1655. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1656. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1657. ALTER TABLE `zh_stage_bills_final_95`
  1658. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1659. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1660. ALTER TABLE `zh_stage_bills_final_96`
  1661. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1662. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1663. ALTER TABLE `zh_stage_bills_final_97`
  1664. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1665. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1666. ALTER TABLE `zh_stage_bills_final_98`
  1667. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1668. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1669. ALTER TABLE `zh_stage_bills_final_99`
  1670. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
  1671. ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
  1672. ALTER TABLE `zh_stage_pos_0`
  1673. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1674. ALTER TABLE `zh_stage_pos_1`
  1675. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1676. ALTER TABLE `zh_stage_pos_2`
  1677. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1678. ALTER TABLE `zh_stage_pos_3`
  1679. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1680. ALTER TABLE `zh_stage_pos_4`
  1681. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1682. ALTER TABLE `zh_stage_pos_5`
  1683. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1684. ALTER TABLE `zh_stage_pos_6`
  1685. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1686. ALTER TABLE `zh_stage_pos_7`
  1687. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1688. ALTER TABLE `zh_stage_pos_8`
  1689. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1690. ALTER TABLE `zh_stage_pos_9`
  1691. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1692. ALTER TABLE `zh_stage_pos_10`
  1693. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1694. ALTER TABLE `zh_stage_pos_11`
  1695. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1696. ALTER TABLE `zh_stage_pos_12`
  1697. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1698. ALTER TABLE `zh_stage_pos_13`
  1699. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1700. ALTER TABLE `zh_stage_pos_14`
  1701. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1702. ALTER TABLE `zh_stage_pos_15`
  1703. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1704. ALTER TABLE `zh_stage_pos_16`
  1705. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1706. ALTER TABLE `zh_stage_pos_17`
  1707. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1708. ALTER TABLE `zh_stage_pos_18`
  1709. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1710. ALTER TABLE `zh_stage_pos_19`
  1711. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1712. ALTER TABLE `zh_stage_pos_20`
  1713. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1714. ALTER TABLE `zh_stage_pos_21`
  1715. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1716. ALTER TABLE `zh_stage_pos_22`
  1717. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1718. ALTER TABLE `zh_stage_pos_23`
  1719. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1720. ALTER TABLE `zh_stage_pos_24`
  1721. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1722. ALTER TABLE `zh_stage_pos_25`
  1723. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1724. ALTER TABLE `zh_stage_pos_26`
  1725. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1726. ALTER TABLE `zh_stage_pos_27`
  1727. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1728. ALTER TABLE `zh_stage_pos_28`
  1729. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1730. ALTER TABLE `zh_stage_pos_29`
  1731. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1732. ALTER TABLE `zh_stage_pos_30`
  1733. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1734. ALTER TABLE `zh_stage_pos_31`
  1735. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1736. ALTER TABLE `zh_stage_pos_32`
  1737. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1738. ALTER TABLE `zh_stage_pos_33`
  1739. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1740. ALTER TABLE `zh_stage_pos_34`
  1741. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1742. ALTER TABLE `zh_stage_pos_35`
  1743. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1744. ALTER TABLE `zh_stage_pos_36`
  1745. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1746. ALTER TABLE `zh_stage_pos_37`
  1747. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1748. ALTER TABLE `zh_stage_pos_38`
  1749. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1750. ALTER TABLE `zh_stage_pos_39`
  1751. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1752. ALTER TABLE `zh_stage_pos_40`
  1753. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1754. ALTER TABLE `zh_stage_pos_41`
  1755. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1756. ALTER TABLE `zh_stage_pos_42`
  1757. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1758. ALTER TABLE `zh_stage_pos_43`
  1759. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1760. ALTER TABLE `zh_stage_pos_44`
  1761. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1762. ALTER TABLE `zh_stage_pos_45`
  1763. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1764. ALTER TABLE `zh_stage_pos_46`
  1765. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1766. ALTER TABLE `zh_stage_pos_47`
  1767. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1768. ALTER TABLE `zh_stage_pos_48`
  1769. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1770. ALTER TABLE `zh_stage_pos_49`
  1771. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1772. ALTER TABLE `zh_stage_pos_50`
  1773. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1774. ALTER TABLE `zh_stage_pos_51`
  1775. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1776. ALTER TABLE `zh_stage_pos_52`
  1777. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1778. ALTER TABLE `zh_stage_pos_53`
  1779. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1780. ALTER TABLE `zh_stage_pos_54`
  1781. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1782. ALTER TABLE `zh_stage_pos_55`
  1783. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1784. ALTER TABLE `zh_stage_pos_56`
  1785. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1786. ALTER TABLE `zh_stage_pos_57`
  1787. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1788. ALTER TABLE `zh_stage_pos_58`
  1789. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1790. ALTER TABLE `zh_stage_pos_59`
  1791. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1792. ALTER TABLE `zh_stage_pos_60`
  1793. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1794. ALTER TABLE `zh_stage_pos_61`
  1795. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1796. ALTER TABLE `zh_stage_pos_62`
  1797. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1798. ALTER TABLE `zh_stage_pos_63`
  1799. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1800. ALTER TABLE `zh_stage_pos_64`
  1801. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1802. ALTER TABLE `zh_stage_pos_65`
  1803. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1804. ALTER TABLE `zh_stage_pos_66`
  1805. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1806. ALTER TABLE `zh_stage_pos_67`
  1807. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1808. ALTER TABLE `zh_stage_pos_68`
  1809. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1810. ALTER TABLE `zh_stage_pos_69`
  1811. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1812. ALTER TABLE `zh_stage_pos_70`
  1813. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1814. ALTER TABLE `zh_stage_pos_71`
  1815. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1816. ALTER TABLE `zh_stage_pos_72`
  1817. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1818. ALTER TABLE `zh_stage_pos_73`
  1819. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1820. ALTER TABLE `zh_stage_pos_74`
  1821. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1822. ALTER TABLE `zh_stage_pos_75`
  1823. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1824. ALTER TABLE `zh_stage_pos_76`
  1825. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1826. ALTER TABLE `zh_stage_pos_77`
  1827. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1828. ALTER TABLE `zh_stage_pos_78`
  1829. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1830. ALTER TABLE `zh_stage_pos_79`
  1831. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1832. ALTER TABLE `zh_stage_pos_80`
  1833. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1834. ALTER TABLE `zh_stage_pos_81`
  1835. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1836. ALTER TABLE `zh_stage_pos_82`
  1837. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1838. ALTER TABLE `zh_stage_pos_83`
  1839. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1840. ALTER TABLE `zh_stage_pos_84`
  1841. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1842. ALTER TABLE `zh_stage_pos_85`
  1843. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1844. ALTER TABLE `zh_stage_pos_86`
  1845. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1846. ALTER TABLE `zh_stage_pos_87`
  1847. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1848. ALTER TABLE `zh_stage_pos_88`
  1849. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1850. ALTER TABLE `zh_stage_pos_89`
  1851. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1852. ALTER TABLE `zh_stage_pos_90`
  1853. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1854. ALTER TABLE `zh_stage_pos_91`
  1855. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1856. ALTER TABLE `zh_stage_pos_92`
  1857. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1858. ALTER TABLE `zh_stage_pos_93`
  1859. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1860. ALTER TABLE `zh_stage_pos_94`
  1861. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1862. ALTER TABLE `zh_stage_pos_95`
  1863. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1864. ALTER TABLE `zh_stage_pos_96`
  1865. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1866. ALTER TABLE `zh_stage_pos_97`
  1867. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1868. ALTER TABLE `zh_stage_pos_98`
  1869. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1870. ALTER TABLE `zh_stage_pos_99`
  1871. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1872. ALTER TABLE `zh_stage_pos_final_0`
  1873. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1874. ALTER TABLE `zh_stage_pos_final_1`
  1875. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1876. ALTER TABLE `zh_stage_pos_final_2`
  1877. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1878. ALTER TABLE `zh_stage_pos_final_3`
  1879. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1880. ALTER TABLE `zh_stage_pos_final_4`
  1881. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1882. ALTER TABLE `zh_stage_pos_final_5`
  1883. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1884. ALTER TABLE `zh_stage_pos_final_6`
  1885. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1886. ALTER TABLE `zh_stage_pos_final_7`
  1887. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1888. ALTER TABLE `zh_stage_pos_final_8`
  1889. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1890. ALTER TABLE `zh_stage_pos_final_9`
  1891. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1892. ALTER TABLE `zh_stage_pos_final_10`
  1893. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1894. ALTER TABLE `zh_stage_pos_final_11`
  1895. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1896. ALTER TABLE `zh_stage_pos_final_12`
  1897. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1898. ALTER TABLE `zh_stage_pos_final_13`
  1899. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1900. ALTER TABLE `zh_stage_pos_final_14`
  1901. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1902. ALTER TABLE `zh_stage_pos_final_15`
  1903. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1904. ALTER TABLE `zh_stage_pos_final_16`
  1905. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1906. ALTER TABLE `zh_stage_pos_final_17`
  1907. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1908. ALTER TABLE `zh_stage_pos_final_18`
  1909. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1910. ALTER TABLE `zh_stage_pos_final_19`
  1911. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1912. ALTER TABLE `zh_stage_pos_final_20`
  1913. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1914. ALTER TABLE `zh_stage_pos_final_21`
  1915. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1916. ALTER TABLE `zh_stage_pos_final_22`
  1917. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1918. ALTER TABLE `zh_stage_pos_final_23`
  1919. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1920. ALTER TABLE `zh_stage_pos_final_24`
  1921. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1922. ALTER TABLE `zh_stage_pos_final_25`
  1923. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1924. ALTER TABLE `zh_stage_pos_final_26`
  1925. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1926. ALTER TABLE `zh_stage_pos_final_27`
  1927. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1928. ALTER TABLE `zh_stage_pos_final_28`
  1929. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1930. ALTER TABLE `zh_stage_pos_final_29`
  1931. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1932. ALTER TABLE `zh_stage_pos_final_30`
  1933. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1934. ALTER TABLE `zh_stage_pos_final_31`
  1935. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1936. ALTER TABLE `zh_stage_pos_final_32`
  1937. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1938. ALTER TABLE `zh_stage_pos_final_33`
  1939. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1940. ALTER TABLE `zh_stage_pos_final_34`
  1941. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1942. ALTER TABLE `zh_stage_pos_final_35`
  1943. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1944. ALTER TABLE `zh_stage_pos_final_36`
  1945. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1946. ALTER TABLE `zh_stage_pos_final_37`
  1947. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1948. ALTER TABLE `zh_stage_pos_final_38`
  1949. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1950. ALTER TABLE `zh_stage_pos_final_39`
  1951. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1952. ALTER TABLE `zh_stage_pos_final_40`
  1953. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1954. ALTER TABLE `zh_stage_pos_final_41`
  1955. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1956. ALTER TABLE `zh_stage_pos_final_42`
  1957. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1958. ALTER TABLE `zh_stage_pos_final_43`
  1959. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1960. ALTER TABLE `zh_stage_pos_final_44`
  1961. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1962. ALTER TABLE `zh_stage_pos_final_45`
  1963. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1964. ALTER TABLE `zh_stage_pos_final_46`
  1965. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1966. ALTER TABLE `zh_stage_pos_final_47`
  1967. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1968. ALTER TABLE `zh_stage_pos_final_48`
  1969. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1970. ALTER TABLE `zh_stage_pos_final_49`
  1971. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1972. ALTER TABLE `zh_stage_pos_final_50`
  1973. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1974. ALTER TABLE `zh_stage_pos_final_51`
  1975. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1976. ALTER TABLE `zh_stage_pos_final_52`
  1977. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1978. ALTER TABLE `zh_stage_pos_final_53`
  1979. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1980. ALTER TABLE `zh_stage_pos_final_54`
  1981. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1982. ALTER TABLE `zh_stage_pos_final_55`
  1983. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1984. ALTER TABLE `zh_stage_pos_final_56`
  1985. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1986. ALTER TABLE `zh_stage_pos_final_57`
  1987. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1988. ALTER TABLE `zh_stage_pos_final_58`
  1989. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1990. ALTER TABLE `zh_stage_pos_final_59`
  1991. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1992. ALTER TABLE `zh_stage_pos_final_60`
  1993. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1994. ALTER TABLE `zh_stage_pos_final_61`
  1995. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1996. ALTER TABLE `zh_stage_pos_final_62`
  1997. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  1998. ALTER TABLE `zh_stage_pos_final_63`
  1999. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  2000. ALTER TABLE `zh_stage_pos_final_64`
  2001. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  2002. ALTER TABLE `zh_stage_pos_final_65`
  2003. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  2004. ALTER TABLE `zh_stage_pos_final_66`
  2005. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  2006. ALTER TABLE `zh_stage_pos_final_67`
  2007. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  2008. ALTER TABLE `zh_stage_pos_final_68`
  2009. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  2010. ALTER TABLE `zh_stage_pos_final_69`
  2011. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  2012. ALTER TABLE `zh_stage_pos_final_70`
  2013. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  2014. ALTER TABLE `zh_stage_pos_final_71`
  2015. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  2016. ALTER TABLE `zh_stage_pos_final_72`
  2017. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  2018. ALTER TABLE `zh_stage_pos_final_73`
  2019. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  2020. ALTER TABLE `zh_stage_pos_final_74`
  2021. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  2022. ALTER TABLE `zh_stage_pos_final_75`
  2023. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  2024. ALTER TABLE `zh_stage_pos_final_76`
  2025. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  2026. ALTER TABLE `zh_stage_pos_final_77`
  2027. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  2028. ALTER TABLE `zh_stage_pos_final_78`
  2029. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  2030. ALTER TABLE `zh_stage_pos_final_79`
  2031. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  2032. ALTER TABLE `zh_stage_pos_final_80`
  2033. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  2034. ALTER TABLE `zh_stage_pos_final_81`
  2035. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  2036. ALTER TABLE `zh_stage_pos_final_82`
  2037. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  2038. ALTER TABLE `zh_stage_pos_final_83`
  2039. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  2040. ALTER TABLE `zh_stage_pos_final_84`
  2041. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  2042. ALTER TABLE `zh_stage_pos_final_85`
  2043. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  2044. ALTER TABLE `zh_stage_pos_final_86`
  2045. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  2046. ALTER TABLE `zh_stage_pos_final_87`
  2047. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  2048. ALTER TABLE `zh_stage_pos_final_88`
  2049. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  2050. ALTER TABLE `zh_stage_pos_final_89`
  2051. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  2052. ALTER TABLE `zh_stage_pos_final_90`
  2053. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  2054. ALTER TABLE `zh_stage_pos_final_91`
  2055. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  2056. ALTER TABLE `zh_stage_pos_final_92`
  2057. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  2058. ALTER TABLE `zh_stage_pos_final_93`
  2059. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  2060. ALTER TABLE `zh_stage_pos_final_94`
  2061. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  2062. ALTER TABLE `zh_stage_pos_final_95`
  2063. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  2064. ALTER TABLE `zh_stage_pos_final_96`
  2065. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  2066. ALTER TABLE `zh_stage_pos_final_97`
  2067. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  2068. ALTER TABLE `zh_stage_pos_final_98`
  2069. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  2070. ALTER TABLE `zh_stage_pos_final_99`
  2071. ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
  2072. ALTER TABLE `zh_project_col_set`
  2073. MODIFY COLUMN `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT FIRST;
  2074. ------------------------------------
  2075. -- 表数据
  2076. ------------------------------------
  2077. UPDATE zh_project_log pl LEFT JOIN zh_tender t ON pl.tid = t.id SET pl.spid = IF(ISNULL(t.spid),'',t.spid);
  2078. Update zh_project_col_set SET pid = id;
  2079. Update zh_payment_folder SET folder_id = id;
  2080. INSERT INTO `zh_permission` (`id`, `name`, `controller`, `action`, `pid`, `icon_class`, `create_time`, `isshow`) VALUES (77, '项目设置', 'project', 'sp-pageshow', 38, 'sp-pageshow', NULL, 1);
  2081. -- 需扩写sql
  2082. UPDATE zh_notice SET tid = JSON_UNQUOTE(JSON_EXTRACT(content, '$.tid')) WHERE tid IS NULL and id < 100000;
  2083. UPDATE zh_notice SET tid = JSON_UNQUOTE(JSON_EXTRACT(content, '$.tid')) WHERE tid IS NULL and id < 200000 and id >= 100000;
  2084. UPDATE zh_notice SET spid = JSON_UNQUOTE(JSON_EXTRACT(content, '$.spid')) WHERE spid = '' and id < 100000;
  2085. UPDATE zh_notice SET spid = JSON_UNQUOTE(JSON_EXTRACT(content, '$.spid')) WHERE spid = '' and id < 200000 and id >= 100000;