DROP TABLE IF EXISTS `bz_base_info`;
CREATE TABLE `bz_base_info`
(
    `id`             BIGINT(20)     NOT NULL COMMENT 'ID',
    `data_type`      INT(11)        NULL     DEFAULT NULL COMMENT '类型',
    `name`           VARCHAR(50)    NULL     DEFAULT NULL COMMENT '名称',
    `litpics`        VARCHAR(500)   NULL     DEFAULT NULL COMMENT '图片',
    `brief`          VARCHAR(500)   NULL     DEFAULT NULL COMMENT '简介',
    `address`        VARCHAR(100)   NULL     DEFAULT NULL COMMENT '地址',
    `contacts`       VARCHAR(50)    NULL     DEFAULT NULL COMMENT '联系人',
    `contact_number` VARCHAR(50)    NULL     DEFAULT NULL COMMENT '联系电话',
    `lng`            DECIMAL(20, 6) NOT NULL DEFAULT '0.000000' COMMENT '经度（坐标）',
    `lat`            DECIMAL(20, 6) NOT NULL DEFAULT '0.000000' COMMENT '纬度（坐标）',
    `created_time`   DATETIME       NULL     DEFAULT NULL COMMENT '创建时间',
    `created_by`     BIGINT(20)     NULL     DEFAULT NULL COMMENT '创建人',
    `updated_time`   DATETIME       NULL     DEFAULT NULL COMMENT '修改时间',
    `updated_by`     BIGINT(20)     NULL     DEFAULT NULL COMMENT '修改人',
    PRIMARY KEY (`id`)
) COMMENT ='文旅场所基础信息' ENGINE = InnoDB;

DROP TABLE IF EXISTS `bz_holiday_village_info`;
CREATE TABLE `bz_holiday_village_info`
(
    `id`             BIGINT(20)   NOT NULL COMMENT 'ID',
    `business_hours` VARCHAR(200) NULL DEFAULT NULL COMMENT '开放时间',
    PRIMARY KEY (`id`)
) COMMENT ='度假村扩展信息表' ENGINE = InnoDB;

DROP TABLE IF EXISTS `bz_home_stay_info`;
CREATE TABLE `bz_home_stay_info`
(
    `id`               BIGINT(20) NOT NULL COMMENT 'ID',
    `total_room_count` INT(1)     NOT NULL COMMENT '客房总数',
    PRIMARY KEY (`id`)
) COMMENT ='民宿扩展信息表' ENGINE = InnoDB;

DROP TABLE IF EXISTS `bz_hotel_info`;
CREATE TABLE `bz_hotel_info`
(
    `id`               BIGINT(20) NOT NULL COMMENT 'ID',
    `grade`            INT(1)     NULL DEFAULT NULL COMMENT '等级',
    `total_room_count` INT(1)     NOT NULL COMMENT '客房总数',
    PRIMARY KEY (`id`)
) COMMENT ='酒店扩展信息表' ENGINE = InnoDB;

DROP TABLE IF EXISTS `bz_scenery_info`;
CREATE TABLE `bz_scenery_info`
(
    `id`    BIGINT(20) NOT NULL COMMENT 'ID',
    `grade` INT(1)     NULL DEFAULT NULL COMMENT '等级',
    PRIMARY KEY (`id`)
) COMMENT ='景区扩展信息表' ENGINE = InnoDB;


DROP TABLE IF EXISTS `bz_tourist_info`;
CREATE TABLE `bz_tourist_info`
(
    `id`                      BIGINT(20)   NOT NULL COMMENT 'ID',
    `total_tour_guides_count` VARCHAR(200) NULL DEFAULT NULL COMMENT '导游人数',
    PRIMARY KEY (`id`)
) COMMENT ='旅行社扩展信息表' ENGINE = InnoDB;

DROP TABLE IF EXISTS `bz_venue_info`;
CREATE TABLE `bz_venue_info`
(
    `id`             BIGINT(20)   NOT NULL COMMENT 'ID',
    `business_hours` VARCHAR(200) NULL DEFAULT NULL COMMENT '开放时间',
    PRIMARY KEY (`id`)
) COMMENT ='场馆扩展信息表' ENGINE = InnoDB;


REPLACE
    INTO `authority_info` (`id`, `parent_id`, `name`, `remark`)
VALUES (1400, 0, 'bz.base.venue', '场馆基本信息管理'),
       (1401, 1400, 'bz.base.venue.find', '查询'),
       (1402, 1400, 'bz.base.venue.add', '添加'),
       (1403, 1400, 'bz.base.venue.edit', '修改'),
       (1404, 1400, 'bz.base.venue.delete', '删除');


REPLACE
    INTO `authority_info` (`id`, `parent_id`, `name`, `remark`)
VALUES (1500, 0, 'bz.base.scenery', '景区基本信息管理'),
       (1501, 1500, 'bz.base.scenery.find', '查询'),
       (1502, 1500, 'bz.base.scenery.add', '添加'),
       (1503, 1500, 'bz.base.scenery.edit', '修改'),
       (1504, 1500, 'bz.base.scenery.delete', '删除');


REPLACE
    INTO `authority_info` (`id`, `parent_id`, `name`, `remark`)
VALUES (1600, 0, 'bz.base.holiday.village', '度假村基本信息管理'),
       (1601, 1600, 'bz.base.holiday.village.find', '查询'),
       (1602, 1600, 'bz.base.holiday.village.add', '添加'),
       (1603, 1600, 'bz.base.holiday.village.edit', '修改'),
       (1604, 1600, 'bz.base.holiday.village.delete', '删除');

REPLACE
    INTO `authority_info` (`id`, `parent_id`, `name`, `remark`)
VALUES (1700, 0, 'bz.base.hotel', '酒店基本信息管理'),
       (1701, 1700, 'bz.base.hotel.find', '查询'),
       (1702, 1700, 'bz.base.hotel.add', '添加'),
       (1703, 1700, 'bz.base.hotel.edit', '修改'),
       (1704, 1700, 'bz.base.hotel.delete', '删除');


REPLACE
    INTO `authority_info` (`id`, `parent_id`, `name`, `remark`)
VALUES (1800, 0, 'bz.base.home.stay', '民宿基本信息管理'),
       (1801, 1800, 'bz.base.home.stay.find', '查询'),
       (1802, 1800, 'bz.base.home.stay.add', '添加'),
       (1803, 1800, 'bz.base.home.stay.edit', '修改'),
       (1804, 1800, 'bz.base.home.stay.delete', '删除');

REPLACE
    INTO `authority_info` (`id`, `parent_id`, `name`, `remark`)
VALUES (1900, 0, 'bz.base.tourist', '旅行社基本信息管理'),
       (1901, 1900, 'bz.base.tourist.find', '查询'),
       (1902, 1900, 'bz.base.tourist.add', '添加'),
       (1903, 1900, 'bz.base.tourist.edit', '修改'),
       (1904, 1900, 'bz.base.tourist.delete', '删除');
