update sys_dict set value = '100001' where type = 'ACTIVITYTYPE' and value = 1;
update sys_dict set value = '100002' where type = 'ACTIVITYTYPE' and value = 2;
update sys_dict set value = '100003' where type = 'ACTIVITYTYPE' and value = 3;
update sys_dict set value = '100004' where type = 'ACTIVITYTYPE' and value = 4;
update sys_dict set value = '100005' where type = 'ACTIVITYTYPE' and value = 5;
update sys_dict set value = '100006' where type = 'ACTIVITYTYPE' and value = 6;
update sys_dict set value = '100007' where type = 'ACTIVITYTYPE' and value = 7;

delete from sys_dict where type = 'COMPOSEFRAMETYPE';

update risk_activity set activityType = '100001' where activityType = 1;
update risk_activity set activityType = '100002' where activityType = 2;
update risk_activity set activityType = '100003' where activityType = 3;
update risk_activity set activityType = '100004' where activityType = 4;
update risk_activity set activityType = '100005' where activityType = 5;
update risk_activity set activityType = '100006' where activityType = 6;
update risk_activity set activityType = '100007' where activityType = 7;
update risk_activity set activityType = '100001' where activityType is null;

insert into sys_dict(description,label,sort,type,value) values('活动来源','在线申报',1,'ACTIVITYSOURCE',1);
insert into sys_dict(description,label,sort,type,value) values('活动来源','系统录入',2,'ACTIVITYSOURCE',2);

update risk_news rn,sys_dict sd set rn.category=sd.label
where rn.category=sd.`value` and sd.type='categorynews';


delete from risk_synctask where syncTaskType in ('10','15','16');


update risk_activity set activitySource = 1 where activitySource is null;

update risk_activity set activityStatus = 10 where oid = 110352;
update risk_activity set activityStatus = 10 where oid = 110353;
update risk_activity set activityStatus = 10 where oid = 110354;


update risk_materialformattrtemplate set tips = CONCAT(tips,'需加盖公章') where attrCode in (
'A3',
'A98',
'A6',
'A20',
'A89',
'A41',
'D40',
'E18',
'E20',
'E69',
'E19',
'E21',
'E64',
'F39',
'F14'
) ;


update risk_materialformattrtemplate set tips = CONCAT(tips,'，需加盖公章') where attrCode in (
'A19',
'D7',
'E17',
'F36',
'F40'
) ;


