Calculation/sql/update.sql

-- 请按如下分类提交sql！！！
-- Version V3.5.50.xxxx
-- uat 2025-xx-xx
-- prod 2025-xx-xx

------------------------------------
-- 表结构
------------------------------------
ALTER TABLE `zh_construction_unit`
MODIFY COLUMN `sign_path` mediumtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT '签章图片地址，以逗号分隔' AFTER `basic`,
ADD COLUMN `sign_permission` tinyint(1) NULL DEFAULT 1 COMMENT '授权所有人使用单位章' AFTER `sign_path`;

ALTER TABLE `zh_project_account`
ADD COLUMN `unit_sign_path` mediumtext NULL COMMENT '单位章图片地址' AFTER `stamp_path`;

ALTER TABLE `zh_filing`
ADD COLUMN `file_company` varchar(100) NOT NULL DEFAULT '' COMMENT '归档单位' AFTER `tips`;

ALTER TABLE `zh_filing_template`
ADD COLUMN `file_company` varchar(100) NOT NULL DEFAULT '' COMMENT '归档单位' AFTER `tips`;

ALTER TABLE `zh_sub_project_permission`
ADD COLUMN `last_time` timestamp NULL DEFAULT NULL COMMENT '最近使用时间' AFTER `tp_cache_time`;

ALTER TABLE `zh_tender_info`
ADD COLUMN `calc_type` varchar(20) NOT NULL DEFAULT 'up' COMMENT '计价类型(单价up，总价tp)' AFTER `s_type`;

CREATE TABLE `zh_multi_limit`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `pid` int(11) UNSIGNED NOT NULL COMMENT '项目id',
  `limit_id` varchar(36) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'uuid',
  `user_id` int(11) NOT NULL COMMENT '创建人',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后更新时间',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '名称',
  `limit` tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '限制计量',
  `lower` tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '计量下限',
  `upper` tinyint(4) UNSIGNED NOT NULL DEFAULT 100 COMMENT '计量上限',
  `condition` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT '判断条件',
  `hint` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '提示文本',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;

ALTER TABLE `zh_tender`
ADD COLUMN `s2b_multi_check` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '联动计量-检查计量' AFTER `map_pic`,
ADD COLUMN `s2b_multi_limit` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '联动计量-限制上报' AFTER `s2b_multi_check`;

