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

/*已使用*/
ALTER TABLE `risk_assessmentorg`
ADD COLUMN `linkUrl`  varchar(255) NULL DEFAULT NULL COMMENT '链接地址' AFTER `linkMode`;


/*以下为最新*/

/*2018年8月9日09:02:57*/
UPDATE `sys_marketregion` SET `oid`='330000', `createOn`=NULL, `updateOn`=NULL, `city`='', `parent_id`='100000', `province`='浙江省', `level`='1' WHERE (`oid`='330000');
INSERT INTO `sys_marketregion` (`oid`, `createOn`, `updateOn`, `city`, `parent_id`, `province`, `level`) VALUES ('330100', NULL, NULL, '杭州市', '330000', '', '2');
INSERT INTO `sys_marketregion` (`oid`, `createOn`, `updateOn`, `city`, `parent_id`, `province`, `level`) VALUES ('330600', NULL, NULL, '绍兴市', '330000', '', '2');


/*2018年8月10日11:17:14*/
UPDATE `sys_dict` SET `oid`='451', `createOn`=NULL, `updateOn`=NULL, `description`='用户类型', `label`='勘查相关人员', `sort`='15', `type`='USERTYPE', `value`='14' WHERE (`oid`='451');
UPDATE `risk_expert_type` SET `oid`='2', `createOn`='2018-08-10 11:17:56', `updateOn`='2018-08-10 11:17:56', `expertType`='14', `expertName`='勘查人员' WHERE (`oid`='2');
UPDATE `risk_expert_type` SET `oid`='3', `createOn`='2018-08-10 11:17:59', `updateOn`='2018-08-10 11:17:59', `expertType`='17', `expertName`='勘查专家' WHERE (`oid`='3');
UPDATE `sys_dict` SET `oid`='11', `createOn`=NULL, `updateOn`=NULL, `description`='材料类型', `label`='第一阶段勘查报告', `sort`='4', `type`='ACTIVITYMATERIALTYPE', `value`='4' WHERE (`oid`='11');
UPDATE `sys_dict` SET `oid`='12', `createOn`=NULL, `updateOn`=NULL, `description`='材料类型', `label`='第二阶段勘查报告', `sort`='5', `type`='ACTIVITYMATERIALTYPE', `value`='5' WHERE (`oid`='12');
UPDATE `sys_dict` SET `oid`='13', `createOn`=NULL, `updateOn`=NULL, `description`='材料类型', `label`='第三阶段勘查报告', `sort`='6', `type`='ACTIVITYMATERIALTYPE', `value`='6' WHERE (`oid`='13');
UPDATE `sys_dict` SET `oid`='115', `createOn`=NULL, `updateOn`=NULL, `description`='活动状态阶段', `label`='第一阶段勘查已完成', `sort`='4', `type`='ACTIVITYSUBSTEP', `value`='25' WHERE (`oid`='115');
UPDATE `sys_dict` SET `oid`='119', `createOn`=NULL, `updateOn`=NULL, `description`='活动状态阶段', `label`='第二阶段勘查已完成', `sort`='8', `type`='ACTIVITYSUBSTEP', `value`='45' WHERE (`oid`='119');
UPDATE `sys_dict` SET `oid`='121', `createOn`=NULL, `updateOn`=NULL, `description`='活动状态阶段', `label`='第三阶段勘查已完成', `sort`='11', `type`='ACTIVITYSUBSTEP', `value`='55' WHERE (`oid`='121');
UPDATE `sys_dict` SET `oid`='135', `createOn`=NULL, `updateOn`=NULL, `description`='勘查阶段', `label`='第一阶段勘查', `sort`='1', `type`='SURVEYSTEP', `value`='1' WHERE (`oid`='135');
UPDATE `sys_dict` SET `oid`='136', `createOn`=NULL, `updateOn`=NULL, `description`='勘查阶段', `label`='第二阶段勘查', `sort`='2', `type`='SURVEYSTEP', `value`='2' WHERE (`oid`='136');
UPDATE `sys_dict` SET `oid`='137', `createOn`=NULL, `updateOn`=NULL, `description`='勘查阶段', `label`='第三阶段勘查', `sort`='3', `type`='SURVEYSTEP', `value`='3' WHERE (`oid`='137');
UPDATE `sys_dict` SET `oid`='169', `createOn`=NULL, `updateOn`=NULL, `description`='任务类型', `label`='现场勘查', `sort`='2', `type`='TASKTYPE', `value`='2' WHERE (`oid`='169');
UPDATE `sys_dict` SET `oid`='177', `createOn`=NULL, `updateOn`=NULL, `description`='勘查任务状态', `label`='新任务', `sort`='1', `type`='SURVEYTASKSTATUS', `value`='1' WHERE (`oid`='177');
UPDATE `sys_dict` SET `oid`='177', `createOn`=NULL, `updateOn`=NULL, `description`='勘查任务状态', `label`='新任务', `sort`='1', `type`='SURVEYTASKSTATUS', `value`='1' WHERE (`oid`='177');
UPDATE `sys_dict` SET `oid`='178', `createOn`=NULL, `updateOn`=NULL, `description`='勘查任务状态', `label`='超时', `sort`='2', `type`='SURVEYTASKSTATUS', `value`='2' WHERE (`oid`='178');
UPDATE `sys_dict` SET `oid`='179', `createOn`=NULL, `updateOn`=NULL, `description`='勘查任务状态', `label`='进行中', `sort`='3', `type`='SURVEYTASKSTATUS', `value`='3' WHERE (`oid`='179');
UPDATE `sys_dict` SET `oid`='180', `createOn`=NULL, `updateOn`=NULL, `description`='勘查任务状态', `label`='勘察结束已办结', `sort`='4', `type`='SURVEYTASKSTATUS', `value`='4' WHERE (`oid`='180');
UPDATE `sys_dict` SET `oid`='181', `createOn`=NULL, `updateOn`=NULL, `description`='勘查任务状态', `label`='已拒绝', `sort`='5', `type`='SURVEYTASKSTATUS', `value`='5' WHERE (`oid`='181');
UPDATE `sys_dict` SET `oid`='182', `createOn`=NULL, `updateOn`=NULL, `description`='勘查任务状态', `label`='已转交', `sort`='6', `type`='SURVEYTASKSTATUS', `value`='6' WHERE (`oid`='182');
UPDATE `sys_dict` SET `oid`='183', `createOn`=NULL, `updateOn`=NULL, `description`='勘查任务状态', `label`='转交审核中', `sort`='7', `type`='SURVEYTASKSTATUS', `value`='7' WHERE (`oid`='183');
UPDATE `sys_dict` SET `oid`='184', `createOn`=NULL, `updateOn`=NULL, `description`='勘查任务状态', `label`='已过活动时间', `sort`='8', `type`='SURVEYTASKSTATUS', `value`='8' WHERE (`oid`='184');
UPDATE `sys_dict` SET `oid`='185', `createOn`=NULL, `updateOn`=NULL, `description`='勘查任务状态', `label`='其他', `sort`='9', `type`='SURVEYTASKSTATUS', `value`='9' WHERE (`oid`='185');
UPDATE `sys_dict` SET `oid`='186', `createOn`=NULL, `updateOn`=NULL, `description`='勘查任务状态', `label`='全部', `sort`='10', `type`='SURVEYTASKSTATUS', `value`='10' WHERE (`oid`='186');
UPDATE `sys_dict` SET `oid`='193', `createOn`=NULL, `updateOn`=NULL, `description`='勘查问题类型', `label`='开放问题', `sort`='1', `type`='QUESTIONTYPE', `value`='1' WHERE (`oid`='193');
UPDATE `sys_dict` SET `oid`='194', `createOn`=NULL, `updateOn`=NULL, `description`='勘查问题类型', `label`='固定问题', `sort`='2', `type`='QUESTIONTYPE', `value`='2' WHERE (`oid`='194');
UPDATE `sys_dict` SET `oid`='195', `createOn`=NULL, `updateOn`=NULL, `description`='勘查问题类型', `label`='补充问题', `sort`='3', `type`='QUESTIONTYPE', `value`='3' WHERE (`oid`='195');
UPDATE `sys_dict` SET `oid`='196', `createOn`=NULL, `updateOn`=NULL, `description`='勘查问题类型', `label`='遗留问题', `sort`='4', `type`='QUESTIONTYPE', `value`='4' WHERE (`oid`='196');
UPDATE `sys_dict` SET `oid`='241', `createOn`=NULL, `updateOn`=NULL, `description`='专家任务类型', `label`='勘查', `sort`='1', `type`='EXPERTTASKTYPE', `value`='1' WHERE (`oid`='241');
UPDATE `sys_dict` SET `oid`='546', `createOn`=NULL, `updateOn`=NULL, `description`='用户类型', `label`='勘查专家', `sort`='17', `type`='USERTYPE', `value`='17' WHERE (`oid`='546');
UPDATE `sys_dict` SET `oid`='547', `createOn`=NULL, `updateOn`=NULL, `description`='用户类型', `label`='勘查项目经理', `sort`='18', `type`='USERTYPE', `value`='18' WHERE (`oid`='547');

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

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

