02_insert_data.sql

INSERT INTO tbl_companies 
(name, email, tax_id, registration_country, address, license, contact_person_name, contact_person_email, contact_person_phone)
VALUES
('Ultra Music Festival LLC', 'info@ultramusicfestival.com', 'INT-021', 'USA', 'Miami, Florida', 'Festival Authorization', 'John Carter', 'john.carter@ultramusicfestival.com', '+1-305-555-0101'),
('Glastonbury Festival Ltd', 'contact@glastonburyfestivals.co.uk', 'INT-022', 'UK', 'Somerset, England', 'Festival Authorization', 'Emily Brown', 'emily.brown@glastonburyfestivals.co.uk', '+44-20-555-0102'),
('Web Summit Lisbon', 'hello@websummit.com', 'INT-023', 'Portugal', 'Lisbon, Portugal', 'Conference Organizer License', 'Miguel Santos', 'miguel.santos@websummit.com', '+351-21-555-0103'),
('TED Conferences LLC', 'info@ted.com', 'INT-024', 'USA', 'New York, USA', 'Conference Organizer License', 'Sarah Lee', 'sarah.lee@ted.com', '+1-212-555-0104'),
('Google Events Team', 'events@google.com', 'INT-025', 'USA', 'Mountain View, California', 'Tech Product Launch License', 'Mark Johnson', 'mark.johnson@google.com', '+1-650-555-0105'),
('Microsoft Events Division', 'events@microsoft.com', 'INT-026', 'USA', 'Redmond, Washington', 'Tech Product Launch License', 'Anna White', 'anna.white@microsoft.com', '+1-425-555-0106'),
('Berlin Marathon GmbH', 'info@berlinmarathon.com', 'INT-027', 'Germany', 'Berlin, Germany', 'Marathon Organizer License', 'Thomas Müller', 'thomas.muller@berlinmarathon.com', '+49-30-555-0107'),
('New York Road Runners', 'nyrr@nyrr.org', 'INT-028', 'USA', 'New York, USA', 'Marathon Organizer License', 'Jessica Adams', 'jessica.adams@nyrr.org', '+1-212-555-0108'),
('Red Bull Events', 'events@redbull.com', 'INT-029', 'Austria', 'Salzburg, Austria', 'Extreme Sports License', 'Lukas Steiner', 'lukas.steiner@redbull.com', '+43-662-555-0109'),
('Venice Biennale Foundation', 'info@labiennale.org', 'INT-030', 'Italy', 'Venice, Italy', 'Art Exhibition License', 'Giulia Rossi', 'giulia.rossi@labiennale.org', '+39-041-555-0110'),
('Frieze Art Fair Ltd', 'contact@frieze.com', 'INT-031', 'UK', 'London, UK', 'Art Exhibition License', 'Oliver Smith', 'oliver.smith@frieze.com', '+44-20-555-0111'),
('Sundance Institute', 'info@sundance.org', 'INT-032', 'USA', 'Utah, USA', 'Film Festival License', 'Rachel Green', 'rachel.green@sundance.org', '+1-801-555-0112'),
('Toronto International Film Festival Group', 'contact@tiff.net', 'INT-033', 'Canada', 'Toronto, Canada', 'Film Festival License', 'Daniel Clark', 'daniel.clark@tiff.net', '+1-416-555-0113'),
('National Theatre London', 'info@nationaltheatre.org.uk', 'INT-034', 'UK', 'London, UK', 'Theatre License', 'Charlotte Evans', 'charlotte.evans@nationaltheatre.org.uk', '+44-20-555-0114'),
('Broadway League', 'contact@broadway.org', 'INT-035', 'USA', 'New York, USA', 'Theatre License', 'Michael Harris', 'michael.harris@broadway.org', '+1-212-555-0115'),
('Oxford Symposium on Food & Cookery', 'info@oxfordsymposium.org.uk', 'INT-036', 'UK', 'Oxford, UK', 'Academic Conference License', 'Sophie Turner', 'sophie.turner@oxfordsymposium.org.uk', '+44-1865-555-0116'),
('MIT Media Lab Events', 'events@mit.edu', 'INT-037', 'USA', 'Cambridge, Massachusetts', 'Academic Conference License', 'David Kim', 'david.kim@mit.edu', '+1-617-555-0117'),
('Safari Adventures Africa', 'info@safariadventures.com', 'INT-038', 'Kenya', 'Nairobi, Kenya', 'Tourism License', 'Peter Okello', 'peter.okello@safariadventures.com', '+254-20-555-0118'),
('Amazon Rainforest Expeditions', 'contact@amazonexpeditions.com', 'INT-039', 'Brazil', 'Manaus, Brazil', 'Adventure Tourism License', 'Mariana Costa', 'mariana.costa@amazonexpeditions.com', '+55-92-555-0119'),
('ITB Berlin', 'info@itb-berlin.com', 'INT-040', 'Germany', 'Berlin, Germany', 'Travel Expo License', 'Stefan Becker', 'stefan.becker@itb-berlin.com', '+49-30-555-0120');

