From 33c2d8e8333de791affe9780b99c7556e5161ceb Mon Sep 17 00:00:00 2001
From: 疯狂的狮子Li <15040126243@163.com>
Date: 星期日, 25 六月 2023 22:24:18 +0800
Subject: [PATCH] reset 回滚 误删方法
---
script/sql/ry_vue_5.X.sql | 617 +++++++++++++++++++++++++++++--------------------------
1 files changed, 326 insertions(+), 291 deletions(-)
diff --git a/script/sql/ry_vue_5.X.sql b/script/sql/ry_vue_5.X.sql
index 41290d2..0fd115a 100644
--- a/script/sql/ry_vue_5.X.sql
+++ b/script/sql/ry_vue_5.X.sql
@@ -1,4 +1,42 @@
-- ----------------------------
+-- 绗笁鏂瑰钩鍙版巿鏉冭〃
+-- ----------------------------
+drop table if exists sys_social;
+create table sys_social
+(
+ id bigint not null comment '涓婚敭',
+ user_id bigint not null comment '鐢ㄦ埛ID',
+ tenant_id varchar(20) default null comment '绉熸埛id',
+ auth_id varchar(255) not null comment '鎺堟潈+鎺堟潈openid',
+ source varchar(255) not null comment '鐢ㄦ埛鏉ユ簮',
+ open_id varchar(255) default null comment '鍘熺敓open id',
+ user_name varchar(30) not null comment '鐧诲綍璐﹀彿',
+ nick_name varchar(30) default '' comment '鐢ㄦ埛鏄电О',
+ email varchar(255) default '' comment '鐢ㄦ埛閭',
+ avatar varchar(500) default '' comment '澶村儚鍦板潃',
+ access_token varchar(255) not null comment '鐢ㄦ埛鐨勬巿鏉冧护鐗�',
+ expire_in int default null comment '鐢ㄦ埛鐨勬巿鏉冧护鐗岀殑鏈夋晥鏈燂紝閮ㄥ垎骞冲彴鍙兘娌℃湁',
+ refresh_token varchar(255) default null comment '鍒锋柊浠ょ墝锛岄儴鍒嗗钩鍙板彲鑳芥病鏈�',
+ access_code varchar(255) default null comment '骞冲彴鐨勬巿鏉冧俊鎭紝閮ㄥ垎骞冲彴鍙兘娌℃湁',
+ union_id varchar(255) default null comment '鐢ㄦ埛鐨� unionid',
+ scope varchar(255) default null comment '鎺堜簣鐨勬潈闄愶紝閮ㄥ垎骞冲彴鍙兘娌℃湁',
+ token_type varchar(255) default null comment '涓埆骞冲彴鐨勬巿鏉冧俊鎭紝閮ㄥ垎骞冲彴鍙兘娌℃湁',
+ id_token varchar(255) default null comment 'id token锛岄儴鍒嗗钩鍙板彲鑳芥病鏈�',
+ mac_algorithm varchar(255) default null comment '灏忕背骞冲彴鐢ㄦ埛鐨勯檮甯﹀睘鎬э紝閮ㄥ垎骞冲彴鍙兘娌℃湁',
+ mac_key varchar(255) default null comment '灏忕背骞冲彴鐢ㄦ埛鐨勯檮甯﹀睘鎬э紝閮ㄥ垎骞冲彴鍙兘娌℃湁',
+ code varchar(255) default null comment '鐢ㄦ埛鐨勬巿鏉僣ode锛岄儴鍒嗗钩鍙板彲鑳芥病鏈�',
+ oauth_token varchar(255) default null comment 'Twitter骞冲彴鐢ㄦ埛鐨勯檮甯﹀睘鎬э紝閮ㄥ垎骞冲彴鍙兘娌℃湁',
+ oauth_token_secret varchar(255) default null comment 'Twitter骞冲彴鐢ㄦ埛鐨勯檮甯﹀睘鎬э紝閮ㄥ垎骞冲彴鍙兘娌℃湁',
+ create_dept bigint(20) comment '鍒涘缓閮ㄩ棬',
+ create_by bigint(20) comment '鍒涘缓鑰�',
+ create_time datetime comment '鍒涘缓鏃堕棿',
+ update_by bigint(20) comment '鏇存柊鑰�',
+ update_time datetime comment '鏇存柊鏃堕棿',
+ del_flag char(1) default '0' comment '鍒犻櫎鏍囧織锛�0浠ｈ〃瀛樺湪 2浠ｈ〃鍒犻櫎锛�',
+ PRIMARY KEY (id)
+) engine=innodb comment = '绀句細鍖栧叧绯昏〃';
+
+-- ----------------------------
-- 绉熸埛琛�
-- ----------------------------
drop table if exists sys_tenant;
@@ -32,7 +70,7 @@
-- 鍒濆鍖�-绉熸埛琛ㄦ暟鎹�
-- ----------------------------
-insert into sys_tenant values(1, '000000', '绠＄悊缁�', '15888888888', 'XXX鏈夐檺鍏徃', NULL, NULL, '澶氱鎴烽�氱敤鍚庡彴绠＄悊绠＄悊绯荤粺', NULL, NULL, NULL, NULL, -1, '0', '0', 103, 1, sysdate(), NULL, NULL);
+insert into sys_tenant values(1, '000000', '绠＄悊缁�', '15888888888', 'XXX鏈夐檺鍏徃', null, null, '澶氱鎴烽�氱敤鍚庡彴绠＄悊绠＄悊绯荤粺', null, null, null, null, -1, '0', '0', 103, 1, sysdate(), null, null);
-- ----------------------------
@@ -61,23 +99,23 @@
-- ----------------------------
drop table if exists sys_dept;
create table sys_dept (
- dept_id bigint(20) not null comment '閮ㄩ棬id',
- tenant_id varchar(20) default '000000' comment '绉熸埛缂栧彿',
- parent_id bigint(20) default 0 comment '鐖堕儴闂╥d',
- ancestors varchar(500) default '' comment '绁栫骇鍒楄〃',
- dept_name varchar(30) default '' comment '閮ㄩ棬鍚嶇О',
- order_num int(4) default 0 comment '鏄剧ず椤哄簭',
- leader varchar(20) default null comment '璐熻矗浜�',
- phone varchar(11) default null comment '鑱旂郴鐢佃瘽',
- email varchar(50) default null comment '閭',
- status char(1) default '0' comment '閮ㄩ棬鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�',
- del_flag char(1) default '0' comment '鍒犻櫎鏍囧織锛�0浠ｈ〃瀛樺湪 2浠ｈ〃鍒犻櫎锛�',
- create_dept bigint(20) default null comment '鍒涘缓閮ㄩ棬',
- create_by bigint(20) default null comment '鍒涘缓鑰�',
- create_time datetime comment '鍒涘缓鏃堕棿',
- update_by bigint(20) default null comment '鏇存柊鑰�',
- update_time datetime comment '鏇存柊鏃堕棿',
- primary key (dept_id)
+ dept_id bigint(20) not null comment '閮ㄩ棬id',
+ tenant_id varchar(20) default '000000' comment '绉熸埛缂栧彿',
+ parent_id bigint(20) default 0 comment '鐖堕儴闂╥d',
+ ancestors varchar(500) default '' comment '绁栫骇鍒楄〃',
+ dept_name varchar(30) default '' comment '閮ㄩ棬鍚嶇О',
+ order_num int(4) default 0 comment '鏄剧ず椤哄簭',
+ leader varchar(20) default null comment '璐熻矗浜�',
+ phone varchar(11) default null comment '鑱旂郴鐢佃瘽',
+ email varchar(50) default null comment '閭',
+ status char(1) default '0' comment '閮ㄩ棬鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�',
+ del_flag char(1) default '0' comment '鍒犻櫎鏍囧織锛�0浠ｈ〃瀛樺湪 2浠ｈ〃鍒犻櫎锛�',
+ create_dept bigint(20) default null comment '鍒涘缓閮ㄩ棬',
+ create_by bigint(20) default null comment '鍒涘缓鑰�',
+ create_time datetime comment '鍒涘缓鏃堕棿',
+ update_by bigint(20) default null comment '鏇存柊鑰�',
+ update_time datetime comment '鏇存柊鏃堕棿',
+ primary key (dept_id)
) engine=innodb comment = '閮ㄩ棬琛�';
-- ----------------------------
@@ -102,28 +140,28 @@
-- ----------------------------
drop table if exists sys_user;
create table sys_user (
- user_id bigint(20) not null comment '鐢ㄦ埛ID',
- tenant_id varchar(20) default '000000' comment '绉熸埛缂栧彿',
- dept_id bigint(20) default null comment '閮ㄩ棬ID',
- user_name varchar(30) not null comment '鐢ㄦ埛璐﹀彿',
- nick_name varchar(30) not null comment '鐢ㄦ埛鏄电О',
- user_type varchar(10) default 'sys_user' comment '鐢ㄦ埛绫诲瀷锛坰ys_user绯荤粺鐢ㄦ埛锛�',
- email varchar(50) default '' comment '鐢ㄦ埛閭',
- phonenumber varchar(11) default '' comment '鎵嬫満鍙风爜',
- sex char(1) default '0' comment '鐢ㄦ埛鎬у埆锛�0鐢� 1濂� 2鏈煡锛�',
- avatar bigint(20) comment '澶村儚鍦板潃',
- password varchar(100) default '' comment '瀵嗙爜',
- status char(1) default '0' comment '甯愬彿鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�',
- del_flag char(1) default '0' comment '鍒犻櫎鏍囧織锛�0浠ｈ〃瀛樺湪 2浠ｈ〃鍒犻櫎锛�',
- login_ip varchar(128) default '' comment '鏈�鍚庣櫥褰旾P',
- login_date datetime comment '鏈�鍚庣櫥褰曟椂闂�',
- create_dept bigint(20) default null comment '鍒涘缓閮ㄩ棬',
- create_by bigint(20) default null comment '鍒涘缓鑰�',
- create_time datetime comment '鍒涘缓鏃堕棿',
- update_by bigint(20) default null comment '鏇存柊鑰�',
- update_time datetime comment '鏇存柊鏃堕棿',
- remark varchar(500) default null comment '澶囨敞',
- primary key (user_id)
+ user_id bigint(20) not null comment '鐢ㄦ埛ID',
+ tenant_id varchar(20) default '000000' comment '绉熸埛缂栧彿',
+ dept_id bigint(20) default null comment '閮ㄩ棬ID',
+ user_name varchar(30) not null comment '鐢ㄦ埛璐﹀彿',
+ nick_name varchar(30) not null comment '鐢ㄦ埛鏄电О',
+ user_type varchar(10) default 'sys_user' comment '鐢ㄦ埛绫诲瀷锛坰ys_user绯荤粺鐢ㄦ埛锛�',
+ email varchar(50) default '' comment '鐢ㄦ埛閭',
+ phonenumber varchar(11) default '' comment '鎵嬫満鍙风爜',
+ sex char(1) default '0' comment '鐢ㄦ埛鎬у埆锛�0鐢� 1濂� 2鏈煡锛�',
+ avatar bigint(20) comment '澶村儚鍦板潃',
+ password varchar(100) default '' comment '瀵嗙爜',
+ status char(1) default '0' comment '甯愬彿鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�',
+ del_flag char(1) default '0' comment '鍒犻櫎鏍囧織锛�0浠ｈ〃瀛樺湪 2浠ｈ〃鍒犻櫎锛�',
+ login_ip varchar(128) default '' comment '鏈�鍚庣櫥褰旾P',
+ login_date datetime comment '鏈�鍚庣櫥褰曟椂闂�',
+ create_dept bigint(20) default null comment '鍒涘缓閮ㄩ棬',
+ create_by bigint(20) default null comment '鍒涘缓鑰�',
+ create_time datetime comment '鍒涘缓鏃堕棿',
+ update_by bigint(20) default null comment '鏇存柊鑰�',
+ update_time datetime comment '鏇存柊鏃堕棿',
+ remark varchar(500) default null comment '澶囨敞',
+ primary key (user_id)
) engine=innodb comment = '鐢ㄦ埛淇℃伅琛�';
-- ----------------------------
@@ -139,19 +177,19 @@
drop table if exists sys_post;
create table sys_post
(
- post_id bigint(20) not null comment '宀椾綅ID',
- tenant_id varchar(20) default '000000' comment '绉熸埛缂栧彿',
- post_code varchar(64) not null comment '宀椾綅缂栫爜',
- post_name varchar(50) not null comment '宀椾綅鍚嶇О',
- post_sort int(4) not null comment '鏄剧ず椤哄簭',
- status char(1) not null comment '鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�',
- create_dept bigint(20) default null comment '鍒涘缓閮ㄩ棬',
- create_by bigint(20) default null comment '鍒涘缓鑰�',
- create_time datetime comment '鍒涘缓鏃堕棿',
- update_by bigint(20) default null comment '鏇存柊鑰�',
- update_time datetime comment '鏇存柊鏃堕棿',
- remark varchar(500) default null comment '澶囨敞',
- primary key (post_id)
+ post_id bigint(20) not null comment '宀椾綅ID',
+ tenant_id varchar(20) default '000000' comment '绉熸埛缂栧彿',
+ post_code varchar(64) not null comment '宀椾綅缂栫爜',
+ post_name varchar(50) not null comment '宀椾綅鍚嶇О',
+ post_sort int(4) not null comment '鏄剧ず椤哄簭',
+ status char(1) not null comment '鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�',
+ create_dept bigint(20) default null comment '鍒涘缓閮ㄩ棬',
+ create_by bigint(20) default null comment '鍒涘缓鑰�',
+ create_time datetime comment '鍒涘缓鏃堕棿',
+ update_by bigint(20) default null comment '鏇存柊鑰�',
+ update_time datetime comment '鏇存柊鏃堕棿',
+ remark varchar(500) default null comment '澶囨敞',
+ primary key (post_id)
) engine=innodb comment = '宀椾綅淇℃伅琛�';
-- ----------------------------
@@ -168,23 +206,23 @@
-- ----------------------------
drop table if exists sys_role;
create table sys_role (
- role_id bigint(20) not null comment '瑙掕壊ID',
- tenant_id varchar(20) default '000000' comment '绉熸埛缂栧彿',
- role_name varchar(30) not null comment '瑙掕壊鍚嶇О',
- role_key varchar(100) not null comment '瑙掕壊鏉冮檺瀛楃涓�',
- role_sort int(4) not null comment '鏄剧ず椤哄簭',
- data_scope char(1) default '1' comment '鏁版嵁鑼冨洿锛�1锛氬叏閮ㄦ暟鎹潈闄� 2锛氳嚜瀹氭暟鎹潈闄� 3锛氭湰閮ㄩ棬鏁版嵁鏉冮檺 4锛氭湰閮ㄩ棬鍙婁互涓嬫暟鎹潈闄愶級',
- menu_check_strictly tinyint(1) default 1 comment '鑿滃崟鏍戦�夋嫨椤规槸鍚﹀叧鑱旀樉绀�',
- dept_check_strictly tinyint(1) default 1 comment '閮ㄩ棬鏍戦�夋嫨椤规槸鍚﹀叧鑱旀樉绀�',
- status char(1) not null comment '瑙掕壊鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�',
- del_flag char(1) default '0' comment '鍒犻櫎鏍囧織锛�0浠ｈ〃瀛樺湪 2浠ｈ〃鍒犻櫎锛�',
- create_dept bigint(20) default null comment '鍒涘缓閮ㄩ棬',
- create_by bigint(20) default null comment '鍒涘缓鑰�',
- create_time datetime comment '鍒涘缓鏃堕棿',
- update_by bigint(20) default null comment '鏇存柊鑰�',
- update_time datetime comment '鏇存柊鏃堕棿',
- remark varchar(500) default null comment '澶囨敞',
- primary key (role_id)
+ role_id bigint(20) not null comment '瑙掕壊ID',
+ tenant_id varchar(20) default '000000' comment '绉熸埛缂栧彿',
+ role_name varchar(30) not null comment '瑙掕壊鍚嶇О',
+ role_key varchar(100) not null comment '瑙掕壊鏉冮檺瀛楃涓�',
+ role_sort int(4) not null comment '鏄剧ず椤哄簭',
+ data_scope char(1) default '1' comment '鏁版嵁鑼冨洿锛�1锛氬叏閮ㄦ暟鎹潈闄� 2锛氳嚜瀹氭暟鎹潈闄� 3锛氭湰閮ㄩ棬鏁版嵁鏉冮檺 4锛氭湰閮ㄩ棬鍙婁互涓嬫暟鎹潈闄愶級',
+ menu_check_strictly tinyint(1) default 1 comment '鑿滃崟鏍戦�夋嫨椤规槸鍚﹀叧鑱旀樉绀�',
+ dept_check_strictly tinyint(1) default 1 comment '閮ㄩ棬鏍戦�夋嫨椤规槸鍚﹀叧鑱旀樉绀�',
+ status char(1) not null comment '瑙掕壊鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�',
+ del_flag char(1) default '0' comment '鍒犻櫎鏍囧織锛�0浠ｈ〃瀛樺湪 2浠ｈ〃鍒犻櫎锛�',
+ create_dept bigint(20) default null comment '鍒涘缓閮ㄩ棬',
+ create_by bigint(20) default null comment '鍒涘缓鑰�',
+ create_time datetime comment '鍒涘缓鏃堕棿',
+ update_by bigint(20) default null comment '鏇存柊鑰�',
+ update_time datetime comment '鏇存柊鏃堕棿',
+ remark varchar(500) default null comment '澶囨敞',
+ primary key (role_id)
) engine=innodb comment = '瑙掕壊淇℃伅琛�';
-- ----------------------------
@@ -199,27 +237,27 @@
-- ----------------------------
drop table if exists sys_menu;
create table sys_menu (
- menu_id bigint(20) not null comment '鑿滃崟ID',
- menu_name varchar(50) not null comment '鑿滃崟鍚嶇О',
- parent_id bigint(20) default 0 comment '鐖惰彍鍗旾D',
- order_num int(4) default 0 comment '鏄剧ず椤哄簭',
- path varchar(200) default '' comment '璺敱鍦板潃',
- component varchar(255) default null comment '缁勪欢璺緞',
- query_param varchar(255) default null comment '璺敱鍙傛暟',
- is_frame int(1) default 1 comment '鏄惁涓哄閾撅紙0鏄� 1鍚︼級',
- is_cache int(1) default 0 comment '鏄惁缂撳瓨锛�0缂撳瓨 1涓嶇紦瀛橈級',
- menu_type char(1) default '' comment '鑿滃崟绫诲瀷锛圡鐩綍 C鑿滃崟 F鎸夐挳锛�',
- visible char(1) default 0 comment '鏄剧ず鐘舵�侊紙0鏄剧ず 1闅愯棌锛�',
- status char(1) default 0 comment '鑿滃崟鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�',
- perms varchar(100) default null comment '鏉冮檺鏍囪瘑',
- icon varchar(100) default '#' comment '鑿滃崟鍥炬爣',
- create_dept bigint(20) default null comment '鍒涘缓閮ㄩ棬',
- create_by bigint(20) default null comment '鍒涘缓鑰�',
- create_time datetime comment '鍒涘缓鏃堕棿',
- update_by bigint(20) default null comment '鏇存柊鑰�',
- update_time datetime comment '鏇存柊鏃堕棿',
- remark varchar(500) default '' comment '澶囨敞',
- primary key (menu_id)
+ menu_id bigint(20) not null comment '鑿滃崟ID',
+ menu_name varchar(50) not null comment '鑿滃崟鍚嶇О',
+ parent_id bigint(20) default 0 comment '鐖惰彍鍗旾D',
+ order_num int(4) default 0 comment '鏄剧ず椤哄簭',
+ path varchar(200) default '' comment '璺敱鍦板潃',
+ component varchar(255) default null comment '缁勪欢璺緞',
+ query_param varchar(255) default null comment '璺敱鍙傛暟',
+ is_frame int(1) default 1 comment '鏄惁涓哄閾撅紙0鏄� 1鍚︼級',
+ is_cache int(1) default 0 comment '鏄惁缂撳瓨锛�0缂撳瓨 1涓嶇紦瀛橈級',
+ menu_type char(1) default '' comment '鑿滃崟绫诲瀷锛圡鐩綍 C鑿滃崟 F鎸夐挳锛�',
+ visible char(1) default 0 comment '鏄剧ず鐘舵�侊紙0鏄剧ず 1闅愯棌锛�',
+ status char(1) default 0 comment '鑿滃崟鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�',
+ perms varchar(100) default null comment '鏉冮檺鏍囪瘑',
+ icon varchar(100) default '#' comment '鑿滃崟鍥炬爣',
+ create_dept bigint(20) default null comment '鍒涘缓閮ㄩ棬',
+ create_by bigint(20) default null comment '鍒涘缓鑰�',
+ create_time datetime comment '鍒涘缓鏃堕棿',
+ update_by bigint(20) default null comment '鏇存柊鑰�',
+ update_time datetime comment '鏇存柊鏃堕棿',
+ remark varchar(500) default '' comment '澶囨敞',
+ primary key (menu_id)
) engine=innodb comment = '鑿滃崟鏉冮檺琛�';
-- ----------------------------
@@ -252,8 +290,8 @@
insert into sys_menu values('117', 'Admin鐩戞帶', '2', '5', 'Admin', 'monitor/admin/index', '', 1, 0, 'C', '0', '0', 'monitor:admin:list', 'dashboard', 103, 1, sysdate(), null, null, 'Admin鐩戞帶鑿滃崟');
-- oss鑿滃崟
insert into sys_menu values('118', '鏂囦欢绠＄悊', '1', '10', 'oss', 'system/oss/index', '', 1, 0, 'C', '0', '0', 'system:oss:list', 'upload', 103, 1, sysdate(), null, null, '鏂囦欢绠＄悊鑿滃崟');
--- xxl-job-admin鎺у埗鍙�
-insert into sys_menu values('120', '浠诲姟璋冨害涓績', '2', '5', 'XxlJob', 'monitor/xxljob/index', '', 1, 0, 'C', '0', '0', 'monitor:xxljob:list', 'job', 103, 1, sysdate(), null, null, 'Xxl-Job鎺у埗鍙拌彍鍗�');
+-- powerjob server鎺у埗鍙�
+insert into sys_menu values('120', '浠诲姟璋冨害涓績', '2', '5', 'powerjob', 'monitor/powerjob/index', '', 1, 0, 'C', '0', '0', 'monitor:powerjob:list', 'job', 103, 1, sysdate(), null, null, 'PowerJob鎺у埗鍙拌彍鍗�');
-- 涓夌骇鑿滃崟
insert into sys_menu values('500', '鎿嶄綔鏃ュ織', '108', '1', 'operlog', 'monitor/operlog/index', '', 1, 0, 'C', '0', '0', 'monitor:operlog:list', 'form', 103, 1, sysdate(), null, null, '鎿嶄綔鏃ュ織鑿滃崟');
@@ -351,9 +389,9 @@
-- ----------------------------
drop table if exists sys_user_role;
create table sys_user_role (
- user_id bigint(20) not null comment '鐢ㄦ埛ID',
- role_id bigint(20) not null comment '瑙掕壊ID',
- primary key(user_id, role_id)
+ user_id bigint(20) not null comment '鐢ㄦ埛ID',
+ role_id bigint(20) not null comment '瑙掕壊ID',
+ primary key(user_id, role_id)
) engine=innodb comment = '鐢ㄦ埛鍜岃鑹插叧鑱旇〃';
-- ----------------------------
@@ -368,9 +406,9 @@
-- ----------------------------
drop table if exists sys_role_menu;
create table sys_role_menu (
- role_id bigint(20) not null comment '瑙掕壊ID',
- menu_id bigint(20) not null comment '鑿滃崟ID',
- primary key(role_id, menu_id)
+ role_id bigint(20) not null comment '瑙掕壊ID',
+ menu_id bigint(20) not null comment '鑿滃崟ID',
+ primary key(role_id, menu_id)
) engine=innodb comment = '瑙掕壊鍜岃彍鍗曞叧鑱旇〃';
-- ----------------------------
@@ -461,9 +499,9 @@
-- ----------------------------
drop table if exists sys_role_dept;
create table sys_role_dept (
- role_id bigint(20) not null comment '瑙掕壊ID',
- dept_id bigint(20) not null comment '閮ㄩ棬ID',
- primary key(role_id, dept_id)
+ role_id bigint(20) not null comment '瑙掕壊ID',
+ dept_id bigint(20) not null comment '閮ㄩ棬ID',
+ primary key(role_id, dept_id)
) engine=innodb comment = '瑙掕壊鍜岄儴闂ㄥ叧鑱旇〃';
-- ----------------------------
@@ -480,9 +518,9 @@
drop table if exists sys_user_post;
create table sys_user_post
(
- user_id bigint(20) not null comment '鐢ㄦ埛ID',
- post_id bigint(20) not null comment '宀椾綅ID',
- primary key (user_id, post_id)
+ user_id bigint(20) not null comment '鐢ㄦ埛ID',
+ post_id bigint(20) not null comment '宀椾綅ID',
+ primary key (user_id, post_id)
) engine=innodb comment = '鐢ㄦ埛涓庡矖浣嶅叧鑱旇〃';
-- ----------------------------
@@ -497,28 +535,28 @@
-- ----------------------------
drop table if exists sys_oper_log;
create table sys_oper_log (
- oper_id bigint(20) not null comment '鏃ュ織涓婚敭',
- tenant_id varchar(20) default '000000' comment '绉熸埛缂栧彿',
- title varchar(50) default '' comment '妯″潡鏍囬',
- business_type int(2) default 0 comment '涓氬姟绫诲瀷锛�0鍏跺畠 1鏂板 2淇敼 3鍒犻櫎锛�',
- method varchar(100) default '' comment '鏂规硶鍚嶇О',
- request_method varchar(10) default '' comment '璇锋眰鏂瑰紡',
- operator_type int(1) default 0 comment '鎿嶄綔绫诲埆锛�0鍏跺畠 1鍚庡彴鐢ㄦ埛 2鎵嬫満绔敤鎴凤級',
- oper_name varchar(50) default '' comment '鎿嶄綔浜哄憳',
- dept_name varchar(50) default '' comment '閮ㄩ棬鍚嶇О',
- oper_url varchar(255) default '' comment '璇锋眰URL',
- oper_ip varchar(128) default '' comment '涓绘満鍦板潃',
- oper_location varchar(255) default '' comment '鎿嶄綔鍦扮偣',
- oper_param varchar(2000) default '' comment '璇锋眰鍙傛暟',
- json_result varchar(2000) default '' comment '杩斿洖鍙傛暟',
- status int(1) default 0 comment '鎿嶄綔鐘舵�侊紙0姝ｅ父 1寮傚父锛�',
- error_msg varchar(2000) default '' comment '閿欒娑堟伅',
- oper_time datetime comment '鎿嶄綔鏃堕棿',
- cost_time bigint(20) default 0 comment '娑堣�楁椂闂�',
- primary key (oper_id),
- key idx_sys_oper_log_bt (business_type),
- key idx_sys_oper_log_s (status),
- key idx_sys_oper_log_ot (oper_time)
+ oper_id bigint(20) not null comment '鏃ュ織涓婚敭',
+ tenant_id varchar(20) default '000000' comment '绉熸埛缂栧彿',
+ title varchar(50) default '' comment '妯″潡鏍囬',
+ business_type int(2) default 0 comment '涓氬姟绫诲瀷锛�0鍏跺畠 1鏂板 2淇敼 3鍒犻櫎锛�',
+ method varchar(100) default '' comment '鏂规硶鍚嶇О',
+ request_method varchar(10) default '' comment '璇锋眰鏂瑰紡',
+ operator_type int(1) default 0 comment '鎿嶄綔绫诲埆锛�0鍏跺畠 1鍚庡彴鐢ㄦ埛 2鎵嬫満绔敤鎴凤級',
+ oper_name varchar(50) default '' comment '鎿嶄綔浜哄憳',
+ dept_name varchar(50) default '' comment '閮ㄩ棬鍚嶇О',
+ oper_url varchar(255) default '' comment '璇锋眰URL',
+ oper_ip varchar(128) default '' comment '涓绘満鍦板潃',
+ oper_location varchar(255) default '' comment '鎿嶄綔鍦扮偣',
+ oper_param varchar(2000) default '' comment '璇锋眰鍙傛暟',
+ json_result varchar(2000) default '' comment '杩斿洖鍙傛暟',
+ status int(1) default 0 comment '鎿嶄綔鐘舵�侊紙0姝ｅ父 1寮傚父锛�',
+ error_msg varchar(2000) default '' comment '閿欒娑堟伅',
+ oper_time datetime comment '鎿嶄綔鏃堕棿',
+ cost_time bigint(20) default 0 comment '娑堣�楁椂闂�',
+ primary key (oper_id),
+ key idx_sys_oper_log_bt (business_type),
+ key idx_sys_oper_log_s (status),
+ key idx_sys_oper_log_ot (oper_time)
) engine=innodb comment = '鎿嶄綔鏃ュ織璁板綍';
@@ -528,19 +566,19 @@
drop table if exists sys_dict_type;
create table sys_dict_type
(
- dict_id bigint(20) not null comment '瀛楀吀涓婚敭',
- tenant_id varchar(20) default '000000' comment '绉熸埛缂栧彿',
- dict_name varchar(100) default '' comment '瀛楀吀鍚嶇О',
- dict_type varchar(100) default '' comment '瀛楀吀绫诲瀷',
- status char(1) default '0' comment '鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�',
- create_dept bigint(20) default null comment '鍒涘缓閮ㄩ棬',
- create_by bigint(20) default null comment '鍒涘缓鑰�',
- create_time datetime comment '鍒涘缓鏃堕棿',
- update_by bigint(20) default null comment '鏇存柊鑰�',
- update_time datetime comment '鏇存柊鏃堕棿',
- remark varchar(500) default null comment '澶囨敞',
- primary key (dict_id),
- unique (tenant_id, dict_type)
+ dict_id bigint(20) not null comment '瀛楀吀涓婚敭',
+ tenant_id varchar(20) default '000000' comment '绉熸埛缂栧彿',
+ dict_name varchar(100) default '' comment '瀛楀吀鍚嶇О',
+ dict_type varchar(100) default '' comment '瀛楀吀绫诲瀷',
+ status char(1) default '0' comment '鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�',
+ create_dept bigint(20) default null comment '鍒涘缓閮ㄩ棬',
+ create_by bigint(20) default null comment '鍒涘缓鑰�',
+ create_time datetime comment '鍒涘缓鏃堕棿',
+ update_by bigint(20) default null comment '鏇存柊鑰�',
+ update_time datetime comment '鏇存柊鏃堕棿',
+ remark varchar(500) default null comment '澶囨敞',
+ primary key (dict_id),
+ unique (tenant_id, dict_type)
) engine=innodb comment = '瀛楀吀绫诲瀷琛�';
insert into sys_dict_type values(1, '000000', '鐢ㄦ埛鎬у埆', 'sys_user_sex', '0', 103, 1, sysdate(), null, null, '鐢ㄦ埛鎬у埆鍒楄〃');
@@ -559,23 +597,23 @@
drop table if exists sys_dict_data;
create table sys_dict_data
(
- dict_code bigint(20) not null comment '瀛楀吀缂栫爜',
- tenant_id varchar(20) default '000000' comment '绉熸埛缂栧彿',
- dict_sort int(4) default 0 comment '瀛楀吀鎺掑簭',
- dict_label varchar(100) default '' comment '瀛楀吀鏍囩',
- dict_value varchar(100) default '' comment '瀛楀吀閿��',
- dict_type varchar(100) default '' comment '瀛楀吀绫诲瀷',
- css_class varchar(100) default null comment '鏍峰紡灞炴�э紙鍏朵粬鏍峰紡鎵╁睍锛�',
- list_class varchar(100) default null comment '琛ㄦ牸鍥炴樉鏍峰紡',
- is_default char(1) default 'N' comment '鏄惁榛樿锛圷鏄� N鍚︼級',
- status char(1) default '0' comment '鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�',
- create_dept bigint(20) default null comment '鍒涘缓閮ㄩ棬',
- create_by bigint(20) default null comment '鍒涘缓鑰�',
- create_time datetime comment '鍒涘缓鏃堕棿',
- update_by bigint(20) default null comment '鏇存柊鑰�',
- update_time datetime comment '鏇存柊鏃堕棿',
- remark varchar(500) default null comment '澶囨敞',
- primary key (dict_code)
+ dict_code bigint(20) not null comment '瀛楀吀缂栫爜',
+ tenant_id varchar(20) default '000000' comment '绉熸埛缂栧彿',
+ dict_sort int(4) default 0 comment '瀛楀吀鎺掑簭',
+ dict_label varchar(100) default '' comment '瀛楀吀鏍囩',
+ dict_value varchar(100) default '' comment '瀛楀吀閿��',
+ dict_type varchar(100) default '' comment '瀛楀吀绫诲瀷',
+ css_class varchar(100) default null comment '鏍峰紡灞炴�э紙鍏朵粬鏍峰紡鎵╁睍锛�',
+ list_class varchar(100) default null comment '琛ㄦ牸鍥炴樉鏍峰紡',
+ is_default char(1) default 'N' comment '鏄惁榛樿锛圷鏄� N鍚︼級',
+ status char(1) default '0' comment '鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�',
+ create_dept bigint(20) default null comment '鍒涘缓閮ㄩ棬',
+ create_by bigint(20) default null comment '鍒涘缓鑰�',
+ create_time datetime comment '鍒涘缓鏃堕棿',
+ update_by bigint(20) default null comment '鏇存柊鑰�',
+ update_time datetime comment '鏇存柊鏃堕棿',
+ remark varchar(500) default null comment '澶囨敞',
+ primary key (dict_code)
) engine=innodb comment = '瀛楀吀鏁版嵁琛�';
insert into sys_dict_data values(1, '000000', 1, '鐢�', '0', 'sys_user_sex', '', '', 'Y', '0', 103, 1, sysdate(), null, null, '鎬у埆鐢�');
@@ -610,50 +648,46 @@
-- ----------------------------
drop table if exists sys_config;
create table sys_config (
- config_id bigint(20) not null comment '鍙傛暟涓婚敭',
- tenant_id varchar(20) default '000000' comment '绉熸埛缂栧彿',
- config_name varchar(100) default '' comment '鍙傛暟鍚嶇О',
- config_key varchar(100) default '' comment '鍙傛暟閿悕',
- config_value varchar(500) default '' comment '鍙傛暟閿��',
- config_type char(1) default 'N' comment '绯荤粺鍐呯疆锛圷鏄� N鍚︼級',
- create_dept bigint(20) default null comment '鍒涘缓閮ㄩ棬',
- create_by bigint(20) default null comment '鍒涘缓鑰�',
- create_time datetime comment '鍒涘缓鏃堕棿',
- update_by bigint(20) default null comment '鏇存柊鑰�',
- update_time datetime comment '鏇存柊鏃堕棿',
- remark varchar(500) default null comment '澶囨敞',
- primary key (config_id)
+ config_id bigint(20) not null comment '鍙傛暟涓婚敭',
+ tenant_id varchar(20) default '000000' comment '绉熸埛缂栧彿',
+ config_name varchar(100) default '' comment '鍙傛暟鍚嶇О',
+ config_key varchar(100) default '' comment '鍙傛暟閿悕',
+ config_value varchar(500) default '' comment '鍙傛暟閿��',
+ config_type char(1) default 'N' comment '绯荤粺鍐呯疆锛圷鏄� N鍚︼級',
+ create_dept bigint(20) default null comment '鍒涘缓閮ㄩ棬',
+ create_by bigint(20) default null comment '鍒涘缓鑰�',
+ create_time datetime comment '鍒涘缓鏃堕棿',
+ update_by bigint(20) default null comment '鏇存柊鑰�',
+ update_time datetime comment '鏇存柊鏃堕棿',
+ remark varchar(500) default null comment '澶囨敞',
+ primary key (config_id)
) engine=innodb comment = '鍙傛暟閰嶇疆琛�';
-insert into sys_config values(1, '000000', '涓绘鏋堕〉-榛樿鐨偆鏍峰紡鍚嶇О', 'sys.index.skinName', 'skin-blue', 'Y', 103, 1, sysdate(), null, NULL, '钃濊壊 skin-blue銆佺豢鑹� skin-green銆佺传鑹� skin-purple銆佺孩鑹� skin-red銆侀粍鑹� skin-yellow');
-insert into sys_config values(2, '000000', '鐢ㄦ埛绠＄悊-璐﹀彿鍒濆瀵嗙爜', 'sys.user.initPassword', '123456', 'Y', 103, 1, sysdate(), null, NULL, '鍒濆鍖栧瘑鐮� 123456');
-insert into sys_config values(3, '000000', '涓绘鏋堕〉-渚ц竟鏍忎富棰�', 'sys.index.sideTheme', 'theme-dark', 'Y', 103, 1, sysdate(), null, NULL, '娣辫壊涓婚theme-dark锛屾祬鑹蹭富棰榯heme-light');
-insert into sys_config values(4, '000000', '璐﹀彿鑷姪-楠岃瘉鐮佸紑鍏�', 'sys.account.captchaEnabled', 'true', 'Y', 103, 1, sysdate(), null, NULL, '鏄惁寮�鍚獙璇佺爜鍔熻兘锛坱rue寮�鍚紝false鍏抽棴锛�');
-insert into sys_config values(5, '000000', '璐﹀彿鑷姪-鏄惁寮�鍚敤鎴锋敞鍐屽姛鑳�', 'sys.account.registerUser', 'false', 'Y', 103, 1, sysdate(), null, NULL, '鏄惁寮�鍚敞鍐岀敤鎴峰姛鑳斤紙true寮�鍚紝false鍏抽棴锛�');
-insert into sys_config values(6, '000000', '鐢ㄦ埛閰嶇疆-瀵嗙爜鏈�澶ч敊璇鏁�', 'sys.user.maxRetryCount', '5', 'Y', 103, 1, sysdate(), null, NULL, '瀵嗙爜鏈�澶ч敊璇鏁�');
-insert into sys_config values(7, '000000', '鐢ㄦ埛閰嶇疆-瀵嗙爜閿佸畾鏃堕棿', 'sys.user.lockTime', '10', 'Y', 103, 1, sysdate(), null, NULL, '瀵嗙爜閿佸畾鏃堕棿锛堝垎閽燂級');
-insert into sys_config values(8, '000000', '璐﹀彿鑷姪-鐭俊寮�鍏�', 'sys.account.smsEnabled', 'false', 'Y', 103, 1, sysdate(), null, NULL, '鏄惁寮�鍚煭淇″姛鑳斤紙true寮�鍚紝false鍏抽棴锛�');
-insert into sys_config values(9, '000000', '璐﹀彿鑷姪-楠岃瘉鐮佹ā鏉縤d', 'sys.account.templateId', '', 'Y', 103, 1, sysdate(), null, NULL, '楠岃瘉鐮佹ā鏉縤d');
-insert into sys_config values(11,'000000', 'OSS棰勮鍒楄〃璧勬簮寮�鍏�', 'sys.oss.previewListResource', 'true', 'Y', 103, 1, sysdate(), null, NULL, 'true:寮�鍚�, false:鍏抽棴');
+insert into sys_config values(1, '000000', '涓绘鏋堕〉-榛樿鐨偆鏍峰紡鍚嶇О', 'sys.index.skinName', 'skin-blue', 'Y', 103, 1, sysdate(), null, null, '钃濊壊 skin-blue銆佺豢鑹� skin-green銆佺传鑹� skin-purple銆佺孩鑹� skin-red銆侀粍鑹� skin-yellow' );
+insert into sys_config values(2, '000000', '鐢ㄦ埛绠＄悊-璐﹀彿鍒濆瀵嗙爜', 'sys.user.initPassword', '123456', 'Y', 103, 1, sysdate(), null, null, '鍒濆鍖栧瘑鐮� 123456' );
+insert into sys_config values(3, '000000', '涓绘鏋堕〉-渚ц竟鏍忎富棰�', 'sys.index.sideTheme', 'theme-dark', 'Y', 103, 1, sysdate(), null, null, '娣辫壊涓婚theme-dark锛屾祬鑹蹭富棰榯heme-light' );
+insert into sys_config values(5, '000000', '璐﹀彿鑷姪-鏄惁寮�鍚敤鎴锋敞鍐屽姛鑳�', 'sys.account.registerUser', 'false', 'Y', 103, 1, sysdate(), null, null, '鏄惁寮�鍚敞鍐岀敤鎴峰姛鑳斤紙true寮�鍚紝false鍏抽棴锛�');
+insert into sys_config values(11, '000000', 'OSS棰勮鍒楄〃璧勬簮寮�鍏�', 'sys.oss.previewListResource', 'true', 'Y', 103, 1, sysdate(), null, null, 'true:寮�鍚�, false:鍏抽棴');
+
-- ----------------------------
-- 14銆佺郴缁熻闂褰�
-- ----------------------------
drop table if exists sys_logininfor;
create table sys_logininfor (
- info_id bigint(20) not null comment '璁块棶ID',
- tenant_id varchar(20) default '000000' comment '绉熸埛缂栧彿',
- user_name varchar(50) default '' comment '鐢ㄦ埛璐﹀彿',
- ipaddr varchar(128) default '' comment '鐧诲綍IP鍦板潃',
- login_location varchar(255) default '' comment '鐧诲綍鍦扮偣',
- browser varchar(50) default '' comment '娴忚鍣ㄧ被鍨�',
- os varchar(50) default '' comment '鎿嶄綔绯荤粺',
- status char(1) default '0' comment '鐧诲綍鐘舵�侊紙0鎴愬姛 1澶辫触锛�',
- msg varchar(255) default '' comment '鎻愮ず娑堟伅',
- login_time datetime comment '璁块棶鏃堕棿',
- primary key (info_id),
- key idx_sys_logininfor_s (status),
- key idx_sys_logininfor_lt (login_time)
+ info_id bigint(20) not null comment '璁块棶ID',
+ tenant_id varchar(20) default '000000' comment '绉熸埛缂栧彿',
+ user_name varchar(50) default '' comment '鐢ㄦ埛璐﹀彿',
+ ipaddr varchar(128) default '' comment '鐧诲綍IP鍦板潃',
+ login_location varchar(255) default '' comment '鐧诲綍鍦扮偣',
+ browser varchar(50) default '' comment '娴忚鍣ㄧ被鍨�',
+ os varchar(50) default '' comment '鎿嶄綔绯荤粺',
+ status char(1) default '0' comment '鐧诲綍鐘舵�侊紙0鎴愬姛 1澶辫触锛�',
+ msg varchar(255) default '' comment '鎻愮ず娑堟伅',
+ login_time datetime comment '璁块棶鏃堕棿',
+ primary key (info_id),
+ key idx_sys_logininfor_s (status),
+ key idx_sys_logininfor_lt (login_time)
) engine=innodb comment = '绯荤粺璁块棶璁板綍';
@@ -662,19 +696,19 @@
-- ----------------------------
drop table if exists sys_notice;
create table sys_notice (
- notice_id bigint(20) not null comment '鍏憡ID',
- tenant_id varchar(20) default '000000' comment '绉熸埛缂栧彿',
- notice_title varchar(50) not null comment '鍏憡鏍囬',
- notice_type char(1) not null comment '鍏憡绫诲瀷锛�1閫氱煡 2鍏憡锛�',
- notice_content longblob default null comment '鍏憡鍐呭',
- status char(1) default '0' comment '鍏憡鐘舵�侊紙0姝ｅ父 1鍏抽棴锛�',
- create_dept bigint(20) default null comment '鍒涘缓閮ㄩ棬',
- create_by bigint(20) default null comment '鍒涘缓鑰�',
- create_time datetime comment '鍒涘缓鏃堕棿',
- update_by bigint(20) default null comment '鏇存柊鑰�',
- update_time datetime comment '鏇存柊鏃堕棿',
- remark varchar(255) default null comment '澶囨敞',
- primary key (notice_id)
+ notice_id bigint(20) not null comment '鍏憡ID',
+ tenant_id varchar(20) default '000000' comment '绉熸埛缂栧彿',
+ notice_title varchar(50) not null comment '鍏憡鏍囬',
+ notice_type char(1) not null comment '鍏憡绫诲瀷锛�1閫氱煡 2鍏憡锛�',
+ notice_content longblob default null comment '鍏憡鍐呭',
+ status char(1) default '0' comment '鍏憡鐘舵�侊紙0姝ｅ父 1鍏抽棴锛�',
+ create_dept bigint(20) default null comment '鍒涘缓閮ㄩ棬',
+ create_by bigint(20) default null comment '鍒涘缓鑰�',
+ create_time datetime comment '鍒涘缓鏃堕棿',
+ update_by bigint(20) default null comment '鏇存柊鑰�',
+ update_time datetime comment '鏇存柊鏃堕棿',
+ remark varchar(255) default null comment '澶囨敞',
+ primary key (notice_id)
) engine=innodb comment = '閫氱煡鍏憡琛�';
-- ----------------------------
@@ -689,28 +723,29 @@
-- ----------------------------
drop table if exists gen_table;
create table gen_table (
- table_id bigint(20) not null comment '缂栧彿',
- table_name varchar(200) default '' comment '琛ㄥ悕绉�',
- table_comment varchar(500) default '' comment '琛ㄦ弿杩�',
- sub_table_name varchar(64) default null comment '鍏宠仈瀛愯〃鐨勮〃鍚�',
- sub_table_fk_name varchar(64) default null comment '瀛愯〃鍏宠仈鐨勫閿悕',
- class_name varchar(100) default '' comment '瀹炰綋绫诲悕绉�',
- tpl_category varchar(200) default 'crud' comment '浣跨敤鐨勬ā鏉匡紙crud鍗曡〃鎿嶄綔 tree鏍戣〃鎿嶄綔锛�',
- package_name varchar(100) comment '鐢熸垚鍖呰矾寰�',
- module_name varchar(30) comment '鐢熸垚妯″潡鍚�',
- business_name varchar(30) comment '鐢熸垚涓氬姟鍚�',
- function_name varchar(50) comment '鐢熸垚鍔熻兘鍚�',
- function_author varchar(50) comment '鐢熸垚鍔熻兘浣滆��',
- gen_type char(1) default '0' comment '鐢熸垚浠ｇ爜鏂瑰紡锛�0zip鍘嬬缉鍖� 1鑷畾涔夎矾寰勶級',
- gen_path varchar(200) default '/' comment '鐢熸垚璺緞锛堜笉濉粯璁ら」鐩矾寰勶級',
- options varchar(1000) comment '鍏跺畠鐢熸垚閫夐」',
- create_dept bigint(20) default null comment '鍒涘缓閮ㄩ棬',
- create_by bigint(20) default null comment '鍒涘缓鑰�',
- create_time datetime comment '鍒涘缓鏃堕棿',
- update_by bigint(20) default null comment '鏇存柊鑰�',
- update_time datetime comment '鏇存柊鏃堕棿',
- remark varchar(500) default null comment '澶囨敞',
- primary key (table_id)
+ table_id bigint(20) not null comment '缂栧彿',
+ data_name varchar(200) default '' comment '鏁版嵁婧愬悕绉�',
+ table_name varchar(200) default '' comment '琛ㄥ悕绉�',
+ table_comment varchar(500) default '' comment '琛ㄦ弿杩�',
+ sub_table_name varchar(64) default null comment '鍏宠仈瀛愯〃鐨勮〃鍚�',
+ sub_table_fk_name varchar(64) default null comment '瀛愯〃鍏宠仈鐨勫閿悕',
+ class_name varchar(100) default '' comment '瀹炰綋绫诲悕绉�',
+ tpl_category varchar(200) default 'crud' comment '浣跨敤鐨勬ā鏉匡紙crud鍗曡〃鎿嶄綔 tree鏍戣〃鎿嶄綔锛�',
+ package_name varchar(100) comment '鐢熸垚鍖呰矾寰�',
+ module_name varchar(30) comment '鐢熸垚妯″潡鍚�',
+ business_name varchar(30) comment '鐢熸垚涓氬姟鍚�',
+ function_name varchar(50) comment '鐢熸垚鍔熻兘鍚�',
+ function_author varchar(50) comment '鐢熸垚鍔熻兘浣滆��',
+ gen_type char(1) default '0' comment '鐢熸垚浠ｇ爜鏂瑰紡锛�0zip鍘嬬缉鍖� 1鑷畾涔夎矾寰勶級',
+ gen_path varchar(200) default '/' comment '鐢熸垚璺緞锛堜笉濉粯璁ら」鐩矾寰勶級',
+ options varchar(1000) comment '鍏跺畠鐢熸垚閫夐」',
+ create_dept bigint(20) default null comment '鍒涘缓閮ㄩ棬',
+ create_by bigint(20) default null comment '鍒涘缓鑰�',
+ create_time datetime comment '鍒涘缓鏃堕棿',
+ update_by bigint(20) default null comment '鏇存柊鑰�',
+ update_time datetime comment '鏇存柊鏃堕棿',
+ remark varchar(500) default null comment '澶囨敞',
+ primary key (table_id)
) engine=innodb comment = '浠ｇ爜鐢熸垚涓氬姟琛�';
@@ -719,30 +754,30 @@
-- ----------------------------
drop table if exists gen_table_column;
create table gen_table_column (
- column_id bigint(20) not null comment '缂栧彿',
- table_id bigint(20) comment '褰掑睘琛ㄧ紪鍙�',
- column_name varchar(200) comment '鍒楀悕绉�',
- column_comment varchar(500) comment '鍒楁弿杩�',
- column_type varchar(100) comment '鍒楃被鍨�',
- java_type varchar(500) comment 'JAVA绫诲瀷',
- java_field varchar(200) comment 'JAVA瀛楁鍚�',
- is_pk char(1) comment '鏄惁涓婚敭锛�1鏄級',
- is_increment char(1) comment '鏄惁鑷锛�1鏄級',
- is_required char(1) comment '鏄惁蹇呭～锛�1鏄級',
- is_insert char(1) comment '鏄惁涓烘彃鍏ュ瓧娈碉紙1鏄級',
- is_edit char(1) comment '鏄惁缂栬緫瀛楁锛�1鏄級',
- is_list char(1) comment '鏄惁鍒楄〃瀛楁锛�1鏄級',
- is_query char(1) comment '鏄惁鏌ヨ瀛楁锛�1鏄級',
- query_type varchar(200) default 'EQ' comment '鏌ヨ鏂瑰紡锛堢瓑浜庛�佷笉绛変簬銆佸ぇ浜庛�佸皬浜庛�佽寖鍥达級',
- html_type varchar(200) comment '鏄剧ず绫诲瀷锛堟枃鏈銆佹枃鏈煙銆佷笅鎷夋銆佸閫夋銆佸崟閫夋銆佹棩鏈熸帶浠讹級',
- dict_type varchar(200) default '' comment '瀛楀吀绫诲瀷',
- sort int comment '鎺掑簭',
- create_dept bigint(20) default null comment '鍒涘缓閮ㄩ棬',
- create_by bigint(20) default null comment '鍒涘缓鑰�',
- create_time datetime comment '鍒涘缓鏃堕棿',
- update_by bigint(20) default null comment '鏇存柊鑰�',
- update_time datetime comment '鏇存柊鏃堕棿',
- primary key (column_id)
+ column_id bigint(20) not null comment '缂栧彿',
+ table_id bigint(20) comment '褰掑睘琛ㄧ紪鍙�',
+ column_name varchar(200) comment '鍒楀悕绉�',
+ column_comment varchar(500) comment '鍒楁弿杩�',
+ column_type varchar(100) comment '鍒楃被鍨�',
+ java_type varchar(500) comment 'JAVA绫诲瀷',
+ java_field varchar(200) comment 'JAVA瀛楁鍚�',
+ is_pk char(1) comment '鏄惁涓婚敭锛�1鏄級',
+ is_increment char(1) comment '鏄惁鑷锛�1鏄級',
+ is_required char(1) comment '鏄惁蹇呭～锛�1鏄級',
+ is_insert char(1) comment '鏄惁涓烘彃鍏ュ瓧娈碉紙1鏄級',
+ is_edit char(1) comment '鏄惁缂栬緫瀛楁锛�1鏄級',
+ is_list char(1) comment '鏄惁鍒楄〃瀛楁锛�1鏄級',
+ is_query char(1) comment '鏄惁鏌ヨ瀛楁锛�1鏄級',
+ query_type varchar(200) default 'EQ' comment '鏌ヨ鏂瑰紡锛堢瓑浜庛�佷笉绛変簬銆佸ぇ浜庛�佸皬浜庛�佽寖鍥达級',
+ html_type varchar(200) comment '鏄剧ず绫诲瀷锛堟枃鏈銆佹枃鏈煙銆佷笅鎷夋銆佸閫夋銆佸崟閫夋銆佹棩鏈熸帶浠讹級',
+ dict_type varchar(200) default '' comment '瀛楀吀绫诲瀷',
+ sort int comment '鎺掑簭',
+ create_dept bigint(20) default null comment '鍒涘缓閮ㄩ棬',
+ create_by bigint(20) default null comment '鍒涘缓鑰�',
+ create_time datetime comment '鍒涘缓鏃堕棿',
+ update_by bigint(20) default null comment '鏇存柊鑰�',
+ update_time datetime comment '鏇存柊鏃堕棿',
+ primary key (column_id)
) engine=innodb comment = '浠ｇ爜鐢熸垚涓氬姟琛ㄥ瓧娈�';
-- ----------------------------
@@ -750,19 +785,19 @@
-- ----------------------------
drop table if exists sys_oss;
create table sys_oss (
- oss_id bigint(20) not null comment '瀵硅薄瀛樺偍涓婚敭',
- tenant_id varchar(20) default '000000' comment '绉熸埛缂栧彿',
- file_name varchar(255) not null default '' comment '鏂囦欢鍚�',
- original_name varchar(255) not null default '' comment '鍘熷悕',
- file_suffix varchar(10) not null default '' comment '鏂囦欢鍚庣紑鍚�',
- url varchar(500) not null comment 'URL鍦板潃',
- create_dept bigint(20) default null comment '鍒涘缓閮ㄩ棬',
- create_time datetime default null comment '鍒涘缓鏃堕棿',
- create_by bigint(20) default null comment '涓婁紶浜�',
- update_time datetime default null comment '鏇存柊鏃堕棿',
- update_by bigint(20) default null comment '鏇存柊浜�',
- service varchar(20) not null default 'minio' comment '鏈嶅姟鍟�',
- primary key (oss_id)
+ oss_id bigint(20) not null comment '瀵硅薄瀛樺偍涓婚敭',
+ tenant_id varchar(20) default '000000' comment '绉熸埛缂栧彿',
+ file_name varchar(255) not null default '' comment '鏂囦欢鍚�',
+ original_name varchar(255) not null default '' comment '鍘熷悕',
+ file_suffix varchar(10) not null default '' comment '鏂囦欢鍚庣紑鍚�',
+ url varchar(500) not null comment 'URL鍦板潃',
+ create_dept bigint(20) default null comment '鍒涘缓閮ㄩ棬',
+ create_time datetime default null comment '鍒涘缓鏃堕棿',
+ create_by bigint(20) default null comment '涓婁紶浜�',
+ update_time datetime default null comment '鏇存柊鏃堕棿',
+ update_by bigint(20) default null comment '鏇存柊浜�',
+ service varchar(20) not null default 'minio' comment '鏈嶅姟鍟�',
+ primary key (oss_id)
) engine=innodb comment ='OSS瀵硅薄瀛樺偍琛�';
-- ----------------------------
@@ -770,31 +805,31 @@
-- ----------------------------
drop table if exists sys_oss_config;
create table sys_oss_config (
- oss_config_id bigint(20) not null comment '涓诲缓',
- tenant_id varchar(20) default '000000'comment '绉熸埛缂栧彿',
- config_key varchar(20) not null default '' comment '閰嶇疆key',
- access_key varchar(255) default '' comment 'accessKey',
- secret_key varchar(255) default '' comment '绉橀挜',
- bucket_name varchar(255) default '' comment '妗跺悕绉�',
- prefix varchar(255) default '' comment '鍓嶇紑',
- endpoint varchar(255) default '' comment '璁块棶绔欑偣',
- domain varchar(255) default '' comment '鑷畾涔夊煙鍚�',
- is_https char(1) default 'N' comment '鏄惁https锛圷=鏄�,N=鍚︼級',
- region varchar(255) default '' comment '鍩�',
- access_policy char(1) not null default '1' comment '妗舵潈闄愮被鍨�(0=private 1=public 2=custom)',
- status char(1) default '1' comment '鏄惁榛樿锛�0=鏄�,1=鍚︼級',
- ext1 varchar(255) default '' comment '鎵╁睍瀛楁',
- create_dept bigint(20) default null comment '鍒涘缓閮ㄩ棬',
- create_by bigint(20) default null comment '鍒涘缓鑰�',
- create_time datetime default null comment '鍒涘缓鏃堕棿',
- update_by bigint(20) default null comment '鏇存柊鑰�',
- update_time datetime default null comment '鏇存柊鏃堕棿',
- remark varchar(500) default null comment '澶囨敞',
- primary key (oss_config_id)
+ oss_config_id bigint(20) not null comment '涓诲缓',
+ tenant_id varchar(20) default '000000'comment '绉熸埛缂栧彿',
+ config_key varchar(20) not null default '' comment '閰嶇疆key',
+ access_key varchar(255) default '' comment 'accessKey',
+ secret_key varchar(255) default '' comment '绉橀挜',
+ bucket_name varchar(255) default '' comment '妗跺悕绉�',
+ prefix varchar(255) default '' comment '鍓嶇紑',
+ endpoint varchar(255) default '' comment '璁块棶绔欑偣',
+ domain varchar(255) default '' comment '鑷畾涔夊煙鍚�',
+ is_https char(1) default 'N' comment '鏄惁https锛圷=鏄�,N=鍚︼級',
+ region varchar(255) default '' comment '鍩�',
+ access_policy char(1) not null default '1' comment '妗舵潈闄愮被鍨�(0=private 1=public 2=custom)',
+ status char(1) default '1' comment '鏄惁榛樿锛�0=鏄�,1=鍚︼級',
+ ext1 varchar(255) default '' comment '鎵╁睍瀛楁',
+ create_dept bigint(20) default null comment '鍒涘缓閮ㄩ棬',
+ create_by bigint(20) default null comment '鍒涘缓鑰�',
+ create_time datetime default null comment '鍒涘缓鏃堕棿',
+ update_by bigint(20) default null comment '鏇存柊鑰�',
+ update_time datetime default null comment '鏇存柊鏃堕棿',
+ remark varchar(500) default null comment '澶囨敞',
+ primary key (oss_config_id)
) engine=innodb comment='瀵硅薄瀛樺偍閰嶇疆琛�';
-insert into sys_oss_config values (1, '000000', 'minio', 'ruoyi', 'ruoyi123', 'ruoyi', '', '127.0.0.1:9000', '','N', '', '1' ,'0', '', 103, 1, sysdate(), 1, sysdate(), NULL);
-insert into sys_oss_config values (2, '000000', 'qiniu', 'XXXXXXXXXXXXXXX', 'XXXXXXXXXXXXXXX', 'ruoyi', '', 's3-cn-north-1.qiniucs.com', '','N', '', '1' ,'1', '', 103, 1, sysdate(), 1, sysdate(), NULL);
-insert into sys_oss_config values (3, '000000', 'aliyun', 'XXXXXXXXXXXXXXX', 'XXXXXXXXXXXXXXX', 'ruoyi', '', 'oss-cn-beijing.aliyuncs.com', '','N', '', '1' ,'1', '', 103, 1, sysdate(), 1, sysdate(), NULL);
-insert into sys_oss_config values (4, '000000', 'qcloud', 'XXXXXXXXXXXXXXX', 'XXXXXXXXXXXXXXX', 'ruoyi-1250000000', '', 'cos.ap-beijing.myqcloud.com', '','N', 'ap-beijing', '1' ,'1', '', 103, 1, sysdate(), 1, sysdate(), NULL);
-insert into sys_oss_config values (5, '000000', 'image', 'ruoyi', 'ruoyi123', 'ruoyi', 'image', '127.0.0.1:9000', '','N', '', '1' ,'1', '', 103, 1, sysdate(), 1, sysdate(), NULL);
+insert into sys_oss_config values (1, '000000', 'minio', 'ruoyi', 'ruoyi123', 'ruoyi', '', '127.0.0.1:9000', '','N', '', '1' ,'0', '', 103, 1, sysdate(), 1, sysdate(), null);
+insert into sys_oss_config values (2, '000000', 'qiniu', 'XXXXXXXXXXXXXXX', 'XXXXXXXXXXXXXXX', 'ruoyi', '', 's3-cn-north-1.qiniucs.com', '','N', '', '1' ,'1', '', 103, 1, sysdate(), 1, sysdate(), null);
+insert into sys_oss_config values (3, '000000', 'aliyun', 'XXXXXXXXXXXXXXX', 'XXXXXXXXXXXXXXX', 'ruoyi', '', 'oss-cn-beijing.aliyuncs.com', '','N', '', '1' ,'1', '', 103, 1, sysdate(), 1, sysdate(), null);
+insert into sys_oss_config values (4, '000000', 'qcloud', 'XXXXXXXXXXXXXXX', 'XXXXXXXXXXXXXXX', 'ruoyi-1250000000', '', 'cos.ap-beijing.myqcloud.com', '','N', 'ap-beijing', '1' ,'1', '', 103, 1, sysdate(), 1, sysdate(), null);
+insert into sys_oss_config values (5, '000000', 'image', 'ruoyi', 'ruoyi123', 'ruoyi', 'image', '127.0.0.1:9000', '','N', '', '1' ,'1', '', 103, 1, sysdate(), 1, sysdate(), null);
--
Gitblit v1.9.3