INSERT INTO ROTATION (RotationId, RotationNom) VALUES (1, 'r1') ;
INSERT INTO ROTATION (RotationId, RotationNom) VALUES (2, 'r2') ;
INSERT INTO ROTATION (RotationId, RotationNom) VALUES (3, 'r3') ;
INSERT INTO ARMOIRE (RotationId, ArmoireId, ArmoireCode, ArmoireNom) VALUES (1, 1, 'a1', 'armoire 1') ;
INSERT INTO ARMOIRE (RotationId, ArmoireId, ArmoireCode, ArmoireNom) VALUES (3, 2, 'a2', 'armoire 2') ;
INSERT INTO ARMOIRE (RotationId, ArmoireId, ArmoireCode, ArmoireNom) VALUES (1, 3, 'a3', 'armoire 3') ;
INSERT INTO ARMOIRE (RotationId, ArmoireId, ArmoireCode, ArmoireNom) VALUES (3, 4, 'a4', 'armoire 4') ;
INSERT INTO ARMOIRE (RotationId, ArmoireId, ArmoireCode, ArmoireNom) VALUES (2, 5, 'a5', 'armoire 5') ;
INSERT INTO ARMOIRE (RotationId, ArmoireId, ArmoireCode, ArmoireNom) VALUES (1, 6, 'a6', 'armoire 6') ;
INSERT INTO ARMOIRE (RotationId, ArmoireId, ArmoireCode, ArmoireNom) VALUES (3, 7, 'a7', 'armoire 7') ;
INSERT INTO ARMOIRE (RotationId, ArmoireId, ArmoireCode, ArmoireNom) VALUES (3, 8, 'a8', 'armoire 8') ;
INSERT INTO ARMOIRE (RotationId, ArmoireId, ArmoireCode, ArmoireNom) VALUES (2, 9, 'a9', 'armoire 9') ;
INSERT INTO ARMOIRE (RotationId, ArmoireId, ArmoireCode, ArmoireNom) VALUES (2, 15, 'a15', 'armoire 15') ;
INSERT INTO OPERATEUR (OperateurId, OperateurCode, OperateurNom, OperateurPrenom) VALUES (1, 'p01', 'Naudin', 'Fernand') ;
INSERT INTO OPERATEUR (OperateurId, OperateurCode, OperateurNom, OperateurPrenom) VALUES (2, 'p02', 'Volfoni', 'Raoul') ;
INSERT INTO OPERATEUR (OperateurId, OperateurCode, OperateurNom, OperateurPrenom) VALUES (3, 'p03', 'Volfoni', 'Paul') ;
INSERT INTO OPERATEUR (OperateurId, OperateurCode, OperateurNom, OperateurPrenom) VALUES (4, 'p04', 'Folace', 'Francis') ;
INSERT INTO OPERATEUR (OperateurId, OperateurCode, OperateurNom, OperateurPrenom) VALUES (5, 'p05', 'Delafoy', 'Antoine') ;
INSERT INTO AFFECTATION (ArmoireId, AffectationDate, OperateurId) VALUES (1, '2015-05-05', 2) ;
INSERT INTO AFFECTATION (ArmoireId, AffectationDate, OperateurId) VALUES (3, '2015-05-05', 2) ;
INSERT INTO AFFECTATION (ArmoireId, AffectationDate, OperateurId) VALUES (6, '2015-05-05', 2) ;
INSERT INTO AFFECTATION (ArmoireId, AffectationDate, OperateurId) VALUES (5, '2015-05-05', 1) ;
INSERT INTO AFFECTATION (ArmoireId, AffectationDate, OperateurId) VALUES (9, '2015-05-05', 1) ;
INSERT INTO AFFECTATION (ArmoireId, AffectationDate, OperateurId) VALUES (15, '2015-05-05', 1) ;
INSERT INTO AFFECTATION (ArmoireId, AffectationDate, OperateurId) VALUES (1, '2015-05-06', 2) ;
INSERT INTO AFFECTATION (ArmoireId, AffectationDate, OperateurId) VALUES (2, '2015-05-06', 2) ;
INSERT INTO AFFECTATION (ArmoireId, AffectationDate, OperateurId) VALUES (3, '2015-05-06', 4) ;
INSERT INTO AFFECTATION (ArmoireId, AffectationDate, OperateurId) VALUES (6, '2015-05-06', 2) ;
INSERT INTO AFFECTATION (ArmoireId, AffectationDate, OperateurId) VALUES (5, '2015-05-06', 3) ;
INSERT INTO AFFECTATION (ArmoireId, AffectationDate, OperateurId) VALUES (9, '2015-05-06', 3) ;
INSERT INTO AFFECTATION (ArmoireId, AffectationDate, OperateurId) VALUES (15, '2015-05-06', 1) ;
INSERT INTO DOSSIER (ArmoireId, DossierDate, NbDossiersRecus, NbDossiersRenvoyes) VALUES (1, '2015-05-05', 10, 0) ;
INSERT INTO DOSSIER (ArmoireId, DossierDate, NbDossiersRecus, NbDossiersRenvoyes) VALUES (3, '2015-05-05', 30, 3) ;
INSERT INTO DOSSIER (ArmoireId, DossierDate, NbDossiersRecus, NbDossiersRenvoyes) VALUES (6, '2015-05-05', 5, 5) ;
INSERT INTO DOSSIER (ArmoireId, DossierDate, NbDossiersRecus, NbDossiersRenvoyes) VALUES (5, '2015-05-05', 7, 1) ;
INSERT INTO DOSSIER (ArmoireId, DossierDate, NbDossiersRecus, NbDossiersRenvoyes) VALUES (9, '2015-05-05', 3, 8) ;
INSERT INTO DOSSIER (ArmoireId, DossierDate, NbDossiersRecus, NbDossiersRenvoyes) VALUES (15, '2015-05-05', 9, 0) ;
INSERT INTO DOSSIER (ArmoireId, DossierDate, NbDossiersRecus, NbDossiersRenvoyes) VALUES (1, '2015-05-06', 14, 2) ;
INSERT INTO DOSSIER (ArmoireId, DossierDate, NbDossiersRecus, NbDossiersRenvoyes) VALUES (2, '2015-05-06', 4, 0) ;
INSERT INTO DOSSIER (ArmoireId, DossierDate, NbDossiersRecus, NbDossiersRenvoyes) VALUES (3, '2015-05-06', 0, 0) ;
INSERT INTO DOSSIER (ArmoireId, DossierDate, NbDossiersRecus, NbDossiersRenvoyes) VALUES (6, '2015-05-06', 7, 7) ;
INSERT INTO DOSSIER (ArmoireId, DossierDate, NbDossiersRecus, NbDossiersRenvoyes) VALUES (5, '2015-05-06', 4, 2) ;
INSERT INTO DOSSIER (ArmoireId, DossierDate, NbDossiersRecus, NbDossiersRenvoyes) VALUES (9, '2015-05-06', 3, 3) ;
INSERT INTO DOSSIER (ArmoireId, DossierDate, NbDossiersRecus, NbDossiersRenvoyes) VALUES (15, '2015-05-06', 1, 0) ;
Partager