CREATE TABLE exp_channel_titles

CREATE TABLE `exp_channel_titles` ( `entry_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `site_id` int(4) unsigned NOT NULL DEFAULT '1', `channel_id` int(4) unsigned NOT NULL, `author_id` int(10) unsigned NOT NULL DEFAULT '0', `pentry_id` int(10) NOT NULL DEFAULT '0', `forum_topic_id` int(10) unsigned DEFAULT NULL, `ip_address` varchar(16) NOT NULL, `title` varchar(100) NOT NULL, `url_title` varchar(75) NOT NULL, `status` varchar(50) NOT NULL, `versioning_enabled` char(1) NOT NULL DEFAULT 'n', `view_count_one` int(10) unsigned NOT NULL DEFAULT '0', `view_count_two` int(10) unsigned NOT NULL DEFAULT '0', `view_count_three` int(10) unsigned NOT NULL DEFAULT '0', `view_count_four` int(10) unsigned NOT NULL DEFAULT '0', `allow_comments` varchar(1) NOT NULL DEFAULT 'y', `sticky` varchar(1) NOT NULL DEFAULT 'n', `entry_date` int(10) NOT NULL, `dst_enabled` varchar(1) NOT NULL DEFAULT 'n', `year` char(4) NOT NULL, `month` char(2) NOT NULL, `day` char(3) NOT NULL, `expiration_date` int(10) NOT NULL DEFAULT '0', `comment_expiration_date` int(10) NOT NULL DEFAULT '0', `edit_date` bigint(14) DEFAULT NULL, `recent_comment_date` int(10) DEFAULT NULL, `comment_total` int(4) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`entry_id`), KEY `channel_id` (`channel_id`), KEY `author_id` (`author_id`), KEY `url_title` (`url_title`), KEY `status` (`status`), KEY `entry_date` (`entry_date`), KEY `expiration_date` (`expiration_date`), KEY `site_id` (`site_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3933 DEFAULT CHARSET=utf8