CREATE TABLE `reservations` ( `id` int(11) NOT NULL auto_increment, `start` datetime NOT NULL, `end` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `reservations` -- INSERT INTO `reservations` (`id`, `start`, `end`) VALUES (1, '2007-05-04 09:00:00', '2007-05-04 10:00:00'), (11, '2007-05-04 11:00:00', '2007-05-04 12:00:00'), (21, '2007-05-04 12:00:00', '2007-05-04 13:00:00'), (31, '2007-05-04 13:00:00', '2007-05-04 14:00:00'), (41, '2007-05-04 14:00:00', '2007-05-04 15:00:00'), (51, '2007-05-04 15:00:00', '2007-05-04 16:00:00'), (61, '2007-05-04 18:00:00', '2007-05-04 19:00:00'), (71, '2007-05-04 19:00:00', '2007-05-04 20:00:00');