1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
|
CREATE TABLE IF NOT EXISTS `planning` (
`id` smallint(6) NOT NULL auto_increment,
`maj` datetime NOT NULL default '0000-00-00 00:00:00',
`journee` date NOT NULL default '0000-00-00',
`employe` enum('Bernard','Michel') NOT NULL default 'Bernard',
`valeur` enum('-','Matin','Soir','Conge') default '-',
PRIMARY KEY (`id`)
) ;
INSERT INTO `planning` (`id`, `maj`, `journee`, `employe`, `valeur`) VALUES(1, '2012-10-16 12:43:17', '2012-09-01', 'Bernard', 'Matin');
INSERT INTO `planning` (`id`, `maj`, `journee`, `employe`, `valeur`) VALUES(2, '2012-10-19 12:43:17', '2012-09-01', 'Bernard', 'Soir');
INSERT INTO `planning` (`id`, `maj`, `journee`, `employe`, `valeur`) VALUES(3, '2012-10-20 12:43:17', '2012-09-01', 'Bernard', 'Conge');
INSERT INTO `planning` (`id`, `maj`, `journee`, `employe`, `valeur`) VALUES(4, '2012-10-18 12:43:17', '2012-09-01', 'Bernard', '-');
INSERT INTO `planning` (`id`, `maj`, `journee`, `employe`, `valeur`) VALUES(5, '2012-10-21 12:43:17', '2012-09-01', 'Michel', 'Conge');
INSERT INTO `planning` (`id`, `maj`, `journee`, `employe`, `valeur`) VALUES(6, '2012-10-20 12:43:17', '2012-09-01', 'Michel', 'Soir');
INSERT INTO `planning` (`id`, `maj`, `journee`, `employe`, `valeur`) VALUES(7, '2012-10-18 12:43:17', '2012-09-01', 'Michel', 'Matin');
INSERT INTO `planning` (`id`, `maj`, `journee`, `employe`, `valeur`) VALUES(8, '2012-10-19 12:43:17', '2012-09-01', 'Michel', '-');
INSERT INTO `planning` (`id`, `maj`, `journee`, `employe`, `valeur`) VALUES(9, '2012-10-15 12:43:17', '2012-09-02', 'Bernard', 'Matin');
INSERT INTO `planning` (`id`, `maj`, `journee`, `employe`, `valeur`) VALUES(10, '2012-10-14 12:43:17', '2012-09-02', 'Bernard', 'Soir');
INSERT INTO `planning` (`id`, `maj`, `journee`, `employe`, `valeur`) VALUES(11, '2012-10-14 12:43:17', '2012-09-02', 'Michel', 'Soir');
INSERT INTO `planning` (`id`, `maj`, `journee`, `employe`, `valeur`) VALUES(12, '2012-10-15 12:43:17', '2012-09-02', 'Michel', 'Matin'); |
Partager