From abca91c18f1e6c7c30d8bf4945a72c908c34ef20 Mon Sep 17 00:00:00 2001
From: 疯狂的狮子li <15040126243@163.com>
Date: 星期三, 29 三月 2023 16:47:42 +0800
Subject: [PATCH] update 重写项目 readme 说明
---
script/sql/postgres/postgres_ry_vue_5.X.sql | 28 ++++++++++++++--------------
1 files changed, 14 insertions(+), 14 deletions(-)
diff --git a/script/sql/postgres/postgres_ry_vue_5.X.sql b/script/sql/postgres/postgres_ry_vue_5.X.sql
index 65857bf..7f5e859 100644
--- a/script/sql/postgres/postgres_ry_vue_5.X.sql
+++ b/script/sql/postgres/postgres_ry_vue_5.X.sql
@@ -100,7 +100,7 @@
create table if not exists sys_dept
(
dept_id int8,
- tenant_id varchar(20) not null,
+ tenant_id varchar(20) default '000000'::varchar,
parent_id int8 default 0,
ancestors varchar(500)default ''::varchar,
dept_name varchar(30) default ''::varchar,
@@ -157,7 +157,7 @@
create table if not exists sys_user
(
user_id int8,
- tenant_id varchar(20) not null,
+ tenant_id varchar(20) default '000000'::varchar,
dept_id int8,
user_name varchar(30) not null,
nick_name varchar(30) not null,
@@ -218,7 +218,7 @@
create table if not exists sys_post
(
post_id int8,
- tenant_id varchar(20) not null,
+ tenant_id varchar(20) default '000000'::varchar,
post_code varchar(64) not null,
post_name varchar(50) not null,
post_sort int4 not null,
@@ -261,7 +261,7 @@
create table if not exists sys_role
(
role_id int8,
- tenant_id varchar(20) not null,
+ tenant_id varchar(20) default '000000'::varchar,
role_name varchar(30) not null,
role_key varchar(100) not null,
role_sort int4 not null,
@@ -363,7 +363,7 @@
insert into sys_menu values('6', '绯荤粺绠＄悊', '0', '2', 'tenant', null, '', '1', '0', 'M', '0', '0', '', 'chart', 103, 1, now(), null, null, '绉熸埛绠＄悊鐩綍');
insert into sys_menu values('2', '绯荤粺鐩戞帶', '0', '3', 'monitor', null, '', '1', '0', 'M', '0', '0', '', 'monitor', 103, 1, now(), null, null, '绯荤粺鐩戞帶鐩綍');
insert into sys_menu values('3', '绯荤粺宸ュ叿', '0', '4', 'tool', null, '', '1', '0', 'M', '0', '0', '', 'tool', 103, 1, now(), null, null, '绯荤粺宸ュ叿鐩綍');
-insert into sys_menu values('4', 'PLUS瀹樼綉', '0', '5', 'https://gitee.com/JavaLionLi/RuoYi-Vue-Plus', null, '', '0', '0', 'M', '0', '0', '', 'guide', 103, 1, now(), null, null, 'RuoYi-Vue-Plus瀹樼綉鍦板潃');
+insert into sys_menu values('4', 'PLUS瀹樼綉', '0', '5', 'https://gitee.com/dromara/RuoYi-Vue-Plus', null, '', '0', '0', 'M', '0', '0', '', 'guide', 103, 1, now(), null, null, 'RuoYi-Vue-Plus瀹樼綉鍦板潃');
-- 浜岀骇鑿滃崟
insert into sys_menu values('100', '鐢ㄦ埛绠＄悊', '1', '1', 'user', 'system/user/index', '', '1', '0', 'C', '0', '0', 'system:user:list', 'user', 103, 1, now(), null, null, '鐢ㄦ埛绠＄悊鑿滃崟');
insert into sys_menu values('101', '瑙掕壊绠＄悊', '1', '2', 'role', 'system/role/index', '', '1', '0', 'C', '0', '0', 'system:role:list', 'peoples', 103, 1, now(), null, null, '瑙掕壊绠＄悊鑿滃崟');
@@ -651,7 +651,7 @@
create table if not exists sys_oper_log
(
oper_id int8,
- tenant_id varchar(20) not null,
+ tenant_id varchar(20) default '000000'::varchar,
title varchar(50) default ''::varchar,
business_type int4 default 0,
method varchar(100) default ''::varchar,
@@ -702,7 +702,7 @@
create table if not exists sys_dict_type
(
dict_id int8,
- tenant_id varchar(20) not null,
+ tenant_id varchar(20) default '000000'::varchar,
dict_name varchar(100) default ''::varchar,
dict_type varchar(100) default ''::varchar,
status char default '0'::bpchar,
@@ -747,7 +747,7 @@
create table if not exists sys_dict_data
(
dict_code int8,
- tenant_id varchar(20) not null,
+ tenant_id varchar(20) default '000000'::varchar,
dict_sort int4 default 0,
dict_label varchar(100) default ''::varchar,
dict_value varchar(100) default ''::varchar,
@@ -817,7 +817,7 @@
create table if not exists sys_config
(
config_id int8,
- tenant_id varchar(20) not null,
+ tenant_id varchar(20) default '000000'::varchar,
config_name varchar(100) default ''::varchar,
config_key varchar(100) default ''::varchar,
config_value varchar(500) default ''::varchar,
@@ -859,7 +859,7 @@
create table if not exists sys_logininfor
(
info_id int8,
- tenant_id varchar(20) not null,
+ tenant_id varchar(20) default '000000'::varchar,
user_name varchar(50) default ''::varchar,
ipaddr varchar(128) default ''::varchar,
login_location varchar(255) default ''::varchar,
@@ -893,7 +893,7 @@
create table if not exists sys_notice
(
notice_id int8,
- tenant_id varchar(20) not null,
+ tenant_id varchar(20) default '000000'::varchar,
notice_title varchar(50) not null,
notice_type char not null,
notice_content text,
@@ -1045,7 +1045,7 @@
create table if not exists sys_oss
(
oss_id int8,
- tenant_id varchar(20) not null,
+ tenant_id varchar(20) default '000000'::varchar,
file_name varchar(255) default ''::varchar not null,
original_name varchar(255) default ''::varchar not null,
file_suffix varchar(10) default ''::varchar not null,
@@ -1080,7 +1080,7 @@
create table if not exists sys_oss_config
(
oss_config_id int8,
- tenant_id varchar(20) not null,
+ tenant_id varchar(20) default '000000'::varchar,
config_key varchar(20) default ''::varchar not null,
access_key varchar(255) default ''::varchar,
secret_key varchar(255) default ''::varchar,
@@ -1115,7 +1115,7 @@
comment on column sys_oss_config.is_https is '鏄惁https锛圷=鏄�,N=鍚︼級';
comment on column sys_oss_config.region is '鍩�';
comment on column sys_oss_config.access_policy is '妗舵潈闄愮被鍨�(0=private 1=public 2=custom)';
-comment on column sys_oss_config.status is '鐘舵�侊紙0=姝ｅ父,1=鍋滅敤锛�';
+comment on column sys_oss_config.status is '鏄惁榛樿锛�0=鏄�,1=鍚︼級';
comment on column sys_oss_config.ext1 is '鎵╁睍瀛楁';
comment on column sys_oss_config.create_dept is '鍒涘缓閮ㄩ棬';
comment on column sys_oss_config.create_by is '鍒涘缓鑰�';
--
Gitblit v1.9.3