migrate/1740108925_create_ufutx_program_adv.up.sql

10 lines
492 B
MySQL
Raw Permalink Normal View History

2025-02-21 13:35:00 +08:00
CREATE TABLE `ufutx_program_adv` (
`id` INT NOT NULL AUTO_INCREMENT ,
`pic` VARCHAR(255) NOT NULL COMMENT '图片url' ,
2025-02-21 14:57:59 +08:00
`shop_id` INT(11) DEFAULT null COMMENT '商品id' ,
2025-02-21 13:35:00 +08:00
`start_time` timestamp null default null comment "开始时间",
`end_time` timestamp null default null comment "结束时间",
`created_at` TIMESTAMP NULL DEFAULT NULL ,
`updated_at` TIMESTAMP NULL DEFAULT NULL ,
PRIMARY KEY (`id`)
) ENGINE = InnoDB COMMENT = '程序首页广告';