CREATE SCHEMA PUBLIC AUTHORIZATION DBA
CREATE MEMORY TABLE VARIABLES_BOLEANAS(NOMBRE CHAR(20) NOT NULL PRIMARY KEY,VALOR BOOLEAN)
CREATE MEMORY TABLE EMPLEADO(ID_EMPLEADO INTEGER NOT NULL PRIMARY KEY,NOMBRE CHAR(30) NOT NULL,CARGO CHAR(1) NOT NULL,ESTADO BOOLEAN NOT NULL)
CREATE MEMORY TABLE ANALISIS(ID_ANALISIS INTEGER NOT NULL PRIMARY KEY,ID_INSPECTOR INTEGER,FECHA DATE,TIPO CHAR(1),COMENTARIO VARCHAR(100),CONSTRAINT SYS_FK_55 FOREIGN KEY(ID_INSPECTOR) REFERENCES EMPLEADO(ID_EMPLEADO))
CREATE MEMORY TABLE ALMACEN_MP(ID_ALMACEN INTEGER NOT NULL PRIMARY KEY,LOCALIZACION CHAR(50) NOT NULL,ESP_LIBRE FLOAT NOT NULL,ESTADO BOOLEAN NOT NULL,C_MAX FLOAT)
CREATE MEMORY TABLE ALMACEN_PT(ID_ALMACEN INTEGER NOT NULL PRIMARY KEY,LOCALIZACION CHAR(50) NOT NULL,ESP_LIBRE FLOAT NOT NULL,ESTADO BOOLEAN NOT NULL,C_MAX FLOAT)
CREATE MEMORY TABLE INSPECCION(ID_INSP INTEGER NOT NULL PRIMARY KEY,ID_INSPECTOR INTEGER,FECHA DATE,COM_L CHAR(500),COM_T CHAR(500),COM_V CHAR(500),CONTROL_L BOOLEAN,CONTROL_T BOOLEAN,CONTROL_V BOOLEAN,CONSTRAINT SYS_FK_78 FOREIGN KEY(ID_INSPECTOR) REFERENCES EMPLEADO(ID_EMPLEADO))
CREATE MEMORY TABLE PEDIDO(ID_PEDIDO INTEGER NOT NULL PRIMARY KEY,ID_EMPLEADO INTEGER,ID_INSPECCION INTEGER,CANTIDAD FLOAT,CONSTRAINT SYS_FK_83 FOREIGN KEY(ID_EMPLEADO) REFERENCES EMPLEADO(ID_EMPLEADO),CONSTRAINT SYS_FK_84 FOREIGN KEY(ID_INSPECCION) REFERENCES INSPECCION(ID_INSP))
CREATE MEMORY TABLE CUBA(ID_CUBA INTEGER NOT NULL PRIMARY KEY,CAPACIDAD FLOAT,ESTADO BOOLEAN,ID_LOTE INTEGER,TIPO CHAR(1))
CREATE MEMORY TABLE BARRICA(ID_BARRICA INTEGER NOT NULL PRIMARY KEY,CAPACIDAD_MAX FLOAT,CANTIDAD FLOAT,ESTADO BOOLEAN,TESTIGO BOOLEAN,TIPO CHAR(1),ID_LOTE_ACTUAL INTEGER,ID_LOTE_SIGUIENTE INTEGER)
CREATE MEMORY TABLE BOTELLAS(ID_REF INTEGER NOT NULL PRIMARY KEY,CANTIDAD_B_MAX INTEGER,CANTIDAD_B_REAL INTEGER,CANTIDAD_L_REAL FLOAT,CANTIDAD_L_MAX FLOAT,ESTADO BOOLEAN,TESTIGO_CRIANZA BOOLEAN,TESTIGO_RESERVA BOOLEAN,TIPO CHAR(1),ID_LOTE_ACTUAL INTEGER,ID_LOTE_SIGUIENTE INTEGER)
CREATE MEMORY TABLE CLIENTE(ID_CLIENTE INTEGER NOT NULL PRIMARY KEY,NOMBRE CHAR(50) NOT NULL,DIRECCION CHAR(100) NOT NULL)
CREATE MEMORY TABLE VENTA(ID_VENTA INTEGER NOT NULL PRIMARY KEY,ID_LOTE INTEGER NOT NULL,ID_CLIENTE INTEGER NOT NULL,FECHA DATE NOT NULL,CANTIDAD FLOAT,CONSTRAINT SYS_FK_115 FOREIGN KEY(ID_CLIENTE) REFERENCES CLIENTE(ID_CLIENTE))
CREATE MEMORY TABLE DISTRIBUCION(ID_REF INTEGER NOT NULL,ID_ALMACEN INTEGER NOT NULL,ID_LOTE INTEGER,CANTIDAD_BOTELLAS INTEGER,ESTADO BOOLEAN,PRIMARY KEY(ID_REF,ID_ALMACEN),CONSTRAINT SYS_FK_122 FOREIGN KEY(ID_ALMACEN) REFERENCES ALMACEN_PT(ID_ALMACEN))
CREATE MEMORY TABLE CONFIGURACION(NOMBRE CHAR(20) NOT NULL PRIMARY KEY,VALOR FLOAT)
CREATE MEMORY TABLE INDICE(NOMBRE CHAR(20) NOT NULL PRIMARY KEY,VALOR INTEGER)
CREATE MEMORY TABLE CAMIONES(ID_REF INTEGER NOT NULL PRIMARY KEY,LOCALIZACION CHAR(20),NUM INTEGER,CAP_MAX FLOAT,CARGA FLOAT,ESTADO BOOLEAN,FECHA DATE)
CREATE MEMORY TABLE CALIDAD(ID_CALIDAD INTEGER NOT NULL PRIMARY KEY,ID_INSPECTOR INTEGER,FECHA DATE,CONTROL_F BOOLEAN,CONTROL_Q BOOLEAN,COM_F CHAR(100),COM_Q CHAR(100),CONTROL_CORRECT BOOLEAN,COM_CORRECT CHAR(100),CONSTRAINT SYS_FK_139 FOREIGN KEY(ID_INSPECTOR) REFERENCES EMPLEADO(ID_EMPLEADO))
CREATE MEMORY TABLE LOTE(ID_LOTE INTEGER NOT NULL PRIMARY KEY,ID_ALMACEN INTEGER,ID_CUBA INTEGER,ID_ANALISIS INTEGER,ID_CALIDAD_1 INTEGER,ID_CALIDAD_2 INTEGER,VENDIDO BOOLEAN,T_ENV FLOAT,T_REP FLOAT,TIPO CHAR(1),CANTIDAD_UVA FLOAT,NUMERO_BARRICAS INTEGER,CANTIDAD_VINO FLOAT,CANTIDAD_BOTELLAS INTEGER,CONSTRAINT SYS_FK_164 FOREIGN KEY(ID_ALMACEN) REFERENCES ALMACEN_PT(ID_ALMACEN),CONSTRAINT SYS_FK_165 FOREIGN KEY(ID_CALIDAD_1) REFERENCES CALIDAD(ID_CALIDAD),CONSTRAINT SYS_FK_166 FOREIGN KEY(ID_CALIDAD_2) REFERENCES CALIDAD(ID_CALIDAD),CONSTRAINT SYS_FK_167 FOREIGN KEY(ID_ANALISIS) REFERENCES ANALISIS(ID_ANALISIS))
CREATE USER SA PASSWORD ""
GRANT DBA TO SA
SET WRITE_DELAY 10
SET SCHEMA PUBLIC
INSERT INTO VARIABLES_BOLEANAS VALUES('almacen_mp',TRUE)
INSERT INTO VARIABLES_BOLEANAS VALUES('almacen_pt',TRUE)
INSERT INTO VARIABLES_BOLEANAS VALUES('barrica',FALSE)
INSERT INTO VARIABLES_BOLEANAS VALUES('base datos',TRUE)
INSERT INTO VARIABLES_BOLEANAS VALUES('bodega',FALSE)
INSERT INTO VARIABLES_BOLEANAS VALUES('crianza',FALSE)
INSERT INTO VARIABLES_BOLEANAS VALUES('joven',FALSE)
INSERT INTO VARIABLES_BOLEANAS VALUES('lote',FALSE)
INSERT INTO VARIABLES_BOLEANAS VALUES('marketing',TRUE)
INSERT INTO VARIABLES_BOLEANAS VALUES('promocion',FALSE)
INSERT INTO VARIABLES_BOLEANAS VALUES('reserva',FALSE)
INSERT INTO VARIABLES_BOLEANAS VALUES('rev',FALSE)
INSERT INTO VARIABLES_BOLEANAS VALUES('v_stock',FALSE)
INSERT INTO EMPLEADO VALUES(1,'Castilla','O',TRUE)
INSERT INTO ANALISIS VALUES(1,NULL,'2012-09-11','J','')
INSERT INTO ANALISIS VALUES(2,NULL,'2012-09-11','J','')
INSERT INTO ANALISIS VALUES(3,NULL,'2012-09-11','R','')
INSERT INTO ANALISIS VALUES(4,NULL,'2012-09-11','C','')
INSERT INTO ANALISIS VALUES(5,NULL,'2012-09-12','F','')
INSERT INTO ANALISIS VALUES(6,NULL,'2012-09-12','F','')
INSERT INTO ANALISIS VALUES(7,NULL,'2012-09-12','F','')
INSERT INTO ANALISIS VALUES(8,NULL,'2012-09-12','F','')
INSERT INTO ANALISIS VALUES(9,NULL,'2012-09-12','F','')
INSERT INTO ANALISIS VALUES(10,NULL,'2012-09-12','F','')
INSERT INTO ANALISIS VALUES(11,NULL,'2012-09-12','F','')
INSERT INTO ANALISIS VALUES(12,NULL,'2012-09-12','C','')
INSERT INTO ANALISIS VALUES(13,NULL,'2012-09-13','R','')
INSERT INTO ANALISIS VALUES(14,NULL,'2012-09-13','R','')
INSERT INTO ANALISIS VALUES(15,NULL,'2012-09-13','C','')
INSERT INTO ANALISIS VALUES(16,NULL,'2012-09-13','R','')
INSERT INTO ANALISIS VALUES(17,NULL,'2012-09-13','C','')
INSERT INTO ANALISIS VALUES(18,NULL,'2012-09-17','R','')
INSERT INTO ANALISIS VALUES(19,NULL,'2012-09-17','R','')
INSERT INTO ANALISIS VALUES(20,NULL,'2012-09-17','R','')
INSERT INTO ANALISIS VALUES(21,NULL,'2012-09-17','C','')
INSERT INTO ANALISIS VALUES(22,NULL,'2012-09-17','J','Es mu joven')
INSERT INTO ANALISIS VALUES(23,NULL,'2012-09-17','J','')
INSERT INTO ANALISIS VALUES(24,NULL,'2012-09-17','J','')
INSERT INTO ANALISIS VALUES(25,NULL,'2012-09-17','J','')
INSERT INTO ANALISIS VALUES(26,NULL,'2012-09-17','F','')
INSERT INTO ANALISIS VALUES(27,NULL,'2012-09-17','J','')
INSERT INTO ANALISIS VALUES(28,NULL,'2012-09-17','R','')
INSERT INTO ANALISIS VALUES(29,NULL,'2012-09-17','R','')
INSERT INTO ANALISIS VALUES(30,NULL,'2012-09-17','C','')
INSERT INTO ANALISIS VALUES(31,NULL,'2012-09-17','R','')
INSERT INTO ANALISIS VALUES(32,NULL,'2012-09-17','R','')
INSERT INTO ANALISIS VALUES(33,NULL,'2012-09-17','R','')
INSERT INTO ANALISIS VALUES(34,NULL,'2012-09-19','J','')
INSERT INTO ANALISIS VALUES(35,NULL,'2012-09-19','R','')
INSERT INTO ALMACEN_MP VALUES(1,'Castilla',1000.0E0,TRUE,1000.0E0)
INSERT INTO ALMACEN_PT VALUES(1,'Castilla',300.0E0,TRUE,1000.0E0)
INSERT INTO INSPECCION VALUES(1,NULL,'2012-09-11',' Comentario de la inspeccion....',' Comentario de la inspeccion....',' Comentario de la inspeccion....',TRUE,TRUE,TRUE)
INSERT INTO INSPECCION VALUES(2,NULL,'2012-09-11',' Comentario de la inspeccion....',' Comentario de la inspeccion....',' Comentario de la inspeccion....',TRUE,TRUE,TRUE)
INSERT INTO INSPECCION VALUES(3,NULL,'2012-09-11',' Comentario de la inspeccion....',' Comentario de la inspeccion....',' Comentario de la inspeccion....',TRUE,TRUE,TRUE)
INSERT INTO INSPECCION VALUES(4,NULL,'2012-09-11',' Comentario de la inspeccion....',' Comentario de la inspeccion....',' Comentario de la inspeccion....',TRUE,TRUE,TRUE)
INSERT INTO INSPECCION VALUES(5,NULL,'2012-09-11',' Comentario de la inspeccion....',' Comentario de la inspeccion....',' Comentario de la inspeccion....',TRUE,TRUE,TRUE)
INSERT INTO INSPECCION VALUES(6,NULL,'2012-09-11',' Comentario de la inspeccion....',' Comentario de la inspeccion....',' Comentario de la inspeccion....',TRUE,TRUE,TRUE)
INSERT INTO INSPECCION VALUES(7,NULL,'2012-09-11',' Comentario de la inspeccion....',' Comentario de la inspeccion....',' Comentario de la inspeccion....',TRUE,TRUE,TRUE)
INSERT INTO INSPECCION VALUES(8,NULL,'2012-09-12',' Comentario de la inspeccion....',' Comentario de la inspeccion....',' Comentario de la inspeccion....',TRUE,TRUE,TRUE)
INSERT INTO INSPECCION VALUES(9,NULL,'2012-09-12',' Comentario de la inspeccion....',' Comentario de la inspeccion....',' Comentario de la inspeccion....',TRUE,TRUE,TRUE)
INSERT INTO INSPECCION VALUES(10,NULL,'2012-09-12',' Comentario de la inspeccion....',' Comentario de la inspeccion....',' Comentario de la inspeccion....',TRUE,TRUE,TRUE)
INSERT INTO INSPECCION VALUES(11,NULL,'2012-09-12',' Comentario de la inspeccion....',' Comentario de la inspeccion....',' Comentario de la inspeccion....',TRUE,TRUE,TRUE)
INSERT INTO INSPECCION VALUES(12,NULL,'2012-09-12',' Comentario de la inspeccion....',' Comentario de la inspeccion....',' Comentario de la inspeccion....',TRUE,TRUE,TRUE)
INSERT INTO INSPECCION VALUES(13,NULL,'2012-09-12',' Comentario de la inspeccion....',' Comentario de la inspeccion....',' Comentario de la inspeccion....',TRUE,TRUE,TRUE)
INSERT INTO INSPECCION VALUES(14,NULL,'2012-09-12',' Comentario de la inspeccion....',' Comentario de la inspeccion....',' Comentario de la inspeccion....',TRUE,TRUE,TRUE)
INSERT INTO INSPECCION VALUES(15,NULL,'2012-09-12',' Comentario de la inspeccion....',' Comentario de la inspeccion....',' Comentario de la inspeccion....',TRUE,TRUE,TRUE)
INSERT INTO INSPECCION VALUES(16,NULL,'2012-09-13',' Comentario de la inspeccion....',' Comentario de la inspeccion....',' Comentario de la inspeccion....',TRUE,TRUE,TRUE)
INSERT INTO INSPECCION VALUES(17,NULL,'2012-09-13',' Comentario de la inspeccion....',' Comentario de la inspeccion....',' Comentario de la inspeccion....',TRUE,TRUE,TRUE)
INSERT INTO INSPECCION VALUES(18,NULL,'2012-09-13',' Comentario de la inspeccion....',' Comentario de la inspeccion....',' Comentario de la inspeccion....',TRUE,TRUE,TRUE)
INSERT INTO INSPECCION VALUES(19,NULL,'2012-09-13',' Comentario de la inspeccion....',' Comentario de la inspeccion....',' Comentario de la inspeccion....',TRUE,TRUE,TRUE)
INSERT INTO INSPECCION VALUES(20,NULL,'2012-09-13',' Comentario de la inspeccion....',' Comentario de la inspeccion....',' Comentario de la inspeccion....',TRUE,TRUE,TRUE)
INSERT INTO INSPECCION VALUES(21,NULL,'2012-09-17',' Comentario de la inspeccion....',' Comentario de la inspeccion....',' Comentario de la inspeccion....',TRUE,TRUE,TRUE)
INSERT INTO INSPECCION VALUES(22,NULL,'2012-09-17',' Comentario de la inspeccion....',' Comentario de la inspeccion....',' Comentario de la inspeccion....',TRUE,TRUE,TRUE)
INSERT INTO INSPECCION VALUES(23,NULL,'2012-09-17',' Comentario de la inspeccion....',' Comentario de la inspeccion....',' Comentario de la inspeccion....',TRUE,TRUE,TRUE)
INSERT INTO INSPECCION VALUES(24,NULL,'2012-09-17',' Comentario de la inspeccion....',' Comentario de la inspeccion....',' Comentario de la inspeccion....',TRUE,TRUE,TRUE)
INSERT INTO INSPECCION VALUES(25,NULL,'2012-09-17',' Comentario de la inspeccion....',' Comentario de la inspeccion....',' Comentario de la inspeccion....',TRUE,TRUE,TRUE)
INSERT INTO INSPECCION VALUES(26,NULL,'2012-09-17',' Comentario de la inspeccion....',' Comentario de la inspeccion....',' Comentario de la inspeccion....',TRUE,TRUE,TRUE)
INSERT INTO INSPECCION VALUES(27,NULL,'2012-09-17',' Comentario de la inspeccion....',' Comentario de la inspeccion....',' Comentario de la inspeccion....',TRUE,TRUE,TRUE)
INSERT INTO INSPECCION VALUES(28,NULL,'2012-09-17',' Comentario de la inspeccion....',' Comentario de la inspeccion....',' Comentario de la inspeccion....',TRUE,TRUE,TRUE)
INSERT INTO INSPECCION VALUES(29,NULL,'2012-09-17',' Comentario de la inspeccion....',' Comentario de la inspeccion....',' Comentario de la inspeccion....',TRUE,TRUE,TRUE)
INSERT INTO INSPECCION VALUES(30,NULL,'2012-09-17',' Comentario de la inspeccion....',' Comentario de la inspeccion....',' Comentario de la inspeccion....',TRUE,TRUE,TRUE)
INSERT INTO INSPECCION VALUES(31,NULL,'2012-09-17',' Comentario de la inspeccion....',' Comentario de la inspeccion....',' Comentario de la inspeccion....',TRUE,TRUE,TRUE)
INSERT INTO INSPECCION VALUES(32,NULL,'2012-09-17',' Comentario de la inspeccion....',' Comentario de la inspeccion....',' Comentario de la inspeccion....',TRUE,TRUE,TRUE)
INSERT INTO INSPECCION VALUES(33,NULL,'2012-09-17',' Comentario de la inspeccion....',' Comentario de la inspeccion....',' Comentario de la inspeccion....',TRUE,TRUE,TRUE)
INSERT INTO INSPECCION VALUES(34,NULL,'2012-09-17',' Comentario de la inspeccion....',' Comentario de la inspeccion....',' Comentario de la inspeccion....',TRUE,TRUE,TRUE)
INSERT INTO INSPECCION VALUES(35,NULL,'2012-09-17',' Comentario de la inspeccion....',' Comentario de la inspeccion....',' Comentario de la inspeccion....',TRUE,TRUE,TRUE)
INSERT INTO INSPECCION VALUES(36,NULL,'2012-09-17',' Comentario de la inspeccion....',' Comentario de la inspeccion....',' Comentario de la inspeccion....',TRUE,TRUE,TRUE)
INSERT INTO INSPECCION VALUES(37,NULL,'2012-09-17',' Comentario de la inspeccion....',' Comentario de la inspeccion....',' Comentario de la inspeccion....',TRUE,TRUE,TRUE)
INSERT INTO INSPECCION VALUES(38,NULL,'2012-09-17',' Comentario de la inspeccion....',' Comentario de la inspeccion....',' Comentario de la inspeccion....',TRUE,TRUE,TRUE)
INSERT INTO PEDIDO VALUES(1,NULL,1,120.0E0)
INSERT INTO PEDIDO VALUES(2,NULL,2,100.0E0)
INSERT INTO PEDIDO VALUES(3,NULL,3,100.0E0)
INSERT INTO PEDIDO VALUES(4,NULL,4,100.0E0)
INSERT INTO PEDIDO VALUES(5,NULL,5,100.0E0)
INSERT INTO PEDIDO VALUES(6,NULL,6,100.0E0)
INSERT INTO PEDIDO VALUES(7,NULL,7,100.0E0)
INSERT INTO PEDIDO VALUES(8,NULL,8,100.0E0)
INSERT INTO PEDIDO VALUES(9,NULL,9,100.0E0)
INSERT INTO PEDIDO VALUES(10,NULL,10,100.0E0)
INSERT INTO PEDIDO VALUES(11,NULL,11,100.0E0)
INSERT INTO PEDIDO VALUES(12,NULL,12,100.0E0)
INSERT INTO PEDIDO VALUES(13,NULL,13,100.0E0)
INSERT INTO PEDIDO VALUES(14,NULL,14,100.0E0)
INSERT INTO PEDIDO VALUES(15,NULL,15,100.0E0)
INSERT INTO PEDIDO VALUES(16,NULL,16,100.0E0)
INSERT INTO PEDIDO VALUES(17,NULL,17,250.0E0)
INSERT INTO PEDIDO VALUES(18,NULL,18,250.0E0)
INSERT INTO PEDIDO VALUES(19,NULL,19,120.0E0)
INSERT INTO PEDIDO VALUES(20,NULL,20,140.0E0)
INSERT INTO PEDIDO VALUES(21,NULL,21,100.0E0)
INSERT INTO PEDIDO VALUES(22,NULL,22,100.0E0)
INSERT INTO PEDIDO VALUES(23,NULL,23,200.0E0)
INSERT INTO PEDIDO VALUES(24,NULL,24,200.0E0)
INSERT INTO PEDIDO VALUES(25,NULL,25,200.0E0)
INSERT INTO PEDIDO VALUES(26,NULL,26,200.0E0)
INSERT INTO PEDIDO VALUES(27,NULL,27,100.0E0)
INSERT INTO PEDIDO VALUES(28,NULL,28,100.0E0)
INSERT INTO PEDIDO VALUES(29,NULL,29,100.0E0)
INSERT INTO PEDIDO VALUES(30,NULL,30,200.0E0)
INSERT INTO PEDIDO VALUES(31,NULL,31,100.0E0)
INSERT INTO PEDIDO VALUES(32,NULL,32,200.0E0)
INSERT INTO PEDIDO VALUES(33,NULL,33,100.0E0)
INSERT INTO PEDIDO VALUES(34,NULL,34,100.0E0)
INSERT INTO PEDIDO VALUES(35,NULL,35,200.0E0)
INSERT INTO PEDIDO VALUES(36,NULL,36,200.0E0)
INSERT INTO PEDIDO VALUES(37,NULL,37,100.0E0)
INSERT INTO PEDIDO VALUES(38,NULL,38,1.0E0)
INSERT INTO PEDIDO VALUES(39,NULL,NULL,200.0E0)
INSERT INTO PEDIDO VALUES(40,NULL,NULL,1.0E0)
INSERT INTO PEDIDO VALUES(41,NULL,NULL,10.0E0)
INSERT INTO PEDIDO VALUES(42,NULL,NULL,200.0E0)
INSERT INTO PEDIDO VALUES(43,NULL,NULL,100.0E0)
INSERT INTO PEDIDO VALUES(44,NULL,NULL,100.0E0)
INSERT INTO PEDIDO VALUES(45,NULL,NULL,100.0E0)
INSERT INTO PEDIDO VALUES(46,NULL,NULL,100.0E0)
INSERT INTO PEDIDO VALUES(47,NULL,NULL,100.0E0)
INSERT INTO PEDIDO VALUES(48,NULL,NULL,100.0E0)
INSERT INTO PEDIDO VALUES(49,NULL,NULL,100.0E0)
INSERT INTO PEDIDO VALUES(50,NULL,NULL,100.0E0)
INSERT INTO PEDIDO VALUES(51,NULL,NULL,1.0E0)
INSERT INTO PEDIDO VALUES(52,NULL,NULL,7.0E0)
INSERT INTO PEDIDO VALUES(53,NULL,NULL,100.0E0)
INSERT INTO PEDIDO VALUES(54,NULL,NULL,100.0E0)
INSERT INTO PEDIDO VALUES(55,NULL,NULL,100.0E0)
INSERT INTO PEDIDO VALUES(56,NULL,NULL,100.0E0)
INSERT INTO PEDIDO VALUES(57,NULL,NULL,200.0E0)
INSERT INTO PEDIDO VALUES(58,NULL,NULL,100.0E0)
INSERT INTO PEDIDO VALUES(59,NULL,NULL,200.0E0)
INSERT INTO PEDIDO VALUES(60,NULL,NULL,200.0E0)
INSERT INTO PEDIDO VALUES(61,NULL,NULL,200.0E0)
INSERT INTO PEDIDO VALUES(62,NULL,NULL,200.0E0)
INSERT INTO PEDIDO VALUES(63,NULL,NULL,100.0E0)
INSERT INTO CUBA VALUES(0,100.0E0,FALSE,48,'F')
INSERT INTO CUBA VALUES(1,100.0E0,FALSE,78,'F')
INSERT INTO CUBA VALUES(2,100.0E0,FALSE,79,'F')
INSERT INTO CUBA VALUES(3,100.0E0,FALSE,80,'F')
INSERT INTO BARRICA VALUES(0,100.0E0,0.0E0,TRUE,TRUE,'F',0,22)
INSERT INTO BARRICA VALUES(1,100.0E0,0.0E0,TRUE,TRUE,'F',0,75)
INSERT INTO BARRICA VALUES(2,100.0E0,0.0E0,TRUE,TRUE,'F',0,76)
INSERT INTO BARRICA VALUES(3,100.0E0,0.0E0,TRUE,TRUE,'F',0,78)
INSERT INTO BARRICA VALUES(4,100.0E0,100.0E0,TRUE,FALSE,'R',0,79)
INSERT INTO BARRICA VALUES(5,100.0E0,0.0E0,TRUE,TRUE,'F',0,80)
INSERT INTO BARRICA VALUES(6,100.0E0,0.0E0,TRUE,TRUE,'F',0,0)
INSERT INTO BARRICA VALUES(7,100.0E0,0.0E0,TRUE,FALSE,'F',0,0)
INSERT INTO BARRICA VALUES(8,100.0E0,0.0E0,TRUE,TRUE,'F',0,0)
INSERT INTO BARRICA VALUES(9,100.0E0,0.0E0,TRUE,TRUE,'F',0,0)
INSERT INTO BOTELLAS VALUES(0,5,NULL,NULL,5.0E0,TRUE,FALSE,FALSE,'F',0,6)
INSERT INTO BOTELLAS VALUES(1,9,0,0.0E0,9.0E0,FALSE,TRUE,TRUE,'R',0,0)
INSERT INTO BOTELLAS VALUES(2,9,0,0.0E0,9.0E0,FALSE,TRUE,TRUE,'R',0,0)
INSERT INTO BOTELLAS VALUES(3,9,0,0.0E0,9.0E0,FALSE,TRUE,TRUE,'R',0,0)
INSERT INTO BOTELLAS VALUES(4,9,0,0.0E0,9.0E0,FALSE,TRUE,TRUE,'R',0,0)
INSERT INTO BOTELLAS VALUES(5,9,0,0.0E0,9.0E0,FALSE,TRUE,TRUE,'R',0,0)
INSERT INTO BOTELLAS VALUES(6,9,0,0.0E0,9.0E0,FALSE,TRUE,TRUE,'R',0,0)
INSERT INTO BOTELLAS VALUES(7,9,0,0.0E0,9.0E0,FALSE,TRUE,TRUE,'R',0,0)
INSERT INTO BOTELLAS VALUES(8,9,0,0.0E0,9.0E0,FALSE,TRUE,TRUE,'R',0,0)
INSERT INTO BOTELLAS VALUES(9,9,0,0.0E0,9.0E0,FALSE,TRUE,TRUE,'R',0,0)
INSERT INTO BOTELLAS VALUES(10,9,0,0.0E0,9.0E0,FALSE,TRUE,TRUE,'R',0,0)
INSERT INTO BOTELLAS VALUES(11,9,0,0.0E0,9.0E0,FALSE,TRUE,TRUE,'R',0,0)
INSERT INTO BOTELLAS VALUES(12,9,NULL,NULL,9.0E0,TRUE,FALSE,FALSE,'F',0,0)
INSERT INTO BOTELLAS VALUES(13,9,9,9.0E0,9.0E0,TRUE,TRUE,TRUE,'F',0,0)
INSERT INTO BOTELLAS VALUES(14,9,9,9.0E0,9.0E0,TRUE,TRUE,TRUE,'F',0,0)
INSERT INTO BOTELLAS VALUES(15,9,9,9.0E0,9.0E0,TRUE,TRUE,TRUE,'F',0,0)
INSERT INTO BOTELLAS VALUES(16,9,9,9.0E0,9.0E0,TRUE,TRUE,TRUE,'F',0,0)
INSERT INTO BOTELLAS VALUES(17,9,9,9.0E0,9.0E0,TRUE,TRUE,TRUE,'F',0,0)
INSERT INTO BOTELLAS VALUES(18,9,9,9.0E0,9.0E0,TRUE,TRUE,TRUE,'F',0,0)
INSERT INTO BOTELLAS VALUES(19,9,9,9.0E0,9.0E0,TRUE,TRUE,TRUE,'F',0,0)
INSERT INTO BOTELLAS VALUES(20,9,9,9.0E0,9.0E0,TRUE,TRUE,TRUE,'F',0,0)
INSERT INTO BOTELLAS VALUES(21,9,9,9.0E0,9.0E0,TRUE,TRUE,TRUE,'F',0,0)
INSERT INTO BOTELLAS VALUES(22,9,9,9.0E0,9.0E0,TRUE,TRUE,TRUE,'F',0,0)
INSERT INTO BOTELLAS VALUES(23,9,9,9.0E0,9.0E0,TRUE,TRUE,TRUE,'F',0,0)
INSERT INTO BOTELLAS VALUES(24,9,9,9.0E0,9.0E0,TRUE,TRUE,TRUE,'F',0,0)
INSERT INTO BOTELLAS VALUES(25,9,9,9.0E0,9.0E0,TRUE,TRUE,TRUE,'F',0,0)
INSERT INTO BOTELLAS VALUES(26,9,9,9.0E0,9.0E0,TRUE,TRUE,TRUE,'F',0,0)
INSERT INTO BOTELLAS VALUES(27,9,9,9.0E0,9.0E0,TRUE,TRUE,TRUE,'F',0,0)
INSERT INTO BOTELLAS VALUES(28,9,9,9.0E0,9.0E0,TRUE,TRUE,TRUE,'R',0,0)
INSERT INTO BOTELLAS VALUES(29,9,9,9.0E0,9.0E0,TRUE,TRUE,TRUE,'R',0,0)
INSERT INTO BOTELLAS VALUES(30,9,9,9.0E0,9.0E0,TRUE,TRUE,TRUE,'R',0,0)
INSERT INTO BOTELLAS VALUES(31,9,9,9.0E0,9.0E0,TRUE,TRUE,TRUE,'R',0,0)
INSERT INTO BOTELLAS VALUES(32,9,9,9.0E0,9.0E0,TRUE,TRUE,TRUE,'R',0,0)
INSERT INTO BOTELLAS VALUES(33,9,9,9.0E0,9.0E0,TRUE,TRUE,TRUE,'R',0,0)
INSERT INTO BOTELLAS VALUES(34,9,9,9.0E0,9.0E0,TRUE,TRUE,TRUE,'R',0,0)
INSERT INTO BOTELLAS VALUES(35,9,9,9.0E0,9.0E0,TRUE,TRUE,TRUE,'R',0,0)
INSERT INTO BOTELLAS VALUES(36,9,9,9.0E0,9.0E0,TRUE,TRUE,TRUE,'R',0,0)
INSERT INTO BOTELLAS VALUES(37,9,9,9.0E0,9.0E0,TRUE,TRUE,TRUE,'R',0,0)
INSERT INTO BOTELLAS VALUES(38,9,9,9.0E0,9.0E0,TRUE,TRUE,TRUE,'R',0,0)
INSERT INTO BOTELLAS VALUES(39,9,9,9.0E0,9.0E0,TRUE,TRUE,TRUE,'F',0,0)
INSERT INTO BOTELLAS VALUES(40,9,NULL,NULL,9.0E0,TRUE,FALSE,FALSE,'F',0,0)
INSERT INTO BOTELLAS VALUES(41,9,NULL,NULL,9.0E0,TRUE,FALSE,FALSE,'F',0,0)
INSERT INTO BOTELLAS VALUES(42,9,NULL,NULL,9.0E0,TRUE,FALSE,FALSE,'F',0,0)
INSERT INTO BOTELLAS VALUES(43,9,NULL,NULL,9.0E0,TRUE,FALSE,FALSE,'F',0,0)
INSERT INTO BOTELLAS VALUES(44,9,NULL,NULL,9.0E0,TRUE,FALSE,FALSE,'F',0,0)
INSERT INTO BOTELLAS VALUES(45,9,NULL,NULL,9.0E0,TRUE,FALSE,FALSE,'F',0,0)
INSERT INTO BOTELLAS VALUES(46,9,NULL,NULL,9.0E0,TRUE,FALSE,FALSE,'F',0,0)
INSERT INTO BOTELLAS VALUES(47,9,9,9.0E0,9.0E0,TRUE,TRUE,TRUE,'F',0,0)
INSERT INTO BOTELLAS VALUES(48,9,9,9.0E0,9.0E0,TRUE,TRUE,TRUE,'F',0,0)
INSERT INTO BOTELLAS VALUES(49,9,9,9.0E0,9.0E0,TRUE,TRUE,TRUE,'F',0,0)
INSERT INTO BOTELLAS VALUES(50,9,9,9.0E0,9.0E0,TRUE,TRUE,TRUE,'F',0,0)
INSERT INTO BOTELLAS VALUES(51,9,9,9.0E0,9.0E0,TRUE,TRUE,TRUE,'F',0,0)
INSERT INTO BOTELLAS VALUES(52,9,9,9.0E0,9.0E0,TRUE,TRUE,TRUE,'F',0,0)
INSERT INTO BOTELLAS VALUES(53,9,9,9.0E0,9.0E0,TRUE,TRUE,TRUE,'F',0,0)
INSERT INTO BOTELLAS VALUES(54,9,9,9.0E0,9.0E0,TRUE,TRUE,TRUE,'F',0,0)
INSERT INTO BOTELLAS VALUES(55,9,9,9.0E0,9.0E0,TRUE,TRUE,TRUE,'F',0,0)
INSERT INTO CONFIGURACION VALUES('cantidad_lote',100.0E0)
INSERT INTO CONFIGURACION VALUES('capacidad_barrica',100.0E0)
INSERT INTO CONFIGURACION VALUES('capacidad_botella',1.0E0)
INSERT INTO CONFIGURACION VALUES('capacidad_cuba',100.0E0)
INSERT INTO CONFIGURACION VALUES('capacidad_litros',1500.0E0)
INSERT INTO CONFIGURACION VALUES('procesando_litros',0.0E0)
INSERT INTO CONFIGURACION VALUES('relacion',0.8E0)
INSERT INTO CONFIGURACION VALUES('t_cuba',100.0E0)
INSERT INTO CONFIGURACION VALUES('t_env_crianza',200.0E0)
INSERT INTO CONFIGURACION VALUES('t_env_joven',0.0E0)
INSERT INTO CONFIGURACION VALUES('t_env_reserva',300.0E0)
INSERT INTO CONFIGURACION VALUES('t_rep_crianza',200.0E0)
INSERT INTO CONFIGURACION VALUES('t_rep_joven',100.0E0)
INSERT INTO CONFIGURACION VALUES('t_rep_reserva',300.0E0)
INSERT INTO INDICE VALUES('analisis',36)
INSERT INTO INDICE VALUES('barricas_libres',10)
INSERT INTO INDICE VALUES('barricas_max',10)
INSERT INTO INDICE VALUES('calidad',35)
INSERT INTO INDICE VALUES('cliente',1)
INSERT INTO INDICE VALUES('crianza',0)
INSERT INTO INDICE VALUES('hoja_d',2)
INSERT INTO INDICE VALUES('id_camion',65)
INSERT INTO INDICE VALUES('inspeccion',39)
INSERT INTO INDICE VALUES('joven',320)
INSERT INTO INDICE VALUES('lote',81)
INSERT INTO INDICE VALUES('lote_botellas',9)
INSERT INTO INDICE VALUES('num_botellas',500)
INSERT INTO INDICE VALUES('pedido',1)
INSERT INTO INDICE VALUES('reserva',380)
INSERT INTO CAMIONES VALUES(1,'Castilla',1,150.0E0,120.0E0,FALSE,'2012-09-11')
INSERT INTO CAMIONES VALUES(2,'Castilla',1,100.0E0,100.0E0,FALSE,'2012-09-11')
INSERT INTO CAMIONES VALUES(3,'Castilla',1,100.0E0,100.0E0,FALSE,'2012-09-11')
INSERT INTO CAMIONES VALUES(4,'Castilla',1,100.0E0,100.0E0,FALSE,'2012-09-11')
INSERT INTO CAMIONES VALUES(5,'Castilla',1,100.0E0,100.0E0,FALSE,'2012-09-11')
INSERT INTO CAMIONES VALUES(6,'Castilla',1,100.0E0,100.0E0,FALSE,'2012-09-11')
INSERT INTO CAMIONES VALUES(7,'Castilla',1,100.0E0,100.0E0,FALSE,'2012-09-11')
INSERT INTO CAMIONES VALUES(8,'Castilla',1,100.0E0,100.0E0,FALSE,'2012-09-12')
INSERT INTO CAMIONES VALUES(9,'c',1,100.0E0,100.0E0,FALSE,'2012-09-12')
INSERT INTO CAMIONES VALUES(10,'Castilla',1,100.0E0,100.0E0,FALSE,'2012-09-12')
INSERT INTO CAMIONES VALUES(11,'Castilla',1,100.0E0,100.0E0,FALSE,'2012-09-12')
INSERT INTO CAMIONES VALUES(12,'Castilla',1,100.0E0,100.0E0,FALSE,'2012-09-12')
INSERT INTO CAMIONES VALUES(13,'Castilla',1,100.0E0,100.0E0,FALSE,'2012-09-12')
INSERT INTO CAMIONES VALUES(14,'Castilla',1,100.0E0,100.0E0,FALSE,'2012-09-12')
INSERT INTO CAMIONES VALUES(15,'Castilla',1,100.0E0,100.0E0,FALSE,'2012-09-12')
INSERT INTO CAMIONES VALUES(16,'Castilla',1,100.0E0,100.0E0,FALSE,'2012-09-13')
INSERT INTO CAMIONES VALUES(17,'Castilla',1,500.0E0,250.0E0,FALSE,'2012-09-13')
INSERT INTO CAMIONES VALUES(18,'C',1,250.0E0,250.0E0,FALSE,'2012-09-13')
INSERT INTO CAMIONES VALUES(19,'c',1,120.0E0,120.0E0,FALSE,'2012-09-13')
INSERT INTO CAMIONES VALUES(20,'C',1,140.0E0,140.0E0,FALSE,'2012-09-13')
INSERT INTO CAMIONES VALUES(21,'c',1,100.0E0,100.0E0,FALSE,'2012-09-17')
INSERT INTO CAMIONES VALUES(22,'c',1,100.0E0,100.0E0,FALSE,'2012-09-17')
INSERT INTO CAMIONES VALUES(23,'c',1,200.0E0,200.0E0,FALSE,'2012-09-17')
INSERT INTO CAMIONES VALUES(24,'c',1,200.0E0,200.0E0,FALSE,'2012-09-17')
INSERT INTO CAMIONES VALUES(25,'c',1,200.0E0,200.0E0,FALSE,'2012-09-17')
INSERT INTO CAMIONES VALUES(26,'cc',1,200.0E0,200.0E0,FALSE,'2012-09-17')
INSERT INTO CAMIONES VALUES(27,'c',1,100.0E0,100.0E0,FALSE,'2012-09-17')
INSERT INTO CAMIONES VALUES(28,'c',1,100.0E0,100.0E0,FALSE,'2012-09-17')
INSERT INTO CAMIONES VALUES(29,'c',1,100.0E0,100.0E0,FALSE,'2012-09-17')
INSERT INTO CAMIONES VALUES(30,'c',1,200.0E0,200.0E0,FALSE,'2012-09-17')
INSERT INTO CAMIONES VALUES(31,'c',1,100.0E0,100.0E0,FALSE,'2012-09-17')
INSERT INTO CAMIONES VALUES(32,'c',1,200.0E0,200.0E0,FALSE,'2012-09-17')
INSERT INTO CAMIONES VALUES(33,'c',1,100.0E0,100.0E0,FALSE,'2012-09-17')
INSERT INTO CAMIONES VALUES(34,'c',1,100.0E0,100.0E0,FALSE,'2012-09-17')
INSERT INTO CAMIONES VALUES(35,'a',1,200.0E0,200.0E0,FALSE,'2012-09-17')
INSERT INTO CAMIONES VALUES(36,'c',1,200.0E0,200.0E0,FALSE,'2012-09-17')
INSERT INTO CAMIONES VALUES(37,'c',1,100.0E0,100.0E0,FALSE,'2012-09-17')
INSERT INTO CAMIONES VALUES(38,'s',1,1.0E0,1.0E0,FALSE,'2012-09-17')
INSERT INTO CAMIONES VALUES(39,'c',1,200.0E0,200.0E0,FALSE,'2012-09-17')
INSERT INTO CAMIONES VALUES(40,'c',1,1.0E0,1.0E0,FALSE,'2012-09-17')
INSERT INTO CAMIONES VALUES(41,'d',1,10.0E0,10.0E0,FALSE,'2012-09-17')
INSERT INTO CAMIONES VALUES(42,'c',1,200.0E0,200.0E0,FALSE,'2012-09-17')
INSERT INTO CAMIONES VALUES(43,'c',1,100.0E0,100.0E0,FALSE,'2012-09-17')
INSERT INTO CAMIONES VALUES(44,'c',1,100.0E0,100.0E0,FALSE,'2012-09-17')
INSERT INTO CAMIONES VALUES(45,'c',1,100.0E0,100.0E0,FALSE,'2012-09-17')
INSERT INTO CAMIONES VALUES(46,'c',1,100.0E0,100.0E0,FALSE,'2012-09-17')
INSERT INTO CAMIONES VALUES(47,'c',1,100.0E0,100.0E0,FALSE,'2012-09-17')
INSERT INTO CAMIONES VALUES(48,'c',1,100.0E0,100.0E0,FALSE,'2012-09-17')
INSERT INTO CAMIONES VALUES(49,'C',1,100.0E0,100.0E0,FALSE,'2012-09-17')
INSERT INTO CAMIONES VALUES(50,'C',1,100.0E0,100.0E0,FALSE,'2012-09-17')
INSERT INTO CAMIONES VALUES(51,'S',1,1.0E0,1.0E0,FALSE,'2012-09-17')
INSERT INTO CAMIONES VALUES(52,'C',1,7.0E0,7.0E0,FALSE,'2012-09-17')
INSERT INTO CAMIONES VALUES(53,'c',1,100.0E0,100.0E0,FALSE,'2012-09-17')
INSERT INTO CAMIONES VALUES(54,'c',1,100.0E0,100.0E0,FALSE,'2012-09-17')
INSERT INTO CAMIONES VALUES(55,'c',1,100.0E0,100.0E0,FALSE,'2012-09-17')
INSERT INTO CAMIONES VALUES(56,'c',1,100.0E0,100.0E0,FALSE,'2012-09-17')
INSERT INTO CAMIONES VALUES(57,'c',1,200.0E0,200.0E0,FALSE,'2012-09-19')
INSERT INTO CAMIONES VALUES(58,'c',1,100.0E0,100.0E0,FALSE,'2012-09-19')
INSERT INTO CAMIONES VALUES(59,'c',1,200.0E0,200.0E0,FALSE,'2012-09-19')
INSERT INTO CAMIONES VALUES(60,'c',1,100.0E0,NULL,TRUE,'2012-09-19')
INSERT INTO CAMIONES VALUES(61,'c',1,200.0E0,200.0E0,FALSE,'2012-09-19')
INSERT INTO CAMIONES VALUES(62,'c',1,200.0E0,200.0E0,FALSE,'2012-09-19')
INSERT INTO CAMIONES VALUES(63,'c',1,200.0E0,200.0E0,FALSE,'2012-09-19')
INSERT INTO CAMIONES VALUES(64,'a',1,100.0E0,100.0E0,FALSE,'2012-11-07')
INSERT INTO CALIDAD VALUES(1,NULL,NULL,TRUE,TRUE,' Comentario de la inspeccion.... ',' Comentario de la inspeccion.... ',FALSE,NULL)
INSERT INTO CALIDAD VALUES(2,NULL,NULL,TRUE,TRUE,' Comentario de la inspeccion.... ',' Comentario de la inspeccion.... ',FALSE,NULL)
INSERT INTO CALIDAD VALUES(5,NULL,NULL,TRUE,TRUE,' Comentario de la inspeccion.... ',' Comentario de la inspeccion.... ',FALSE,NULL)
INSERT INTO CALIDAD VALUES(6,NULL,NULL,TRUE,TRUE,' Comentario de la inspeccion.... ',' Comentario de la inspeccion.... ',FALSE,NULL)
INSERT INTO CALIDAD VALUES(7,NULL,NULL,FALSE,TRUE,' Comentario de la inspeccion.... ',' Comentario de la inspeccion.... ',FALSE,NULL)
INSERT INTO CALIDAD VALUES(8,NULL,NULL,TRUE,FALSE,' Comentario de la inspeccion.... ',' Comentario de la inspeccion.... ',FALSE,NULL)
INSERT INTO CALIDAD VALUES(9,NULL,NULL,TRUE,TRUE,' Comentario de la inspeccion.... ',' Comentario de la inspeccion.... ',TRUE,NULL)
INSERT INTO CALIDAD VALUES(10,NULL,NULL,TRUE,TRUE,' Comentario de la inspeccion.... ',' Comentario de la inspeccion.... ',FALSE,NULL)
INSERT INTO CALIDAD VALUES(11,NULL,NULL,TRUE,TRUE,' Comentario de la inspeccion.... ',' Comentario de la inspeccion.... ',FALSE,NULL)
INSERT INTO CALIDAD VALUES(12,NULL,NULL,TRUE,TRUE,' Comentario de la inspeccion.... ',' Comentario de la inspeccion.... ',FALSE,NULL)
INSERT INTO CALIDAD VALUES(13,NULL,NULL,TRUE,TRUE,' Comentario de la inspeccion.... ',' Comentario de la inspeccion.... ',FALSE,NULL)
INSERT INTO CALIDAD VALUES(14,NULL,NULL,FALSE,FALSE,' Comentario de la inspeccion.... ',' Comentario de la inspeccion.... ',TRUE,NULL)
INSERT INTO CALIDAD VALUES(15,NULL,NULL,TRUE,TRUE,' Comentario de la inspeccion.... ',' Comentario de la inspeccion.... ',FALSE,NULL)
INSERT INTO CALIDAD VALUES(16,NULL,NULL,TRUE,TRUE,' Comentario de la inspeccion.... ',' Comentario de la inspeccion.... ',FALSE,NULL)
INSERT INTO CALIDAD VALUES(17,NULL,NULL,TRUE,TRUE,' Comentario de la inspeccion.... ',' Comentario de la inspeccion.... ',FALSE,NULL)
INSERT INTO CALIDAD VALUES(18,NULL,NULL,TRUE,TRUE,' Comentario de la inspeccion.... ',' Comentario de la inspeccion.... ',FALSE,NULL)
INSERT INTO CALIDAD VALUES(19,NULL,NULL,TRUE,FALSE,' Comentario de la inspeccion.... ',' Comentario de la inspeccion.... ',FALSE,NULL)
INSERT INTO CALIDAD VALUES(20,NULL,NULL,TRUE,TRUE,' Comentario de la inspeccion.... ',' Comentario de la inspeccion.... ',FALSE,NULL)
INSERT INTO CALIDAD VALUES(21,NULL,NULL,TRUE,TRUE,' Comentario de la inspeccion.... ',' Comentario de la inspeccion.... ',FALSE,NULL)
INSERT INTO CALIDAD VALUES(22,NULL,NULL,TRUE,TRUE,' Comentario de la inspeccion.... ',' Comentario de la inspeccion.... ',FALSE,NULL)
INSERT INTO CALIDAD VALUES(23,NULL,NULL,TRUE,TRUE,' Comentario de la inspeccion.... ',' Comentario de la inspeccion.... ',FALSE,NULL)
INSERT INTO CALIDAD VALUES(24,NULL,NULL,TRUE,TRUE,' Comentario de la inspeccion.... ',' Comentario de la inspeccion.... ',FALSE,NULL)
INSERT INTO CALIDAD VALUES(25,NULL,NULL,TRUE,TRUE,' Comentario de la inspeccion.... ',' Comentario de la inspeccion.... ',FALSE,NULL)
INSERT INTO CALIDAD VALUES(26,NULL,NULL,TRUE,TRUE,' Comentario de la inspeccion.... ',' Comentario de la inspeccion.... ',FALSE,NULL)
INSERT INTO CALIDAD VALUES(27,NULL,NULL,TRUE,TRUE,' Comentario de la inspeccion.... ',' Comentario de la inspeccion.... ',FALSE,NULL)
INSERT INTO CALIDAD VALUES(28,NULL,NULL,TRUE,TRUE,' Comentario de la inspeccion.... ',' Comentario de la inspeccion.... ',FALSE,NULL)
INSERT INTO CALIDAD VALUES(29,NULL,NULL,TRUE,FALSE,' Comentario de la inspeccion.... ',' Comentario de la inspeccion.... ',FALSE,NULL)
INSERT INTO CALIDAD VALUES(30,NULL,NULL,TRUE,TRUE,' Comentario de la inspeccion.... ',' Comentario de la inspeccion.... ',FALSE,NULL)
INSERT INTO CALIDAD VALUES(31,NULL,NULL,TRUE,TRUE,' Comentario de la inspeccion.... ',' Comentario de la inspeccion.... ',FALSE,NULL)
INSERT INTO CALIDAD VALUES(32,NULL,NULL,TRUE,TRUE,' Comentario de la inspeccion.... ',' Comentario de la inspeccion.... ',FALSE,NULL)
INSERT INTO CALIDAD VALUES(33,NULL,NULL,TRUE,TRUE,' Comentario de la inspeccion.... ',' Comentario de la inspeccion.... ',FALSE,NULL)
INSERT INTO CALIDAD VALUES(34,NULL,NULL,TRUE,TRUE,' Comentario de la inspeccion.... ',' Comentario de la inspeccion.... ',FALSE,NULL)
INSERT INTO LOTE VALUES(0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
INSERT INTO LOTE VALUES(27,NULL,1,20,NULL,NULL,NULL,300.0E0,300.0E0,'R',100.0E0,1,100.0E0,NULL)
INSERT INTO LOTE VALUES(28,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,100.0E0,NULL,NULL,NULL)
INSERT INTO LOTE VALUES(29,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,100.0E0,NULL,NULL,NULL)
INSERT INTO LOTE VALUES(30,NULL,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,100.0E0,NULL,NULL,NULL)
INSERT INTO LOTE VALUES(31,NULL,1,21,NULL,NULL,NULL,200.0E0,200.0E0,'C',100.0E0,1,100.0E0,NULL)
INSERT INTO LOTE VALUES(32,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,100.0E0,NULL,NULL,NULL)
INSERT INTO LOTE VALUES(33,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,100.0E0,NULL,NULL,NULL)
INSERT INTO LOTE VALUES(34,NULL,1,22,NULL,NULL,NULL,0.0E0,100.0E0,'J',100.0E0,2,120.0E0,NULL)
INSERT INTO LOTE VALUES(35,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,100.0E0,NULL,NULL,NULL)
INSERT INTO LOTE VALUES(36,NULL,1,23,NULL,NULL,NULL,0.0E0,100.0E0,'J',100.0E0,2,200.0E0,NULL)
INSERT INTO LOTE VALUES(37,NULL,1,24,19,NULL,NULL,0.0E0,100.0E0,'J',100.0E0,2,200.0E0,NULL)
INSERT INTO LOTE VALUES(38,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,100.0E0,NULL,NULL,NULL)
INSERT INTO LOTE VALUES(39,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,100.0E0,NULL,NULL,NULL)
INSERT INTO LOTE VALUES(40,1,3,25,20,21,FALSE,0.0E0,100.0E0,'J',100.0E0,2,120.0E0,120)
INSERT INTO LOTE VALUES(41,NULL,3,26,NULL,NULL,NULL,NULL,NULL,'F',100.0E0,2,120.0E0,NULL)
INSERT INTO LOTE VALUES(42,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,100.0E0,NULL,NULL,NULL)
INSERT INTO LOTE VALUES(43,1,3,27,22,23,FALSE,0.0E0,100.0E0,'J',100.0E0,2,120.0E0,120)
INSERT INTO LOTE VALUES(44,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,100.0E0,NULL,NULL,NULL)
INSERT INTO LOTE VALUES(45,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,100.0E0,NULL,NULL,NULL)
INSERT INTO LOTE VALUES(46,1,3,28,24,25,FALSE,300.0E0,300.0E0,'R',100.0E0,1,100.0E0,100)
INSERT INTO LOTE VALUES(47,NULL,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,100.0E0,NULL,NULL,NULL)
INSERT INTO LOTE VALUES(48,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,100.0E0,NULL,NULL,NULL)
INSERT INTO LOTE VALUES(50,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,100.0E0,NULL,NULL,NULL)
INSERT INTO LOTE VALUES(51,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,100.0E0,NULL,NULL,NULL)
INSERT INTO LOTE VALUES(52,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,100.0E0,NULL,NULL,NULL)
INSERT INTO LOTE VALUES(53,1,2,29,26,27,FALSE,300.0E0,300.0E0,'R',100.0E0,1,80.0E0,80)
INSERT INTO LOTE VALUES(54,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,100.0E0,NULL,NULL,NULL)
INSERT INTO LOTE VALUES(55,NULL,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,100.0E0,NULL,NULL,NULL)
INSERT INTO LOTE VALUES(56,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,100.0E0,NULL,NULL,NULL)
INSERT INTO LOTE VALUES(57,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,100.0E0,NULL,NULL,NULL)
INSERT INTO LOTE VALUES(58,NULL,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,100.0E0,NULL,NULL,NULL)
INSERT INTO LOTE VALUES(59,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,100.0E0,NULL,NULL,NULL)
INSERT INTO LOTE VALUES(60,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,100.0E0,NULL,NULL,NULL)
INSERT INTO LOTE VALUES(61,NULL,3,30,28,29,NULL,200.0E0,200.0E0,'C',100.0E0,1,80.0E0,80)
INSERT INTO LOTE VALUES(62,NULL,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,100.0E0,NULL,NULL,NULL)
INSERT INTO LOTE VALUES(63,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,100.0E0,NULL,NULL,NULL)
INSERT INTO LOTE VALUES(64,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,100.0E0,NULL,NULL,NULL)
INSERT INTO LOTE VALUES(65,NULL,1,31,NULL,NULL,NULL,300.0E0,300.0E0,'R',100.0E0,1,80.0E0,NULL)
INSERT INTO LOTE VALUES(66,NULL,1,32,NULL,NULL,NULL,300.0E0,300.0E0,'R',100.0E0,1,100.0E0,NULL)
INSERT INTO LOTE VALUES(67,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,100.0E0,NULL,NULL,NULL)
INSERT INTO LOTE VALUES(68,NULL,2,33,30,NULL,NULL,300.0E0,300.0E0,'R',100.0E0,1,100.0E0,100)
INSERT INTO LOTE VALUES(69,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,100.0E0,NULL,NULL,NULL)
INSERT INTO LOTE VALUES(70,NULL,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,100.0E0,NULL,NULL,NULL)
INSERT INTO LOTE VALUES(71,1,1,34,31,32,FALSE,0.0E0,100.0E0,'J',100.0E0,1,80.0E0,80)
INSERT INTO LOTE VALUES(72,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,100.0E0,NULL,NULL,NULL)
INSERT INTO LOTE VALUES(73,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,100.0E0,NULL,NULL,NULL)
INSERT INTO LOTE VALUES(74,NULL,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,100.0E0,NULL,NULL,NULL)
INSERT INTO LOTE VALUES(75,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,100.0E0,NULL,NULL,NULL)
INSERT INTO LOTE VALUES(76,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,100.0E0,NULL,NULL,NULL)
INSERT INTO LOTE VALUES(77,1,3,35,33,34,FALSE,300.0E0,300.0E0,'R',100.0E0,1,100.0E0,100)
INSERT INTO LOTE VALUES(78,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,100.0E0,NULL,NULL,NULL)
INSERT INTO LOTE VALUES(79,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,100.0E0,NULL,NULL,NULL)
INSERT INTO LOTE VALUES(80,NULL,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,100.0E0,NULL,NULL,NULL)
e-REdING. Biblioteca de la Escuela Superior de Ingenieros de Sevilla.
