Inserts

code format="sql" INSERT INTO MONEDA VALUES ('ESPAÑA','EURO',1,1); INSERT INTO MONEDA VALUES ('FRANCIA','EURO',1,1); INSERT INTO MONEDA VALUES ('ALEMANIA','EURO',1,1); INSERT INTO MONEDA VALUES ('ITALIA','EURO',1,1); INSERT INTO MONEDA VALUES ('EE.UU.','DOLAR',0.6810,0.6810); INSERT INTO MONEDA VALUES ('G. BRETAÑA','LIBRA',1.3372,1.3372); INSERT INTO MONEDA VALUES ('PORTUGAL','EURO',1,1);

INSERT INTO PROVEEDORES VALUES ('P1','1234567801','PROVEEDOR UNO','C/UNO, 1','111111111','ALBACETE','ESPAÑA'); INSERT INTO PROVEEDORES VALUES ('P2','1234567802','PROVEEDOR DOS','C/DOS, 2','111111111','CUENCA','ESPAÑA'); INSERT INTO PROVEEDORES VALUES ('P3','1234567803','PROVEEDOR TRES','C/TRES, 3','111111111','ALBACETE','ESPAÑA'); INSERT INTO PROVEEDORES VALUES ('P4','1234567804','PROVEEDOR CUATRO','C/CUATRO, 4','111111111','LISBOA','PORTUGAL'); INSERT INTO PROVEEDORES VALUES ('P5','1234567805','PROVEEDOR CINCO','C/CINCO, 5','111111111','MURCIA','ESPAÑA'); INSERT INTO PROVEEDORES VALUES ('P6','1234567806','PROVEEDOR SEIS','C/SEIS, 6','111111111','CUENCA','ESPAÑA'); INSERT INTO PROVEEDORES VALUES ('P7','1234567807','PROVEEDOR SIETE','C/SIETE, 7','111111111','MILAN','ITALIA'); INSERT INTO PROVEEDORES VALUES ('P8','1234567808','PROVEEDOR OCHO','C/OCHO, 8','111111111','ALBACETE','ESPAÑA'); INSERT INTO PROVEEDORES VALUES ('P9','1234567809','PROVEEDOR NUEVE','C/NUEVE, 9','111111111','ALBACETE','ESPAÑA'); INSERT INTO PROVEEDORES VALUES ('P10','1234567810','PROVEEDOR DIEZ','C/DIEZ, 10','111111111','PARIS','FRANCIA'); INSERT INTO PROVEEDORES VALUES ('P11','1234567811','PROVEEDOR ONCE','C/ONCE, 11','111111111','MADRID','ESPAÑA'); INSERT INTO PROVEEDORES VALUES ('P12','1234567812','PROVEEDOR DOCE','C/DOCE, 12','111111111','MADRID','ESPAÑA'); INSERT INTO PROVEEDORES VALUES ('P13','1234567813','PROVEEDOR TRECE','C/TRECE, 13','111111111','PARIS','FRANCIA'); INSERT INTO PROVEEDORES VALUES ('P14','1234567814','PROVEEDOR CATORCE','C/CATORCE, 14','111111111','BONN','ALEMANIA'); INSERT INTO PROVEEDORES VALUES ('P15','1234567815','PROVEEDOR QUINCE','C/QUINCE, 15','111111111','ALBACETE','ESPAÑA');

