ALTER TABLE `zh_project` CHANGE `page_show` `page_show` VARCHAR(5000) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '{\"bwtz\":\"1\"}' COMMENT '前台页面或功能展示与隐藏';

ALTER TABLE `zh_change_audit_list` ADD `xmj_code` VARCHAR(500) NULL DEFAULT NULL COMMENT '项目节编号' AFTER `detail`, ADD `xmj_jldy` VARCHAR(500) NULL DEFAULT NULL COMMENT '细目' AFTER `xmj_code`;

ALTER TABLE `zh_login_logging`
ADD COLUMN `type` INT(1) NOT NULL COMMENT '登录类型 1(sso登录) | 2(正常或副密码登录) | 3(接口登录或微信登录)' AFTER `pid`, ADD `show` INT(1) NOT NULL COMMENT '是否显示: 0-显示，1-不显示' AFTER `TYPE`;

ALTER TABLE `zh_material_bills` ADD `is_summary` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '是否汇总' AFTER `remark`;

ALTER TABLE `zh_material_bills_history` ADD `is_summary` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '是否汇总' AFTER `pre_tp`;

ALTER TABLE `zh_deal_bills`
MODIFY COLUMN `id`  varchar(50) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL COMMENT '主键(uuid)' FIRST ,
CHANGE COLUMN `deal_id` `order`  int(11) NOT NULL AFTER `tender_id`;

