Mine

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');