DROP TABLE IF EXISTS context;
DROP TABLE IF EXISTS pseudoana;

CREATE TABLE pseudoana (   
  id         INTEGER auto_increment PRIMARY KEY,   
  lat        INTEGER NOT NULL,   
  lon        INTEGER NOT NULL,   
  ident      CHAR(64)
) 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)
) TYPE = InnoDB;

INSERT INTO context VALUES (NULL, 1, 254, '1000-01-01 00:00:00', 257, 0, 0, 0, 0, 0);
INSERT INTO context VALUES (NULL, 1, 1, '2004-11-30 12:00:00', 1, 0, 0, 0, 0, 0);
INSERT INTO context VALUES (NULL, 1, 1, '2004-11-30 12:00:00', 1, 0, 0, 2, -21600, 0);
INSERT INTO context VALUES (NULL, 1, 1, '2004-11-30 12:00:00', 1, 0, 0, 2, -10800, 0);
INSERT INTO context VALUES (NULL, 1, 1, '2004-11-30 12:00:00', 1, 0, 0, 5, -10800, 0);
INSERT INTO context VALUES (NULL, 1, 1, '2004-11-30 12:00:00', 102, 0, 0, 0, 0, 0);
INSERT INTO context VALUES (NULL, 1, 1, '2004-11-30 12:00:00', 105, 2, 0, 0, 0, 0);
INSERT INTO context VALUES (NULL, 1, 1, '2004-11-30 12:00:00', 105, 10, 0, 0, 0, 0);
INSERT INTO context VALUES (NULL, 1, 1, '2004-11-30 12:00:00', 256, 0, 0, 0, 0, 0);
INSERT INTO context VALUES (NULL, 1, 1, '2004-11-30 12:00:00', 256, 0, 1, 0, 0, 0);
INSERT INTO context VALUES (NULL, 1, 1, '2004-11-30 12:00:00', 256, 0, 2, 0, 0, 0);
INSERT INTO context VALUES (NULL, 1, 1, '2004-11-30 12:00:00', 256, 0, 3, 0, 0, 0);



INSERT INTO pseudoana (lat, lon, ident) VALUES (3388000, -553000, NULL);
-- This second insert is what displays the bug
INSERT INTO pseudoana (lat, lon, ident) VALUES (3388000, -553000, NULL);