ALTER TABLE `zh_ledger_cooperation` ADD `company` VARCHAR(100) NULL DEFAULT '' COMMENT '单位或备注名,筛选用' AFTER `sign_path`; -- -- 表的结构 `zh_cooperation_confirm` -- CREATE TABLE `zh_cooperation_confirm` ( `id` int(11) NOT NULL AUTO_INCREMENT, `tid` int(11) NOT NULL COMMENT '标段id', `sid` int(11) NOT NULL COMMENT '期id', `times` tinyint(11) NOT NULL COMMENT '次数', `ledger_id` int(11) NOT NULL COMMENT '台账id', `uid` int(11) NOT NULL COMMENT '审批人id', `create_time` datetime DEFAULT NULL COMMENT '确认时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='多人协同确认表'; ALTER TABLE `zh_advance_audit` CHANGE COLUMN `type` `type` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '预付款类型,0为开工预付款,1为材料预付款,2为安全生产费预付款' ; ALTER TABLE `zh_advance_pay` CHANGE COLUMN `type` `type` INT(1) NOT NULL DEFAULT '0' COMMENT '预付款类型,0为开工预付款,1为材料预付款,2位安全生产费预付款' ; -- 接口相关 ALTER TABLE `zh_tender` ADD COLUMN `s2b_gxby_check` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '工序报验-检查计量' AFTER `copy_id`, ADD COLUMN `s2b_gxby_limit` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '限制上报' AFTER `s2b_gxby_check`, ADD COLUMN `s2b_dagl_check` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '档案管理-检查计量' AFTER `s2b_gxby_limit`, ADD COLUMN `s2b_dagl_limit` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '档案管理-限制上报' AFTER `s2b_dagl_check`; ALTER TABLE `zh_pos_0` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_pos_1` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_pos_2` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_pos_3` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_pos_4` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_pos_5` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_pos_6` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_pos_7` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_pos_8` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_pos_9` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_pos_10` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_pos_11` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_pos_12` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_pos_13` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_pos_14` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_pos_15` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_pos_16` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_pos_17` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_pos_18` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_pos_19` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_revise_pos_0` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_revise_pos_1` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_revise_pos_2` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_revise_pos_3` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_revise_pos_4` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_revise_pos_5` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_revise_pos_6` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_revise_pos_7` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_revise_pos_8` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_revise_pos_9` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_revise_pos_10` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_revise_pos_11` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_revise_pos_12` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_revise_pos_13` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_revise_pos_14` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_revise_pos_15` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_revise_pos_16` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_revise_pos_17` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_revise_pos_18` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_revise_pos_19` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_ledger_0` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_ledger_1` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_ledger_2` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_ledger_3` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_ledger_4` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_ledger_5` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_ledger_6` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_ledger_7` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_ledger_8` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_ledger_9` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_revise_bills_0` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_revise_bills_1` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_revise_bills_2` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_revise_bills_3` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_revise_bills_4` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_revise_bills_5` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_revise_bills_6` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_revise_bills_7` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_revise_bills_8` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; ALTER TABLE `zh_revise_bills_9` ADD COLUMN `gxby_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `gxby_status`, ADD COLUMN `gxby_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `gxby_limit`, ADD COLUMN `dagl_limit` int(4) NOT NULL DEFAULT -1 COMMENT '计量是否受限,-1不受限,0受限不可计量,1受限可计量' AFTER `dagl_status`, ADD COLUMN `dagl_ratio` decimal(6,4) NOT NULL DEFAULT 0 COMMENT '允许计量比例,-1表示不限制' AFTER `dagl_limit`; --更新归档结构 ALTER TABLE `calculation`.`zh_rpt_archive` CHANGE COLUMN `archive_id` `id` INT(11) NOT NULL AUTO_INCREMENT ; -- -- 表的结构 `zh_tender_tourist` -- CREATE TABLE `zh_tender_tourist` ( `id` int(11) NOT NULL AUTO_INCREMENT, `tid` int(11) NOT NULL COMMENT '标段id', `user_id` int(11) NOT NULL COMMENT '用户id', `in_time` datetime DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='标段游客表'; ALTER TABLE `zh_change` ADD `is_revise` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '是否是修订状态' AFTER `tp_decimal`;