REPLACE
INTO `authority_info` (`id`, `parent_id`, `name`, `remark`)
VALUES (2400, 0, 'bz', '业务数据展示系统'),
        (2401, 2400, 'bz.media', '多媒体资源管理'),
        (2402, 2400, 'bz.monitor', '实时监测'),
        (2403, 2400, 'bz.consume', '文旅消费'),
        (2404, 2400, 'bz.resourceAnalysis', '文旅资源分析'),
        (2405, 2400, 'bz.touristAnalysis', '游客分析');


DROP TABLE IF EXISTS `bz_media`;
CREATE TABLE `bz_media`
(
    `id`           BIGINT(20) NOT NULL COMMENT 'ID',
    `category_id`   BIGINT(20) NOT NULL COMMENT '分类',
    `name`         VARCHAR(50) NOT NULL COMMENT '名称',
    `address`      VARCHAR(50) NOT NULL COMMENT '地址',
    `created_time` DATETIME    NOT NULL COMMENT '创建时间',
    `created_by`   BIGINT(20) NOT NULL COMMENT '创建人',
    `updated_time` DATETIME NULL DEFAULT NULL COMMENT '修改时间',
    `updated_by`   BIGINT(20) NULL DEFAULT NULL COMMENT '修改人',
    PRIMARY KEY (`id`)
) COMMENT ='多媒体资源' ENGINE = InnoDB;
