Calculation/sql/update20250404.sql

-- 请按如下分类提交sql！！！
-- Version V3.5.48.0401
-- uat 2025-4-1
-- prod 2025-4-4

------------------------------------
-- 表结构
------------------------------------

ALTER TABLE `zh_sub_project`
ADD COLUMN `page_show` varchar(5000) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '{\"bwtz\":\"1\"}' COMMENT '前台页面或功能展示与隐藏' AFTER `lock_file`,
ADD COLUMN `fun_rela` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '功能设置(json.stringify)' AFTER `page_show`,
ADD COLUMN `data_collect` tinyint(1) NOT NULL DEFAULT 0 COMMENT '决策大屏是否显示及对应大屏编号' AFTER `fun_rela`,
ADD COLUMN `data_collect_pages` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '需要展示的大屏字符串，以，分隔' AFTER `data_collect`,
ADD COLUMN `fun_set` varchar(5000) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '项目设置页内容json' AFTER `data_collect_pages`,
ADD COLUMN `payment_setting` JSON NULL DEFAULT NULL COMMENT '支付审批模块设置' AFTER `fun_set`,
ADD COLUMN `common_json` json NULL COMMENT '通用json，没有sql查询值必要的可放这' AFTER `payment_setting`;

ALTER TABLE `zh_category`
ADD COLUMN `spid` varchar(36) NOT NULL DEFAULT '' COMMENT '子项目id（uuid）' AFTER `pid`;

ALTER TABLE `zh_category_value`
ADD COLUMN `spid` varchar(36) NOT NULL DEFAULT '' COMMENT '子项目id（uuid）' AFTER `pid`;

ALTER TABLE `zh_sub_project_permission`
ADD COLUMN `self_category_level` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' AFTER `update_time`;

ALTER TABLE `zh_project_log`
ADD COLUMN `spid` varchar(36) NOT NULL DEFAULT '' COMMENT '操作子项目' AFTER `pid`;

ALTER TABLE `zh_sub_project`
MODIFY COLUMN `rela_tender` varchar(5000) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT '关联标段id(\',\'分隔)' AFTER `user_id`;

ALTER TABLE `zh_budget`
MODIFY COLUMN `rela_tender` varchar(5000) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT '关联标段id(\',\'分隔)' AFTER `std_id`;

ALTER TABLE `zh_sub_project_permission`
ADD COLUMN `info_permission` varchar(255) NOT NULL DEFAULT '' COMMENT '项目概况，权限id列表(\',\'分隔)' AFTER `self_category_level`,
ADD COLUMN `fund_trans_permission` varchar(255) NOT NULL DEFAULT '' COMMENT '资金划拨，权限id列表(\',\'分隔)' AFTER `info_permission`,
ADD COLUMN `fund_pay_permission` varchar(255) NOT NULL DEFAULT '' COMMENT '资金支付，权限id列表(\',\'分隔)' AFTER `fund_trans_permission`,
ADD COLUMN `contract_permission` varchar(255) NOT NULL DEFAULT '' COMMENT '合同管理，权限id列表(\',\'分隔)' AFTER `fund_pay_permission`,
ADD COLUMN `datacollect_permission` varchar(255) NOT NULL DEFAULT '' COMMENT '决策大屏，权限id列表(\',\'分隔)' AFTER `contract_permission`,
ADD COLUMN `payment_permission` varchar(255) NOT NULL DEFAULT '' COMMENT '支付审批，权限id列表(\',\'分隔)' AFTER `datacollect_permission`;

ALTER TABLE `zh_file_reference_list`
ADD COLUMN `file_type` tinyint(4) UNSIGNED NOT NULL DEFAULT 1 COMMENT '文件类型' AFTER `remark`,
ADD COLUMN `file_type_str` varchar(50) NOT NULL DEFAULT '资料归集' COMMENT '文件类型-文本' AFTER `file_type`;

ALTER TABLE `zh_file_reference`
MODIFY COLUMN `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '名称' AFTER `is_leaf`,
ADD COLUMN `code` varchar(50) NOT NULL DEFAULT '' COMMENT '序号/编号' AFTER `name`,
MODIFY COLUMN `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '备注' AFTER `name`;

