
DELETE FROM `config` where `key`='activiti_link_fingerprint';
INSERT INTO `config` (`key`, `value`, `name`, `create_time`, `update_time`, `update_by`)
VALUES ('activiti_link_fingerprint', '1', '是否需要指纹录入环节', now(), now(), 'system');

DELETE FROM `config` where `key`='activiti_link_examschedule';
INSERT INTO `config` (`key`, `value`, `name`, `create_time`, `update_time`, `update_by`)
VALUES ('activiti_link_examschedule', '1', '是否需要考试安排环节', now(), now(), 'system');

DELETE FROM `config` where `key`='activiti_link_assignpolice';
INSERT INTO `config` (`key`, `value`, `name`, `create_time`, `update_time`, `update_by`)
VALUES ('activiti_link_assignpolice', '1', '是否需要指派民警环节', now(), now(), 'system');

DELETE FROM `config` where `key` like'%signup';
INSERT INTO `config` (`key`, `value`, `name`, `create_time`, `update_time`, `update_by`)
select CONCAT('activiti_link_',s2.`code`,'signup'), '1', CONCAT(s2.`name`,'是否需要报名确认环节'), now(), now(), 'system'
from config c,sysarea s1,sysarea s2
where `key`='current_province'
and c.active=1 and s1.active=1 and s2.active=1
and c.`value`=s1.`code` and s1.id=s2.parentid
and s2.`code` in (610400,610300,611000,610200,610500,610900,610600);


