CREATE TABLE `webinar_tag` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
`webinar_id` int(10) unsigned NOT NULL COMMENT '活动ID',
`user_id` int(10) NOT NULL COMMENT '用户ID',
`organizers_status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '主办方信息(0:关闭 1:开启)',
`reserved_status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '版权信息(0:关闭 1:开启)',
`view_status` tinyint(1) unsigned NOT NULL COMMENT '观看端信息(0:关闭 1:开启)',
`logo_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '图片地址',
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `idx_user_id` (`user_id`),
KEY `idx_webinar_id_user_id` (`webinar_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='活动标志表'