123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124 |
- -- 请按如下分类提交sql!!!
- -- Version V3.5.48.0401
- -- uat 2025-4-1
- -- prod 2025-4-4
- ------------------------------------
- -- 表结构
- ------------------------------------
- ALTER TABLE `zh_sub_project`
- ADD COLUMN `page_show` varchar(5000) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '{\"bwtz\":\"1\"}' COMMENT '前台页面或功能展示与隐藏' AFTER `lock_file`,
- ADD COLUMN `fun_rela` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '功能设置(json.stringify)' AFTER `page_show`,
- ADD COLUMN `data_collect` tinyint(1) NOT NULL DEFAULT 0 COMMENT '决策大屏是否显示及对应大屏编号' AFTER `fun_rela`,
- ADD COLUMN `data_collect_pages` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '需要展示的大屏字符串,以,分隔' AFTER `data_collect`,
- ADD COLUMN `fun_set` varchar(5000) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '项目设置页内容json' AFTER `data_collect_pages`,
- ADD COLUMN `payment_setting` JSON NULL DEFAULT NULL COMMENT '支付审批模块设置' AFTER `fun_set`,
- ADD COLUMN `common_json` json NULL COMMENT '通用json,没有sql查询值必要的可放这' AFTER `payment_setting`;
- ALTER TABLE `zh_category`
- ADD COLUMN `spid` varchar(36) NOT NULL DEFAULT '' COMMENT '子项目id(uuid)' AFTER `pid`;
- ALTER TABLE `zh_category_value`
- ADD COLUMN `spid` varchar(36) NOT NULL DEFAULT '' COMMENT '子项目id(uuid)' AFTER `pid`;
- ALTER TABLE `zh_sub_project_permission`
- ADD COLUMN `self_category_level` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' AFTER `update_time`;
- ALTER TABLE `zh_project_log`
- ADD COLUMN `spid` varchar(36) NOT NULL DEFAULT '' COMMENT '操作子项目' AFTER `pid`;
- ALTER TABLE `zh_sub_project`
- MODIFY COLUMN `rela_tender` varchar(5000) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT '关联标段id(\',\'分隔)' AFTER `user_id`;
- ALTER TABLE `zh_budget`
- MODIFY COLUMN `rela_tender` varchar(5000) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT '关联标段id(\',\'分隔)' AFTER `std_id`;
- ALTER TABLE `zh_sub_project_permission`
- ADD COLUMN `info_permission` varchar(255) NOT NULL DEFAULT '' COMMENT '项目概况,权限id列表(\',\'分隔)' AFTER `self_category_level`,
- ADD COLUMN `fund_trans_permission` varchar(255) NOT NULL DEFAULT '' COMMENT '资金划拨,权限id列表(\',\'分隔)' AFTER `info_permission`,
- ADD COLUMN `fund_pay_permission` varchar(255) NOT NULL DEFAULT '' COMMENT '资金支付,权限id列表(\',\'分隔)' AFTER `fund_trans_permission`,
- ADD COLUMN `contract_permission` varchar(255) NOT NULL DEFAULT '' COMMENT '合同管理,权限id列表(\',\'分隔)' AFTER `fund_pay_permission`,
- ADD COLUMN `datacollect_permission` varchar(255) NOT NULL DEFAULT '' COMMENT '决策大屏,权限id列表(\',\'分隔)' AFTER `contract_permission`,
- ADD COLUMN `payment_permission` varchar(255) NOT NULL DEFAULT '' COMMENT '支付审批,权限id列表(\',\'分隔)' AFTER `datacollect_permission`;
- ALTER TABLE `zh_file_reference_list`
- ADD COLUMN `file_type` tinyint(4) UNSIGNED NOT NULL DEFAULT 1 COMMENT '文件类型' AFTER `remark`,
- ADD COLUMN `file_type_str` varchar(50) NOT NULL DEFAULT '资料归集' COMMENT '文件类型-文本' AFTER `file_type`;
- ALTER TABLE `zh_file_reference`
- MODIFY COLUMN `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '名称' AFTER `is_leaf`,
- ADD COLUMN `code` varchar(50) NOT NULL DEFAULT '' COMMENT '序号/编号' AFTER `name`,
- MODIFY COLUMN `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '备注' AFTER `name`;
- ALTER TABLE `zh_budget_std`
- ADD COLUMN `progress_template_id` varchar(255) NOT NULL DEFAULT '' COMMENT '项目概况-阶段进度-新建模板id列表(‘,’分隔)' AFTER `ht_tender_template_id`;
- ALTER TABLE `zh_project_col_set`
- ADD COLUMN `pid` int(11) NOT NULL DEFAULT 0 COMMENT 'zh_project.id' AFTER `id`,
- ADD COLUMN `spid` varchar(36) NOT NULL DEFAULT '' COMMENT 'zh_sub_project.id' AFTER `pid`,
- ADD COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `info`,
- ADD COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间' AFTER `create_time`;
- ALTER TABLE `zh_payment_tender`
- ADD COLUMN `spid` varchar(36) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '子项目id' AFTER `pid`;
- ALTER TABLE `zh_payment_folder`
- MODIFY COLUMN `id` varchar(36) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL FIRST,
- ADD COLUMN `spid` varchar(36) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '子项目id' AFTER `pid`,
- ADD COLUMN `folder_id` int(11) NOT NULL DEFAULT 0 COMMENT '节点id' AFTER `name`;
- ALTER TABLE `zh_tender`
- ADD COLUMN `filter_budget` tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '动态投资-是否过滤' AFTER `spid`,
- ADD COLUMN `filter_fund` tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '资金监管-是否过滤' AFTER `filter_budget`;
- ALTER TABLE `zh_notice`
- ADD COLUMN `spid` varchar(36) NULL DEFAULT '' COMMENT '子项目id' AFTER `pid`,
- ADD COLUMN `tid` int(11) NULL DEFAULT NULL COMMENT '标段id' AFTER `spid`;
- ALTER TABLE `zh_message`
- ADD COLUMN `spid` varchar(36) NULL DEFAULT '' COMMENT '子项目id' AFTER `project_id`;
- ALTER TABLE `zh_filing_template`
- ADD COLUMN `is_rela` tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '可否导入文件' AFTER `tips`;
- ALTER TABLE `zh_filing`
- ADD COLUMN `is_rela` tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '可否导入文件' AFTER `tips`;
- ALTER TABLE `zh_ledger_0`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_1`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_2`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_3`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_4`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_5`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_6`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_7`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_8`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_9`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_10`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_11`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_12`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_13`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_14`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_15`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_16`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_17`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_18`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_19`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_20`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_21`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_22`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_23`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_24`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_25`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_26`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_27`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_28`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_29`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_30`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_31`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_32`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_33`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_34`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_35`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_36`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_37`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_38`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_39`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_40`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_41`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_42`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_43`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_44`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_45`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_46`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_47`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_48`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_49`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_50`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_51`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_52`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_53`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_54`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_55`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_56`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_57`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_58`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_59`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_60`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_61`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_62`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_63`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_64`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_65`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_66`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_67`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_68`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_69`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_70`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_71`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_72`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_73`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_74`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_75`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_76`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_77`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_78`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_79`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_80`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_81`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_82`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_83`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_84`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_85`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_86`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_87`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_88`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_89`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_90`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_91`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_92`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_93`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_94`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_95`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_96`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_97`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_98`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_ledger_99`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_0`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_1`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_2`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_3`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_4`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_5`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_6`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_7`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_8`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_9`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_10`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_11`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_12`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_13`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_14`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_15`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_16`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_17`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_18`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_19`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_20`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_21`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_22`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_23`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_24`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_25`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_26`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_27`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_28`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_29`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_30`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_31`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_32`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_33`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_34`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_35`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_36`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_37`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_38`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_39`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_40`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_41`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_42`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_43`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_44`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_45`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_46`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_47`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_48`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_49`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_50`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_51`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_52`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_53`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_54`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_55`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_56`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_57`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_58`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_59`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_60`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_61`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_62`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_63`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_64`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_65`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_66`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_67`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_68`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_69`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_70`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_71`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_72`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_73`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_74`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_75`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_76`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_77`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_78`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_79`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_80`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_81`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_82`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_83`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_84`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_85`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_86`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_87`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_88`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_89`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_90`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_91`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_92`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_93`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_94`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_95`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_96`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_97`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_98`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_revise_bills_99`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_change_ledger`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
- ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
- ALTER TABLE `zh_pos_0`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_1`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_2`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_3`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_4`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_5`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_6`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_7`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_8`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_9`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_10`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_11`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_12`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_13`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_14`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_15`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_16`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_17`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_18`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_19`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_20`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_21`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_22`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_23`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_24`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_25`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_26`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_27`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_28`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_29`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_30`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_31`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_32`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_33`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_34`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_35`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_36`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_37`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_38`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_39`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_40`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_41`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_42`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_43`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_44`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_45`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_46`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_47`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_48`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_49`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_50`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_51`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_52`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_53`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_54`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_55`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_56`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_57`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_58`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_59`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_60`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_61`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_62`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_63`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_64`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_65`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_66`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_67`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_68`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_69`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_70`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_71`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_72`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_73`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_74`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_75`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_76`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_77`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_78`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_79`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_80`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_81`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_82`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_83`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_84`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_85`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_86`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_87`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_88`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_89`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_90`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_91`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_92`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_93`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_94`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_95`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_96`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_97`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_98`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_pos_99`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_0`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_1`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_2`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_3`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_4`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_5`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_6`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_7`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_8`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_9`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_10`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_11`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_12`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_13`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_14`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_15`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_16`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_17`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_18`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_19`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_20`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_21`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_22`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_23`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_24`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_25`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_26`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_27`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_28`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_29`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_30`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_31`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_32`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_33`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_34`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_35`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_36`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_37`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_38`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_39`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_40`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_41`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_42`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_43`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_44`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_45`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_46`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_47`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_48`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_49`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_50`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_51`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_52`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_53`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_54`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_55`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_56`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_57`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_58`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_59`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_60`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_61`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_62`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_63`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_64`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_65`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_66`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_67`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_68`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_69`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_70`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_71`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_72`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_73`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_74`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_75`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_76`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_77`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_78`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_79`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_80`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_81`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_82`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_83`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_84`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_85`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_86`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_87`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_88`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_89`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_90`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_91`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_92`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_93`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_94`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_95`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_96`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_97`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_98`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_revise_pos_99`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_change_pos`
- ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
- ALTER TABLE `zh_stage_bills_0`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_1`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_2`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_3`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_4`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_5`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_6`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_7`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_8`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_9`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_10`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_11`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_12`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_13`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_14`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_15`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_16`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_17`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_18`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_19`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_20`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_21`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_22`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_23`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_24`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_25`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_26`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_27`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_28`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_29`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_30`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_31`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_32`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_33`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_34`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_35`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_36`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_37`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_38`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_39`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_40`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_41`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_42`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_43`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_44`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_45`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_46`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_47`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_48`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_49`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_50`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_51`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_52`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_53`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_54`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_55`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_56`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_57`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_58`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_59`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_60`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_61`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_62`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_63`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_64`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_65`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_66`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_67`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_68`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_69`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_70`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_71`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_72`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_73`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_74`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_75`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_76`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_77`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_78`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_79`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_80`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_81`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_82`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_83`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_84`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_85`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_86`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_87`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_88`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_89`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_90`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_91`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_92`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_93`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_94`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_95`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_96`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_97`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_98`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_99`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_0`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_1`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_2`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_3`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_4`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_5`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_6`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_7`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_8`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_9`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_10`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_11`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_12`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_13`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_14`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_15`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_16`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_17`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_18`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_19`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_20`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_21`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_22`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_23`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_24`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_25`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_26`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_27`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_28`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_29`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_30`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_31`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_32`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_33`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_34`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_35`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_36`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_37`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_38`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_39`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_40`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_41`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_42`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_43`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_44`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_45`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_46`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_47`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_48`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_49`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_50`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_51`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_52`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_53`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_54`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_55`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_56`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_57`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_58`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_59`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_60`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_61`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_62`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_63`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_64`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_65`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_66`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_67`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_68`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_69`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_70`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_71`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_72`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_73`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_74`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_75`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_76`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_77`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_78`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_79`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_80`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_81`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_82`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_83`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_84`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_85`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_86`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_87`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_88`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_89`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_90`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_91`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_92`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_93`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_94`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_95`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_96`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_97`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_98`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_bills_final_99`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
- ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
- ALTER TABLE `zh_stage_pos_0`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_1`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_2`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_3`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_4`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_5`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_6`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_7`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_8`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_9`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_10`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_11`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_12`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_13`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_14`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_15`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_16`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_17`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_18`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_19`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_20`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_21`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_22`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_23`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_24`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_25`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_26`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_27`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_28`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_29`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_30`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_31`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_32`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_33`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_34`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_35`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_36`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_37`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_38`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_39`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_40`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_41`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_42`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_43`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_44`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_45`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_46`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_47`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_48`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_49`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_50`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_51`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_52`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_53`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_54`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_55`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_56`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_57`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_58`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_59`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_60`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_61`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_62`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_63`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_64`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_65`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_66`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_67`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_68`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_69`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_70`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_71`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_72`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_73`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_74`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_75`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_76`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_77`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_78`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_79`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_80`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_81`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_82`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_83`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_84`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_85`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_86`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_87`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_88`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_89`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_90`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_91`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_92`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_93`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_94`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_95`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_96`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_97`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_98`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_99`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_0`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_1`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_2`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_3`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_4`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_5`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_6`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_7`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_8`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_9`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_10`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_11`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_12`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_13`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_14`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_15`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_16`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_17`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_18`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_19`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_20`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_21`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_22`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_23`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_24`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_25`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_26`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_27`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_28`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_29`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_30`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_31`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_32`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_33`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_34`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_35`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_36`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_37`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_38`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_39`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_40`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_41`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_42`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_43`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_44`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_45`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_46`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_47`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_48`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_49`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_50`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_51`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_52`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_53`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_54`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_55`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_56`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_57`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_58`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_59`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_60`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_61`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_62`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_63`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_64`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_65`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_66`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_67`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_68`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_69`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_70`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_71`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_72`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_73`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_74`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_75`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_76`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_77`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_78`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_79`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_80`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_81`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_82`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_83`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_84`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_85`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_86`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_87`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_88`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_89`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_90`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_91`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_92`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_93`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_94`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_95`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_96`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_97`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_98`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_stage_pos_final_99`
- ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
- ALTER TABLE `zh_project_col_set`
- MODIFY COLUMN `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT FIRST;
- ------------------------------------
- -- 表数据
- ------------------------------------
- UPDATE zh_project_log pl LEFT JOIN zh_tender t ON pl.tid = t.id SET pl.spid = IF(ISNULL(t.spid),'',t.spid);
- Update zh_project_col_set SET pid = id;
- Update zh_payment_folder SET folder_id = id;
- INSERT INTO `zh_permission` (`id`, `name`, `controller`, `action`, `pid`, `icon_class`, `create_time`, `isshow`) VALUES (77, '项目设置', 'project', 'sp-pageshow', 38, 'sp-pageshow', NULL, 1);
- -- 需扩写sql
- UPDATE zh_notice SET tid = JSON_UNQUOTE(JSON_EXTRACT(content, '$.tid')) WHERE tid IS NULL and id < 100000;
- UPDATE zh_notice SET tid = JSON_UNQUOTE(JSON_EXTRACT(content, '$.tid')) WHERE tid IS NULL and id < 200000 and id >= 100000;
- UPDATE zh_notice SET spid = JSON_UNQUOTE(JSON_EXTRACT(content, '$.spid')) WHERE spid = '' and id < 100000;
- UPDATE zh_notice SET spid = JSON_UNQUOTE(JSON_EXTRACT(content, '$.spid')) WHERE spid = '' and id < 200000 and id >= 100000;
|