/*2018年8月17日09:37:06*/
INSERT INTO `risk_menu` (`oid`, `createOn`, `updateOn`, `menuCode`, `menuDesc`, `menuName`, `parent_id`, `menuType`) VALUES ('1020220', '2018-08-15 13:26:54', NULL, NULL, '20', '勘查管理', '10202', '2');
INSERT INTO `risk_menu` (`oid`, `createOn`, `updateOn`, `menuCode`, `menuDesc`, `menuName`, `parent_id`, `menuType`) VALUES ('1020221', '2018-08-15 13:26:54', NULL, NULL, '21', '协助管理', '10202', '2');
INSERT INTO `risk_menu` (`oid`, `createOn`, `updateOn`, `menuCode`, `menuDesc`, `menuName`, `parent_id`, `menuType`) VALUES ('1020214', '2018-06-15 09:47:10', NULL, NULL, '14', '勘查任务', '10202', '2');

INSERT INTO `sys_dict` (`oid`, `createOn`, `updateOn`, `description`, `label`, `sort`, `type`, `value`) VALUES ('600', NULL, NULL, '用户类型', '勘查区域经理', '19', 'USERTYPE', '19');

INSERT INTO `risk_menu` (`oid`, `createOn`, `updateOn`, `menuCode`, `menuDesc`, `menuName`, `parent_id`, `menuType`) VALUES ('10114', '2018-06-20 11:10:08', NULL, NULL, '14', '数据录入', '101', '1');
INSERT INTO `risk_menu` (`oid`, `createOn`, `updateOn`, `menuCode`, `menuDesc`, `menuName`, `parent_id`, `menuType`) VALUES ('1011401', '2018-08-17 00:00:00', NULL, NULL, '1', '数据列表', '10114', '2');
INSERT INTO `risk_menu` (`oid`, `createOn`, `updateOn`, `menuCode`, `menuDesc`, `menuName`, `parent_id`, `menuType`) VALUES ('1011402', '2018-08-17 00:00:00', NULL, NULL, '2', '数据录入', '10114', '2');


UPDATE `sys_dict` SET `oid`='125', `createOn`=NULL, `updateOn`=NULL, `description`='报告发送类型', `label`='不需要纸质评估报告', `sort`='1', `type`='REPORTEXPRESS', `value`='0' WHERE (`oid`='125');
UPDATE `sys_dict` SET `oid`='126', `createOn`=NULL, `updateOn`=NULL, `description`='报告发送类型', `label`='需要纸质评估报告', `sort`='2', `type`='REPORTEXPRESS', `value`='1' WHERE (`oid`='126');