etrade / dili-xtrade · Files

ALTER TABLE `dili_xtrade`.`banner`
ADD COLUMN `link_type` int NULL DEFAULT NULL COMMENT '链接类型(枚举)' AFTER `pic_url`;

ALTER TABLE `dili_xtrade`.`banner` MODIFY pic_url NULL DEFAULT NULL;

DROP TABLE IF EXISTS `dili_xtrade`.`banner_content`;
CREATE TABLE `dili_xtrade`.`banner_content` (
    `id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增ID',
    `banner_id` bigint DEFAULT NULL COMMENT '轮播图ID',
    `content` text  COMMENT '内容',
    `pic_url` varchar(255) DEFAULT NULL COMMENT '图片链接',
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE INDEX `unq_banner_id`(`banner_id`) USING BTREE
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC COMMENT='内容管理-轮播图';