INSERT INTO tbl_companies 
(name, email, tax_id, registration_country, address, license, contact_person_name, contact_person_email, contact_person_phone)
VALUES
('Coachella Valley Music and Arts', 'info@coachella.com', 'INT-041', 'USA', 'Indio, California', 'Festival Authorization', 'Paul Tollett', 'paul.tollett@coachella.com', '+1-760-555-0121'),
('Primavera Sound Barcelona', 'contact@primaverasound.com', 'INT-042', 'Spain', 'Barcelona, Spain', 'Festival Authorization', 'Ana Martinez', 'ana.martinez@primaverasound.com', '+34-93-555-0122'),
('Electric Daisy Carnival', 'info@edc.com', 'INT-043', 'USA', 'Las Vegas, Nevada', 'Festival Authorization', 'James Walker', 'james.walker@edc.com', '+1-702-555-0123'),
('SXSW Film & Music', 'events@sxsw.com', 'INT-044', 'USA', 'Austin, Texas', 'Conference & Festival License', 'Laura Green', 'laura.green@sxsw.com', '+1-512-555-0124'),
('Collision Conference Toronto', 'info@collisionconf.com', 'INT-045', 'Canada', 'Toronto, Canada', 'Conference Organizer License', 'Daniel Scott', 'daniel.scott@collisionconf.com', '+1-416-555-0125'),
('AWS Events', 'events@amazon.com', 'INT-046', 'USA', 'Seattle, Washington', 'Tech Conference License', 'Karen Smith', 'karen.smith@amazon.com', '+1-206-555-0126'),
('IBM Think Conference', 'info@ibm.com', 'INT-047', 'USA', 'New York, USA', 'Tech Conference License', 'Robert Brown', 'robert.brown@ibm.com', '+1-212-555-0127'),
('London Marathon Ltd', 'info@londonmarathon.com', 'INT-048', 'UK', 'London, England', 'Marathon Organizer License', 'Helen Carter', 'helen.carter@londonmarathon.com', '+44-20-555-0128'),
('Chicago Marathon Inc', 'info@chicagomarathon.com', 'INT-049', 'USA', 'Chicago, Illinois', 'Marathon Organizer License', 'Brian Wilson', 'brian.wilson@chicagomarathon.com', '+1-312-555-0129'),
('X Games Organizers', 'info@xgames.com', 'INT-050', 'USA', 'Aspen, Colorado', 'Extreme Sports License', 'Chris Johnson', 'chris.johnson@xgames.com', '+1-970-555-0130'),
('Documenta Kassel', 'info@documenta.de', 'INT-051', 'Germany', 'Kassel, Germany', 'Art Exhibition License', 'Sabine Keller', 'sabine.keller@documenta.de', '+49-561-555-0131'),
('MoMA Exhibitions', 'events@moma.org', 'INT-052', 'USA', 'New York, USA', 'Art Exhibition License', 'Emily Davis', 'emily.davis@moma.org', '+1-212-555-0132'),
('Berlin International Film Festival', 'info@berlinale.de', 'INT-053', 'Germany', 'Berlin, Germany', 'Film Festival License', 'Hans Schmidt', 'hans.schmidt@berlinale.de', '+49-30-555-0133'),
('Locarno Film Festival', 'info@locarnofestival.ch', 'INT-054', 'Switzerland', 'Locarno, Switzerland', 'Film Festival License', 'Marco Rossi', 'marco.rossi@locarnofestival.ch', '+41-91-555-0134'),
('Royal Shakespeare Company', 'info@rsc.org.uk', 'INT-055', 'UK', 'Stratford-upon-Avon, England', 'Theatre License', 'Alice Turner', 'alice.turner@rsc.org.uk', '+44-1789-555-0135'),
('Sydney Opera House Events', 'events@sydneyoperahouse.com', 'INT-056', 'Australia', 'Sydney, Australia', 'Theatre & Concert License', 'Matthew Clark', 'matthew.clark@sydneyoperahouse.com', '+61-2-555-0136'),
('Cambridge University Conferences', 'info@cam.ac.uk', 'INT-057', 'UK', 'Cambridge, England', 'Academic Conference License', 'Richard Evans', 'richard.evans@cam.ac.uk', '+44-1223-555-0137'),
('Stanford University Events', 'events@stanford.edu', 'INT-058', 'USA', 'Stanford, California', 'Academic Conference License', 'Linda Moore', 'linda.moore@stanford.edu', '+1-650-555-0138'),
('Adventure Himalaya Treks', 'info@himalayatreks.com', 'INT-059', 'Nepal', 'Kathmandu, Nepal', 'Adventure Tourism License', 'Rajesh Shrestha', 'rajesh.shrestha@himalayatreks.com', '+977-1-555-0139'),
('Kyoto Cultural Tours', 'info@kyotoculturaltours.jp', 'INT-060', 'Japan', 'Kyoto, Japan', 'Cultural Tourism License', 'Yuki Tanaka', 'yuki.tanaka@kyotoculturaltours.jp', '+81-75-555-0140');


