--Ma création de tuples de base

INSERT INTO login (login,mdp,groupe) VALUES ('aRJ','123','a');
INSERT INTO login (login,mdp,groupe) VALUES ('sSpechtLaur','123','s');
INSERT INTO login (login,mdp,groupe) VALUES ('mHouseGreg','123','m');
INSERT INTO login (login,mdp,groupe) VALUES ('pCretinLapi','123','p');

INSERT INTO specialite (nom,actif) VALUES ('Generaliste','TRUE');
INSERT INTO specialite (nom,actif) VALUES ('Dentiste','TRUE');
INSERT INTO specialite (nom,actif) VALUES ('Diagnosticien','TRUE');

INSERT INTO substance_active (nom,actif) VALUES ('Anti toux','TRUE');
INSERT INTO substance_active (nom,actif) VALUES ('Anti roux','TRUE');
INSERT INTO substance_active (nom,actif) VALUES ('Paracetamol','TRUE');
INSERT INTO substance_active (nom,actif) VALUES ('Pro roux','TRUE');
INSERT INTO substance_active (nom,actif) VALUES ('Pro coagulant','TRUE');
INSERT INTO substance_active (nom,actif) VALUES ('Anti coagulant','TRUE');
INSERT INTO substance_active (nom,actif) VALUES ('Anti dépressif','TRUE');

INSERT INTO examen (nom,actif) VALUES ('Scanner','TRUE');
INSERT INTO examen (nom,actif) VALUES ('Prise de sang','TRUE');

INSERT INTO pathologie (nom,actif) VALUES ('Toux','TRUE');
INSERT INTO pathologie (nom,actif) VALUES ('Roux','TRUE');
INSERT INTO pathologie (nom,actif) VALUES ('Migraine','TRUE');
INSERT INTO pathologie (nom,actif) VALUES ('Envie suicidaire','TRUE');
INSERT INTO pathologie (nom,actif) VALUES ('Manque de coaguation','TRUE');
INSERT INTO pathologie (nom,actif) VALUES ('Trop de coagulation','TRUE');

INSERT INTO connexion (idLogin,dateC) VALUES (1,TO_DATE('01-09-2010 09:15','DD-MM-YYYY HH24:mi'));
INSERT INTO connexion (idLogin,dateC) VALUES (2,TO_DATE('01-09-2010 09:15','DD-MM-YYYY HH24:mi'));
INSERT INTO connexion (idLogin,dateC) VALUES (3,TO_DATE('01-09-2010 09:15','DD-MM-YYYY HH24:mi'));
INSERT INTO connexion (idLogin,dateC) VALUES (4,TO_DATE('01-09-2010 09:15','DD-MM-YYYY HH24:mi'));

INSERT INTO message (idLogin,quoi,dateTraitement) VALUES (1,'inserer des tuples',SYSDATE);
INSERT INTO message (idLogin,quoi,dateTraitement) VALUES (1,'plein de tuples',SYSDATE);
INSERT INTO message (idLogin,quoi,dateTraitement) VALUES (1,'beaucoup de tuples',SYSDATE);
INSERT INTO message (idLogin,quoi) VALUES (1,'et il en faut encore !');
INSERT INTO message (idLogin,quoi) VALUES (1,'Fait pleuvoir une pluie de tuples !');

INSERT INTO administrateur (nom,prenom,rue,codePostal,ville,telephone,actif, idLogin) VALUES ('R','J','10 rue Jean-Henri Schnitzler', '67000', 'STRASBOURG', '0977459430','TRUE',1);

INSERT INTO secretaire (nom,prenom,rue,codePostal,ville,telephone,actif, idLogin) VALUES ('Specht','Laurane','12 rue de la Bruche', '67000', 'STRASBOURG', '0388124578','TRUE',2);

INSERT INTO medicament (nom,prix,estGenerique,idSubstanceActive,actif) VALUES ('Dafalgan',12,'TRUE',3,'TRUE');
INSERT INTO medicament (nom,prix,estGenerique,idSubstanceActive,actif) VALUES ('Doliprane',10,'TRUE',3,'TRUE');
INSERT INTO medicament (nom,prix,estGenerique,idSubstanceActive,actif) VALUES ('Efferalgan',15,'FALSE',3,'TRUE');
INSERT INTO medicament (nom,prix,estGenerique,idSubstanceActive,actif) VALUES ('TueTout',4,'FALSE',1,'TRUE');
INSERT INTO medicament (nom,prix,estGenerique,idSubstanceActive,actif) VALUES ('EffaceToux',8,'TRUE',1,'TRUE');
INSERT INTO medicament (nom,prix,estGenerique,idSubstanceActive,actif) VALUES ('Essence',10,'FALSE',2,'TRUE');
INSERT INTO medicament (nom,prix,estGenerique,idSubstanceActive,actif) VALUES ('Bucher',100,'TRUE',2,'TRUE');
INSERT INTO medicament (nom,prix,estGenerique,idSubstanceActive,actif) VALUES ('Teinture',100,'TRUE',4,'TRUE');
INSERT INTO medicament (nom,prix,estGenerique,idSubstanceActive,actif) VALUES ('Coagul++',20,'TRUE',5,'TRUE');
INSERT INTO medicament (nom,prix,estGenerique,idSubstanceActive,actif) VALUES ('Coagul--',20,'TRUE',6,'TRUE');
INSERT INTO medicament (nom,prix,estGenerique,idSubstanceActive,actif) VALUES ('Pastille du bonheur',35,'TRUE',7,'TRUE');