INSERT INTO ARTICUL VALUES ('A1','ARTICULO UNO','','VERDE',150,12); INSERT INTO ARTICUL VALUES ('A2','ARTICULO DOS','','AZUL',350,6); INSERT INTO ARTICUL VALUES ('A3','ARTICULO TRES','','AZUL',550,6); INSERT INTO ARTICUL VALUES ('A4','ARTICULO CUATRO','','BLANCO',1000,12); INSERT INTO ARTICUL VALUES ('A5','ARTICULO CINCO','','NEGRO',500,12); INSERT INTO ARTICUL VALUES ('A6','ARTICULO SEIS','','NEGRO',550,12); INSERT INTO ARTICUL VALUES ('A7','ARTICULO SIETE','','AMARILLO',350,6); INSERT INTO ARTICUL VALUES ('A8','ARTICULO OCHO','','ROJO',3050,12); INSERT INTO ARTICUL VALUES ('A9','ARTICULO NUEVE','','ROJO',50,12); INSERT INTO ARTICUL VALUES ('A10','ARTICULO DIEZ','','AZUL',30,6); INSERT INTO ARTICUL VALUES ('A11','ARTICULO ONCE','','VERDE',150,12); INSERT INTO ARTICUL VALUES ('A12','ARTICULO DOCE','','ROJO',700,12); INSERT INTO ARTICUL VALUES ('A13','ARTICULO TRECE','','METALICO',1350,12); INSERT INTO ARTICUL VALUES ('A14','ARTICULO CATORCE','','BLANCO',1100,6); INSERT INTO ARTICUL VALUES ('A15','ARTICULO QUINCE','','NEGRO',500,12); INSERT INTO ARTICUL VALUES ('A16','ARTICULO DIECISEIS','','AMBAR',50,12); INSERT INTO ARTICUL VALUES ('A17','ARTICULO DIECISIETE','','OCRE',2360,6); INSERT INTO ARTICUL VALUES ('A18','ARTICULO DIECIOCHO   ','','GRIS',3250,12); INSERT INTO ARTICUL VALUES ('A19','ARTICULO DIECINUEVE','','ROJO',5000,6); INSERT INTO ARTICUL VALUES ('A20','ARTICULO VEINTE','','AZUL',300,12);

INSERT INTO CLIENTES VALUES ('C1','0123456701','CLIENTE UNO','C/UNO, 1','222222222'); INSERT INTO CLIENTES VALUES ('C2','0123456702','CLIENTE DOS','C/DOS, 2','222222222'); INSERT INTO CLIENTES VALUES ('C3','0123456703','CLIENTE TRES','C/TRES, 3','222222222'); INSERT INTO CLIENTES VALUES ('C4','0123456704','CLIENTE CUATRO','C/CUATRO, 4','222222222'); INSERT INTO CLIENTES VALUES ('C5','0123456705','CLIENTE CINCO','C/CINCO, 5','222222222'); INSERT INTO CLIENTES VALUES ('C6','0123456706','CLIENTE SEIS','C/SEIS, 6','222222222'); INSERT INTO CLIENTES VALUES ('C7','0123456707','CLIENTE SIETE','C/SIETE, 7','222222222'); INSERT INTO CLIENTES VALUES ('C8','0123456708','CLIENTE OCHO','C/OCHO, 8','222222222'); INSERT INTO CLIENTES VALUES ('C9','0123456709','CLIENTE NUEVE','C/NUEVE, 9','222222222'); INSERT INTO CLIENTES VALUES ('C10','0123456710','CLIENTE DIEZ','C/DIEZ, 10','222222222'); INSERT INTO CLIENTES VALUES ('C11','0123456711','CLIENTE ONCE','C/ONCE, 11','222222222'); INSERT INTO CLIENTES VALUES ('C12','0123456712','CLIENTE DOCE','C/DOCE, 12','222222222'); INSERT INTO CLIENTES VALUES ('C13','0123456713','CLIENTE TRECE','C/TRECE, 13','222222222'); INSERT INTO CLIENTES VALUES ('C14','0123456714','CLIENTE CATORCE','C/CATORCE, 14','222222222'); INSERT INTO CLIENTES VALUES ('C15','0123456715','CLIENTE QUINCE','C/QUINCE, 15','222222222');

