lbqms.git - Gitblit

ÎÄ¼þÃû´Ó sql/ry_20210908.sql ÐÞ¸Ä
			@@ -172,7 +172,7 @@
			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('110', 'å®æ¶ä»»å¡', '2', '2', 'job', 'monitor/job/index', '', 1, 0, 'C', '0', '0', 'monitor:job:list', 'job', 'admin', sysdate(), '', null, 'å®æ¶ä»»å¡èå');
			# insert into sys_menu values('110', 'å®æ¶ä»»å¡', '2', '2', 'job', 'monitor/job/index', '', 1, 0, 'C', '0', '0', 'monitor:job:list', 'job', 'admin', sysdate(), '', null, 'å®æ¶ä»»å¡èå');
			insert into sys_menu values('111', 'æ°æ®çæ§', '2', '3', 'druid', 'monitor/druid/index', '', 1, 0, 'C', '0', '0', 'monitor:druid:list', 'druid', 'admin', sysdate(), '', null, 'æ°æ®çæ§èå');
			# insert into sys_menu values('112', 'æå¡çæ§', '2', '4', 'server', 'monitor/server/index', '', 1, 0, 'C', '0', '0', 'monitor:server:list', 'server', '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, 'ç¼åçæ§èå');
			@@ -181,6 +181,10 @@
			insert into sys_menu values('116', 'ç³»ç»æ¥å£', '3', '3', 'swagger', 'tool/swagger/index', '', 1, 0, 'C', '0', '0', 'tool:swagger:list', 'swagger', 'admin', sysdate(), '', 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çæ§èå');
			-- 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, 'æä»¶ç®¡çèå');
			-- 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('500', 'æä½æ¥å¿', '108', '1', 'operlog', 'monitor/operlog/index', '', 1, 0, 'C', '0', '0', 'monitor:operlog:list', 'form', 'admin', sysdate(), '', null, 'æä½æ¥å¿èå');
			@@ -258,6 +262,13 @@
			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, '');
			-- 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, '');


			-- ----------------------------
			@@ -543,6 +554,7 @@
			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.captchaOnOff', '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:å³é');


			-- ----------------------------
			@@ -688,4 +700,51 @@
			update_by varchar(64) default '' comment 'æ´æ°è',
			update_time datetime comment 'æ´æ°æ¶é´',
			primary key (column_id)
			) engine=innodb auto_increment=1 comment = 'ä»£ç çæä¸å¡è¡¨åæ®µ';
			) engine=innodb auto_increment=1 comment = 'ä»£ç çæä¸å¡è¡¨åæ®µ';

			-- ----------------------------
			-- OSSå¯¹è±¡åå¨è¡¨
			-- ----------------------------
			drop table if exists sys_oss;
			create table sys_oss (
			oss_id bigint(20) not null auto_increment comment 'å¯¹è±¡åå¨ä¸»é®',
			file_name varchar(64) not null default '' comment 'æä»¶å',
			original_name varchar(64) not null default '' comment 'åå',
			file_suffix varchar(10) not null default '' comment 'æä»¶åç¼å',
			url varchar(200) not null comment 'URLå°å',
			create_time datetime default null comment 'åå»ºæ¶é´',
			create_by varchar(64) default '' comment 'ä¸ä¼ äºº',
			update_time datetime default null comment 'æ´æ°æ¶é´',
			update_by varchar(64) default '' comment 'æ´æ°äºº',
			service varchar(10) not null default 'minio' comment 'æå¡å',
			primary key (oss_id)
			) engine=innodb comment ='OSSå¯¹è±¡åå¨è¡¨';

			-- ----------------------------
			-- OSSå¯¹è±¡åå¨å¨æéç½®è¡¨
			-- ----------------------------
			drop table if exists sys_oss_config;
			create table sys_oss_config (
			oss_config_id bigint(20) not null auto_increment comment 'ä¸»å»º',
			config_key varchar(255) not null default '' comment 'éç½®key',
			access_key varchar(255) default '' comment 'accessKey',
			secret_key varchar(255) default '' comment 'ç§é¥',
			bucket_name varchar(255) default '' comment 'æ¡¶åç§°',
			prefix varchar(255) default '' comment 'åç¼',
			endpoint varchar(255) default '' comment 'è®¿é®ç«ç¹',
			is_https char(1) default 'N' comment 'æ¯å¦httpsï¼Y=æ¯,N=å¦ï¼',
			region varchar(255) default '' comment 'å',
			status char(1) default '1' comment 'ç¶æï¼0=æ£å¸¸,1=åç¨ï¼',
			ext1 varchar(255) default '' comment 'æ©å±åæ®µ',
			create_by varchar(64) default '' comment 'åå»ºè',
			create_time datetime default null comment 'åå»ºæ¶é´',
			update_by varchar(64) default '' 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', '', 'http://localhost:9000', 'N', '', '0', '', 'admin', sysdate(), 'admin', sysdate(), NULL);
			insert into sys_oss_config values (2, 'qiniu', 'XXXXXXXXXXXXXXX', 'XXXXXXXXXXXXXXX', 'ruoyi', '', 'http://XXX.XXXX.com', 'N', 'z0', '1', '', 'admin', sysdate(), 'admin', sysdate(), NULL);
			insert into sys_oss_config values (3, 'aliyun', 'XXXXXXXXXXXXXXX', 'XXXXXXXXXXXXXXX', 'ruoyi', '', 'http://oss-cn-beijing.aliyuncs.com', 'N', '', '1', '', 'admin', sysdate(), 'admin', sysdate(), NULL);
			insert into sys_oss_config values (4, 'qcloud', 'XXXXXXXXXXXXXXX', 'XXXXXXXXXXXXXXX', 'ruoyi-1250000000', '', 'http://cos.ap-beijing.myqcloud.com', 'N', 'ap-beijing', '1', '', 'admin', sysdate(), 'admin', sysdate(), NULL);