From 78290128e77c56ef1ae236b2f4128d49df4d8773 Mon Sep 17 00:00:00 2001
From: 疯狂的狮子li <15040126243@163.com>
Date: 星期四, 03 十一月 2022 11:38:40 +0800
Subject: [PATCH] add 增加 4.3-4.4 更新 sql 文件
---
script/sql/update/oracle/update-4.3-4.4.sql | 3 +++
script/sql/update/sqlserver/update-4.3-4.4.sql | 9 +++++++++
script/sql/update/postgres/update-4.3-4.4.sql | 3 +++
script/sql/update/update-4.3-4.4.sql | 1 +
4 files changed, 16 insertions(+), 0 deletions(-)
diff --git a/script/sql/update/oracle/update-4.3-4.4.sql b/script/sql/update/oracle/update-4.3-4.4.sql
new file mode 100644
index 0000000..77e12ed
--- /dev/null
+++ b/script/sql/update/oracle/update-4.3-4.4.sql
@@ -0,0 +1,3 @@
+ALTER TABLE "SYS_OSS_CONFIG" ADD ("ACCESS_POLICY" CHAR(1) DEFAULT '1' NOT NULL);
+
+COMMENT ON COLUMN "SYS_OSS_CONFIG"."ACCESS_POLICY" IS '妗舵潈闄愮被鍨�(0=private 1=public 2=custom)';
diff --git a/script/sql/update/postgres/update-4.3-4.4.sql b/script/sql/update/postgres/update-4.3-4.4.sql
new file mode 100644
index 0000000..e74357a
--- /dev/null
+++ b/script/sql/update/postgres/update-4.3-4.4.sql
@@ -0,0 +1,3 @@
+ALTER TABLE "sys_oss_config" ADD COLUMN "access_policy" char(1) NOT NULL DEFAULT '1'::bpchar;
+
+COMMENT ON COLUMN "sys_oss_config"."access_policy" IS '妗舵潈闄愮被鍨�(0=private 1=public 2=custom)';
diff --git a/script/sql/update/sqlserver/update-4.3-4.4.sql b/script/sql/update/sqlserver/update-4.3-4.4.sql
new file mode 100644
index 0000000..8e36db5
--- /dev/null
+++ b/script/sql/update/sqlserver/update-4.3-4.4.sql
@@ -0,0 +1,9 @@
+ALTER TABLE [sys_oss_config] ADD [access_policy] nchar(1) DEFAULT ('1') NOT NULL
+GO
+
+EXEC sp_addextendedproperty
+'MS_Description', N'妗舵潈闄愮被鍨�(0=private 1=public 2=custom)',
+'SCHEMA', N'dbo',
+'TABLE', N'sys_oss_config',
+'COLUMN', N'access_policy'
+GO
diff --git a/script/sql/update/update-4.3-4.4.sql b/script/sql/update/update-4.3-4.4.sql
new file mode 100644
index 0000000..5a59987
--- /dev/null
+++ b/script/sql/update/update-4.3-4.4.sql
@@ -0,0 +1 @@
+ALTER TABLE sys_oss_config ADD COLUMN access_policy char(1) NOT NULL DEFAULT 1 COMMENT '妗舵潈闄愮被鍨�(0=private 1=public 2=custom)' AFTER region;
--
Gitblit v1.9.3