From f51c654c582815d5d7e9ec934a1f9f548fbad050 Mon Sep 17 00:00:00 2001
From: 疯狂的狮子li <15040126243@163.com>
Date: 星期一, 29 五月 2023 11:45:42 +0800
Subject: [PATCH] add 增加 5.0-5.1 升级sql

---
 script/sql/update/sqlserver/update_5.0-5.1.sql |    9 +++++++++
 script/sql/update/oracle/update_5.0-5.1.sql    |    3 +++
 script/sql/update/postgres/update_5.0-5.1.sql  |    3 +++
 script/sql/update/update_5.0-5.1.sql           |    1 +
 4 files changed, 16 insertions(+), 0 deletions(-)

diff --git a/script/sql/update/oracle/update_5.0-5.1.sql b/script/sql/update/oracle/update_5.0-5.1.sql
new file mode 100644
index 0000000..69fccd6
--- /dev/null
+++ b/script/sql/update/oracle/update_5.0-5.1.sql
@@ -0,0 +1,3 @@
+ALTER TABLE gen_table ADD (data_name VARCHAR2(200) DEFAULT '');
+
+COMMENT ON COLUMN gen_table.data_name IS '鏁版嵁婧愬悕绉�';
diff --git a/script/sql/update/postgres/update_5.0-5.1.sql b/script/sql/update/postgres/update_5.0-5.1.sql
new file mode 100644
index 0000000..f802788
--- /dev/null
+++ b/script/sql/update/postgres/update_5.0-5.1.sql
@@ -0,0 +1,3 @@
+ALTER TABLE gen_table ADD data_name varchar(200) default ''::varchar;
+
+COMMENT ON COLUMN gen_table.data_name IS '鏁版嵁婧愬悕绉�';
diff --git a/script/sql/update/sqlserver/update_5.0-5.1.sql b/script/sql/update/sqlserver/update_5.0-5.1.sql
new file mode 100644
index 0000000..8fd249f
--- /dev/null
+++ b/script/sql/update/sqlserver/update_5.0-5.1.sql
@@ -0,0 +1,9 @@
+ALTER TABLE gen_table ADD data_name nvarchar(200) DEFAULT '' NULL
+GO
+
+EXEC sp_addextendedproperty
+    'MS_Description', N'鏁版嵁婧愬悕绉�',
+    'SCHEMA', N'dbo',
+    'TABLE', N'gen_table',
+    'COLUMN', N'data_name'
+GO
diff --git a/script/sql/update/update_5.0-5.1.sql b/script/sql/update/update_5.0-5.1.sql
new file mode 100644
index 0000000..897fb4c
--- /dev/null
+++ b/script/sql/update/update_5.0-5.1.sql
@@ -0,0 +1 @@
+ALTER TABLE gen_table ADD COLUMN data_name varchar(200) NULL DEFAULT '' COMMENT '鏁版嵁婧愬悕绉�' AFTER table_id;

--
Gitblit v1.9.3