lbqms.git - Gitblit

			@@ -14,7 +14,7 @@
			email varchar(255) default ''::varchar,
			avatar varchar(500) default ''::varchar,
			access_token varchar(255) not null,
			expire_in int8 default null::varchar,
			expire_in int8 default null,
			refresh_token varchar(255) default null::varchar,
			access_code varchar(255) default null::varchar,
			union_id varchar(255) default null::varchar,
			@@ -65,6 +65,8 @@
			comment on column sys_social.update_by is '更新者';
			comment on column sys_social.update_time is '更新时间';
			comment on column sys_social.del_flag is '删除标志（0代表存在 2代表删除）';

			insert into sys_social values (1, 1, '000000', 'GITEE1766278', 'GITEE', NULL, 'JavaLionLi', '', '', 'https://foruda.gitee.com/avatar/1676987709652631782/1766278_javalionli_1585201115.png', '2a25b8a8b6803939070d931cdb1f9540', 86400, '448155d0a9c35e6a036a346f7a090f9b3aa7fd41fd2e9563e71e38a7faffbe1c', NULL, NULL, 'user_info projects', 'bearer', NULL, NULL, NULL, NULL, NULL, NULL, 103, 1, '2023-07-13 17:12:01', 1, '2023-07-13 17:12:01', '0');

			-- ----------------------------
			-- 租户表
			@@ -448,7 +450,7 @@
			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, '代码生成菜单');
			insert into sys_menu values('121', '租户管理', '6', '1', 'tenant', 'system/tenant/index', '', '1', '0', 'C', '0', '0', 'system:tenant:list', 'list', 103, 1, now(), null, null, '租户管理菜单');
			insert into sys_menu values('122', '租户套餐管理', '6', '2', 'tenantPackage', 'system/tenantPackage/index', '', '1', '0', 'C', '0', '0', 'system:tenantPackage:list', 'form', 103, 1, now(), null, null, '租户套餐管理菜单');
			insert into sys_menu values('123', '客户端管理', '1', '1', 'client', 'system/client/index', '', '1', '0', 'C', '0', '0', 'system:client:list', 'international', 103, 1, now(), null, null, '客户端管理菜单');
			insert into sys_menu values('123', '客户端管理', '1', '11', 'client', 'system/client/index', '', '1', '0', 'C', '0', '0', 'system:client:list', 'international', 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', 103, 1, now(), null, null, 'Admin监控菜单');
			@@ -1225,11 +1227,11 @@
			drop table if exists sys_client;
			create table sys_client (
			id int8,
			client_id varchar(64) ''::varchar,
			client_key varchar(32) ''::varchar,
			client_secret varchar(255) ''::varchar,
			grant_type varchar(255) ''::varchar,
			device_type varchar(32) ''::varchar,
			client_id varchar(64) default ''::varchar,
			client_key varchar(32) default ''::varchar,
			client_secret varchar(255) default ''::varchar,
			grant_type varchar(255) default ''::varchar,
			device_type varchar(32) default ''::varchar,
			active_timeout int4 default 1800,
			timeout int4 default 604800,
			status char(1) default '0'::bpchar,
			@@ -1240,7 +1242,7 @@
			update_by int8,
			update_time timestamp,
			constraint sys_client_pk primary key (id)
			)
			);

			comment on table sys_client is '系统授权表';
			comment on column sys_client.id is '主建';