ALTER TABLE `zh_ledger_extra_0`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_1`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_2`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_3`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_4`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_5`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_6`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_7`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_8`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_9`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_10`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_11`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_12`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_13`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_14`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_15`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_16`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_17`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_18`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_19`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_20`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_21`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_22`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_23`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_24`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_25`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_26`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_27`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_28`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_29`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_30`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_31`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_32`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_33`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_34`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_35`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_36`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_37`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_38`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_39`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_40`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_41`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_42`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_43`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_44`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_45`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_46`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_47`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_48`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_49`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_50`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_51`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_52`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_53`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_54`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_55`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_56`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_57`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_58`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_59`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_60`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_61`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_62`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_63`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_64`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_65`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_66`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_67`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_68`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_69`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_70`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_71`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_72`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_73`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_74`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_75`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_76`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_77`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_78`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_79`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_80`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_81`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_82`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_83`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_84`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_85`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_86`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_87`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_88`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_89`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_90`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_91`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_92`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_93`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_94`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_95`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_96`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_97`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_98`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_99`
ADD COLUMN `multi_limit` varchar(36) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;

ALTER TABLE `zh_financial_transfer_tender`
MODIFY COLUMN `sorder` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT '期数，以逗号分隔' AFTER `tid`,
ADD COLUMN `source` varchar(255) NULL DEFAULT '' COMMENT '资金来源' AFTER `is_lock`,
ADD COLUMN `pre_hb_tp` decimal(30, 8) NULL DEFAULT 0 COMMENT '截止上次划拨' AFTER `hb_tp`;

ALTER TABLE `zh_financial_transfer`
ADD COLUMN `pre_hb_tp` decimal(30, 8) NULL DEFAULT 0 COMMENT '截止上次划拨金额' AFTER `total_price`;

ALTER TABLE `zh_financial_pay`
ADD COLUMN `fpsid` int NULL COMMENT '资金支付单位期id' AFTER `tid`;

ALTER TABLE `zh_financial_pay_audit`
ADD COLUMN `fpsid` int NULL COMMENT '资金支付单位期id' AFTER `fpid`;

CREATE TABLE `zh_financial_pay_stage`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `spid` varchar(100) NULL COMMENT '项目id',
  `company_id` int NULL DEFAULT NULL COMMENT '单位id',
  `order` smallint(5) NULL COMMENT '期数',
  `uid` int NULL COMMENT '申请人id',
  `total_price` decimal(30, 8) NULL DEFAULT 0 COMMENT '本期金额',
  `pre_tp` decimal(30, 8) NULL DEFAULT 0 COMMENT '截止上期金额',
  `can_del` tinyint(1) NULL DEFAULT 1 COMMENT '是否可删除',
  `create_time` datetime NULL DEFAULT NULL COMMENT '申请时间',
  PRIMARY KEY (`id`)
)  ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT = '资金支付单位期数表';


CREATE TABLE `zh_tender_permission` (
  `id` varchar(36) NOT NULL COMMENT 'uuid',
  `pid` int(11) NOT NULL COMMENT '项目id(zh_project.id)',
  `spid` varchar(36) NOT NULL COMMENT '子项目id(zh_sub_project.id)',
  `tid` int(11) NOT NULL COMMENT '标段id(zh_tender.id)',
  `uid` int(11) NOT NULL COMMENT '授权用户id(zh_project_account.id)',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后编辑时间',
  `quality` varchar(255) NOT NULL DEFAULT '' COMMENT '质量管理权限(,分隔，具体见代码定义)',
  PRIMARY KEY (`id`)
);

CREATE TABLE `zh_quality_rule` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id',
  `pid` int(11) NOT NULL COMMENT '项目id',
  `spid` varchar(36) NOT NULL COMMENT '子项目id(zh_sub_project.id)',
  `group_id` varchar(36) NOT NULL COMMENT 'uuid(分组id)',
  `group_name` varchar(50) NOT NULL COMMENT '分组名称',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后更新时间',
  `user_id` int(11) UNSIGNED NOT NULL COMMENT '创建人',
  `name` varchar(50) NOT NULL DEFAULT '' COMMENT '规则名称',
  `condition` text NULL COMMENT '条件',
  `push_status` varchar(255) NOT NULL DEFAULT '' COMMENT '推送状态',
  `memo` varchar(255) NOT NULL DEFAULT '' COMMENT '备注',
  PRIMARY KEY (`id`)
);

CREATE TABLE `zh_quality`  (
  `id` varchar(36) NOT NULL COMMENT 'uuid',
  `tid` int(11) NOT NULL COMMENT '标段id(zh_tender.id)',
  `rela_type` varchar(10) NOT NULL COMMENT '台账类型(xmj/pos)',
  `rela_id` varchar(36) NOT NULL COMMENT '台账id(zh_ledger.id/zh_pos.id)',
  `rela_name` varchar(36) NOT NULL COMMENT '计量单元名称(zh_pos.name)',
  `gxby_status` tinyint(4) NOT NULL DEFAULT -1 COMMENT '工序报验状态',
  `gxby_date` timestamp NULL COMMENT '完工日期',
  `gxby_limit` tinyint(4) NOT NULL DEFAULT 0 COMMENT '计量是否受限',
  `dagl_status` tinyint(4) NOT NULL DEFAULT -1 COMMENT '档案管理状态',
  `dagl_limit` tinyint(4) NOT NULL DEFAULT 0 COMMENT '计量是否受限',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后更新时间',
  `create_uid` int(11) NOT NULL COMMENT '创建人',
  `update_uid` int(11) NOT NULL COMMENT '最后修改人',
  `is_used` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否使用',
  `group_id` varchar(36) NOT NULL DEFAULT '' COMMENT '规则判断组id(zh_quality_rule.group_id)',
  `kaigong_name` varchar(50) NOT NULL DEFAULT '' COMMENT '开工-名称',
  `kaigong_date` varchar(20) NOT NULL DEFAULT '' COMMENT '开工-计划开工日期',
  `kaigong_uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '开工-创建人',
  `kaigong_time` timestamp NULL COMMENT '开工-创建时间',
  PRIMARY KEY (`id`)
);

