CREATE TABLE `quiz` ( `quiz_id` int(11) NOT NULL default '0', `date_created` datetime default NULL, `last_updated` datetime default NULL, `question` varchar(255) default NULL, `answer1` text, `answer2` text, `answer3` text, `answer4` text, `correct` int(1) default NULL, `comments` text, `item_order` int(11) default NULL, PRIMARY KEY (`quiz_id`) ) TYPE=MyISAM