ALTER TABLE `sp_approve_history`
ADD COLUMN `remark`  varchar(255) NULL COMMENT '备注' AFTER `addTime`;


ALTER TABLE `sp_activity`
ADD COLUMN `transferContent`  varchar(255) NULL COMMENT '转交原因' AFTER `approveDate`;

ALTER TABLE `sp_activity`
ADD COLUMN `isTransfer`  varchar(1) NULL COMMENT '是否已经转交' AFTER `transferContent`;

ALTER TABLE `sp_activity`
ADD COLUMN `isBackUp`  varchar(1) NULL COMMENT '是否备案项目' AFTER `isTransfer`;


-- 修改政府项目为备案项目
update sp_activity set isBackUp=1 where isGov=1;

CREATE TABLE `change_log` (
  `oid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `sourceOid` bigint(20) DEFAULT NULL,
  `billId` varchar(50) DEFAULT NULL,
  `activityNo` varchar(50) DEFAULT NULL,
  `billCategory` varchar(255) DEFAULT NULL,
  `billType` varchar(255) DEFAULT NULL,
  `keyName` varchar(255) DEFAULT NULL,
  `text` varchar(255) DEFAULT NULL,
  `sourceVal` varchar(255) DEFAULT NULL,
  `nowVal` varchar(255) DEFAULT NULL,
  `changeVersion` varchar(255) DEFAULT NULL,
  `changeDate` datetime DEFAULT NULL,
  `isNew` varchar(1) DEFAULT NULL,
  `flagId` varchar(255) DEFAULT NULL,
  `markerRegionId` bigint(20) DEFAULT NULL COMMENT '落地省份',
  `source` varchar(255) DEFAULT NULL COMMENT '来源',
  `isUpdate` varchar(1) DEFAULT NULL,
  `createOn` datetime DEFAULT NULL,
  `updateOn` datetime DEFAULT NULL,
  PRIMARY KEY (`oid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