INSERT INTO incompatible_sub_sub VALUES (5,6);
INSERT INTO incompatible_sub_sub VALUES (4,7);

INSERT INTO incompatible_sub_pat VALUES (4,4);
INSERT INTO incompatible_sub_pat VALUES (5,6);
INSERT INTO incompatible_sub_pat VALUES (6,5);

INSERT INTO traitement_sub_pat VALUES (1,1);
INSERT INTO traitement_sub_pat VALUES (2,2);
INSERT INTO traitement_sub_pat VALUES (3,3);
INSERT INTO traitement_sub_pat VALUES (5,5);
INSERT INTO traitement_sub_pat VALUES (6,6);
INSERT INTO traitement_sub_pat VALUES (7,4);

INSERT INTO medecin (nom,prenom,rue,codePostal,ville,telephone,idSecretaire,idSpecialite,actif,idLogin) VALUES ('House','Gregory','2 impasse de la Lorraine', '67000', 'STRASBOURG', '0615486398', 1, 3,'TRUE',3);

INSERT INTO absence (idMedecin,debut,fin) VALUES (1,TO_DATE('30-11-2010','DD-MM-YYYY'),SYSDATE);

INSERT INTO patient (nom,prenom,dateDeNaissance,numSecu,cleSecu,rue,codePostal,ville,telephone,sexe,idMedecin,idLogin) VALUES ('Cretin','Lapin',TO_DATE('08-09-1989','DD-MM-YYYY'),'1890928085063','27','4 rue St Louis', '67000', 'STRASBOURG', '0954874851', 'Homme', 1,4);

INSERT INTO consultation (idPatient,idMedecin,rdv,duree,objet) VALUES (1,1,TO_DATE('02-01-2011 09:15','DD-MM-YYYY HH24:mi'),10,'Controle traitement stupidité');
INSERT INTO consultation (idPatient,idMedecin,rdv,duree,objet) VALUES (1,1,TO_DATE('03-01-2011 09:15','DD-MM-YYYY HH24:mi'),10,'Controle traitement stupidité');

INSERT INTO consultation_archive (idPatient,idMedecin,rdv,duree,objet) VALUES (1,1,TO_DATE('01-10-2010 09:15','DD-MM-YYYY HH24:mi'),40,'Tentative de suicide avec une banane');
INSERT INTO consultation_archive (idPatient,idMedecin,rdv,duree,objet) VALUES (1,1,TO_DATE('02-10-2010 09:30','DD-MM-YYYY HH24:mi'),45,'Tentative de suicide avec un pneu');
INSERT INTO consultation_archive (idPatient,idMedecin,rdv,duree,objet) VALUES (1,1,TO_DATE('30-11-2010 14:15','DD-MM-YYYY HH24:mi'),15,'Tentative de suicide avec une mongofière');
INSERT INTO consultation_archive (idPatient,idMedecin,rdv,duree,objet) VALUES (1,1,TO_DATE('01-01-2011 09:15','DD-MM-YYYY HH24:mi'),10,'Controle traitement stupidité : prise de sang');

INSERT INTO prescription_medicament VALUES (1,2,10);
INSERT INTO prescription_medicament VALUES (1,11,2);
INSERT INTO prescription_medicament VALUES (2,2,15);
INSERT INTO prescription_medicament VALUES (2,11,3);
INSERT INTO prescription_medicament VALUES (3,2,30);
INSERT INTO prescription_medicament VALUES (3,11,10);

INSERT INTO prescription_examen VALUES (1,1);
INSERT INTO prescription_examen VALUES (1,2);
INSERT INTO prescription_examen VALUES (2,1);
INSERT INTO prescription_examen VALUES (2,2);
INSERT INTO prescription_examen VALUES (3,1);
INSERT INTO prescription_examen VALUES (3,2);
INSERT INTO prescription_examen VALUES (4,2);

INSERT INTO atteint_de (idPrescription,idPathologie,dateDebut,dateFin) VALUES (1,3,TO_DATE('30-09-2010','DD-MM-YYYY'), TO_DATE('11-10-2010','DD-MM-YYYY'));
INSERT INTO atteint_de (idPrescription,idPathologie,dateDebut,dateFin) VALUES (1,4,TO_DATE('28-09-2010','DD-MM-YYYY'), TO_DATE('03-10-2010','DD-MM-YYYY'));
INSERT INTO atteint_de (idPrescription,idPathologie,dateDebut,dateFin) VALUES (2,3,TO_DATE('30-09-2010','DD-MM-YYYY'), TO_DATE('17-10-2010','DD-MM-YYYY'));
INSERT INTO atteint_de (idPrescription,idPathologie,dateDebut,dateFin) VALUES (2,4,TO_DATE('28-09-2010','DD-MM-YYYY'), TO_DATE('05-10-2010','DD-MM-YYYY'));
INSERT INTO atteint_de (idPrescription,idPathologie,dateDebut,dateFin) VALUES (3,3,TO_DATE('29-11-2010','DD-MM-YYYY'), TO_DATE('30-12-2010','DD-MM-YYYY'));
INSERT INTO atteint_de (idPrescription,idPathologie,dateDebut,dateFin) VALUES (3,4,TO_DATE('29-11-2010','DD-MM-YYYY'), TO_DATE('10-12-2010','DD-MM-YYYY'));