drop table flightdetails cascade constraints;

start c:\java\flightdetails_table;
start c:\java\flightdetails_insert;
start c:\java\flightdetails_update;
start c:\java\flightdetails_delete;
start c:\java\flightdetails_first;
start c:\java\flightdetails_last;
start c:\java\flightdetails_next;
start c:\java\flightdetails_previous;

insert into flightdetails values(1,'R0001','AI-111','1','.','3','.','.','.','7','310',''   ,'BOM','LON','NYC','   ','','','');
insert into flightdetails values(2,'R0001','AI-101','.','2','.','.','5','6','.','310','744','BLR','BOM','LON','NYC','','','');
insert into flightdetails values(3,'R0001','AI-101','.','.','.','4','.','.','.','310','744','MAA','BOM','LON','NYC','','','');

insert into flightdetails values(4,'R0002','AI-440','1','.','.','.','.','.','.','310',''   ,'BOM','BLR','SIN','   ','','','');
insert into flightdetails values(5,'R0002','AI-442','.','2','.','.','.','.','.','310',''   ,'BOM','HYD','SIN','   ','','','');

commit;