DROP TABLE IF EXISTS `sys_marketregion`;
CREATE TABLE `sys_marketregion`  (
  `oid` bigint(20) NOT NULL COMMENT '主键ID',
  `createOn` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `updateOn` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
  `city` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '市/县',
  `parent_id` bigint(20) NULL DEFAULT NULL COMMENT '父级编码',
  `province` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '省',
  `level` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '层级',
  `website` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '链接网站',
  `platform` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '平台名称',
  `independent` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '独立网站',
  PRIMARY KEY (`oid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'pss上线城市列表' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of sys_marketregion
-- ----------------------------
INSERT INTO `sys_marketregion` VALUES (100000, '2017-09-14 17:29:07', '2017-09-14 17:29:09', NULL, NULL, '全国', '0', NULL, NULL, '0');
INSERT INTO `sys_marketregion` VALUES (330000, NULL, NULL, '', 100000, '浙江省', '1', 'http://test2.pss360.cn', '浙江省大型活动安全管理服务信息平台', '1');
INSERT INTO `sys_marketregion` VALUES (330100, NULL, NULL, '杭州市', 330000, '', '2', 'http://test2.pss360.cn', '杭州市大型活动安全管理服务信息平台', '1');
INSERT INTO `sys_marketregion` VALUES (330600, NULL, NULL, '绍兴市', 330000, '', '2', NULL, NULL, '0');
INSERT INTO `sys_marketregion` VALUES (450000, '2017-06-23 10:28:50', '2017-06-23 10:28:50', '', 100000, '广西壮族自治区', '1', 'http://test2.pss360.cn', '广西大型活动安全管理服务信息平台', '1');
INSERT INTO `sys_marketregion` VALUES (450100, '2017-06-23 10:28:50', '2017-06-23 10:28:50', '南宁市', 450000, '', '2', NULL, NULL, '0');
INSERT INTO `sys_marketregion` VALUES (450200, '2017-06-27 17:29:33', '2017-06-27 17:29:33', '柳州市', 450000, '', '2', NULL, NULL, '0');
INSERT INTO `sys_marketregion` VALUES (450300, '2017-06-23 10:28:50', '2017-06-23 10:28:50', '桂林市', 450000, '', '2', NULL, NULL, '0');
INSERT INTO `sys_marketregion` VALUES (450400, '2017-06-27 17:29:33', '2017-06-27 17:29:33', '梧州市', 450000, '', '2', NULL, NULL, '0');
INSERT INTO `sys_marketregion` VALUES (450500, '2017-06-27 17:29:33', '2017-06-27 17:29:33', '北海市', 450000, '', '2', NULL, NULL, '0');
INSERT INTO `sys_marketregion` VALUES (450600, '2017-06-27 17:29:33', '2017-06-27 17:29:33', '防城港市', 450000, '', '2', NULL, NULL, '0');
INSERT INTO `sys_marketregion` VALUES (450700, '2017-06-27 17:29:33', '2017-06-27 17:29:33', '钦州市', 450000, '', '2', NULL, NULL, '0');
INSERT INTO `sys_marketregion` VALUES (450800, '2017-06-27 17:29:33', '2017-06-27 17:29:33', '贵港市', 450000, '', '2', NULL, NULL, '0');
INSERT INTO `sys_marketregion` VALUES (450900, '2017-06-27 17:29:33', '2017-06-27 17:29:33', '玉林市', 450000, '', '2', NULL, NULL, '0');
INSERT INTO `sys_marketregion` VALUES (451000, '2017-06-27 17:29:33', '2017-06-27 17:29:33', '百色市', 450000, '', '2', NULL, NULL, '0');
INSERT INTO `sys_marketregion` VALUES (451100, '2017-06-27 17:29:33', '2017-06-27 17:29:33', '贺州市', 450000, '', '2', NULL, NULL, '0');
INSERT INTO `sys_marketregion` VALUES (451200, '2017-06-27 17:29:33', '2017-06-27 17:29:33', '河池市', 450000, '', '2', NULL, NULL, '0');
INSERT INTO `sys_marketregion` VALUES (451300, '2017-06-27 17:29:33', '2017-06-27 17:29:33', '来宾市', 450000, '', '2', NULL, NULL, '0');
INSERT INTO `sys_marketregion` VALUES (451400, '2017-06-27 17:29:33', '2017-06-27 17:29:33', '崇左市', 450000, '', '2', NULL, NULL, '0');
INSERT INTO `sys_marketregion` VALUES (610000, '2017-09-12 19:48:34', '2017-09-12 19:48:34', '', 100000, '陕西省', '1', 'http://test2.pss360.cn', '陕西省大型活动安全管理信息系统', '1');
INSERT INTO `sys_marketregion` VALUES (610100, '2017-09-12 19:48:34', '2017-09-12 19:48:34', '西安市', 610000, '', '2', NULL, NULL, '0');
INSERT INTO `sys_marketregion` VALUES (610200, '2017-09-12 19:48:34', '2017-09-12 19:48:34', '铜川市', 610000, '', '2', NULL, NULL, '0');
INSERT INTO `sys_marketregion` VALUES (610300, '2017-09-12 19:48:34', '2017-09-12 19:48:34', '宝鸡市', 610000, '', '2', NULL, NULL, '0');
INSERT INTO `sys_marketregion` VALUES (610400, '2017-09-12 19:48:34', '2017-09-12 19:48:34', '咸阳市', 610000, '', '2', NULL, NULL, '0');
INSERT INTO `sys_marketregion` VALUES (610500, '2017-09-12 19:48:34', '2017-09-12 19:48:34', '渭南市', 610000, '', '2', NULL, NULL, '0');
INSERT INTO `sys_marketregion` VALUES (610600, '2017-09-12 19:48:34', '2017-09-12 19:48:34', '延安市', 610000, '', '2', NULL, NULL, '0');
INSERT INTO `sys_marketregion` VALUES (610700, '2017-09-12 19:48:34', '2017-09-12 19:48:34', '汉中市', 610000, '', '2', NULL, NULL, '0');
INSERT INTO `sys_marketregion` VALUES (610800, '2017-09-12 19:48:34', '2017-09-12 19:48:34', '榆林市', 610000, '', '2', NULL, NULL, '0');
INSERT INTO `sys_marketregion` VALUES (610900, '2017-09-12 19:48:34', '2017-09-12 19:48:34', '安康市', 610000, '', '2', NULL, NULL, '0');
INSERT INTO `sys_marketregion` VALUES (611000, '2017-09-12 19:48:34', '2017-09-12 19:48:34', '商洛市', 610000, '', '2', NULL, NULL, '0');
INSERT INTO `sys_marketregion` VALUES (611100, '2017-09-12 19:48:34', '2017-09-12 19:48:34', '杨凌示范区', 610000, '', '2', NULL, NULL, '0');
INSERT INTO `sys_marketregion` VALUES (617000, '2017-09-12 19:48:34', '2017-09-12 19:48:34', '西咸新区', 610000, '', '2', NULL, NULL, '0');


delete from risk_systemconfig where `syskey` = 'pgjg_helpdoc_url';
INSERT INTO `risk_systemconfig`( `createOn`, `updateOn`, `syskey`, `sysvalue`, `description`) VALUES ('2018-07-10 17:17:11', '2018-07-10 17:17:11', 'pgjg_helpdoc_url', 'http://47.93.117.58:8012/preview?token=aHR0cDovL2JjeGludmVkaW8ub3NzLWNuLXNoYW5naGFpLmFsaXl1bmNzLmNvbS9wZWl4dW4vZHhoZC96aHV6eWZwLW1hbnVhbC5wZGY=', '风评机构操作手册文档路径');
INSERT INTO `risk_systemconfig`(`createOn`, `updateOn`, `syskey`, `sysvalue`, `description`) VALUES ( '2018-08-29 14:34:22', '2018-08-29 14:34:23', 'dsfpgjg_helpdoc_url', 'http://47.93.117.58:8012/preview?token=aHR0cDovL2JjeGludmVkaW8ub3NzLWNuLXNoYW5naGFpLmFsaXl1bmNzLmNvbS9wZWl4dW4vZHhoZC96aHVkc2ZmcC1tYW51YWwucGRm', '第三方风评机构操作手册文档路径');