CREATE TABLE tvshowsource (
  idSource         integer PRIMARY KEY AUTOINCREMENT,
  strName          text NOT NULL,
  strPath          text NOT NULL,
  strLastScan      text NOT NULL DEFAULT '1900/01/01',
  strLanguage      text NOT NULL DEFAULT 'en-US',
  iOrdering        integer NOT NULL DEFAULT 0,
  bExclude         bool NOT NULL DEFAULT 0,
  iEpisodeSorting  integer NOT NULL DEFAULT 0,
  bSingle          bool NOT NULL DEFAULT 0
);

CREATE UNIQUE INDEX UniqueTVShowSourcePath
  ON tvshowsource
  (strPath);

CREATE TRIGGER delete_tvshowsource
  AFTER DELETE
  ON tvshowsource
BEGIN
		DELETE FROM tvshow WHERE idSource=old.idSource;
END;