INSERT INTO tbl_users (name, email, phone, password_hash)
VALUES
('Alice Johnson', 'alice.johnson@example.com', '+1-202-555-0147', 'hash_pw1'),
('Bruno Silva', 'bruno.silva@example.com', '+55-11-91234-5678', 'hash_pw2'),
('Carla Mendes', 'carla.mendes@example.com', '+55-21-99876-5432', 'hash_pw3'),
('David Thompson', 'david.thompson@example.com', '+44-20-7946-0958', 'hash_pw4'),
('Emma Williams', 'emma.williams@example.com', '+1-310-555-0199', 'hash_pw5'),
('Felipe Costa', 'felipe.costa@example.com', '+55-31-98765-4321', 'hash_pw6'),
('Grace Lee', 'grace.lee@example.com', '+1-617-555-0133', 'hash_pw7'),
('Hiro Tanaka', 'hiro.tanaka@example.com', '+81-90-1234-5678', 'hash_pw8'),
('Isabella Rossi', 'isabella.rossi@example.com', '+39-06-555-0123', 'hash_pw9'),
('Jack Miller', 'jack.miller@example.com', '+1-415-555-0177', 'hash_pw10');


INSERT INTO tbl_categories (name, parent_id) VALUES
('Music', NULL),
('Entrepreneurship', NULL),
('Fashion', NULL),
('Gastronomy', NULL),
('Comedy', NULL),
('Technology', NULL),
('Sports', NULL),
('Art & Culture', NULL),
('Education', NULL),
('Travel & Tourism', NULL);

INSERT INTO tbl_categories (name, parent_id) VALUES ('Music', NULL) RETURNING id;

INSERT INTO tbl_categories (name, parent_id) VALUES
('Festivals & Major Events', 1),
('Live Shows', 1),
('Music Education', 1);

INSERT INTO tbl_categories (name, parent_id) VALUES
('Tomorrowland', 2), ('Rock in Rio', 2), ('Coachella', 2),
('Rock/Metal Concerts', 3), ('Pop/Electronic Shows', 3), ('Jazz/Blues Nights', 3),
('Instrument Workshops', 4), ('Vocal Training', 4), ('Music Theory Seminars', 4);

INSERT INTO tbl_categories (name, parent_id) VALUES ('Entrepreneurship', NULL);

INSERT INTO tbl_categories (name, parent_id) VALUES
('Conferences', 5),
('Workshops', 5),
('Networking Events', 5);

INSERT INTO tbl_categories (name, parent_id) VALUES
('Web Summit', 6), ('Startup Grind', 6), ('SXSW Startup Track', 6),
('Leadership Bootcamps', 7), ('Finance & Investment Workshops', 7), ('Project Management Labs', 7),
('Sales Meetups', 8), ('Marketing Mixers', 8), ('Investor Pitch Nights', 8);

INSERT INTO tbl_categories (name, parent_id) VALUES ('Fashion', NULL);

INSERT INTO tbl_categories (name, parent_id) VALUES
('Fashion Weeks', 9),
('Exhibitions', 9),
('Launch Events', 9);

