CREATE TABLE `Languages` (
	`ID` INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT DEFAULT NULL,
	`Language` VARCHAR(200) NOT NULL,
	PRIMARY KEY (`ID`),
	UNIQUE KEY (`Language`)
) ENGINE=InnoDB;

CREATE TABLE `Types` (
	`ID` INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT DEFAULT NULL,
	`Type` VARCHAR(200) NOT NULL,
	PRIMARY KEY (`ID`),
	UNIQUE KEY (`Type`)
) ENGINE=InnoDB;

CREATE TABLE `Genres` (
	`ID` INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT DEFAULT NULL,
	`Genre` VARCHAR(200) NOT NULL,
	PRIMARY KEY (`ID`),
	UNIQUE KEY (`Genre`)
) ENGINE=InnoDB;

CREATE TABLE `Movies` (
	`ID` INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT DEFAULT NULL,
	`Imdb` VARCHAR(7) NULL,
	`Title` VARCHAR(200) NULL,
-- Vad är en ITitle?
	`ITitle` VARCHAR(200) NULL,
	`Genre` INTEGER(10) UNSIGNED NOT NULL,
	`Language` INTEGER(10) UNSIGNED NOT NULL,
	`Type` INTEGER(10) UNSIGNED NOT NULL,
-- Varför inte `RelaseDate` DATETIME?
	`Year` YEAR(4) NULL,
-- Vad är en poster?
	`Poster` VARCHAR(255),
	`Rating` CHAR(3) NULL,
	`Director` VARCHAR(255) NULL,
-- Borde inte detta ligga i en till tabell?
	`Actor` VARCHAR(255) NULL,
	`Disc` TINYINT UNSIGNED NOT NULL DEFAULT 1,
	`Quality` TINYINT UNSIGNED NOT NULL DEFAULT 0,
-- Varför inte ange det som 800x600 istället för två separata variabler?
	`Resolution` VARCHAR(20) NULL,
	`Notes` TEXT NOT NULL,
	`Release` VARCHAR(255) NULL,
	PRIMARY KEY (`ID`),
	FOREIGN KEY (`Language`) REFERENCES `Languages` (`ID`),
	FOREIGN KEY (`Genre`) REFERENCES `Genres` (`ID`),
	FOREIGN KEY (`Type`) REFERENCES `Types` (`ID`)
) ENGINE=InnoDB;

INSERT INTO `Genres` (`Genre`) VALUES ('Action');
INSERT INTO `Genres` (`Genre`) VALUES ('Adult');
INSERT INTO `Genres` (`Genre`) VALUES ('Adventure');
INSERT INTO `Genres` (`Genre`) VALUES ('Animation');
INSERT INTO `Genres` (`Genre`) VALUES ('Comedy');
INSERT INTO `Genres` (`Genre`) VALUES ('Crime');
INSERT INTO `Genres` (`Genre`) VALUES ('Documentary');
INSERT INTO `Genres` (`Genre`) VALUES ('Drama');
INSERT INTO `Genres` (`Genre`) VALUES ('Erotic');
INSERT INTO `Genres` (`Genre`) VALUES ('Family');
INSERT INTO `Genres` (`Genre`) VALUES ('Fantasy');
INSERT INTO `Genres` (`Genre`) VALUES ('Film-Noir');
INSERT INTO `Genres` (`Genre`) VALUES ('Horror');
INSERT INTO `Genres` (`Genre`) VALUES ('Musical');
INSERT INTO `Genres` (`Genre`) VALUES ('Mystery');
INSERT INTO `Genres` (`Genre`) VALUES ('Romance');
INSERT INTO `Genres` (`Genre`) VALUES ('Sci-Fi');
INSERT INTO `Genres` (`Genre`) VALUES ('Short');
INSERT INTO `Genres` (`Genre`) VALUES ('Thriller');
INSERT INTO `Genres` (`Genre`) VALUES ('War');
INSERT INTO `Genres` (`Genre`) VALUES ('Western');
INSERT INTO `Genres` (`Genre`) VALUES ('Music');

INSERT INTO `Types` (`Type`) VALUES ('ASF');
INSERT INTO `Types` (`Type`) VALUES ('DAT');
INSERT INTO `Types` (`Type`) VALUES ('DivX');
INSERT INTO `Types` (`Type`) VALUES ('DVD');
INSERT INTO `Types` (`Type`) VALUES ('M2V');
INSERT INTO `Types` (`Type`) VALUES ('MOV');
INSERT INTO `Types` (`Type`) VALUES ('MPEG');
INSERT INTO `Types` (`Type`) VALUES ('RAM');
INSERT INTO `Types` (`Type`) VALUES ('SVCD');
INSERT INTO `Types` (`Type`) VALUES ('VCD');
INSERT INTO `Types` (`Type`) VALUES ('WMX');
INSERT INTO `Types` (`Type`) VALUES ('XVCD');

