From 8860a495cd11451f2538d6c2c8cf9785037bc5ae Mon Sep 17 00:00:00 2001 From: 13693261870 <252740454@qq.com> Date: 星期一, 19 八月 2024 08:58:28 +0800 Subject: [PATCH] 1 --- sql/se_cloud_20240629.sql | 27 +++++++++++++-------------- 1 files changed, 13 insertions(+), 14 deletions(-) diff --git a/sql/se_cloud_20240629.sql b/sql/se_cloud_20240629.sql index 2837855..776af9b 100644 --- a/sql/se_cloud_20240629.sql +++ b/sql/se_cloud_20240629.sql @@ -27,7 +27,7 @@ update_by varchar(64) default '' comment '鏇存柊鑰�', update_time datetime comment '鏇存柊鏃堕棿', primary key (dept_id) -) engine=innodb auto_increment=200 comment = '閮ㄩ棬琛�'; +) engine=innodb auto_increment=110 comment = '閮ㄩ棬琛�'; -- ---------------------------- -- 鍒濆鍖�-閮ㄩ棬琛ㄦ暟鎹� @@ -42,7 +42,6 @@ insert into sys_dept values(107, 101, '0,100,101', '杩愮淮閮ㄩ棬', 5, '', '15888888888', 'ry@qq.com', '0', '0', 'admin', sysdate(), '', null); insert into sys_dept values(108, 102, '0,100,102', '甯傚満閮ㄩ棬', 1, '', '15888888888', 'ry@qq.com', '0', '0', 'admin', sysdate(), '', null); insert into sys_dept values(109, 102, '0,100,102', '璐㈠姟閮ㄩ棬', 2, '', '15888888888', 'ry@qq.com', '0', '0', 'admin', sysdate(), '', null); - -- ---------------------------- -- 2銆佺敤鎴蜂俊鎭〃 @@ -69,7 +68,7 @@ update_time datetime comment '鏇存柊鏃堕棿', remark varchar(500) default null comment '澶囨敞', primary key (user_id) -) engine=innodb auto_increment=100 comment = '鐢ㄦ埛淇℃伅琛�'; +) engine=innodb auto_increment=3 comment = '鐢ㄦ埛淇℃伅琛�'; -- ---------------------------- -- 鍒濆鍖�-鐢ㄦ埛淇℃伅琛ㄦ暟鎹� @@ -95,7 +94,7 @@ update_time datetime comment '鏇存柊鏃堕棿', remark varchar(500) default null comment '澶囨敞', primary key (post_id) -) engine=innodb comment = '宀椾綅淇℃伅琛�'; +) engine=innodb auto_increment=5 comment = '宀椾綅淇℃伅琛�'; -- ---------------------------- -- 鍒濆鍖�-宀椾綅淇℃伅琛ㄦ暟鎹� @@ -126,7 +125,7 @@ update_time datetime comment '鏇存柊鏃堕棿', remark varchar(500) default null comment '澶囨敞', primary key (role_id) -) engine=innodb auto_increment=100 comment = '瑙掕壊淇℃伅琛�'; +) engine=innodb auto_increment=3 comment = '瑙掕壊淇℃伅琛�'; -- ---------------------------- -- 鍒濆鍖�-瑙掕壊淇℃伅琛ㄦ暟鎹� @@ -161,7 +160,7 @@ update_time datetime comment '鏇存柊鏃堕棿', remark varchar(500) default '' comment '澶囨敞', primary key (menu_id) -) engine=innodb auto_increment=2000 comment = '鑿滃崟鏉冮檺琛�'; +) engine=innodb auto_increment=1070 comment = '鑿滃崟鏉冮檺琛�'; -- ---------------------------- -- 鍒濆鍖�-鑿滃崟淇℃伅琛ㄦ暟鎹� @@ -445,7 +444,7 @@ 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 auto_increment=100 comment = '鎿嶄綔鏃ュ織璁板綍'; +) engine=innodb auto_increment=1 comment = '鎿嶄綔鏃ュ織璁板綍'; -- ---------------------------- @@ -465,7 +464,7 @@ remark varchar(500) default null comment '澶囨敞', primary key (dict_id), unique (dict_type) -) engine=innodb auto_increment=100 comment = '瀛楀吀绫诲瀷琛�'; +) engine=innodb auto_increment=11 comment = '瀛楀吀绫诲瀷琛�'; insert into sys_dict_type values(1, '鐢ㄦ埛鎬у埆', 'sys_user_sex', '0', 'admin', sysdate(), '', null, '鐢ㄦ埛鎬у埆鍒楄〃'); insert into sys_dict_type values(2, '鑿滃崟鐘舵��', 'sys_show_hide', '0', 'admin', sysdate(), '', null, '鑿滃崟鐘舵�佸垪琛�'); @@ -500,7 +499,7 @@ update_time datetime comment '鏇存柊鏃堕棿', remark varchar(500) default null comment '澶囨敞', primary key (dict_code) -) engine=innodb auto_increment=100 comment = '瀛楀吀鏁版嵁琛�'; +) engine=innodb auto_increment=30 comment = '瀛楀吀鏁版嵁琛�'; insert into sys_dict_data values(1, 1, '鐢�', '0', 'sys_user_sex', '', '', 'Y', '0', 'admin', sysdate(), '', null, '鎬у埆鐢�'); insert into sys_dict_data values(2, 2, '濂�', '1', 'sys_user_sex', '', '', 'N', '0', 'admin', sysdate(), '', null, '鎬у埆濂�'); @@ -549,7 +548,7 @@ update_time datetime comment '鏇存柊鏃堕棿', remark varchar(500) default null comment '澶囨敞', primary key (config_id) -) engine=innodb auto_increment=100 comment = '鍙傛暟閰嶇疆琛�'; +) engine=innodb auto_increment=6 comment = '鍙傛暟閰嶇疆琛�'; insert into sys_config values(1, '涓绘鏋堕〉-榛樿鐨偆鏍峰紡鍚嶇О', 'sys.index.skinName', 'skin-blue', 'Y', 'admin', sysdate(), '', null, '钃濊壊 skin-blue銆佺豢鑹� skin-green銆佺传鑹� skin-purple銆佺孩鑹� skin-red銆侀粍鑹� skin-yellow' ); insert into sys_config values(2, '鐢ㄦ埛绠＄悊-璐﹀彿鍒濆瀵嗙爜', 'sys.user.initPassword', '123456', 'Y', 'admin', sysdate(), '', null, '鍒濆鍖栧瘑鐮� 123456' ); @@ -572,7 +571,7 @@ primary key (info_id), key idx_sys_logininfor_s (status), key idx_sys_logininfor_lt (access_time) -) engine=innodb auto_increment=100 comment = '绯荤粺璁块棶璁板綍'; +) engine=innodb auto_increment=1 comment = '绯荤粺璁块棶璁板綍'; -- ---------------------------- @@ -594,7 +593,7 @@ update_time datetime comment '鏇存柊鏃堕棿', remark varchar(500) default '' comment '澶囨敞淇℃伅', primary key (job_id, job_name, job_group) -) engine=innodb auto_increment=100 comment = '瀹氭椂浠诲姟璋冨害琛�'; +) engine=innodb auto_increment=4 comment = '瀹氭椂浠诲姟璋冨害琛�'; insert into sys_job values(1, '绯荤粺榛樿锛堟棤鍙傦級', 'DEFAULT', 'ryTask.ryNoParams', '0/10 * * * * ?', '3', '1', '1', 'admin', sysdate(), '', null, ''); insert into sys_job values(2, '绯荤粺榛樿锛堟湁鍙傦級', 'DEFAULT', 'ryTask.ryParams(\'ry\')', '0/15 * * * * ?', '3', '1', '1', 'admin', sysdate(), '', null, ''); @@ -615,7 +614,7 @@ exception_info varchar(2000) default '' comment '寮傚父淇℃伅', create_time datetime comment '鍒涘缓鏃堕棿', primary key (job_log_id) -) engine=innodb comment = '瀹氭椂浠诲姟璋冨害鏃ュ織琛�'; +) engine=innodb auto_increment=1 comment = '瀹氭椂浠诲姟璋冨害鏃ュ織琛�'; -- ---------------------------- @@ -634,7 +633,7 @@ update_time datetime comment '鏇存柊鏃堕棿', remark varchar(255) default null comment '澶囨敞', primary key (notice_id) -) engine=innodb auto_increment=10 comment = '閫氱煡鍏憡琛�'; +) engine=innodb auto_increment=3 comment = '閫氱煡鍏憡琛�'; -- ---------------------------- -- 鍒濆鍖�-鍏憡淇℃伅琛ㄦ暟鎹� -- Gitblit v1.9.3