Calculation/sql/update.sql

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`;

CREATE TABLE `zh_login_logging` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `browser` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '浏览器信息',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '登录时间',
  `ip` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '登录ip',
  `os` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '操作系统',
  `address` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '登录地址',
  `uid` int(11) NOT NULL COMMENT '用户id',
  `pid` int(11) NOT NULL COMMENT '项目id',
  `type` int(1) NOT NULL COMMENT '登录类型：1(sso登录) | 2(正常或副密码登录) | 3(接口登录或微信登录)',
  `show` int(1) NOT NULL COMMENT '是否显示: 0-显示，1-不显示',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=382 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='登录日志';

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`;

-- 2020-9-21
ALTER TABLE `zh_stage_jgcl`
ADD COLUMN `tid`  int(11) NULL COMMENT '标段id' AFTER `add_sid`;

Update zh_stage_jgcl LEFT JOIN zh_stage ON zh_stage_jgcl.sid = zh_stage.id Set zh_stage_jgcl.tid = zh_stage.tid