From e72b878380b942135a9bf1ce2e6cd864ba605496 Mon Sep 17 00:00:00 2001
From: 疯狂的狮子Li <15040126243@163.com>
Date: 星期五, 15 四月 2022 11:52:44 +0800
Subject: [PATCH] fix 修复 使用雪花id 导致 部门祖籍字段 长度不够问题
---
script/sql/postgres/postgres_ry_vue_4.X.sql | 2 +-
script/sql/sqlserver/sqlserver_ry_vue_4.X.sql | 2 +-
script/sql/oracle/oracle_ry_vue_4.X.sql | 2 +-
script/sql/ry_vue_4.X.sql | 2 +-
script/sql/update/update-4.0-4.1.sql | 2 ++
5 files changed, 6 insertions(+), 4 deletions(-)
diff --git a/script/sql/oracle/oracle_ry_vue_4.X.sql b/script/sql/oracle/oracle_ry_vue_4.X.sql
index 3c62649..68b29e9 100644
--- a/script/sql/oracle/oracle_ry_vue_4.X.sql
+++ b/script/sql/oracle/oracle_ry_vue_4.X.sql
@@ -4,7 +4,7 @@
create table sys_dept (
dept_id number(20) not null,
parent_id number(20) default 0,
- ancestors varchar2(50) default '',
+ ancestors varchar2(500) default '',
dept_name varchar2(30) default '',
order_num number(4) default 0,
leader varchar2(20) default null,
diff --git a/script/sql/postgres/postgres_ry_vue_4.X.sql b/script/sql/postgres/postgres_ry_vue_4.X.sql
index 4bf4ec2..850491f 100644
--- a/script/sql/postgres/postgres_ry_vue_4.X.sql
+++ b/script/sql/postgres/postgres_ry_vue_4.X.sql
@@ -6,7 +6,7 @@
(
dept_id int8,
parent_id int8 default 0,
- ancestors varchar(50) default ''::varchar,
+ ancestors varchar(500)default ''::varchar,
dept_name varchar(30) default ''::varchar,
order_num int4 default 0,
leader varchar(20) default null::varchar,
diff --git a/script/sql/ry_vue_4.X.sql b/script/sql/ry_vue_4.X.sql
index 47f5da6..e190186 100644
--- a/script/sql/ry_vue_4.X.sql
+++ b/script/sql/ry_vue_4.X.sql
@@ -5,7 +5,7 @@
create table sys_dept (
dept_id bigint(20) not null comment '閮ㄩ棬id',
parent_id bigint(20) default 0 comment '鐖堕儴闂╥d',
- ancestors varchar(50) default '' comment '绁栫骇鍒楄〃',
+ ancestors varchar(500) default '' comment '绁栫骇鍒楄〃',
dept_name varchar(30) default '' comment '閮ㄩ棬鍚嶇О',
order_num int(4) default 0 comment '鏄剧ず椤哄簭',
leader varchar(20) default null comment '璐熻矗浜�',
diff --git a/script/sql/sqlserver/sqlserver_ry_vue_4.X.sql b/script/sql/sqlserver/sqlserver_ry_vue_4.X.sql
index 92ea9c6..d37f1b4 100644
--- a/script/sql/sqlserver/sqlserver_ry_vue_4.X.sql
+++ b/script/sql/sqlserver/sqlserver_ry_vue_4.X.sql
@@ -425,7 +425,7 @@
(
[dept_id] bigint NOT NULL,
[parent_id] bigint DEFAULT ((0)) NULL,
- [ancestors] nvarchar(50) DEFAULT '' NULL,
+ [ancestors] nvarchar(500)DEFAULT '' NULL,
[dept_name] nvarchar(30) DEFAULT '' NULL,
[order_num] int DEFAULT ((0)) NULL,
[leader] nvarchar(20) NULL,
diff --git a/script/sql/update/update-4.0-4.1.sql b/script/sql/update/update-4.0-4.1.sql
index 0848ad7..28e545a 100644
--- a/script/sql/update/update-4.0-4.1.sql
+++ b/script/sql/update/update-4.0-4.1.sql
@@ -1 +1,3 @@
alter table sys_menu change query query_param varchar(255) default null comment '璺敱鍙傛暟';
+
+alter table sys_dept modify column ancestors varchar(500) null default '' comment '绁栫骇鍒楄〃';
--
Gitblit v1.9.3