DROP TABLE IF EXISTS attr;
DROP TABLE IF EXISTS data;
DROP TABLE IF EXISTS context;
DROP TABLE IF EXISTS pseudoana;
DROP TABLE IF EXISTS repinfo;
CREATE TABLE repinfo (   id		     SMALLINT PRIMARY KEY,	memo	 	 VARCHAR(30) NOT NULL,	description	 VARCHAR(255) NOT NULL,   prio	     INTEGER NOT NULL,	descriptor	 CHAR(6) NOT NULL,	tablea		 INTEGER NOT NULL) TYPE=InnoDB;
CREATE TABLE pseudoana (   id         INTEGER auto_increment PRIMARY KEY,   lat        INTEGER NOT NULL,   lon        INTEGER NOT NULL,   ident      CHAR(64),   UNIQUE INDEX(lat, lon, ident(8)),   INDEX(lon)) TYPE=InnoDB;
CREATE TABLE context (   id			INTEGER auto_increment PRIMARY KEY,   id_ana		INTEGER NOT NULL,	id_report	SMALLINT NOT NULL,   datetime	DATETIME NOT NULL,	ltype		SMALLINT NOT NULL,	l1			INTEGER NOT NULL,	l2			INTEGER NOT NULL,	ptype		SMALLINT NOT NULL,	p1			INTEGER NOT NULL,	p2			INTEGER NOT NULL,   UNIQUE INDEX (id_ana, datetime, ltype, l1, l2, ptype, p1, p2, id_report),   INDEX (id_ana),   INDEX (id_report),   INDEX (datetime),   INDEX (ltype, l1, l2),   INDEX (ptype, p1, p2)) TYPE=InnoDB;
CREATE TABLE data (   id_context	INTEGER NOT NULL,	id_var		SMALLINT NOT NULL,	value		VARCHAR(255) NOT NULL,	INDEX (id_context),   UNIQUE INDEX(id_var, id_context)) TYPE=InnoDB;
CREATE TABLE attr (   id_context	INTEGER NOT NULL,	id_var		SMALLINT NOT NULL,   type		SMALLINT NOT NULL,   value		VARCHAR(255) NOT NULL,   INDEX (id_context, id_var),   UNIQUE INDEX (id_context, id_var, type)) TYPE=InnoDB;
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (1, 'synop', 'report synottico', 100, 'oss', 0);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (2, 'metar', 'metar', 80, 'oss', 0);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (3, 'temp', 'radiosondaggio', 100, 'oss', 2);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (4, 'pilot', 'sondaggi pilot', 80, 'oss', 2);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (9, 'boe', 'dati omdametrici', 100, 'oss', 31);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (10, 'ship', 'synop da nave', 100, 'oss', 1);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (11, 'tempship', 'temp da nave', 100, 'oss', 2);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (12, 'airep', 'airep', 80, 'oss', 4);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (13, 'amdar', 'amdar', 100, 'oss', 4);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (14, 'acars', 'acars', 100, 'oss', 4);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (50, 'regioni', 'dati regioni per verifica LAMI', 100, 'oss', 255);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (105, 'ana', 'campi analizzati tramite modello meteo', 0, 'ana', 255);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (106, 'ossmed04', 'osservati media su box 0.4', 0, 'oss', 255);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (107, 'ossmax04', 'osservati massimo su box 0.4', 0, 'oss', 255);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (108, 'ossmed05', 'osservati media su box 0.5', 0, 'oss', 255);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (109, 'ossmax05', 'osservati massimo su box 0.5', 0, 'oss', 255);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (110, 'lmsmr2031spnpo', 'previsione LAMI nudging 35 livelli interpolato punto piu\' vicino', -10, 'pre', 255);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (111, 'lmsmr2031spbil', 'previsione LAMI nudging 35 livelli interpolato 4 punti piu\' vicini', -10, 'pre', 255);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (112, 'lmsmr2032spnpo', 'previsione LAMI prognostica 35 livelli interpolato punto piu\' vicino', -10, 'pre', 255);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (113, 'lmsmr2032spbil', 'previsione LAMI prognostica 35 livelli interpolato 4 punti piu\' vicini', -10, 'pre', 255);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (114, 'lmsmr3032spnpo', 'previsione LAMI prognostica 40 livelli interpolato punto piu\' vicino', -1, 'pre', 255);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (115, 'lmsmr3032spbil', 'previsione LAMI prognostica 40 livelli interpolato 4 punti piu\' vicini', -1, 'pre', 255);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (116, 'lmsmr3033spnpo', 'previsione LAMI Runge-Kutta 40 livelli interpolato punto piu\' vicino', -1, 'pre', 255);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (117, 'lmsmr3033spbil', 'previsione LAMI Runge-Kutta 40 livelli interpolato 4 punti piu\' vicini', -1, 'pre', 255);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (118, 'lmdetspnpo', 'previsione LM su ECMWF (deterministico di COSMO-LEPS) 35 livelli interpolato punto piu\' vicino', -1, 'pre', 255);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (119, 'lmdet40spnpo', 'previsione LM su ECMWF (deterministico di COSMO-LEPS) 40 livelli interpolato 4 punti piu\' vicini', -1, 'pre', 255);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (120, 'lmsmr2031med04', 'previsione LAMI nudging 35 livelli media su box 0.4', -1, 'pre', 255);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (121, 'lmsmr2032med04', 'previsione LAMI prognostica 35 livelli media su box 0.4', -10, 'pre', 255);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (122, 'lmsmr3032med04', 'previsione LAMI prognostica 40 livelli media su box 0.4', -10, 'pre', 255);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (123, 'lmsmr3033med04', 'previsione LAMI Runge-Kutta 40 livelli media su box 0.4', -1, 'pre', 255);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (124, 'lmdet40med04', 'previsione LM su ECMWF (deterministico di COSMO-LEPS) 40 livelli media su box 0.4', -1, 'pre', 255);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (125, 'lmsmr2031max04', 'previsione LAMI nudging 35 livelli massimo su box 0.4', -1, 'pre', 255);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (126, 'lmsmr2032max04', 'previsione LAMI prognostica 35 livelli massimo su box 0.4', -10, 'pre', 255);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (127, 'lmsmr3032max04', 'previsione LAMI prognostica 40 livelli massimo su box 0.4', -10, 'pre', 255);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (128, 'lmsmr3033max04', 'previsione LAMI Runge-Kutta 40 livelli massimo su box 0.4', -1, 'pre', 255);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (129, 'lmdet40max04', 'previsione LM su ECMWF (deterministico di COSMO-LEPS) 40 livelli massimo su box 0.4', -1, 'pre', 255);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (130, 'clepsmed05el001', 'previsti COSMO-LEPS media su box 0.5 elemento 1', -10, 'pre', 255);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (131, 'clepsmed05el002', 'previsti COSMO-LEPS media su box 0.5 elemento 2', -10, 'pre', 255);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (132, 'clepsmed05el003', 'previsti COSMO-LEPS media su box 0.5 elemento 3', -10, 'pre', 255);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (133, 'clepsmed05el004', 'previsti COSMO-LEPS media su box 0.5 elemento 4', -10, 'pre', 255);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (134, 'clepsmed05el005', 'previsti COSMO-LEPS media su box 0.5 elemento 5', -10, 'pre', 255);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (135, 'clepsmed05el006', 'previsti COSMO-LEPS media su box 0.5 elemento 6', -10, 'pre', 255);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (136, 'clepsmed05el007', 'previsti COSMO-LEPS media su box 0.5 elemento 7', -10, 'pre', 255);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (137, 'clepsmed05el008', 'previsti COSMO-LEPS media su box 0.5 elemento 8', -10, 'pre', 255);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (138, 'clepsmed05el009', 'previsti COSMO-LEPS media su box 0.5 elemento 9', -10, 'pre', 255);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (139, 'clepsmed05el010', 'previsti COSMO-LEPS media su box 0.5 elemento 10', -10, 'pre', 255);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (140, 'clepsspnpoel001', 'previsti COSMO-LEPS interpolato npo elemento 1', -10, 'pre', 255);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (141, 'clepsspnpoel002', 'previsti COSMO-LEPS interpolato npo elemento 2', -10, 'pre', 255);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (142, 'clepsspnpoel003', 'previsti COSMO-LEPS interpolato npo elemento 3', -10, 'pre', 255);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (143, 'clepsspnpoel004', 'previsti COSMO-LEPS interpolato npo elemento 4', -10, 'pre', 255);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (144, 'clepsspnpoel005', 'previsti COSMO-LEPS interpolato npo elemento 5', -10, 'pre', 255);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (145, 'clepsspnpoel006', 'previsti COSMO-LEPS interpolato npo elemento 6', -10, 'pre', 255);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (146, 'clepsspnpoel007', 'previsti COSMO-LEPS interpolato npo elemento 7', -10, 'pre', 255);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (147, 'clepsspnpoel008', 'previsti COSMO-LEPS interpolato npo elemento 8', -10, 'pre', 255);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (148, 'clepsspnpoel009', 'previsti COSMO-LEPS interpolato npo elemento 9', -10, 'pre', 255);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (149, 'clepsspnpoel010', 'previsti COSMO-LEPS interpolato npo elemento 10', -10, 'pre', 255);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (160, 'necmwfeuspnpo', 'previsti ECMWF IFS interpolato punto piu\' vicino', -10, 'pre', 255);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (161, 'necmwfeuspbil', 'previsti ECMWF IFS interpolato 4 punti piu\' vicini', -10, 'pre', 255);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (162, 'necmwfeumed05', 'previsti ECMWF IFS media su box 0.5', -10, 'pre', 255);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (163, 'necmwfeumax05', 'previsti ECMWF IFS massimo su box 0.5', -10, 'pre', 255);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (254, 'ana', 'dati anagrafici', 100, '?', 255);
INSERT INTO repinfo (id, memo, description, prio, descriptor, tablea)     VALUES (255, 'generic', 'export generici da DB Meteo', 0, '?', 255);
BEGIN;
SELECT id FROM pseudoana WHERE lat=3388000 AND lon=-553000 AND ident IS NULL;
INSERT INTO pseudoana (lat, lon, ident) VALUES (3388000, -553000, NULL);
SELECT LAST_INSERT_ID();
SELECT id FROM context WHERE id_ana=1 AND id_report=254 AND datetime='1000-01-01 00:00:00' AND ltype=257 AND l1=0 AND l2=0 AND ptype=0 AND p1=0 AND p2=0;
INSERT INTO context VALUES (NULL, 1, 254, '1000-01-01 00:00:00', 257, 0, 0, 0, 0, 0);
SELECT LAST_INSERT_ID();
INSERT INTO data (id_context, id_var, value) VALUES(1, 257, '60');
INSERT INTO attr (id_context, id_var, type, value) VALUES(1, 257, 8455, '70');
INSERT INTO data (id_context, id_var, value) VALUES(1, 258, '150');
INSERT INTO attr (id_context, id_var, type, value) VALUES(1, 258, 8455, '70');
INSERT INTO data (id_context, id_var, value) VALUES(1, 513, '1');
INSERT INTO attr (id_context, id_var, type, value) VALUES(1, 513, 8455, '70');
INSERT INTO data (id_context, id_var, value) VALUES(1, 1025, '2004');
INSERT INTO attr (id_context, id_var, type, value) VALUES(1, 1025, 8455, '70');
INSERT INTO data (id_context, id_var, value) VALUES(1, 1026, '11');
INSERT INTO attr (id_context, id_var, type, value) VALUES(1, 1026, 8455, '70');
INSERT INTO data (id_context, id_var, value) VALUES(1, 1027, '30');
INSERT INTO attr (id_context, id_var, type, value) VALUES(1, 1027, 8455, '70');
INSERT INTO data (id_context, id_var, value) VALUES(1, 1028, '12');
INSERT INTO attr (id_context, id_var, type, value) VALUES(1, 1028, 8455, '70');
INSERT INTO data (id_context, id_var, value) VALUES(1, 1029, '0');
INSERT INTO attr (id_context, id_var, type, value) VALUES(1, 1029, 8455, '70');
INSERT INTO data (id_context, id_var, value) VALUES(1, 1281, '3388000');
INSERT INTO attr (id_context, id_var, type, value) VALUES(1, 1281, 8455, '70');
INSERT INTO data (id_context, id_var, value) VALUES(1, 1537, '-553000');
INSERT INTO attr (id_context, id_var, type, value) VALUES(1, 1537, 8455, '70');
INSERT INTO data (id_context, id_var, value) VALUES(1, 1793, '560');
INSERT INTO attr (id_context, id_var, type, value) VALUES(1, 1793, 8455, '75');
SELECT id FROM context WHERE id_ana=1 AND id_report=1 AND datetime='2004-11-30 12:00:00' AND ltype=1 AND l1=0 AND l2=0 AND ptype=0 AND p1=0 AND p2=0;
INSERT INTO context VALUES (NULL, 1, 1, '2004-11-30 12:00:00', 1, 0, 0, 0, 0, 0);
SELECT LAST_INSERT_ID();
INSERT INTO data (id_context, id_var, value) VALUES(2, 2564, '9419');
INSERT INTO attr (id_context, id_var, type, value) VALUES(2, 2564, 8455, '74');
INSERT INTO data (id_context, id_var, value) VALUES(2, 5121, '800');
INSERT INTO attr (id_context, id_var, type, value) VALUES(2, 5121, 8455, '82');
INSERT INTO data (id_context, id_var, value) VALUES(2, 5123, '2');
INSERT INTO attr (id_context, id_var, type, value) VALUES(2, 5123, 8455, '85');
SELECT id FROM context WHERE id_ana=1 AND id_report=1 AND datetime='2004-11-30 12:00:00' AND ltype=1 AND l1=0 AND l2=0 AND ptype=2 AND p1=-21600 AND p2=0;
INSERT INTO context VALUES (NULL, 1, 1, '2004-11-30 12:00:00', 1, 0, 0, 2, -21600, 0);
SELECT LAST_INSERT_ID();
INSERT INTO data (id_context, id_var, value) VALUES(3, 5124, '6');
INSERT INTO attr (id_context, id_var, type, value) VALUES(3, 5124, 8455, '70');
INSERT INTO data (id_context, id_var, value) VALUES(3, 5125, '2');
INSERT INTO attr (id_context, id_var, type, value) VALUES(3, 5125, 8455, '70');
SELECT id FROM context WHERE id_ana=1 AND id_report=1 AND datetime='2004-11-30 12:00:00' AND ltype=1 AND l1=0 AND l2=0 AND ptype=2 AND p1=-10800 AND p2=0;
INSERT INTO context VALUES (NULL, 1, 1, '2004-11-30 12:00:00', 1, 0, 0, 2, -10800, 0);
SELECT LAST_INSERT_ID();
INSERT INTO data (id_context, id_var, value) VALUES(4, 2623, '8');
INSERT INTO attr (id_context, id_var, type, value) VALUES(4, 2623, 8455, '79');
SELECT id FROM context WHERE id_ana=1 AND id_report=1 AND datetime='2004-11-30 12:00:00' AND ltype=1 AND l1=0 AND l2=0 AND ptype=5 AND p1=-10800 AND p2=0;
INSERT INTO context VALUES (NULL, 1, 1, '2004-11-30 12:00:00', 1, 0, 0, 5, -10800, 0);
SELECT LAST_INSERT_ID();
INSERT INTO data (id_context, id_var, value) VALUES(5, 2621, '-18');
INSERT INTO attr (id_context, id_var, type, value) VALUES(5, 2621, 8455, '77');
SELECT id FROM context WHERE id_ana=1 AND id_report=1 AND datetime='2004-11-30 12:00:00' AND ltype=102 AND l1=0 AND l2=0 AND ptype=0 AND p1=0 AND p2=0;
INSERT INTO context VALUES (NULL, 1, 1, '2004-11-30 12:00:00', 102, 0, 0, 0, 0, 0);
SELECT LAST_INSERT_ID();
INSERT INTO data (id_context, id_var, value) VALUES(6, 2611, '10054');
INSERT INTO attr (id_context, id_var, type, value) VALUES(6, 2611, 8455, '74');
SELECT id FROM context WHERE id_ana=1 AND id_report=1 AND datetime='2004-11-30 12:00:00' AND ltype=105 AND l1=2 AND l2=0 AND ptype=0 AND p1=0 AND p2=0;
INSERT INTO context VALUES (NULL, 1, 1, '2004-11-30 12:00:00', 105, 2, 0, 0, 0, 0);
SELECT LAST_INSERT_ID();
INSERT INTO data (id_context, id_var, value) VALUES(7, 3073, '2892');
INSERT INTO attr (id_context, id_var, type, value) VALUES(7, 3073, 8455, '80');
INSERT INTO data (id_context, id_var, value) VALUES(7, 3075, '2857');
INSERT INTO attr (id_context, id_var, type, value) VALUES(7, 3075, 8455, '77');
SELECT id FROM context WHERE id_ana=1 AND id_report=1 AND datetime='2004-11-30 12:00:00' AND ltype=105 AND l1=10 AND l2=0 AND ptype=0 AND p1=0 AND p2=0;
INSERT INTO context VALUES (NULL, 1, 1, '2004-11-30 12:00:00', 105, 10, 0, 0, 0, 0);
SELECT LAST_INSERT_ID();
INSERT INTO data (id_context, id_var, value) VALUES(8, 2817, '80');
INSERT INTO attr (id_context, id_var, type, value) VALUES(8, 2817, 8455, '70');
INSERT INTO data (id_context, id_var, value) VALUES(8, 2818, '40');
INSERT INTO attr (id_context, id_var, type, value) VALUES(8, 2818, 8455, '70');
SELECT id FROM context WHERE id_ana=1 AND id_report=1 AND datetime='2004-11-30 12:00:00' AND ltype=256 AND l1=0 AND l2=0 AND ptype=0 AND p1=0 AND p2=0;
INSERT INTO context VALUES (NULL, 1, 1, '2004-11-30 12:00:00', 256, 0, 0, 0, 0, 0);
SELECT LAST_INSERT_ID();
INSERT INTO data (id_context, id_var, value) VALUES(9, 5130, '100');
INSERT INTO attr (id_context, id_var, type, value) VALUES(9, 5130, 8455, '85');
INSERT INTO data (id_context, id_var, value) VALUES(9, 5131, '8');
INSERT INTO attr (id_context, id_var, type, value) VALUES(9, 5131, 8455, '85');
INSERT INTO data (id_context, id_var, value) VALUES(9, 5133, '250');
INSERT INTO attr (id_context, id_var, type, value) VALUES(9, 5133, 8455, '84');
SELECT id FROM context WHERE id_ana=1 AND id_report=1 AND datetime='2004-11-30 12:00:00' AND ltype=256 AND l1=0 AND l2=1 AND ptype=0 AND p1=0 AND p2=0;
INSERT INTO context VALUES (NULL, 1, 1, '2004-11-30 12:00:00', 256, 0, 1, 0, 0, 0);
SELECT LAST_INSERT_ID();
INSERT INTO data (id_context, id_var, value) VALUES(10, 5132, '39');
INSERT INTO attr (id_context, id_var, type, value) VALUES(10, 5132, 8455, '85');
SELECT id FROM context WHERE id_ana=1 AND id_report=1 AND datetime='2004-11-30 12:00:00' AND ltype=256 AND l1=0 AND l2=2 AND ptype=0 AND p1=0 AND p2=0;
INSERT INTO context VALUES (NULL, 1, 1, '2004-11-30 12:00:00', 256, 0, 2, 0, 0, 0);
SELECT LAST_INSERT_ID();
INSERT INTO data (id_context, id_var, value) VALUES(11, 5132, '61');
INSERT INTO attr (id_context, id_var, type, value) VALUES(11, 5132, 8455, '85');
SELECT id FROM context WHERE id_ana=1 AND id_report=1 AND datetime='2004-11-30 12:00:00' AND ltype=256 AND l1=0 AND l2=3 AND ptype=0 AND p1=0 AND p2=0;
INSERT INTO context VALUES (NULL, 1, 1, '2004-11-30 12:00:00', 256, 0, 3, 0, 0, 0);
SELECT LAST_INSERT_ID();
INSERT INTO data (id_context, id_var, value) VALUES(12, 5132, '60');
INSERT INTO attr (id_context, id_var, type, value) VALUES(12, 5132, 8455, '85');
SELECT id FROM context WHERE id_ana=1 AND id_report=1 AND datetime='2004-11-30 12:00:00' AND ltype=256 AND l1=1 AND l2=0 AND ptype=0 AND p1=0 AND p2=0;
INSERT INTO context VALUES (NULL, 1, 1, '2004-11-30 12:00:00', 256, 1, 0, 0, 0, 0);
SELECT LAST_INSERT_ID();
INSERT INTO data (id_context, id_var, value) VALUES(13, 5131, '2');
INSERT INTO attr (id_context, id_var, type, value) VALUES(13, 5131, 8455, '70');
INSERT INTO data (id_context, id_var, value) VALUES(13, 5132, '8');
INSERT INTO attr (id_context, id_var, type, value) VALUES(13, 5132, 8455, '70');
INSERT INTO data (id_context, id_var, value) VALUES(13, 5133, '320');
INSERT INTO attr (id_context, id_var, type, value) VALUES(13, 5133, 8455, '70');
SELECT id FROM context WHERE id_ana=1 AND id_report=1 AND datetime='2004-11-30 12:00:00' AND ltype=256 AND l1=2 AND l2=0 AND ptype=0 AND p1=0 AND p2=0;
INSERT INTO context VALUES (NULL, 1, 1, '2004-11-30 12:00:00', 256, 2, 0, 0, 0, 0);
SELECT LAST_INSERT_ID();
INSERT INTO data (id_context, id_var, value) VALUES(14, 5131, '5');
INSERT INTO attr (id_context, id_var, type, value) VALUES(14, 5131, 8455, '70');
INSERT INTO data (id_context, id_var, value) VALUES(14, 5132, '8');
INSERT INTO attr (id_context, id_var, type, value) VALUES(14, 5132, 8455, '70');
INSERT INTO data (id_context, id_var, value) VALUES(14, 5133, '620');
INSERT INTO attr (id_context, id_var, type, value) VALUES(14, 5133, 8455, '70');
SELECT id FROM context WHERE id_ana=1 AND id_report=1 AND datetime='2004-11-30 12:00:00' AND ltype=256 AND l1=3 AND l2=0 AND ptype=0 AND p1=0 AND p2=0;
INSERT INTO context VALUES (NULL, 1, 1, '2004-11-30 12:00:00', 256, 3, 0, 0, 0, 0);
SELECT LAST_INSERT_ID();
INSERT INTO data (id_context, id_var, value) VALUES(15, 5131, '2');
INSERT INTO attr (id_context, id_var, type, value) VALUES(15, 5131, 8455, '70');
INSERT INTO data (id_context, id_var, value) VALUES(15, 5132, '9');
INSERT INTO attr (id_context, id_var, type, value) VALUES(15, 5132, 8455, '70');
INSERT INTO data (id_context, id_var, value) VALUES(15, 5133, '920');
INSERT INTO attr (id_context, id_var, type, value) VALUES(15, 5133, 8455, '70');
COMMIT;
BEGIN;
SELECT id FROM pseudoana WHERE lat=4622000 AND lon=733000 AND ident IS NULL;
INSERT INTO pseudoana (lat, lon, ident) VALUES (4622000, 733000, NULL);
SELECT LAST_INSERT_ID();
SELECT id FROM context WHERE id_ana=2 AND id_report=254 AND datetime='1000-01-01 00:00:00' AND ltype=257 AND l1=0 AND l2=0 AND ptype=0 AND p1=0 AND p2=0;
INSERT INTO context VALUES (NULL, 2, 254, '1000-01-01 00:00:00', 257, 0, 0, 0, 0, 0);
SELECT LAST_INSERT_ID();
INSERT INTO data (id_context, id_var, value) VALUES(16, 257, '6');
INSERT INTO attr (id_context, id_var, type, value) VALUES(16, 257, 8455, '70');
INSERT INTO data (id_context, id_var, value) VALUES(16, 258, '720');
INSERT INTO attr (id_context, id_var, type, value) VALUES(16, 258, 8455, '70');
INSERT INTO data (id_context, id_var, value) VALUES(16, 513, '0');
INSERT INTO attr (id_context, id_var, type, value) VALUES(16, 513, 8455, '70');
INSERT INTO data (id_context, id_var, value) VALUES(16, 1025, '2004');
INSERT INTO attr (id_context, id_var, type, value) VALUES(16, 1025, 8455, '70');
INSERT INTO data (id_context, id_var, value) VALUES(16, 1026, '11');
INSERT INTO attr (id_context, id_var, type, value) VALUES(16, 1026, 8455, '70');
INSERT INTO data (id_context, id_var, value) VALUES(16, 1027, '30');
INSERT INTO attr (id_context, id_var, type, value) VALUES(16, 1027, 8455, '70');
INSERT INTO data (id_context, id_var, value) VALUES(16, 1028, '12');
INSERT INTO attr (id_context, id_var, type, value) VALUES(16, 1028, 8455, '70');
INSERT INTO data (id_context, id_var, value) VALUES(16, 1029, '0');
INSERT INTO attr (id_context, id_var, type, value) VALUES(16, 1029, 8455, '70');
INSERT INTO data (id_context, id_var, value) VALUES(16, 1281, '4622000');
INSERT INTO attr (id_context, id_var, type, value) VALUES(16, 1281, 8455, '70');
INSERT INTO data (id_context, id_var, value) VALUES(16, 1537, '733000');
INSERT INTO attr (id_context, id_var, type, value) VALUES(16, 1537, 8455, '70');
INSERT INTO data (id_context, id_var, value) VALUES(16, 1793, '481');
INSERT INTO attr (id_context, id_var, type, value) VALUES(16, 1793, 8455, '75');
SELECT id FROM context WHERE id_ana=2 AND id_report=1 AND datetime='2004-11-30 12:00:00' AND ltype=1 AND l1=0 AND l2=0 AND ptype=0 AND p1=0 AND p2=0;
INSERT INTO context VALUES (NULL, 2, 1, '2004-11-30 12:00:00', 1, 0, 0, 0, 0, 0);
SELECT LAST_INSERT_ID();
INSERT INTO data (id_context, id_var, value) VALUES(17, 2564, '9510');
INSERT INTO attr (id_context, id_var, type, value) VALUES(17, 2564, 8455, '74');
INSERT INTO data (id_context, id_var, value) VALUES(17, 5121, '500');
INSERT INTO attr (id_context, id_var, type, value) VALUES(17, 5121, 8455, '82');
INSERT INTO data (id_context, id_var, value) VALUES(17, 5123, '160');
INSERT INTO attr (id_context, id_var, type, value) VALUES(17, 5123, 8455, '85');
SELECT id FROM context WHERE id_ana=2 AND id_report=1 AND datetime='2004-11-30 12:00:00' AND ltype=1 AND l1=0 AND l2=0 AND ptype=2 AND p1=-21600 AND p2=0;
INSERT INTO context VALUES (NULL, 2, 1, '2004-11-30 12:00:00', 1, 0, 0, 2, -21600, 0);
SELECT LAST_INSERT_ID();
INSERT INTO data (id_context, id_var, value) VALUES(18, 5124, '16');
INSERT INTO attr (id_context, id_var, type, value) VALUES(18, 5124, 8455, '70');
INSERT INTO data (id_context, id_var, value) VALUES(18, 5125, '16');
INSERT INTO attr (id_context, id_var, type, value) VALUES(18, 5125, 8455, '70');
SELECT id FROM context WHERE id_ana=2 AND id_report=1 AND datetime='2004-11-30 12:00:00' AND ltype=1 AND l1=0 AND l2=0 AND ptype=2 AND p1=-10800 AND p2=0;
INSERT INTO context VALUES (NULL, 2, 1, '2004-11-30 12:00:00', 1, 0, 0, 2, -10800, 0);
SELECT LAST_INSERT_ID();
INSERT INTO data (id_context, id_var, value) VALUES(19, 2623, '0');
INSERT INTO attr (id_context, id_var, type, value) VALUES(19, 2623, 8455, '79');
SELECT id FROM context WHERE id_ana=2 AND id_report=1 AND datetime='2004-11-30 12:00:00' AND ltype=1 AND l1=0 AND l2=0 AND ptype=5 AND p1=-10800 AND p2=0;
INSERT INTO context VALUES (NULL, 2, 1, '2004-11-30 12:00:00', 1, 0, 0, 5, -10800, 0);
SELECT LAST_INSERT_ID();
INSERT INTO data (id_context, id_var, value) VALUES(20, 2621, '2');
INSERT INTO attr (id_context, id_var, type, value) VALUES(20, 2621, 8455, '77');
SELECT id FROM context WHERE id_ana=2 AND id_report=1 AND datetime='2004-11-30 12:00:00' AND ltype=102 AND l1=0 AND l2=0 AND ptype=0 AND p1=0 AND p2=0;
INSERT INTO context VALUES (NULL, 2, 1, '2004-11-30 12:00:00', 102, 0, 0, 0, 0, 0);
SELECT LAST_INSERT_ID();
INSERT INTO data (id_context, id_var, value) VALUES(21, 2611, '10083');
INSERT INTO attr (id_context, id_var, type, value) VALUES(21, 2611, 8455, '74');
SELECT id FROM context WHERE id_ana=2 AND id_report=1 AND datetime='2004-11-30 12:00:00' AND ltype=105 AND l1=2 AND l2=0 AND ptype=0 AND p1=0 AND p2=0;
INSERT INTO context VALUES (NULL, 2, 1, '2004-11-30 12:00:00', 105, 2, 0, 0, 0, 0);
SELECT LAST_INSERT_ID();
INSERT INTO data (id_context, id_var, value) VALUES(22, 3073, '2777');
INSERT INTO attr (id_context, id_var, type, value) VALUES(22, 3073, 8455, '80');
INSERT INTO data (id_context, id_var, value) VALUES(22, 3075, '2763');
INSERT INTO attr (id_context, id_var, type, value) VALUES(22, 3075, 8455, '77');
SELECT id FROM context WHERE id_ana=2 AND id_report=1 AND datetime='2004-11-30 12:00:00' AND ltype=105 AND l1=10 AND l2=0 AND ptype=0 AND p1=0 AND p2=0;
INSERT INTO context VALUES (NULL, 2, 1, '2004-11-30 12:00:00', 105, 10, 0, 0, 0, 0);
SELECT LAST_INSERT_ID();
INSERT INTO data (id_context, id_var, value) VALUES(23, 2817, '280');
INSERT INTO attr (id_context, id_var, type, value) VALUES(23, 2817, 8455, '70');
INSERT INTO data (id_context, id_var, value) VALUES(23, 2818, '10');
INSERT INTO attr (id_context, id_var, type, value) VALUES(23, 2818, 8455, '70');
SELECT id FROM context WHERE id_ana=2 AND id_report=1 AND datetime='2004-11-30 12:00:00' AND ltype=256 AND l1=0 AND l2=0 AND ptype=0 AND p1=0 AND p2=0;
INSERT INTO context VALUES (NULL, 2, 1, '2004-11-30 12:00:00', 256, 0, 0, 0, 0, 0);
SELECT LAST_INSERT_ID();
INSERT INTO data (id_context, id_var, value) VALUES(24, 5130, '100');
INSERT INTO attr (id_context, id_var, type, value) VALUES(24, 5130, 8455, '85');
INSERT INTO data (id_context, id_var, value) VALUES(24, 5131, '5');
INSERT INTO attr (id_context, id_var, type, value) VALUES(24, 5131, 8455, '85');
INSERT INTO data (id_context, id_var, value) VALUES(24, 5133, '450');
INSERT INTO attr (id_context, id_var, type, value) VALUES(24, 5133, 8455, '84');
SELECT id FROM context WHERE id_ana=2 AND id_report=1 AND datetime='2004-11-30 12:00:00' AND ltype=256 AND l1=0 AND l2=1 AND ptype=0 AND p1=0 AND p2=0;
INSERT INTO context VALUES (NULL, 2, 1, '2004-11-30 12:00:00', 256, 0, 1, 0, 0, 0);
SELECT LAST_INSERT_ID();
INSERT INTO data (id_context, id_var, value) VALUES(25, 5132, '37');
INSERT INTO attr (id_context, id_var, type, value) VALUES(25, 5132, 8455, '85');
SELECT id FROM context WHERE id_ana=2 AND id_report=1 AND datetime='2004-11-30 12:00:00' AND ltype=256 AND l1=0 AND l2=2 AND ptype=0 AND p1=0 AND p2=0;
INSERT INTO context VALUES (NULL, 2, 1, '2004-11-30 12:00:00', 256, 0, 2, 0, 0, 0);
SELECT LAST_INSERT_ID();
INSERT INTO data (id_context, id_var, value) VALUES(26, 5132, '22');
INSERT INTO attr (id_context, id_var, type, value) VALUES(26, 5132, 8455, '85');
SELECT id FROM context WHERE id_ana=2 AND id_report=1 AND datetime='2004-11-30 12:00:00' AND ltype=256 AND l1=0 AND l2=3 AND ptype=0 AND p1=0 AND p2=0;
INSERT INTO context VALUES (NULL, 2, 1, '2004-11-30 12:00:00', 256, 0, 3, 0, 0, 0);
SELECT LAST_INSERT_ID();
INSERT INTO data (id_context, id_var, value) VALUES(27, 5132, '60');
INSERT INTO attr (id_context, id_var, type, value) VALUES(27, 5132, 8455, '85');
SELECT id FROM context WHERE id_ana=2 AND id_report=1 AND datetime='2004-11-30 12:00:00' AND ltype=256 AND l1=1 AND l2=0 AND ptype=0 AND p1=0 AND p2=0;
INSERT INTO context VALUES (NULL, 2, 1, '2004-11-30 12:00:00', 256, 1, 0, 0, 0, 0);
SELECT LAST_INSERT_ID();
INSERT INTO data (id_context, id_var, value) VALUES(28, 5131, '5');
INSERT INTO attr (id_context, id_var, type, value) VALUES(28, 5131, 8455, '70');
INSERT INTO data (id_context, id_var, value) VALUES(28, 5132, '7');
INSERT INTO attr (id_context, id_var, type, value) VALUES(28, 5132, 8455, '70');
INSERT INTO data (id_context, id_var, value) VALUES(28, 5133, '530');
INSERT INTO attr (id_context, id_var, type, value) VALUES(28, 5133, 8455, '70');
SELECT id FROM context WHERE id_ana=2 AND id_report=1 AND datetime='2004-11-30 12:00:00' AND ltype=256 AND l1=2 AND l2=0 AND ptype=0 AND p1=0 AND p2=0;
INSERT INTO context VALUES (NULL, 2, 1, '2004-11-30 12:00:00', 256, 2, 0, 0, 0, 0);
SELECT LAST_INSERT_ID();
INSERT INTO data (id_context, id_var, value) VALUES(29, 5131, '8');
INSERT INTO attr (id_context, id_var, type, value) VALUES(29, 5131, 8455, '70');
INSERT INTO data (id_context, id_var, value) VALUES(29, 5132, '5');
INSERT INTO attr (id_context, id_var, type, value) VALUES(29, 5132, 8455, '70');
INSERT INTO data (id_context, id_var, value) VALUES(29, 5133, '3150');
INSERT INTO attr (id_context, id_var, type, value) VALUES(29, 5133, 8455, '70');
COMMIT;
SELECT id, memo, description, prio, descriptor, tablea FROM repinfo ORDER BY id;
SELECT pa.lat, pa.lon, pa.ident, c.ltype, c.l1, c.l2, c.ptype, c.p1, c.p2, c.datetime, c.id_report, d.id_var, d.value, pa.id, c.id FROM context AS c JOIN pseudoana AS pa ON c.id_ana = pa.id JOIN data AS d ON d.id_context=c.id WHERE c.id_report=1 AND c.datetime>='1001-01-01 00:00:00' ORDER BY c.id_ana, c.datetime, c.ltype, c.l1, c.l2, c.ptype, c.p1, c.p2;