CREATE TABLE seasons (
  idSeason  integer PRIMARY KEY,
  idShow    integer,
  Season    integer,
  Title     text,
  Lock      bool NOT NULL DEFAULT 0,
  Mark      bool NOT NULL DEFAULT 0,
  "New"     bool NOT NULL DEFAULT 0,
  strTVDB   text,
  strTMDB   text,
  strAired  text,
  strPlot   text
);

CREATE UNIQUE INDEX ix_seasons
  ON seasons
  (idShow, Season);

CREATE TRIGGER delete_season
  AFTER DELETE
  ON seasons
BEGIN
        DELETE FROM art WHERE media_id=old.idSeason AND media_type='season';
        DELETE FROM episode WHERE Season=old.Season AND idShow=old.idShow;
        DELETE FROM uniqueid WHERE media_id=old.idSeason AND media_type='season';
        END;