lab.sql

CREATE TABLE pattern (
  pId INTEGER PRIMARY KEY AUTOINCREMENT,
  rle TEXT UNIQUE,
  sizeX INTEGER,
  sizeY INTEGER,
  start TEXT,
  sx INTEGER,
  sy INTEGER,
  nrResults INTEGER
);
CREATE TABLE result (
  pId INTEGER,
  resNr INTEGER,
  object TEXT,
  dt INTEGER,
  dx INTEGER,
  dy INTEGER,
  PRIMARY KEY (pId, resNr)
);