-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy path3. adding_entries.sql
More file actions
118 lines (110 loc) · 14 KB
/
Copy path3. adding_entries.sql
File metadata and controls
118 lines (110 loc) · 14 KB
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
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
INSERT INTO `server_database`.`users` (`User_ID`, `First Name`, `Last Name`, `Email`, `Password`, `Language`) VALUES ('1', 'Mudit', 'Garg', 'gargmu@tcd.ie', 'FunnyNinja23', 'English');
INSERT INTO `server_database`.`users` (`User_ID`, `First Name`, `Last Name`, `Email`, `Password`, `Language`) VALUES ('2', 'Rahul', 'Garg', 'gargr@tcd.ie', '3flex@', 'Hindi');
INSERT INTO `server_database`.`users` (`User_ID`, `First Name`, `Last Name`, `Email`, `Password`, `Language`) VALUES ('3', 'Yashraj', 'Saluja', 'yashraj@gmail.com', 'maakaladla134', 'Punjabi');
INSERT INTO `server_database`.`users` (`User_ID`, `First Name`, `Last Name`, `Email`, `Password`, `Language`) VALUES ('4', 'Angad', 'Singh Garcha', 'garchaa@outlook.com', 'ikyktk69', 'French');
INSERT INTO `server_database`.`users` (`User_ID`, `First Name`, `Last Name`, `Email`, `Password`, `Language`) VALUES ('5', 'Ritwik', 'Kumar', 'kumarritwik@aol.com', 'coolDude13', 'Tamil');
INSERT INTO `server_database`.`users` (`User_ID`, `First Name`, `Last Name`, `Email`, `Password`, `Language`) VALUES ('6', 'Ananya', 'Garg', 'papaKipari@yahoo.com', 'cakemurder01', 'Hindi');
INSERT INTO `server_database`.`users` (`User_ID`, `First Name`, `Last Name`, `Email`, `Password`, `Language`) VALUES ('7', 'Mathew', 'McHart', 'mathewmc@aol.com', 'asdfmovie%', 'English');
INSERT INTO `server_database`.`games` (`Game_ID`, `Name`, `Price`, `Release Date`) VALUES ('1', 'Uncharted', '23.99', '2015-10-21')
INSERT INTO `server_database`.`games` (`Game_ID`, `Name`, `Price`, `Release Date`) VALUES ('2', 'The Spiderman', '14.99', '2021-11-17')
INSERT INTO `server_database`.`games` (`Game_ID`, `Name`, `Price`, `Release Date`) VALUES ('3', 'GTA V', '8.99', '2013-09-10')
INSERT INTO `server_database`.`games` (`Game_ID`, `Name`, `Price`, `Release Date`) VALUES ('4', 'Red Dead Redemption', '18.99', '2018-06-16')
INSERT INTO `server_database`.`games` (`Game_ID`, `Name`, `Price`, `Release Date`) VALUES ('5', 'FIFA 19', '20.99', '2019-04-12')
INSERT INTO `server_database`.`games` (`Game_ID`, `Name`, `Price`, `Release Date`) VALUES ('6', 'Cyberpunk 2077', '15.99', '2020-11-30')
INSERT INTO `server_database`.`games` (`Game_ID`, `Name`, `Price`, `Release Date`) VALUES ('7', 'Spiderman: Miles Morales', '28.99', '2022-11-17')
INSERT INTO `server_database`.`games` (`Game_ID`, `Name`, `Price`, `Release Date`) VALUES ('8', 'Witcher 3', '32.99', '2018-03-25')
INSERT INTO `server_database`.`user_libraries` (`Library Item ID`, `library_id`, `game_ids`) VALUES ('1', '1', '2')
INSERT INTO `server_database`.`user_libraries` (`Library Item ID`, `library_id`, `game_ids`) VALUES ('2', '1', '3')
INSERT INTO `server_database`.`user_libraries` (`Library Item ID`, `library_id`, `game_ids`) VALUES ('3', '1', '1')
INSERT INTO `server_database`.`user_libraries` (`Library Item ID`, `library_id`, `game_ids`) VALUES ('4', '4', '3')
INSERT INTO `server_database`.`user_libraries` (`Library Item ID`, `library_id`, `game_ids`) VALUES ('5', '2', '9')
INSERT INTO `server_database`.`user_libraries` (`Library Item ID`, `library_id`, `game_ids`) VALUES ('6', '7', '5')
INSERT INTO `server_database`.`user_libraries` (`Library Item ID`, `library_id`, `game_ids`) VALUES ('7', '7', '3')
INSERT INTO `server_database`.`user_libraries` (`Library Item ID`, `library_id`, `game_ids`) VALUES ('8', '7', '1')
INSERT INTO `server_database`.`user_libraries` (`Library Item ID`, `library_id`, `game_ids`) VALUES ('9', '7', '2')
INSERT INTO `server_database`.`user_libraries` (`Library Item ID`, `library_id`, `game_ids`) VALUES ('10', '7', '4')
INSERT INTO `server_database`.`user_wishlists` (`Wishlist Item ID`, `wishlist_id`, `game_ids`) VALUES ('1', '1', '7')
INSERT INTO `server_database`.`user_wishlists` (`Wishlist Item ID`, `wishlist_id`, `game_ids`) VALUES ('2', '1', '6')
INSERT INTO `server_database`.`user_wishlists` (`Wishlist Item ID`, `wishlist_id`, `game_ids`) VALUES ('3', '2', '3')
INSERT INTO `server_database`.`user_wishlists` (`Wishlist Item ID`, `wishlist_id`, `game_ids`) VALUES ('4', '2', '8')
INSERT INTO `server_database`.`user_wishlists` (`Wishlist Item ID`, `wishlist_id`, `game_ids`) VALUES ('5', '6', '3')
INSERT INTO `server_database`.`user_wishlists` (`Wishlist Item ID`, `wishlist_id`, `game_ids`) VALUES ('6', '5', '5')
INSERT INTO `server_database`.`user_wishlists` (`Wishlist Item ID`, `wishlist_id`, `game_ids`) VALUES ('7', '4', '5')
INSERT INTO `server_database`.`user_wishlists` (`Wishlist Item ID`, `wishlist_id`, `game_ids`) VALUES ('8', '4', '8')
INSERT INTO `server_database`.`user_wishlists` (`Wishlist Item ID`, `wishlist_id`, `game_ids`) VALUES ('9', '3', '5')
INSERT INTO `server_database`.`user_wishlists` (`Wishlist Item ID`, `wishlist_id`, `game_ids`) VALUES ('10', '3', '2')
INSERT INTO `server_database`.`user_carts` (`Cart Item ID`, `cart_id`, `game_ids`) VALUES ('1', '1', '7')
INSERT INTO `server_database`.`user_carts` (`Cart Item ID`, `cart_id`, `game_ids`) VALUES ('2', '1', '6')
INSERT INTO `server_database`.`user_carts` (`Cart Item ID`, `cart_id`, `game_ids`) VALUES ('3', '7', '6')
INSERT INTO `server_database`.`user_carts` (`Cart Item ID`, `cart_id`, `game_ids`) VALUES ('4', '7', '7')
INSERT INTO `server_database`.`user_carts` (`Cart Item ID`, `cart_id`, `game_ids`) VALUES ('5', '3', '1')
INSERT INTO `server_database`.`user_carts` (`Cart Item ID`, `cart_id`, `game_ids`) VALUES ('6', '3', '2')
INSERT INTO `server_database`.`user_carts` (`Cart Item ID`, `cart_id`, `game_ids`) VALUES ('7', '3', '3')
INSERT INTO `server_database`.`user_carts` (`Cart Item ID`, `cart_id`, `game_ids`) VALUES ('8', '3', '5')
INSERT INTO `server_database`.`user_carts` (`Cart Item ID`, `cart_id`, `game_ids`) VALUES ('9', '3', '9')
INSERT INTO `server_database`.`user_carts` (`Cart Item ID`, `cart_id`, `game_ids`) VALUES ('10', '5', '9')
INSERT INTO `server_database`.`platforms` (`Platform Item ID`, `Game_ID`, `Platform_ID`, `Platform Name`) VALUES ('1', '1', '1', 'PC')
INSERT INTO `server_database`.`platforms` (`Platform Item ID`, `Game_ID`, `Platform_ID`, `Platform Name`) VALUES ('2', '1', '2', 'Xbox')
INSERT INTO `server_database`.`platforms` (`Platform Item ID`, `Game_ID`, `Platform_ID`, `Platform Name`) VALUES ('3', '1', '3', 'Playstation')
INSERT INTO `server_database`.`platforms` (`Platform Item ID`, `Game_ID`, `Platform_ID`, `Platform Name`) VALUES ('4', '2', '1', 'PC')
INSERT INTO `server_database`.`platforms` (`Platform Item ID`, `Game_ID`, `Platform_ID`, `Platform Name`) VALUES ('5', '2', '2', 'Xbox')
INSERT INTO `server_database`.`platforms` (`Platform Item ID`, `Game_ID`, `Platform_ID`, `Platform Name`) VALUES ('6', '2', '3', 'Playstation')
INSERT INTO `server_database`.`platforms` (`Platform Item ID`, `Game_ID`, `Platform_ID`, `Platform Name`) VALUES ('7', '3', '1', 'PC')
INSERT INTO `server_database`.`platforms` (`Platform Item ID`, `Game_ID`, `Platform_ID`, `Platform Name`) VALUES ('8', '4', '2', 'Xbox')
INSERT INTO `server_database`.`platforms` (`Platform Item ID`, `Game_ID`, `Platform_ID`, `Platform Name`) VALUES ('9', '4', '3', 'Playstation')
INSERT INTO `server_database`.`platforms` (`Platform Item ID`, `Game_ID`, `Platform_ID`, `Platform Name`) VALUES ('10', '5', '1', 'PC')
INSERT INTO `server_database`.`platforms` (`Platform Item ID`, `Game_ID`, `Platform_ID`, `Platform Name`) VALUES ('11', '6', '1', 'PC')
INSERT INTO `server_database`.`platforms` (`Platform Item ID`, `Game_ID`, `Platform_ID`, `Platform Name`) VALUES ('12', '7', '1', 'PC')
INSERT INTO `server_database`.`platforms` (`Platform Item ID`, `Game_ID`, `Platform_ID`, `Platform Name`) VALUES ('13', '7', '3', 'Playstation')
INSERT INTO `server_database`.`platforms` (`Platform Item ID`, `Game_ID`, `Platform_ID`, `Platform Name`) VALUES ('14', '8', '1', 'PC')
INSERT INTO `server_database`.`platforms` (`Platform Item ID`, `Game_ID`, `Platform_ID`, `Platform Name`) VALUES ('15', '8', '2', 'Xbox')
INSERT INTO `server_database`.`platforms` (`Platform Item ID`, `Game_ID`, `Platform_ID`, `Platform Name`) VALUES ('16', '8', '3', 'Playstation')
INSERT INTO `server_database`.`platforms` (`Platform Item ID`, `Game_ID`, `Platform_ID`, `Platform Name`) VALUES ('17', '9', '1', 'PC')
INSERT INTO `server_database`.`platforms` (`Platform Item ID`, `Game_ID`, `Platform_ID`, `Platform Name`) VALUES ('18', '9', '2', 'Xbox')
INSERT INTO `server_database`.`platforms` (`Platform Item ID`, `Game_ID`, `Platform_ID`, `Platform Name`) VALUES ('19', '9', '3', 'Playstation')
INSERT INTO `server_database`.`platforms` (`Platform Item ID`, `Game_ID`, `Platform_ID`, `Platform Name`) VALUES ('20', '9', '4', 'Android')
INSERT INTO `server_database`.`publishers` (`Publisher Item ID`, `Publisher_ID`, `Publisher Name`, `Game_ID`) VALUES ('1', '1', 'Sony Interactive Entertainment', '1')
INSERT INTO `server_database`.`publishers` (`Publisher Item ID`, `Publisher_ID`, `Publisher Name`, `Game_ID`) VALUES ('2', '1', 'Sony Interactive Entertainment', '2')
INSERT INTO `server_database`.`publishers` (`Publisher Item ID`, `Publisher_ID`, `Publisher Name`, `Game_ID`) VALUES ('3', '1', 'Sony Interactive Entertainment', '7')
INSERT INTO `server_database`.`publishers` (`Publisher Item ID`, `Publisher_ID`, `Publisher Name`, `Game_ID`) VALUES ('4', '2', 'Rockstar Games', '3')
INSERT INTO `server_database`.`publishers` (`Publisher Item ID`, `Publisher_ID`, `Publisher Name`, `Game_ID`) VALUES ('5', '2', 'Rockstar Games', '9')
INSERT INTO `server_database`.`publishers` (`Publisher Item ID`, `Publisher_ID`, `Publisher Name`, `Game_ID`) VALUES ('6', '2', 'Rockstar Games', '4')
INSERT INTO `server_database`.`publishers` (`Publisher Item ID`, `Publisher_ID`, `Publisher Name`, `Game_ID`) VALUES ('7', '3', 'Electronic Arts', '5')
INSERT INTO `server_database`.`publishers` (`Publisher Item ID`, `Publisher_ID`, `Publisher Name`, `Game_ID`) VALUES ('8', '4', 'CD Projekt Red', '6')
INSERT INTO `server_database`.`publishers` (`Publisher Item ID`, `Publisher_ID`, `Publisher Name`, `Game_ID`) VALUES ('9', '4', 'CD Projekt Red', '8')
INSERT INTO `server_database`.`genres` (`Genre Item ID`, `Genre_ID`, `Genre Name`, `Game_ID`) VALUES ('1', '1', 'Action', '1')
INSERT INTO `server_database`.`genres` (`Genre Item ID`, `Genre_ID`, `Genre Name`, `Game_ID`) VALUES ('2', '2', 'Adventure', '1')
INSERT INTO `server_database`.`genres` (`Genre Item ID`, `Genre_ID`, `Genre Name`, `Game_ID`) VALUES ('3', '1', 'Action', '2')
INSERT INTO `server_database`.`genres` (`Genre Item ID`, `Genre_ID`, `Genre Name`, `Game_ID`) VALUES ('4', '2', 'Adventure', '2')
INSERT INTO `server_database`.`genres` (`Genre Item ID`, `Genre_ID`, `Genre Name`, `Game_ID`) VALUES ('5', '1', 'Action', '3')
INSERT INTO `server_database`.`genres` (`Genre Item ID`, `Genre_ID`, `Genre Name`, `Game_ID`) VALUES ('6', '2', 'Adventure', '3')
INSERT INTO `server_database`.`genres` (`Genre Item ID`, `Genre_ID`, `Genre Name`, `Game_ID`) VALUES ('7', '1', 'Action', '4')
INSERT INTO `server_database`.`genres` (`Genre Item ID`, `Genre_ID`, `Genre Name`, `Game_ID`) VALUES ('8', '2', 'Adventure', '4')
INSERT INTO `server_database`.`genres` (`Genre Item ID`, `Genre_ID`, `Genre Name`, `Game_ID`) VALUES ('9', '3', 'Unique', '4')
INSERT INTO `server_database`.`genres` (`Genre Item ID`, `Genre_ID`, `Genre Name`, `Game_ID`) VALUES ('10', '4', 'Sports', '5')
INSERT INTO `server_database`.`genres` (`Genre Item ID`, `Genre_ID`, `Genre Name`, `Game_ID`) VALUES ('11', '5', 'RPG', '6')
INSERT INTO `server_database`.`genres` (`Genre Item ID`, `Genre_ID`, `Genre Name`, `Game_ID`) VALUES ('12', '1', 'Action', '7')
INSERT INTO `server_database`.`genres` (`Genre Item ID`, `Genre_ID`, `Genre Name`, `Game_ID`) VALUES ('13', '2', 'Adventure', '7')
INSERT INTO `server_database`.`genres` (`Genre Item ID`, `Genre_ID`, `Genre Name`, `Game_ID`) VALUES ('14', '3', 'Unique', '8')
INSERT INTO `server_database`.`genres` (`Genre Item ID`, `Genre_ID`, `Genre Name`, `Game_ID`) VALUES ('15', '5', 'RPG', '8')
INSERT INTO `server_database`.`genres` (`Genre Item ID`, `Genre_ID`, `Genre Name`, `Game_ID`) VALUES ('16', '1', 'Action', '9')
INSERT INTO `server_database`.`genres` (`Genre Item ID`, `Genre_ID`, `Genre Name`, `Game_ID`) VALUES ('17', '2', 'Adventure', '9')
INSERT INTO `server_database`.`genres` (`Genre Item ID`, `Genre_ID`, `Genre Name`, `Game_ID`) VALUES ('18', '5', 'RPG', '9')
INSERT INTO `server_database`.`friend_list` (`Relationship ID`, `user_id`, `friend_id`) VALUES ('1', '1', '2')
INSERT INTO `server_database`.`friend_list` (`Relationship ID`, `user_id`, `friend_id`) VALUES ('2', '1', '3')
INSERT INTO `server_database`.`friend_list` (`Relationship ID`, `user_id`, `friend_id`) VALUES ('3', '1', '4')
INSERT INTO `server_database`.`friend_list` (`Relationship ID`, `user_id`, `friend_id`) VALUES ('4', '1', '5')
INSERT INTO `server_database`.`friend_list` (`Relationship ID`, `user_id`, `friend_id`) VALUES ('5', '2', '1')
INSERT INTO `server_database`.`friend_list` (`Relationship ID`, `user_id`, `friend_id`) VALUES ('6', '2', '3')
INSERT INTO `server_database`.`friend_list` (`Relationship ID`, `user_id`, `friend_id`) VALUES ('7', '2', '4')
INSERT INTO `server_database`.`friend_list` (`Relationship ID`, `user_id`, `friend_id`) VALUES ('8', '3', '1')
INSERT INTO `server_database`.`friend_list` (`Relationship ID`, `user_id`, `friend_id`) VALUES ('9', '3', '2')
INSERT INTO `server_database`.`friend_list` (`Relationship ID`, `user_id`, `friend_id`) VALUES ('10', '4', '1')
INSERT INTO `server_database`.`friend_list` (`Relationship ID`, `user_id`, `friend_id`) VALUES ('11', '4', '2')
INSERT INTO `server_database`.`friend_list` (`Relationship ID`, `user_id`, `friend_id`) VALUES ('12', '5', '1')
INSERT INTO `server_database`.`friend_list` (`Relationship ID`, `user_id`, `friend_id`) VALUES ('13', '5', '6')
INSERT INTO `server_database`.`friend_list` (`Relationship ID`, `user_id`, `friend_id`) VALUES ('14', '6', '5')
INSERT INTO `server_database`.`friend_list` (`Relationship ID`, `user_id`, `friend_id`) VALUES ('15', '4', '6')
INSERT INTO `server_database`.`friend_list` (`Relationship ID`, `user_id`, `friend_id`) VALUES ('16', '6', '4')
INSERT INTO `server_database`.`friend_list` (`Relationship ID`, `user_id`, `friend_id`) VALUES ('17', '6', '7')
INSERT INTO `server_database`.`friend_list` (`Relationship ID`, `user_id`, `friend_id`) VALUES ('18', '7', '6')