-- 用户表增加字段
ALTER TABLE `risk_se_user`
ADD COLUMN `comId`  varchar(50) NULL COMMENT 'saas企业id' AFTER `channel`;
ALTER TABLE `risk_se_user`
ADD COLUMN `source`  varchar(20) NULL COMMENT '账号来源' AFTER `comId`;
ALTER TABLE `risk_se_user`
ADD COLUMN `perId`  varchar(50) NULL COMMENT 'saas人员id' AFTER `source`;

-- 修改平台名称
update risk_systemconfig set sysvalue='百保盾公共安全服务平台' where syskey='platform_name';


-- 新增测试环境配置，生产环境需要改对应的地址
insert into risk_systemconfig(CREATEON,UPDATEON,sysKey,sysValue,description)
values(NOW(),NOW(),'saas_url','http://183.250.166.207:8762','saas请求地址');

insert into risk_systemconfig(CREATEON,UPDATEON,sysKey,sysValue,description)
values(NOW(),NOW(),'saas_register_url','http://120.76.218.179:9158/bbdweb/#/user/EnterpriseRegistration','saas注册接口');

insert into risk_systemconfig(CREATEON,UPDATEON,sysKey,sysValue,description)
values(NOW(),NOW(),'saas_logon_url','http://120.76.218.179:9158/bbdweb/#/user/logOn','saas登录接口');

