lbqms.git - Gitblit

ÎÄ¼þÃû´Ó script/sql/postgres/postgres_ry_vue_4.X.sql ÐÞ¸Ä
			@@ -14,9 +14,10 @@
			email varchar(50) default null::varchar,
			status char default '0'::bpchar,
			del_flag char default '0'::bpchar,
			create_by varchar(64) default ''::varchar,
			create_dept int8,
			create_by int8,
			create_time timestamp,
			update_by varchar(64) default ''::varchar,
			update_by int8,
			update_time timestamp,
			constraint "sys_dept_pk" primary key (dept_id)
			);
			@@ -32,6 +33,7 @@
			comment on column sys_dept.email is 'é®ç®±';
			comment on column sys_dept.status is 'é¨é¨ç¶æï¼0æ£å¸¸ 1åç¨ï¼';
			comment on column sys_dept.del_flag is 'å é¤æ å¿ï¼0ä»£è¡¨åå¨ 2ä»£è¡¨å é¤ï¼';
			comment on column sys_dept.create_dept is 'åå»ºé¨é¨';
			comment on column sys_dept.create_by is 'åå»ºè';
			comment on column sys_dept.create_time is 'åå»ºæ¶é´';
			comment on column sys_dept.update_by is 'æ´æ°è';
			@@ -40,16 +42,16 @@
			-- ----------------------------
			-- åå§å-é¨é¨è¡¨æ°æ®
			-- ----------------------------
			insert into sys_dept values(100, 0, '0', 'è¥ä¾ç§æ', 0, 'è¥ä¾', '15888888888', 'ry@qq.com', '0', '0', 'admin', now(), '', null);
			insert into sys_dept values(101, 100, '0,100', 'æ·±å³æ»å¬å¸', 1, 'è¥ä¾', '15888888888', 'ry@qq.com', '0', '0', 'admin', now(), '', null);
			insert into sys_dept values(102, 100, '0,100', 'é¿æ²åå¬å¸', 2, 'è¥ä¾', '15888888888', 'ry@qq.com', '0', '0', 'admin', now(), '', null);
			insert into sys_dept values(103, 101, '0,100,101', 'ç åé¨é¨', 1, 'è¥ä¾', '15888888888', 'ry@qq.com', '0', '0', 'admin', now(), '', null);
			insert into sys_dept values(104, 101, '0,100,101', 'å¸åºé¨é¨', 2, 'è¥ä¾', '15888888888', 'ry@qq.com', '0', '0', 'admin', now(), '', null);
			insert into sys_dept values(105, 101, '0,100,101', 'æµè¯é¨é¨', 3, 'è¥ä¾', '15888888888', 'ry@qq.com', '0', '0', 'admin', now(), '', null);
			insert into sys_dept values(106, 101, '0,100,101', 'è´¢å¡é¨é¨', 4, 'è¥ä¾', '15888888888', 'ry@qq.com', '0', '0', 'admin', now(), '', null);
			insert into sys_dept values(107, 101, '0,100,101', 'è¿ç»´é¨é¨', 5, 'è¥ä¾', '15888888888', 'ry@qq.com', '0', '0', 'admin', now(), '', null);
			insert into sys_dept values(108, 102, '0,100,102', 'å¸åºé¨é¨', 1, 'è¥ä¾', '15888888888', 'ry@qq.com', '0', '0', 'admin', now(), '', null);
			insert into sys_dept values(109, 102, '0,100,102', 'è´¢å¡é¨é¨', 2, 'è¥ä¾', '15888888888', 'ry@qq.com', '0', '0', 'admin', now(), '', null);
			insert into sys_dept values(100, 0, '0', 'è¥ä¾ç§æ', 0, 'è¥ä¾', '15888888888', 'ry@qq.com', '0', '0', 103, 1, now(), null, null);
			insert into sys_dept values(101, 100, '0,100', 'æ·±å³æ»å¬å¸', 1, 'è¥ä¾', '15888888888', 'ry@qq.com', '0', '0', 103, 1, now(), null, null);
			insert into sys_dept values(102, 100, '0,100', 'é¿æ²åå¬å¸', 2, 'è¥ä¾', '15888888888', 'ry@qq.com', '0', '0', 103, 1, now(), null, null);
			insert into sys_dept values(103, 101, '0,100,101', 'ç åé¨é¨', 1, 'è¥ä¾', '15888888888', 'ry@qq.com', '0', '0', 103, 1, now(), null, null);
			insert into sys_dept values(104, 101, '0,100,101', 'å¸åºé¨é¨', 2, 'è¥ä¾', '15888888888', 'ry@qq.com', '0', '0', 103, 1, now(), null, null);
			insert into sys_dept values(105, 101, '0,100,101', 'æµè¯é¨é¨', 3, 'è¥ä¾', '15888888888', 'ry@qq.com', '0', '0', 103, 1, now(), null, null);
			insert into sys_dept values(106, 101, '0,100,101', 'è´¢å¡é¨é¨', 4, 'è¥ä¾', '15888888888', 'ry@qq.com', '0', '0', 103, 1, now(), null, null);
			insert into sys_dept values(107, 101, '0,100,101', 'è¿ç»´é¨é¨', 5, 'è¥ä¾', '15888888888', 'ry@qq.com', '0', '0', 103, 1, now(), null, null);
			insert into sys_dept values(108, 102, '0,100,102', 'å¸åºé¨é¨', 1, 'è¥ä¾', '15888888888', 'ry@qq.com', '0', '0', 103, 1, now(), null, null);
			insert into sys_dept values(109, 102, '0,100,102', 'è´¢å¡é¨é¨', 2, 'è¥ä¾', '15888888888', 'ry@qq.com', '0', '0', 103, 1, now(), null, null);

			-- ----------------------------
			-- 2ãç¨æ·ä¿¡æ¯è¡¨
			@@ -71,9 +73,10 @@
			del_flag char default '0'::bpchar,
			login_ip varchar(128) default ''::varchar,
			login_date timestamp,
			create_by varchar(64) default ''::varchar,
			create_dept int8,
			create_by int8,
			create_time timestamp,
			update_by varchar(64) default ''::varchar,
			update_by int8,
			update_time timestamp,
			remark varchar(500) default null::varchar,
			constraint "sys_user_pk" primary key (user_id)
			@@ -94,6 +97,7 @@
			comment on column sys_user.del_flag is 'å é¤æ å¿ï¼0ä»£è¡¨åå¨ 2ä»£è¡¨å é¤ï¼';
			comment on column sys_user.login_ip is 'æåç»éIP';
			comment on column sys_user.login_date is 'æåç»éæ¶é´';
			comment on column sys_user.create_dept is 'åå»ºé¨é¨';
			comment on column sys_user.create_by is 'åå»ºè';
			comment on column sys_user.create_time is 'åå»ºæ¶é´';
			comment on column sys_user.update_by is 'æ´æ°è';
			@@ -101,10 +105,11 @@
			comment on column sys_user.remark is 'å¤æ³¨';

			-- ----------------------------

			-- åå§å-ç¨æ·ä¿¡æ¯è¡¨æ°æ®
			-- ----------------------------
			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', now(), 'admin', now(), '', null, 'ç®¡çå');
			insert into sys_user values(2, 105, 'ry', 'ç¯ççç®åLi', 'sys_user', 'crazyLionLi@qq.com', '15666666666', '1', '', '$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', '0', '0', '127.0.0.1', now(), 'admin', now(), '', null, 'æµè¯å');
			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', now(), 103, 1, now(), null, null, 'ç®¡çå');
			insert into sys_user values(2, 105, 'ry', 'ç¯ççç®åLi', 'sys_user', 'crazyLionLi@qq.com', '15666666666', '1', '', '$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', '0', '0', '127.0.0.1', now(), 103, 1, now(), null, null, 'æµè¯å');


			-- ----------------------------
			@@ -118,9 +123,10 @@
			post_name varchar(50) not null,
			post_sort int4 not null,
			status char not null,
			create_by varchar(64) default ''::varchar,
			create_dept int8,
			create_by int8,
			create_time timestamp,
			update_by varchar(64) default ''::varchar,
			update_by int8,
			update_time timestamp,
			remark varchar(500) default null::varchar,
			constraint "sys_post_pk" primary key (post_id)
			@@ -132,6 +138,7 @@
			comment on column sys_post.post_name is 'å²ä½åç§°';
			comment on column sys_post.post_sort is 'æ¾ç¤ºé¡ºåº';
			comment on column sys_post.status is 'ç¶æï¼0æ£å¸¸ 1åç¨ï¼';
			comment on column sys_post.create_dept is 'åå»ºé¨é¨';
			comment on column sys_post.create_by is 'åå»ºè';
			comment on column sys_post.create_time is 'åå»ºæ¶é´';
			comment on column sys_post.update_by is 'æ´æ°è';
			@@ -141,10 +148,10 @@
			-- ----------------------------
			-- åå§å-å²ä½ä¿¡æ¯è¡¨æ°æ®
			-- ----------------------------
			insert into sys_post values(1, 'ceo', 'è£äºé¿', 1, '0', 'admin', now(), '', null, '');
			insert into sys_post values(2, 'se', 'é¡¹ç®ç»ç', 2, '0', 'admin', now(), '', null, '');
			insert into sys_post values(3, 'hr', 'äººåèµæº', 3, '0', 'admin', now(), '', null, '');
			insert into sys_post values(4, 'user', 'æ®éåå·¥', 4, '0', 'admin', now(), '', null, '');
			insert into sys_post values(1, 'ceo', 'è£äºé¿', 1, '0', 103, 1, now(), null, null, '');
			insert into sys_post values(2, 'se', 'é¡¹ç®ç»ç', 2, '0', 103, 1, now(), null, null, '');
			insert into sys_post values(3, 'hr', 'äººåèµæº', 3, '0', 103, 1, now(), null, null, '');
			insert into sys_post values(4, 'user', 'æ®éåå·¥', 4, '0', 103, 1, now(), null, null, '');

			-- ----------------------------
			-- 4ãè§è²ä¿¡æ¯è¡¨
			@@ -161,9 +168,10 @@
			dept_check_strictly bool default true,
			status char not null,
			del_flag char default '0'::bpchar,
			create_by varchar(64) default ''::varchar,
			create_dept int8,
			create_by int8,
			create_time timestamp,
			update_by varchar(64) default ''::varchar,
			update_by int8,
			update_time timestamp,
			remark varchar(500) default null::varchar,
			constraint "sys_role_pk" primary key (role_id)
			@@ -179,6 +187,7 @@
			comment on column sys_role.dept_check_strictly is 'é¨é¨æ éæ©é¡¹æ¯å¦å³èæ¾ç¤º';
			comment on column sys_role.status is 'è§è²ç¶æï¼0æ£å¸¸ 1åç¨ï¼';
			comment on column sys_role.del_flag is 'å é¤æ å¿ï¼0ä»£è¡¨åå¨ 2ä»£è¡¨å é¤ï¼';
			comment on column sys_role.create_dept is 'åå»ºé¨é¨';
			comment on column sys_role.create_by is 'åå»ºè';
			comment on column sys_role.create_time is 'åå»ºæ¶é´';
			comment on column sys_role.update_by is 'æ´æ°è';
			@@ -188,8 +197,8 @@
			-- ----------------------------
			-- åå§å-è§è²ä¿¡æ¯è¡¨æ°æ®
			-- ----------------------------
			insert into sys_role values('1', 'è¶çº§ç®¡çå', 'admin', 1, '1', 't', 't', '0', '0', 'admin', now(), '', null, 'è¶çº§ç®¡çå');
			insert into sys_role values('2', 'æ®éè§è²', 'common', 2, '2', 't', 't', '0', '0', 'admin', now(), '', null, 'æ®éè§è²');
			insert into sys_role values('1', 'è¶çº§ç®¡çå', 'admin', 1, '1', 't', 't', '0', '0', 103, 1, now(), null, null, 'è¶çº§ç®¡çå');
			insert into sys_role values('2', 'æ®éè§è²', 'common', 2, '2', 't', 't', '0', '0', 103, 1, now(), null, null, 'æ®éè§è²');


			-- ----------------------------
			@@ -212,9 +221,10 @@
			status char default '0'::bpchar,
			perms varchar(100) default null::varchar,
			icon varchar(100) default '#'::varchar,
			create_by varchar(64) default ''::varchar,
			create_dept int8,
			create_by int8,
			create_time timestamp,
			update_by varchar(64) default ''::varchar,
			update_by int8,
			update_time timestamp,
			remark varchar(500) default ''::varchar,
			constraint "sys_menu_pk" primary key (menu_id)
			@@ -235,6 +245,7 @@
			comment on column sys_menu.status is 'èåç¶æï¼0æ£å¸¸ 1åç¨ï¼';
			comment on column sys_menu.perms is 'æéæ è¯';
			comment on column sys_menu.icon is 'èåå¾æ ';
			comment on column sys_menu.create_dept is 'åå»ºé¨é¨';
			comment on column sys_menu.create_by is 'åå»ºè';
			comment on column sys_menu.create_time is 'åå»ºæ¶é´';
			comment on column sys_menu.update_by is 'æ´æ°è';
			@@ -245,109 +256,109 @@
			-- åå§å-èåä¿¡æ¯è¡¨æ°æ®
			-- ----------------------------
			-- ä¸çº§èå
			insert into sys_menu values('1', 'ç³»ç»ç®¡ç', '0', '1', 'system', null, '', '1', '0', 'M', '0', '0', '', 'system', 'admin', now(), '', null, 'ç³»ç»ç®¡çç®å½');
			insert into sys_menu values('2', 'ç³»ç»çæ§', '0', '2', 'monitor', null, '', '1', '0', 'M', '0', '0', '', 'monitor', 'admin', now(), '', null, 'ç³»ç»çæ§ç®å½');
			insert into sys_menu values('3', 'ç³»ç»å·¥å·', '0', '3', 'tool', null, '', '1', '0', 'M', '0', '0', '', 'tool', 'admin', now(), '', 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', now(), '', null, 'RuoYi-Vue-Pluså®ç½å°å');
			insert into sys_menu values('1', 'ç³»ç»ç®¡ç', '0', '1', 'system', null, '', '1', '0', 'M', '0', '0', '', 'system', 103, 1, now(), null, null, 'ç³»ç»ç®¡çç®å½');
			insert into sys_menu values('2', 'ç³»ç»çæ§', '0', '2', 'monitor', null, '', '1', '0', 'M', '0', '0', '', 'monitor', 103, 1, now(), null, null, 'ç³»ç»çæ§ç®å½');
			insert into sys_menu values('3', 'ç³»ç»å·¥å·', '0', '3', 'tool', null, '', '1', '0', 'M', '0', '0', '', 'tool', 103, 1, now(), 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, now(), null, null, 'RuoYi-Vue-Pluså®ç½å°å');
			-- äºçº§èå
			insert into sys_menu values('100', 'ç¨æ·ç®¡ç', '1', '1', 'user', 'system/user/index', '', '1', '0', 'C', '0', '0', 'system:user:list', 'user', 'admin', now(), '', null, 'ç¨æ·ç®¡çèå');
			insert into sys_menu values('101', 'è§è²ç®¡ç', '1', '2', 'role', 'system/role/index', '', '1', '0', 'C', '0', '0', 'system:role:list', 'peoples', 'admin', now(), '', null, 'è§è²ç®¡çèå');
			insert into sys_menu values('102', 'èåç®¡ç', '1', '3', 'menu', 'system/menu/index', '', '1', '0', 'C', '0', '0', 'system:menu:list', 'tree-table', 'admin', now(), '', null, 'èåç®¡çèå');
			insert into sys_menu values('103', 'é¨é¨ç®¡ç', '1', '4', 'dept', 'system/dept/index', '', '1', '0', 'C', '0', '0', 'system:dept:list', 'tree', 'admin', now(), '', null, 'é¨é¨ç®¡çèå');
			insert into sys_menu values('104', 'å²ä½ç®¡ç', '1', '5', 'post', 'system/post/index', '', '1', '0', 'C', '0', '0', 'system:post:list', 'post', 'admin', now(), '', null, 'å²ä½ç®¡çèå');
			insert into sys_menu values('105', 'åå¸ç®¡ç', '1', '6', 'dict', 'system/dict/index', '', '1', '0', 'C', '0', '0', 'system:dict:list', 'dict', 'admin', now(), '', null, 'åå¸ç®¡çèå');
			insert into sys_menu values('106', 'åæ°è®¾ç½®', '1', '7', 'config', 'system/config/index', '', '1', '0', 'C', '0', '0', 'system:config:list', 'edit', 'admin', now(), '', null, 'åæ°è®¾ç½®èå');
			insert into sys_menu values('107', 'éç¥å¬å', '1', '8', 'notice', 'system/notice/index', '', '1', '0', 'C', '0', '0', 'system:notice:list', 'message', 'admin', now(), '', null, 'éç¥å¬åèå');
			insert into sys_menu values('108', 'æ¥å¿ç®¡ç', '1', '9', 'log', '', '', '1', '0', 'M', '0', '0', '', 'log', 'admin', now(), '', null, 'æ¥å¿ç®¡çèå');
			insert into sys_menu values('109', 'å¨çº¿ç¨æ·', '2', '1', 'online', 'monitor/online/index', '', '1', '0', 'C', '0', '0', 'monitor:online:list', 'online', 'admin', now(), '', null, 'å¨çº¿ç¨æ·èå');
			insert into sys_menu values('112', 'ç¼ååè¡¨', '2', '6', 'cacheList', 'monitor/cache/list', '', '1', '0', 'C', '0', '0', 'monitor:cache:list', 'redis-list', 'admin', now(), '', null, 'ç¼ååè¡¨èå');
			insert into sys_menu values('113', 'ç¼åçæ§', '2', '5', 'cache', 'monitor/cache/index', '', '1', '0', 'C', '0', '0', 'monitor:cache:list', 'redis', 'admin', now(), '', null, 'ç¼åçæ§èå');
			insert into sys_menu values('114', 'è¡¨åæå»º', '3', '1', 'build', 'tool/build/index', '', '1', '0', 'C', '0', '0', 'tool:build:list', 'build', 'admin', now(), '', null, 'è¡¨åæå»ºèå');
			insert into sys_menu values('115', 'ä»£ç çæ', '3', '2', 'gen', 'tool/gen/index', '', '1', '0', 'C', '0', '0', 'tool:gen:list', 'code', 'admin', now(), '', null, 'ä»£ç çæèå');
			insert into sys_menu values('100', 'ç¨æ·ç®¡ç', '1', '1', 'user', 'system/user/index', '', '1', '0', 'C', '0', '0', 'system:user:list', 'user', 103, 1, now(), null, null, 'ç¨æ·ç®¡çèå');
			insert into sys_menu values('101', 'è§è²ç®¡ç', '1', '2', 'role', 'system/role/index', '', '1', '0', 'C', '0', '0', 'system:role:list', 'peoples', 103, 1, now(), null, null, 'è§è²ç®¡çèå');
			insert into sys_menu values('102', 'èåç®¡ç', '1', '3', 'menu', 'system/menu/index', '', '1', '0', 'C', '0', '0', 'system:menu:list', 'tree-table', 103, 1, now(), 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, now(), 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, now(), 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, now(), 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, now(), 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, now(), null, null, 'éç¥å¬åèå');
			insert into sys_menu values('108', 'æ¥å¿ç®¡ç', '1', '9', 'log', '', '', '1', '0', 'M', '0', '0', '', 'log', 103, 1, now(), 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, now(), 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, now(), 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, now(), 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, now(), 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, now(), 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', now(), '', null, 'Adminçæ§èå');
			insert into sys_menu values('117', 'Adminçæ§', '2', '5', 'Admin', 'monitor/admin/index', '', '1', '0', 'C', '0', '0', 'monitor:admin:list', 'dashboard', 103, 1, now(), 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', now(), '', null, 'æä»¶ç®¡çèå');
			insert into sys_menu values('118', 'æä»¶ç®¡ç', '1', '10', 'oss', 'system/oss/index', '', '1', '0', 'C', '0', '0', 'system:oss:list', 'upload', 103, 1, now(), 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', now(), '', 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, now(), 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', now(), '', null, 'æä½æ¥å¿èå');
			insert into sys_menu values('501', 'ç»å½æ¥å¿', '108', '2', 'logininfor', 'monitor/logininfor/index', '', '1', '0', 'C', '0', '0', 'monitor:logininfor:list', 'logininfor', 'admin', now(), '', null, 'ç»å½æ¥å¿èå');
			insert into sys_menu values('500', 'æä½æ¥å¿', '108', '1', 'operlog', 'monitor/operlog/index', '', '1', '0', 'C', '0', '0', 'monitor:operlog:list', 'form', 103, 1, now(), 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, now(), null, null, 'ç»å½æ¥å¿èå');
			-- ç¨æ·ç®¡çæé®
			insert into sys_menu values('1001', 'ç¨æ·æ¥è¯¢', '100', '1', '', '', '', '1', '0', 'F', '0', '0', 'system:user:query', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1002', 'ç¨æ·æ°å¢', '100', '2', '', '', '', '1', '0', 'F', '0', '0', 'system:user:add', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1003', 'ç¨æ·ä¿®æ¹', '100', '3', '', '', '', '1', '0', 'F', '0', '0', 'system:user:edit', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1004', 'ç¨æ·å é¤', '100', '4', '', '', '', '1', '0', 'F', '0', '0', 'system:user:remove', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1005', 'ç¨æ·å¯¼åº', '100', '5', '', '', '', '1', '0', 'F', '0', '0', 'system:user:export', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1006', 'ç¨æ·å¯¼å¥', '100', '6', '', '', '', '1', '0', 'F', '0', '0', 'system:user:import', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1007', 'éç½®å¯ç ', '100', '7', '', '', '', '1', '0', 'F', '0', '0', 'system:user:resetPwd', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1001', 'ç¨æ·æ¥è¯¢', '100', '1', '', '', '', '1', '0', 'F', '0', '0', 'system:user:query', '#', 103, 1, now(), null, null, '');
			insert into sys_menu values('1002', 'ç¨æ·æ°å¢', '100', '2', '', '', '', '1', '0', 'F', '0', '0', 'system:user:add', '#', 103, 1, now(), null, null, '');
			insert into sys_menu values('1003', 'ç¨æ·ä¿®æ¹', '100', '3', '', '', '', '1', '0', 'F', '0', '0', 'system:user:edit', '#', 103, 1, now(), null, null, '');
			insert into sys_menu values('1004', 'ç¨æ·å é¤', '100', '4', '', '', '', '1', '0', 'F', '0', '0', 'system:user:remove', '#', 103, 1, now(), null, null, '');
			insert into sys_menu values('1005', 'ç¨æ·å¯¼åº', '100', '5', '', '', '', '1', '0', 'F', '0', '0', 'system:user:export', '#', 103, 1, now(), null, null, '');
			insert into sys_menu values('1006', 'ç¨æ·å¯¼å¥', '100', '6', '', '', '', '1', '0', 'F', '0', '0', 'system:user:import', '#', 103, 1, now(), null, null, '');
			insert into sys_menu values('1007', 'éç½®å¯ç ', '100', '7', '', '', '', '1', '0', 'F', '0', '0', 'system:user:resetPwd', '#', 103, 1, now(), null, null, '');
			-- è§è²ç®¡çæé®
			insert into sys_menu values('1008', 'è§è²æ¥è¯¢', '101', '1', '', '', '', '1', '0', 'F', '0', '0', 'system:role:query', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1009', 'è§è²æ°å¢', '101', '2', '', '', '', '1', '0', 'F', '0', '0', 'system:role:add', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1010', 'è§è²ä¿®æ¹', '101', '3', '', '', '', '1', '0', 'F', '0', '0', 'system:role:edit', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1011', 'è§è²å é¤', '101', '4', '', '', '', '1', '0', 'F', '0', '0', 'system:role:remove', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1012', 'è§è²å¯¼åº', '101', '5', '', '', '', '1', '0', 'F', '0', '0', 'system:role:export', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1008', 'è§è²æ¥è¯¢', '101', '1', '', '', '', '1', '0', 'F', '0', '0', 'system:role:query', '#', 103, 1, now(), null, null, '');
			insert into sys_menu values('1009', 'è§è²æ°å¢', '101', '2', '', '', '', '1', '0', 'F', '0', '0', 'system:role:add', '#', 103, 1, now(), null, null, '');
			insert into sys_menu values('1010', 'è§è²ä¿®æ¹', '101', '3', '', '', '', '1', '0', 'F', '0', '0', 'system:role:edit', '#', 103, 1, now(), null, null, '');
			insert into sys_menu values('1011', 'è§è²å é¤', '101', '4', '', '', '', '1', '0', 'F', '0', '0', 'system:role:remove', '#', 103, 1, now(), null, null, '');
			insert into sys_menu values('1012', 'è§è²å¯¼åº', '101', '5', '', '', '', '1', '0', 'F', '0', '0', 'system:role:export', '#', 103, 1, now(), null, null, '');
			-- èåç®¡çæé®
			insert into sys_menu values('1013', 'èåæ¥è¯¢', '102', '1', '', '', '', '1', '0', 'F', '0', '0', 'system:menu:query', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1014', 'èåæ°å¢', '102', '2', '', '', '', '1', '0', 'F', '0', '0', 'system:menu:add', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1015', 'èåä¿®æ¹', '102', '3', '', '', '', '1', '0', 'F', '0', '0', 'system:menu:edit', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1016', 'èåå é¤', '102', '4', '', '', '', '1', '0', 'F', '0', '0', 'system:menu:remove', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1013', 'èåæ¥è¯¢', '102', '1', '', '', '', '1', '0', 'F', '0', '0', 'system:menu:query', '#', 103, 1, now(), null, null, '');
			insert into sys_menu values('1014', 'èåæ°å¢', '102', '2', '', '', '', '1', '0', 'F', '0', '0', 'system:menu:add', '#', 103, 1, now(), null, null, '');
			insert into sys_menu values('1015', 'èåä¿®æ¹', '102', '3', '', '', '', '1', '0', 'F', '0', '0', 'system:menu:edit', '#', 103, 1, now(), null, null, '');
			insert into sys_menu values('1016', 'èåå é¤', '102', '4', '', '', '', '1', '0', 'F', '0', '0', 'system:menu:remove', '#', 103, 1, now(), null, null, '');
			-- é¨é¨ç®¡çæé®
			insert into sys_menu values('1017', 'é¨é¨æ¥è¯¢', '103', '1', '', '', '', '1', '0', 'F', '0', '0', 'system:dept:query', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1018', 'é¨é¨æ°å¢', '103', '2', '', '', '', '1', '0', 'F', '0', '0', 'system:dept:add', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1019', 'é¨é¨ä¿®æ¹', '103', '3', '', '', '', '1', '0', 'F', '0', '0', 'system:dept:edit', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1020', 'é¨é¨å é¤', '103', '4', '', '', '', '1', '0', 'F', '0', '0', 'system:dept:remove', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1017', 'é¨é¨æ¥è¯¢', '103', '1', '', '', '', '1', '0', 'F', '0', '0', 'system:dept:query', '#', 103, 1, now(), null, null, '');
			insert into sys_menu values('1018', 'é¨é¨æ°å¢', '103', '2', '', '', '', '1', '0', 'F', '0', '0', 'system:dept:add', '#', 103, 1, now(), null, null, '');
			insert into sys_menu values('1019', 'é¨é¨ä¿®æ¹', '103', '3', '', '', '', '1', '0', 'F', '0', '0', 'system:dept:edit', '#', 103, 1, now(), null, null, '');
			insert into sys_menu values('1020', 'é¨é¨å é¤', '103', '4', '', '', '', '1', '0', 'F', '0', '0', 'system:dept:remove', '#', 103, 1, now(), null, null, '');
			-- å²ä½ç®¡çæé®
			insert into sys_menu values('1021', 'å²ä½æ¥è¯¢', '104', '1', '', '', '', '1', '0', 'F', '0', '0', 'system:post:query', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1022', 'å²ä½æ°å¢', '104', '2', '', '', '', '1', '0', 'F', '0', '0', 'system:post:add', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1023', 'å²ä½ä¿®æ¹', '104', '3', '', '', '', '1', '0', 'F', '0', '0', 'system:post:edit', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1024', 'å²ä½å é¤', '104', '4', '', '', '', '1', '0', 'F', '0', '0', 'system:post:remove', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1025', 'å²ä½å¯¼åº', '104', '5', '', '', '', '1', '0', 'F', '0', '0', 'system:post:export', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1021', 'å²ä½æ¥è¯¢', '104', '1', '', '', '', '1', '0', 'F', '0', '0', 'system:post:query', '#', 103, 1, now(), null, null, '');
			insert into sys_menu values('1022', 'å²ä½æ°å¢', '104', '2', '', '', '', '1', '0', 'F', '0', '0', 'system:post:add', '#', 103, 1, now(), null, null, '');
			insert into sys_menu values('1023', 'å²ä½ä¿®æ¹', '104', '3', '', '', '', '1', '0', 'F', '0', '0', 'system:post:edit', '#', 103, 1, now(), null, null, '');
			insert into sys_menu values('1024', 'å²ä½å é¤', '104', '4', '', '', '', '1', '0', 'F', '0', '0', 'system:post:remove', '#', 103, 1, now(), null, null, '');
			insert into sys_menu values('1025', 'å²ä½å¯¼åº', '104', '5', '', '', '', '1', '0', 'F', '0', '0', 'system:post:export', '#', 103, 1, now(), null, null, '');
			-- åå¸ç®¡çæé®
			insert into sys_menu values('1026', 'åå¸æ¥è¯¢', '105', '1', '#', '', '', '1', '0', 'F', '0', '0', 'system:dict:query', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1027', 'åå¸æ°å¢', '105', '2', '#', '', '', '1', '0', 'F', '0', '0', 'system:dict:add', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1028', 'åå¸ä¿®æ¹', '105', '3', '#', '', '', '1', '0', 'F', '0', '0', 'system:dict:edit', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1029', 'åå¸å é¤', '105', '4', '#', '', '', '1', '0', 'F', '0', '0', 'system:dict:remove', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1030', 'åå¸å¯¼åº', '105', '5', '#', '', '', '1', '0', 'F', '0', '0', 'system:dict:export', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1026', 'åå¸æ¥è¯¢', '105', '1', '#', '', '', '1', '0', 'F', '0', '0', 'system:dict:query', '#', 103, 1, now(), null, null, '');
			insert into sys_menu values('1027', 'åå¸æ°å¢', '105', '2', '#', '', '', '1', '0', 'F', '0', '0', 'system:dict:add', '#', 103, 1, now(), null, null, '');
			insert into sys_menu values('1028', 'åå¸ä¿®æ¹', '105', '3', '#', '', '', '1', '0', 'F', '0', '0', 'system:dict:edit', '#', 103, 1, now(), null, null, '');
			insert into sys_menu values('1029', 'åå¸å é¤', '105', '4', '#', '', '', '1', '0', 'F', '0', '0', 'system:dict:remove', '#', 103, 1, now(), null, null, '');
			insert into sys_menu values('1030', 'åå¸å¯¼åº', '105', '5', '#', '', '', '1', '0', 'F', '0', '0', 'system:dict:export', '#', 103, 1, now(), null, null, '');
			-- åæ°è®¾ç½®æé®
			insert into sys_menu values('1031', 'åæ°æ¥è¯¢', '106', '1', '#', '', '', '1', '0', 'F', '0', '0', 'system:config:query', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1032', 'åæ°æ°å¢', '106', '2', '#', '', '', '1', '0', 'F', '0', '0', 'system:config:add', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1033', 'åæ°ä¿®æ¹', '106', '3', '#', '', '', '1', '0', 'F', '0', '0', 'system:config:edit', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1034', 'åæ°å é¤', '106', '4', '#', '', '', '1', '0', 'F', '0', '0', 'system:config:remove', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1035', 'åæ°å¯¼åº', '106', '5', '#', '', '', '1', '0', 'F', '0', '0', 'system:config:export', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1031', 'åæ°æ¥è¯¢', '106', '1', '#', '', '', '1', '0', 'F', '0', '0', 'system:config:query', '#', 103, 1, now(), null, null, '');
			insert into sys_menu values('1032', 'åæ°æ°å¢', '106', '2', '#', '', '', '1', '0', 'F', '0', '0', 'system:config:add', '#', 103, 1, now(), null, null, '');
			insert into sys_menu values('1033', 'åæ°ä¿®æ¹', '106', '3', '#', '', '', '1', '0', 'F', '0', '0', 'system:config:edit', '#', 103, 1, now(), null, null, '');
			insert into sys_menu values('1034', 'åæ°å é¤', '106', '4', '#', '', '', '1', '0', 'F', '0', '0', 'system:config:remove', '#', 103, 1, now(), null, null, '');
			insert into sys_menu values('1035', 'åæ°å¯¼åº', '106', '5', '#', '', '', '1', '0', 'F', '0', '0', 'system:config:export', '#', 103, 1, now(), null, null, '');
			-- éç¥å¬åæé®
			insert into sys_menu values('1036', 'å¬åæ¥è¯¢', '107', '1', '#', '', '', '1', '0', 'F', '0', '0', 'system:notice:query', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1037', 'å¬åæ°å¢', '107', '2', '#', '', '', '1', '0', 'F', '0', '0', 'system:notice:add', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1038', 'å¬åä¿®æ¹', '107', '3', '#', '', '', '1', '0', 'F', '0', '0', 'system:notice:edit', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1039', 'å¬åå é¤', '107', '4', '#', '', '', '1', '0', 'F', '0', '0', 'system:notice:remove', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1036', 'å¬åæ¥è¯¢', '107', '1', '#', '', '', '1', '0', 'F', '0', '0', 'system:notice:query', '#', 103, 1, now(), null, null, '');
			insert into sys_menu values('1037', 'å¬åæ°å¢', '107', '2', '#', '', '', '1', '0', 'F', '0', '0', 'system:notice:add', '#', 103, 1, now(), null, null, '');
			insert into sys_menu values('1038', 'å¬åä¿®æ¹', '107', '3', '#', '', '', '1', '0', 'F', '0', '0', 'system:notice:edit', '#', 103, 1, now(), null, null, '');
			insert into sys_menu values('1039', 'å¬åå é¤', '107', '4', '#', '', '', '1', '0', 'F', '0', '0', 'system:notice:remove', '#', 103, 1, now(), null, null, '');
			-- æä½æ¥å¿æé®
			insert into sys_menu values('1040', 'æä½æ¥è¯¢', '500', '1', '#', '', '', '1', '0', 'F', '0', '0', 'monitor:operlog:query', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1041', 'æä½å é¤', '500', '2', '#', '', '', '1', '0', 'F', '0', '0', 'monitor:operlog:remove', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1042', 'æ¥å¿å¯¼åº', '500', '4', '#', '', '', '1', '0', 'F', '0', '0', 'monitor:operlog:export', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1040', 'æä½æ¥è¯¢', '500', '1', '#', '', '', '1', '0', 'F', '0', '0', 'monitor:operlog:query', '#', 103, 1, now(), null, null, '');
			insert into sys_menu values('1041', 'æä½å é¤', '500', '2', '#', '', '', '1', '0', 'F', '0', '0', 'monitor:operlog:remove', '#', 103, 1, now(), null, null, '');
			insert into sys_menu values('1042', 'æ¥å¿å¯¼åº', '500', '4', '#', '', '', '1', '0', 'F', '0', '0', 'monitor:operlog:export', '#', 103, 1, now(), null, null, '');
			-- ç»å½æ¥å¿æé®
			insert into sys_menu values('1043', 'ç»å½æ¥è¯¢', '501', '1', '#', '', '', '1', '0', 'F', '0', '0', 'monitor:logininfor:query', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1044', 'ç»å½å é¤', '501', '2', '#', '', '', '1', '0', 'F', '0', '0', 'monitor:logininfor:remove', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1045', 'æ¥å¿å¯¼åº', '501', '3', '#', '', '', '1', '0', 'F', '0', '0', 'monitor:logininfor:export', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1050', 'è´¦æ·è§£é', '501', '4', '#', '', '', '1', '0', 'F', '0', '0', 'monitor:logininfor:unlock', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1043', 'ç»å½æ¥è¯¢', '501', '1', '#', '', '', '1', '0', 'F', '0', '0', 'monitor:logininfor:query', '#', 103, 1, now(), null, null, '');
			insert into sys_menu values('1044', 'ç»å½å é¤', '501', '2', '#', '', '', '1', '0', 'F', '0', '0', 'monitor:logininfor:remove', '#', 103, 1, now(), null, null, '');
			insert into sys_menu values('1045', 'æ¥å¿å¯¼åº', '501', '3', '#', '', '', '1', '0', 'F', '0', '0', 'monitor:logininfor:export', '#', 103, 1, now(), null, null, '');
			insert into sys_menu values('1050', 'è´¦æ·è§£é', '501', '4', '#', '', '', '1', '0', 'F', '0', '0', 'monitor:logininfor:unlock', '#', 103, 1, now(), null, null, '');
			-- å¨çº¿ç¨æ·æé®
			insert into sys_menu values('1046', 'å¨çº¿æ¥è¯¢', '109', '1', '#', '', '', '1', '0', 'F', '0', '0', 'monitor:online:query', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1047', 'æ¹éå¼ºé', '109', '2', '#', '', '', '1', '0', 'F', '0', '0', 'monitor:online:batchLogout', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1048', 'åæ¡å¼ºé', '109', '3', '#', '', '', '1', '0', 'F', '0', '0', 'monitor:online:forceLogout', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1046', 'å¨çº¿æ¥è¯¢', '109', '1', '#', '', '', '1', '0', 'F', '0', '0', 'monitor:online:query', '#', 103, 1, now(), null, null, '');
			insert into sys_menu values('1047', 'æ¹éå¼ºé', '109', '2', '#', '', '', '1', '0', 'F', '0', '0', 'monitor:online:batchLogout', '#', 103, 1, now(), null, null, '');
			insert into sys_menu values('1048', 'åæ¡å¼ºé', '109', '3', '#', '', '', '1', '0', 'F', '0', '0', 'monitor:online:forceLogout', '#', 103, 1, now(), null, null, '');
			-- ä»£ç çææé®
			insert into sys_menu values('1055', 'çææ¥è¯¢', '115', '1', '#', '', '', '1', '0', 'F', '0', '0', 'tool:gen:query', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1056', 'çæä¿®æ¹', '115', '2', '#', '', '', '1', '0', 'F', '0', '0', 'tool:gen:edit', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1057', 'çæå é¤', '115', '3', '#', '', '', '1', '0', 'F', '0', '0', 'tool:gen:remove', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1058', 'å¯¼å¥ä»£ç ', '115', '2', '#', '', '', '1', '0', 'F', '0', '0', 'tool:gen:import', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1059', 'é¢è§ä»£ç ', '115', '4', '#', '', '', '1', '0', 'F', '0', '0', 'tool:gen:preview', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1060', 'çæä»£ç ', '115', '5', '#', '', '', '1', '0', 'F', '0', '0', 'tool:gen:code', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1055', 'çææ¥è¯¢', '115', '1', '#', '', '', '1', '0', 'F', '0', '0', 'tool:gen:query', '#', 103, 1, now(), null, null, '');
			insert into sys_menu values('1056', 'çæä¿®æ¹', '115', '2', '#', '', '', '1', '0', 'F', '0', '0', 'tool:gen:edit', '#', 103, 1, now(), null, null, '');
			insert into sys_menu values('1057', 'çæå é¤', '115', '3', '#', '', '', '1', '0', 'F', '0', '0', 'tool:gen:remove', '#', 103, 1, now(), null, null, '');
			insert into sys_menu values('1058', 'å¯¼å¥ä»£ç ', '115', '2', '#', '', '', '1', '0', 'F', '0', '0', 'tool:gen:import', '#', 103, 1, now(), null, null, '');
			insert into sys_menu values('1059', 'é¢è§ä»£ç ', '115', '4', '#', '', '', '1', '0', 'F', '0', '0', 'tool:gen:preview', '#', 103, 1, now(), null, null, '');
			insert into sys_menu values('1060', 'çæä»£ç ', '115', '5', '#', '', '', '1', '0', 'F', '0', '0', 'tool:gen:code', '#', 103, 1, now(), null, null, '');
			-- ossç¸å³æé®
			insert into sys_menu values('1600', 'æä»¶æ¥è¯¢', '118', '1', '#', '', '', '1', '0', 'F', '0', '0', 'system:oss:query', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1601', 'æä»¶ä¸ä¼ ', '118', '2', '#', '', '', '1', '0', 'F', '0', '0', 'system:oss:upload', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1602', 'æä»¶ä¸è½½', '118', '3', '#', '', '', '1', '0', 'F', '0', '0', 'system:oss:download', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1603', 'æä»¶å é¤', '118', '4', '#', '', '', '1', '0', 'F', '0', '0', 'system:oss:remove', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1604', 'éç½®æ·»å ', '118', '5', '#', '', '', '1', '0', 'F', '0', '0', 'system:oss:add', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1605', 'éç½®ç¼è¾', '118', '6', '#', '', '', '1', '0', 'F', '0', '0', 'system:oss:edit', '#', 'admin', now(), '', null, '');
			insert into sys_menu values('1600', 'æä»¶æ¥è¯¢', '118', '1', '#', '', '', '1', '0', 'F', '0', '0', 'system:oss:query', '#', 103, 1, now(), null, null, '');
			insert into sys_menu values('1601', 'æä»¶ä¸ä¼ ', '118', '2', '#', '', '', '1', '0', 'F', '0', '0', 'system:oss:upload', '#', 103, 1, now(), null, null, '');
			insert into sys_menu values('1602', 'æä»¶ä¸è½½', '118', '3', '#', '', '', '1', '0', 'F', '0', '0', 'system:oss:download', '#', 103, 1, now(), null, null, '');
			insert into sys_menu values('1603', 'æä»¶å é¤', '118', '4', '#', '', '', '1', '0', 'F', '0', '0', 'system:oss:remove', '#', 103, 1, now(), null, null, '');
			insert into sys_menu values('1604', 'éç½®æ·»å ', '118', '5', '#', '', '', '1', '0', 'F', '0', '0', 'system:oss:add', '#', 103, 1, now(), null, null, '');
			insert into sys_menu values('1605', 'éç½®ç¼è¾', '118', '6', '#', '', '', '1', '0', 'F', '0', '0', 'system:oss:edit', '#', 103, 1, now(), null, null, '');


			-- ----------------------------
			@@ -568,9 +579,10 @@
			dict_name varchar(100) default ''::varchar,
			dict_type varchar(100) default ''::varchar,
			status char default '0'::bpchar,
			create_by varchar(64) default ''::varchar,
			create_dept int8,
			create_by int8,
			create_time timestamp,
			update_by varchar(64) default ''::varchar,
			update_by int8,
			update_time timestamp,
			remark varchar(500) default null::varchar,
			constraint sys_dict_type_pk primary key (dict_id)
			@@ -581,20 +593,21 @@
			comment on column sys_dict_type.dict_name is 'åå¸åç§°';
			comment on column sys_dict_type.dict_type is 'åå¸ç±»å';
			comment on column sys_dict_type.status is 'ç¶æï¼0æ£å¸¸ 1åç¨ï¼';
			comment on column sys_dict_type.create_dept is 'åå»ºé¨é¨';
			comment on column sys_dict_type.create_by is 'åå»ºè';
			comment on column sys_dict_type.create_time is 'åå»ºæ¶é´';
			comment on column sys_dict_type.update_by is 'æ´æ°è';
			comment on column sys_dict_type.update_time is 'æ´æ°æ¶é´';
			comment on column sys_dict_type.remark is 'å¤æ³¨';

			insert into sys_dict_type values(1, 'ç¨æ·æ§å«', 'sys_user_sex', '0', 'admin', now(), '', null, 'ç¨æ·æ§å«åè¡¨');
			insert into sys_dict_type values(2, 'èåç¶æ', 'sys_show_hide', '0', 'admin', now(), '', null, 'èåç¶æåè¡¨');
			insert into sys_dict_type values(3, 'ç³»ç»å¼å³', 'sys_normal_disable', '0', 'admin', now(), '', null, 'ç³»ç»å¼å³åè¡¨');
			insert into sys_dict_type values(6, 'ç³»ç»æ¯å¦', 'sys_yes_no', '0', 'admin', now(), '', null, 'ç³»ç»æ¯å¦åè¡¨');
			insert into sys_dict_type values(7, 'éç¥ç±»å', 'sys_notice_type', '0', 'admin', now(), '', null, 'éç¥ç±»ååè¡¨');
			insert into sys_dict_type values(8, 'éç¥ç¶æ', 'sys_notice_status', '0', 'admin', now(), '', null, 'éç¥ç¶æåè¡¨');
			insert into sys_dict_type values(9, 'æä½ç±»å', 'sys_oper_type', '0', 'admin', now(), '', null, 'æä½ç±»ååè¡¨');
			insert into sys_dict_type values(10, 'ç³»ç»ç¶æ', 'sys_common_status', '0', 'admin', now(), '', null, 'ç»å½ç¶æåè¡¨');
			insert into sys_dict_type values(1, 'ç¨æ·æ§å«', 'sys_user_sex', '0', 103, 1, now(), null, null, 'ç¨æ·æ§å«åè¡¨');
			insert into sys_dict_type values(2, 'èåç¶æ', 'sys_show_hide', '0', 103, 1, now(), null, null, 'èåç¶æåè¡¨');
			insert into sys_dict_type values(3, 'ç³»ç»å¼å³', 'sys_normal_disable', '0', 103, 1, now(), null, null, 'ç³»ç»å¼å³åè¡¨');
			insert into sys_dict_type values(6, 'ç³»ç»æ¯å¦', 'sys_yes_no', '0', 103, 1, now(), null, null, 'ç³»ç»æ¯å¦åè¡¨');
			insert into sys_dict_type values(7, 'éç¥ç±»å', 'sys_notice_type', '0', 103, 1, now(), null, null, 'éç¥ç±»ååè¡¨');
			insert into sys_dict_type values(8, 'éç¥ç¶æ', 'sys_notice_status', '0', 103, 1, now(), null, null, 'éç¥ç¶æåè¡¨');
			insert into sys_dict_type values(9, 'æä½ç±»å', 'sys_oper_type', '0', 103, 1, now(), null, null, 'æä½ç±»ååè¡¨');
			insert into sys_dict_type values(10, 'ç³»ç»ç¶æ', 'sys_common_status', '0', 103, 1, now(), null, null, 'ç»å½ç¶æåè¡¨');


			-- ----------------------------
			@@ -612,9 +625,10 @@
			list_class varchar(100) default null::varchar,
			is_default char default 'N'::bpchar,
			status char default '0'::bpchar,
			create_by varchar(64) default ''::varchar,
			create_dept int8,
			create_by int8,
			create_time timestamp,
			update_by varchar(64) default ''::varchar,
			update_by int8,
			update_time timestamp,
			remark varchar(500) default null::varchar,
			constraint sys_dict_data_pk primary key (dict_code)
			@@ -630,37 +644,38 @@
			comment on column sys_dict_data.list_class is 'è¡¨æ ¼åæ¾æ ·å¼';
			comment on column sys_dict_data.is_default is 'æ¯å¦é»è®¤ï¼Yæ¯ Nå¦ï¼';
			comment on column sys_dict_data.status is 'ç¶æï¼0æ£å¸¸ 1åç¨ï¼';
			comment on column sys_dict_data.create_dept is 'åå»ºé¨é¨';
			comment on column sys_dict_data.create_by is 'åå»ºè';
			comment on column sys_dict_data.create_time is 'åå»ºæ¶é´';
			comment on column sys_dict_data.update_by is 'æ´æ°è';
			comment on column sys_dict_data.update_time is 'æ´æ°æ¶é´';
			comment on column sys_dict_data.remark is 'å¤æ³¨';

			insert into sys_dict_data values(1, 1, 'ç·', '0', 'sys_user_sex', '', '', 'Y', '0', 'admin', now(), '', null, 'æ§å«ç·');
			insert into sys_dict_data values(2, 2, 'å¥³', '1', 'sys_user_sex', '', '', 'N', '0', 'admin', now(), '', null, 'æ§å«å¥³');
			insert into sys_dict_data values(3, 3, 'æªç¥', '2', 'sys_user_sex', '', '', 'N', '0', 'admin', now(), '', null, 'æ§å«æªç¥');
			insert into sys_dict_data values(4, 1, 'æ¾ç¤º', '0', 'sys_show_hide', '', 'primary', 'Y', '0', 'admin', now(), '', null, 'æ¾ç¤ºèå');
			insert into sys_dict_data values(5, 2, 'éè', '1', 'sys_show_hide', '', 'danger', 'N', '0', 'admin', now(), '', null, 'éèèå');
			insert into sys_dict_data values(6, 1, 'æ£å¸¸', '0', 'sys_normal_disable', '', 'primary', 'Y', '0', 'admin', now(), '', null, 'æ£å¸¸ç¶æ');
			insert into sys_dict_data values(7, 2, 'åç¨', '1', 'sys_normal_disable', '', 'danger', 'N', '0', 'admin', now(), '', null, 'åç¨ç¶æ');
			insert into sys_dict_data values(12, 1, 'æ¯', 'Y', 'sys_yes_no', '', 'primary', 'Y', '0', 'admin', now(), '', null, 'ç³»ç»é»è®¤æ¯');
			insert into sys_dict_data values(13, 2, 'å¦', 'N', 'sys_yes_no', '', 'danger', 'N', '0', 'admin', now(), '', null, 'ç³»ç»é»è®¤å¦');
			insert into sys_dict_data values(14, 1, 'éç¥', '1', 'sys_notice_type', '', 'warning', 'Y', '0', 'admin', now(), '', null, 'éç¥');
			insert into sys_dict_data values(15, 2, 'å¬å', '2', 'sys_notice_type', '', 'success', 'N', '0', 'admin', now(), '', null, 'å¬å');
			insert into sys_dict_data values(16, 1, 'æ£å¸¸', '0', 'sys_notice_status', '', 'primary', 'Y', '0', 'admin', now(), '', null, 'æ£å¸¸ç¶æ');
			insert into sys_dict_data values(17, 2, 'å³é', '1', 'sys_notice_status', '', 'danger', 'N', '0', 'admin', now(), '', null, 'å³éç¶æ');
			insert into sys_dict_data values(29, 99, 'å¶ä»', '0', 'sys_oper_type', '', 'info', 'N', '0', 'admin', now(), '', null, 'å¶ä»æä½');
			insert into sys_dict_data values(18, 1, 'æ°å¢', '1', 'sys_oper_type', '', 'info', 'N', '0', 'admin', now(), '', null, 'æ°å¢æä½');
			insert into sys_dict_data values(19, 2, 'ä¿®æ¹', '2', 'sys_oper_type', '', 'info', 'N', '0', 'admin', now(), '', null, 'ä¿®æ¹æä½');
			insert into sys_dict_data values(20, 3, 'å é¤', '3', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', now(), '', null, 'å é¤æä½');
			insert into sys_dict_data values(21, 4, 'ææ', '4', 'sys_oper_type', '', 'primary', 'N', '0', 'admin', now(), '', null, 'æææä½');
			insert into sys_dict_data values(22, 5, 'å¯¼åº', '5', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', now(), '', null, 'å¯¼åºæä½');
			insert into sys_dict_data values(23, 6, 'å¯¼å¥', '6', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', now(), '', null, 'å¯¼å¥æä½');
			insert into sys_dict_data values(24, 7, 'å¼ºé', '7', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', now(), '', null, 'å¼ºéæä½');
			insert into sys_dict_data values(25, 8, 'çæä»£ç ', '8', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', now(), '', null, 'çææä½');
			insert into sys_dict_data values(26, 9, 'æ¸ç©ºæ°æ®', '9', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', now(), '', null, 'æ¸ç©ºæä½');
			insert into sys_dict_data values(27, 1, 'æå', '0', 'sys_common_status', '', 'primary', 'N', '0', 'admin', now(), '', null, 'æ£å¸¸ç¶æ');
			insert into sys_dict_data values(28, 2, 'å¤±è´¥', '1', 'sys_common_status', '', 'danger', 'N', '0', 'admin', now(), '', null, 'åç¨ç¶æ');
			insert into sys_dict_data values(1, 1, 'ç·', '0', 'sys_user_sex', '', '', 'Y', '0', 103, 1, now(), null, null, 'æ§å«ç·');
			insert into sys_dict_data values(2, 2, 'å¥³', '1', 'sys_user_sex', '', '', 'N', '0', 103, 1, now(), null, null, 'æ§å«å¥³');
			insert into sys_dict_data values(3, 3, 'æªç¥', '2', 'sys_user_sex', '', '', 'N', '0', 103, 1, now(), null, null, 'æ§å«æªç¥');
			insert into sys_dict_data values(4, 1, 'æ¾ç¤º', '0', 'sys_show_hide', '', 'primary', 'Y', '0', 103, 1, now(), null, null, 'æ¾ç¤ºèå');
			insert into sys_dict_data values(5, 2, 'éè', '1', 'sys_show_hide', '', 'danger', 'N', '0', 103, 1, now(), null, null, 'éèèå');
			insert into sys_dict_data values(6, 1, 'æ£å¸¸', '0', 'sys_normal_disable', '', 'primary', 'Y', '0', 103, 1, now(), null, null, 'æ£å¸¸ç¶æ');
			insert into sys_dict_data values(7, 2, 'åç¨', '1', 'sys_normal_disable', '', 'danger', 'N', '0', 103, 1, now(), null, null, 'åç¨ç¶æ');
			insert into sys_dict_data values(12, 1, 'æ¯', 'Y', 'sys_yes_no', '', 'primary', 'Y', '0', 103, 1, now(), null, null, 'ç³»ç»é»è®¤æ¯');
			insert into sys_dict_data values(13, 2, 'å¦', 'N', 'sys_yes_no', '', 'danger', 'N', '0', 103, 1, now(), null, null, 'ç³»ç»é»è®¤å¦');
			insert into sys_dict_data values(14, 1, 'éç¥', '1', 'sys_notice_type', '', 'warning', 'Y', '0', 103, 1, now(), null, null, 'éç¥');
			insert into sys_dict_data values(15, 2, 'å¬å', '2', 'sys_notice_type', '', 'success', 'N', '0', 103, 1, now(), null, null, 'å¬å');
			insert into sys_dict_data values(16, 1, 'æ£å¸¸', '0', 'sys_notice_status', '', 'primary', 'Y', '0', 103, 1, now(), null, null, 'æ£å¸¸ç¶æ');
			insert into sys_dict_data values(17, 2, 'å³é', '1', 'sys_notice_status', '', 'danger', 'N', '0', 103, 1, now(), null, null, 'å³éç¶æ');
			insert into sys_dict_data values(29, 99, 'å¶ä»', '0', 'sys_oper_type', '', 'info', 'N', '0', 103, 1, now(), null, null, 'å¶ä»æä½');
			insert into sys_dict_data values(18, 1, 'æ°å¢', '1', 'sys_oper_type', '', 'info', 'N', '0', 103, 1, now(), null, null, 'æ°å¢æä½');
			insert into sys_dict_data values(19, 2, 'ä¿®æ¹', '2', 'sys_oper_type', '', 'info', 'N', '0', 103, 1, now(), null, null, 'ä¿®æ¹æä½');
			insert into sys_dict_data values(20, 3, 'å é¤', '3', 'sys_oper_type', '', 'danger', 'N', '0', 103, 1, now(), null, null, 'å é¤æä½');
			insert into sys_dict_data values(21, 4, 'ææ', '4', 'sys_oper_type', '', 'primary', 'N', '0', 103, 1, now(), null, null, 'æææä½');
			insert into sys_dict_data values(22, 5, 'å¯¼åº', '5', 'sys_oper_type', '', 'warning', 'N', '0', 103, 1, now(), null, null, 'å¯¼åºæä½');
			insert into sys_dict_data values(23, 6, 'å¯¼å¥', '6', 'sys_oper_type', '', 'warning', 'N', '0', 103, 1, now(), null, null, 'å¯¼å¥æä½');
			insert into sys_dict_data values(24, 7, 'å¼ºé', '7', 'sys_oper_type', '', 'danger', 'N', '0', 103, 1, now(), null, null, 'å¼ºéæä½');
			insert into sys_dict_data values(25, 8, 'çæä»£ç ', '8', 'sys_oper_type', '', 'warning', 'N', '0', 103, 1, now(), null, null, 'çææä½');
			insert into sys_dict_data values(26, 9, 'æ¸ç©ºæ°æ®', '9', 'sys_oper_type', '', 'danger', 'N', '0', 103, 1, now(), null, null, 'æ¸ç©ºæä½');
			insert into sys_dict_data values(27, 1, 'æå', '0', 'sys_common_status', '', 'primary', 'N', '0', 103, 1, now(), null, null, 'æ£å¸¸ç¶æ');
			insert into sys_dict_data values(28, 2, 'å¤±è´¥', '1', 'sys_common_status', '', 'danger', 'N', '0', 103, 1, now(), null, null, 'åç¨ç¶æ');


			-- ----------------------------
			@@ -674,9 +689,10 @@
			config_key varchar(100) default ''::varchar,
			config_value varchar(500) default ''::varchar,
			config_type char default 'N'::bpchar,
			create_by varchar(64) default ''::varchar,
			create_dept int8,
			create_by int8,
			create_time timestamp,
			update_by varchar(64) default ''::varchar,
			update_by int8,
			update_time timestamp,
			remark varchar(500) default null::varchar,
			constraint sys_config_pk primary key (config_id)
			@@ -688,18 +704,19 @@
			comment on column sys_config.config_key is 'åæ°é®å';
			comment on column sys_config.config_value is 'åæ°é®å¼';
			comment on column sys_config.config_type is 'ç³»ç»åç½®ï¼Yæ¯ Nå¦ï¼';
			comment on column sys_config.create_dept is 'åå»ºé¨é¨';
			comment on column sys_config.create_by is 'åå»ºè';
			comment on column sys_config.create_time is 'åå»ºæ¶é´';
			comment on column sys_config.update_by is 'æ´æ°è';
			comment on column sys_config.update_time is 'æ´æ°æ¶é´';
			comment on column sys_config.remark is 'å¤æ³¨';

			insert into sys_config values(1, 'ä¸»æ¡æ¶é¡µ-é»è®¤ç®è¤æ ·å¼åç§°', 'sys.index.skinName', 'skin-blue', 'Y', 'admin', now(), '', null, 'èè² skin-blueãç»¿è² skin-greenãç´«è² skin-purpleãçº¢è² skin-redãé»è² skin-yellow' );
			insert into sys_config values(2, 'ç¨æ·ç®¡ç-è´¦å·åå§å¯ç ', 'sys.user.initPassword', '123456', 'Y', 'admin', now(), '', null, 'åå§åå¯ç 123456' );
			insert into sys_config values(3, 'ä¸»æ¡æ¶é¡µ-ä¾§è¾¹æ ä¸»é¢', 'sys.index.sideTheme', 'theme-dark', 'Y', 'admin', now(), '', null, 'æ·±è²ä¸»é¢theme-darkï¼æµè²ä¸»é¢theme-light' );
			insert into sys_config values(4, 'è´¦å·èªå©-éªè¯ç å¼å³', 'sys.account.captchaEnabled', 'true', 'Y', 'admin', now(), '', null, 'æ¯å¦å¼å¯éªè¯ç åè½ï¼trueå¼å¯ï¼falseå³éï¼');
			insert into sys_config values(5, 'è´¦å·èªå©-æ¯å¦å¼å¯ç¨æ·æ³¨ååè½', 'sys.account.registerUser', 'false', 'Y', 'admin', now(), '', null, 'æ¯å¦å¼å¯æ³¨åç¨æ·åè½ï¼trueå¼å¯ï¼falseå³éï¼');
			insert into sys_config values(11, 'OSSé¢è§åè¡¨èµæºå¼å³', 'sys.oss.previewListResource', 'true', 'Y', 'admin', now(), '', null, 'true:å¼å¯, false:å³é');
			insert into sys_config values(1, 'ä¸»æ¡æ¶é¡µ-é»è®¤ç®è¤æ ·å¼åç§°', 'sys.index.skinName', 'skin-blue', 'Y', 103, 1, now(), 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, now(), null, null, 'åå§åå¯ç 123456' );
			insert into sys_config values(3, 'ä¸»æ¡æ¶é¡µ-ä¾§è¾¹æ ä¸»é¢', 'sys.index.sideTheme', 'theme-dark', 'Y', 103, 1, now(), null, null, 'æ·±è²ä¸»é¢theme-darkï¼æµè²ä¸»é¢theme-light' );
			insert into sys_config values(4, 'è´¦å·èªå©-éªè¯ç å¼å³', 'sys.account.captchaEnabled', 'true', 'Y', 103, 1, now(), null, null, 'æ¯å¦å¼å¯éªè¯ç åè½ï¼trueå¼å¯ï¼falseå³éï¼');
			insert into sys_config values(5, 'è´¦å·èªå©-æ¯å¦å¼å¯ç¨æ·æ³¨ååè½', 'sys.account.registerUser', 'false', 'Y', 103, 1, now(), null, null, 'æ¯å¦å¼å¯æ³¨åç¨æ·åè½ï¼trueå¼å¯ï¼falseå³éï¼');
			insert into sys_config values(11, 'OSSé¢è§åè¡¨èµæºå¼å³', 'sys.oss.previewListResource', 'true', 'Y', 103, 1, now(), null, null, 'true:å¼å¯, false:å³é');


			-- ----------------------------
			@@ -742,9 +759,10 @@
			notice_type char not null,
			notice_content text,
			status char default '0'::bpchar,
			create_by varchar(64) default ''::varchar,
			create_dept int8,
			create_by int8,
			create_time timestamp,
			update_by varchar(64) default ''::varchar,
			update_by int8,
			update_time timestamp,
			remark varchar(255) default null::varchar,
			constraint sys_notice_pk primary key (notice_id)
			@@ -756,6 +774,7 @@
			comment on column sys_notice.notice_type is 'å¬åç±»åï¼1éç¥ 2å¬åï¼';
			comment on column sys_notice.notice_content is 'å¬ååå®¹';
			comment on column sys_notice.status is 'å¬åç¶æï¼0æ£å¸¸ 1å³éï¼';
			comment on column sys_notice.create_dept is 'åå»ºé¨é¨';
			comment on column sys_notice.create_by is 'åå»ºè';
			comment on column sys_notice.create_time is 'åå»ºæ¶é´';
			comment on column sys_notice.update_by is 'æ´æ°è';
			@@ -765,8 +784,8 @@
			-- ----------------------------
			-- åå§å-å¬åä¿¡æ¯è¡¨æ°æ®
			-- ----------------------------
			insert into sys_notice values('1', 'æ¸©é¦¨æéï¼2018-07-01 æ°çæ¬åå¸å¦', '2', 'æ°çæ¬åå®¹', '0', 'admin', now(), '', null, 'ç®¡çå');
			insert into sys_notice values('2', 'ç»´æ¤éç¥ï¼2018-07-01 ç³»ç»åæ¨ç»´æ¤', '1', 'ç»´æ¤åå®¹', '0', 'admin', now(), '', null, 'ç®¡çå');
			insert into sys_notice values('1', 'æ¸©é¦¨æéï¼2018-07-01 æ°çæ¬åå¸å¦', '2', 'æ°çæ¬åå®¹', '0', 103, 1, now(), null, null, 'ç®¡çå');
			insert into sys_notice values('2', 'ç»´æ¤éç¥ï¼2018-07-01 ç³»ç»åæ¨ç»´æ¤', '1', 'ç»´æ¤åå®¹', '0', 103, 1, now(), null, null, 'ç®¡çå');


			-- ----------------------------
			@@ -790,9 +809,9 @@
			gen_type char default '0'::bpchar not null,
			gen_path varchar(200) default '/'::varchar,
			options varchar(1000) default null::varchar,
			create_by varchar(64) default ''::varchar,
			create_by int8,
			create_time timestamp,
			update_by varchar(64) default ''::varchar,
			update_by int8,
			update_time timestamp,
			remark varchar(500) default null::varchar,
			constraint gen_table_pk primary key (table_id)
			@@ -814,6 +833,7 @@
			comment on column gen_table.gen_type is 'çæä»£ç æ¹å¼ï¼0zipåç¼©å 1èªå®ä¹è·¯å¾ï¼';
			comment on column gen_table.gen_path is 'çæè·¯å¾ï¼ä¸å¡«é»è®¤é¡¹ç®è·¯å¾ï¼';
			comment on column gen_table.options is 'å¶å®çæéé¡¹';
			comment on column gen_table.create_dept is 'åå»ºé¨é¨';
			comment on column gen_table.create_by is 'åå»ºè';
			comment on column gen_table.create_time is 'åå»ºæ¶é´';
			comment on column gen_table.update_by is 'æ´æ°è';
			@@ -844,9 +864,10 @@
			html_type varchar(200) default null::varchar,
			dict_type varchar(200) default ''::varchar,
			sort int4,
			create_by varchar(64) default ''::varchar,
			create_dept int8,
			create_by int8,
			create_time timestamp,
			update_by varchar(64) default ''::varchar,
			update_by int8,
			update_time timestamp,
			constraint gen_table_column_pk primary key (column_id)
			);
			@@ -870,6 +891,7 @@
			comment on column gen_table_column.html_type is 'æ¾ç¤ºç±»åï¼ææ¬æ¡ãææ¬åãä¸ææ¡ãå¤éæ¡ãåéæ¡ãæ¥ææ§ä»¶ï¼';
			comment on column gen_table_column.dict_type is 'åå¸ç±»å';
			comment on column gen_table_column.sort is 'æåº';
			comment on column gen_table_column.create_dept is 'åå»ºé¨é¨';
			comment on column gen_table_column.create_by is 'åå»ºè';
			comment on column gen_table_column.create_time is 'åå»ºæ¶é´';
			comment on column gen_table_column.update_by is 'æ´æ°è';
			@@ -886,9 +908,10 @@
			original_name varchar(255) default ''::varchar not null,
			file_suffix varchar(10) default ''::varchar not null,
			url varchar(500) default ''::varchar not null,
			create_by varchar(64) default ''::varchar,
			create_dept int8,
			create_by int8,
			create_time timestamp,
			update_by varchar(64) default ''::varchar,
			update_by int8,
			update_time timestamp,
			service varchar(20) default 'minio'::varchar,
			constraint sys_oss_pk primary key (oss_id)
			@@ -901,6 +924,7 @@
			comment on column sys_oss.file_suffix is 'æä»¶åç¼å';
			comment on column sys_oss.url is 'URLå°å';
			comment on column sys_oss.create_by is 'ä¸ä¼ äºº';
			comment on column sys_oss.create_dept is 'åå»ºé¨é¨';
			comment on column sys_oss.create_time is 'åå»ºæ¶é´';
			comment on column sys_oss.update_by is 'æ´æ°è';
			comment on column sys_oss.update_time is 'æ´æ°æ¶é´';
			@@ -925,9 +949,10 @@
			access_policy char(1) default '1'::bpchar not null,
			status char default '1'::bpchar,
			ext1 varchar(255) default ''::varchar,
			create_by varchar(64) default ''::varchar,
			create_dept int8,
			create_by int8,
			create_time timestamp,
			update_by varchar(64) default ''::varchar,
			update_by int8,
			update_time timestamp,
			remark varchar(500) default ''::varchar,
			constraint sys_oss_config_pk primary key (oss_config_id)
			@@ -947,17 +972,18 @@
			comment on column sys_oss_config.access_policy is 'æ¡¶æéç±»å(0=private 1=public 2=custom)';
			comment on column sys_oss_config.status is 'ç¶æï¼0=æ£å¸¸,1=åç¨ï¼';
			comment on column sys_oss_config.ext1 is 'æ©å±åæ®µ';
			comment on column sys_oss_config.create_dept is 'åå»ºé¨é¨';
			comment on column sys_oss_config.create_by is 'åå»ºè';
			comment on column sys_oss_config.create_time is 'åå»ºæ¶é´';
			comment on column sys_oss_config.update_by is 'æ´æ°è';
			comment on column sys_oss_config.update_time is 'æ´æ°æ¶é´';
			comment on column sys_oss_config.remark is 'å¤æ³¨';

			insert into sys_oss_config values (1, 'minio', 'ruoyi', 'ruoyi123', 'ruoyi', '', '127.0.0.1:9000', '','N', '', '1', '0', '', 'admin', now(), 'admin', now(), null);
			insert into sys_oss_config values (2, 'qiniu', 'XXXXXXXXXXXXXXX', 'XXXXXXXXXXXXXXX', 'ruoyi', '', 's3-cn-north-1.qiniucs.com', '','N', '', '1', '1', '', 'admin', now(), 'admin', now(), null);
			insert into sys_oss_config values (3, 'aliyun', 'XXXXXXXXXXXXXXX', 'XXXXXXXXXXXXXXX', 'ruoyi', '', 'oss-cn-beijing.aliyuncs.com', '','N', '', '1', '1', '', 'admin', now(), 'admin', now(), null);
			insert into sys_oss_config values (4, 'qcloud', 'XXXXXXXXXXXXXXX', 'XXXXXXXXXXXXXXX', 'ruoyi-1250000000', '', 'cos.ap-beijing.myqcloud.com', '','N', 'ap-beijing', '1', '1', '', 'admin', now(), 'admin', now(), null);
			insert into sys_oss_config values (5, 'image', 'ruoyi', 'ruoyi123', 'ruoyi', 'image', '127.0.0.1:9000', '','N', '', '1', '1', '', 'admin', now(), 'admin', now(), NULL);
			insert into sys_oss_config values (1, 'minio', 'ruoyi', 'ruoyi123', 'ruoyi', '', '127.0.0.1:9000', '','N', '', '1', '0', '', 103, 1, now(), 1, now(), null);
			insert into sys_oss_config values (2, 'qiniu', 'XXXXXXXXXXXXXXX', 'XXXXXXXXXXXXXXX', 'ruoyi', '', 's3-cn-north-1.qiniucs.com', '','N', '', '1', '1', '', 103, 1, now(), 1, now(), null);
			insert into sys_oss_config values (3, 'aliyun', 'XXXXXXXXXXXXXXX', 'XXXXXXXXXXXXXXX', 'ruoyi', '', 'oss-cn-beijing.aliyuncs.com', '','N', '', '1', '1', '', 103, 1, now(), 1, now(), 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, now(), 1, now(), null);
			insert into sys_oss_config values (5, 'image', 'ruoyi', 'ruoyi123', 'ruoyi', 'image', '127.0.0.1:9000', '','N', '', '1', '1', '', 103, 1, now(), 1, now(), NULL);

			-- åç¬¦ä¸²èªå¨è½¬æ¶é´ é¿åæ¡æ¶æ¶é´æ¥è¯¢æ¥éé®é¢
			create or replace function cast_varchar_to_timestamp(varchar) returns timestamptz as $$