Support Forum

CREATE TABLE `xxx_sftopics` (
 `topic_id` bigint(20) NOT NULL AUTO_INCREMENT,
 `topic_name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
 `topic_date` datetime NOT NULL,
 `topic_status` int(4) NOT NULL DEFAULT '0',
 `forum_id` bigint(20) NOT NULL,
 `user_id` bigint(20) unsigned DEFAULT NULL,
 `topic_pinned` smallint(1) NOT NULL DEFAULT '0',
 `topic_opened` bigint(20) NOT NULL DEFAULT '0',
 `blog_post_id` bigint(20) NOT NULL DEFAULT '0',
 `topic_slug` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
 `post_id` bigint(20) DEFAULT NULL,
 `post_count` mediumint(8) DEFAULT '0',
 `topic_status_flag` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 `post_id_held` bigint(20) DEFAULT NULL,
 `post_count_held` mediumint(8) DEFAULT '0',
 `answered` bigint(20) NOT NULL DEFAULT '0',
 `expire_date` datetime DEFAULT NULL,
 `expire_action` int(4) NOT NULL DEFAULT '0',
 PRIMARY KEY (`topic_id`),
 KEY `forum_id_idx` (`forum_id`),
 KEY `topic_slug_idx` (`topic_slug`),
 KEY `user_id_idx` (`user_id`),
 KEY `post_id_idx` (`post_id`),
 KEY `topic_status_flag_idx` (`topic_status_flag`),
 KEY `expire_date_idx` (`expire_date`)
) ENGINE=MyISAM AUTO_INCREMENT=22840 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;