-- version 0.1
BEGIN TRANSACTION;
DROP TABLE Patients;
DROP TABLE Prescriptions;
DROP TABLE Caisses;
DROP TABLE PeriodesCaisses;
DROP TABLE Mutuelles;
DROP TABLE Parametres;
DROP TABLE Seances;
DROP TABLE Medias;
CREATE TABLE "Caisses" ("Id" INTEGER PRIMARY KEY  NOT NULL,"IdPatient" INTEGER NOT NULL,"Libelle" VARCHAR,"Numero" VARCHAR );
CREATE TABLE "Medias" ("Id" INTEGER PRIMARY KEY  NOT NULL,"IdPrescription" INTEGER NOT NULL  DEFAULT (0),"IdPatient" INTEGER NOT NULL  DEFAULT (0),"Type" VARCHAR,"Commentaire" VARCHAR,"Fichier" TEXT,"Date" DATETIME,"Dechargement" INTEGER NOT NULL DEFAULT 0);
CREATE TABLE "Parametres" ("Id" INTEGER PRIMARY KEY  AUTOINCREMENT  NOT NULL, "VersionSQLScript" VARCHAR,"DernierTransfert" DATETIME,"NomPS" VARCHAR,"NumeroPS" VARCHAR, "NomLogiciel" VARCHAR );
CREATE TABLE "Patients" ("Id" INTEGER PRIMARY KEY  NOT NULL  DEFAULT (0),"Nom" VARCHAR NOT NULL,"Prenom" VARCHAR NOT NULL,"DateNaissance" VARCHAR,"NumSecu" VARCHAR,"TelephoneFixe" VARCHAR,"TelephoneMobile" VARCHAR,"Adresse" VARCHAR,"CodePostal" VARCHAR,"Ville" VARCHAR,"Note" TEXT,"AlerteMessage" TEXT,"AlerteStatut" VARCHAR,"SoldeDu" FLOAT, "Editable" INTEGER NOT NULL  DEFAULT 0,"Modification" INTEGER NOT NULL DEFAULT 0,"Dechargement" INTEGER NOT NULL DEFAULT 0,"AlerteLogicielle" VARCHAR);
CREATE TABLE "PeriodesCaisses" ("Id" INTEGER PRIMARY KEY  NOT NULL ,"IdCaisse" INTEGER NOT NULL ,"DateLibelle" VARCHAR);
CREATE TABLE "Prescriptions" ("Id" INTEGER PRIMARY KEY  NOT NULL  DEFAULT (0),"IdPatient" INTEGER NOT NULL,"DatePrescription" VARCHAR,"DateEntente" VARCHAR,"FinTraitement" DATETIME,"NombreSeances" INTEGER,"Description" TEXT,"Cotation" VARCHAR,"NomPrescripteur" VARCHAR,"TelephonePrescripteur" VARCHAR,"Note" TEXT,"SeancesFacturees" INTEGER,"NumFacturation" VARCHAR );
CREATE TABLE "Seances" ("Id" INTEGER PRIMARY KEY  NOT NULL,"IdPrescription" INTEGER NOT NULL  DEFAULT (0),"Date" DATETIME,"Lieu" VARCHAR,"Cotation" VARCHAR,"Libelle" VARCHAR,"Numero" INTEGER,"Note" TEXT,"AlerteMessage" TEXT,"AlerteStatut" VARCHAR,"Annulation" VARCHAR NOT NULL  DEFAULT non,"Dechargement" INTEGER NOT NULL DEFAULT 0 );
CREATE TABLE "Mutuelles"("Id" INTEGER PRIMARY KEY  NOT NULL,"IdPatient" INTEGER NOT NULL,"Libelle" VARCHAR,"Numero" VARCHAR,"DateDebut" DATETIME,"DateFin" DATETIME,"Origine" VARCHAR );

INSERT INTO Parametres(VersionSQLScript, DernierTransfert, NomPS, NumeroPS, NomLogiciel) VALUES('0.1','2013-06-19','PANSEMENT Reine','996050407','Infimax');

