仪表盘
版本库
文件存储
活动
搜索
登录
main
/
lbqms
兰宝车间质量管理系统
概况
操作记录
提交次数
目录
文档
分支
对比
blame
|
历史
|
原始文档
!225 【轻量级 PR】:update 修复镜像标签命名与docker-compose不一致 Merge pull request !225 fro...
疯狂的狮子Li
2022-09-03
2f2021caafe9f75815d88eb49fa3c346b45eb38f
[lbqms.git]
/
script
/
sql
/
update
/
oracle
/
update-4.1-4.2.sql
1
2
3
4
5
6
7
8
9
10
11
12
ALTER TABLE "SYS_OSS_CONFIG" ADD ("DOMAIN" VARCHAR2(255));
COMMENT ON COLUMN "SYS_OSS_CONFIG"."DOMAIN" IS '自定义域名';
update sys_oss_config set endpoint = '127.0.0.1:9000' where oss_config_id = 1;
update sys_oss_config set endpoint = 's3-cn-north-1.qiniucs.com', region = '' where oss_config_id = 2;
update sys_oss_config set endpoint = 'oss-cn-beijing.aliyuncs.com' where oss_config_id = 3;
update sys_oss_config set endpoint = 'cos.ap-beijing.myqcloud.com' where oss_config_id = 4;
insert into sys_oss_config values (5, 'image', 'ruoyi', 'ruoyi123', 'ruoyi', 'image', '127.0.0.1:9000', 'N', '', '1', '', NULL, 'admin', sysdate, 'admin', sysdate, '');
ALTER TABLE "GEN_TABLE_COLUMN" MODIFY ("TABLE_ID" NUMBER(20,0));