CREATE TABLE `dateplayground` (
  `dp_name` varchar(100) NOT NULL default '',
  `dp_year` year(4) NOT NULL default '0000',
  `dp_date` date NOT NULL default '0000-00-00',
  `dp_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
  `dp_timestamp` timestamp NOT NULL default '0000-00-00 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='4 different ways to store a date in MySQL';