| 1 | ALTER TABLE Watchable ADD CONSTRAINT check_watchable_type
|
|---|
| 2 | CHECK ((MovieID IS NOT NULL AND EpisodeID IS NULL) OR (MovieID IS NULL AND EpisodeID IS NOT NULL));
|
|---|
| 3 |
|
|---|
| 4 |
|
|---|
| 5 | INSERT 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')
|
|---|
| 13 | ON CONFLICT (Name) DO NOTHING;
|
|---|
| 14 |
|
|---|
| 15 | INSERT 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')
|
|---|
| 34 | ON CONFLICT (Name) DO NOTHING;
|
|---|
| 35 |
|
|---|
| 36 | INSERT 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)'); |
|---|
