begin transaction;
insert into villes values('MTL', 'Montréal',2000000);
insert into villes values('QUE', 'Québec',1500000);
insert into villes values('OTT','Ottawa',10000000);
insert into villes values ('TOR','Toronto',3000000); 
--------------------------------------------

insert into monuments values('Oratoire St-Josephe','L''oratoire Saint-Joseph est une église à Montréal',5,'20');
insert into monuments values('Basilique notre dame','L''église-mère de Montréal',4,10);
insert into monuments values('Beaux Art','Musé de Montréal',4,100);
insert into monuments values('Le château Frontenac','L''hôtel du Parlement du Québec1',5,150); 
insert into monuments values('Jardin Botanique','Le Jardin botanique de Montréal',3,50);
insert into monuments values('Parlement de Quebec','Le parlement de Quebec',4,50);
insert into monuments values('Le Parelemt D''Ottawa','Le parlement de Ottawa',4,50);
insert into monuments values('Le Phare','Le Phare de Gatineau',2,10);
insert into monuments values('Le Panthéon','Le Panthéon du Hockey',3,60);
insert into monuments values('Le Musé','Le musé de la 2eme guere mondiale',4,50);
insert into monuments values('La Citadelle','La citadelle de Quebec',5,20);
insert into monuments values('Le Chateau','Le Chateau de Toronto',2,20);
-------

insert into circuits values('Le MontMartre',7,400,50,'MTL','QUE');
insert into circuits values('Le Patoche',10,500,20,'MTL','TOR');
insert into circuits values('Le Barackuda',5,300,40,'MTL','OTT');
insert into circuits values('Le Primogene',6,300,20,'QUE','MTL');
insert into circuits values('Le Jaguar',4,200,10,'QUE','OTT');
---


insert into EVALUATIONSCIRCUIT values(101,51,18, 'excellent circuit, je recommande');
insert into EVALUATIONSCIRCUIT values(102,51,18, 'excellent circuit, un peu long');
insert into EVALUATIONSCIRCUIT values(103,51,20, 'excellent circuit.''adore, je recommande');
insert into EVALUATIONSCIRCUIT values(104,51,17, 'bien, trop court pour le nombre de monuments');
insert into EVALUATIONSCIRCUIT values(101,52,16, 'excellent circuit, un peu cher. Long');
insert into EVALUATIONSCIRCUIT values(102,52,17, 'excellent circuit, un peu long');
insert into EVALUATIONSCIRCUIT values(105,52,18, 'excellent circuit. je recommande');
insert into EVALUATIONSCIRCUIT values(103,52,15, 'bien, trop long');
insert into EVALUATIONSCIRCUIT values(106,53,16, 'bon circuit, trop court');
insert into EVALUATIONSCIRCUIT values(107,53,17, 'tres bien circuit, un peu court');
insert into EVALUATIONSCIRCUIT values(101,53,18, 'excellent circuit. je recommande');
insert into EVALUATIONSCIRCUIT values(103,53,18, 'très bien bien, trop court');
insert into EVALUATIONSCIRCUIT values(103,55,12, 'moyen, trop court');

---
insert into circuitsmonuments values(2,51,1);
insert into circuitsmonuments values(3,51,2);
insert into circuitsmonuments values(5,51,3);
insert into circuitsmonuments values(7,51,4);
insert into circuitsmonuments values(8,51,5);
insert into circuitsmonuments values(12,51,6);
insert into circuitsmonuments values(2,52,1);
insert into circuitsmonuments values(4,52,2);
insert into circuitsmonuments values(10,52,3);
insert into circuitsmonuments values(11,52,4);
insert into circuitsmonuments values(2,53,1);
insert into circuitsmonuments values(3,53,2);
insert into circuitsmonuments values(8,53,3);
insert into circuitsmonuments values(11,53,4);
insert into circuitsmonuments values(9,53,5);
insert into circuitsmonuments values(5,55,1);
insert into circuitsmonuments values(9,55,1);
insert into circuitsmonuments values(11,55,1);
commit;


-------