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='活动扩展表';

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`;
