DatabaseCreation: console_2.sql

File console_2.sql, 2.6 KB (added by 231166, 2 days ago)
Line 
1ALTER TABLE Watchable ADD CONSTRAINT check_watchable_type
2CHECK ((MovieID IS NOT NULL AND EpisodeID IS NULL) OR (MovieID IS NULL AND EpisodeID IS NOT NULL));
3
4
5INSERT INTO Genre (Name) VALUES
6('Action'), ('Adventure'), ('Animation'), ('Biography'), ('Comedy'),
7('Crime'), ('Documentary'), ('Drama'), ('Family'), ('Fantasy'),
8('Film-Noir'), ('History'), ('Horror'), ('Music'), ('Musical'),
9('Mystery'), ('Romance'), ('Sci-Fi'), ('Sport'), ('Thriller'),
10('War'), ('Western'), ('Psychological'), ('Supernatural'),
11('Cyberpunk'), ('Post-Apocalyptic'), ('Martial Arts'), ('Slasher'),
12('Mockumentary')
13ON CONFLICT (Name) DO NOTHING;
14
15INSERT INTO Language (Name) VALUES
16('Macedonian'), ('English'), ('Albanian'), ('Spanish'), ('French'), ('German'), ('Italian'),
17('Portuguese'), ('Russian'), ('Japanese'), ('Korean'), ('Chinese (Mandarin)'), ('Chinese (Cantonese)'),
18('Turkish'), ('Serbian'), ('Croatian'), ('Bosnian'), ('Slovenian'), ('Bulgarian'), ('Greek'),
19('Arabic'), ('Hindi'), ('Bengali'), ('Punjabi'), ('Telugu'), ('Marathi'), ('Tamil'), ('Urdu'),
20('Vietnamese'), ('Thai'), ('Indonesian'), ('Malay'), ('Filipino'), ('Persian'), ('Hebrew'),
21('Dutch'), ('Polish'), ('Romanian'), ('Hungarian'), ('Czech'), ('Slovak'), ('Swedish'),
22('Danish'), ('Norwegian'), ('Finnish'), ('Icelandic'), ('Estonian'), ('Latvian'), ('Lithuanian'),
23('Ukrainian'), ('Belarusian'), ('Georgian'), ('Armenian'), ('Azerbaijani'), ('Kazakh'), ('Uzbek'),
24('Pashto'), ('Kurdish'), ('Amharic'), ('Swahili'), ('Yoruba'), ('Zulu'), ('Afrikaans'),
25('Somali'), ('Thai'), ('Mongolian'), ('Tibetan'), ('Burmese'), ('Khmer'), ('Lao'),
26('Malayalam'), ('Kannada'), ('Gujarati'), ('Oriya'), ('Assamese'), ('Maithili'), ('Santhali'),
27('Kashmiri'), ('Nepali'), ('Sindhi'), ('Sanskrit'), ('Catalan'), ('Galician'), ('Basque'),
28('Welsh'), ('Irish'), ('Scottish Gaelic'), ('Breton'), ('Luxembourgish'), ('Maltese'),
29('Esperanto'), ('Latin'), ('Ancient Greek'), ('Quechua'), ('Guarani'), ('Aymara'),
30('Nahuatl'), ('Maya'), ('Inuktitut'), ('Maori'), ('Hawaiian'), ('Fijian'), ('Samoan'),
31('Tongan'), ('Javanese'), ('Sundanese'), ('Balinese'), ('Tatar'), ('Chechen'), ('Bashkir'),
32('Chuvash'), ('Uighur'), ('Karakalpak'), ('Moksha'), ('Mari'), ('Komi'), ('Yiddish'),
33('Lad Ladino'), ('Klingon'), ('Dothraki'), ('Quenya'), ('Sindarin')
34ON CONFLICT (Name) DO NOTHING;
35
36INSERT INTO subscription (name, price, maxdevices, videoquality) VALUES
37('Basic Plan', 4.99, 1, '720p (HD)'),
38('Standard Plan', 8.99, 2, '1080p (Full HD)'),
39('Premium Plan', 13.99, 4, '4K + HDR'),
40('Family Ultra', 19.99, 6, '4K + HDR + Atmos'),
41('Student Deal', 2.99, 1, '1080p (Full HD)'),
42('Mobile Only', 3.50, 1, '480p (SD)');