#浙江
INSERT INTO `risk_systemconfig`(`createOn`, `updateOn`, `syskey`, sysvalue, `description`) VALUES (now(), now(), 'host_unit_cn','浙江公安厅', '主办单位');

#广西
INSERT INTO `risk_systemconfig`(`createOn`, `updateOn`, `syskey`, sysvalue, `description`) VALUES (now(), now(), 'host_unit_cn','广西公安厅', '主办单位');

#陕西
INSERT INTO `risk_systemconfig`(`createOn`, `updateOn`, `syskey`, sysvalue, `description`) VALUES (now(), now(), 'host_unit_cn','陕西公安厅', '主办单位');

#杭州
INSERT INTO `risk_systemconfig`(`createOn`, `updateOn`, `syskey`, `sysvalue`, `description`) VALUES (now(), now(), 'switch_copyDir', 'on', '开关：复制文件夹');
INSERT INTO `risk_systemconfig`(`createOn`, `updateOn`, `syskey`, `sysvalue`, `description`) VALUES (now(), now(), 'copyDir_path', '/data/pss/material_cp/', '复制文件夹目录');





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 base_dict set value = '100001' where type = 'ACTIVITYTYPE' and value = 1;
update base_dict set value = '100002' where type = 'ACTIVITYTYPE' and value = 2;
update base_dict set value = '100003' where type = 'ACTIVITYTYPE' and value = 3;
update base_dict set value = '100004' where type = 'ACTIVITYTYPE' and value = 4;
update base_dict set value = '100005' where type = 'ACTIVITYTYPE' and value = 5;
update base_dict set value = '100006' where type = 'ACTIVITYTYPE' and value = 6;
update base_dict set value = '100007' where type = 'ACTIVITYTYPE' and value = 7;


ALTER TABLE `risk_activity`
ADD COLUMN `activitySource`  varchar(10) NULL DEFAULT NULL COMMENT '活动来源';

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

update risk_activity set activitySource = 1;


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


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



ALTER TABLE `config_materialformattrtemplate`
ADD COLUMN `locked` varchar(10) NULL COMMENT '元素是否锁定' AFTER `maxFileSize`;


ALTER TABLE `risk_materialformattr`
ADD COLUMN `locked` varchar(10) NULL COMMENT '元素是否锁定' AFTER `maxFileSize`;


UPDATE `config_materialformattrtemplate` SET `locked` = '1' WHERE `oid` = 1;

UPDATE `risk_materialformattr` SET `locked` = '1' WHERE `attrCode` = 'A1';
