You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
24 lines
1.8 KiB
SQL
24 lines
1.8 KiB
SQL
create table configs
|
|
(
|
|
id bigint unsigned auto_increment
|
|
primary key,
|
|
label varchar(50) not null,
|
|
value varchar(1000) not null,
|
|
type tinyint not null comment '1-文字 2-图片 3-文字数组 4-图片数组 5-Key_Value',
|
|
remark varchar(100) not null,
|
|
created_at timestamp null,
|
|
updated_at timestamp null
|
|
)
|
|
collate = utf8mb4_unicode_ci;
|
|
|
|
create index configs_type_index
|
|
on configs (type);
|
|
|
|
INSERT INTO lkpe.configs (id, label, value, type, remark, created_at, updated_at) VALUES (1, 'Logo', '/storage/assets/logo.png', 2, '', '2023-04-06 23:01:37', '2023-04-06 23:01:37');
|
|
INSERT INTO lkpe.configs (id, label, value, type, remark, created_at, updated_at) VALUES (2, 'Favicon', '/storage/assets/favicon.png', 2, '', '2023-04-06 23:01:37', '2023-04-06 23:01:37');
|
|
INSERT INTO lkpe.configs (id, label, value, type, remark, created_at, updated_at) VALUES (3, 'Login欢迎图片', '/storage/assets/login_image.jpg', 2, '', '2023-04-06 23:01:37', '2023-04-06 23:01:37');
|
|
INSERT INTO lkpe.configs (id, label, value, type, remark, created_at, updated_at) VALUES (4, '网站名称', '岚科体检预约', 1, '', '2023-04-06 23:01:37', '2023-04-06 23:01:37');
|
|
INSERT INTO lkpe.configs (id, label, value, type, remark, created_at, updated_at) VALUES (5, '客服电话', '13333333333', 1, '', '2023-04-10 23:22:21', '2023-04-11 23:17:51');
|
|
INSERT INTO lkpe.configs (id, label, value, type, remark, created_at, updated_at) VALUES (6, '小程序默认封面图', '/storage/assets/mp/home/cover.png', 2, '', '2023-04-11 09:23:34', '2023-04-11 09:23:34');
|
|
INSERT INTO lkpe.configs (id, label, value, type, remark, created_at, updated_at) VALUES (7, '会员卡配置', '{"open":0}', 5, '', '2023-04-11 09:29:24', '2023-04-11 09:29:24');
|