insertions.sql

INSERT INTO ADMIN values(001,'CHEEMJU','YAMSHU');

INSERT INTO FLIGHT VALUES(1001, 'AirIndia', 'Delhi', 'Chennai', '01-05-2022 08:00:01','01-05-2022 11:00:00', 100, 7000,'3 hours 0 minutes', 001);
INSERT INTO FLIGHT VALUES(1002, 'JetAirways', 'Delhi', 'Chennai', '08-05-2022 04:00:01','08-05-2022 7:00:00', 200, 5000,'3 hours 0 minutes', 001);
INSERT INTO FLIGHT VALUES(1003, 'AirIndia', 'Mumbai', 'Bengaluru', '06-05-2022 10:00:00','06-05-2022 11:58:00', 300, 9000,'2 hours 58 minutes', 001);
INSERT INTO FLIGHT VALUES(1004, 'Eithad', 'Mumbai', 'Hyderabad', '02-05-2022 9:30:00','02-05-2022 10:40:00', 250, 10000,'1 hours 10 minutes', 001);
INSERT INTO FLIGHT VALUES(1005, 'GoAir', 'Bengaluru', 'Chennai', '04-05-2022 01:30:00','04-05-2022 03:00:00', 600, 20000,'1 hours 30 minutes', 001);
INSERT INTO FLIGHT VALUES(1006, 'AirIndia', 'Delhi', 'Mumbai', '18-05-2022 09:00:01','18-05-2022 11:30:01', 150, 6000,'2 hours 30 minutes', 001);

INSERT INTO CUSTOMER VALUES(200, 'Vibhav', 'Shukla',DATE '2002-07-15','vshukla_be20@thapar.edu',8851423091,'12345');
INSERT INTO CUSTOMER VALUES(201, 'Yashvardhan', 'Arora',DATE '2001-10-22','yarora_be20@thapar.edu',9625056985,'13579');
INSERT INTO CUSTOMER VALUES(202, 'Nikhil', 'Bakshi',DATE '2001-10-19','nbakshi_be20@thapar.edu',7042320972,'24680');
INSERT INTO CUSTOMER VALUES(203, 'Sidharth', 'Bahl',DATE '2002-04-20','sbahl_be20@thapar.edu',8130664467,'123789');
INSERT INTO CUSTOMER VALUES(204, 'Raghav', 'Sharma',DATE '2002-02-17','rsharma_be20@thapar.edu',9880918485,'456123');


 

INSERT INTO TICKET(CID,FLIGHT_ID,FOOD_PREF,isVALID)
VALUES(200, 1001, 'VEG' ,1);
INSERT INTO TICKET(CID,FLIGHT_ID,FOOD_PREF,isVALID)
VALUES(200, 1001, 'VEG' ,1);
INSERT INTO TICKET(CID,FLIGHT_ID,FOOD_PREF,isVALID)
VALUES(201, 1002, 'NONVEG' ,1);