DELETE from `sys_dict` where `codeType` = 'politics';
INSERT INTO `sys_dict` (`isActive`, `codeType`, `tableName`, `description`, `codeValue`, `label`, `seq`)
VALUES ('1', 'politics', NULL, '政治面貌', '01', '中共党员', '1'),
('1', 'politics', NULL, '政治面貌', '02', '中共预备党员', '2'),
('1', 'politics', NULL, '政治面貌', '03', '共青团员', '3'),
('1', 'politics', NULL, '政治面貌', '04', '民革会员', '4'),
('1', 'politics', NULL, '政治面貌', '05', '民盟盟员', '5'),
('1', 'politics', NULL, '政治面貌', '06', '民建会员', '6'),
('1', 'politics', NULL, '政治面貌', '07', '民进会员', '7'),
('1', 'politics', NULL, '政治面貌', '08', '农工党党员', '8'),
('1', 'politics', NULL, '政治面貌', '09', '致公党党员', '9'),
('1', 'politics', NULL, '政治面貌', '10', '九三学社社员', '10'),
('1', 'politics', NULL, '政治面貌', '11', '台盟盟员', '11'),
('1', 'politics', NULL, '政治面貌', '12', '无党派民主人士', '12'),
('1', 'politics', NULL, '政治面貌', '13', '群众', '13');
-- 1	党员
-- 2	团员
-- 3	群众
update security_person set politics='01' where politics='1';
update security_person set politics='03' where politics='2';
update security_person set politics='13' where politics='3';

update sb_personcertificate set politics='01' where politics='1';
update sb_personcertificate set politics='03' where politics='2';
update sb_personcertificate set politics='13' where politics='3';


-- 系统接口日志
DROP TABLE IF EXISTS `sys_interface_log`;
CREATE TABLE `sys_interface_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `active` bit(1) DEFAULT NULL COMMENT '是否可用',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `update_by` varchar(50) DEFAULT NULL,
  `parameters` longtext COMMENT '接口请求数据',
  `result` longtext COMMENT '接口返回结果',
  `url` varchar(500) DEFAULT NULL COMMENT '方法url',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=390 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='系统接口日志';