1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
|
CREATE TABLE IF NOT EXISTS `jour` (
`idJour` int(10) unsigned NOT NULL AUTO_INCREMENT,
`idSemaine` int(10) unsigned NOT NULL DEFAULT '0',
`idAbsence` int(10) unsigned NOT NULL DEFAULT '0',
`jour` varchar(50) COLLATE utf8_bin DEFAULT NULL,
`debutHoraire` time DEFAULT NULL,
`finHoraire` time DEFAULT NULL,
`typeHoraire` varchar(45) COLLATE utf8_bin NOT NULL DEFAULT '',
`libelleJour` varchar(45) COLLATE utf8_bin NOT NULL DEFAULT '',
`indexJour` int(10) unsigned NOT NULL DEFAULT '0',
`dureeTravail` varchar(6) COLLATE utf8_bin DEFAULT NULL,
`dateJour` varchar(45) COLLATE utf8_bin DEFAULT NULL,
`mois` int(10) unsigned DEFAULT NULL,
`annee` int(10) unsigned DEFAULT NULL,
`modif` varchar(45) COLLATE utf8_bin DEFAULT NULL,
`dureeAfaire` varchar(45) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (`idJour`),
KEY `FK_jour_1` (`idSemaine`),
KEY `FK_jour_2` (`idAbsence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ; |
Partager