This repository has been archived by the owner on Sep 4, 2022. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 2
/
lists.sql
99 lines (80 loc) · 6.83 KB
/
lists.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
INSERT INTO medialist(medialistid, userid, listname, description, creationdate, visibility, collaborative) VALUES (2, 10, 'Kids Movies', 'Movies for the whole family. Enjoy with the kids.',
current_date, true, false);
INSERT INTO listelement(mediaid, medialistid) VALUES (29,2);
INSERT INTO listelement(mediaid, medialistid) VALUES (30,2);
INSERT INTO listelement(mediaid, medialistid) VALUES (31,2);
INSERT INTO listelement(mediaid, medialistid) VALUES (33,2);
INSERT INTO listelement(mediaid, medialistid) VALUES (37,2);
INSERT INTO listelement(mediaid, medialistid) VALUES (38,2);
INSERT INTO listelement(mediaid, medialistid) VALUES (39,2);
INSERT INTO medialist(medialistid, userid, listname, description, creationdate, visibility, collaborative) VALUES (3, 10, 'Movies to Enjoy Alone', 'Everyone needs some space, these films were ' ||
'chosen' ||
' so you can recharge your batteries. Sit back and relax. ' , current_date, true, false);
INSERT INTO listelement(mediaid, medialistid) VALUES (26,3);
INSERT INTO listelement(mediaid, medialistid) VALUES (25,3);
INSERT INTO listelement(mediaid, medialistid) VALUES (28,3);
INSERT INTO listelement(mediaid, medialistid) VALUES (32,3);
INSERT INTO listelement(mediaid, medialistid) VALUES (40,3);
INSERT INTO listelement(mediaid, medialistid) VALUES (23,3);
INSERT INTO medialist(medialistid, userid, listname, description, creationdate, visibility, collaborative) VALUES (4, 10, 'Populars', 'Enjoys this popular films. ', current_date, true, false);
INSERT INTO listelement(mediaid, medialistid) VALUES (22,4);
INSERT INTO listelement(mediaid, medialistid) VALUES (34,4);
INSERT INTO listelement(mediaid, medialistid) VALUES (35,4);
INSERT INTO listelement(mediaid, medialistid) VALUES (18,4);
INSERT INTO listelement(mediaid, medialistid) VALUES (6,4);
INSERT INTO medialist(medialistid, userid, listname, description, creationdate, visibility, collaborative) VALUES (5, 10, 'Greatest Dramas', 'Enjoy these dramas. Let''s go!', current_date, true,
false);
INSERT INTO listelement(mediaid, medialistid) VALUES (1,5);
INSERT INTO listelement(mediaid, medialistid) VALUES (2,5);
INSERT INTO listelement(mediaid, medialistid) VALUES (8,5);
INSERT INTO listelement(mediaid, medialistid) VALUES (9,5);
INSERT INTO listelement(mediaid, medialistid) VALUES (10,5);
INSERT INTO listelement(mediaid, medialistid) VALUES (14,5);
INSERT INTO medialist(medialistid, userid, listname, description, creationdate, visibility, collaborative) VALUES (6, 10, 'Our Favorite Sitcoms', 'LOL', current_date, true, false);
INSERT INTO listelement(mediaid, medialistid) VALUES (11,6);
INSERT INTO listelement(mediaid, medialistid) VALUES (13,6);
INSERT INTO listelement(mediaid, medialistid) VALUES (14,6);
INSERT INTO listelement(mediaid, medialistid) VALUES (15,6);
INSERT INTO listelement(mediaid, medialistid) VALUES (17,6);
INSERT INTO listelement(mediaid, medialistid) VALUES (30,6);
INSERT INTO medialist(medialistid, userid, listname, description, creationdate, visibility, collaborative) VALUES (7, 10, 'Shrek is Love', 'Look At Him In His Wee Li’l Boots! Y’know, How Many Cats ' ||
'' ||
'' ||
'Can Wear Boots? Honestly?', current_date, true, false);
INSERT INTO listelement(mediaid, medialistid) VALUES (29,7);
INSERT INTO listelement(mediaid, medialistid) VALUES (30,7);
INSERT INTO listelement(mediaid, medialistid) VALUES (31,7);
INSERT INTO listelement(mediaid, medialistid) VALUES (33,7);
INSERT INTO medialist(medialistid, userid, listname, description, creationdate, visibility, collaborative) VALUES (8, 10, 'Halloween', 'Spooky October.', current_date, true, false);
INSERT INTO listelement(mediaid, medialistid) VALUES (32,8);
INSERT INTO listelement(mediaid, medialistid) VALUES (35,8);
INSERT INTO listelement(mediaid, medialistid) VALUES (27,8);
INSERT INTO listelement(mediaid, medialistid) VALUES (28,8);
INSERT INTO listelement(mediaid, medialistid) VALUES (6,8);
INSERT INTO medialist(medialistid, userid, listname, description, creationdate, visibility, collaborative) VALUES (9, 10, 'Trilogies', 'Up for a trilogy marathon? We got you covered.', current_date,
true, false);
INSERT INTO listelement(mediaid, medialistid) VALUES (37,9);
INSERT INTO listelement(mediaid, medialistid) VALUES (38,9);
INSERT INTO listelement(mediaid, medialistid) VALUES (39,9);
INSERT INTO listelement(mediaid, medialistid) VALUES (29,9);
INSERT INTO listelement(mediaid, medialistid) VALUES (30,9);
INSERT INTO listelement(mediaid, medialistid) VALUES (31,9);
INSERT INTO medialist(medialistid, userid, listname, description, creationdate, visibility, collaborative) VALUES (10, 10, 'Based', 'SNM.', current_date, true, false);
INSERT INTO listelement(mediaid, medialistid) VALUES (18,10);
INSERT INTO listelement(mediaid, medialistid) VALUES (16,10);
INSERT INTO listelement(mediaid, medialistid) VALUES (10,10);
INSERT INTO listelement(mediaid, medialistid) VALUES (36,10);
INSERT INTO listelement(mediaid, medialistid) VALUES (23,10);
INSERT INTO listelement(mediaid, medialistid) VALUES (22,10);
INSERT INTO listelement(mediaid, medialistid) VALUES (26,10);
INSERT INTO listelement(mediaid, medialistid) VALUES (35,10);
INSERT INTO listelement(mediaid, medialistid) VALUES (30,10);
INSERT INTO medialist(medialistid, userid, listname, description, creationdate, visibility, collaborative) VALUES (11, 10, 'The Time Machine', 'Let''s go back in time!', current_date, true, false);
INSERT INTO listelement(mediaid, medialistid) VALUES (21,11);
INSERT INTO listelement(mediaid, medialistid) VALUES (25,11);
INSERT INTO listelement(mediaid, medialistid) VALUES (24,11);
INSERT INTO listelement(mediaid, medialistid) VALUES (23,11);
INSERT INTO listelement(mediaid, medialistid) VALUES (26,11);
INSERT INTO listelement(mediaid, medialistid) VALUES (32,11);
INSERT INTO listelement(mediaid, medialistid) VALUES (34,11);
INSERT INTO listelement(mediaid, medialistid) VALUES (35,11);