insert into TypeImpr
values ('I','INCONNU');
insert into TypeImpr
values ('M','Matricielle');
insert into TypeImpr
values ('J','Jet d''encre');
insert into TypeImpr
values ('L','Laser');

commit;

-- prompt table des cartouches
insert into cartouche 
values (0, 'INC?','INCONNU',0);

insert into cartouche 
values (1, 'CXT1R','Rotrex 2500',95.00);

insert into cartouche 
values (2, 'CDUM2','Micral 20P',40.00);

insert into cartouche 
values (3, 'OKI80','Ruban OKI 80',80.00);

insert into cartouche 
values (4, 'OKI132','Ruban OKI 132',108.00);

insert into cartouche 
values (5, 'P45-HP-LJ2','Cartouche toner',529.99);

insert into cartouche 
values (6, 'P45-HP-LJ2P','Cartouche toner',527.67);

insert into cartouche 
values (7, 'P45-HPLA50','Cartouche toner',939.77);

insert into cartouche 
values (8, 'P45-HPLA5L','Cartouche toner',464.77);

insert into cartouche 
values (9, 'P45-HPL400','Cartouche toner',669.67);

insert into cartouche 
values (10, 'P45-HPL410','Cartouche toner',499.67);

insert into cartouche 
values (11, 'P45-HPL120','Cartouche toner',1094.44);

insert into cartouche 
values (12, 'P45-HPL150','Cartouche toner',599.67);

insert into cartouche 
values (13, 'P45-HPLASI','Cartouche toner',1244.64);

insert into cartouche 
values (14, 'P45-C4092A','Cartouche toner',724.86);

insert into cartouche 
values (15, 'P45-C4127A','Cartouche toner',764.26);

insert into cartouche 
values (16, 'P45-CA-SII','Toner EPS série 2',519.67);

insert into cartouche 
values (17, 'P45-CA-SIIP','Toner EPL série 2',489.67);

-- Jet d'encre
insert into cartouche 
values (18, 'P45-HPDJ101','Cartouche noire',179.67);

insert into cartouche 
values (19, 'P45-HPDJ02','Cartouche 3 couleurs',194.88);

insert into cartouche 
values (20, 'P45-51633M','Cartouche noire',169.67);

commit;

-- prompt table des imprimantes 

-- prompt laser

insert into imprimante
values (0, 'INCONNUE','I','INCONNUE');

insert into imprimante
values (null, 'HPLJ2','L','Hewlett Packard Laserjet 2');

insert into imprimante
values (null, 'HPLJ2D','L','Hewlett Packard Laserjet 2D');

insert into imprimante
values (null, 'HPLJ3','L','Hewlett Packard Laserjet 3');

insert into imprimante
values (null, 'HPLJ3D','L','Hewlett Packard Laserjet 3D');

commit;
insert into accepter
values (5,1);

insert into accepter
values (5, 2);

insert into accepter
values (5, 3);

insert into accepter
values (5, 4);

insert into imprimante
values (null, 'HPLJ2P','L','Hewlett Packard Laserjet 2P');

insert into imprimante
values (null, 'HPLJ2PP','L','Hewlett Packard Laserjet 2P Plus');

insert into imprimante
values (null, 'HPLJ3P','L','Hewlett Packard Laserjet 3P');

commit;
insert into accepter
values (6, 5);

insert into accepter
values (6, 6);

insert into accepter
values (6, 7);


insert into imprimante
values (null, 'HPLJ3SI','L','Hewlett Packard Laserjet 3Si');

insert into imprimante
values (null, 'HPLJ4SI','L','Hewlett Packard Laserjet 4Si');

insert into imprimante
values (null, 'HPLJ4SIMX','L','Hewlett Packard Laserjet 4SiMx');

commit;
insert into accepter
values (7,8);

insert into accepter
values (7,9);

insert into accepter
values (7,10);

-- prompt LJ4
insert into imprimante
values (null, 'HPLJ4','L','Hewlett Packard Laserjet 4');

