video_server/storage/sql/inc/chuji_inc_20220515.sql

CREATE TABLE `bulletin` (
                            `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
                            `title` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '公告标题',
                            `status` tinyint unsigned NOT NULL DEFAULT '1' COMMENT '公告状态,1开,2关',
                            `sort` int unsigned NOT NULL DEFAULT '99' COMMENT '排序',
                            `device` tinyint unsigned NOT NULL DEFAULT '1' COMMENT '设备,1.安卓,2.ios,3.所有端',
                            `start_time` datetime NOT NULL COMMENT '开始时间',
                            `end_time` datetime NOT NULL COMMENT '结束时间',
                            `created_at` datetime DEFAULT NULL COMMENT '创建时间',
                            `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
                            `deleted_at` datetime DEFAULT NULL COMMENT '删除时间',
                            `text` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '文本内容',
                            PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='公告管理';