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 26 27 28 29 30 31 32 33
| CREATE TABLE IF NOT EXISTS `lo_travailler` (
`NUMETAB` varchar(32) NOT NULL,
`NUMDIVISION` varchar(32) NOT NULL,
`NUMELEVE` int(4) NOT NULL,
`NUMPERIODE` varchar(32) NOT NULL,
`NUMMATIERE` varchar(32) NOT NULL,
`DATETRAVAILLER` date DEFAULT NULL,
`HEUREDEBUT` time DEFAULT NULL,
`HEUREFIN` time DEFAULT NULL,
`NUMINTER` int(4) DEFAULT NULL,
PRIMARY KEY (`NUMETAB`,`NUMDIVISION`,`NUMELEVE`,`NUMPERIODE`,`NUMMATIERE`),
KEY `NUMDIVISION` (`NUMDIVISION`),
KEY `NUMELEVE` (`NUMELEVE`),
KEY `NUMPERIODE` (`NUMPERIODE`),
KEY `NUMMATIERE` (`NUMMATIERE`),
KEY `NUMETAB` (`NUMETAB`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Contenu de la table `lo_travailler`
--
INSERT INTO `lo_travailler` (`NUMETAB`, `NUMDIVISION`, `NUMELEVE`, `NUMPERIODE`, `NUMMATIERE`, `DATETRAVAILLER`, `HEUREDEBUT`, `HEUREFIN`, `NUMINTER`) VALUES
('1', '1GA1', 1, '1', '1', '0000-00-00', '00:00:00', '00:00:00', 0),
('1', '1GA1', 1, '1', '2', '0000-00-00', '00:00:00', '00:00:00', 0),
('1', '1GA1', 3, '1', '3', '0000-00-00', '00:00:00', '00:00:00', 0),
('1', '1GA1', 6, '1', '6', '0000-00-00', '00:00:00', '00:00:00', 0),
('1', '1GA1', 22, '1', '1', '0000-00-00', '00:00:00', '00:00:00', 0),
('1', '1GA1', 22, '1', '2', '0000-00-00', '00:00:00', '00:00:00', 0),
('2', 'BTSSIOUNDEUX', 793, '1', '1', '2013-09-06', '00:00:00', '00:00:00', 2),
('2', 'BTSSIOUNDEUX', 793, '1', '2', '2013-09-07', '00:00:00', '00:00:00', 8),
('2', 'BTSSIOUNDEUX', 793, '1', '6', '0000-00-00', '00:00:00', '00:00:00', 0),
('2', 'BTSSIOUNDEUX', 793, '2', '1', '0000-00-00', '00:00:00', '00:00:00', 0); |
Partager