CREATE TABLE `zh_quality_file` (
  `id` varchar(36) NOT NULL COMMENT 'uuid',
  `tid` int(11) NOT NULL COMMENT '标段id(zh_tender.id)',
  `quality_id` varchar(36) NOT NULL COMMENT '质量管理id(zh_quality.id)',
  `rela_type` varchar(20) NOT NULL COMMENT '关联台账类型(xmj/pos)',
  `rela_id` varchar(36) NOT NULL COMMENT '关联台账id(zh_ledger.id/zh_pos.id)',
  `block_type` varchar(20) NOT NULL COMMENT '质量管理模块(kaigong/gongxu/...)',
  `block_id` varchar(36) NOT NULL COMMENT '质量管理模块id(zh_quality_gongxu.id/zh_quality_yinbi.id/...)',
  `user_id` int(11) UNSIGNED NOT NULL COMMENT '用户id(zh_project_account.id)',
  `user_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '用户名(缓存)',
  `user_company` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '公司(缓存)',
  `user_role` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '角色(缓存)',
  `filename` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '文件名',
  `fileext` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '文件类型',
  `filesize` int(11) UNSIGNED NOT NULL COMMENT '文件大小',
  `filepath` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '文件路径(oss路径)',
  `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最后更新时间',
  `is_deleted` tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否删除',
  `spec_type` varchar(20) NOT NULL DEFAULT '' COMMENT '特殊文件类型(质检qa)',
  PRIMARY KEY (`id`)
);

CREATE TABLE `zh_quality_gongxu` (
  `id` varchar(36) NOT NULL COMMENT 'uuid',
  `tid` int(11) NOT NULL COMMENT '标段id(zh_tender.id)',
  `quality_id` varchar(36) NOT NULL COMMENT '质量管理id(zh_quality.id)',
  `user_id` int(11) NOT NULL COMMENT '创建人id',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间',
  `name` varchar(100) NOT NULL DEFAULT '' COMMENT '名称',
  PRIMARY KEY (`id`)
);

CREATE TABLE `zh_quality_yinbi`  (
  `id` varchar(36) NOT NULL COMMENT 'uuid',
  `tid` int(11) NOT NULL COMMENT '标段id(zh_tender.id)',
  `quality_id` varchar(36) NOT NULL COMMENT '质量管理id(zh_quality.id)',
  `user_id` int(11) NOT NULL COMMENT '创建人id',
  `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最后修改时间',
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '名称',
  `gongxu_id` varchar(36) NOT NULL DEFAULT '' COMMENT '工序id(zh_quality_gongxu.id)',
  `gcbw` varchar(1000) NOT NULL DEFAULT '' COMMENT '工程部位',
  `content` varchar(1000) NOT NULL DEFAULT '' COMMENT '说明',
  PRIMARY KEY (`id`)
);

ALTER TABLE `zh_ledger_extra_0`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_1`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_2`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_3`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_4`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_5`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_6`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_7`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_8`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_9`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_10`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_11`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_12`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_13`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_14`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_15`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_16`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_17`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_18`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_19`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_20`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_21`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_22`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_23`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_24`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_25`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_26`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_27`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_28`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_29`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_30`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_31`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_32`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_33`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_34`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_35`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_36`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_37`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_38`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_39`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_40`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_41`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_42`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_43`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_44`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_45`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_46`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_47`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_48`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_49`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_50`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_51`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_52`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_53`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_54`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_55`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_56`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_57`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_58`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_59`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_60`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_61`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_62`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_63`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_64`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_65`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_66`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_67`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_68`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_69`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_70`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_71`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_72`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_73`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_74`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_75`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_76`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_77`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_78`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_79`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_80`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_81`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_82`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_83`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_84`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_85`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_86`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_87`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_88`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_89`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_90`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_91`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_92`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_93`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_94`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_95`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_96`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_97`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_98`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_ledger_extra_99`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;

ALTER TABLE `zh_pos_extra_0`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_1`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_2`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_3`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_4`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_5`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_6`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_7`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_8`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_9`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_10`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_11`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_12`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_13`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_14`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_15`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_16`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_17`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_18`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_19`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_20`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_21`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_22`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_23`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_24`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_25`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_26`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_27`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_28`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_29`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_30`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_31`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_32`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_33`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_34`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_35`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_36`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_37`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_38`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_39`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_40`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_41`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_42`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_43`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_44`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_45`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_46`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_47`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_48`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_49`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_50`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_51`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_52`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_53`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_54`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_55`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_56`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_57`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_58`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_59`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_60`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_61`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_62`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_63`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_64`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_65`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_66`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_67`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_68`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_69`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_70`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_71`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_72`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_73`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_74`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_75`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_76`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_77`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_78`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_79`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_80`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_81`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_82`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_83`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_84`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_85`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_86`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_87`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_88`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_89`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_90`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_91`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_92`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_93`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_94`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_95`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_96`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_97`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_98`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
ALTER TABLE `zh_pos_extra_99`
ADD COLUMN `wbs_url` varchar(255) NOT NULL DEFAULT '' COMMENT '联动计量配置' AFTER `gxby_id`;
------------------------------------
-- 表数据
------------------------------------