ALTER TABLE `zh_budget_std`
ADD COLUMN `progress_template_id` varchar(255) NOT NULL DEFAULT '' COMMENT '项目概况-阶段进度-新建模板id列表（‘,’分隔）' AFTER `ht_tender_template_id`;

ALTER TABLE `zh_project_col_set`
ADD COLUMN `pid` int(11) NOT NULL DEFAULT 0 COMMENT 'zh_project.id' AFTER `id`,
ADD COLUMN `spid` varchar(36) NOT NULL DEFAULT '' COMMENT 'zh_sub_project.id' AFTER `pid`,
ADD COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `info`,
ADD COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间' AFTER `create_time`;

ALTER TABLE `zh_payment_tender`
ADD COLUMN `spid` varchar(36) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '子项目id' AFTER `pid`;

ALTER TABLE `zh_payment_folder`
MODIFY COLUMN `id` varchar(36) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL FIRST,
ADD COLUMN `spid` varchar(36) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '子项目id' AFTER `pid`,
ADD COLUMN `folder_id` int(11) NOT NULL DEFAULT 0 COMMENT '节点id' AFTER `name`;

ALTER TABLE `zh_tender`
ADD COLUMN `filter_budget` tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '动态投资-是否过滤' AFTER `spid`,
ADD COLUMN `filter_fund` tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '资金监管-是否过滤' AFTER `filter_budget`;

ALTER TABLE `zh_notice`
ADD COLUMN `spid` varchar(36) NULL DEFAULT '' COMMENT '子项目id' AFTER `pid`,
ADD COLUMN `tid` int(11) NULL DEFAULT NULL COMMENT '标段id' AFTER `spid`;

ALTER TABLE `zh_message`
ADD COLUMN `spid` varchar(36) NULL DEFAULT '' COMMENT '子项目id' AFTER `project_id`;

ALTER TABLE `zh_filing_template`
ADD COLUMN `is_rela` tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '可否导入文件' AFTER `tips`;

ALTER TABLE `zh_filing`
ADD COLUMN `is_rela` tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '可否导入文件' AFTER `tips`;


ALTER TABLE `zh_ledger_0`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_1`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_2`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_3`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_4`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_5`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_6`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_7`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_8`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_9`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_10`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_11`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_12`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_13`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_14`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_15`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_16`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_17`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_18`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_19`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_20`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_21`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_22`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_23`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_24`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_25`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_26`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_27`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_28`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_29`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_30`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_31`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_32`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_33`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_34`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_35`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_36`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_37`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_38`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_39`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_40`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_41`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_42`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_43`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_44`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_45`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_46`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_47`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_48`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_49`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_50`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_51`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_52`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_53`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_54`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_55`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_56`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_57`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_58`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_59`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_60`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_61`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_62`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_63`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_64`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_65`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_66`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_67`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_68`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_69`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_70`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_71`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_72`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_73`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_74`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_75`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_76`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_77`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_78`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_79`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_80`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_81`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_82`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_83`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_84`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_85`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_86`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_87`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_88`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_89`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_90`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_91`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_92`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_93`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_94`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_95`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_96`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_97`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_98`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_ledger_99`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;

ALTER TABLE `zh_revise_bills_0`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_1`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_2`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_3`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_4`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_5`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_6`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_7`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_8`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_9`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_10`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_11`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_12`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_13`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_14`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_15`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_16`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_17`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_18`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_19`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_20`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_21`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_22`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_23`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_24`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_25`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_26`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_27`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_28`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_29`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_30`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_31`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_32`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_33`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_34`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_35`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_36`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_37`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_38`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_39`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_40`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_41`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_42`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_43`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_44`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_45`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_46`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_47`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_48`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_49`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_50`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_51`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_52`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_53`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_54`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_55`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_56`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_57`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_58`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_59`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_60`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_61`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_62`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_63`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_64`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_65`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_66`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_67`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_68`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_69`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_70`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_71`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_72`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_73`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_74`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_75`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_76`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_77`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_78`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_79`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_80`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_81`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_82`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_83`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_84`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_85`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_86`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_87`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_88`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_89`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_90`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_91`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_92`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_93`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_94`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_95`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_96`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_97`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_98`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;
ALTER TABLE `zh_revise_bills_99`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;

ALTER TABLE `zh_change_ledger`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`,
ADD COLUMN `ex_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_qty1`;

