CREATE TABLE `risk_activity_ext` (
                                     `oid` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
                                     `activityId` bigint(20) DEFAULT NULL COMMENT '活动id',
                                     `securityCompanyName` varchar(255) DEFAULT NULL COMMENT '安保公司名称',
                                     `dataStatus` tinyint(1) DEFAULT NULL COMMENT '数据状态,1已启用，0未启用',
                                     `securityComId` varchar(255) DEFAULT NULL COMMENT '安保公司id',
                                     `createOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                                     `updateOn` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
                                     PRIMARY KEY (`oid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='活动扩展表';

ALTER TABLE `risk_se_user`
    MODIFY COLUMN `zwId` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '各政务平台用户Id' AFTER `dataSource`;

INSERT INTO base_role_menu (oid, createOn, updateOn, menu_id, role_id) VALUES (1018, '2020-11-06 10:55:11', null, 1020105, 70);
INSERT INTO config_systemconfig (oid, createOn, updateOn, syskey, sysvalue, description) VALUES (NULL, '2019-03-06 11:08:30', '2019-03-06 11:08:30', 'lj_sso_url', 'http://114.115.154.84:8080/admin', '临建单点登录url');
INSERT INTO config_systemconfig (oid, createOn, updateOn, syskey, sysvalue, description) VALUES (NULL, '2019-09-04 10:22:33', '2019-09-04 10:22:35', 'lj_sso_mobile_url', 'http://114.115.154.84:8080', '临建单点登录手机端url');
INSERT INTO config_systemconfig (oid, createOn, updateOn, syskey, sysvalue, description) VALUES (NULL, '2020-11-11 17:25:13', '2020-11-11 17:25:16', 'ningxia_add_links', 'on', '宁夏链接开关');
INSERT INTO config_systemconfig (oid, createOn, updateOn, syskey, sysvalue, description) VALUES (NULL, '2020-11-20 14:39:13', '2020-11-20 14:39:17', 'bi_url', 'http://visiblebi.test.bcxin.com.cn', '物可视地址');

ALTER TABLE `risk_contractororg`
    ADD COLUMN `serviceOrgType` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '服务机构类型,1.风评，2.安保' AFTER `description`;

INSERT INTO  `risk_se_user`(`oid`, `createOn`, `updateOn`, `active`, `email`, `orgAdmin`, `overdueTime`, `password`, `phone`, `companyPhone`, `realName`, `userName`, `userType`, `ipAddress`, `org_id`, `area_id`, `city_id`, `province_id`, `userRoles`, `validateCode`, `isSync`, `ywzcId`, `signature`, `channel`, `dataSource`, `zwId`) VALUES (NULL, '2018-08-02 16:51:50', NULL, '1', NULL, NULL, NULL, '$2a$10$7DIJ0qcRB4pjsEnLKnGe.ujeIOxls82lhBDFwh05SCVyyiAXOSSU.', NULL, NULL, '宁夏公安', 'nxpolice', '3', NULL, 12, 640104, 640100, 640000, NULL, NULL, NULL, NULL, NULL, 'http://out.test.pss360.cn', NULL, '');