INSERT INTO FACTURAS VALUES ('1',10,'13/02/09',350,'A1','C1'); INSERT INTO FACTURAS VALUES ('2',21,'13/04/09',550,'A2','C7'); INSERT INTO FACTURAS VALUES ('3',80,'12/04/09',1000,'A1','C1'); INSERT INTO FACTURAS VALUES ('4',23,'12/04/09',550,'A3','C2'); INSERT INTO FACTURAS VALUES ('5',100,'12/04/09',445,'A1','C3'); INSERT INTO FACTURAS VALUES ('6',21,'21/05/09',1150,'A4','C4'); INSERT INTO FACTURAS VALUES ('7',80,'21/05/09',1040,'A4','C5'); INSERT INTO FACTURAS VALUES ('8',623,'21/07/09',450,'A5','C8'); INSERT INTO FACTURAS VALUES ('9',5000,'10/08/09',1350,'A8','C9'); INSERT INTO FACTURAS VALUES ('10',2100,'11/08/09',1550,'A8','C9'); INSERT INTO FACTURAS VALUES ('11',800,'24/08/09',1000,'A3','C10'); INSERT INTO FACTURAS VALUES ('12',230,'10/09/09',234,'A10','C2'); INSERT INTO FACTURAS VALUES ('13',100,'14/11/09',129,'A11','C11'); INSERT INTO FACTURAS VALUES ('14',1221,'17/11/09',1350,'A12','C3'); INSERT INTO FACTURAS VALUES ('15',79,'30/11/09',40,'A12','C10'); INSERT INTO FACTURAS VALUES ('16',523,'8/12/09',3478,'A9','C8'); INSERT INTO FACTURAS VALUES ('17',5330,'10/12/09',350,'A13','C15'); INSERT INTO FACTURAS VALUES ('18',1450,'2/01/10',323,'A4','C13'); INSERT INTO FACTURAS VALUES ('19',121,'14/01/10',1123,'A4','C13'); INSERT INTO FACTURAS VALUES ('20',446,'16/01/10',234,'A13','C2'); INSERT INTO FACTURAS VALUES ('21',1100,'23/01/10',1129,'A1','C8'); INSERT INTO FACTURAS VALUES ('22',251,'1/02/10',150,'A7','C12'); INSERT INTO FACTURAS VALUES ('23',179,'12/02/10',400,'A10','C12'); INSERT INTO FACTURAS VALUES ('24',223,'12/02/10',2178,'A2','C8');

INSERT INTO SUMINISTROS VALUES ('P13','A1',1234); INSERT INTO SUMINISTROS VALUES ('P13','A4',234); INSERT INTO SUMINISTROS VALUES ('P13','A15',934); INSERT INTO SUMINISTROS VALUES ('P14','A2',724); INSERT INTO SUMINISTROS VALUES ('P14','A8',134); INSERT INTO SUMINISTROS VALUES ('P14','A16',764); INSERT INTO SUMINISTROS VALUES ('P15','A6',334); INSERT INTO SUMINISTROS VALUES ('P15','A6',224); INSERT INTO SUMINISTROS VALUES ('P15','A14',1123); INSERT INTO SUMINISTROS VALUES ('P9','A7',534); INSERT INTO SUMINISTROS VALUES ('P9','A8',134); INSERT INTO SUMINISTROS VALUES ('P9','A13',54); INSERT INTO SUMINISTROS VALUES ('P10','A12',434); INSERT INTO SUMINISTROS VALUES ('P10','A16',674); INSERT INTO SUMINISTROS VALUES ('P10','A4',1334); INSERT INTO SUMINISTROS VALUES ('P11','A18',324); INSERT INTO SUMINISTROS VALUES ('P11','A17',35); INSERT INTO SUMINISTROS VALUES ('P11','A1',456); INSERT INTO SUMINISTROS VALUES ('P11','A3',764); INSERT INTO SUMINISTROS VALUES ('P2','A2',56); INSERT INTO SUMINISTROS VALUES ('P2','A14',134); INSERT INTO SUMINISTROS VALUES ('P3','A5',174); INSERT INTO SUMINISTROS VALUES ('P3','A12',1000); INSERT INTO SUMINISTROS VALUES ('P3','A3',356); INSERT INTO SUMINISTROS VALUES ('P12','A2',77); INSERT INTO SUMINISTROS VALUES ('P12','A7',336); INSERT INTO SUMINISTROS VALUES ('P5','A12',454); INSERT INTO SUMINISTROS VALUES ('P5','A16',1165); INSERT INTO SUMINISTROS VALUES ('P5','A4',634); INSERT INTO SUMINISTROS VALUES ('P6','A1',374); INSERT INTO SUMINISTROS VALUES ('P13','A12',1000); INSERT INTO SUMINISTROS VALUES ('P8','A6',500); code