Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INSERT INTO account_logins
- VALUES ('1', 'Nick', 'password123', 'nickster@gmail.com', 'health requirements', 'x2 Adult');
- INSERT INTO account_logins
- VALUES ('2', 'Jenifer', 'omgitsjen12', 'jennysflowers@gmail.com', 'enjoys cooking', 'x2 promotion, x3 child');
- INSERT INTO cinemas
- VALUES ('1', 'cineworld', '3', '24');
- INSERT INTO cinemas
- VALUES ('2', 'odeon', '2', '36');
- INSERT INTO cinemas
- VALUES ('3', 'vue', '4', '40');
- INSERT INTO movies
- VALUES ('1', 'Joker', 'Feburary', '2020', '17.00', '2', 'Action', '15');
- INSERT INTO movies
- VALUES ('2', 'Harry Potter', 'Feburary', '2020', '17.00', '2','Fantasy', '18');
- INSERT INTO movies
- VALUES ('3', 'The Shining', 'March', '2020', '17.30','3','Horror', '18');
- INSERT INTO movies
- VALUES ('4', 'Chicken Little', 'March', '2019', '18.00','2','Adventure', '18');
- INSERT INTO movies
- VALUES ('5', 'Sonic', 'April', '2020', 'Comedy', '18.00','1', '18');
- INSERT INTO seat_price
- VALUES ('1', '2', '1', '0', '0', '0', '2', '0', '10','12','7','8','12','5', '0');
- INSERT INTO seat_price
- VALUES ('2', '0', '0', '1', '1', '1', '2', '2', '11','14','3','6','17','5', '0');
- INSERT INTO seat_price
- VALUES ('3', '0', '0', '0', '1', '1', '0', '0', '19','12','5','5','19','5', '0');
- INSERT INTO movie_seat_booking
- VALUES ('1', '1', 'G', '7', '1','3');
- INSERT INTO movie_seat_booking
- VALUES ('2', '1', 'G', '8', '1', '3');
- INSERT INTO movie_seat_booking
- VALUES ('3', '1', 'G', '9', '1', '3');
- INSERT INTO movie_seat_booking
- VALUES ('4', '2', 'C', '1', '4', '2');
- INSERT INTO movie_seat_booking
- VALUES ('5', '2', 'D', '2', '4', '2');
- INSERT INTO movie_seat_booking
- VALUES ('6', '2', 'R', '2', '4', '2');
- INSERT INTO movie_seat_booking
- VALUES ('7', '2', 'G', '2', '4', '2');
- INSERT INTO movie_seat_booking
- VALUES ('8', '2', 'F', '2', '4', '2');
- INSERT INTO movie_seat_booking
- VALUES ('9', '2', 'E', '2', '4', '2');
- INSERT INTO movie_seat_booking
- VALUES ('10','2', 'B', '2', '4', '2');
Add Comment
Please, Sign In to add comment