REM **********************************************************************
REM Script ORACLE d'insertion des données de la base SEMINAR
REM Auteur : Fessy Jerome
REM **********************************************************************

CREATE SEQUENCE Seqanimateur start with 10;

REM INSERTION dans la table theme

insert into theme (Idtheme,libelleTheme) values (1, 'Bases de Données');
insert into theme (Idtheme,libelleTheme) values (2,'Réseau');
insert into theme (Idtheme,libelleTheme) values (3,'Internet');
insert into theme (Idtheme,libelleTheme) values (4,'Programmation');
insert into theme (Idtheme,libelleTheme) values (5,'Architecture');
insert into theme (Idtheme,libelleTheme) values (6,'Maintenance');

REM  INSERTION dans la table Animateur

insert into animateur (Idanim,NomAnim, PrenomAnim) values (1,'Valant','Pierre');
insert into animateur (Idanim,NomAnim, PrenomAnim) values (2,'Erlon','Lucy');
insert into animateur (Idanim,NomAnim, PrenomAnim) values (3,'Passini','Jacques');
insert into animateur (Idanim,NomAnim, PrenomAnim) values (4,'Larcoux','Edouard');
insert into animateur (Idanim,NomAnim, PrenomAnim) values (5,'Talinu','Marc');
insert into animateur (Idanim,NomAnim, PrenomAnim) values (6,'Armandi','Maëlle');

REM INSERTION dans la table Societe 

insert into societe (Idsociete,RaisonSociale, Adresse, Ville, CP, Email)
values (1,'EDF', '12 rue de la Pierre', 'Paris', '75013', 'Elian@edf.fr');
insert into societe (Idsociete,RaisonSociale, Adresse, Ville, CP, Email)
values (2,'Soleo', '4 rue de la liberté', 'Longues sur Mer', '14400', 'Soleo@soleo.fr');
insert into societe (Idsociete,RaisonSociale, Adresse, Ville, CP, Email)
values (3,'IOS', '3 Place Vendome', 'Anthony', '92200', 'fme@ios.fr');
insert into societe (Idsociete,RaisonSociale, Adresse, Ville, CP, Email)
values (4,'Placo', '17 Avenue Leclerc', 'Corbreuse', '91300', 'Placo@free.fr');
insert into societe (Idsociete,RaisonSociale, Adresse, Ville, CP, Email)
values (5,'Arcano', '2 chemin du Home', 'Corbreuse', '91300', 'Arcono@wanadoo.fr');


REM INSERTION dans la table Seminaire REM


insert into seminaire (Idsem, IntituleSem, DateSem, PrixSem, IdTheme, IdSemConseille, NbrePlaceMax)
values (1,'PostgreSQL Developpeur', '12/06/2018', 75, 1, NULL, 19);
insert into seminaire (Idsem,IntituleSem, DateSem, PrixSem, IdTheme, IdSemConseille, NbrePlaceMax)
values (2,'Oracle Admistrateur', '29/07/2018', 170,1, NULL, 20);
insert into seminaire (Idsem,IntituleSem, DateSem, PrixSem, IdTheme, IdSemConseille, NbrePlaceMax)
values (3,'Informix Developpeur', '31/07/2018', 150, 1, NULL, 20);
insert into seminaire (Idsem,IntituleSem, DateSem, PrixSem, IdTheme, IdSemConseille, NbrePlaceMax)
values (4,'PostgreSQL Administrateur', '19/06/2018', 120, 1, 1, 19);
insert into seminaire (Idsem,IntituleSem, DateSem, PrixSem, IdTheme, IdSemConseille, NbrePlaceMax)
values (5,'PHP', '05/07/2018', NULL , 3, NULL, 15);

REM INSERTION dans la table Intervention

insert into intervention (idAnim, IdSem, DureeInter, OrdrePassage)
values(1,2,3, 1);
insert into intervention (idAnim, IdSem, DureeInter, OrdrePassage)
values(1,4,3, 1);
insert into intervention (idAnim, IdSem, DureeInter, OrdrePassage)
values(2,1,3, 1);
insert into intervention (idAnim, IdSem, DureeInter, OrdrePassage)
values(3,1,3, 2);
insert into intervention (idAnim, IdSem, DureeInter, OrdrePassage)
values(1,5,3, 1);
insert into intervention (idAnim, IdSem, DureeInter, OrdrePassage)
values(1,3,2, 1);
insert into intervention (idAnim, IdSem, DureeInter, OrdrePassage)
values(2,3,1, 2);
insert into intervention (idAnim, IdSem, DureeInter, OrdrePassage)
values(3,3,1, 3);
insert into intervention (idAnim, IdSem, DureeInter, OrdrePassage)
values(4,3,1, 4);
insert into intervention (idAnim, IdSem, DureeInter, OrdrePassage)
values(5,3,1, 5);

REM INSERTION dans la table Inscription 


insert into inscription (IdSociete, Idsem, NbrePlace, DateInscription)
values (1, 1, 2, '12/05/2018');
insert into inscription (IdSociete, Idsem, NbrePlace, DateInscription)
values (1, 2, 1, '17/06/2018');
insert into inscription (IdSociete, Idsem, NbrePlace, DateInscription)
values (1, 3, 5, '7/06/2018');
insert into inscription (IdSociete, Idsem, NbrePlace, DateInscription)
values (2, 2, 10, '1/07/2018');
insert into inscription (IdSociete, Idsem, NbrePlace, DateInscription)
values (2, 3, 4, '12/07/2018');
insert into inscription (IdSociete, Idsem, NbrePlace, DateInscription)
values (2, 5, 1, '12/05/2018');
insert into inscription (IdSociete, Idsem, NbrePlace, DateInscription)
values (2, 1, 1, '11/05/2018');
insert into inscription (IdSociete, Idsem, NbrePlace, DateInscription)
values (3, 3, 3, '29/05/2018');
insert into inscription (IdSociete, Idsem, NbrePlace, DateInscription)
values (4, 4, 10, '19/05/2018');
insert into inscription (IdSociete, Idsem, NbrePlace, DateInscription)
values (5, 5, 4, '2/07/2018');
insert into inscription (IdSociete, Idsem, NbrePlace, DateInscription)
values (5, 1, 6, '1/05/2018');

COMMIT;