delete from Seat_Status;
delete from Seat_Plan_Seat;
delete from Booking;
delete from Price_Band;
delete from Performance;
delete from Price_Structure;
delete from Shows;
delete from Genre;
delete from Seating_Plan;
delete from Seat_Class;
update Seat set left_Seat_id = null, right_Seat_id = null;
delete from Seat;
insert into genre (id, name) values (1, 'Rock');
insert into genre (id, name) values (2, 'Ballet');
insert into genre (id, name) values (3, 'Theatre');
insert into genre (id, name) values (4, 'Classical');
insert into genre (id, name) values (5, 'Musical');
insert into genre (id, name) values (6, 'Opera');
insert into seating_plan (id, name) values (1, 'Standard Opera Seating');
insert into shows (id, name, Genre_id, Seating_plan_id) values (1, 'Romeo and Juliet', 3, 1);
insert into shows (id, name, Genre_id, Seating_plan_id) values (2, 'Waiting for Godot', 3, 1);
insert into shows (id, name, Genre_id, Seating_plan_id) values (3, 'Giselle', 2, 1);
insert into shows (id, name, Genre_id, Seating_plan_id) values (4, 'Tristan und Isolde', 6, 1);
insert into shows (id, name, Genre_id, Seating_plan_id) values (5, 'La Traviata', 6, 1);
insert into shows (id, name, Genre_id, Seating_plan_id) values (6, 'Miss Saigon', 5, 1);
insert into shows (id, name, Genre_id, Seating_plan_id) values (7, 'Cats', 5, 1);
insert into seat_class (id, code, description) values (1, 'AA', 'Premium Reserve');
insert into seat_class (id, code, description) values (2, 'A', 'A Reserve');
insert into price_structure (id, name) values (1, 'Standard opera pricing');
insert into price_band (id, Price_Structure_id, Seat_Class_id, price) values (1, 1, 1, 195);
insert into price_band (id, Price_Structure_id, Seat_Class_id, price) values (2, 1, 2, 160);
insert into performance (id, date_and_time, Show_id, Price_Structure_id) values (1, '2004-11-12 19:30:00', 1, 1);
insert into performance (id, date_and_time, Show_id, Price_Structure_id) values (2, '2005-01-14 19:30:00', 1, 1);
insert into seat (id, name, row_or_box, row_pos) values (1, 'Seat 1-1', 1, 1);
insert into seat (id, name, row_or_box, row_pos) values (2, 'Seat 1-2', 1, 2);
insert into seat (id, name, row_or_box, row_pos) values (3, 'Seat 2-1', 2, 1);
insert into seat (id, name, row_or_box, row_pos) values (4, 'Seat 2-2', 2, 2);
insert into seat (id, name, row_or_box, row_pos) values (5, 'Seat 2-3', 2, 3);
insert into seat (id, name, row_or_box, row_pos) values (6, 'Seat 2-4', 2, 4);
update seat set right_Seat_id = 2 where id = 1;
update seat set left_Seat_id = 1 where id = 2;
update seat set right_Seat_id = 4 where id = 3;
update seat set left_Seat_id = 3, right_Seat_id = 5 where id = 4;
update seat set left_Seat_id = 4, right_Seat_id = 6 where id = 5;
update seat set left_Seat_id = 5 where id = 6;
insert into Seat_Plan_Seat (Seat_id, Seat_Class_id, Seating_Plan_id) values(1, 1, 1);
insert into Seat_Plan_Seat (Seat_id, Seat_Class_id, Seating_Plan_id) values(2, 1, 1);
insert into booking (id, date_made, price) values (1, '2004-11-14', 122.45);
insert into booking (id, date_made, price) values (2, '2004-11-16', 445.25);
insert into seat_status (Seat_id, Price_Band_id, Performance_id, Booking_id) values (1, 1, 1, null);
insert into seat_status (Seat_id, Price_Band_id, Performance_id, Booking_id) values (2, 1, 1, null);
insert into seat_status (Seat_id, Price_Band_id, Performance_id, Booking_id) values (1, 1, 2, 2);
insert into seat_status (Seat_id, Price_Band_id, Performance_id, Booking_id) values (2, 1, 2, 2);
