From 197253717689a5868d3cef3b79d67842b1987e98 Mon Sep 17 00:00:00 2001 From: AprilWind <2100166581@qq.com> Date: 星期三, 15 一月 2025 20:50:56 +0800 Subject: [PATCH] update 回退update.sql修改 --- script/sql/update/sqlserver/update_5.0-5.1.sql | 4 ++-- script/sql/update/oracle/update_5.0-5.1.sql | 4 ++-- script/sql/update/postgres/update_5.0-5.1.sql | 4 ++-- script/sql/update/update_5.0-5.1.sql | 4 ++-- 4 files changed, 8 insertions(+), 8 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 index 5341fec..09cfae8 100644 --- a/script/sql/update/oracle/update_5.0-5.1.sql +++ b/script/sql/update/oracle/update_5.0-5.1.sql @@ -71,7 +71,7 @@ comment on column sys_social.create_time is '鍒涘缓鏃堕棿'; comment on column sys_social.update_by is '鏇存柊鑰�'; comment on column sys_social.update_time is '鏇存柊鏃堕棿'; -comment on column sys_social.del_flag is '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛�'; +comment on column sys_social.del_flag is '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛�'; -- ---------------------------- @@ -107,7 +107,7 @@ comment on column sys_client.active_timeout is 'token娲昏穬瓒呮椂鏃堕棿'; comment on column sys_client.timeout is 'token鍥哄畾瓒呮椂'; comment on column sys_client.status is '鐘舵�侊紙0姝e父 1鍋滅敤锛�'; -comment on column sys_client.del_flag is '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛�'; +comment on column sys_client.del_flag is '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛�'; comment on column sys_client.create_dept is '鍒涘缓閮ㄩ棬'; comment on column sys_client.create_by is '鍒涘缓鑰�'; comment on column sys_client.create_time 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 index 14d7eb6..f5f0a5c 100644 --- a/script/sql/update/postgres/update_5.0-5.1.sql +++ b/script/sql/update/postgres/update_5.0-5.1.sql @@ -70,7 +70,7 @@ comment on column sys_social.create_time is '鍒涘缓鏃堕棿'; comment on column sys_social.update_by is '鏇存柊鑰�'; comment on column sys_social.update_time is '鏇存柊鏃堕棿'; -comment on column sys_social.del_flag is '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛�'; +comment on column sys_social.del_flag is '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛�'; -- ---------------------------- @@ -106,7 +106,7 @@ comment on column sys_client.active_timeout is 'token娲昏穬瓒呮椂鏃堕棿'; comment on column sys_client.timeout is 'token鍥哄畾瓒呮椂'; comment on column sys_client.status is '鐘舵�侊紙0姝e父 1鍋滅敤锛�'; -comment on column sys_client.del_flag is '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛�'; +comment on column sys_client.del_flag is '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛�'; comment on column sys_client.create_dept is '鍒涘缓閮ㄩ棬'; comment on column sys_client.create_by is '鍒涘缓鑰�'; comment on column sys_client.create_time 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 index 81434a3..bde3813 100644 --- a/script/sql/update/sqlserver/update_5.0-5.1.sql +++ b/script/sql/update/sqlserver/update_5.0-5.1.sql @@ -188,7 +188,7 @@ 'COLUMN', N'oauth_token_secret' GO EXEC sys.sp_addextendedproperty - 'MS_Description', N'鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛�' , + 'MS_Description', N'鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛�' , 'SCHEMA', N'dbo', 'TABLE', N'sys_social', 'COLUMN', N'del_flag' @@ -304,7 +304,7 @@ 'COLUMN', N'status' GO EXEC sp_addextendedproperty -'MS_Description', N'鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛�', +'MS_Description', N'鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛�', 'SCHEMA', N'dbo', 'TABLE', N'sys_client', 'COLUMN', N'del_flag' diff --git a/script/sql/update/update_5.0-5.1.sql b/script/sql/update/update_5.0-5.1.sql index 4ebd71c..871bda3 100644 --- a/script/sql/update/update_5.0-5.1.sql +++ b/script/sql/update/update_5.0-5.1.sql @@ -36,7 +36,7 @@ create_time datetime comment '鍒涘缓鏃堕棿', update_by bigint(20) comment '鏇存柊鑰�', update_time datetime comment '鏇存柊鏃堕棿', - del_flag char(1) default '0' comment '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛�', + del_flag char(1) default '0' comment '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛�', PRIMARY KEY (id) ) engine=innodb comment = '绀句細鍖栧叧绯昏〃'; @@ -55,7 +55,7 @@ active_timeout int(11) default 1800 comment 'token娲昏穬瓒呮椂鏃堕棿', timeout int(11) default 604800 comment 'token鍥哄畾瓒呮椂', status char(1) default '0' comment '鐘舵�侊紙0姝e父 1鍋滅敤锛�', - del_flag char(1) default '0' comment '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 1浠h〃鍒犻櫎锛�', + del_flag char(1) default '0' comment '鍒犻櫎鏍囧織锛�0浠h〃瀛樺湪 2浠h〃鍒犻櫎锛�', create_dept bigint(20) default null comment '鍒涘缓閮ㄩ棬', create_by bigint(20) default null comment '鍒涘缓鑰�', create_time datetime default null comment '鍒涘缓鏃堕棿', -- Gitblit v1.9.3