drop TABLE if exists `kylin_perform_sub`;
CREATE TABLE `kylin_perform_sub`
(
    `mid`            int(11)      NOT NULL AUTO_INCREMENT,
    `perform_sub_id` varchar(255) NOT NULL DEFAULT '' COMMENT 'perform_sub_id',
    `performance_id` varchar(255) NOT NULL DEFAULT '' COMMENT '演出id',
    `user_id`        varchar(255) NOT NULL DEFAULT '' COMMENT '用户id',
    `user_name`      varchar(255) NOT NULL DEFAULT '' COMMENT '用户昵称',
    `user_mobile`    varchar(255) NOT NULL DEFAULT '' COMMENT '用户手机号',
    `source_type`    tinyint      NOT NULL DEFAULT 0 COMMENT '来源 1小程序 2h5',
    `created_at`     datetime     NULL     DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `updated_at`     datetime     NULL     DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
    KEY `idx_perform_sub_id` (`perform_sub_id`),
    KEY `idx_perform_sub_performance_id` (`performance_id`),
    KEY `idx_perform_sub_user_id` (`user_id`),
    PRIMARY KEY (`mid`)
) ENGINE = InnoDB
  DEFAULT CHARSET utf8mb4
  COLLATE utf8mb4_unicode_ci COMMENT '演出预约表';