From 9a8c87a43e9490c95705202c0b8b33c4f1648892 Mon Sep 17 00:00:00 2001
From: 疯狂的狮子Li <15040126243@163.com>
Date: 星期四, 21 四月 2022 00:14:13 +0800
Subject: [PATCH] update .gitee/ISSUE_TEMPLATE.zh-CN.md.
---
script/sql/postgres/postgres_ry_vue_4.X.sql | 30 ++++++++----------------------
1 files changed, 8 insertions(+), 22 deletions(-)
diff --git a/script/sql/postgres/postgres_ry_vue_4.X.sql b/script/sql/postgres/postgres_ry_vue_4.X.sql
index b93309d..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,
@@ -157,8 +157,8 @@
role_key varchar(100) not null,
role_sort int4 not null,
data_scope char default '1'::bpchar,
- menu_check_strictly smallint default 1,
- dept_check_strictly smallint default 1,
+ menu_check_strictly bool default true,
+ dept_check_strictly bool default true,
status char not null,
del_flag char default '0'::bpchar,
create_by varchar(64) default ''::varchar,
@@ -188,8 +188,8 @@
-- ----------------------------
-- 鍒濆鍖�-瑙掕壊淇℃伅琛ㄦ暟鎹�
-- ----------------------------
-insert into sys_role values('1', '瓒呯骇绠＄悊鍛�', 'admin', 1, 1, 1, 1, '0', '0', 'admin', now(), '', null, '瓒呯骇绠＄悊鍛�');
-insert into sys_role values('2', '鏅�氳鑹�', 'common', 2, 2, 1, 1, '0', '0', 'admin', now(), '', null, '鏅�氳鑹�');
+insert into sys_role values('1', '瓒呯骇绠＄悊鍛�', 'admin', 1, '1', 't', 't', '0', '0', 'admin', now(), '', null, '瓒呯骇绠＄悊鍛�');
+insert into sys_role values('2', '鏅�氳鑹�', 'common', 2, '2', 't', 't', '0', '0', 'admin', now(), '', null, '鏅�氳鑹�');
-- ----------------------------
@@ -204,7 +204,7 @@
order_num int4 default 0,
path varchar(200) default ''::varchar,
component varchar(255) default null::varchar,
- query varchar(255) default null::varchar,
+ query_param varchar(255) default null::varchar,
is_frame int4 default 1,
is_cache int4 default 0,
menu_type char default ''::bpchar,
@@ -227,7 +227,7 @@
comment on column sys_menu.order_num is '鏄剧ず椤哄簭';
comment on column sys_menu.path is '璺敱鍦板潃';
comment on column sys_menu.component is '缁勪欢璺緞';
-comment on column sys_menu.query is '璺敱鍙傛暟';
+comment on column sys_menu.query_param is '璺敱鍙傛暟';
comment on column sys_menu.is_frame is '鏄惁涓哄閾撅紙0鏄� 1鍚︼級';
comment on column sys_menu.is_cache is '鏄惁缂撳瓨锛�0缂撳瓨 1涓嶇紦瀛橈級';
comment on column sys_menu.menu_type is '鑿滃崟绫诲瀷锛圡鐩綍 C鑿滃崟 F鎸夐挳锛�';
@@ -825,7 +825,7 @@
create table if not exists gen_table_column
(
column_id int8,
- table_id varchar(64) default null::varchar,
+ table_id int8,
column_name varchar(200) default null::varchar,
column_comment varchar(500) default null::varchar,
column_type varchar(100) default null::varchar,
@@ -951,17 +951,3 @@
insert into sys_oss_config values (2, 'qiniu', 'XXXXXXXXXXXXXXX', 'XXXXXXXXXXXXXXX', 'ruoyi', '', 'http://XXX.XXXX.com', 'N', 'z0', '1', '', 'admin', now(), 'admin', now(), null);
insert into sys_oss_config values (3, 'aliyun', 'XXXXXXXXXXXXXXX', 'XXXXXXXXXXXXXXX', 'ruoyi', '', 'http://oss-cn-beijing.aliyuncs.com', 'N', '', '1', '', 'admin', now(), 'admin', now(), null);
insert into sys_oss_config values (4, 'qcloud', 'XXXXXXXXXXXXXXX', 'XXXXXXXXXXXXXXX', 'ruoyi-1250000000', '', 'http://cos.ap-beijing.myqcloud.com', 'N', 'ap-beijing', '1', '', 'admin', now(), 'admin', now(), null);
-
--- ----------------------------
--- 鍑芥暟 锛屼唬鏇縨ysql鐨刦ind_in_set
--- 渚嬪锛� select * from sys_dept where FIND_IN_SET (101,ancestors) <> 0
--- ----------------------------
-create or replace function find_in_set(arg1 int8, arg2 varchar)
-returns int8 as $body$
-declare pos int8;
-begin
-select position(','||arg1||',' IN ','||arg2||',') into pos;
-return pos;
-end;
-$body$
-language plpgsql
--
Gitblit v1.9.3