CREATE TABLE sets (
  idSet       integer PRIMARY KEY AUTOINCREMENT,
  NfoPath     text,
  TMDBColID   text,
  Plot        text,
  Title       text,
  "New"       bool NOT NULL DEFAULT 0,
  Mark        bool NOT NULL DEFAULT 0,
  Lock        bool NOT NULL DEFAULT 0,
  SortMethod  integer NOT NULL DEFAULT 0,
  Language    text
);

CREATE TRIGGER delete_set
  AFTER DELETE
  ON sets
BEGIN
        DELETE FROM art WHERE media_id=old.idSet AND media_type='set';
        DELETE FROM uniqueid WHERE media_id=old.idSet AND media_type='set';
        END;