CREATE TABLE IF NOT EXISTS `checkbook` (
  `num` int(10) unsigned NOT NULL,
  `type` set('Deficit','Credit') NOT NULL,
  `date` date NOT NULL,
  `payee` varchar(50) NOT NULL,
  `amount` varchar(10) NOT NULL,
  `cleared` set('n','y') NOT NULL,
  `memo` text NOT NULL,
  PRIMARY KEY  (`num`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;