lbqms.git - Gitblit

ÎÄ¼þÃû´Ó script/sql/ry_vue_4.X.sql ÐÞ¸Ä
			@@ -13,9 +13,10 @@
			email varchar(50) default null comment 'é®ç®±',
			status char(1) default '0' comment 'é¨é¨ç¶æï¼0æ£å¸¸ 1åç¨ï¼',
			del_flag char(1) default '0' comment 'å é¤æ å¿ï¼0ä»£è¡¨åå¨ 2ä»£è¡¨å é¤ï¼',
			create_by varchar(64) default '' comment 'åå»ºè',
			create_dept bigint(20) default null comment 'åå»ºé¨é¨',
			create_by bigint(20) default null comment 'åå»ºè',
			create_time datetime comment 'åå»ºæ¶é´',
			update_by varchar(64) default '' comment 'æ´æ°è',
			update_by bigint(20) default null comment 'æ´æ°è',
			update_time datetime comment 'æ´æ°æ¶é´',
			primary key (dept_id)
			) engine=innodb comment = 'é¨é¨è¡¨';
			@@ -23,16 +24,18 @@
			-- ----------------------------
			-- åå§å-é¨é¨è¡¨æ°æ®
			-- ----------------------------
			insert into sys_dept values(100, 0, '0', 'è¥ä¾ç§æ', 0, 'è¥ä¾', '15888888888', 'ry@qq.com', '0', '0', 'admin', sysdate(), '', null);
			insert into sys_dept values(101, 100, '0,100', 'æ·±å³æ»å¬å¸', 1, 'è¥ä¾', '15888888888', 'ry@qq.com', '0', '0', 'admin', sysdate(), '', null);
			insert into sys_dept values(102, 100, '0,100', 'é¿æ²åå¬å¸', 2, 'è¥ä¾', '15888888888', 'ry@qq.com', '0', '0', 'admin', sysdate(), '', null);
			insert into sys_dept values(103, 101, '0,100,101', 'ç åé¨é¨', 1, 'è¥ä¾', '15888888888', 'ry@qq.com', '0', '0', 'admin', sysdate(), '', null);
			insert into sys_dept values(104, 101, '0,100,101', 'å¸åºé¨é¨', 2, 'è¥ä¾', '15888888888', 'ry@qq.com', '0', '0', 'admin', sysdate(), '', null);
			insert into sys_dept values(105, 101, '0,100,101', 'æµè¯é¨é¨', 3, 'è¥ä¾', '15888888888', 'ry@qq.com', '0', '0', 'admin', sysdate(), '', null);
			insert into sys_dept values(106, 101, '0,100,101', 'è´¢å¡é¨é¨', 4, 'è¥ä¾', '15888888888', 'ry@qq.com', '0', '0', 'admin', sysdate(), '', null);
			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);


			insert into sys_dept values(100, 0, '0', 'è¥ä¾ç§æ', 0, 'è¥ä¾', '15888888888', 'ry@qq.com', '0', '0', 103, 1, sysdate(), null, null);
			insert into sys_dept values(101, 100, '0,100', 'æ·±å³æ»å¬å¸', 1, 'è¥ä¾', '15888888888', 'ry@qq.com', '0', '0', 103, 1, sysdate(), null, null);
			insert into sys_dept values(102, 100, '0,100', 'é¿æ²åå¬å¸', 2, 'è¥ä¾', '15888888888', 'ry@qq.com', '0', '0', 103, 1, sysdate(), null, null);
			insert into sys_dept values(103, 101, '0,100,101', 'ç åé¨é¨', 1, 'è¥ä¾', '15888888888', 'ry@qq.com', '0', '0', 103, 1, sysdate(), null, null);
			insert into sys_dept values(104, 101, '0,100,101', 'å¸åºé¨é¨', 2, 'è¥ä¾', '15888888888', 'ry@qq.com', '0', '0', 103, 1, sysdate(), null, null);
			insert into sys_dept values(105, 101, '0,100,101', 'æµè¯é¨é¨', 3, 'è¥ä¾', '15888888888', 'ry@qq.com', '0', '0', 103, 1, sysdate(), null, null);
			insert into sys_dept values(106, 101, '0,100,101', 'è´¢å¡é¨é¨', 4, 'è¥ä¾', '15888888888', 'ry@qq.com', '0', '0', 103, 1, sysdate(), null, null);
			insert into sys_dept values(107, 101, '0,100,101', 'è¿ç»´é¨é¨', 5, 'è¥ä¾', '15888888888', 'ry@qq.com', '0', '0', 103, 1, sysdate(), null, null);
			insert into sys_dept values(108, 102, '0,100,102', 'å¸åºé¨é¨', 1, 'è¥ä¾', '15888888888', 'ry@qq.com', '0', '0', 103, 1, sysdate(), null, null);
			insert into sys_dept values(109, 102, '0,100,102', 'è´¢å¡é¨é¨', 2, 'è¥ä¾', '15888888888', 'ry@qq.com', '0', '0', 103, 1, sysdate(), null, null);


			-- ----------------------------
			@@ -54,9 +57,10 @@
			del_flag char(1) default '0' comment 'å é¤æ å¿ï¼0ä»£è¡¨åå¨ 2ä»£è¡¨å é¤ï¼',
			login_ip varchar(128) default '' comment 'æåç»å½IP',
			login_date datetime comment 'æåç»å½æ¶é´',
			create_by varchar(64) default '' comment 'åå»ºè',
			create_dept bigint(20) default null comment 'åå»ºé¨é¨',
			create_by bigint(20) default null comment 'åå»ºè',
			create_time datetime comment 'åå»ºæ¶é´',
			update_by varchar(64) default '' comment 'æ´æ°è',
			update_by bigint(20) default null comment 'æ´æ°è',
			update_time datetime comment 'æ´æ°æ¶é´',
			remark varchar(500) default null comment 'å¤æ³¨',
			primary key (user_id)
			@@ -65,8 +69,8 @@
			-- ----------------------------
			-- åå§å-ç¨æ·ä¿¡æ¯è¡¨æ°æ®
			-- ----------------------------
			insert into sys_user values(1, 103, 'admin', 'ç¯ççç®åLi', 'sys_user', 'crazyLionLi@163.com', '15888888888', '1', '', '$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', '0', '0', '127.0.0.1', sysdate(), 'admin', sysdate(), '', null, 'ç®¡çå');
			insert into sys_user values(2, 105, 'lionli', 'ç¯ççç®åLi', 'sys_user', 'crazyLionLi@qq.com', '15666666666', '1', '', '$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', '0', '0', '127.0.0.1', sysdate(), 'admin', sysdate(), '', null, 'æµè¯å');
			insert into sys_user values(1, 103, 1, 'ç¯ççç®åLi', 'sys_user', 'crazyLionLi@163.com', '15888888888', '1', '', '$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', '0', '0', '127.0.0.1', sysdate(), 103, 1, sysdate(), null, null, 'ç®¡çå');
			insert into sys_user values(2, 105, 'lionli', 'ç¯ççç®åLi', 'sys_user', 'crazyLionLi@qq.com', '15666666666', '1', '', '$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', '0', '0', '127.0.0.1', sysdate(), 103, 1, sysdate(), null, null, 'æµè¯å');


			-- ----------------------------
			@@ -80,9 +84,10 @@
			post_name varchar(50) not null comment 'å²ä½åç§°',
			post_sort int(4) not null comment 'æ¾ç¤ºé¡ºåº',
			status char(1) not null comment 'ç¶æï¼0æ£å¸¸ 1åç¨ï¼',
			create_by varchar(64) default '' comment 'åå»ºè',
			create_dept bigint(20) default null comment 'åå»ºé¨é¨',
			create_by bigint(20) default null comment 'åå»ºè',
			create_time datetime comment 'åå»ºæ¶é´',
			update_by varchar(64) default '' comment 'æ´æ°è',
			update_by bigint(20) default null comment 'æ´æ°è',
			update_time datetime comment 'æ´æ°æ¶é´',
			remark varchar(500) default null comment 'å¤æ³¨',
			primary key (post_id)
			@@ -91,10 +96,10 @@
			-- ----------------------------
			-- åå§å-å²ä½ä¿¡æ¯è¡¨æ°æ®
			-- ----------------------------
			insert into sys_post values(1, 'ceo', 'è£äºé¿', 1, '0', 'admin', sysdate(), '', null, '');
			insert into sys_post values(2, 'se', 'é¡¹ç®ç»ç', 2, '0', 'admin', sysdate(), '', null, '');
			insert into sys_post values(3, 'hr', 'äººåèµæº', 3, '0', 'admin', sysdate(), '', null, '');
			insert into sys_post values(4, 'user', 'æ®éåå·¥', 4, '0', 'admin', sysdate(), '', null, '');
			insert into sys_post values(1, 'ceo', 'è£äºé¿', 1, '0', 103, 1, sysdate(), null, null, '');
			insert into sys_post values(2, 'se', 'é¡¹ç®ç»ç', 2, '0', 103, 1, sysdate(), null, null, '');
			insert into sys_post values(3, 'hr', 'äººåèµæº', 3, '0', 103, 1, sysdate(), null, null, '');
			insert into sys_post values(4, 'user', 'æ®éåå·¥', 4, '0', 103, 1, sysdate(), null, null, '');


			-- ----------------------------
			@@ -111,9 +116,10 @@
			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_by varchar(64) default '' comment 'åå»ºè',
			create_dept bigint(20) default null comment 'åå»ºé¨é¨',
			create_by varchar(64) default null comment 'åå»ºè',
			create_time datetime comment 'åå»ºæ¶é´',
			update_by varchar(64) default '' comment 'æ´æ°è',
			update_by varchar(64) default null comment 'æ´æ°è',
			update_time datetime comment 'æ´æ°æ¶é´',
			remark varchar(500) default null comment 'å¤æ³¨',
			primary key (role_id)
			@@ -122,8 +128,8 @@
			-- ----------------------------
			-- åå§å-è§è²ä¿¡æ¯è¡¨æ°æ®
			-- ----------------------------
			insert into sys_role values('1', 'è¶çº§ç®¡çå', 'admin', 1, 1, 1, 1, '0', '0', 'admin', sysdate(), '', null, 'è¶çº§ç®¡çå');
			insert into sys_role values('2', 'æ®éè§è²', 'common', 2, 2, 1, 1, '0', '0', 'admin', sysdate(), '', null, 'æ®éè§è²');
			insert into sys_role values('1', 'è¶çº§ç®¡çå', 1, 1, 1, 1, 1, '0', '0', 103, 1, sysdate(), null, null, 'è¶çº§ç®¡çå');
			insert into sys_role values('2', 'æ®éè§è²', 'common', 2, 2, 1, 1, '0', '0', 103, 1, sysdate(), null, null, 'æ®éè§è²');


			-- ----------------------------
			@@ -145,9 +151,10 @@
			status char(1) default 0 comment 'èåç¶æï¼0æ£å¸¸ 1åç¨ï¼',
			perms varchar(100) default null comment 'æéæ è¯',
			icon varchar(100) default '#' comment 'èåå¾æ ',
			create_by varchar(64) default '' comment 'åå»ºè',
			create_dept bigint(20) default null comment 'åå»ºé¨é¨',
			create_by bigint(20) default null comment 'åå»ºè',
			create_time datetime comment 'åå»ºæ¶é´',
			update_by varchar(64) default '' comment 'æ´æ°è',
			update_by bigint(20) default null comment 'æ´æ°è',
			update_time datetime comment 'æ´æ°æ¶é´',
			remark varchar(500) default '' comment 'å¤æ³¨',
			primary key (menu_id)
			@@ -157,109 +164,109 @@
			-- åå§å-èåä¿¡æ¯è¡¨æ°æ®
			-- ----------------------------
			-- ä¸çº§èå
			insert into sys_menu values('1', 'ç³»ç»ç®¡ç', '0', '1', 'system', null, '', 1, 0, 'M', '0', '0', '', 'system', 'admin', sysdate(), '', null, 'ç³»ç»ç®¡çç®å½');
			insert into sys_menu values('2', 'ç³»ç»çæ§', '0', '2', 'monitor', null, '', 1, 0, 'M', '0', '0', '', 'monitor', 'admin', sysdate(), '', null, 'ç³»ç»çæ§ç®å½');
			insert into sys_menu values('3', 'ç³»ç»å·¥å·', '0', '3', 'tool', null, '', 1, 0, 'M', '0', '0', '', 'tool', 'admin', sysdate(), '', null, 'ç³»ç»å·¥å·ç®å½');
			insert into sys_menu values('4', 'PLUSå®ç½', '0', '4', 'https://gitee.com/JavaLionLi/RuoYi-Vue-Plus', null, '', 0, 0, 'M', '0', '0', '', 'guide', 'admin', sysdate(), '', null, 'RuoYi-Vue-Pluså®ç½å°å');
			insert into sys_menu values('1', 'ç³»ç»ç®¡ç', '0', '1', 'system', null, '', 1, 0, 'M', '0', '0', '', 'system', 103, 1, sysdate(), null, null, 'ç³»ç»ç®¡çç®å½');
			insert into sys_menu values('2', 'ç³»ç»çæ§', '0', '2', 'monitor', null, '', 1, 0, 'M', '0', '0', '', 'monitor', 103, 1, sysdate(), null, null, 'ç³»ç»çæ§ç®å½');
			insert into sys_menu values('3', 'ç³»ç»å·¥å·', '0', '3', 'tool', null, '', 1, 0, 'M', '0', '0', '', 'tool', 103, 1, sysdate(), null, null, 'ç³»ç»å·¥å·ç®å½');
			insert into sys_menu values('4', 'PLUSå®ç½', '0', '4', 'https://gitee.com/JavaLionLi/RuoYi-Vue-Plus', null, '', 0, 0, 'M', '0', '0', '', 'guide', 103, 1, sysdate(), 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', 'admin', sysdate(), '', null, 'ç¨æ·ç®¡çèå');
			insert into sys_menu values('101', 'è§è²ç®¡ç', '1', '2', 'role', 'system/role/index', '', 1, 0, 'C', '0', '0', 'system:role:list', 'peoples', 'admin', sysdate(), '', null, 'è§è²ç®¡çèå');
			insert into sys_menu values('102', 'èåç®¡ç', '1', '3', 'menu', 'system/menu/index', '', 1, 0, 'C', '0', '0', 'system:menu:list', 'tree-table', 'admin', sysdate(), '', null, 'èåç®¡çèå');
			insert into sys_menu values('103', 'é¨é¨ç®¡ç', '1', '4', 'dept', 'system/dept/index', '', 1, 0, 'C', '0', '0', 'system:dept:list', 'tree', 'admin', sysdate(), '', null, 'é¨é¨ç®¡çèå');
			insert into sys_menu values('104', 'å²ä½ç®¡ç', '1', '5', 'post', 'system/post/index', '', 1, 0, 'C', '0', '0', 'system:post:list', 'post', 'admin', sysdate(), '', null, 'å²ä½ç®¡çèå');
			insert into sys_menu values('105', 'åå¸ç®¡ç', '1', '6', 'dict', 'system/dict/index', '', 1, 0, 'C', '0', '0', 'system:dict:list', 'dict', 'admin', sysdate(), '', null, 'åå¸ç®¡çèå');
			insert into sys_menu values('106', 'åæ°è®¾ç½®', '1', '7', 'config', 'system/config/index', '', 1, 0, 'C', '0', '0', 'system:config:list', 'edit', 'admin', sysdate(), '', null, 'åæ°è®¾ç½®èå');
			insert into sys_menu values('107', 'éç¥å¬å', '1', '8', 'notice', 'system/notice/index', '', 1, 0, 'C', '0', '0', 'system:notice:list', 'message', 'admin', sysdate(), '', null, 'éç¥å¬åèå');
			insert into sys_menu values('108', 'æ¥å¿ç®¡ç', '1', '9', 'log', '', '', 1, 0, 'M', '0', '0', '', 'log', 'admin', sysdate(), '', null, 'æ¥å¿ç®¡çèå');
			insert into sys_menu values('109', 'å¨çº¿ç¨æ·', '2', '1', 'online', 'monitor/online/index', '', 1, 0, 'C', '0', '0', 'monitor:online:list', 'online', 'admin', sysdate(), '', null, 'å¨çº¿ç¨æ·èå');
			insert into sys_menu values('112', 'ç¼ååè¡¨', '2', '6', 'cacheList', 'monitor/cache/list', '', 1, 0, 'C', '0', '0', 'monitor:cache:list', 'redis-list', 'admin', sysdate(), '', null, 'ç¼ååè¡¨èå');
			insert into sys_menu values('113', 'ç¼åçæ§', '2', '5', 'cache', 'monitor/cache/index', '', 1, 0, 'C', '0', '0', 'monitor:cache:list', 'redis', 'admin', sysdate(), '', null, 'ç¼åçæ§èå');
			insert into sys_menu values('114', 'è¡¨åæå»º', '3', '1', 'build', 'tool/build/index', '', 1, 0, 'C', '0', '0', 'tool:build:list', 'build', 'admin', sysdate(), '', null, 'è¡¨åæå»ºèå');
			insert into sys_menu values('115', 'ä»£ç çæ', '3', '2', 'gen', 'tool/gen/index', '', 1, 0, 'C', '0', '0', 'tool:gen:list', 'code', 'admin', sysdate(), '', null, 'ä»£ç çæèå');
			insert into sys_menu values('100', 'ç¨æ·ç®¡ç', '1', '1', 'user', 'system/user/index', '', 1, 0, 'C', '0', '0', 'system:user:list', 'user', 103, 1, sysdate(), 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, sysdate(), null, null, 'è§è²ç®¡çèå');
			insert into sys_menu values('102', 'èåç®¡ç', '1', '3', 'menu', 'system/menu/index', '', 1, 0, 'C', '0', '0', 'system:menu:list', 'tree-table', 103, 1, sysdate(), null, null, 'èåç®¡çèå');
			insert into sys_menu values('103', 'é¨é¨ç®¡ç', '1', '4', 'dept', 'system/dept/index', '', 1, 0, 'C', '0', '0', 'system:dept:list', 'tree', 103, 1, sysdate(), null, null, 'é¨é¨ç®¡çèå');
			insert into sys_menu values('104', 'å²ä½ç®¡ç', '1', '5', 'post', 'system/post/index', '', 1, 0, 'C', '0', '0', 'system:post:list', 'post', 103, 1, sysdate(), null, null, 'å²ä½ç®¡çèå');
			insert into sys_menu values('105', 'åå¸ç®¡ç', '1', '6', 'dict', 'system/dict/index', '', 1, 0, 'C', '0', '0', 'system:dict:list', 'dict', 103, 1, sysdate(), null, null, 'åå¸ç®¡çèå');
			insert into sys_menu values('106', 'åæ°è®¾ç½®', '1', '7', 'config', 'system/config/index', '', 1, 0, 'C', '0', '0', 'system:config:list', 'edit', 103, 1, sysdate(), null, null, 'åæ°è®¾ç½®èå');
			insert into sys_menu values('107', 'éç¥å¬å', '1', '8', 'notice', 'system/notice/index', '', 1, 0, 'C', '0', '0', 'system:notice:list', 'message', 103, 1, sysdate(), null, null, 'éç¥å¬åèå');
			insert into sys_menu values('108', 'æ¥å¿ç®¡ç', '1', '9', 'log', '', '', 1, 0, 'M', '0', '0', '', 'log', 103, 1, sysdate(), null, null, 'æ¥å¿ç®¡çèå');
			insert into sys_menu values('109', 'å¨çº¿ç¨æ·', '2', '1', 'online', 'monitor/online/index', '', 1, 0, 'C', '0', '0', 'monitor:online:list', 'online', 103, 1, sysdate(), null, null, 'å¨çº¿ç¨æ·èå');
			insert into sys_menu values('112', 'ç¼ååè¡¨', '2', '6', 'cacheList', 'monitor/cache/list', '', 1, 0, 'C', '0', '0', 'monitor:cache:list', 'redis-list', 103, 1, sysdate(), null, null, 'ç¼ååè¡¨èå');
			insert into sys_menu values('113', 'ç¼åçæ§', '2', '5', 'cache', 'monitor/cache/index', '', 1, 0, 'C', '0', '0', 'monitor:cache:list', 'redis', 103, 1, sysdate(), null, null, 'ç¼åçæ§èå');
			insert into sys_menu values('114', 'è¡¨åæå»º', '3', '1', 'build', 'tool/build/index', '', 1, 0, 'C', '0', '0', 'tool:build:list', 'build', 103, 1, sysdate(), null, null, 'è¡¨åæå»ºèå');
			insert into sys_menu values('115', 'ä»£ç çæ', '3', '2', 'gen', 'tool/gen/index', '', 1, 0, 'C', '0', '0', 'tool:gen:list', 'code', 103, 1, sysdate(), null, null, 'ä»£ç çæèå');
			-- springboot-adminçæ§
			insert into sys_menu values('117', 'Adminçæ§', '2', '5', 'Admin', 'monitor/admin/index', '', 1, 0, 'C', '0', '0', 'monitor:admin:list', 'dashboard', 'admin', sysdate(), '', null, 'Adminçæ§èå');
			insert into sys_menu values('117', 'Adminçæ§', '2', '5', 1, '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', 'admin', sysdate(), '', null, 'æä»¶ç®¡çèå');
			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', 'admin', sysdate(), '', null, 'Xxl-Jobæ§å¶å°èå');
			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æ§å¶å°èå');

			-- ä¸çº§èå
			insert into sys_menu values('500', 'æä½æ¥å¿', '108', '1', 'operlog', 'monitor/operlog/index', '', 1, 0, 'C', '0', '0', 'monitor:operlog:list', 'form', 'admin', sysdate(), '', null, 'æä½æ¥å¿èå');
			insert into sys_menu values('501', 'ç»å½æ¥å¿', '108', '2', 'logininfor', 'monitor/logininfor/index', '', 1, 0, 'C', '0', '0', 'monitor:logininfor:list', 'logininfor', 'admin', sysdate(), '', null, 'ç»å½æ¥å¿èå');
			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, 'æä½æ¥å¿èå');
			insert into sys_menu values('501', 'ç»å½æ¥å¿', '108', '2', 'logininfor', 'monitor/logininfor/index', '', 1, 0, 'C', '0', '0', 'monitor:logininfor:list', 'logininfor', 103, 1, sysdate(), null, null, 'ç»å½æ¥å¿èå');
			-- ç¨æ·ç®¡çæé®
			insert into sys_menu values('1001', 'ç¨æ·æ¥è¯¢', '100', '1', '', '', '', 1, 0, 'F', '0', '0', 'system:user:query', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1002', 'ç¨æ·æ°å¢', '100', '2', '', '', '', 1, 0, 'F', '0', '0', 'system:user:add', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1003', 'ç¨æ·ä¿®æ¹', '100', '3', '', '', '', 1, 0, 'F', '0', '0', 'system:user:edit', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1004', 'ç¨æ·å é¤', '100', '4', '', '', '', 1, 0, 'F', '0', '0', 'system:user:remove', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1005', 'ç¨æ·å¯¼åº', '100', '5', '', '', '', 1, 0, 'F', '0', '0', 'system:user:export', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1006', 'ç¨æ·å¯¼å¥', '100', '6', '', '', '', 1, 0, 'F', '0', '0', 'system:user:import', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1007', 'éç½®å¯ç ', '100', '7', '', '', '', 1, 0, 'F', '0', '0', 'system:user:resetPwd', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1001', 'ç¨æ·æ¥è¯¢', '100', '1', '', '', '', 1, 0, 'F', '0', '0', 'system:user:query', '#', 103, 1, sysdate(), null, null, '');
			insert into sys_menu values('1002', 'ç¨æ·æ°å¢', '100', '2', '', '', '', 1, 0, 'F', '0', '0', 'system:user:add', '#', 103, 1, sysdate(), null, null, '');
			insert into sys_menu values('1003', 'ç¨æ·ä¿®æ¹', '100', '3', '', '', '', 1, 0, 'F', '0', '0', 'system:user:edit', '#', 103, 1, sysdate(), null, null, '');
			insert into sys_menu values('1004', 'ç¨æ·å é¤', '100', '4', '', '', '', 1, 0, 'F', '0', '0', 'system:user:remove', '#', 103, 1, sysdate(), null, null, '');
			insert into sys_menu values('1005', 'ç¨æ·å¯¼åº', '100', '5', '', '', '', 1, 0, 'F', '0', '0', 'system:user:export', '#', 103, 1, sysdate(), null, null, '');
			insert into sys_menu values('1006', 'ç¨æ·å¯¼å¥', '100', '6', '', '', '', 1, 0, 'F', '0', '0', 'system:user:import', '#', 103, 1, sysdate(), null, null, '');
			insert into sys_menu values('1007', 'éç½®å¯ç ', '100', '7', '', '', '', 1, 0, 'F', '0', '0', 'system:user:resetPwd', '#', 103, 1, sysdate(), null, null, '');
			-- è§è²ç®¡çæé®
			insert into sys_menu values('1008', 'è§è²æ¥è¯¢', '101', '1', '', '', '', 1, 0, 'F', '0', '0', 'system:role:query', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1009', 'è§è²æ°å¢', '101', '2', '', '', '', 1, 0, 'F', '0', '0', 'system:role:add', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1010', 'è§è²ä¿®æ¹', '101', '3', '', '', '', 1, 0, 'F', '0', '0', 'system:role:edit', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1011', 'è§è²å é¤', '101', '4', '', '', '', 1, 0, 'F', '0', '0', 'system:role:remove', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1012', 'è§è²å¯¼åº', '101', '5', '', '', '', 1, 0, 'F', '0', '0', 'system:role:export', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1008', 'è§è²æ¥è¯¢', '101', '1', '', '', '', 1, 0, 'F', '0', '0', 'system:role:query', '#', 103, 1, sysdate(), null, null, '');
			insert into sys_menu values('1009', 'è§è²æ°å¢', '101', '2', '', '', '', 1, 0, 'F', '0', '0', 'system:role:add', '#', 103, 1, sysdate(), null, null, '');
			insert into sys_menu values('1010', 'è§è²ä¿®æ¹', '101', '3', '', '', '', 1, 0, 'F', '0', '0', 'system:role:edit', '#', 103, 1, sysdate(), null, null, '');
			insert into sys_menu values('1011', 'è§è²å é¤', '101', '4', '', '', '', 1, 0, 'F', '0', '0', 'system:role:remove', '#', 103, 1, sysdate(), null, null, '');
			insert into sys_menu values('1012', 'è§è²å¯¼åº', '101', '5', '', '', '', 1, 0, 'F', '0', '0', 'system:role:export', '#', 103, 1, sysdate(), null, null, '');
			-- èåç®¡çæé®
			insert into sys_menu values('1013', 'èåæ¥è¯¢', '102', '1', '', '', '', 1, 0, 'F', '0', '0', 'system:menu:query', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1014', 'èåæ°å¢', '102', '2', '', '', '', 1, 0, 'F', '0', '0', 'system:menu:add', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1015', 'èåä¿®æ¹', '102', '3', '', '', '', 1, 0, 'F', '0', '0', 'system:menu:edit', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1016', 'èåå é¤', '102', '4', '', '', '', 1, 0, 'F', '0', '0', 'system:menu:remove', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1013', 'èåæ¥è¯¢', '102', '1', '', '', '', 1, 0, 'F', '0', '0', 'system:menu:query', '#', 103, 1, sysdate(), null, null, '');
			insert into sys_menu values('1014', 'èåæ°å¢', '102', '2', '', '', '', 1, 0, 'F', '0', '0', 'system:menu:add', '#', 103, 1, sysdate(), null, null, '');
			insert into sys_menu values('1015', 'èåä¿®æ¹', '102', '3', '', '', '', 1, 0, 'F', '0', '0', 'system:menu:edit', '#', 103, 1, sysdate(), null, null, '');
			insert into sys_menu values('1016', 'èåå é¤', '102', '4', '', '', '', 1, 0, 'F', '0', '0', 'system:menu:remove', '#', 103, 1, sysdate(), null, null, '');
			-- é¨é¨ç®¡çæé®
			insert into sys_menu values('1017', 'é¨é¨æ¥è¯¢', '103', '1', '', '', '', 1, 0, 'F', '0', '0', 'system:dept:query', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1018', 'é¨é¨æ°å¢', '103', '2', '', '', '', 1, 0, 'F', '0', '0', 'system:dept:add', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1019', 'é¨é¨ä¿®æ¹', '103', '3', '', '', '', 1, 0, 'F', '0', '0', 'system:dept:edit', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1020', 'é¨é¨å é¤', '103', '4', '', '', '', 1, 0, 'F', '0', '0', 'system:dept:remove', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1017', 'é¨é¨æ¥è¯¢', '103', '1', '', '', '', 1, 0, 'F', '0', '0', 'system:dept:query', '#', 103, 1, sysdate(), null, null, '');
			insert into sys_menu values('1018', 'é¨é¨æ°å¢', '103', '2', '', '', '', 1, 0, 'F', '0', '0', 'system:dept:add', '#', 103, 1, sysdate(), null, null, '');
			insert into sys_menu values('1019', 'é¨é¨ä¿®æ¹', '103', '3', '', '', '', 1, 0, 'F', '0', '0', 'system:dept:edit', '#', 103, 1, sysdate(), null, null, '');
			insert into sys_menu values('1020', 'é¨é¨å é¤', '103', '4', '', '', '', 1, 0, 'F', '0', '0', 'system:dept:remove', '#', 103, 1, sysdate(), null, null, '');
			-- å²ä½ç®¡çæé®
			insert into sys_menu values('1021', 'å²ä½æ¥è¯¢', '104', '1', '', '', '', 1, 0, 'F', '0', '0', 'system:post:query', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1022', 'å²ä½æ°å¢', '104', '2', '', '', '', 1, 0, 'F', '0', '0', 'system:post:add', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1023', 'å²ä½ä¿®æ¹', '104', '3', '', '', '', 1, 0, 'F', '0', '0', 'system:post:edit', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1024', 'å²ä½å é¤', '104', '4', '', '', '', 1, 0, 'F', '0', '0', 'system:post:remove', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1025', 'å²ä½å¯¼åº', '104', '5', '', '', '', 1, 0, 'F', '0', '0', 'system:post:export', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1021', 'å²ä½æ¥è¯¢', '104', '1', '', '', '', 1, 0, 'F', '0', '0', 'system:post:query', '#', 103, 1, sysdate(), null, null, '');
			insert into sys_menu values('1022', 'å²ä½æ°å¢', '104', '2', '', '', '', 1, 0, 'F', '0', '0', 'system:post:add', '#', 103, 1, sysdate(), null, null, '');
			insert into sys_menu values('1023', 'å²ä½ä¿®æ¹', '104', '3', '', '', '', 1, 0, 'F', '0', '0', 'system:post:edit', '#', 103, 1, sysdate(), null, null, '');
			insert into sys_menu values('1024', 'å²ä½å é¤', '104', '4', '', '', '', 1, 0, 'F', '0', '0', 'system:post:remove', '#', 103, 1, sysdate(), null, null, '');
			insert into sys_menu values('1025', 'å²ä½å¯¼åº', '104', '5', '', '', '', 1, 0, 'F', '0', '0', 'system:post:export', '#', 103, 1, sysdate(), null, null, '');
			-- åå¸ç®¡çæé®
			insert into sys_menu values('1026', 'åå¸æ¥è¯¢', '105', '1', '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:query', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1027', 'åå¸æ°å¢', '105', '2', '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:add', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1028', 'åå¸ä¿®æ¹', '105', '3', '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:edit', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1029', 'åå¸å é¤', '105', '4', '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:remove', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1030', 'åå¸å¯¼åº', '105', '5', '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:export', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1026', 'åå¸æ¥è¯¢', '105', '1', '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:query', '#', 103, 1, sysdate(), null, null, '');
			insert into sys_menu values('1027', 'åå¸æ°å¢', '105', '2', '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:add', '#', 103, 1, sysdate(), null, null, '');
			insert into sys_menu values('1028', 'åå¸ä¿®æ¹', '105', '3', '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:edit', '#', 103, 1, sysdate(), null, null, '');
			insert into sys_menu values('1029', 'åå¸å é¤', '105', '4', '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:remove', '#', 103, 1, sysdate(), null, null, '');
			insert into sys_menu values('1030', 'åå¸å¯¼åº', '105', '5', '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:export', '#', 103, 1, sysdate(), null, null, '');
			-- åæ°è®¾ç½®æé®
			insert into sys_menu values('1031', 'åæ°æ¥è¯¢', '106', '1', '#', '', '', 1, 0, 'F', '0', '0', 'system:config:query', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1032', 'åæ°æ°å¢', '106', '2', '#', '', '', 1, 0, 'F', '0', '0', 'system:config:add', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1033', 'åæ°ä¿®æ¹', '106', '3', '#', '', '', 1, 0, 'F', '0', '0', 'system:config:edit', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1034', 'åæ°å é¤', '106', '4', '#', '', '', 1, 0, 'F', '0', '0', 'system:config:remove', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1035', 'åæ°å¯¼åº', '106', '5', '#', '', '', 1, 0, 'F', '0', '0', 'system:config:export', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1031', 'åæ°æ¥è¯¢', '106', '1', '#', '', '', 1, 0, 'F', '0', '0', 'system:config:query', '#', 103, 1, sysdate(), null, null, '');
			insert into sys_menu values('1032', 'åæ°æ°å¢', '106', '2', '#', '', '', 1, 0, 'F', '0', '0', 'system:config:add', '#', 103, 1, sysdate(), null, null, '');
			insert into sys_menu values('1033', 'åæ°ä¿®æ¹', '106', '3', '#', '', '', 1, 0, 'F', '0', '0', 'system:config:edit', '#', 103, 1, sysdate(), null, null, '');
			insert into sys_menu values('1034', 'åæ°å é¤', '106', '4', '#', '', '', 1, 0, 'F', '0', '0', 'system:config:remove', '#', 103, 1, sysdate(), null, null, '');
			insert into sys_menu values('1035', 'åæ°å¯¼åº', '106', '5', '#', '', '', 1, 0, 'F', '0', '0', 'system:config:export', '#', 103, 1, sysdate(), null, null, '');
			-- éç¥å¬åæé®
			insert into sys_menu values('1036', 'å¬åæ¥è¯¢', '107', '1', '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:query', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1037', 'å¬åæ°å¢', '107', '2', '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:add', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1038', 'å¬åä¿®æ¹', '107', '3', '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:edit', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1039', 'å¬åå é¤', '107', '4', '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:remove', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1036', 'å¬åæ¥è¯¢', '107', '1', '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:query', '#', 103, 1, sysdate(), null, null, '');
			insert into sys_menu values('1037', 'å¬åæ°å¢', '107', '2', '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:add', '#', 103, 1, sysdate(), null, null, '');
			insert into sys_menu values('1038', 'å¬åä¿®æ¹', '107', '3', '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:edit', '#', 103, 1, sysdate(), null, null, '');
			insert into sys_menu values('1039', 'å¬åå é¤', '107', '4', '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:remove', '#', 103, 1, sysdate(), null, null, '');
			-- æä½æ¥å¿æé®
			insert into sys_menu values('1040', 'æä½æ¥è¯¢', '500', '1', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:operlog:query', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1041', 'æä½å é¤', '500', '2', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:operlog:remove', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1042', 'æ¥å¿å¯¼åº', '500', '4', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:operlog:export', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1040', 'æä½æ¥è¯¢', '500', '1', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:operlog:query', '#', 103, 1, sysdate(), null, null, '');
			insert into sys_menu values('1041', 'æä½å é¤', '500', '2', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:operlog:remove', '#', 103, 1, sysdate(), null, null, '');
			insert into sys_menu values('1042', 'æ¥å¿å¯¼åº', '500', '4', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:operlog:export', '#', 103, 1, sysdate(), null, null, '');
			-- ç»å½æ¥å¿æé®
			insert into sys_menu values('1043', 'ç»å½æ¥è¯¢', '501', '1', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:query', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1044', 'ç»å½å é¤', '501', '2', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:remove', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1045', 'æ¥å¿å¯¼åº', '501', '3', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:export', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1050', 'è´¦æ·è§£é', '501', '4', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:unlock', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1043', 'ç»å½æ¥è¯¢', '501', '1', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:query', '#', 103, 1, sysdate(), null, null, '');
			insert into sys_menu values('1044', 'ç»å½å é¤', '501', '2', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:remove', '#', 103, 1, sysdate(), null, null, '');
			insert into sys_menu values('1045', 'æ¥å¿å¯¼åº', '501', '3', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:export', '#', 103, 1, sysdate(), null, null, '');
			insert into sys_menu values('1050', 'è´¦æ·è§£é', '501', '4', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:unlock', '#', 103, 1, sysdate(), null, null, '');
			-- å¨çº¿ç¨æ·æé®
			insert into sys_menu values('1046', 'å¨çº¿æ¥è¯¢', '109', '1', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:online:query', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1047', 'æ¹éå¼ºé', '109', '2', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:online:batchLogout', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1048', 'åæ¡å¼ºé', '109', '3', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:online:forceLogout', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1046', 'å¨çº¿æ¥è¯¢', '109', '1', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:online:query', '#', 103, 1, sysdate(), null, null, '');
			insert into sys_menu values('1047', 'æ¹éå¼ºé', '109', '2', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:online:batchLogout', '#', 103, 1, sysdate(), null, null, '');
			insert into sys_menu values('1048', 'åæ¡å¼ºé', '109', '3', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:online:forceLogout', '#', 103, 1, sysdate(), null, null, '');
			-- ä»£ç çææé®
			insert into sys_menu values('1055', 'çææ¥è¯¢', '115', '1', '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:query', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1056', 'çæä¿®æ¹', '115', '2', '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:edit', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1057', 'çæå é¤', '115', '3', '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:remove', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1058', 'å¯¼å¥ä»£ç ', '115', '2', '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:import', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1059', 'é¢è§ä»£ç ', '115', '4', '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:preview', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1060', 'çæä»£ç ', '115', '5', '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:code', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1055', 'çææ¥è¯¢', '115', '1', '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:query', '#', 103, 1, sysdate(), null, null, '');
			insert into sys_menu values('1056', 'çæä¿®æ¹', '115', '2', '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:edit', '#', 103, 1, sysdate(), null, null, '');
			insert into sys_menu values('1057', 'çæå é¤', '115', '3', '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:remove', '#', 103, 1, sysdate(), null, null, '');
			insert into sys_menu values('1058', 'å¯¼å¥ä»£ç ', '115', '2', '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:import', '#', 103, 1, sysdate(), null, null, '');
			insert into sys_menu values('1059', 'é¢è§ä»£ç ', '115', '4', '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:preview', '#', 103, 1, sysdate(), null, null, '');
			insert into sys_menu values('1060', 'çæä»£ç ', '115', '5', '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:code', '#', 103, 1, sysdate(), null, null, '');
			-- ossç¸å³æé®
			insert into sys_menu values('1600', 'æä»¶æ¥è¯¢', '118', '1', '#', '', '', 1, 0, 'F', '0', '0', 'system:oss:query', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1601', 'æä»¶ä¸ä¼ ', '118', '2', '#', '', '', 1, 0, 'F', '0', '0', 'system:oss:upload', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1602', 'æä»¶ä¸è½½', '118', '3', '#', '', '', 1, 0, 'F', '0', '0', 'system:oss:download', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1603', 'æä»¶å é¤', '118', '4', '#', '', '', 1, 0, 'F', '0', '0', 'system:oss:remove', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1604', 'éç½®æ·»å ', '118', '5', '#', '', '', 1, 0, 'F', '0', '0', 'system:oss:add', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1605', 'éç½®ç¼è¾', '118', '6', '#', '', '', 1, 0, 'F', '0', '0', 'system:oss:edit', '#', 'admin', sysdate(), '', null, '');
			insert into sys_menu values('1600', 'æä»¶æ¥è¯¢', '118', '1', '#', '', '', 1, 0, 'F', '0', '0', 'system:oss:query', '#', 103, 1, sysdate(), null, null, '');
			insert into sys_menu values('1601', 'æä»¶ä¸ä¼ ', '118', '2', '#', '', '', 1, 0, 'F', '0', '0', 'system:oss:upload', '#', 103, 1, sysdate(), null, null, '');
			insert into sys_menu values('1602', 'æä»¶ä¸è½½', '118', '3', '#', '', '', 1, 0, 'F', '0', '0', 'system:oss:download', '#', 103, 1, sysdate(), null, null, '');
			insert into sys_menu values('1603', 'æä»¶å é¤', '118', '4', '#', '', '', 1, 0, 'F', '0', '0', 'system:oss:remove', '#', 103, 1, sysdate(), null, null, '');
			insert into sys_menu values('1604', 'éç½®æ·»å ', '118', '5', '#', '', '', 1, 0, 'F', '0', '0', 'system:oss:add', '#', 103, 1, sysdate(), null, null, '');
			insert into sys_menu values('1605', 'éç½®ç¼è¾', '118', '6', '#', '', '', 1, 0, 'F', '0', '0', 'system:oss:edit', '#', 103, 1, sysdate(), null, null, '');


			-- ----------------------------
			@@ -443,23 +450,24 @@
			dict_name varchar(100) default '' comment 'åå¸åç§°',
			dict_type varchar(100) default '' comment 'åå¸ç±»å',
			status char(1) default '0' comment 'ç¶æï¼0æ£å¸¸ 1åç¨ï¼',
			create_by varchar(64) default '' comment 'åå»ºè',
			create_dept bigint(20) default null comment 'åå»ºé¨é¨',
			create_by varchar(64) default null comment 'åå»ºè',
			create_time datetime comment 'åå»ºæ¶é´',
			update_by varchar(64) default '' comment 'æ´æ°è',
			update_by varchar(64) default null comment 'æ´æ°è',
			update_time datetime comment 'æ´æ°æ¶é´',
			remark varchar(500) default null comment 'å¤æ³¨',
			primary key (dict_id),
			unique (dict_type)
			) engine=innodb 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, 'èåç¶æåè¡¨');
			insert into sys_dict_type values(3, 'ç³»ç»å¼å³', 'sys_normal_disable', '0', 'admin', sysdate(), '', null, 'ç³»ç»å¼å³åè¡¨');
			insert into sys_dict_type values(6, 'ç³»ç»æ¯å¦', 'sys_yes_no', '0', 'admin', sysdate(), '', null, 'ç³»ç»æ¯å¦åè¡¨');
			insert into sys_dict_type values(7, 'éç¥ç±»å', 'sys_notice_type', '0', 'admin', sysdate(), '', null, 'éç¥ç±»ååè¡¨');
			insert into sys_dict_type values(8, 'éç¥ç¶æ', 'sys_notice_status', '0', 'admin', sysdate(), '', null, 'éç¥ç¶æåè¡¨');
			insert into sys_dict_type values(9, 'æä½ç±»å', 'sys_oper_type', '0', 'admin', sysdate(), '', null, 'æä½ç±»ååè¡¨');
			insert into sys_dict_type values(10, 'ç³»ç»ç¶æ', 'sys_common_status', '0', 'admin', sysdate(), '', null, 'ç»å½ç¶æåè¡¨');
			insert into sys_dict_type values(1, 'ç¨æ·æ§å«', 'sys_user_sex', '0', 103, 1, sysdate(), null, null, 'ç¨æ·æ§å«åè¡¨');
			insert into sys_dict_type values(2, 'èåç¶æ', 'sys_show_hide', '0', 103, 1, sysdate(), null, null, 'èåç¶æåè¡¨');
			insert into sys_dict_type values(3, 'ç³»ç»å¼å³', 'sys_normal_disable', '0', 103, 1, sysdate(), null, null, 'ç³»ç»å¼å³åè¡¨');
			insert into sys_dict_type values(6, 'ç³»ç»æ¯å¦', 'sys_yes_no', '0', 103, 1, sysdate(), null, null, 'ç³»ç»æ¯å¦åè¡¨');
			insert into sys_dict_type values(7, 'éç¥ç±»å', 'sys_notice_type', '0', 103, 1, sysdate(), null, null, 'éç¥ç±»ååè¡¨');
			insert into sys_dict_type values(8, 'éç¥ç¶æ', 'sys_notice_status', '0', 103, 1, sysdate(), null, null, 'éç¥ç¶æåè¡¨');
			insert into sys_dict_type values(9, 'æä½ç±»å', 'sys_oper_type', '0', 103, 1, sysdate(), null, null, 'æä½ç±»ååè¡¨');
			insert into sys_dict_type values(10, 'ç³»ç»ç¶æ', 'sys_common_status', '0', 103, 1, sysdate(), null, null, 'ç»å½ç¶æåè¡¨');


			-- ----------------------------
			@@ -477,39 +485,40 @@
			list_class varchar(100) default null comment 'è¡¨æ ¼åæ¾æ ·å¼',
			is_default char(1) default 'N' comment 'æ¯å¦é»è®¤ï¼Yæ¯ Nå¦ï¼',
			status char(1) default '0' comment 'ç¶æï¼0æ£å¸¸ 1åç¨ï¼',
			create_by varchar(64) default '' comment 'åå»ºè',
			create_dept bigint(20) default null comment 'åå»ºé¨é¨',
			create_by varchar(64) default null comment 'åå»ºè',
			create_time datetime comment 'åå»ºæ¶é´',
			update_by varchar(64) default '' comment 'æ´æ°è',
			update_by varchar(64) 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, 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, 'æ§å«å¥³');
			insert into sys_dict_data values(3, 3, 'æªç¥', '2', 'sys_user_sex', '', '', 'N', '0', 'admin', sysdate(), '', null, 'æ§å«æªç¥');
			insert into sys_dict_data values(4, 1, 'æ¾ç¤º', '0', 'sys_show_hide', '', 'primary', 'Y', '0', 'admin', sysdate(), '', null, 'æ¾ç¤ºèå');
			insert into sys_dict_data values(5, 2, 'éè', '1', 'sys_show_hide', '', 'danger', 'N', '0', 'admin', sysdate(), '', null, 'éèèå');
			insert into sys_dict_data values(6, 1, 'æ£å¸¸', '0', 'sys_normal_disable', '', 'primary', 'Y', '0', 'admin', sysdate(), '', null, 'æ£å¸¸ç¶æ');
			insert into sys_dict_data values(7, 2, 'åç¨', '1', 'sys_normal_disable', '', 'danger', 'N', '0', 'admin', sysdate(), '', null, 'åç¨ç¶æ');
			insert into sys_dict_data values(12, 1, 'æ¯', 'Y', 'sys_yes_no', '', 'primary', 'Y', '0', 'admin', sysdate(), '', null, 'ç³»ç»é»è®¤æ¯');
			insert into sys_dict_data values(13, 2, 'å¦', 'N', 'sys_yes_no', '', 'danger', 'N', '0', 'admin', sysdate(), '', null, 'ç³»ç»é»è®¤å¦');
			insert into sys_dict_data values(14, 1, 'éç¥', '1', 'sys_notice_type', '', 'warning', 'Y', '0', 'admin', sysdate(), '', null, 'éç¥');
			insert into sys_dict_data values(15, 2, 'å¬å', '2', 'sys_notice_type', '', 'success', 'N', '0', 'admin', sysdate(), '', null, 'å¬å');
			insert into sys_dict_data values(16, 1, 'æ£å¸¸', '0', 'sys_notice_status', '', 'primary', 'Y', '0', 'admin', sysdate(), '', null, 'æ£å¸¸ç¶æ');
			insert into sys_dict_data values(17, 2, 'å³é', '1', 'sys_notice_status', '', 'danger', 'N', '0', 'admin', sysdate(), '', null, 'å³éç¶æ');
			insert into sys_dict_data values(29, 99, 'å¶ä»', '0', 'sys_oper_type', '', 'info', 'N', '0', 'admin', sysdate(), '', null, 'å¶ä»æä½');
			insert into sys_dict_data values(18, 1, 'æ°å¢', '1', 'sys_oper_type', '', 'info', 'N', '0', 'admin', sysdate(), '', null, 'æ°å¢æä½');
			insert into sys_dict_data values(19, 2, 'ä¿®æ¹', '2', 'sys_oper_type', '', 'info', 'N', '0', 'admin', sysdate(), '', null, 'ä¿®æ¹æä½');
			insert into sys_dict_data values(20, 3, 'å é¤', '3', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', sysdate(), '', null, 'å é¤æä½');
			insert into sys_dict_data values(21, 4, 'ææ', '4', 'sys_oper_type', '', 'primary', 'N', '0', 'admin', sysdate(), '', null, 'æææä½');
			insert into sys_dict_data values(22, 5, 'å¯¼åº', '5', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', sysdate(), '', null, 'å¯¼åºæä½');
			insert into sys_dict_data values(23, 6, 'å¯¼å¥', '6', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', sysdate(), '', null, 'å¯¼å¥æä½');
			insert into sys_dict_data values(24, 7, 'å¼ºé', '7', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', sysdate(), '', null, 'å¼ºéæä½');
			insert into sys_dict_data values(25, 8, 'çæä»£ç ', '8', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', sysdate(), '', null, 'çææä½');
			insert into sys_dict_data values(26, 9, 'æ¸ç©ºæ°æ®', '9', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', sysdate(), '', null, 'æ¸ç©ºæä½');
			insert into sys_dict_data values(27, 1, 'æå', '0', 'sys_common_status', '', 'primary', 'N', '0', 'admin', sysdate(), '', null, 'æ£å¸¸ç¶æ');
			insert into sys_dict_data values(28, 2, 'å¤±è´¥', '1', 'sys_common_status', '', 'danger', 'N', '0', 'admin', sysdate(), '', null, 'åç¨ç¶æ');
			insert into sys_dict_data values(1, 1, 'ç·', '0', 'sys_user_sex', '', '', 'Y', '0', 103, 1, sysdate(), null, null, 'æ§å«ç·');
			insert into sys_dict_data values(2, 2, 'å¥³', '1', 'sys_user_sex', '', '', 'N', '0', 103, 1, sysdate(), null, null, 'æ§å«å¥³');
			insert into sys_dict_data values(3, 3, 'æªç¥', '2', 'sys_user_sex', '', '', 'N', '0', 103, 1, sysdate(), null, null, 'æ§å«æªç¥');
			insert into sys_dict_data values(4, 1, 'æ¾ç¤º', '0', 'sys_show_hide', '', 'primary', 'Y', '0', 103, 1, sysdate(), null, null, 'æ¾ç¤ºèå');
			insert into sys_dict_data values(5, 2, 'éè', '1', 'sys_show_hide', '', 'danger', 'N', '0', 103, 1, sysdate(), null, null, 'éèèå');
			insert into sys_dict_data values(6, 1, 'æ£å¸¸', '0', 'sys_normal_disable', '', 'primary', 'Y', '0', 103, 1, sysdate(), null, null, 'æ£å¸¸ç¶æ');
			insert into sys_dict_data values(7, 2, 'åç¨', '1', 'sys_normal_disable', '', 'danger', 'N', '0', 103, 1, sysdate(), null, null, 'åç¨ç¶æ');
			insert into sys_dict_data values(12, 1, 'æ¯', 'Y', 'sys_yes_no', '', 'primary', 'Y', '0', 103, 1, sysdate(), null, null, 'ç³»ç»é»è®¤æ¯');
			insert into sys_dict_data values(13, 2, 'å¦', 'N', 'sys_yes_no', '', 'danger', 'N', '0', 103, 1, sysdate(), null, null, 'ç³»ç»é»è®¤å¦');
			insert into sys_dict_data values(14, 1, 'éç¥', '1', 'sys_notice_type', '', 'warning', 'Y', '0', 103, 1, sysdate(), null, null, 'éç¥');
			insert into sys_dict_data values(15, 2, 'å¬å', '2', 'sys_notice_type', '', 'success', 'N', '0', 103, 1, sysdate(), null, null, 'å¬å');
			insert into sys_dict_data values(16, 1, 'æ£å¸¸', '0', 'sys_notice_status', '', 'primary', 'Y', '0', 103, 1, sysdate(), null, null, 'æ£å¸¸ç¶æ');
			insert into sys_dict_data values(17, 2, 'å³é', '1', 'sys_notice_status', '', 'danger', 'N', '0', 103, 1, sysdate(), null, null, 'å³éç¶æ');
			insert into sys_dict_data values(29, 99, 'å¶ä»', '0', 'sys_oper_type', '', 'info', 'N', '0', 103, 1, sysdate(), null, null, 'å¶ä»æä½');
			insert into sys_dict_data values(18, 1, 'æ°å¢', '1', 'sys_oper_type', '', 'info', 'N', '0', 103, 1, sysdate(), null, null, 'æ°å¢æä½');
			insert into sys_dict_data values(19, 2, 'ä¿®æ¹', '2', 'sys_oper_type', '', 'info', 'N', '0', 103, 1, sysdate(), null, null, 'ä¿®æ¹æä½');
			insert into sys_dict_data values(20, 3, 'å é¤', '3', 'sys_oper_type', '', 'danger', 'N', '0', 103, 1, sysdate(), null, null, 'å é¤æä½');
			insert into sys_dict_data values(21, 4, 'ææ', '4', 'sys_oper_type', '', 'primary', 'N', '0', 103, 1, sysdate(), null, null, 'æææä½');
			insert into sys_dict_data values(22, 5, 'å¯¼åº', '5', 'sys_oper_type', '', 'warning', 'N', '0', 103, 1, sysdate(), null, null, 'å¯¼åºæä½');
			insert into sys_dict_data values(23, 6, 'å¯¼å¥', '6', 'sys_oper_type', '', 'warning', 'N', '0', 103, 1, sysdate(), null, null, 'å¯¼å¥æä½');
			insert into sys_dict_data values(24, 7, 'å¼ºé', '7', 'sys_oper_type', '', 'danger', 'N', '0', 103, 1, sysdate(), null, null, 'å¼ºéæä½');
			insert into sys_dict_data values(25, 8, 'çæä»£ç ', '8', 'sys_oper_type', '', 'warning', 'N', '0', 103, 1, sysdate(), null, null, 'çææä½');
			insert into sys_dict_data values(26, 9, 'æ¸ç©ºæ°æ®', '9', 'sys_oper_type', '', 'danger', 'N', '0', 103, 1, sysdate(), null, null, 'æ¸ç©ºæä½');
			insert into sys_dict_data values(27, 1, 'æå', '0', 'sys_common_status', '', 'primary', 'N', '0', 103, 1, sysdate(), null, null, 'æ£å¸¸ç¶æ');
			insert into sys_dict_data values(28, 2, 'å¤±è´¥', '1', 'sys_common_status', '', 'danger', 'N', '0', 103, 1, sysdate(), null, null, 'åç¨ç¶æ');


			-- ----------------------------
			@@ -522,20 +531,21 @@
			config_key varchar(100) default '' comment 'åæ°é®å',
			config_value varchar(500) default '' comment 'åæ°é®å¼',
			config_type char(1) default 'N' comment 'ç³»ç»åç½®ï¼Yæ¯ Nå¦ï¼',
			create_by varchar(64) default '' comment 'åå»ºè',
			create_dept bigint(20) default null comment 'åå»ºé¨é¨',
			create_by bigint(20) default null comment 'åå»ºè',
			create_time datetime comment 'åå»ºæ¶é´',
			update_by varchar(64) default '' 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, 'ä¸»æ¡æ¶é¡µ-é»è®¤ç®è¤æ ·å¼åç§°', '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' );
			insert into sys_config values(3, 'ä¸»æ¡æ¶é¡µ-ä¾§è¾¹æ ä¸»é¢', 'sys.index.sideTheme', 'theme-dark', 'Y', 'admin', sysdate(), '', null, 'æ·±è²ä¸»é¢theme-darkï¼æµè²ä¸»é¢theme-light' );
			insert into sys_config values(4, 'è´¦å·èªå©-éªè¯ç å¼å³', 'sys.account.captchaEnabled', 'true', 'Y', 'admin', sysdate(), '', null, 'æ¯å¦å¼å¯éªè¯ç åè½ï¼trueå¼å¯ï¼falseå³éï¼');
			insert into sys_config values(5, 'è´¦å·èªå©-æ¯å¦å¼å¯ç¨æ·æ³¨ååè½', 'sys.account.registerUser', 'false', 'Y', 'admin', sysdate(), '', null, 'æ¯å¦å¼å¯æ³¨åç¨æ·åè½ï¼trueå¼å¯ï¼falseå³éï¼');
			insert into sys_config values(11, 'OSSé¢è§åè¡¨èµæºå¼å³', 'sys.oss.previewListResource', 'true', 'Y', 'admin', sysdate(), '', null, 'true:å¼å¯, false:å³é');
			insert into sys_config values(1, 'ä¸»æ¡æ¶é¡µ-é»è®¤ç®è¤æ ·å¼åç§°', '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, 'ç¨æ·ç®¡ç-è´¦å·åå§å¯ç ', 'sys.user.initPassword', '123456', 'Y', 103, 1, sysdate(), null, null, 'åå§åå¯ç 123456' );
			insert into sys_config values(3, 'ä¸»æ¡æ¶é¡µ-ä¾§è¾¹æ ä¸»é¢', 'sys.index.sideTheme', 'theme-dark', 'Y', 103, 1, sysdate(), null, null, 'æ·±è²ä¸»é¢theme-darkï¼æµè²ä¸»é¢theme-light' );
			insert into sys_config values(4, 'è´¦å·èªå©-éªè¯ç å¼å³', 'sys.account.captchaEnabled', 'true', 'Y', 103, 1, sysdate(), null, null, 'æ¯å¦å¼å¯éªè¯ç åè½ï¼trueå¼å¯ï¼falseå³éï¼');
			insert into sys_config values(5, 'è´¦å·èªå©-æ¯å¦å¼å¯ç¨æ·æ³¨ååè½', 'sys.account.registerUser', 'false', 'Y', 103, 1, sysdate(), null, null, 'æ¯å¦å¼å¯æ³¨åç¨æ·åè½ï¼trueå¼å¯ï¼falseå³éï¼');
			insert into sys_config values(11, 'OSSé¢è§åè¡¨èµæºå¼å³', 'sys.oss.previewListResource', 'true', 'Y', 103, 1, sysdate(), null, null, 'true:å¼å¯, false:å³é');


			-- ----------------------------
			@@ -566,9 +576,10 @@
			notice_type char(1) not null comment 'å¬åç±»åï¼1éç¥ 2å¬åï¼',
			notice_content longblob default null comment 'å¬ååå®¹',
			status char(1) default '0' comment 'å¬åç¶æï¼0æ£å¸¸ 1å³éï¼',
			create_by varchar(64) default '' comment 'åå»ºè',
			create_dept bigint(20) default null comment 'åå»ºé¨é¨',
			create_by bigint(20) default null comment 'åå»ºè',
			create_time datetime comment 'åå»ºæ¶é´',
			update_by varchar(64) default '' comment 'æ´æ°è',
			update_by bigint(20) default null comment 'æ´æ°è',
			update_time datetime comment 'æ´æ°æ¶é´',
			remark varchar(255) default null comment 'å¤æ³¨',
			primary key (notice_id)
			@@ -577,8 +588,8 @@
			-- ----------------------------
			-- åå§å-å¬åä¿¡æ¯è¡¨æ°æ®
			-- ----------------------------
			insert into sys_notice values('1', 'æ¸©é¦¨æéï¼2018-07-01 æ°çæ¬åå¸å¦', '2', 'æ°çæ¬åå®¹', '0', 'admin', sysdate(), '', null, 'ç®¡çå');
			insert into sys_notice values('2', 'ç»´æ¤éç¥ï¼2018-07-01 ç³»ç»åæ¨ç»´æ¤', '1', 'ç»´æ¤åå®¹', '0', 'admin', sysdate(), '', null, 'ç®¡çå');
			insert into sys_notice values('1', 'æ¸©é¦¨æéï¼2018-07-01 æ°çæ¬åå¸å¦', '2', 'æ°çæ¬åå®¹', '0', 103, 1, sysdate(), null, null, 'ç®¡çå');
			insert into sys_notice values('2', 'ç»´æ¤éç¥ï¼2018-07-01 ç³»ç»åæ¨ç»´æ¤', '1', 'ç»´æ¤åå®¹', '0', 103, 1, sysdate(), null, null, 'ç®¡çå');


			-- ----------------------------
			@@ -601,9 +612,10 @@
			gen_type char(1) default '0' comment 'çæä»£ç æ¹å¼ï¼0zipåç¼©å 1èªå®ä¹è·¯å¾ï¼',
			gen_path varchar(200) default '/' comment 'çæè·¯å¾ï¼ä¸å¡«é»è®¤é¡¹ç®è·¯å¾ï¼',
			options varchar(1000) comment 'å¶å®çæéé¡¹',
			create_by varchar(64) default '' comment 'åå»ºè',
			create_dept bigint(20) default null comment 'åå»ºé¨é¨',
			create_by bigint(20) default null comment 'åå»ºè',
			create_time datetime comment 'åå»ºæ¶é´',
			update_by varchar(64) default '' comment 'æ´æ°è',
			update_by bigint(20) default null comment 'æ´æ°è',
			update_time datetime comment 'æ´æ°æ¶é´',
			remark varchar(500) default null comment 'å¤æ³¨',
			primary key (table_id)
			@@ -633,9 +645,10 @@
			html_type varchar(200) comment 'æ¾ç¤ºç±»åï¼ææ¬æ¡ãææ¬åãä¸ææ¡ãå¤éæ¡ãåéæ¡ãæ¥ææ§ä»¶ï¼',
			dict_type varchar(200) default '' comment 'åå¸ç±»å',
			sort int comment 'æåº',
			create_by varchar(64) default '' comment 'åå»ºè',
			create_dept bigint(20) default null comment 'åå»ºé¨é¨',
			create_by bigint(20) default null comment 'åå»ºè',
			create_time datetime comment 'åå»ºæ¶é´',
			update_by varchar(64) default '' comment 'æ´æ°è',
			update_by bigint(20) default null comment 'æ´æ°è',
			update_time datetime comment 'æ´æ°æ¶é´',
			primary key (column_id)
			) engine=innodb comment = 'ä»£ç çæä¸å¡è¡¨åæ®µ';
			@@ -650,10 +663,11 @@
			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 varchar(64) default '' comment 'ä¸ä¼ äºº',
			create_by bigint(20) default null comment 'ä¸ä¼ äºº',
			update_time datetime default null comment 'æ´æ°æ¶é´',
			update_by varchar(64) default '' comment 'æ´æ°äºº',
			update_by bigint(20) default null comment 'æ´æ°äºº',
			service varchar(20) not null default 'minio' comment 'æå¡å',
			primary key (oss_id)
			) engine=innodb comment ='OSSå¯¹è±¡åå¨è¡¨';
			@@ -676,16 +690,17 @@
			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_by varchar(64) default '' comment 'åå»ºè',
			create_dept bigint(20) default null comment 'åå»ºé¨é¨',
			create_by bigint(20) default null comment 'åå»ºè',
			create_time datetime default null comment 'åå»ºæ¶é´',
			update_by varchar(64) default '' 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, 'minio', 'ruoyi', 'ruoyi123', 'ruoyi', '', '127.0.0.1:9000', '','N', '', '1' ,'0', '', 'admin', sysdate(), 'admin', sysdate(), NULL);
			insert into sys_oss_config values (2, 'qiniu', 'XXXXXXXXXXXXXXX', 'XXXXXXXXXXXXXXX', 'ruoyi', '', 's3-cn-north-1.qiniucs.com', '','N', '', '1' ,'1', '', 'admin', sysdate(), 'admin', sysdate(), NULL);
			insert into sys_oss_config values (3, 'aliyun', 'XXXXXXXXXXXXXXX', 'XXXXXXXXXXXXXXX', 'ruoyi', '', 'oss-cn-beijing.aliyuncs.com', '','N', '', '1' ,'1', '', 'admin', sysdate(), 'admin', sysdate(), NULL);
			insert into sys_oss_config values (4, 'qcloud', 'XXXXXXXXXXXXXXX', 'XXXXXXXXXXXXXXX', 'ruoyi-1250000000', '', 'cos.ap-beijing.myqcloud.com', '','N', 'ap-beijing', '1' ,'1', '', 'admin', sysdate(), 'admin', sysdate(), NULL);
			insert into sys_oss_config values (5, 'image', 'ruoyi', 'ruoyi123', 'ruoyi', 'image', '127.0.0.1:9000', '','N', '', '1' ,'1', '', 'admin', sysdate(), 'admin', sysdate(), NULL);
			insert into sys_oss_config values (1, '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, '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, '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, '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, 'image', 'ruoyi', 'ruoyi123', 'ruoyi', 'image', '127.0.0.1:9000', '','N', '', '1' ,'1', '', 103, 1, sysdate(), 1, sysdate(), NULL);