· 8 years ago · Mar 16, 2018, 12:50 PM
1CREATE TABLE IF NOT EXISTS `FLIGHT` (
2 `FlightNumber` int(5) NOT NULL,
3 `TailNumber` int(5) default NULL,
4 `SkidIDNumber` int(5) default NULL,
5 `CrewID` int(5) default NULL,
6 `Title` varchar(3) default NULL,
7 `Time` varchar(5) default NULL,
8 `Date` varchar(10) default NULL,
9 `Origin` varchar(20) default NULL,
10 `Destination` varchar(20) default NULL,
11 PRIMARY KEY (`FlightNumber`),
12 KEY `TailNumber` (`TailNumber`),
13 KEY `SkididNumber` (`SkidIDNumber`),
14 KEY `CrewId` (`CrewID`)
15) ENGINE=MyISAM DEFAULT CHARSET=latin1;
16
17INSERT INTO `FLIGHT` (`FlightNumber`, `TailNumber`, `SkidIDNumber`, `CrewID`, `Title`, `Time`, `Date`, `Origin`, `Destination`) VALUES
18(200, 500, 10000, 101, 'SAN', '05:30', '2011-10-31', '', 'SAN DIEGO'),
19(201, 501, 10001, 102, 'JFK', '00:30', '2011-10-31', 'NEW YORK', ''),
20(202, 502, 10002, 103, 'LAX', '02:45', '2011-10-31', 'LOS ANGELOS', ''),
21(203, 503, 10003, 104, 'JAX', '16:45', '2011-11-01', '', 'JACKSONVILLE'),
22(204, 504, 10004, 105, 'SFO', '21:05', '2011-11-01', 'SAN FRANSISCO', ''),
23(205, 505, 10005, 106, 'DEN', '01:25', '2011-11-01', '', 'DENVER'),
24(206, 506, 10006, 107, 'IAD', '04:15', '2011-11-01', 'WASHINGTON D.C.', ''),
25(207, 507, 10007, 108, 'ORD', '12:45', '2011-11-02', '', 'CHICAGO'),
26(208, 508, 10008, 109, 'ATL', '10:10', '2011-11-02', 'ATLANTA', ''),
27(209, 509, 10009, 110, 'DFW', '14:05', '2011-11-02', '', 'DALLAS/FORT WORTH'),
28(210, 510, 10010, 111, 'LGA', '23:55', '2011-11-02', '', 'NEW YORK/LGA'),
29(211, 511, 10011, 112, 'PHL', '19:20', '2011-11-03', 'PHILADELPHIA', ''),
30(212, 512, 10012, 113, 'EWR', '11:00', '2011-11-03', '', 'NEWARK'),
31(213, 513, 10013, 114, 'SLC', '13:30', '2011-11-03', 'SALT LAKE CITY', ''),
32(214, 514, 10014, 115, 'BUF', '20:20', '2011-11-03', '', 'BUFFALO');