INSERT INTO tbl_categories (name, parent_id) VALUES
('Paris Fashion Week', 10), ('Milan Fashion Week', 10), ('New York Fashion Week', 10),
('Sustainable Fashion Expo', 11), ('Vintage Collections Exhibition', 11), ('Photography of Fashion', 11),
('Collection Launch Parties', 12), ('Designer Collaborations', 12), ('Luxury Brand Showcases', 12);

INSERT INTO tbl_categories (name, parent_id) VALUES ('Gastronomy', NULL);

INSERT INTO tbl_categories (name, parent_id) VALUES
('Food Festivals', 13),
('Masterclasses', 13),
('Wine & Beer Events', 13);

INSERT INTO tbl_categories (name, parent_id) VALUES
('Taste of London', 14), ('Madrid Fusion', 14), ('Melbourne Food & Wine Festival', 14),
('International Cuisine Classes', 15), ('Pastry & Dessert Workshops', 15), ('Mixology Sessions', 15),
('Oktoberfest', 16), ('Great American Beer Festival', 16), ('Vinitaly', 16);

INSERT INTO tbl_categories (name, parent_id) VALUES ('Comedy', NULL);


INSERT INTO tbl_categories (name, parent_id) VALUES
('Stand-up', 17),
('Comedy Festivals', 17),
('Improv Shows', 17);

INSERT INTO tbl_categories (name, parent_id) VALUES
('Dave Chappelle Live', 18), ('Kevin Hart Tour', 18), ('Ali Wong Specials', 18),
('Edinburgh Fringe Festival', 19), ('Just for Laughs Montreal', 19), ('Melbourne Comedy Festival', 19),
('Whose Line Is It Anyway', 20), ('UCB Improv Nights', 20), ('Second City Chicago', 20);

INSERT INTO tbl_categories (name, parent_id) VALUES ('Technology', NULL);

INSERT INTO tbl_categories (name, parent_id) VALUES
('Tech Conferences', 21),
('Hackathons', 21),
('Product Launches', 21);

INSERT INTO tbl_categories (name, parent_id) VALUES
('CES Las Vegas', 22), ('Mobile World Congress', 22), ('AWS re:Invent', 22),
('Global Hackathon Series', 23), ('NASA Space Apps Challenge', 23), ('HackZurich', 23),
('Apple WWDC', 24), ('Google I/O', 24), ('Microsoft Build', 24);

INSERT INTO tbl_categories (name, parent_id) VALUES ('Sports', NULL);

INSERT INTO tbl_categories (name, parent_id) VALUES
('International Tournaments', 25),
('Marathons', 25),
('Extreme Sports', 25);

INSERT INTO tbl_categories (name, parent_id) VALUES
('FIFA World Cup', 26), ('Olympic Games', 26), ('Wimbledon', 26),
('Boston Marathon', 27), ('Berlin Marathon', 27), ('New York Marathon', 27),
('X Games', 28), ('Red Bull Cliff Diving', 28), ('Winter X Games', 28);

INSERT INTO tbl_categories (name, parent_id) VALUES ('Art & Culture', NULL);

INSERT INTO tbl_categories (name, parent_id) VALUES
('Art Exhibitions', 29),
('Film Festivals', 29),
('Theatre', 29);

INSERT INTO tbl_categories (name, parent_id) VALUES
('Art Basel', 30), ('Venice Biennale', 30), ('Frieze London', 30),
('Cannes Film Festival', 31), ('Sundance Film Festival', 31), ('Toronto International Film Festival', 31),
('Broadway Shows', 32), ('Shakespeare Festivals', 32), ('National Theatre London', 32);

INSERT INTO tbl_categories (name, parent_id) VALUES ('Education', NULL);


INSERT INTO tbl_categories (name, parent_id) VALUES
('Academic Conferences', 33),
('Workshops', 33),
('Seminars', 33);

INSERT INTO tbl_categories (name, parent_id) VALUES
('Harvard Education Conference', 34), ('Oxford Symposium', 34), ('MIT Learning Summit', 34),
('Teacher Training Workshops', 35), ('STEM Labs', 35), ('Language Learning Workshops', 35),
('Philosophy Seminars', 36), ('Psychology Seminars', 36), ('Economics Seminars', 36);

INSERT INTO tbl_categories (name, parent_id) VALUES ('Travel & Tourism', NULL);

INSERT INTO tbl_categories (name, parent_id) VALUES
('Travel Expos', 37),
('Adventure Tours', 37),
('Cultural Trips', 37);

