/*已使用*/
ALTER TABLE `risk_assessment`
ADD COLUMN `linkMode`  varchar(255) NULL COMMENT '链接模式（0否，1是）' AFTER `provinceId`;
/*已使用*/
ALTER TABLE `risk_assessment`
ADD COLUMN `linkUrl`  varchar(255) NULL DEFAULT NULL COMMENT '链接地址' AFTER `linkMode`;

/*2018年8月10日13:56:32*/
UPDATE `risk_materialformattrtemplate` SET `oid`='3', `createOn`='2016-09-13 11:39:19', `updateOn`='2016-09-13 11:39:26', `optionType`=NULL, `attrCode`='A3', `attrName`='营业执照', `events`='', `isPageHidden`='0', `isRequired`=b'1', `script`='', `seq`='40', `tips`='需加盖公章', `type`='pic', `mainEle`='0', `menuTemplate_id`='1', `activityType`=NULL, `supportProvince`=NULL, `maxFileSize`=NULL WHERE (`oid`='3');
UPDATE `risk_materialformattrtemplate` SET `oid`='114', `createOn`='2016-12-22 21:26:48', `updateOn`='2016-12-22 21:26:48', `optionType`=NULL, `attrCode`='A98', `attrName`='事业单位法人证书', `events`='', `isPageHidden`='0', `isRequired`=b'1', `script`='', `seq`='45', `tips`='需加盖公章', `type`='pic', `mainEle`='0', `menuTemplate_id`='1', `activityType`=NULL, `supportProvince`=NULL, `maxFileSize`=NULL WHERE (`oid`='114');
UPDATE `risk_materialformattrtemplate` SET `oid`='5', `createOn`='2016-09-13 13:43:47', `updateOn`='2016-09-13 13:43:47', `optionType`=NULL, `attrCode`='A6', `attrName`='大型群众性活动安全许可申请表', `events`='', `isPageHidden`='0', `isRequired`=b'1', `script`='', `seq`='50', `tips`='需加盖公章', `type`='pic', `mainEle`='1', `menuTemplate_id`='1', `activityType`=NULL, `supportProvince`=NULL, `maxFileSize`=NULL WHERE (`oid`='5');
UPDATE `risk_materialformattrtemplate` SET `oid`='30', `createOn`='2016-09-13 20:28:27', `updateOn`='2016-09-13 20:28:27', `optionType`=NULL, `attrCode`='A20', `attrName`='安全责任人身份证明', `events`='', `isPageHidden`='0', `isRequired`=b'1', `script`='', `seq`='60', `tips`='需加盖公章', `type`='pic', `mainEle`='1', `menuTemplate_id`='1', `activityType`=NULL, `supportProvince`=NULL, `maxFileSize`=NULL WHERE (`oid`='30');
UPDATE `risk_materialformattrtemplate` SET `oid`='4', `createOn`='2016-09-13 13:43:47', `updateOn`='2016-09-13 13:43:47', `optionType`=NULL, `attrCode`='A89', `attrName`='社会团体法人登记证书', `events`='', `isPageHidden`='0', `isRequired`=b'0', `script`='', `seq`='75', `tips`='需加盖公章', `type`='pic', `mainEle`='0', `menuTemplate_id`='1', `activityType`=NULL, `supportProvince`=NULL, `maxFileSize`=NULL WHERE (`oid`='4');
UPDATE `risk_materialformattrtemplate` SET `oid`='23', `createOn`='2016-09-13 20:28:26', `updateOn`='2016-09-13 20:28:26', `optionType`=NULL, `attrCode`='A41', `attrName`='资质、资格证明文件', `events`='', `isPageHidden`='0', `isRequired`=b'0', `script`='', `seq`='65', `tips`='需加盖公章', `type`='pic', `mainEle`='0', `menuTemplate_id`='5', `activityType`=NULL, `supportProvince`=NULL, `maxFileSize`=NULL WHERE (`oid`='23');
UPDATE `risk_materialformattrtemplate` SET `oid`='77', `createOn`='2016-09-14 14:56:22', `updateOn`='2016-09-14 14:56:22', `optionType`=NULL, `attrCode`='D7', `attrName`='场地使用证明/服务协议', `events`='', `isPageHidden`='0', `isRequired`=b'1', `script`='', `seq`='6', `tips`='活动场所管理者同意提供活动场所的证明、安全责任协议等，需加盖公章', `type`='pic', `mainEle`='0', `menuTemplate_id`='10', `activityType`=NULL, `supportProvince`=NULL, `maxFileSize`=NULL WHERE (`oid`='77');
UPDATE `risk_materialformattrtemplate` SET `oid`='120', `createOn`='2017-03-09 20:13:44', `updateOn`='2017-03-09 20:13:44', `optionType`=NULL, `attrCode`='D40', `attrName`='管理者身份证明', `events`='', `isPageHidden`='0', `isRequired`=b'0', `script`='', `seq`='7', `tips`='需加盖公章', `type`='pic', `mainEle`='0', `menuTemplate_id`='10', `activityType`=NULL, `supportProvince`=NULL, `maxFileSize`=NULL WHERE (`oid`='120');
UPDATE `risk_materialformattrtemplate` SET `oid`='94', `createOn`='2016-09-14 15:02:38', `updateOn`='2016-09-14 15:02:38', `optionType`=NULL, `attrCode`='E18', `attrName`='营业执照', `events`='', `isPageHidden`='0', `isRequired`=b'1', `script`='', `seq`='27', `tips`='需加盖公章', `type`='pic', `mainEle`='0', `menuTemplate_id`='18', `activityType`=NULL, `supportProvince`=NULL, `maxFileSize`=NULL WHERE (`oid`='94');
UPDATE `risk_materialformattrtemplate` SET `oid`='96', `createOn`='2016-09-14 15:02:38', `updateOn`='2016-09-14 15:02:38', `optionType`=NULL, `attrCode`='E20', `attrName`='资质证明', `events`='', `isPageHidden`='0', `isRequired`=b'1', `script`='', `seq`='29', `tips`='需加盖公章', `type`='pic', `mainEle`='0', `menuTemplate_id`='18', `activityType`=NULL, `supportProvince`=NULL, `maxFileSize`=NULL WHERE (`oid`='96');
UPDATE `risk_materialformattrtemplate` SET `oid`='128', `createOn`='2017-03-09 20:28:57', `updateOn`='2017-03-09 20:28:57', `optionType`=NULL, `attrCode`='E69', `attrName`='法人身份证明', `events`='', `isPageHidden`='0', `isRequired`=b'0', `script`='', `seq`='35', `tips`='需加盖公章', `type`='pic', `mainEle`='0', `menuTemplate_id`='18', `activityType`=NULL, `supportProvince`=NULL, `maxFileSize`=NULL WHERE (`oid`='128');
UPDATE `risk_materialformattrtemplate` SET `oid`='95', `createOn`='2016-09-14 15:02:38', `updateOn`='2016-09-14 15:02:38', `optionType`=NULL, `attrCode`='E19', `attrName`='安全生产许可证', `events`='', `isPageHidden`='0', `isRequired`=b'0', `script`='', `seq`='40', `tips`='需加盖公章', `type`='pic', `mainEle`='0', `menuTemplate_id`='18', `activityType`=NULL, `supportProvince`=NULL, `maxFileSize`=NULL WHERE (`oid`='95');
UPDATE `risk_materialformattrtemplate` SET `oid`='93', `createOn`='2016-09-14 15:02:38', `updateOn`='2016-09-14 15:02:38', `optionType`=NULL, `attrCode`='E17', `attrName`='服务协议', `events`='', `isPageHidden`='0', `isRequired`=b'0', `script`='', `seq`='45', `tips`='请提供承办者与临建施工单位签订的施工协议书，包括搭建委托书、质量安全承诺书等，需加盖公章', `type`='pic', `mainEle`='0', `menuTemplate_id`='18', `activityType`=NULL, `supportProvince`=NULL, `maxFileSize`=NULL WHERE (`oid`='93');
UPDATE `risk_materialformattrtemplate` SET `oid`='132', `createOn`='2017-03-10 13:31:11', `updateOn`='2017-03-10 13:31:11', `optionType`=NULL, `attrCode`='E64', `attrName`='资质、资格证明文件', `events`='', `isPageHidden`='0', `isRequired`=b'0', `script`='', `seq`='37', `tips`='需加盖公章', `type`='pic', `mainEle`='0', `menuTemplate_id`='19', `activityType`=NULL, `supportProvince`=NULL, `maxFileSize`=NULL WHERE (`oid`='132');
UPDATE `risk_materialformattrtemplate` SET `oid`='138', `createOn`='2017-03-10 13:31:11', `updateOn`='2017-03-10 13:31:11', `optionType`=NULL, `attrCode`='F39', `attrName`='资质、资格证明文件', `events`='', `isPageHidden`='0', `isRequired`=b'0', `script`='', `seq`='3', `tips`='需加盖公章', `type`='pic', `mainEle`='0', `menuTemplate_id`='21', `activityType`=NULL, `supportProvince`=NULL, `maxFileSize`=NULL WHERE (`oid`='138');
UPDATE `risk_materialformattrtemplate` SET `oid`='139', `createOn`='2017-03-10 13:31:11', `updateOn`='2017-03-10 13:31:11', `optionType`=NULL, `attrCode`='F40', `attrName`='聘请保安证明材料', `events`='', `isPageHidden`='0', `isRequired`=b'0', `script`='', `seq`='4', `tips`='请上传聘请保安的相关证明材料如聘请安保承诺书、聘用合同，需加盖公章', `type`='pic', `mainEle`='0', `menuTemplate_id`='21', `activityType`=NULL, `supportProvince`=NULL, `maxFileSize`=NULL WHERE (`oid`='139');
UPDATE `risk_materialformattrtemplate` SET `oid`='109', `createOn`='2016-09-19 21:45:38', `updateOn`='2016-09-19 21:45:38', `optionType`=NULL, `attrCode`='F36', `attrName`='医疗救护协议书', `events`='', `isPageHidden`='0', `isRequired`=b'0', `script`='', `seq`='50', `tips`='如有与医疗组签订协议书，请上传，需加盖公章', `type`='pic', `mainEle`='0', `menuTemplate_id`='22', `activityType`=NULL, `supportProvince`=NULL, `maxFileSize`=NULL WHERE (`oid`='109');
UPDATE `risk_materialformattrtemplate` SET `oid`='53', `createOn`='2016-09-14 14:36:30', `updateOn`='2016-09-14 14:36:30', `optionType`=NULL, `attrCode`='F14', `attrName`='防爆安检人员资格证明', `events`='', `isPageHidden`='0', `isRequired`=b'0', `script`='', `seq`='33', `tips`='需加盖公章', `type`='pic', `mainEle`='0', `menuTemplate_id`='25', `activityType`=NULL, `supportProvince`=NULL, `maxFileSize`=NULL WHERE (`oid`='53');

