1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387 |
- -- 请按如下分类提交sql!!!
- -- Version V3.5.50.xxxx
- -- uat 2025-xx-xx
- -- prod 2025-xx-xx
- ------------------------------------
- -- 表结构
- ------------------------------------
- ALTER TABLE `zh_construction_unit`
- MODIFY COLUMN `sign_path` mediumtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT '签章图片地址,以逗号分隔' AFTER `basic`,
- ADD COLUMN `sign_permission` tinyint(1) NULL DEFAULT 1 COMMENT '授权所有人使用单位章' AFTER `sign_path`;
- ALTER TABLE `zh_project_account`
- ADD COLUMN `unit_sign_path` mediumtext NULL COMMENT '单位章图片地址' AFTER `stamp_path`;
- ALTER TABLE `zh_filing`
- ADD COLUMN `file_company` varchar(100) NOT NULL DEFAULT '' COMMENT '归档单位' AFTER `tips`;
- ALTER TABLE `zh_filing_template`
- ADD COLUMN `file_company` varchar(100) NOT NULL DEFAULT '' COMMENT '归档单位' AFTER `tips`;
- ALTER TABLE `zh_sub_project_permission`
- ADD COLUMN `last_time` timestamp NULL DEFAULT NULL COMMENT '最近使用时间' AFTER `tp_cache_time`;
- ALTER TABLE `zh_tender_info`
- ADD COLUMN `calc_type` varchar(20) NOT NULL DEFAULT 'up' COMMENT '计价类型(单价up,总价tp)' AFTER `s_type`;
- CREATE TABLE `zh_multi_limit` (
- `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
- `pid` int(11) UNSIGNED NOT NULL COMMENT '项目id',
- `limit_id` varchar(36) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'uuid',
- `user_id` int(11) NOT NULL COMMENT '创建人',
- `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
- `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后更新时间',
- `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '名称',
- `limit` tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '限制计量',
- `lower` tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '计量下限',
- `upper` tinyint(4) UNSIGNED NOT NULL DEFAULT 100 COMMENT '计量上限',
- `condition` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT '判断条件',
- `hint` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '提示文本',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;
- ALTER TABLE `zh_tender`
- ADD COLUMN `s2b_multi_check` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '联动计量-检查计量' AFTER `map_pic`,
- ADD COLUMN `s2b_multi_limit` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '联动计量-限制上报' AFTER `s2b_multi_check`;
- ALTER TABLE `zh_ledger_extra_0`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_1`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_2`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_3`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_4`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_5`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_6`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_7`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_8`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_9`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_10`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_11`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_12`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_13`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_14`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_15`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_16`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_17`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_18`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_19`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_20`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_21`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_22`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_23`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_24`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_25`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_26`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_27`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_28`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_29`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_30`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_31`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_32`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_33`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_34`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_35`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_36`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_37`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_38`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_39`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_40`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_41`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_42`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_43`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_44`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_45`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_46`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_47`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_48`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_49`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_50`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_51`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_52`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_53`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_54`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_55`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_56`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_57`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_58`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_59`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_60`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_61`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_62`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_63`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_64`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_65`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_66`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_67`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_68`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_69`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_70`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_71`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_72`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_73`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_74`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_75`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_76`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_77`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_78`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_79`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_80`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_81`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_82`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_83`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_84`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_85`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_86`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_87`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_88`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_89`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_90`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_91`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_92`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_93`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_94`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_95`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_96`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_97`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_98`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_99`
- ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_financial_transfer_tender`
- MODIFY COLUMN `sorder` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT '期数,以逗号分隔' AFTER `tid`,
- ADD COLUMN `source` varchar(255) NULL DEFAULT '' COMMENT '资金来源' AFTER `is_lock`,
- ADD COLUMN `pre_hb_tp` decimal(30, 8) NULL DEFAULT 0 COMMENT '截止上次划拨' AFTER `hb_tp`;
- ALTER TABLE `zh_financial_transfer`
- ADD COLUMN `pre_hb_tp` decimal(30, 8) NULL DEFAULT 0 COMMENT '截止上次划拨金额' AFTER `total_price`;
- ALTER TABLE `zh_financial_pay`
- ADD COLUMN `fpsid` int NULL COMMENT '资金支付单位期id' AFTER `tid`;
- ALTER TABLE `zh_financial_pay_audit`
- ADD COLUMN `fpsid` int NULL COMMENT '资金支付单位期id' AFTER `fpid`;
- CREATE TABLE `zh_financial_pay_stage` (
- `id` int NOT NULL AUTO_INCREMENT,
- `spid` varchar(100) NULL COMMENT '项目id',
- `company_id` int NULL DEFAULT NULL COMMENT '单位id',
- `order` smallint(5) NULL COMMENT '期数',
- `uid` int NULL COMMENT '申请人id',
- `total_price` decimal(30, 8) NULL DEFAULT 0 COMMENT '本期金额',
- `pre_tp` decimal(30, 8) NULL DEFAULT 0 COMMENT '截止上期金额',
- `can_del` tinyint(1) NULL DEFAULT 1 COMMENT '是否可删除',
- `create_time` datetime NULL DEFAULT NULL COMMENT '申请时间',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT = '资金支付单位期数表';
- CREATE TABLE `zh_tender_permission` (
- `id` varchar(36) NOT NULL COMMENT 'uuid',
- `pid` int(11) NOT NULL COMMENT '项目id(zh_project.id)',
- `spid` varchar(36) NOT NULL COMMENT '子项目id(zh_sub_project.id)',
- `tid` int(11) NOT NULL COMMENT '标段id(zh_tender.id)',
- `uid` int(11) NOT NULL COMMENT '授权用户id(zh_project_account.id)',
- `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
- `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后编辑时间',
- `quality` varchar(255) NOT NULL DEFAULT '' COMMENT '质量管理权限(,分隔,具体见代码定义)',
- PRIMARY KEY (`id`)
- );
- CREATE TABLE `zh_quality_rule` (
- `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id',
- `pid` int(11) NOT NULL COMMENT '项目id',
- `spid` varchar(36) NOT NULL COMMENT '子项目id(zh_sub_project.id)',
- `group_id` varchar(36) NOT NULL COMMENT 'uuid(分组id)',
- `group_name` varchar(50) NOT NULL COMMENT '分组名称',
- `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
- `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后更新时间',
- `user_id` int(11) UNSIGNED NOT NULL COMMENT '创建人',
- `name` varchar(50) NOT NULL DEFAULT '' COMMENT '规则名称',
- `condition` text NULL COMMENT '条件',
- `push_status` varchar(255) NOT NULL DEFAULT '' COMMENT '推送状态',
- `memo` varchar(255) NOT NULL DEFAULT '' COMMENT '备注',
- PRIMARY KEY (`id`)
- );
- CREATE TABLE `zh_quality` (
- `id` varchar(36) NOT NULL COMMENT 'uuid',
- `tid` int(11) NOT NULL COMMENT '标段id(zh_tender.id)',
- `rela_type` varchar(10) NOT NULL COMMENT '台账类型(xmj/pos)',
- `rela_id` varchar(36) NOT NULL COMMENT '台账id(zh_ledger.id/zh_pos.id)',
- `rela_name` varchar(36) NOT NULL COMMENT '计量单元名称(zh_pos.name)',
- `gxby_status` tinyint(4) NOT NULL DEFAULT -1 COMMENT '工序报验状态',
- `gxby_date` timestamp NULL COMMENT '完工日期',
- `gxby_limit` tinyint(4) NOT NULL DEFAULT 0 COMMENT '计量是否受限',
- `dagl_status` tinyint(4) NOT NULL DEFAULT -1 COMMENT '档案管理状态',
- `dagl_limit` tinyint(4) NOT NULL DEFAULT 0 COMMENT '计量是否受限',
- `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
- `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后更新时间',
- `create_uid` int(11) NOT NULL COMMENT '创建人',
- `update_uid` int(11) NOT NULL COMMENT '最后修改人',
- `is_used` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否使用',
- `group_id` varchar(36) NOT NULL DEFAULT '' COMMENT '规则判断组id(zh_quality_rule.group_id)',
- `kaigong_name` varchar(50) NOT NULL DEFAULT '' COMMENT '开工-名称',
- `kaigong_date` varchar(20) NOT NULL DEFAULT '' COMMENT '开工-计划开工日期',
- `kaigong_uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '开工-创建人',
- `kaigong_time` timestamp NULL COMMENT '开工-创建时间',
- PRIMARY KEY (`id`)
- );
- CREATE TABLE `zh_quality_file` (
- `id` varchar(36) NOT NULL COMMENT 'uuid',
- `tid` int(11) NOT NULL COMMENT '标段id(zh_tender.id)',
- `quality_id` varchar(36) NOT NULL COMMENT '质量管理id(zh_quality.id)',
- `rela_type` varchar(20) NOT NULL COMMENT '关联台账类型(xmj/pos)',
- `rela_id` varchar(36) NOT NULL COMMENT '关联台账id(zh_ledger.id/zh_pos.id)',
- `block_type` varchar(20) NOT NULL COMMENT '质量管理模块(kaigong/gongxu/...)',
- `block_id` varchar(36) NOT NULL COMMENT '质量管理模块id(zh_quality_gongxu.id/zh_quality_yinbi.id/...)',
- `user_id` int(11) UNSIGNED NOT NULL COMMENT '用户id(zh_project_account.id)',
- `user_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '用户名(缓存)',
- `user_company` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '公司(缓存)',
- `user_role` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '角色(缓存)',
- `filename` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '文件名',
- `fileext` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '文件类型',
- `filesize` int(11) UNSIGNED NOT NULL COMMENT '文件大小',
- `filepath` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '文件路径(oss路径)',
- `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
- `update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最后更新时间',
- `is_deleted` tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否删除',
- `spec_type` varchar(20) NOT NULL DEFAULT '' COMMENT '特殊文件类型(质检qa)',
- PRIMARY KEY (`id`)
- );
- CREATE TABLE `zh_quality_gongxu` (
- `id` varchar(36) NOT NULL COMMENT 'uuid',
- `tid` int(11) NOT NULL COMMENT '标段id(zh_tender.id)',
- `quality_id` varchar(36) NOT NULL COMMENT '质量管理id(zh_quality.id)',
- `user_id` int(11) NOT NULL COMMENT '创建人id',
- `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
- `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间',
- `name` varchar(100) NOT NULL DEFAULT '' COMMENT '名称',
- PRIMARY KEY (`id`)
- );
- CREATE TABLE `zh_quality_yinbi` (
- `id` varchar(36) NOT NULL COMMENT 'uuid',
- `tid` int(11) NOT NULL COMMENT '标段id(zh_tender.id)',
- `quality_id` varchar(36) NOT NULL COMMENT '质量管理id(zh_quality.id)',
- `user_id` int(11) NOT NULL COMMENT '创建人id',
- `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
- `update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最后修改时间',
- `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '名称',
- `gongxu_id` varchar(36) NOT NULL DEFAULT '' COMMENT '工序id(zh_quality_gongxu.id)',
- `gcbw` varchar(1000) NOT NULL DEFAULT '' COMMENT '工程部位',
- `content` varchar(1000) NOT NULL DEFAULT '' COMMENT '说明',
- PRIMARY KEY (`id`)
- );
- ALTER TABLE `zh_ledger_extra_0`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_1`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_2`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_3`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_4`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_5`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_6`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_7`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_8`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_9`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_10`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_11`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_12`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_13`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_14`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_15`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_16`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_17`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_18`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_19`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_20`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_21`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_22`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_23`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_24`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_25`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_26`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_27`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_28`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_29`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_30`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_31`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_32`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_33`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_34`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_35`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_36`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_37`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_38`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_39`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_40`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_41`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_42`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_43`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_44`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_45`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_46`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_47`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_48`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_49`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_50`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_51`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_52`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_53`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_54`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_55`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_56`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_57`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_58`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_59`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_60`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_61`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_62`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_63`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_64`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_65`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_66`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_67`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_68`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_69`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_70`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_71`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_72`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_73`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_74`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_75`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_76`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_77`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_78`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_79`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_80`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_81`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_82`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_83`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_84`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_85`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_86`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_87`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_88`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_89`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_90`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_91`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_92`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_93`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_94`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_95`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_96`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_97`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_98`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_ledger_extra_99`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_0`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_1`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_2`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_3`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_4`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_5`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_6`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_7`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_8`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_9`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_10`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_11`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_12`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_13`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_14`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_15`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_16`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_17`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_18`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_19`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_20`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_21`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_22`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_23`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_24`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_25`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_26`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_27`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_28`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_29`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_30`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_31`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_32`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_33`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_34`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_35`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_36`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_37`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_38`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_39`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_40`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_41`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_42`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_43`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_44`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_45`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_46`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_47`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_48`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_49`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_50`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_51`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_52`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_53`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_54`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_55`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_56`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_57`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_58`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_59`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_60`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_61`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_62`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_63`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_64`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_65`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_66`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_67`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_68`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_69`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_70`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_71`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_72`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_73`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_74`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_75`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_76`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_77`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_78`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_79`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_80`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_81`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_82`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_83`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_84`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_85`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_86`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_87`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_88`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_89`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_90`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_91`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_92`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_93`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_94`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_95`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_96`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_97`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_98`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_pos_extra_99`
- ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
- ALTER TABLE `zh_stage_bills_final_0`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_1`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_2`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_3`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_4`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_5`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_6`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_7`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_8`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_9`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_10`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_11`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_12`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_13`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_14`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_15`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_16`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_17`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_18`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_19`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_20`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_21`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_22`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_23`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_24`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_25`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_26`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_27`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_28`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_29`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_30`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_31`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_32`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_33`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_34`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_35`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_36`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_37`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_38`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_39`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_40`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_41`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_42`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_43`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_44`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_45`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_46`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_47`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_48`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_49`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_50`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_51`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_52`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_53`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_54`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_55`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_56`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_57`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_58`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_59`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_60`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_61`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_62`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_63`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_64`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_65`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_66`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_67`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_68`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_69`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_70`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_71`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_72`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_73`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_74`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_75`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_76`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_77`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_78`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_79`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_80`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_81`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_82`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_83`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_84`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_85`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_86`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_87`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_88`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_89`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_90`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_91`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_92`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_93`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_94`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_95`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_96`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_97`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_98`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_bills_final_99`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_0`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_1`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_2`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_3`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_4`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_5`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_6`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_7`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_8`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_9`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_10`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_11`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_12`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_13`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_14`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_15`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_16`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_17`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_18`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_19`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_20`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_21`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_22`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_23`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_24`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_25`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_26`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_27`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_28`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_29`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_30`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_31`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_32`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_33`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_34`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_35`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_36`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_37`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_38`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_39`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_40`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_41`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_42`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_43`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_44`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_45`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_46`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_47`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_48`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_49`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_50`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_51`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_52`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_53`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_54`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_55`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_56`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_57`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_58`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_59`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_60`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_61`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_62`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_63`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_64`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_65`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_66`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_67`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_68`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_69`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_70`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_71`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_72`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_73`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_74`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_75`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_76`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_77`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_78`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_79`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_80`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_81`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_82`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_83`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_84`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_85`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_86`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_87`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_88`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_89`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_90`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_91`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_92`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_93`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_94`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_95`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_96`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_97`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_98`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_stage_pos_final_99`
- ADD COLUMN `used_time` datetime NULL COMMENT '首次使用时间' AFTER `unit_price`,
- ADD COLUMN `update_time` datetime NULL COMMENT '最后更新时间' AFTER `used_time`;
- ALTER TABLE `zh_contract_audit`
- ADD COLUMN `permission_edit_contract` tinyint(1) NULL DEFAULT 0 COMMENT '编辑非本人合同权限' AFTER `permission_edit`,
- ADD COLUMN `permission_add_pay` tinyint(1) NULL DEFAULT 0 COMMENT '添加非本人合同支付权限' AFTER `permission_edit_contract`;
- ------------------------------------
- -- 表数据
- ------------------------------------
|