Closed xbpk3t closed 1 year ago
insert into gva.sys_apis (id, created_at, updated_at, deleted_at, path, description, api_group, method)
values
(147, '2023-04-11 17:40:36.806', '2023-04-11 17:40:36.806', null, '/appCategory/createAppCategory', '新增appCategory表', 'appCategory', 'POST'),
(148, '2023-04-11 17:40:36.814', '2023-04-11 17:40:36.814', null, '/appCategory/deleteAppCategory', '删除appCategory表', 'appCategory', 'DELETE'),
(149, '2023-04-11 17:40:36.820', '2023-04-11 17:40:36.820', null, '/appCategory/deleteAppCategoryByIds', '批量删除appCategory表', 'appCategory', 'DELETE'),
(150, '2023-04-11 17:40:36.828', '2023-04-11 17:40:36.828', null, '/appCategory/updateAppCategory', '更新appCategory表', 'appCategory', 'PUT'),
(151, '2023-04-11 17:40:36.834', '2023-04-11 17:40:36.834', null, '/appCategory/findAppCategory', '根据ID获取appCategory表', 'appCategory', 'GET'),
(152, '2023-04-11 17:40:36.839', '2023-04-11 17:40:36.839', null, '/appCategory/getAppCategoryList', '获取appCategory表列表', 'appCategory', 'GET'),
(153, '2023-04-11 17:43:57.104', '2023-04-11 17:43:57.104', null, '/appManage/createApp', '新增app表', 'app', 'POST'),
(154, '2023-04-11 17:43:57.113', '2023-04-11 17:43:57.113', null, '/appManage/deleteApp', '删除app表', 'app', 'DELETE'),
(155, '2023-04-11 17:43:57.122', '2023-04-11 17:43:57.122', null, '/appManage/deleteAppByIds', '批量删除app表', 'app', 'DELETE'),
(156, '2023-04-11 17:43:57.130', '2023-04-11 17:43:57.130', null, '/appManage/updateApp', '更新app表', 'app', 'PUT'),
(157, '2023-04-11 17:43:57.141', '2023-04-11 17:43:57.141', null, '/appManage/findApp', '根据ID获取app表', 'app', 'GET'),
(158, '2023-04-11 17:43:57.150', '2023-04-11 17:43:57.150', null, '/appManage/getAppList', '获取app表列表', 'app', 'GET');
create table app_category
(
id int auto_increment,
category_name varchar(255) null comment '分类名称',
more text
null comment '备注',
created_at timestamp null,
updated_at
timestamp null,
deleted_at timestamp null,
constraint
app_category_pk
primary key (id),
constraint
app_category_pk2
unique (id)
)
comment 'app分类表';
create table app_manage
(
id int auto_increment,
category_id int null comment '分类id',
app_name varchar(255) null comment 'app名称',
app_url varchar(255) null comment 'app的url',
app_label int null comment 'app标签(0核心应用、1增强应用、2已删除应用)',
app_remark varchar(255) null comment 'app备注',
app_more text null comment 'md-textarea',
created_at timestamp null,
updated_at timestamp null,
deleted_at timestamp null,
constraint app_pk
primary key (id)
);
alter table app_manage
add score int not null comment '评分' after app_more;
update gva.sys_apis set path = "/appManage/createApp" where id = 153;
update gva.sys_apis set path = "/appManage/deleteApp" where id = 154;
update gva.sys_apis set path = "/appManage/deleteAppByIds" where id = 155;
update gva.sys_apis set path = "/appManage/updateApp" where id = 156;
update gva.sys_apis set path = "/appManage/findApp" where id = 157;
update gva.sys_apis set path = "/appManage/getAppList" where id = 158;