INSERT INTO tbl_categories (name, parent_id) VALUES
('World Travel Market London', 38), ('ITB Berlin', 38), ('Arabian Travel Market Dubai', 38),
('Safari Tours Africa', 39), ('Himalayan Treks', 39), ('Amazon Rainforest Expeditions', 39),
('Historical Tours Rome', 40), ('Cultural Trips Kyoto', 40), ('Heritage Tours Egypt', 40);


INSERT INTO tbl_events 
(company_id, category_id, event_name, license, event_date, event_time, venue, city, state, country, postal_code, ticket_link)
VALUES
(21, 2, 'Ultra Music Festival 2026', 'Festival Authorization #UMF2026', '2026-03-25', '18:00', 'Bayfront Park', 'Miami', 'Florida', 'USA', '33132', 'https://ultramusicfestival.com/tickets'),

(22, 2, 'Glastonbury Festival 2026', 'Festival Authorization #GLASTO2026', '2026-06-28', '12:00', 'Pyramid Stage', 'Somerset', 'England', 'UK', 'BA6', 'https://glastonburyfestivals.co.uk/tickets'),

(23, 6, 'Web Summit Lisbon 2026', 'Conference Permit #WS2026', '2026-11-01', '09:00', 'Altice Arena', 'Lisbon', 'Lisbon', 'Portugal', '1990-214', 'https://websummit.com/tickets'),

(24, 6, 'TED Global Conference 2026', 'Conference Permit #TED2026', '2026-08-20', '10:00', 'Lincoln Center', 'New York', 'NY', 'USA', '10023', 'https://ted.com/tickets'),

(25, 21, 'Google I/O 2026', 'Tech Launch License #GOOGLE2026', '2026-05-10', '09:00', 'Shoreline Amphitheatre', 'Mountain View', 'California', 'USA', '94043', 'https://events.google.com/io'),

(26, 21, 'Microsoft Build 2026', 'Tech Launch License #MSBUILD2026', '2026-05-15', '09:00', 'Microsoft Campus', 'Redmond', 'Washington', 'USA', '98052', 'https://build.microsoft.com/tickets'),

(27, 25, 'Berlin Marathon 2026', 'Marathon License #BERLIN2026', '2026-09-27', '08:00', 'Start Line Straße des 17. Juni', 'Berlin', 'Berlin', 'Germany', '10557', 'https://berlinmarathon.com/tickets'),

(28, 25, 'New York City Marathon 2026', 'Marathon License #NYC2026', '2026-11-02', '08:00', 'Central Park', 'New York', 'NY', 'USA', '10023', 'https://nyrr.org/tickets'),

(29, 28, 'X Games Aspen 2026', 'Extreme Sports License #XGAMES2026', '2026-01-25', '14:00', 'Buttermilk Mountain', 'Aspen', 'Colorado', 'USA', '81611', 'https://xgames.com/tickets'),

(30, 29, 'Venice Biennale 2026', 'Art Exhibition License #VENICE2026', '2026-06-01', '10:00', 'Giardini della Biennale', 'Venice', 'Veneto', 'Italy', '30122', 'https://labiennale.org/tickets'),

(31, 29, 'Frieze London 2026', 'Art Exhibition License #FRIEZE2026', '2026-10-10', '11:00', 'Regent’s Park', 'London', 'England', 'UK', 'NW1', 'https://frieze.com/tickets'),

(32, 31, 'Sundance Film Festival 2026', 'Film Festival License #SUNDANCE2026', '2026-01-20', '15:00', 'Egyptian Theatre', 'Park City', 'Utah', 'USA', '84060', 'https://sundance.org/tickets'),

(33, 31, 'Toronto International Film Festival 2026', 'Film Festival License #TIFF2026', '2026-09-05', '14:00', 'TIFF Bell Lightbox', 'Toronto', 'Ontario', 'Canada', 'M5V', 'https://tiff.net/tickets'),

(34, 32, 'National Theatre Premiere 2026', 'Theatre License #NT2026', '2026-04-15', '19:00', 'National Theatre', 'London', 'England', 'UK', 'SE1', 'https://nationaltheatre.org.uk/tickets'),

(35, 32, 'Broadway Revival 2026', 'Theatre License #BROADWAY2026', '2026-05-01', '20:00', 'Broadway Theatre', 'New York', 'NY', 'USA', '10036', 'https://broadway.org/tickets');