ghLxQZ0K

1CREATE TABLE IF NOT EXISTS `chunks` (
2`id` int(11) NOT NULL AUTO_INCREMENT,
3`start` date NOT NULL,
4`length` smallint(4) unsigned NOT NULL,
5PRIMARY KEY (`id`)
6) ENGINE=MyISAM ;
7
8
9INSERT INTO `chunks` (`id`, `start`, `length`) VALUES
10(1, '2012-01-01', 5),
11(2, '2012-05-01', 3),
12(3, '2012-01-03', 3),
13(4, '2012-01-06', 3),
14(5, '2012-01-09', 13);
15	
162012-01-01 5
172012-01-02 4
182012-01-06 3