/*2018年8月13日10:12:58*/
ALTER TABLE `risk_assessment`
DROP COLUMN `iconUrl`;

ALTER TABLE `risk_assessment`
ADD COLUMN `bgpUrl`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '背景图片地址' AFTER `linkUrl`;
ALTER TABLE `risk_assessment`
ADD COLUMN `areaOneTitle`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区域一标题' AFTER `bgpUrl`;
ALTER TABLE `risk_assessment`
ADD COLUMN `areaOneContent`  varchar(2550) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区域一内容' AFTER `areaOneTitle`;
ALTER TABLE `risk_assessment`
ADD COLUMN `areaOnePicUrl`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '区域一图片地址' AFTER `areaOneContent`;
ALTER TABLE `risk_assessment`
ADD COLUMN `areaTwoTitle`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区域二区域标题' AFTER `areaOnePicUrl`;
ALTER TABLE `risk_assessment`
ADD COLUMN `areaTwoLittleTitle`  varchar(2550) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区域二小标题用英文",.@"隔开' AFTER `areaTwoTitle`;
ALTER TABLE `risk_assessment`
ADD COLUMN `areaTwoContent`  mediumtext NULL COMMENT '区域二内容，用英文\",.@\"隔开' AFTER `areaTwoLittleTitle`;
ALTER TABLE `risk_assessment`
ADD COLUMN `areaTwoPicUrl`  varchar(2550) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区域二图片地址，用英文",.@"隔开' AFTER `areaTwoContent`;
ALTER TABLE `risk_assessment`
ADD COLUMN `areaThreeTitle`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区域三标题' AFTER `areaTwoPicUrl`;
ALTER TABLE `risk_assessment`
ADD COLUMN `areaThreeContent`  varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区域三内容' AFTER `areaThreeTitle`;
ALTER TABLE `risk_assessment`
ADD COLUMN `areaThreePicUrl`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区域三图片地址' AFTER `areaThreeContent`;
ALTER TABLE `risk_assessment`
ADD COLUMN `areaFourTitle`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区域四标题' AFTER `areaThreePicUrl`;
ALTER TABLE `risk_assessment`
ADD COLUMN `areaFourContent`  varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区域四内容' AFTER `areaFourTitle`;