ALTER TABLE `zh_pos_0`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_1`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_2`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_3`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_4`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_5`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_6`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_7`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_8`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_9`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_10`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_11`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_12`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_13`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_14`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_15`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_16`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_17`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_18`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_19`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_20`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_21`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_22`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_23`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_24`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_25`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_26`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_27`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_28`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_29`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_30`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_31`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_32`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_33`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_34`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_35`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_36`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_37`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_38`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_39`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_40`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_41`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_42`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_43`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_44`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_45`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_46`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_47`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_48`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_49`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_50`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_51`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_52`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_53`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_54`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_55`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_56`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_57`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_58`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_59`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_60`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_61`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_62`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_63`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_64`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_65`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_66`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_67`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_68`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_69`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_70`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_71`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_72`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_73`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_74`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_75`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_76`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_77`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_78`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_79`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_80`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_81`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_82`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_83`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_84`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_85`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_86`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_87`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_88`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_89`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_90`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_91`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_92`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_93`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_94`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_95`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_96`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_97`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_98`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_pos_99`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;

ALTER TABLE `zh_revise_pos_0`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_1`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_2`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_3`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_4`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_5`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_6`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_7`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_8`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_9`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_10`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_11`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_12`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_13`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_14`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_15`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_16`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_17`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_18`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_19`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_20`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_21`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_22`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_23`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_24`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_25`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_26`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_27`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_28`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_29`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_30`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_31`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_32`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_33`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_34`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_35`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_36`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_37`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_38`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_39`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_40`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_41`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_42`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_43`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_44`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_45`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_46`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_47`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_48`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_49`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_50`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_51`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_52`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_53`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_54`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_55`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_56`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_57`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_58`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_59`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_60`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_61`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_62`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_63`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_64`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_65`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_66`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_67`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_68`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_69`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_70`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_71`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_72`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_73`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_74`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_75`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_76`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_77`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_78`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_79`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_80`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_81`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_82`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_83`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_84`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_85`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_86`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_87`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_88`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_89`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_90`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_91`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_92`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_93`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_94`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_95`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_96`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_97`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_98`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;
ALTER TABLE `zh_revise_pos_99`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;

ALTER TABLE `zh_change_pos`
ADD COLUMN `ex_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `ex_memo3`;

ALTER TABLE `zh_stage_bills_0`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_1`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_2`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_3`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_4`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_5`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_6`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_7`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_8`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_9`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_10`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_11`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_12`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_13`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_14`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_15`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_16`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_17`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_18`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_19`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_20`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_21`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_22`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_23`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_24`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_25`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_26`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_27`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_28`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_29`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_30`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_31`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_32`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_33`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_34`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_35`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_36`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_37`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_38`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_39`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_40`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_41`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_42`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_43`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_44`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_45`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_46`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_47`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_48`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_49`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_50`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_51`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_52`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_53`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_54`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_55`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_56`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_57`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_58`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_59`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_60`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_61`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_62`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_63`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_64`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_65`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_66`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_67`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_68`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_69`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_70`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_71`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_72`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_73`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_74`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_75`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_76`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_77`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_78`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_79`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_80`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_81`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_82`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_83`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_84`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_85`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_86`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_87`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_88`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_89`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_90`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_91`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_92`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_93`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_94`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_95`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_96`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_97`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_98`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_99`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `contract_expr`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;

ALTER TABLE `zh_stage_bills_final_0`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_1`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_2`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_3`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_4`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_5`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_6`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_7`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_8`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_9`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_10`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_11`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_12`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_13`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_14`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_15`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_16`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_17`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_18`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_19`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_20`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_21`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_22`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_23`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_24`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_25`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_26`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_27`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_28`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_29`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_30`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_31`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_32`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_33`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_34`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_35`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_36`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_37`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_38`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_39`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_40`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_41`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_42`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_43`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_44`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_45`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_46`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_47`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_48`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_49`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_50`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_51`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_52`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_53`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_54`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_55`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_56`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_57`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_58`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_59`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_60`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_61`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_62`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_63`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_64`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_65`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_66`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_67`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_68`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_69`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_70`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_71`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_72`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_73`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_74`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_75`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_76`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_77`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_78`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_79`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_80`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_81`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_82`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_83`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_84`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_85`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_86`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_87`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_88`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_89`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_90`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_91`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_92`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_93`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_94`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_95`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_96`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_97`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_98`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;
ALTER TABLE `zh_stage_bills_final_99`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `pc_tp`,
ADD COLUMN `ex_stage_tp1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '金额1' AFTER `ex_stage_qty1`;

