Calculation/sql/update.sql

CREATE TABLE `zh_notice` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` int(11) NOT NULL COMMENT '推送的类型',
  `uid` int(11) NOT NULL COMMENT '接收者id',
  `status` int(11) NOT NULL COMMENT '状态',
  `is_read` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否已读，0：未读，1：已读',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `pid` int(11) NOT NULL COMMENT '项目id',
  `content` text COLLATE utf8_unicode_ci NOT NULL COMMENT '推送必要的查询字段，如 ''{tid, mid}''',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='关注推送表';
SELECT * FROM calculation.zh_notice;

-- ----------------------------
-- 以上于2020-7-29 18:00 因更新至prod，尚未更新uat，如需增加sql，请一定在其后添加
-- ----------------------------

ALTER TABLE `zh_ledger`
ADD COLUMN `gxby_status`  tinyint(4) NULL DEFAULT 0 COMMENT '工序报验-状态' AFTER `qtcl_expr`,
ADD COLUMN `dagl_status`  tinyint(4) NULL DEFAULT 0 COMMENT '档案管理-状态' AFTER `gxby_status`;

ALTER TABLE `zh_pos`
ADD COLUMN `gxby_status`  int(4) NULL DEFAULT 0 COMMENT '工序报验-状态' AFTER `real_qty`,
ADD COLUMN `dagl_status`  int(4) NULL DEFAULT 0 COMMENT '档案管理-状态' AFTER `gxby_status`;