|
|
create table hospital_extras
|
|
|
(
|
|
|
id bigint unsigned auto_increment
|
|
|
primary key,
|
|
|
hospital bigint not null,
|
|
|
mark varchar(20) not null,
|
|
|
content longtext not null,
|
|
|
created_at timestamp null,
|
|
|
updated_at timestamp null
|
|
|
)
|
|
|
collate = utf8mb4_unicode_ci;
|
|
|
|
|
|
create index hospital_extras_hospital_index
|
|
|
on hospital_extras (hospital);
|
|
|
|
|
|
INSERT INTO lkpe.hospital_extras (id, hospital, mark, content, created_at, updated_at) VALUES (1, 0, 'pay', '{"wxp":{"open":1,"id":"1638739772","number":"3CE37188EBCFBBEB800B0E1C69B360F05A3E80CD","v3":"AVPV7NxK8cC2RvRrrwdTqUG9YbQXQe3w","key":"/storage/app/forbidden/2023/05/9943b647-1143-40c6-be2c-8844919ee1ff.pem","crt":"/storage/app/forbidden/2023/05/9943b64e-32f6-4eb1-b218-df86353965de.pem"}}', '2023-05-24 13:10:48', '2023-05-27 12:16:49');
|
|
|
INSERT INTO lkpe.hospital_extras (id, hospital, mark, content, created_at, updated_at) VALUES (2, 0, 'order_type', '{"combo_add_item":2,"item":1}', '2023-05-24 13:10:48', '2023-06-09 10:06:24');
|
|
|
INSERT INTO lkpe.hospital_extras (id, hospital, mark, content, created_at, updated_at) VALUES (3, 0, 'card_pay', '{"open":2}', '2023-05-24 14:29:59', '2023-05-24 14:35:50');
|
|
|
INSERT INTO lkpe.hospital_extras (id, hospital, mark, content, created_at, updated_at) VALUES (4, 1, 'pay', '{"wxp":{"open":0,"id":"","number":"","v3":"","key":"","crt":""}}', '2023-05-25 21:31:04', '2023-05-25 21:31:04');
|
|
|
INSERT INTO lkpe.hospital_extras (id, hospital, mark, content, created_at, updated_at) VALUES (5, 1, 'order_type', '{"combo_add_item":0,"item":0}', '2023-05-25 21:31:04', '2023-05-25 21:31:04');
|
|
|
INSERT INTO lkpe.hospital_extras (id, hospital, mark, content, created_at, updated_at) VALUES (6, 1, 'card_pay', '{"open":0}', '2023-05-25 21:31:04', '2023-05-25 21:31:04');
|
|
|
INSERT INTO lkpe.hospital_extras (id, hospital, mark, content, created_at, updated_at) VALUES (7, 0, 'readme', '{"open":1,"content":"1、体检前三天不应参加聚餐，太甜、太咸、太油腻的食物应避免，禁酒，尽量以素食\\n为主。晚上八点钟后一般要求禁食，并应早睡。<br/>\\n2、体检当日不吃早餐，空腹进行抽血及腹部B超检查等体检项目。<br/>\\n3、进行女性妇科B超、男性前列腺B超时，需要憋尿。<br/>\\n4、女性在作妇科检查时,需要排尽小便。<br/>\\n5、女性月经期间不宜做妇科检查及化验室小便检查;孕妇不应做X线检查。<br/>\\n6、静脉抽血后用棉球压住针头的穿刺点两分钟，不能按揉，防止形成血肿。<br/>\\n7、接受体检时，应自然放松，心态平和，为医生提供真实的病历资料及自我身体状况\\n或感觉。","time":5}', '2023-05-26 11:50:02', '2023-05-27 12:20:08');
|
|
|
INSERT INTO lkpe.hospital_extras (id, hospital, mark, content, created_at, updated_at) VALUES (8, 1, 'readme', '{"open":1,"content":"AAAAAAAAAAAAA","time":5}', '2023-05-26 12:50:40', '2023-06-10 00:51:02');
|
|
|
INSERT INTO lkpe.hospital_extras (id, hospital, mark, content, created_at, updated_at) VALUES (9, 2, 'pay', '{"wxp":{"open":0,"id":"","number":"","v3":"","key":"","crt":""}}', '2023-05-26 12:51:54', '2023-05-26 12:51:54');
|
|
|
INSERT INTO lkpe.hospital_extras (id, hospital, mark, content, created_at, updated_at) VALUES (10, 2, 'order_type', '{"combo_add_item":0,"item":0}', '2023-05-26 12:51:54', '2023-05-26 12:51:54');
|
|
|
INSERT INTO lkpe.hospital_extras (id, hospital, mark, content, created_at, updated_at) VALUES (11, 2, 'card_pay', '{"open":0}', '2023-05-26 12:51:54', '2023-05-26 12:51:54');
|
|
|
INSERT INTO lkpe.hospital_extras (id, hospital, mark, content, created_at, updated_at) VALUES (12, 2, 'readme', '{"open":0,"content":"","time":5}', '2023-05-26 12:51:54', '2023-05-26 12:51:54');
|