CREATE TABLE `thankyous` ( `id` int(10) unsigned NOT NULL auto_increment, `gift` varchar(255) NOT NULL, `household` varchar(255) NOT NULL, `gift_received` date default NULL, `thank_you_sent` date default NULL, `address` text NOT NULL, `notes` varchar(255) NOT NULL, `thank_you` text, `status` enum('Not done','Ready to write','Written','Sent','Hold') NOT NULL, PRIMARY KEY (`id`), KEY `thank_you_sent` (`thank_you_sent`), KEY `status` (`status`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1