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.
41 lines
6.8 KiB
SQL
41 lines
6.8 KiB
SQL
create table carousels
|
|
(
|
|
id bigint unsigned auto_increment
|
|
primary key,
|
|
name varchar(20) not null,
|
|
image varchar(200) not null,
|
|
`desc` varchar(50) default '' null,
|
|
hospital bigint not null,
|
|
type tinyint not null comment '1-轮播图 2-广告',
|
|
jump_type tinyint not null comment '1-无跳转 2-小程序跳转 3-H5跳转',
|
|
jump_path varchar(200) not null,
|
|
login_type tinyint not null comment '1-需要 2-不需要',
|
|
start_time datetime not null,
|
|
end_time datetime not null,
|
|
status tinyint not null,
|
|
created_at timestamp null,
|
|
updated_at timestamp null
|
|
)
|
|
collate = utf8mb4_unicode_ci;
|
|
|
|
create index carousels_hospital_index
|
|
on carousels (hospital);
|
|
|
|
create index carousels_type_index
|
|
on carousels (type);
|
|
|
|
INSERT INTO lkpe.carousels (id, name, image, `desc`, hospital, type, jump_type, jump_path, login_type, start_time, end_time, status, created_at, updated_at) VALUES (1, '测试轮播图', '/storage/assets/upload/image/2023/04/98e750cd-17c5-4f07-aadb-f1880b081cd4.png', null, 0, 1, 1, '/aaaaaaaaaaaaaaaaaaaaaaaaaaaaa', 2, '2023-03-13 00:00:00', '2123-03-13 00:00:00', 1, '2023-04-11 13:56:47', '2023-04-11 23:44:11');
|
|
INSERT INTO lkpe.carousels (id, name, image, `desc`, hospital, type, jump_type, jump_path, login_type, start_time, end_time, status, created_at, updated_at) VALUES (3, '测试2', '/storage/assets/upload/image/2023/04/98e75454-60a9-48d5-9ae7-70f9e222007b.jpeg', null, 0, 1, 1, '', 2, '2023-03-13 00:00:00', '2123-03-13 00:00:00', 1, '2023-04-11 14:06:38', '2023-04-11 23:44:20');
|
|
INSERT INTO lkpe.carousels (id, name, image, `desc`, hospital, type, jump_type, jump_path, login_type, start_time, end_time, status, created_at, updated_at) VALUES (4, '套餐测试', '/storage/assets/upload/image/2023/04/98e75485-3cac-4ebc-aa89-f918401a4b2f.png', '套餐测试', 0, 2, 4, 'activity_package;2', 2, '2023-03-13 00:00:00', '2123-03-13 00:00:00', 1, '2023-04-11 14:07:12', '2023-05-24 20:59:15');
|
|
INSERT INTO lkpe.carousels (id, name, image, `desc`, hospital, type, jump_type, jump_path, login_type, start_time, end_time, status, created_at, updated_at) VALUES (5, '测试2', '/storage/assets/upload/image/2023/04/98e75497-ea0d-476a-9c56-c475030ca832.jpeg', null, 0, 2, 4, 'combo_item_open;2349;1,2,3;{"id":0,"date":null}', 2, '2023-03-13 00:00:00', '2123-03-13 00:00:00', 1, '2023-04-11 14:07:22', '2023-05-27 10:51:40');
|
|
INSERT INTO lkpe.carousels (id, name, image, `desc`, hospital, type, jump_type, jump_path, login_type, start_time, end_time, status, created_at, updated_at) VALUES (6, '个检预约', '/storage/assets/upload/image/2023/04/98e85460-2128-4135-86cc-297dd9e748e8.png', '点击预约个检', 0, 3, 4, 'order_choose_type', 1, '2023-03-13 00:00:00', '2123-03-13 00:00:00', 1, '2023-04-11 14:15:13', '2023-04-12 02:18:57');
|
|
INSERT INTO lkpe.carousels (id, name, image, `desc`, hospital, type, jump_type, jump_path, login_type, start_time, end_time, status, created_at, updated_at) VALUES (7, '团检预约', '/storage/assets/upload/image/2023/04/98e85748-2963-4635-8654-d5a2776c1668.png', '点击预约团检', 0, 3, 2, '/pages/buy/person/person?type=group', 1, '2023-03-13 00:00:00', '2123-03-13 00:00:00', 1, '2023-04-11 14:15:26', '2023-05-26 16:20:48');
|
|
INSERT INTO lkpe.carousels (id, name, image, `desc`, hospital, type, jump_type, jump_path, login_type, start_time, end_time, status, created_at, updated_at) VALUES (8, '健康问卷', '/storage/assets/upload/image/2023/04/98e85af6-8a22-4ff0-a831-7f7bdd50ef0d.png', '填写问卷', 0, 4, 2, '/pages/buy/person/person?type=question', 1, '2023-03-13 00:00:00', '2123-03-13 00:00:00', 1, '2023-04-11 14:15:13', '2023-06-09 04:50:35');
|
|
INSERT INTO lkpe.carousels (id, name, image, `desc`, hospital, type, jump_type, jump_path, login_type, start_time, end_time, status, created_at, updated_at) VALUES (9, '满意度调查', '/storage/assets/upload/image/2023/04/98e85b8c-71f8-419d-8326-b691fbd9d1fd.png', '意见和建议', 0, 4, 3, 'http://192.168.31.84:5173/h5/#/pages/main/login/login?page=question&token=[TOKEN]¶m=&hospital=[HOSPITAL]', 1, '2023-03-13 00:00:00', '2123-03-13 00:00:00', 1, '2023-04-11 14:15:26', '2023-06-09 02:16:04');
|
|
INSERT INTO lkpe.carousels (id, name, image, `desc`, hospital, type, jump_type, jump_path, login_type, start_time, end_time, status, created_at, updated_at) VALUES (10, '健康宣传', '/storage/assets/upload/image/2023/04/98e85b97-468b-4a1d-b55c-d72ed8076a21.png', '健康科普', 0, 4, 3, 'http://192.168.31.84:5173/h5/#/pages/main/posts/posts?type=1&hospital=[HOSPITAL]', 2, '2023-03-13 00:00:00', '2123-03-13 00:00:00', 1, '2023-04-12 01:25:21', '2023-06-09 02:16:10');
|
|
INSERT INTO lkpe.carousels (id, name, image, `desc`, hospital, type, jump_type, jump_path, login_type, start_time, end_time, status, created_at, updated_at) VALUES (11, '常见问题', '/storage/assets/upload/image/2023/04/98e85be6-c467-42ff-b62f-95fc274e8939.png', '问题解答', 0, 4, 3, 'http://192.168.31.84:5173/h5/#/pages/main/posts/posts?type=2&hospital=[HOSPITAL]', 2, '2023-03-13 00:00:00', '2123-03-13 00:00:00', 1, '2023-04-12 01:26:35', '2023-06-09 02:16:16');
|
|
INSERT INTO lkpe.carousels (id, name, image, `desc`, hospital, type, jump_type, jump_path, login_type, start_time, end_time, status, created_at, updated_at) VALUES (13, '体检引导', '/storage/assets/upload/image/2023/04/98e855dc-2df4-478f-9ac8-934deec649fc.png', '点击扫码排队', 0, 3, 2, '/pages/order/choose_person/choose_person', 1, '2023-03-13 00:00:00', '2123-03-13 00:00:00', 2, '2023-04-12 02:10:35', '2023-06-09 02:03:08');
|
|
INSERT INTO lkpe.carousels (id, name, image, `desc`, hospital, type, jump_type, jump_path, login_type, start_time, end_time, status, created_at, updated_at) VALUES (14, '报告查询', '/storage/assets/upload/image/2023/04/98e857d9-e99a-4146-bcc0-3dc6f220af0e.png', '点击查看报告', 0, 3, 2, '/pages/buy/person/person?type=report', 1, '2023-03-13 00:00:00', '2123-03-13 00:00:00', 1, '2023-04-12 02:13:46', '2023-06-03 01:16:05');
|
|
INSERT INTO lkpe.carousels (id, name, image, `desc`, hospital, type, jump_type, jump_path, login_type, start_time, end_time, status, created_at, updated_at) VALUES (15, '测试', '/storage/assets/upload/image/2023/06/995ee267-7d9f-4df7-ad45-410bddde770d.png', 'AAAAAAAAA', 1, 1, 1, '', 2, '2023-03-13 00:00:00', '2123-03-13 00:00:00', 1, '2023-06-10 00:27:30', '2023-06-10 00:27:30');
|
|
INSERT INTO lkpe.carousels (id, name, image, `desc`, hospital, type, jump_type, jump_path, login_type, start_time, end_time, status, created_at, updated_at) VALUES (16, 'ASDASDSAD', '/storage/assets/upload/image/2023/06/995ee441-6862-4d35-a3d7-e995464298e4.png', 'ASDASDASD', 1, 2, 1, '', 2, '2023-03-13 00:00:00', '2123-03-13 00:00:00', 1, '2023-06-10 00:32:37', '2023-06-10 00:32:37');
|