ALTER TABLE `yearreportdata`
ADD COLUMN `policeid`  int NULL COMMENT '民警ID' AFTER `operatorphone`;

ALTER TABLE `sb_personcertificate`
ADD COLUMN `signConfirm`  varchar(10) NULL COMMENT '报名确认' AFTER `stamina_endDate`;

INSERT INTO `operation` (`id`, `native_code`, `code`, `name`, `module_id`, `active`, `create_time`, `update_time`, `update_by`) VALUES ('231', '3502', 'view', '报名确认', '72', '', '2017-06-30 17:53:18', '2017-06-30 17:53:20', 'system');



-- 删除 adminq权限
DELETE from permission where role_id =1;
-- 插入admin角色的权限信息
INSERT INTO permission (native_code,role_id,module_id,operation_id,roletype) SELECT '3502',1,module_id,id,'1' FROM operation t where module_id in( select id from module where moduletype=1);





 