-
Notifications
You must be signed in to change notification settings - Fork 0
/
old_data.sql
165 lines (161 loc) · 6.99 KB
/
old_data.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
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
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
-- Sample data for the venue table
INSERT INTO
venue (name, location, description, rating, capacity)
VALUES
('Madison Square Garden', 'New York, NY', 'Indoor arena for concerts and sports events', 4, 20000),
('Red Rocks Amphitheatre', 'Morrison, CO', 'Outdoor amphitheatre in a natural setting', 5, 9450),
('Wembley Stadium', 'London, UK', 'Iconic stadium for football and music events', 4, 90000),
('Sydney Opera House', 'Sydney, AU', 'Famous performing arts venue with unique architecture', 4, 1500),
('Royal Albert Hall', 'London, UK', 'Historic venue for classical music performances', 4, 5272),
('Glastonbury Festival', 'Glastonbury, UK', 'Music festival featuring various genres and artists', 4, 135000),
('O2 Academy Brixton', 'London, UK', 'Music venue for intimate performances and club nights', 3, 4929),
('The Fillmore', 'San Francisco, CA', 'Historic venue for rock concerts', 4, 1200),
('The Troubadour', 'Los Angeles, CA', 'Famous music venue for up-and-coming artists', 3, 500),
('Staples Center', 'Los Angeles, CA', 'Indoor arena for sports and music events', 4, 21000),
('Bill Graham Civic Auditorium', 'San Francisco, CA', 'Indoor venue for concerts and events', 4, 8500),
('Mercedes-Benz Stadium', 'Atlanta, GA', 'State-of-the-art stadium for sports and music events', 4, 71000),
('Ryman Auditorium', 'Nashville, TN', 'Historic venue for country music performances', 4, 2362),
('The Tabernacle', 'Atlanta, GA', 'Music venue for various genres and intimate performances', 3, 2600),
('Theater of the Stars', 'New York, NY', 'A classic Broadway theater', 4, 1000),
('Theater of Dreams', 'Los Angeles, CA', 'A modern theater with excellent acoustics', 5, 1500),
('Magic Theater', 'Las Vegas', 'A theater that specializes in magic shows', 4, 800),
('Theater by the Lake', 'Chicago', 'A theater with a beautiful lakeside view', 3, 1200),
('Theater in the Round', 'Seattle', 'A theater with a unique circular stage', 4, 900),
('Shakespeare Theater', 'London, UK', 'A theater dedicated to staging Shakespearean plays', 5, 800),
('Grand Opera House', 'Paris', 'A historic opera house', 4, 1500),
('Comedy Club', 'New York, NY', 'A venue that specializes in stand-up comedy', 4, 200),
('The Blue Note', 'New York, NY', 'A jazz club that attracts world-class musicians', 5, 300),
('The Fillmore', 'San Francisco, CA', 'A legendary rock venue that has hosted countless iconic shows', 5, 1000),
('The Sydney Opera House', 'Sydney, AU', 'An iconic venue with a stunning architectural design', 5, 1500),
('The Shrine Auditorium', 'Los Angeles, CA', 'A venue that has hosted many awards shows and televised events', 4, 5000),
('The O2 Arena', 'London, UK', 'A state-of-the-art arena that can seat over 20,000 people', 5, 20000),
('The Staples Center', 'Los Angeles, CA', 'A multipurpose arena that hosts concerts, sports events, and more', 4, 19000);
-- Sample data for the show table
INSERT INTO
show (name, description, category, rating, ticket_price)
VALUES
('Beyonce and Jay-Z: On the Run II', 'Hip-hop and R&B concert tour', 'Music', 5, 150.00),
('Hamilton', 'Award-winning Broadway musical', 'Theatre', 5, 200.00),
('The Lion King', 'Broadway musical based on the Disney animated film', 'Theatre', 4, 150.00),
('The Rolling Stones: No Filter Tour', 'Rock concert tour', 'Music', 4, 100.00),
('Elton John: Farewell Yellow Brick Road Tour', 'Pop and rock concert tour', 'Music', 5, 175.00),
('WWE WrestleMania', 'Professional wrestling event', 'Sports', 4, 75.00),
('The Nutcracker', 'Holiday ballet performance', 'Dance', 4, 100.00),
('Cirque du Soleil: O', 'Acrobatic and aquatic performance', 'Circus', 5, 150.00),
('The Book of Mormon', 'Musical comedy', 'Theatre', 4, 150.00),
('Coachella Valley Music and Arts Festival', 'Music and arts festival', 'Music', 4, 450.00),
('The Killers', 'Rock concert', 'Music', 4, 75.00),
('Comedy Night with Dave Chappelle', 'Stand-up comedy show', 'Comedy', 5, 100.00),
('NBA Finals Game 1', 'Basketball game', 'Sports', 4, 200.00),
('NFL Super Bowl', 'American football championship game', 'Sports', 5, 500.00),
('The Metropolitan Opera: Tosca', 'Opera performance', 'Music', 4, 125.00),
('Les Miserables', 'A musical based on the novel by Victor Hugo', 'Musical', 5, 95.00),
('Phantom of the Opera', 'A musical about a mysterious phantom who haunts an opera house', 'Musical', 4, 85.00),
('Harry Potter and the Cursed Child', 'A play based on an original story by J.K. Rowling', 'Play', 4, 120.00),
('The Magic Show', 'A Las Vegas-style magic show', 'Magic', 4, 100.00);
-- Sample data for the show_tags table
INSERT INTO
show_tags (show_id, tag)
VALUES
(1, 'Music'),
(1, 'Hip-hop'),
(2, 'Theatre'),
(2, 'Broadway'),
(3, 'Theatre'),
(3, 'Broadway'),
(4, 'Music'),
(4, 'Rock'),
(5, 'Music'),
(5, 'Pop'),
(6, 'Sports'),
(6, 'Wrestling'),
(7, 'Dance'),
(7, 'Ballet'),
(8, 'Circus'),
(8, 'Acrobatic'),
(9, 'Theatre'),
(9, 'Musical'),
(9, 'Comedy'),
(10, 'Music'),
(10, 'Arts'),
(11, 'Music'),
(11, 'Rock concert'),
(12, 'Comedy'),
(12, 'Stand-up'),
(13, 'Sports'),
(13, 'Basketball'),
(14, 'Sports'),
(15, 'Music'),
(15, 'Opera'),
(16, 'Musical'),
(17, 'Musical'),
(18, 'Play'),
(19, 'Magic');
-- Sample data for the scheduled_at table
INSERT INTO
scheduled_at (show_id, venue_id, show_date)
VALUES
(1, 4, '2023-07-14'),
(1, 10, '2023-03-16'),
(1, 13, '2023-08-09'),
(1, 14, '2023-10-01'),
(1, 16, '2023-08-19'),
(2, 1, '2023-06-11'),
(2, 3, '2023-08-17'),
(2, 8, '2023-07-17'),
(2, 10, '2023-10-24'),
(2, 17, '2023-08-03'),
(3, 5, '2023-10-12'),
(3, 8, '2023-09-16'),
(4, 4, '2023-01-13'),
(4, 5, '2023-12-18'),
(4, 9, '2023-10-23'),
(4, 10, '2023-10-20'),
(4, 11, '2023-08-10'),
(4, 14, '2023-03-28'),
(4, 15, '2023-02-18'),
(6, 7, '2023-04-13'),
(6, 16, '2023-07-03'),
(6, 17, '2023-04-05'),
(8, 4, '2023-03-16'),
(8, 5, '2023-08-15'),
(8, 8, '2023-04-24'),
(9, 1, '2023-04-16'),
(9, 12, '2023-02-01'),
(10, 1, '2023-11-15'),
(10, 7, '2023-08-21'),
(10, 8, '2023-06-23'),
(10, 13, '2023-10-20'),
(11, 2, '2023-11-21'),
(11, 9, '2023-05-02'),
(11, 10, '2023-06-16'),
(11, 11, '2023-02-16'),
(11, 12, '2023-02-21'),
(13, 4, '2023-07-19'),
(13, 10, '2023-05-09'),
(13, 17, '2023-10-06'),
(14, 9, '2023-11-15'),
(15, 4, '2023-01-20'),
(15, 15, '2023-03-06'),
(16, 7, '2023-07-03'),
(16, 12, '2023-04-28'),
(17, 8, '2023-07-10'),
(17, 10, '2023-08-07'),
(18, 8, '2023-08-25'),
(18, 13, '2023-09-19'),
(18, 17, '2023-10-04'),
(18, 17, '2023-11-26');
-- Sample data for the bought_ticket table
INSERT INTO
booking (user_id, svd_id)
VALUES
(1, 2),
(1, 7),
(1, 18),
(2, 13),
(2, 38),
(3, 9),
(3, 11),
(3, 16),
(3, 44),
(3, 48);