From bcee37b84bde39072e6e35e642b0911a94f52eef Mon Sep 17 00:00:00 2001
From: RuoYi <yzz_ivy@163.com>
Date: 星期一, 11 十一月 2019 08:59:15 +0800
Subject: [PATCH] 若依 1.1
---
ruoyi/sql/ry_20191111.sql | 40 ++++++++++------------------------------
1 files changed, 10 insertions(+), 30 deletions(-)
diff --git a/ruoyi/sql/ry_20191008.sql b/ruoyi/sql/ry_20191111.sql
similarity index 96%
rename from ruoyi/sql/ry_20191008.sql
rename to ruoyi/sql/ry_20191111.sql
index 7d75501..0558cba 100644
--- a/ruoyi/sql/ry_20191008.sql
+++ b/ruoyi/sql/ry_20191111.sql
@@ -136,7 +136,7 @@
path varchar(200) default '' comment '璺敱鍦板潃',
component varchar(255) default null comment '缁勪欢璺緞',
is_frame int(1) default 1 comment '鏄惁涓哄閾撅紙0鏄� 1鍚︼級',
- menu_type char(1) default '' comment '鑿滃崟绫诲瀷锛�0鐩綍 1鑿滃崟 2鎸夐挳锛�',
+ menu_type char(1) default '' comment '鑿滃崟绫诲瀷锛圡鐩綍 C鑿滃崟 F鎸夐挳锛�',
visible char(1) default 0 comment '鑿滃崟鐘舵�侊紙0鏄剧ず 1闅愯棌锛�',
perms varchar(100) default null comment '鏉冮檺鏍囪瘑',
icon varchar(100) default '#' comment '鑿滃崟鍥炬爣',
@@ -152,10 +152,10 @@
-- 鍒濆鍖�-鑿滃崟淇℃伅琛ㄦ暟鎹�
-- ----------------------------
-- 涓�绾ц彍鍗�
-insert into sys_menu values('1', '绯荤粺绠＄悊', '0', '1', 'system', null, 1, 'M', '0', '', 'system', 'admin', '2018-03-16 11-33-00', 'ry', '2018-03-16 11-33-00', '绯荤粺绠＄悊鐩綍');
-insert into sys_menu values('2', '绯荤粺鐩戞帶', '0', '2', 'monitor', null, 1, 'M', '0', '', 'monitor', 'admin', '2018-03-16 11-33-00', 'ry', '2018-03-16 11-33-00', '绯荤粺鐩戞帶鐩綍');
-insert into sys_menu values('3', '绯荤粺宸ュ叿', '0', '3', 'tool', null, 1, 'M', '0', '', 'tool', 'admin', '2018-03-16 11-33-00', 'ry', '2018-03-16 11-33-00', '绯荤粺宸ュ叿鐩綍');
-INSERT INTO sys_menu VALUES('4', '鑻ヤ緷瀹樼綉', '0', '4', 'http://ruoyi.vip', NULL , 0, 'M', '0', '', 'guide', 'admin', '2018-03-16 11-33-00', 'ry', '2018-03-16 11-33-00', '鑻ヤ緷瀹樼綉');
+insert into sys_menu values('1', '绯荤粺绠＄悊', '0', '1', 'system', null, 1, 'M', '0', '', 'system', 'admin', '2018-03-16 11-33-00', 'ry', '2018-03-16 11-33-00', '绯荤粺绠＄悊鐩綍');
+insert into sys_menu values('2', '绯荤粺鐩戞帶', '0', '2', 'monitor', null, 1, 'M', '0', '', 'monitor', 'admin', '2018-03-16 11-33-00', 'ry', '2018-03-16 11-33-00', '绯荤粺鐩戞帶鐩綍');
+insert into sys_menu values('3', '绯荤粺宸ュ叿', '0', '3', 'tool', null, 1, 'M', '0', '', 'tool', 'admin', '2018-03-16 11-33-00', 'ry', '2018-03-16 11-33-00', '绯荤粺宸ュ叿鐩綍');
+insert into sys_menu values('4', '鑻ヤ緷瀹樼綉', '0', '4', 'http://ruoyi.vip', null , 0, 'M', '0', '', 'guide', 'admin', '2018-03-16 11-33-00', 'ry', '2018-03-16 11-33-00', '鑻ヤ緷瀹樼綉鍦板潃');
-- 浜岀骇鑿滃崟
insert into sys_menu values('100', '鐢ㄦ埛绠＄悊', '1', '1', 'user', 'system/user/index', 1, 'C', '0', 'system:user:list', 'user', 'admin', '2018-03-16 11-33-00', 'ry', '2018-03-16 11-33-00', '鐢ㄦ埛绠＄悊鑿滃崟');
insert into sys_menu values('101', '瑙掕壊绠＄悊', '1', '2', 'role', 'system/role/index', 1, 'C', '0', 'system:role:list', 'peoples', 'admin', '2018-03-16 11-33-00', 'ry', '2018-03-16 11-33-00', '瑙掕壊绠＄悊鑿滃崟');
@@ -550,27 +550,7 @@
-- ----------------------------
--- 15銆佸湪绾跨敤鎴疯褰�
--- ----------------------------
-drop table if exists sys_user_online;
-create table sys_user_online (
- sessionId varchar(50) default '' comment '鐢ㄦ埛浼氳瘽id',
- user_name varchar(50) default '' comment '鐢ㄦ埛璐﹀彿',
- dept_name varchar(50) default '' comment '閮ㄩ棬鍚嶇О',
- ipaddr varchar(50) default '' comment '鐧诲綍IP鍦板潃',
- login_location varchar(255) default '' comment '鐧诲綍鍦扮偣',
- browser varchar(50) default '' comment '娴忚鍣ㄧ被鍨�',
- os varchar(50) default '' comment '鎿嶄綔绯荤粺',
- status varchar(10) default '' comment '鍦ㄧ嚎鐘舵�乷n_line鍦ㄧ嚎off_line绂荤嚎',
- start_timestamp datetime comment 'session鍒涘缓鏃堕棿',
- last_access_time datetime comment 'session鏈�鍚庤闂椂闂�',
- expire_time int(5) default 0 comment '瓒呮椂鏃堕棿锛屽崟浣嶄负鍒嗛挓',
- primary key (sessionId)
-) engine=innodb comment = '鍦ㄧ嚎鐢ㄦ埛璁板綍';
-
-
--- ----------------------------
--- 16銆佸畾鏃朵换鍔¤皟搴﹁〃
+-- 15銆佸畾鏃朵换鍔¤皟搴﹁〃
-- ----------------------------
drop table if exists sys_job;
create table sys_job (
@@ -596,7 +576,7 @@
-- ----------------------------
--- 17銆佸畾鏃朵换鍔¤皟搴︽棩蹇楄〃
+-- 16銆佸畾鏃朵换鍔¤皟搴︽棩蹇楄〃
-- ----------------------------
drop table if exists sys_job_log;
create table sys_job_log (
@@ -613,7 +593,7 @@
-- ----------------------------
--- 18銆侀�氱煡鍏憡琛�
+-- 17銆侀�氱煡鍏憡琛�
-- ----------------------------
drop table if exists sys_notice;
create table sys_notice (
@@ -638,7 +618,7 @@
-- ----------------------------
--- 19銆佷唬鐮佺敓鎴愪笟鍔¤〃
+-- 18銆佷唬鐮佺敓鎴愪笟鍔¤〃
-- ----------------------------
drop table if exists gen_table;
create table gen_table (
@@ -663,7 +643,7 @@
-- ----------------------------
--- 20銆佷唬鐮佺敓鎴愪笟鍔¤〃瀛楁
+-- 19銆佷唬鐮佺敓鎴愪笟鍔¤〃瀛楁
-- ----------------------------
drop table if exists gen_table_column;
create table gen_table_column (
--
Gitblit v1.9.3