ALTER TABLE `zh_stage_pos_0`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_1`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_2`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_3`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_4`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_5`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_6`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_7`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_8`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_9`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_10`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_11`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_12`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_13`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_14`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_15`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_16`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_17`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_18`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_19`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_20`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_21`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_22`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_23`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_24`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_25`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_26`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_27`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_28`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_29`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_30`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_31`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_32`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_33`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_34`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_35`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_36`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_37`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_38`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_39`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_40`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_41`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_42`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_43`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_44`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_45`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_46`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_47`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_48`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_49`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_50`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_51`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_52`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_53`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_54`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_55`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_56`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_57`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_58`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_59`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_60`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_61`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_62`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_63`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_64`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_65`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_66`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_67`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_68`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_69`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_70`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_71`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_72`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_73`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_74`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_75`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_76`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_77`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_78`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_79`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_80`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_81`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_82`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_83`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_84`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_85`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_86`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_87`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_88`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_89`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_90`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_91`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_92`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_93`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_94`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_95`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_96`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_97`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_98`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_99`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;

ALTER TABLE `zh_stage_pos_final_0`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_1`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_2`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_3`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_4`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_5`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_6`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_7`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_8`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_9`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_10`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_11`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_12`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_13`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_14`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_15`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_16`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_17`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_18`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_19`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_20`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_21`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_22`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_23`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_24`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_25`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_26`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_27`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_28`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_29`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_30`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_31`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_32`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_33`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_34`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_35`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_36`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_37`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_38`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_39`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_40`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_41`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_42`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_43`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_44`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_45`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_46`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_47`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_48`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_49`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_50`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_51`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_52`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_53`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_54`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_55`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_56`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_57`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_58`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_59`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_60`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_61`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_62`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_63`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_64`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_65`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_66`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_67`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_68`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_69`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_70`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_71`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_72`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_73`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_74`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_75`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_76`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_77`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_78`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_79`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_80`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_81`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_82`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_83`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_84`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_85`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_86`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_87`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_88`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_89`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_90`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_91`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_92`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_93`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_94`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_95`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_96`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_97`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_98`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;
ALTER TABLE `zh_stage_pos_final_99`
ADD COLUMN `ex_stage_qty1` decimal(24, 8) NOT NULL DEFAULT 0 COMMENT '数量1' AFTER `negative_qc_qty`;

ALTER TABLE `zh_project_col_set`
MODIFY COLUMN `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT FIRST;

------------------------------------
-- 表数据
------------------------------------

UPDATE zh_project_log pl LEFT JOIN zh_tender t ON pl.tid = t.id SET pl.spid = IF(ISNULL(t.spid),'',t.spid);

Update zh_project_col_set SET pid = id;

Update zh_payment_folder SET folder_id = id;

INSERT INTO `zh_permission` (`id`, `name`, `controller`, `action`, `pid`, `icon_class`, `create_time`, `isshow`) VALUES (77, '项目设置', 'project', 'sp-pageshow', 38, 'sp-pageshow', NULL, 1);

-- 需扩写sql
UPDATE zh_notice SET tid = JSON_UNQUOTE(JSON_EXTRACT(content, '$.tid')) WHERE tid IS NULL and id < 100000;
UPDATE zh_notice SET tid = JSON_UNQUOTE(JSON_EXTRACT(content, '$.tid')) WHERE tid IS NULL and id < 200000 and id >= 100000;

UPDATE zh_notice SET spid = JSON_UNQUOTE(JSON_EXTRACT(content, '$.spid')) WHERE spid = '' and id < 100000;
UPDATE zh_notice SET spid = JSON_UNQUOTE(JSON_EXTRACT(content, '$.spid')) WHERE spid = '' and id < 200000 and id >= 100000;