INSERT INTO Patients(Id, Nom, Prenom, DateNaissance, NumSecu, TelephoneFixe, TelephoneMobile, Adresse, CodePostal, Ville, Note, SoldeDu,AlerteLogicielle) VALUES(624,"ESSAI","Alain",'01/01/1942','1 42 19 62 965 165 96','','',"",'',"","13/05/2013 : Toto",0.00,"13/05/2013 : Toto");
INSERT INTO Patients(Id, Nom, Prenom, DateNaissance, NumSecu, TelephoneFixe, TelephoneMobile, Adresse, CodePostal, Ville, Note, SoldeDu,AlerteLogicielle) VALUES(307,"STASI","Pierre",'09/04/1974','1 74 04 68 224 144 07','','06-32-82-96-22',"2, rue de Besanon",'67100',"STRASBOURG","Le patient vous doit la somme de 25.20  :
Il reste 25.20  rgler pour la FSE du 22/03/2013.",25.20,"");
INSERT INTO Patients(Id, Nom, Prenom, DateNaissance, NumSecu, TelephoneFixe, TelephoneMobile, Adresse, CodePostal, Ville, Note, SoldeDu,AlerteLogicielle) VALUES(341,"ZEZIOLA","Christine",'13/04/1971','2 71 04 99 350 486 92','03-88-55-22-66','06-12-34-16-94',"26 RUE DE LA DIVISION LECLERC",'67120',"KOLBSHEIM","",0.00,"");
INSERT INTO Patients(Id, Nom, Prenom, DateNaissance, NumSecu, TelephoneFixe, TelephoneMobile, Adresse, CodePostal, Ville, Note, SoldeDu,AlerteLogicielle) VALUES(66,"VIDOT","Joelle",'20/12/1951','2 51 12 88 511 001 62','','',"12 RUE DES CARPEAUX",'67200',"STRASBOURG","",0.00,"");
INSERT INTO Patients(Id, Nom, Prenom, DateNaissance, NumSecu, TelephoneFixe, TelephoneMobile, Adresse, CodePostal, Ville, Note, SoldeDu,AlerteLogicielle) VALUES(526,"TABACHNIKOFF","Pjotr",'04/08/1998','2 66 05 99 404 185 04','','06-45-48-90-91',"16, rue Fischart",'67000',"STRASBOURG","",0.00,"");
INSERT INTO Patients(Id, Nom, Prenom, DateNaissance, NumSecu, TelephoneFixe, TelephoneMobile, Adresse, CodePostal, Ville, Note, SoldeDu,AlerteLogicielle) VALUES(574,"SEEWALD","Christine",'19/04/1971','2 71 04 67 482 497 89','','',"",'',"","",0.00,"");
INSERT INTO Patients(Id, Nom, Prenom, DateNaissance, NumSecu, TelephoneFixe, TelephoneMobile, Adresse, CodePostal, Ville, Note, SoldeDu,AlerteLogicielle) VALUES(74,"WISTRAND","Nathan",'24/07/1999','1 58 01 99 352 312 69','','',"5 place de l'edit de nantes",'',"","",0.00,"");
INSERT INTO Patients(Id, Nom, Prenom, DateNaissance, NumSecu, TelephoneFixe, TelephoneMobile, Adresse, CodePostal, Ville, Note, SoldeDu,AlerteLogicielle) VALUES(264,"UMBRECHT","Veronique",'21/01/1967','2 67 01 68 224 270 29','03-88-83-29-85','06-52-17-89-35',"2-4 Boulevard de Launay",'44100',"NANTES","",0.00,"");
INSERT INTO Patients(Id, Nom, Prenom, DateNaissance, NumSecu, TelephoneFixe, TelephoneMobile, Adresse, CodePostal, Ville, Note, SoldeDu,AlerteLogicielle) VALUES(383,"STAUBER","Danielle",'04/09/1947','2 47 09 24 322 005 38','','06-72-90-31-83',"10, rue Jacques Peirtoes",'67000',"STRASBOURG","",0.00,"");
INSERT INTO Patients(Id, Nom, Prenom, DateNaissance, NumSecu, TelephoneFixe, TelephoneMobile, Adresse, CodePostal, Ville, Note, SoldeDu,AlerteLogicielle) VALUES(129,"ZOBY","Lll",'','0 00 00 00 000 000 00','','',"",'',"","",0.00,"");
INSERT INTO Patients(Id, Nom, Prenom, DateNaissance, NumSecu, TelephoneFixe, TelephoneMobile, Adresse, CodePostal, Ville, Note, SoldeDu,AlerteLogicielle) VALUES(299,"URY","Daniel",'23/05/1964','1 64 05 67 482 529 78','03-88-93-93-28','',"72 GRAND RUE",'67500',"HAGUENAU","",0.00,"");
INSERT INTO Patients(Id, Nom, Prenom, DateNaissance, NumSecu, TelephoneFixe, TelephoneMobile, Adresse, CodePostal, Ville, Note, SoldeDu,AlerteLogicielle) VALUES(188,"STUBER","Martine",'26/12/1966','2 66 12 67 482 578 90','','06-83-23-62-12',"",'',"","",0.00,"");
INSERT INTO Patients(Id, Nom, Prenom, DateNaissance, NumSecu, TelephoneFixe, TelephoneMobile, Adresse, CodePostal, Ville, Note, SoldeDu,AlerteLogicielle) VALUES(104,"SEGRESTAIN","Raphael",'','0 00 00 00 000 000 00','','',"2 bd de launay",'',"","",0.00,"");
INSERT INTO Patients(Id, Nom, Prenom, DateNaissance, NumSecu, TelephoneFixe, TelephoneMobile, Adresse, CodePostal, Ville, Note, SoldeDu,AlerteLogicielle) VALUES(641,"ISQUIERDO","Sbastien ",'04/10/1976','0 00 00 00 000 000 00','0240694651','0681828385',"BOUSSAY ",'44190',"BOUSSAY ","28/05/2013 : ville?

28/05/2013 : 44190

 ",0.00,"28/05/2013 : ville? -  - ...");
INSERT INTO Caisses(Id, IdPatient, Libelle, Numero) VALUES (1,624,"CPAM Flux  destination du serveur CNDA","01 349 9881");
INSERT INTO Caisses(Id, IdPatient, Libelle, Numero) VALUES (2,307,"CPAM du Bas-Rhin","01 673 0000");
INSERT INTO Caisses(Id, IdPatient, Libelle, Numero) VALUES (3,341,"Mutuelle de l Est","99 673 0689");
INSERT INTO Caisses(Id, IdPatient, Libelle, Numero) VALUES (4,66,"Mutuelle de l Est","99 673 0689");
INSERT INTO Caisses(Id, IdPatient, Libelle, Numero) VALUES (5,526,"CPAM du Bas-Rhin","01 673 0000");
INSERT INTO Caisses(Id, IdPatient, Libelle, Numero) VALUES (6,574,"CPAM du Bas-Rhin","01 673 0000");
INSERT INTO Caisses(Id, IdPatient, Libelle, Numero) VALUES (7,74,"CPAM du Bas-Rhin","01 673 0000");
INSERT INTO Caisses(Id, IdPatient, Libelle, Numero) VALUES (8,264,"CPAM du Bas-Rhin","01 673 0000");
INSERT INTO Caisses(Id, IdPatient, Libelle, Numero) VALUES (9,383,"CPAM du Bas-Rhin","01 673 0000");
INSERT INTO Caisses(Id, IdPatient, Libelle, Numero) VALUES (10,299,"R.A.M. (ALSACE)","03 003 1100");
INSERT INTO Caisses(Id, IdPatient, Libelle, Numero) VALUES (11,188,"CPAM du Bas-Rhin","01 673 0000");
INSERT INTO Caisses(Id, IdPatient, Libelle, Numero) VALUES (12,641,"CPAM de Loire-Atlantique","01 441 0000");
INSERT INTO PeriodesCaisses(Id, IdCaisse, DateLibelle) VALUES (1,1,'Droits jusqu''au 03/10/1964');
INSERT INTO PeriodesCaisses(Id, IdCaisse, DateLibelle) VALUES (2,1,'Exonr du 04/10/1964 au 31/12/2002');
INSERT INTO PeriodesCaisses(Id, IdCaisse, DateLibelle) VALUES (3,1,'Droits  partir du 01/01/2003');
INSERT INTO PeriodesCaisses(Id, IdCaisse, DateLibelle) VALUES (4,3,'Droits du 23/01/2008 au 31/12/2012');
INSERT INTO PeriodesCaisses(Id, IdCaisse, DateLibelle) VALUES (5,4,'Droits du 26/03/2008 au 31/12/2012');
INSERT INTO PeriodesCaisses(Id, IdCaisse, DateLibelle) VALUES (6,5,'Droits jusqu''au 10/01/2010');
INSERT INTO PeriodesCaisses(Id, IdCaisse, DateLibelle) VALUES (7,5,'Droits du 11/01/2010 au 28/02/2013');
INSERT INTO PeriodesCaisses(Id, IdCaisse, DateLibelle) VALUES (8,6,'Droits jusqu''au 31/07/1991');
INSERT INTO PeriodesCaisses(Id, IdCaisse, DateLibelle) VALUES (9,6,'Droits du 01/08/1991 au 30/09/2013');
INSERT INTO PeriodesCaisses(Id, IdCaisse, DateLibelle) VALUES (10,7,'Droits jusqu''au 30/09/1983');
INSERT INTO PeriodesCaisses(Id, IdCaisse, DateLibelle) VALUES (11,7,'Droits  partir du 01/10/1983');
INSERT INTO PeriodesCaisses(Id, IdCaisse, DateLibelle) VALUES (12,8,'Droits jusqu''au 31/08/1999');
INSERT INTO PeriodesCaisses(Id, IdCaisse, DateLibelle) VALUES (13,8,'Droits du 01/09/1999 au 31/12/2012');
INSERT INTO PeriodesCaisses(Id, IdCaisse, DateLibelle) VALUES (14,9,'Droits jusqu''au 18/10/1993');
INSERT INTO PeriodesCaisses(Id, IdCaisse, DateLibelle) VALUES (15,9,'Droits du 19/10/1993 au 30/09/2012');
INSERT INTO PeriodesCaisses(Id, IdCaisse, DateLibelle) VALUES (16,11,'Droits jusqu''au 31/05/1998');
INSERT INTO PeriodesCaisses(Id, IdCaisse, DateLibelle) VALUES (17,11,'Droits du 01/06/1998 au 31/10/2012');
INSERT INTO Mutuelles(Id, IdPatient, Libelle, Numero, DateDebut, DateFin, Origine) VALUES(1,66,"Mutuelle n 67990333","67990333",'2012-03-01','2012-12-31','Carte Vitale');
INSERT INTO Mutuelles(Id, IdPatient, Libelle, Numero, DateDebut, DateFin, Origine) VALUES(2,641,"ACORIS MUTUELLES","0780004099",'2010-01-01','2015-12-12','Attestation papier');

INSERT INTO Prescriptions(Id, IdPatient, DatePrescription, DateEntente, FinTraitement, NombreSeances, Description, Cotation, NomPrescripteur, TelephonePrescripteur, Note, SeancesFacturees,NumFacturation) VALUES(813,66,'2013-05-02','','2013-06-02',10,"AMI 3 Changement de sonde urinaire (femme)"," 10 AMI 3","DR ARNOULD Claude","","",0,"671026557");
INSERT INTO Prescriptions(Id, IdPatient, DatePrescription, DateEntente, FinTraitement, NombreSeances, Description, Cotation, NomPrescripteur, TelephonePrescripteur, Note, SeancesFacturees,NumFacturation) VALUES(816,74,'2013-05-09','','2013-05-22',10,"AMI 3 Changement de sonde urinaire (femme)"," 10 AMI 3","DR ACHILLE Mihaela","","",0,"671701621");
INSERT INTO Prescriptions(Id, IdPatient, DatePrescription, DateEntente, FinTraitement, NombreSeances, Description, Cotation, NomPrescripteur, TelephonePrescripteur, Note, SeancesFacturees,NumFacturation) VALUES(822,104,'2013-05-22','','2013-06-22',70,"AMI 1 Lecture d'un timbre tuberculinique et ..."," 70 AMI 1","DR WOLFF Jean-Marc","03-89-68-67-03","",0,"681027926");
INSERT INTO Prescriptions(Id, IdPatient, DatePrescription, DateEntente, FinTraitement, NombreSeances, Description, Cotation, NomPrescripteur, TelephonePrescripteur, Note, SeancesFacturees,NumFacturation) VALUES(819,129,'2013-05-27','','2013-06-27',27,"AIS 3 Sance de soins infirmiers  domicile (hygine ..."," 27 AIS 3","DR ADAM-ABERGEL Simone-Sophie","03-88-61-95-95","La DAP n'a pas encore t envoye?",0,"671060887");
INSERT INTO Prescriptions(Id, IdPatient, DatePrescription, DateEntente, FinTraitement, NombreSeances, Description, Cotation, NomPrescripteur, TelephonePrescripteur, Note, SeancesFacturees,NumFacturation) VALUES(821,188,'2013-05-15','','2013-06-27',27,"AMI 4 Cathtrisme urtral chez l'homme"," 27 AMI 4","DR CREPS ","03-88-10-47-78","",0,"670014935");
INSERT INTO Prescriptions(Id, IdPatient, DatePrescription, DateEntente, FinTraitement, NombreSeances, Description, Cotation, NomPrescripteur, TelephonePrescripteur, Note, SeancesFacturees,NumFacturation) VALUES(817,264,'2013-05-11','','2013-05-29',8,"AMI 5 Injection d'un srum d'origine humaine ou..."," 8 AMI 5","DR BADINA JEAN FRANCOIS ","","",0,"671024164");
INSERT INTO Prescriptions(Id, IdPatient, DatePrescription, DateEntente, FinTraitement, NombreSeances, Description, Cotation, NomPrescripteur, TelephonePrescripteur, Note, SeancesFacturees,NumFacturation) VALUES(820,299,'2013-05-27','','2013-06-27',14,"AMI 1 + AMI 1 Surveillance d'un patient insulino-dpendant ... - AMI 1 Administration d'une thrapeut... (premier mois)"," 14 AMI 1 + AMI 1","DR BENSOUSSAN Marc","03-88-22-12-52","",0,"671032589");
INSERT INTO Prescriptions(Id, IdPatient, DatePrescription, DateEntente, FinTraitement, NombreSeances, Description, Cotation, NomPrescripteur, TelephonePrescripteur, Note, SeancesFacturees,NumFacturation) VALUES(810,307,'2013-03-21','','2013-03-28',7,"AMI 3 Changement de sonde urinaire (femme) - AMI 2 Injection intraveineuse directe chez un enfant... - AMI 1 Injection intramusculaire - AMI 1.5 Prlvement par ponction veineuse directe"," 6 AMI 3   6 AMI 2   6 AMI 1.5   1 AMI 1","DR ALOIRD Jean-Claude","","",2,"671050094");
INSERT INTO Prescriptions(Id, IdPatient, DatePrescription, DateEntente, FinTraitement, NombreSeances, Description, Cotation, NomPrescripteur, TelephonePrescripteur, Note, SeancesFacturees,NumFacturation) VALUES(812,341,'2013-05-02','','2013-05-13',10,"AMI 5 Saigne"," 10 AMI 5","DR ABESSERA Isaac","03-88-32-29-30","",0,"671047868");
INSERT INTO Prescriptions(Id, IdPatient, DatePrescription, DateEntente, FinTraitement, NombreSeances, Description, Cotation, NomPrescripteur, TelephonePrescripteur, Note, SeancesFacturees,NumFacturation) VALUES(818,383,'2013-05-13','','2013-05-27',8,"AMI 5 Ponction artrielle percutane"," 8 AMI 5","DR BENSOUSSAN Marc","03-88-22-12-52","",0,"671032589");
INSERT INTO Prescriptions(Id, IdPatient, DatePrescription, DateEntente, FinTraitement, NombreSeances, Description, Cotation, NomPrescripteur, TelephonePrescripteur, Note, SeancesFacturees,NumFacturation) VALUES(814,526,'2013-05-02','','2013-05-09',5,"AMI 4 Pansements de brlure tendue... - AMI 4.5 Radaptation de vessie neurologique... - AMI 1.25 + AMI 4 + AMI 4.5 Pulvrisation de produits mdicamenteux"," 5 AMI 1.25 + AMI 4 + AMI 4.5","DR BENSOUSSAN Marc","03-88-22-12-52","",0,"671032589");
INSERT INTO Prescriptions(Id, IdPatient, DatePrescription, DateEntente, FinTraitement, NombreSeances, Description, Cotation, NomPrescripteur, TelephonePrescripteur, Note, SeancesFacturees,NumFacturation) VALUES(815,574,'2013-05-02','','2013-05-03',8,"AMI 4 Cathtrisme urtral chez l'homme"," 8 AMI 4","DR ACHILLE Mihaela","","",0,"671701621");
INSERT INTO Prescriptions(Id, IdPatient, DatePrescription, DateEntente, FinTraitement, NombreSeances, Description, Cotation, NomPrescripteur, TelephonePrescripteur, Note, SeancesFacturees,NumFacturation) VALUES(807,624,'2013-03-21','','2013-03-21',1,"AMI 2 Injection intraveineuse directe chez un enfant..."," 1 AMI 2","DR ALOIRD Jean-Claude","","",0,"671050094");
INSERT INTO Prescriptions(Id, IdPatient, DatePrescription, DateEntente, FinTraitement, NombreSeances, Description, Cotation, NomPrescripteur, TelephonePrescripteur, Note, SeancesFacturees,NumFacturation) VALUES(823,641,'2013-05-28','','2013-06-18',20,"AIS 3 + AMI 1 + AMI 2 (Gratuit) + AMI 4 (Gratuit)  Sances de soins infirmiers - AMI 1 Injection sous-cutane d'insuline - AMI 2 (Gratuit) Autre pansement - AMI 4 (Gratuit) Pansement chirurgical ncessitant un mchage ou... - AMI 6 (Gratuit) Supplment forfaitaire  surveillance perfusion..."," 20 AIS 3 + AMI 1 + AMI 2 (Gratuit) + AMI 4 (Gratuit) + AMI 6 (Gratuit)","DR BAEHREL Yvan","03-88-74-68-69","La DAP n'a pas encore t envoye?
Ce traitement renouvelable se termine le 18/06/2013.",0,"671084937");

INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13571,822,'2013-06-12 - 08:00','Domicile','AMI 1','',41,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13462,819,'2013-06-12 - 10:00','Cabinet','AIS 3','',15,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13572,822,'2013-06-12 - 12:00','Domicile','AMI 1','',42,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13878,820,'2013-06-12 - 15:25','Cabinet','AMI 1 + AMI 1','',10,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13518,821,'2013-06-12 - 16:20','Cabinet','AMI 4','',15,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13573,822,'2013-06-12 - 22:00','Domicile','AMI N 1','',43,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13574,822,'2013-06-13 - 08:00','Domicile','AMI 1','',44,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13463,819,'2013-06-13 - 10:00','Cabinet','AIS 3','',16,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13575,822,'2013-06-13 - 12:00','Domicile','AMI 1','',45,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13519,821,'2013-06-13 - 16:20','Cabinet','AMI 4','',16,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13576,822,'2013-06-13 - 22:00','Domicile','AMI N 1','',46,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13577,822,'2013-06-14 - 08:00','Domicile','AMI 1','',47,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13464,819,'2013-06-14 - 10:00','Cabinet','AIS 3','',17,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13578,822,'2013-06-14 - 12:00','Domicile','AMI 1','',48,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13879,820,'2013-06-14 - 15:25','Cabinet','AMI 1 + AMI 1','',11,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13520,821,'2013-06-14 - 16:20','Cabinet','AMI 4','',17,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13579,822,'2013-06-14 - 22:00','Domicile','AMI N 1','',49,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13580,822,'2013-06-15 - 08:00','Domicile','AMI 1','',50,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13465,819,'2013-06-15 - 10:00','Cabinet','AIS 3','',18,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13581,822,'2013-06-15 - 12:00','Domicile','AMI 1','',51,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13521,821,'2013-06-15 - 16:20','Cabinet','AMI 4','',18,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13582,822,'2013-06-15 - 22:00','Domicile','AMI N 1','',52,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13716,823,'2013-06-16 - 10:00','Domicile','AIS F 3 + AMI 1 + AMI 2 (G) + AMI 4 (G) + AMI 6 (G','',14,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13717,823,'2013-06-16 - 16:00','Domicile','AIS F 3 + AMI 1 + AMI 2 (G) + AMI 4 (G) + AMI 6 (G','',15,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13718,823,'2013-06-16 - 23:00','Domicile','AIS F 3 + AMI 1 + AMI 2 (G) + AMI 4 (G) + AMI 6 (G','',16,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13583,822,'2013-06-17 - 08:00','Domicile','AMI 1','',53,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13466,819,'2013-06-17 - 10:00','Cabinet','AIS 3','',19,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13584,822,'2013-06-17 - 12:00','Domicile','AMI 1','',54,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13880,820,'2013-06-17 - 15:25','Cabinet','AMI 1 + AMI 1','',12,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13522,821,'2013-06-17 - 16:20','Cabinet','AMI 4','',19,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13585,822,'2013-06-17 - 22:00','Domicile','AMI N 1','',55,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13586,822,'2013-06-18 - 08:00','Domicile','AMI 1','',56,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13467,819,'2013-06-18 - 10:00','Cabinet','AIS 3','',20,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13719,823,'2013-06-18 - 10:00','Domicile','AIS 3 + AMI 1 + AMI 2 (G) + AMI 4 (G) + AMI 6 (G)','',17,"Le patient devra avoir sa carte Vitale pour la facturation  la prochaine sance.");
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13587,822,'2013-06-18 - 12:00','Domicile','AMI 1','',57,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13720,823,'2013-06-18 - 16:00','Domicile','AIS 3 + AMI 1 + AMI 2 (G) + AMI 4 (G) + AMI 6 (G)','',18,"Dernire sance du traitement.");
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13523,821,'2013-06-18 - 16:20','Cabinet','AMI 4','',20,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13588,822,'2013-06-18 - 22:00','Domicile','AMI N 1','',58,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13589,822,'2013-06-19 - 08:00','Domicile','AMI 1','',59,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13468,819,'2013-06-19 - 10:00','Cabinet','AIS 3','',21,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13590,822,'2013-06-19 - 12:00','Domicile','AMI 1','',60,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13881,820,'2013-06-19 - 15:25','Cabinet','AMI 1 + AMI 1','',13,"Le patient devra avoir sa carte Vitale pour la facturation  la prochaine sance.");
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13524,821,'2013-06-19 - 16:20','Cabinet','AMI 4','',21,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13591,822,'2013-06-19 - 22:00','Domicile','AMI N 1','',61,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13592,822,'2013-06-20 - 08:00','Domicile','AMI 1','',62,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13469,819,'2013-06-20 - 10:00','Cabinet','AIS 3','',22,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13593,822,'2013-06-20 - 12:00','Domicile','AMI 1','',63,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13525,821,'2013-06-20 - 16:20','Cabinet','AMI 4','',22,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13594,822,'2013-06-20 - 22:00','Domicile','AMI N 1','',64,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13595,822,'2013-06-21 - 08:00','Domicile','AMI 1','',65,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13470,819,'2013-06-21 - 10:00','Cabinet','AIS 3','',23,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13596,822,'2013-06-21 - 12:00','Domicile','AMI 1','',66,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13526,821,'2013-06-21 - 16:20','Cabinet','AMI 4','',23,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13597,822,'2013-06-21 - 22:00','Domicile','AMI N 1','',67,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13598,822,'2013-06-22 - 08:00','Domicile','AMI 1','',68,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13471,819,'2013-06-22 - 10:00','Cabinet','AIS 3','',24,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13599,822,'2013-06-22 - 12:00','Domicile','AMI 1','',69,"Le patient devra avoir sa carte Vitale pour la facturation  la prochaine sance.");
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13527,821,'2013-06-22 - 16:20','Cabinet','AMI 4','',24,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13600,822,'2013-06-22 - 22:00','Domicile','AMI N 1','',70,"Dernire sance du traitement.");
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13472,819,'2013-06-24 - 10:00','Cabinet','AIS 3','',25,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13528,821,'2013-06-24 - 16:20','Cabinet','AMI 4','',25,'');
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13473,819,'2013-06-25 - 10:00','Cabinet','AIS 3','',26,"Le patient devra avoir sa carte Vitale pour la facturation  la prochaine sance.");
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13529,821,'2013-06-25 - 16:20','Cabinet','AMI 4','',26,"Le patient devra avoir sa carte Vitale pour la facturation  la prochaine sance.");
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13474,819,'2013-06-26 - 10:00','Cabinet','AIS 3','',27,"Dernire sance du traitement.");
INSERT INTO Seances(Id, IdPrescription, Date, Lieu, Cotation, Libelle, Numero, Note) VALUES(13530,821,'2013-06-26 - 16:20','Cabinet','AMI 4','',27,"Dernire sance du traitement.");

COMMIT;