INSERT INTO `Languages` (`Language`) VALUES ('None');
INSERT INTO `Languages` (`Language`) VALUES ('Albanian');
INSERT INTO `Languages` (`Language`) VALUES ('Arabic');
INSERT INTO `Languages` (`Language`) VALUES ('Bengali');
INSERT INTO `Languages` (`Language`) VALUES ('Bulgarian');
INSERT INTO `Languages` (`Language`) VALUES ('Cantonese');
INSERT INTO `Languages` (`Language`) VALUES ('Czech');
INSERT INTO `Languages` (`Language`) VALUES ('Danish');
INSERT INTO `Languages` (`Language`) VALUES ('Dutch');
INSERT INTO `Languages` (`Language`) VALUES ('English');
INSERT INTO `Languages` (`Language`) VALUES ('Filipino');
INSERT INTO `Languages` (`Language`) VALUES ('Finnish');
INSERT INTO `Languages` (`Language`) VALUES ('French');
INSERT INTO `Languages` (`Language`) VALUES ('Georgian');
INSERT INTO `Languages` (`Language`) VALUES ('German');
INSERT INTO `Languages` (`Language`) VALUES ('Greek');
INSERT INTO `Languages` (`Language`) VALUES ('Hebrew');
INSERT INTO `Languages` (`Language`) VALUES ('Hindi');
INSERT INTO `Languages` (`Language`) VALUES ('Hungarian');
INSERT INTO `Languages` (`Language`) VALUES ('Italian');
INSERT INTO `Languages` (`Language`) VALUES ('Japanese');
INSERT INTO `Languages` (`Language`) VALUES ('Korean');
INSERT INTO `Languages` (`Language`) VALUES ('Malayalam');
INSERT INTO `Languages` (`Language`) VALUES ('Mandarin');
INSERT INTO `Languages` (`Language`) VALUES ('Marathi');
INSERT INTO `Languages` (`Language`) VALUES ('Norwegian');
INSERT INTO `Languages` (`Language`) VALUES ('Persian');
INSERT INTO `Languages` (`Language`) VALUES ('Polish');
INSERT INTO `Languages` (`Language`) VALUES ('Portuguese');
INSERT INTO `Languages` (`Language`) VALUES ('Romanian');
INSERT INTO `Languages` (`Language`) VALUES ('Russian');
INSERT INTO `Languages` (`Language`) VALUES ('Serbo- Croatian');
INSERT INTO `Languages` (`Language`) VALUES ('Spanish');
INSERT INTO `Languages` (`Language`) VALUES ('Swedish');
INSERT INTO `Languages` (`Language`) VALUES ('Tagalog');
INSERT INTO `Languages` (`Language`) VALUES ('Tamil');
INSERT INTO `Languages` (`Language`) VALUES ('Telugu');
INSERT INTO `Languages` (`Language`) VALUES ('Turkish');
INSERT INTO `Languages` (`Language`) VALUES ('Afrikaans');
INSERT INTO `Languages` (`Language`) VALUES ('Aidoukrou');
INSERT INTO `Languages` (`Language`) VALUES ('Alsatian');
INSERT INTO `Languages` (`Language`) VALUES ('Amharic');
INSERT INTO `Languages` (`Language`) VALUES ('Aramaic');
INSERT INTO `Languages` (`Language`) VALUES ('Arapaho');
INSERT INTO `Languages` (`Language`) VALUES ('Armenian');
INSERT INTO `Languages` (`Language`) VALUES ('Assamese');
INSERT INTO `Languages` (`Language`) VALUES ('Aymara');
INSERT INTO `Languages` (`Language`) VALUES ('Azeri');
INSERT INTO `Languages` (`Language`) VALUES ('Bable dialect');
INSERT INTO `Languages` (`Language`) VALUES ('Baka');
INSERT INTO `Languages` (`Language`) VALUES ('Bambara');
INSERT INTO `Languages` (`Language`) VALUES ('Bangla');
INSERT INTO `Languages` (`Language`) VALUES ('Basque');
INSERT INTO `Languages` (`Language`) VALUES ('Belarusian');
INSERT INTO `Languages` (`Language`) VALUES ('Berber');
INSERT INTO `Languages` (`Language`) VALUES ('Bhojpuri');
INSERT INTO `Languages` (`Language`) VALUES ('Bodo');
INSERT INTO `Languages` (`Language`) VALUES ('Breton');
INSERT INTO `Languages` (`Language`) VALUES ('Burmese');
INSERT INTO `Languages` (`Language`) VALUES ('Castilian');
INSERT INTO `Languages` (`Language`) VALUES ('Catalan');
INSERT INTO `Languages` (`Language`) VALUES ('Chaozhou');
INSERT INTO `Languages` (`Language`) VALUES ('Chechen');
INSERT INTO `Languages` (`Language`) VALUES ('Cheyenne');
INSERT INTO `Languages` (`Language`) VALUES ('Chhattisgarhi');
INSERT INTO `Languages` (`Language`) VALUES ('Corsican');
INSERT INTO `Languages` (`Language`) VALUES ('Crow');
INSERT INTO `Languages` (`Language`) VALUES ('Dari');
INSERT INTO `Languages` (`Language`) VALUES ('Desia');
INSERT INTO `Languages` (`Language`) VALUES ('Dinka');
INSERT INTO `Languages` (`Language`) VALUES ('Dioula');
INSERT INTO `Languages` (`Language`) VALUES ('Djerma');
INSERT INTO `Languages` (`Language`) VALUES ('Dogri');
INSERT INTO `Languages` (`Language`) VALUES ('Dzongkha');
INSERT INTO `Languages` (`Language`) VALUES ('East- Greenlandic');
INSERT INTO `Languages` (`Language`) VALUES ('Esperanto');
INSERT INTO `Languages` (`Language`) VALUES ('Estonian');
INSERT INTO `Languages` (`Language`) VALUES ('Faliasch');
INSERT INTO `Languages` (`Language`) VALUES ('Faroese');
INSERT INTO `Languages` (`Language`) VALUES ('Farsi');
INSERT INTO `Languages` (`Language`) VALUES ('Fon');
INSERT INTO `Languages` (`Language`) VALUES ('Frisian');
INSERT INTO `Languages` (`Language`) VALUES ('Gaelic');
INSERT INTO `Languages` (`Language`) VALUES ('Galician');
INSERT INTO `Languages` (`Language`) VALUES ('Grebo');
INSERT INTO `Languages` (`Language`) VALUES ('Greenlandic');
INSERT INTO `Languages` (`Language`) VALUES ('Guarani');
INSERT INTO `Languages` (`Language`) VALUES ('Gujarati');
INSERT INTO `Languages` (`Language`) VALUES ('Gumatj');
INSERT INTO `Languages` (`Language`) VALUES ('Haitian');
INSERT INTO `Languages` (`Language`) VALUES ('Haoussa');
INSERT INTO `Languages` (`Language`) VALUES ('Haryanvi');
INSERT INTO `Languages` (`Language`) VALUES ('Hassanya');
INSERT INTO `Languages` (`Language`) VALUES ('Hawaiian');
INSERT INTO `Languages` (`Language`) VALUES ('Hokkien');
INSERT INTO `Languages` (`Language`) VALUES ('Hopi');
INSERT INTO `Languages` (`Language`) VALUES ('Iban');
INSERT INTO `Languages` (`Language`) VALUES ('Ibo');
INSERT INTO `Languages` (`Language`) VALUES ('Icelandic');
INSERT INTO `Languages` (`Language`) VALUES ('Indonesian');
INSERT INTO `Languages` (`Language`) VALUES ('Inuktitut');
INSERT INTO `Languages` (`Language`) VALUES ('Kaado');
INSERT INTO `Languages` (`Language`) VALUES ('Kabuverdianu');
INSERT INTO `Languages` (`Language`) VALUES ('Kandarian');
INSERT INTO `Languages` (`Language`) VALUES ('Kannada');
INSERT INTO `Languages` (`Language`) VALUES ('Karaja');
INSERT INTO `Languages` (`Language`) VALUES ('Karbi');
INSERT INTO `Languages` (`Language`) VALUES ('Kazakh');
INSERT INTO `Languages` (`Language`) VALUES ('Khanty');
INSERT INTO `Languages` (`Language`) VALUES ('Khasi');
INSERT INTO `Languages` (`Language`) VALUES ('Khmer');
INSERT INTO `Languages` (`Language`) VALUES ('Kikongo');
INSERT INTO `Languages` (`Language`) VALUES ('Kinyarwanda');
INSERT INTO `Languages` (`Language`) VALUES ('Klingon');
INSERT INTO `Languages` (`Language`) VALUES ('Kodava');
INSERT INTO `Languages` (`Language`) VALUES ('Konkani');
INSERT INTO `Languages` (`Language`) VALUES ('Korowai');
INSERT INTO `Languages` (`Language`) VALUES ('Kriolu');
INSERT INTO `Languages` (`Language`) VALUES ('Kru');
INSERT INTO `Languages` (`Language`) VALUES ('Kuna');
INSERT INTO `Languages` (`Language`) VALUES ('Kunwinjku');
INSERT INTO `Languages` (`Language`) VALUES ('Kurdish');
INSERT INTO `Languages` (`Language`) VALUES ('Kwakiutl');
INSERT INTO `Languages` (`Language`) VALUES ('Kyrgyz');
INSERT INTO `Languages` (`Language`) VALUES ('Ladakhi');
INSERT INTO `Languages` (`Language`) VALUES ('Ladino');
INSERT INTO `Languages` (`Language`) VALUES ('Lao');
INSERT INTO `Languages` (`Language`) VALUES ('Latin');
INSERT INTO `Languages` (`Language`) VALUES ('Latvian');
INSERT INTO `Languages` (`Language`) VALUES ('Letzebuergesh');
INSERT INTO `Languages` (`Language`) VALUES ('Limbu');
INSERT INTO `Languages` (`Language`) VALUES ('Lingala');
INSERT INTO `Languages` (`Language`) VALUES ('Lithuanian');
INSERT INTO `Languages` (`Language`) VALUES ('Macedonian');
INSERT INTO `Languages` (`Language`) VALUES ('Macro- Jê');
INSERT INTO `Languages` (`Language`) VALUES ('Magahi');
INSERT INTO `Languages` (`Language`) VALUES ('Maithili');
INSERT INTO `Languages` (`Language`) VALUES ('Malagasy');
INSERT INTO `Languages` (`Language`) VALUES ('Malay');
INSERT INTO `Languages` (`Language`) VALUES ('Malinka');
INSERT INTO `Languages` (`Language`) VALUES ('Maltese');
INSERT INTO `Languages` (`Language`) VALUES ('Manchu');
INSERT INTO `Languages` (`Language`) VALUES ('Mandingo');
INSERT INTO `Languages` (`Language`) VALUES ('Manipuri');
INSERT INTO `Languages` (`Language`) VALUES ('Maori');
INSERT INTO `Languages` (`Language`) VALUES ('Marshallese');
INSERT INTO `Languages` (`Language`) VALUES ('Maya');
INSERT INTO `Languages` (`Language`) VALUES ('Mende');
INSERT INTO `Languages` (`Language`) VALUES ('Micmac');
INSERT INTO `Languages` (`Language`) VALUES ('Middle English');
INSERT INTO `Languages` (`Language`) VALUES ('Mizo');
INSERT INTO `Languages` (`Language`) VALUES ('Montagnais');
INSERT INTO `Languages` (`Language`) VALUES ('More');
INSERT INTO `Languages` (`Language`) VALUES ('Morisyen');
INSERT INTO `Languages` (`Language`) VALUES ('Moso');
INSERT INTO `Languages` (`Language`) VALUES ('Nagpuri');
INSERT INTO `Languages` (`Language`) VALUES ('Nahuatl');
INSERT INTO `Languages` (`Language`) VALUES ('Navajo');
INSERT INTO `Languages` (`Language`) VALUES ('Nenets');
INSERT INTO `Languages` (`Language`) VALUES ('Nepali');
INSERT INTO `Languages` (`Language`) VALUES ('Nisgaa');
INSERT INTO `Languages` (`Language`) VALUES ('Nushi');
INSERT INTO `Languages` (`Language`) VALUES ('Nyaneka');
INSERT INTO `Languages` (`Language`) VALUES ('Occitan');
INSERT INTO `Languages` (`Language`) VALUES ('Ojibwa');
INSERT INTO `Languages` (`Language`) VALUES ('Ojihimba');
INSERT INTO `Languages` (`Language`) VALUES ('Oriya');
INSERT INTO `Languages` (`Language`) VALUES ('Papiamento');
INSERT INTO `Languages` (`Language`) VALUES ('Parsee');
INSERT INTO `Languages` (`Language`) VALUES ('Pashtu');
INSERT INTO `Languages` (`Language`) VALUES ('Pawnee');
INSERT INTO `Languages` (`Language`) VALUES ('Peul');
INSERT INTO `Languages` (`Language`) VALUES ('Polynesian');
INSERT INTO `Languages` (`Language`) VALUES ('Provençal');
INSERT INTO `Languages` (`Language`) VALUES ('Pular');
INSERT INTO `Languages` (`Language`) VALUES ('Punjabi');
INSERT INTO `Languages` (`Language`) VALUES ('Quechua');
INSERT INTO `Languages` (`Language`) VALUES ('Rajasthani');
INSERT INTO `Languages` (`Language`) VALUES ('Rhaeto- Romanic');
INSERT INTO `Languages` (`Language`) VALUES ('Romany');
INSERT INTO `Languages` (`Language`) VALUES ('Rotuman');
INSERT INTO `Languages` (`Language`) VALUES ('Ryukyuan');
INSERT INTO `Languages` (`Language`) VALUES ('Saami');
INSERT INTO `Languages` (`Language`) VALUES ('Samoan');
INSERT INTO `Languages` (`Language`) VALUES ('Sanskrit');
INSERT INTO `Languages` (`Language`) VALUES ('Sardinian');
INSERT INTO `Languages` (`Language`) VALUES ('Scanian');
INSERT INTO `Languages` (`Language`) VALUES ('Serere');
INSERT INTO `Languages` (`Language`) VALUES ('Sesotho');
INSERT INTO `Languages` (`Language`) VALUES ('Shanghainese');
INSERT INTO `Languages` (`Language`) VALUES ('Shanxi');
INSERT INTO `Languages` (`Language`) VALUES ('Shona');
INSERT INTO `Languages` (`Language`) VALUES ('Shoshone');
INSERT INTO `Languages` (`Language`) VALUES ('Sicilian');
INSERT INTO `Languages` (`Language`) VALUES ('Sign Language');
INSERT INTO `Languages` (`Language`) VALUES ('Sindhi');
INSERT INTO `Languages` (`Language`) VALUES ('Sinhala');
INSERT INTO `Languages` (`Language`) VALUES ('Sioux');
INSERT INTO `Languages` (`Language`) VALUES ('Slovak');
INSERT INTO `Languages` (`Language`) VALUES ('Slovenian');
INSERT INTO `Languages` (`Language`) VALUES ('Somali');
INSERT INTO `Languages` (`Language`) VALUES ('Soninke');
INSERT INTO `Languages` (`Language`) VALUES ('Sotho');
INSERT INTO `Languages` (`Language`) VALUES ('Sousson');
INSERT INTO `Languages` (`Language`) VALUES ('Swahili');
INSERT INTO `Languages` (`Language`) VALUES ('Swiss');
INSERT INTO `Languages` (`Language`) VALUES ('German');
INSERT INTO `Languages` (`Language`) VALUES ('Tajik');
INSERT INTO `Languages` (`Language`) VALUES ('Tamashek');
INSERT INTO `Languages` (`Language`) VALUES ('Tarahumara');
INSERT INTO `Languages` (`Language`) VALUES ('Tatar');
INSERT INTO `Languages` (`Language`) VALUES ('Teochew');
INSERT INTO `Languages` (`Language`) VALUES ('Thai');
INSERT INTO `Languages` (`Language`) VALUES ('Tibetan');
INSERT INTO `Languages` (`Language`) VALUES ('Tigrigna');
INSERT INTO `Languages` (`Language`) VALUES ('Tlingit');
INSERT INTO `Languages` (`Language`) VALUES ('Tupi');
INSERT INTO `Languages` (`Language`) VALUES ('Turkmen');
INSERT INTO `Languages` (`Language`) VALUES ('Tzotzil');
INSERT INTO `Languages` (`Language`) VALUES ('Ukrainian');
INSERT INTO `Languages` (`Language`) VALUES ('Ungwatsi');
INSERT INTO `Languages` (`Language`) VALUES ('Urdu');
INSERT INTO `Languages` (`Language`) VALUES ('Uzbek');
INSERT INTO `Languages` (`Language`) VALUES ('Valencian');
INSERT INTO `Languages` (`Language`) VALUES ('Vietnamese');
INSERT INTO `Languages` (`Language`) VALUES ('Visayan');
INSERT INTO `Languages` (`Language`) VALUES ('Washoe');
INSERT INTO `Languages` (`Language`) VALUES ('Welsh');
INSERT INTO `Languages` (`Language`) VALUES ('Wolof');
INSERT INTO `Languages` (`Language`) VALUES ('Xhosa');
INSERT INTO `Languages` (`Language`) VALUES ('Xitewa');
INSERT INTO `Languages` (`Language`) VALUES ('Yapese');
INSERT INTO `Languages` (`Language`) VALUES ('Yiddish');