CREATE TABLE moviesource (
  idSource     integer PRIMARY KEY AUTOINCREMENT,
  strName      text NOT NULL,
  strPath      text NOT NULL,
  bRecursive   bool NOT NULL DEFAULT 0,
  bFoldername  bool NOT NULL DEFAULT 0,
  bSingle      bool NOT NULL DEFAULT 0,
  strLastScan  text NOT NULL DEFAULT '1900/01/01',
  bExclude     bool NOT NULL DEFAULT 0,
  bGetYear     bool NOT NULL DEFAULT 1,
  strLanguage  text NOT NULL DEFAULT 'en-US'
);

CREATE UNIQUE INDEX UniqueMovieSourcePath
  ON moviesource
  (strPath);

CREATE TRIGGER delete_moviesource
  AFTER DELETE
  ON moviesource
BEGIN
		DELETE FROM movie WHERE idSource=old.idSource;
END;