ALTER TABLE `lihu`.`check_type`
ADD COLUMN `display_barcode` INT NULL DEFAULT 0 COMMENT '是否显示患者条码' AFTER `deleted`,
ADD COLUMN `expense_recognition` INT NULL DEFAULT 0 COMMENT '是否需要确费' AFTER `display_barcode`,
ADD COLUMN `timeslot_book_num` INT NULL DEFAULT 0 COMMENT '时段预约规定人数' AFTER `expense_recognition`,
ADD COLUMN `timeslot_reserved_num` INT NULL DEFAULT 0 COMMENT '每时段预留人数' AFTER `timeslot_book_num`,
ADD COLUMN `affinity_check_types` VARCHAR(45) NULL DEFAULT '' COMMENT '亲和的检查类型' AFTER `timeslot_reserved_num`;

CREATE TABLE `queue_sequence` (
  `id` int NOT NULL AUTO_INCREMENT,
  `check_type` int DEFAULT NULL,
  `time_slot` int DEFAULT NULL,
  `queue_no` int DEFAULT NULL,
  `queue_vip_no` int DEFAULT NULL,
  `queue_full` int DEFAULT NULL,
  `queue_vip_full` int DEFAULT NULL,
  `creator` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `create_time` datetime NOT NULL,
  `updater` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `update_time` datetime NOT NULL,
  `deleted` bit(1) DEFAULT b'0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
SELECT * FROM lihu.check_type;


