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ébec',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 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;