CREATE TABLE `ci_entries` ( `id` int(200) NOT NULL auto_increment, `title` text NOT NULL, `body` text NOT NULL, `date` date NOT NULL default '0000-00-00', `author` varchar(30) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;