CREATE TABLE `cta_ft_featured_threads` ( `thread_id` int(10) unsigned NOT NULL, `featured_title` varchar(250) NOT NULL, `featured_message` mediumtext NOT NULL, `featured_date` int(10) unsigned NOT NULL DEFAULT '0', `featured_expiry` int(10) unsigned NOT NULL, `featured_by_user_id` int(10) unsigned NOT NULL, `featured_icon_date` int(10) unsigned NOT NULL DEFAULT '0', `featured_background_date` int(10) unsigned NOT NULL DEFAULT '0', `featured_slider_background_date` int(10) unsigned NOT NULL DEFAULT '0', `featured_automatically` tinyint(3) unsigned NOT NULL DEFAULT '0', `display` tinyint(3) unsigned NOT NULL DEFAULT '0', `avatar_icon` tinyint(3) unsigned NOT NULL DEFAULT '0', `slider` tinyint(3) unsigned NOT NULL DEFAULT '0', `slider_date` int(10) unsigned NOT NULL DEFAULT '0', `dismissible` tinyint(3) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`thread_id`), KEY `featured_by_user_id` (`featured_by_user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8