insert into imprimante
values (null, 'HPLJ4M','L','Hewlett Packard Laserjet 4M');

insert into imprimante
values (null, 'HPLJ5','L','Hewlett Packard Laserjet 5');

commit;
insert into accepter
values (8,11);

insert into accepter
values (8,12);

insert into accepter
values (8,13);


insert into imprimante
values (null, 'HPLJ4L','L','Hewlett Packard Laserjet 4L');

insert into imprimante
values (null, 'HPLJ4ML','L','Hewlett Packard Laserjet 4ML');

insert into imprimante
values (null, 'HPLJ4MP','L','Hewlett Packard Laserjet 4MP');

insert into imprimante
values (null, 'HPLJ4P','L','Hewlett Packard Laserjet 4P');

commit;
insert into accepter
values (10,14);

insert into accepter
values (10,15);

insert into accepter
values (10,16);

insert into accepter
values (10,17);


insert into imprimante
values (null, 'HPLJ4MX','L','Hewlett Packard Laserjet 4MX');

insert into imprimante
values (null, 'HPLJ4MV','L','Hewlett Packard Laserjet 4MV');

commit;
insert into accepter
values (11, 18);

insert into accepter
values (11, 19);

insert into imprimante
values (null, 'HPLJ5P','L','Hewlett Packard Laserjet 5P');

insert into imprimante
values (null, 'HPLJ5MP','L','Hewlett Packard Laserjet 5MP');

insert into imprimante
values (null, 'HPLJ6P','L','Hewlett Packard Laserjet 6P');

insert into imprimante
values (null, 'HPLJ6MP','L','Hewlett Packard Laserjet 6MP');

commit;
insert into accepter
values (12,20);

insert into accepter
values (12,21);

insert into accepter
values (12,22);

insert into accepter
values (12,23);

-- prompt -- Laserjet

insert into imprimante
values (null, 'CANLBP8','L','Canon LBP-8II');

insert into imprimante
values (null, 'CANLBP83','L','Canon LBP-843');

insert into imprimante
values (null, 'CANLBPRX','L','Canon LBP-RX');


commit;
insert into accepter
values (16,24);

insert into accepter
values (16,25);

insert into accepter
values (16,26);

insert into imprimante
values (null, 'CANLBP4','L','Canon LBP4');

commit;
insert into accepter
values (17,27);

insert into imprimante
values (null, 'HPDJ400C','J','Hewlett Packard Deskjet 400C');

insert into imprimante
values (null, 'HPDJ500C','J','Hewlett Packard Deskjet 500C');

insert into imprimante
values (null, 'HPDJ550C','J','Hewlett Packard Deskjet 550C');

insert into imprimante
values (null, 'HPDJ560C','J','Hewlett Packard Deskjet 560C');

commit;
insert into accepter
values (18, 28);

insert into accepter
values (18, 29);

insert into accepter
values (18,30);

insert into accepter
values (18,31);


insert into accepter
values (19,28);

insert into accepter
values (19,29);

insert into accepter
values (19,30);

insert into accepter
values (19,31);

insert into imprimante
values (null, 'HPDJP310','J','Hewlett Packard Deskjet Portable 310');

insert into imprimante
values (null, 'HPDJP320','J','Hewlett Packard Deskjet Portable 320');

insert into imprimante
values (null, 'HPDJP340','J','Hewlett Packard Deskjet Portable 340');

insert into imprimante
values (null, 'HPDJP380','J','Hewlett Packard Deskjet Portable 380');

commit;
insert into accepter
values (20,32);

insert into accepter
values (20,33);

insert into accepter
values ( 20,34);

insert into accepter
values (20,35);

commit;

-- prompt -- matricielle 

insert into imprimante
values (null, 'MOKI80','M','Oki 80 colonnes');

insert into imprimante
values (null, 'MOKI132','M','Oki 132 colonnes');

commit;
insert into accepter
values (3,36);

insert into accepter
values (4,37);

commit;