Database Schema db1 Airport

MS SQL Schema

CREATE DATABASE [FlightsAirport] GO USE [FlightsAirport] GO CREATE TABLE [dbo].[aircraft]( [AircraftID] smallint NOT NULL IDENTITY(1,1), [AircraftTypeID] smallint NOT NULL, [RegNum] nchar(6) NOT NULL, [LastMaintEnd] date NOT NULL, [NextMaintBegin] date NOT NULL, [NextMaintEnd] date NOT NULL, CONSTRAINT [aircraft_PK] PRIMARY KEY (AircraftID), CONSTRAINT [aircraft_AK] UNIQUE (RegNum), ); CREATE TABLE [dbo].[aircrafttype]( [AircraftTypeID] smallint NOT NULL IDENTITY (1,1), [AircraftName] nvarchar(255) NOT NULL, CONSTRAINT [aircraftType_PK] PRIMARY KEY (AircraftTypeID), ); CREATE TABLE [dbo].[airport]( [AirportID] smallint NOT NULL IDENTITY (1,1), [AirportCode] nchar(3) NOT NULL, [AirportName] nvarchar(255) NOT NULL, [CityName] nvarchar(255) NOT NULL, [CountryCode] nchar(2) NOT NULL, [NumRunways] tinyint NOT NULL, [NumTerminals] tinyint NOT NULL, CONSTRAINT [airport_PK] PRIMARY KEY (AirportID), CONSTRAINT [airport_AK] UNIQUE (AirportCode), ); CREATE NONCLUSTERED INDEX [airport_IDX] ON [dbo].[airport]( [CountryCode] ASC ); CREATE TABLE [dbo].[class]( [ClassID] int NOT NULL IDENTITY (1,1), [ClassName] nvarchar(25) NOT NULL, CONSTRAINT [class_PK] PRIMARY KEY (ClassID), ); CREATE TABLE [dbo].[flight]( [FlightID] smallint NOT NULL IDENTITY (1,1), [RouteID] smallint NOT NULL, [AircraftID] smallint NOT NULL, CONSTRAINT [flight_PK] PRIMARY KEY (FlightID), ); CREATE NONCLUSTERED INDEX [flight_IDX] ON [dbo].[flight]( [AircraftID] ASC ); CREATE TABLE [dbo].[flightclass]( [FlightID] smallint NOT NULL, [ClassID] nchar(1) NOT NULL, [MaxSeats] smallint NOT NULL, [BasePrice] int NOT NULL ); CREATE NONCLUSTERED INDEX [flightclass_IDX] ON [dbo].[flightclass]( [ClassID] ASC ); CREATE TABLE [dbo].[flightdep]( [FlightID] smallint NOT NULL , [DepDay] tinyint NOT NULL, [DepTime] time(7) NOT NULL, CONSTRAINT [flightdep_PK] PRIMARY KEY (FlightID, DepDay, DepTime), ); CREATE TABLE [dbo].[log]( [RecordID] smallint NOT NULL IDENTITY(1,1), [ByUser] nchar(50) NOT NULL, [Note] nvarchar(max) NOT NULL, [EventTime] datetime2(7) NOT NULL, CONSTRAINT [log_PK] PRIMARY KEY (RecordID), ); CREATE TABLE [dbo].[pax]( [RecordID] int NOT NULL IDENTITY(1,1), [FlightID] int NOT NULL, [FlightDate] date NOT NULL, [ClassID] int NOT NULL, [PaxName] nvarchar(255) NOT NULL, [PaxRef] nvarchar(255) NULL, [Note] nvarchar(max) NULL, CONSTRAINT [pax_PK] PRIMARY KEY (RecordID), ); CREATE NONCLUSTERED INDEX [pax_IDX] ON [dbo].[pax]( [ClassID] ASC ); CREATE TABLE [dbo].[route]( [RouteID] smallint NOT NULL IDENTITY(1,1), [From] smallint NOT NULL, [To] smallint NOT NULL, [Distance] smallint NOT NULL, [Duration] smallint NOT NULL, [Status] tinyint NOT NULL, CONSTRAINT [route_PK] PRIMARY KEY (RouteID), ); CREATE NONCLUSTERED INDEX [route_IDX] ON [dbo].[route]( [Duration] ASC ); CREATE TABLE [dbo].[stats]( [FlightID] int NOT NULL, [FlightDate] date NOT NULL, [ClassID] int NOT NULL, [CurrSeats] int NOT NULL, [CurrPrice] int NOT NULL ) GO SET IDENTITY_INSERT [dbo].[aircraft] ON; INSERT [dbo].[aircraft] ([AircraftID], [AircraftTypeID], [RegNum], [LastMaintEnd], [NextMaintBegin], [NextMaintEnd]) VALUES (3125, 617, N'ZX1386', CAST(N'2007-12-12' AS Date), CAST(N'2009-02-01' AS Date), CAST(N'2009-02-22' AS Date)); INSERT [dbo].[aircraft] ([AircraftID], [AircraftTypeID], [RegNum], [LastMaintEnd], [NextMaintBegin], [NextMaintEnd]) VALUES (3128, 617, N'ZX7634', CAST(N'2008-03-07' AS Date), CAST(N'2009-05-07' AS Date), CAST(N'2009-05-18' AS Date)); INSERT [dbo].[aircraft] ([AircraftID], [AircraftTypeID], [RegNum], [LastMaintEnd], [NextMaintBegin], [NextMaintEnd]) VALUES (3130, 616, N'ZX7391', CAST(N'2008-09-15' AS Date), CAST(N'2009-04-15' AS Date), CAST(N'2009-05-15' AS Date)); INSERT [dbo].[aircraft] ([AircraftID], [AircraftTypeID], [RegNum], [LastMaintEnd], [NextMaintBegin], [NextMaintEnd]) VALUES (3145, 503, N'ZX5731', CAST(N'2008-04-17' AS Date), CAST(N'2009-12-20' AS Date), CAST(N'2009-12-30' AS Date)); INSERT [dbo].[aircraft] ([AircraftID], [AircraftTypeID], [RegNum], [LastMaintEnd], [NextMaintBegin], [NextMaintEnd]) VALUES (3189, 616, N'ZX582 ', CAST(N'2008-08-07' AS Date), CAST(N'2008-11-05' AS Date), CAST(N'2008-11-12' AS Date)); INSERT [dbo].[aircraft] ([AircraftID], [AircraftTypeID], [RegNum], [LastMaintEnd], [NextMaintBegin], [NextMaintEnd]) VALUES (3201, 617, N'ZX7472', CAST(N'2008-10-15' AS Date), CAST(N'2009-10-15' AS Date), CAST(N'2009-10-27' AS Date)); INSERT [dbo].[aircraft] ([AircraftID], [AircraftTypeID], [RegNum], [LastMaintEnd], [NextMaintBegin], [NextMaintEnd]) VALUES (3223, 618, N'ZX1037', CAST(N'2008-12-06' AS Date), CAST(N'2009-09-16' AS Date), CAST(N'2009-09-30' AS Date)); INSERT [dbo].[aircraft] ([AircraftID], [AircraftTypeID], [RegNum], [LastMaintEnd], [NextMaintBegin], [NextMaintEnd]) VALUES (3425, 504, N'ZX6821', CAST(N'2008-06-22' AS Date), CAST(N'2009-05-25' AS Date), CAST(N'2009-06-04' AS Date)); INSERT [dbo].[aircraft] ([AircraftID], [AircraftTypeID], [RegNum], [LastMaintEnd], [NextMaintBegin], [NextMaintEnd]) VALUES (3427, 616, N'ZX5921', CAST(N'2008-10-01' AS Date), CAST(N'2010-03-02' AS Date), CAST(N'2010-04-02' AS Date)); INSERT [dbo].[aircraft] ([AircraftID], [AircraftTypeID], [RegNum], [LastMaintEnd], [NextMaintBegin], [NextMaintEnd]) VALUES (3451, 503, N'ZX6488', CAST(N'2007-10-01' AS Date), CAST(N'2008-10-23' AS Date), CAST(N'2008-10-31' AS Date)); INSERT [dbo].[aircraft] ([AircraftID], [AircraftTypeID], [RegNum], [LastMaintEnd], [NextMaintBegin], [NextMaintEnd]) VALUES (3452, 617, N'ZX5464', CAST(N'2006-10-04' AS Date), CAST(N'2009-01-03' AS Date), CAST(N'2009-01-21' AS Date)); INSERT [dbo].[aircraft] ([AircraftID], [AircraftTypeID], [RegNum], [LastMaintEnd], [NextMaintBegin], [NextMaintEnd]) VALUES (3465, 503, N'ZX5373', CAST(N'1900-01-01' AS Date), CAST(N'2008-10-14' AS Date), CAST(N'2008-10-21' AS Date)); INSERT [dbo].[aircraft] ([AircraftID], [AircraftTypeID], [RegNum], [LastMaintEnd], [NextMaintBegin], [NextMaintEnd]) VALUES (3467, 616, N'ZX7283', CAST(N'2008-02-05' AS Date), CAST(N'2008-12-02' AS Date), CAST(N'2008-10-09' AS Date)); INSERT [dbo].[aircraft] ([AircraftID], [AircraftTypeID], [RegNum], [LastMaintEnd], [NextMaintBegin], [NextMaintEnd]) VALUES (3469, 616, N'ZX5382', CAST(N'2008-04-16' AS Date), CAST(N'2009-04-08' AS Date), CAST(N'2009-04-18' AS Date)); INSERT [dbo].[aircraft] ([AircraftID], [AircraftTypeID], [RegNum], [LastMaintEnd], [NextMaintBegin], [NextMaintEnd]) VALUES (3470, 616, N'ZX5173', CAST(N'2008-05-20' AS Date), CAST(N'2009-10-05' AS Date), CAST(N'2009-10-15' AS Date)); INSERT [dbo].[aircraft] ([AircraftID], [AircraftTypeID], [RegNum], [LastMaintEnd], [NextMaintBegin], [NextMaintEnd]) VALUES (3565, 503, N'ZX5830', CAST(N'2008-11-19' AS Date), CAST(N'2009-11-15' AS Date), CAST(N'2009-12-15' AS Date)); SET IDENTITY_INSERT [dbo].[aircraft] OFF; GO SET IDENTITY_INSERT [dbo].[aircrafttype] ON; INSERT [dbo].[aircrafttype] ([AircraftTypeID], [AircraftName]) VALUES (503, N'Boeing 747'); INSERT [dbo].[aircrafttype] ([AircraftTypeID], [AircraftName]) VALUES (504, N'Boeing 767'); INSERT [dbo].[aircrafttype] ([AircraftTypeID], [AircraftName]) VALUES (615, N'Airbus A300/310'); INSERT [dbo].[aircrafttype] ([AircraftTypeID], [AircraftName]) VALUES (616, N'Airbus A330'); INSERT [dbo].[aircrafttype] ([AircraftTypeID], [AircraftName]) VALUES (617, N'Airbus A340'); INSERT [dbo].[aircrafttype] ([AircraftTypeID], [AircraftName]) VALUES (618, N'Airbus A380'); INSERT [dbo].[aircrafttype] ([AircraftTypeID], [AircraftName]) VALUES (619, N'Cessna C60'); INSERT [dbo].[aircrafttype] ([AircraftTypeID], [AircraftName]) VALUES (711, N'Boeing 777'); SET IDENTITY_INSERT [dbo].[aircrafttype] OFF; GO SET IDENTITY_INSERT [dbo].[airport] ON; INSERT [dbo].[airport] ([AirportID], [AirportCode], [AirportName], [CityName], [CountryCode], [NumRunways], [NumTerminals]) VALUES (34, N'ORY', N'Orly Airport', N'Paris', N'FR', 3, 2); INSERT [dbo].[airport] ([AirportID], [AirportCode], [AirportName], [CityName], [CountryCode], [NumRunways], [NumTerminals]) VALUES (48, N'LGW', N'Gatwick Airport', N'London', N'UK', 2, 2); INSERT [dbo].[airport] ([AirportID], [AirportCode], [AirportName], [CityName], [CountryCode], [NumRunways], [NumTerminals]) VALUES (56, N'LHR', N'Heathrow Airport', N'London', N'UK', 2, 5); INSERT [dbo].[airport] ([AirportID], [AirportCode], [AirportName], [CityName], [CountryCode], [NumRunways], [NumTerminals]) VALUES (59, N'CIA', N'Rome Ciampino Airport', N'Rome', N'IT', 1, 1); INSERT [dbo].[airport] ([AirportID], [AirportCode], [AirportName], [CityName], [CountryCode], [NumRunways], [NumTerminals]) VALUES (62, N'AMS', N'Schiphol Airport', N'Amsterdam', N'NL', 6, 1); INSERT [dbo].[airport] ([AirportID], [AirportCode], [AirportName], [CityName], [CountryCode], [NumRunways], [NumTerminals]) VALUES (72, N'BCN', N'Barcelona International Airport', N'Barcelona', N'ES', 3, 3); INSERT [dbo].[airport] ([AirportID], [AirportCode], [AirportName], [CityName], [CountryCode], [NumRunways], [NumTerminals]) VALUES (74, N'MUC', N'Franz Josef Strauss Airport', N'Munich', N'DE', 3, 2); INSERT [dbo].[airport] ([AirportID], [AirportCode], [AirportName], [CityName], [CountryCode], [NumRunways], [NumTerminals]) VALUES (83, N'LIS', N'Lisbon Airport', N'Lisbon', N'PT', 2, 2); INSERT [dbo].[airport] ([AirportID], [AirportCode], [AirportName], [CityName], [CountryCode], [NumRunways], [NumTerminals]) VALUES (87, N'BUD', N'Budapest Ferihegy International Airport', N'Budapest', N'HU', 2, 2); INSERT [dbo].[airport] ([AirportID], [AirportCode], [AirportName], [CityName], [CountryCode], [NumRunways], [NumTerminals]) VALUES (92, N'ZRH', N'Zurich Airport ', N'Zurich', N'CH', 3, 1); INSERT [dbo].[airport] ([AirportID], [AirportCode], [AirportName], [CityName], [CountryCode], [NumRunways], [NumTerminals]) VALUES (126, N'BOM', N'Chhatrapati Shivaji International Airport ', N'Bombay', N'IN', 2, 2); INSERT [dbo].[airport] ([AirportID], [AirportCode], [AirportName], [CityName], [CountryCode], [NumRunways], [NumTerminals]) VALUES (129, N'BRS', N'Bristol International Airport', N'Bristol', N'UK', 1, 1); INSERT [dbo].[airport] ([AirportID], [AirportCode], [AirportName], [CityName], [CountryCode], [NumRunways], [NumTerminals]) VALUES (132, N'MAD', N'Barajas Airport', N'Madrid', N'ES', 4, 4); INSERT [dbo].[airport] ([AirportID], [AirportCode], [AirportName], [CityName], [CountryCode], [NumRunways], [NumTerminals]) VALUES (165, N'NCE', N'Nice Côte d''Azur Airport ', N'Nice', N'FR', 2, 2); INSERT [dbo].[airport] ([AirportID], [AirportCode], [AirportName], [CityName], [CountryCode], [NumRunways], [NumTerminals]) VALUES (201, N'SIN', N'Changi Airport', N'Singapore', N'SG', 3, 3); SET IDENTITY_INSERT [dbo].[airport] OFF; GO SET IDENTITY_INSERT [dbo].[class] ON; INSERT [dbo].[class] ([ClassID], [ClassName]) VALUES (1, N'Platinum'); INSERT [dbo].[class] ([ClassID], [ClassName]) VALUES (2, N'Gold'); INSERT [dbo].[class] ([ClassID], [ClassName]) VALUES (3, N'Silver'); SET IDENTITY_INSERT [dbo].[class] OFF; GO SET IDENTITY_INSERT [dbo].[flight] ON; INSERT [dbo].[flight] ([FlightID], [RouteID], [AircraftID]) VALUES (345, 1003, 3452); INSERT [dbo].[flight] ([FlightID], [RouteID], [AircraftID]) VALUES (535, 1005, 3451); INSERT [dbo].[flight] ([FlightID], [RouteID], [AircraftID]) VALUES (589, 1097, 3467); INSERT [dbo].[flight] ([FlightID], [RouteID], [AircraftID]) VALUES (652, 1018, 3465); INSERT [dbo].[flight] ([FlightID], [RouteID], [AircraftID]) VALUES (662, 1018, 3465); INSERT [dbo].[flight] ([FlightID], [RouteID], [AircraftID]) VALUES (663, 1009, 3427); INSERT [dbo].[flight] ([FlightID], [RouteID], [AircraftID]) VALUES (671, 1169, 3201); INSERT [dbo].[flight] ([FlightID], [RouteID], [AircraftID]) VALUES (672, 1169, 3223); INSERT [dbo].[flight] ([FlightID], [RouteID], [AircraftID]) VALUES (674, 1165, 3427); INSERT [dbo].[flight] ([FlightID], [RouteID], [AircraftID]) VALUES (675, 1023, 3451); INSERT [dbo].[flight] ([FlightID], [RouteID], [AircraftID]) VALUES (681, 1123, 3189); INSERT [dbo].[flight] ([FlightID], [RouteID], [AircraftID]) VALUES (685, 1180, 3470); INSERT [dbo].[flight] ([FlightID], [RouteID], [AircraftID]) VALUES (687, 1191, 3128); INSERT [dbo].[flight] ([FlightID], [RouteID], [AircraftID]) VALUES (688, 1139, 3130); INSERT [dbo].[flight] ([FlightID], [RouteID], [AircraftID]) VALUES (689, 1140, 3130); INSERT [dbo].[flight] ([FlightID], [RouteID], [AircraftID]) VALUES (702, 1008, 3469); INSERT [dbo].[flight] ([FlightID], [RouteID], [AircraftID]) VALUES (708, 1006, 3469); INSERT [dbo].[flight] ([FlightID], [RouteID], [AircraftID]) VALUES (724, 1193, 3125); INSERT [dbo].[flight] ([FlightID], [RouteID], [AircraftID]) VALUES (725, 1192, 3125); INSERT [dbo].[flight] ([FlightID], [RouteID], [AircraftID]) VALUES (765, 1133, 3425); INSERT [dbo].[flight] ([FlightID], [RouteID], [AircraftID]) VALUES (812, 1190, 3565); INSERT [dbo].[flight] ([FlightID], [RouteID], [AircraftID]) VALUES (826, 1209, 3469); INSERT [dbo].[flight] ([FlightID], [RouteID], [AircraftID]) VALUES (833, 1061, 3469); INSERT [dbo].[flight] ([FlightID], [RouteID], [AircraftID]) VALUES (857, 1059, 3565); INSERT [dbo].[flight] ([FlightID], [RouteID], [AircraftID]) VALUES (871, 1173, 3201); INSERT [dbo].[flight] ([FlightID], [RouteID], [AircraftID]) VALUES (872, 1173, 3223); INSERT [dbo].[flight] ([FlightID], [RouteID], [AircraftID]) VALUES (876, 1175, 3467); INSERT [dbo].[flight] ([FlightID], [RouteID], [AircraftID]) VALUES (877, 1176, 3467); INSERT [dbo].[flight] ([FlightID], [RouteID], [AircraftID]) VALUES (896, 1141, 3145); INSERT [dbo].[flight] ([FlightID], [RouteID], [AircraftID]) VALUES (897, 1142, 3145); INSERT [dbo].[flight] ([FlightID], [RouteID], [AircraftID]) VALUES (898, 1141, 3145); INSERT [dbo].[flight] ([FlightID], [RouteID], [AircraftID]) VALUES (899, 1142, 3145); SET IDENTITY_INSERT [dbo].[flight] OFF; GO INSERT [dbo].[flightclass] ([FlightID], [ClassID], [MaxSeats], [BasePrice]) VALUES (535, N'2', 50, 200); INSERT [dbo].[flightclass] ([FlightID], [ClassID], [MaxSeats], [BasePrice]) VALUES (535, N'3', 150, 50); INSERT [dbo].[flightclass] ([FlightID], [ClassID], [MaxSeats], [BasePrice]) VALUES (876, N'2', 85, 250); INSERT [dbo].[flightclass] ([FlightID], [ClassID], [MaxSeats], [BasePrice]) VALUES (876, N'3', 100, 35); INSERT [dbo].[flightclass] ([FlightID], [ClassID], [MaxSeats], [BasePrice]) VALUES (876, N'1', 10, 300); INSERT [dbo].[flightclass] ([FlightID], [ClassID], [MaxSeats], [BasePrice]) VALUES (652, N'2', 10, 200); INSERT [dbo].[flightclass] ([FlightID], [ClassID], [MaxSeats], [BasePrice]) VALUES (652, N'3', 20, 50) GO INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (896, 1, CAST(N'00:30:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (876, 1, CAST(N'07:10:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (675, 1, CAST(N'07:30:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (681, 1, CAST(N'08:15:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (663, 1, CAST(N'09:10:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (871, 1, CAST(N'12:50:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (652, 1, CAST(N'14:10:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (674, 1, CAST(N'14:25:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (812, 1, CAST(N'14:30:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (671, 1, CAST(N'16:55:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (725, 1, CAST(N'17:30:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (857, 1, CAST(N'19:30:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (897, 1, CAST(N'20:15:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (877, 1, CAST(N'20:30:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (345, 1, CAST(N'21:30:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (685, 1, CAST(N'21:45:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (896, 2, CAST(N'00:30:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (765, 2, CAST(N'01:45:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (876, 2, CAST(N'07:10:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (663, 2, CAST(N'09:10:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (1, 2, CAST(N'12:35:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (872, 2, CAST(N'12:50:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (826, 2, CAST(N'13:45:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (652, 2, CAST(N'14:10:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (674, 2, CAST(N'14:25:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (812, 2, CAST(N'14:30:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (535, 2, CAST(N'15:30:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (672, 2, CAST(N'16:55:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (857, 2, CAST(N'19:30:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (687, 2, CAST(N'19:35:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (897, 2, CAST(N'20:15:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (877, 2, CAST(N'20:30:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (345, 2, CAST(N'21:30:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (685, 2, CAST(N'21:45:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (896, 3, CAST(N'00:30:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (833, 3, CAST(N'07:00:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (876, 3, CAST(N'07:10:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (675, 3, CAST(N'07:30:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (663, 3, CAST(N'09:10:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (871, 3, CAST(N'12:50:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (688, 3, CAST(N'13:45:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (652, 3, CAST(N'14:10:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (674, 3, CAST(N'14:25:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (812, 3, CAST(N'14:30:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (671, 3, CAST(N'16:55:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (689, 3, CAST(N'19:00:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (857, 3, CAST(N'19:30:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (687, 3, CAST(N'19:35:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (897, 3, CAST(N'20:15:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (877, 3, CAST(N'20:30:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (345, 3, CAST(N'21:30:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (685, 3, CAST(N'21:45:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (724, 3, CAST(N'23:30:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (898, 4, CAST(N'00:10:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (765, 4, CAST(N'01:45:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (876, 4, CAST(N'07:10:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (663, 4, CAST(N'09:10:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (872, 4, CAST(N'12:50:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (688, 4, CAST(N'13:45:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (652, 4, CAST(N'14:10:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (674, 4, CAST(N'14:25:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (812, 4, CAST(N'14:30:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (535, 4, CAST(N'15:30:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (672, 4, CAST(N'16:55:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (725, 4, CAST(N'17:30:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (689, 4, CAST(N'19:00:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (857, 4, CAST(N'19:30:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (687, 4, CAST(N'19:35:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (877, 4, CAST(N'20:30:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (899, 4, CAST(N'21:15:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (345, 4, CAST(N'21:30:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (898, 5, CAST(N'00:10:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (876, 5, CAST(N'07:10:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (675, 5, CAST(N'07:30:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (663, 5, CAST(N'09:10:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (702, 5, CAST(N'09:30:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (708, 5, CAST(N'12:45:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (871, 5, CAST(N'12:50:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (688, 5, CAST(N'13:45:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (652, 5, CAST(N'14:10:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (812, 5, CAST(N'14:30:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (671, 5, CAST(N'16:55:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (689, 5, CAST(N'19:00:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (857, 5, CAST(N'19:30:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (877, 5, CAST(N'20:30:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (899, 5, CAST(N'21:15:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (345, 5, CAST(N'21:30:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (896, 6, CAST(N'00:30:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (765, 6, CAST(N'01:45:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (702, 6, CAST(N'09:30:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (708, 6, CAST(N'12:45:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (872, 6, CAST(N'12:50:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (688, 6, CAST(N'13:45:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (672, 6, CAST(N'16:55:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (662, 6, CAST(N'17:45:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (689, 6, CAST(N'19:00:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (589, 6, CAST(N'20:05:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (897, 6, CAST(N'20:15:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (345, 6, CAST(N'21:30:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (896, 7, CAST(N'00:30:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (702, 7, CAST(N'09:30:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (708, 7, CAST(N'12:45:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (872, 7, CAST(N'12:50:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (672, 7, CAST(N'16:55:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (662, 7, CAST(N'17:45:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (589, 7, CAST(N'20:05:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (897, 7, CAST(N'20:15:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (345, 7, CAST(N'21:30:00' AS Time)); INSERT [dbo].[flightdep] ([FlightID], [DepDay], [DepTime]) VALUES (724, 7, CAST(N'23:30:00' AS Time)) GO SET IDENTITY_INSERT [dbo].[pax] ON; INSERT [dbo].[pax] ([RecordID], [FlightID], [FlightDate], [ClassID], [PaxName], [PaxRef], [Note]) VALUES (197, 652, CAST(N'2009-01-20' AS Date), 2, N'Henry Rabbit', N'TG75850303', N''); INSERT [dbo].[pax] ([RecordID], [FlightID], [FlightDate], [ClassID], [PaxName], [PaxRef], [Note]) VALUES (198, 652, CAST(N'2009-01-20' AS Date), 3, N'Harry Hippo', N'TG75847493', N''); INSERT [dbo].[pax] ([RecordID], [FlightID], [FlightDate], [ClassID], [PaxName], [PaxRef], [Note]) VALUES (199, 652, CAST(N'2009-01-20' AS Date), 3, N'Henrietta Hippo', N'TG75847493', N''); SET IDENTITY_INSERT [dbo].[pax] OFF; GO SET IDENTITY_INSERT [dbo].[route] ON; INSERT [dbo].[route] ([RouteID], [From], [To], [Distance], [Duration], [Status]) VALUES (1003, 126, 56, 7200, 550, 1); INSERT [dbo].[route] ([RouteID], [From], [To], [Distance], [Duration], [Status]) VALUES (1005, 34, 48, 343, 85, 1); INSERT [dbo].[route] ([RouteID], [From], [To], [Distance], [Duration], [Status]) VALUES (1006, 165, 132, 974, 125, 1); INSERT [dbo].[route] ([RouteID], [From], [To], [Distance], [Duration], [Status]) VALUES (1008, 34, 165, 686, 60, 1); INSERT [dbo].[route] ([RouteID], [From], [To], [Distance], [Duration], [Status]) VALUES (1009, 34, 92, 489, 70, 1); INSERT [dbo].[route] ([RouteID], [From], [To], [Distance], [Duration], [Status]) VALUES (1018, 34, 87, 1248, 135, 1); INSERT [dbo].[route] ([RouteID], [From], [To], [Distance], [Duration], [Status]) VALUES (1023, 48, 59, 1434, 150, 1); INSERT [dbo].[route] ([RouteID], [From], [To], [Distance], [Duration], [Status]) VALUES (1059, 165, 62, 978, 130, 1); INSERT [dbo].[route] ([RouteID], [From], [To], [Distance], [Duration], [Status]) VALUES (1061, 48, 87, 1452, 155, 1); INSERT [dbo].[route] ([RouteID], [From], [To], [Distance], [Duration], [Status]) VALUES (1071, 132, 72, 505, 65, 0); INSERT [dbo].[route] ([RouteID], [From], [To], [Distance], [Duration], [Status]) VALUES (1097, 129, 165, 1134, 120, 1); INSERT [dbo].[route] ([RouteID], [From], [To], [Distance], [Duration], [Status]) VALUES (1123, 92, 48, 777, 60, 1); INSERT [dbo].[route] ([RouteID], [From], [To], [Distance], [Duration], [Status]) VALUES (1133, 74, 126, 6336, 470, 1); INSERT [dbo].[route] ([RouteID], [From], [To], [Distance], [Duration], [Status]) VALUES (1139, 83, 87, 2474, 150, 1); INSERT [dbo].[route] ([RouteID], [From], [To], [Distance], [Duration], [Status]) VALUES (1140, 87, 83, 2474, 150, 1); INSERT [dbo].[route] ([RouteID], [From], [To], [Distance], [Duration], [Status]) VALUES (1141, 126, 201, 3913, 320, 1); INSERT [dbo].[route] ([RouteID], [From], [To], [Distance], [Duration], [Status]) VALUES (1142, 201, 126, 3915, 320, 1); INSERT [dbo].[route] ([RouteID], [From], [To], [Distance], [Duration], [Status]) VALUES (1165, 92, 59, 683, 50, 1); INSERT [dbo].[route] ([RouteID], [From], [To], [Distance], [Duration], [Status]) VALUES (1167, 92, 56, 777, 70, 0); INSERT [dbo].[route] ([RouteID], [From], [To], [Distance], [Duration], [Status]) VALUES (1169, 62, 92, 612, 120, 1); INSERT [dbo].[route] ([RouteID], [From], [To], [Distance], [Duration], [Status]) VALUES (1173, 72, 62, 1237, 130, 1); INSERT [dbo].[route] ([RouteID], [From], [To], [Distance], [Duration], [Status]) VALUES (1175, 132, 56, 1267, 150, 1); INSERT [dbo].[route] ([RouteID], [From], [To], [Distance], [Duration], [Status]) VALUES (1176, 56, 132, 1267, 150, 1); INSERT [dbo].[route] ([RouteID], [From], [To], [Distance], [Duration], [Status]) VALUES (1180, 201, 56, 10863, 815, 1); INSERT [dbo].[route] ([RouteID], [From], [To], [Distance], [Duration], [Status]) VALUES (1190, 72, 165, 488, 80, 1); INSERT [dbo].[route] ([RouteID], [From], [To], [Distance], [Duration], [Status]) VALUES (1191, 74, 83, 1966, 190, 1); INSERT [dbo].[route] ([RouteID], [From], [To], [Distance], [Duration], [Status]) VALUES (1192, 92, 201, 10310, 760, 0); INSERT [dbo].[route] ([RouteID], [From], [To], [Distance], [Duration], [Status]) VALUES (1193, 201, 92, 10310, 760, 1); INSERT [dbo].[route] ([RouteID], [From], [To], [Distance], [Duration], [Status]) VALUES (1209, 56, 59, 1434, 150, 1); SET IDENTITY_INSERT [dbo].[route] OFF; GO INSERT [dbo].[stats] ([FlightID], [FlightDate], [ClassID], [CurrSeats], [CurrPrice]) VALUES (652, CAST(N'2009-01-20' AS Date), 2, 9, 200); INSERT [dbo].[stats] ([FlightID], [FlightDate], [ClassID], [CurrSeats], [CurrPrice]) VALUES (652, CAST(N'2009-01-20' AS Date), 3, 17, 50); INSERT [dbo].[stats] ([FlightID], [FlightDate], [ClassID], [CurrSeats], [CurrPrice]) VALUES (876, CAST(N'2009-04-01' AS Date), 1, 10, 300); INSERT [dbo].[stats] ([FlightID], [FlightDate], [ClassID], [CurrSeats], [CurrPrice]) VALUES (876, CAST(N'2009-04-01' AS Date), 2, 85, 250); INSERT [dbo].[stats] ([FlightID], [FlightDate], [ClassID], [CurrSeats], [CurrPrice]) VALUES (876, CAST(N'2009-04-01' AS Date), 3, 100, 35); INSERT [dbo].[stats] ([FlightID], [FlightDate], [ClassID], [CurrSeats], [CurrPrice]) VALUES (876, CAST(N'2009-04-08' AS Date), 1, 3, 300); INSERT [dbo].[stats] ([FlightID], [FlightDate], [ClassID], [CurrSeats], [CurrPrice]) VALUES (876, CAST(N'2009-04-08' AS Date), 2, 3, 250); INSERT [dbo].[stats] ([FlightID], [FlightDate], [ClassID], [CurrSeats], [CurrPrice]) VALUES (876, CAST(N'2009-04-08' AS Date), 3, 3, 35) GO

MySQL Schema

-- SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -------------------------------------------------------- -- -- Database: `db1` -- -- DROP DATABASE db1; CREATE DATABASE db1; USE db1; -- -------------------------------------------------------- -- -- Table structure for table `aircraft` -- DROP TABLE IF EXISTS `aircraft`; CREATE TABLE `aircraft` ( `AircraftID` smallint(4) unsigned NOT NULL AUTO_INCREMENT, `AircraftTypeID` smallint(4) unsigned NOT NULL, `RegNum` char(6) NOT NULL, `LastMaintEnd` date NOT NULL, `NextMaintBegin` date NOT NULL, `NextMaintEnd` date NOT NULL, PRIMARY KEY (`AircraftID`), UNIQUE KEY `RegNum` (`RegNum`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `aircraft` -- INSERT INTO `aircraft` (`AircraftID`, `AircraftTypeID`, `RegNum`, `LastMaintEnd`, `NextMaintBegin`, `NextMaintEnd`) VALUES(3451, 503, 'ZX6488', '2007-10-01', '2008-10-23', '2008-10-31'); INSERT INTO `aircraft` (`AircraftID`, `AircraftTypeID`, `RegNum`, `LastMaintEnd`, `NextMaintBegin`, `NextMaintEnd`) VALUES(3465, 503, 'ZX5373', '0000-00-00', '2008-10-14', '2008-10-21'); INSERT INTO `aircraft` (`AircraftID`, `AircraftTypeID`, `RegNum`, `LastMaintEnd`, `NextMaintBegin`, `NextMaintEnd`) VALUES(3467, 616, 'ZX7283', '2008-02-05', '2008-12-02', '2008-10-09'); INSERT INTO `aircraft` (`AircraftID`, `AircraftTypeID`, `RegNum`, `LastMaintEnd`, `NextMaintBegin`, `NextMaintEnd`) VALUES(3452, 617, 'ZX5464', '2006-10-04', '2009-01-03', '2009-01-21'); INSERT INTO `aircraft` (`AircraftID`, `AircraftTypeID`, `RegNum`, `LastMaintEnd`, `NextMaintBegin`, `NextMaintEnd`) VALUES(3469, 616, 'ZX5382', '2008-04-16', '2009-04-08', '2009-04-18'); INSERT INTO `aircraft` (`AircraftID`, `AircraftTypeID`, `RegNum`, `LastMaintEnd`, `NextMaintBegin`, `NextMaintEnd`) VALUES(3145, 503, 'ZX5731', '2008-04-17', '2009-12-20', '2009-12-30'); INSERT INTO `aircraft` (`AircraftID`, `AircraftTypeID`, `RegNum`, `LastMaintEnd`, `NextMaintBegin`, `NextMaintEnd`) VALUES(3425, 504, 'ZX6821', '2008-06-22', '2009-05-25', '2009-06-04'); INSERT INTO `aircraft` (`AircraftID`, `AircraftTypeID`, `RegNum`, `LastMaintEnd`, `NextMaintBegin`, `NextMaintEnd`) VALUES(3427, 616, 'ZX5921', '2008-10-01', '2010-03-02', '2010-04-02'); INSERT INTO `aircraft` (`AircraftID`, `AircraftTypeID`, `RegNum`, `LastMaintEnd`, `NextMaintBegin`, `NextMaintEnd`) VALUES(3189, 616, 'ZX582', '2008-08-07', '2008-11-05', '2008-11-12'); INSERT INTO `aircraft` (`AircraftID`, `AircraftTypeID`, `RegNum`, `LastMaintEnd`, `NextMaintBegin`, `NextMaintEnd`) VALUES(3470, 616, 'ZX5173', '2008-05-20', '2009-10-05', '2009-10-15'); INSERT INTO `aircraft` (`AircraftID`, `AircraftTypeID`, `RegNum`, `LastMaintEnd`, `NextMaintBegin`, `NextMaintEnd`) VALUES(3125, 617, 'ZX1386', '2007-12-12', '2009-02-01', '2009-02-22'); INSERT INTO `aircraft` (`AircraftID`, `AircraftTypeID`, `RegNum`, `LastMaintEnd`, `NextMaintBegin`, `NextMaintEnd`) VALUES(3128, 617, 'ZX7634', '2008-03-07', '2009-05-07', '2009-05-18'); INSERT INTO `aircraft` (`AircraftID`, `AircraftTypeID`, `RegNum`, `LastMaintEnd`, `NextMaintBegin`, `NextMaintEnd`) VALUES(3565, 503, 'ZX5830', '2008-11-19', '2009-11-15', '2009-12-15'); INSERT INTO `aircraft` (`AircraftID`, `AircraftTypeID`, `RegNum`, `LastMaintEnd`, `NextMaintBegin`, `NextMaintEnd`) VALUES(3201, 617, 'ZX7472', '2008-10-15', '2009-10-15', '2009-10-27'); INSERT INTO `aircraft` (`AircraftID`, `AircraftTypeID`, `RegNum`, `LastMaintEnd`, `NextMaintBegin`, `NextMaintEnd`) VALUES(3223, 618, 'ZX1037', '2008-12-06', '2009-09-16', '2009-09-30'); INSERT INTO `aircraft` (`AircraftID`, `AircraftTypeID`, `RegNum`, `LastMaintEnd`, `NextMaintBegin`, `NextMaintEnd`) VALUES(3130, 616, 'ZX7391', '2008-09-15', '2009-04-15', '2009-05-15'); -- -------------------------------------------------------- -- -- Table structure for table `aircrafttype` -- DROP TABLE IF EXISTS `aircrafttype`; CREATE TABLE `aircrafttype` ( `AircraftTypeID` smallint(4) unsigned NOT NULL AUTO_INCREMENT, `AircraftName` varchar(255) NOT NULL, PRIMARY KEY (`AircraftTypeID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `aircrafttype` -- INSERT INTO `aircrafttype` (`AircraftTypeID`, `AircraftName`) VALUES(503, 'Boeing 747'); INSERT INTO `aircrafttype` (`AircraftTypeID`, `AircraftName`) VALUES(504, 'Boeing 767'); INSERT INTO `aircrafttype` (`AircraftTypeID`, `AircraftName`) VALUES(615, 'Airbus A300/310'); INSERT INTO `aircrafttype` (`AircraftTypeID`, `AircraftName`) VALUES(616, 'Airbus A330'); INSERT INTO `aircrafttype` (`AircraftTypeID`, `AircraftName`) VALUES(617, 'Airbus A340'); INSERT INTO `aircrafttype` (`AircraftTypeID`, `AircraftName`) VALUES(618, 'Airbus A380'); -- -------------------------------------------------------- -- -- Table structure for table `airport` -- DROP TABLE IF EXISTS `airport`; CREATE TABLE `airport` ( `AirportID` smallint(5) unsigned NOT NULL, `AirportCode` char(3) NOT NULL, `AirportName` varchar(255) NOT NULL, `CityName` varchar(255) NOT NULL, `CountryCode` char(2) NOT NULL, `NumRunways` tinyint(1) unsigned NOT NULL, `NumTerminals` tinyint(1) unsigned NOT NULL, PRIMARY KEY (`AirportID`), UNIQUE KEY `AirportCode_2` (`AirportCode`), KEY `AirportCode` (`AirportCode`), KEY `CountryCode` (`CountryCode`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `airport` -- INSERT INTO `airport` (`AirportID`, `AirportCode`, `AirportName`, `CityName`, `CountryCode`, `NumRunways`, `NumTerminals`) VALUES(34, 'ORY', 'Orly Airport', 'Paris', 'FR', 3, 2); INSERT INTO `airport` (`AirportID`, `AirportCode`, `AirportName`, `CityName`, `CountryCode`, `NumRunways`, `NumTerminals`) VALUES(48, 'LGW', 'Gatwick Airport', 'London', 'UK', 2, 2); INSERT INTO `airport` (`AirportID`, `AirportCode`, `AirportName`, `CityName`, `CountryCode`, `NumRunways`, `NumTerminals`) VALUES(56, 'LHR', 'Heathrow Airport', 'London', 'UK', 2, 5); INSERT INTO `airport` (`AirportID`, `AirportCode`, `AirportName`, `CityName`, `CountryCode`, `NumRunways`, `NumTerminals`) VALUES(59, 'CIA', 'Rome Ciampino Airport', 'Rome', 'IT', 1, 1); INSERT INTO `airport` (`AirportID`, `AirportCode`, `AirportName`, `CityName`, `CountryCode`, `NumRunways`, `NumTerminals`) VALUES(62, 'AMS', 'Schiphol Airport', 'Amsterdam', 'NL', 6, 1); INSERT INTO `airport` (`AirportID`, `AirportCode`, `AirportName`, `CityName`, `CountryCode`, `NumRunways`, `NumTerminals`) VALUES(72, 'BCN', 'Barcelona International Airport', 'Barcelona', 'ES', 3, 3); INSERT INTO `airport` (`AirportID`, `AirportCode`, `AirportName`, `CityName`, `CountryCode`, `NumRunways`, `NumTerminals`) VALUES(74, 'MUC', 'Franz Josef Strauss Airport', 'Munich', 'DE', 3, 2); INSERT INTO `airport` (`AirportID`, `AirportCode`, `AirportName`, `CityName`, `CountryCode`, `NumRunways`, `NumTerminals`) VALUES(83, 'LIS', 'Lisbon Airport', 'Lisbon', 'PT', 2, 2); INSERT INTO `airport` (`AirportID`, `AirportCode`, `AirportName`, `CityName`, `CountryCode`, `NumRunways`, `NumTerminals`) VALUES(87, 'BUD', 'Budapest Ferihegy International Airport', 'Budapest', 'HU', 2, 2); INSERT INTO `airport` (`AirportID`, `AirportCode`, `AirportName`, `CityName`, `CountryCode`, `NumRunways`, `NumTerminals`) VALUES(92, 'ZRH', 'Zurich Airport ', 'Zurich', 'CH', 3, 1); INSERT INTO `airport` (`AirportID`, `AirportCode`, `AirportName`, `CityName`, `CountryCode`, `NumRunways`, `NumTerminals`) VALUES(126, 'BOM', 'Chhatrapati Shivaji International Airport ', 'Bombay', 'IN', 2, 2); INSERT INTO `airport` (`AirportID`, `AirportCode`, `AirportName`, `CityName`, `CountryCode`, `NumRunways`, `NumTerminals`) VALUES(129, 'BRS', 'Bristol International Airport', 'Bristol', 'UK', 1, 1); INSERT INTO `airport` (`AirportID`, `AirportCode`, `AirportName`, `CityName`, `CountryCode`, `NumRunways`, `NumTerminals`) VALUES(132, 'MAD', 'Barajas Airport', 'Madrid', 'ES', 4, 4); INSERT INTO `airport` (`AirportID`, `AirportCode`, `AirportName`, `CityName`, `CountryCode`, `NumRunways`, `NumTerminals`) VALUES(165, 'NCE', 'Nice Côte d''Azur Airport ', 'Nice', 'FR', 2, 2); INSERT INTO `airport` (`AirportID`, `AirportCode`, `AirportName`, `CityName`, `CountryCode`, `NumRunways`, `NumTerminals`) VALUES(201, 'SIN', 'Changi Airport', 'Singapore', 'SG', 3, 3); -- -------------------------------------------------------- -- -- Table structure for table `class` -- DROP TABLE IF EXISTS `class`; CREATE TABLE `class` ( `ClassID` int(11) NOT NULL AUTO_INCREMENT, `ClassName` varchar(25) NOT NULL, PRIMARY KEY (`ClassID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `class` -- INSERT INTO `class` (`ClassID`, `ClassName`) VALUES(1, 'Platinum'); INSERT INTO `class` (`ClassID`, `ClassName`) VALUES(2, 'Gold'); INSERT INTO `class` (`ClassID`, `ClassName`) VALUES(3, 'Silver'); -- -------------------------------------------------------- -- -- Table structure for table `flight` -- DROP TABLE IF EXISTS `flight`; CREATE TABLE `flight` ( `FlightID` smallint(4) unsigned NOT NULL AUTO_INCREMENT, `RouteID` smallint(4) unsigned NOT NULL, `AircraftID` smallint(4) unsigned NOT NULL, PRIMARY KEY (`FlightID`), KEY `AircraftID` (`AircraftID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `flight` -- INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) VALUES(345, 1003, 3452); INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) VALUES(535, 1005, 3451); INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) VALUES(589, 1097, 3467); INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) VALUES(652, 1018, 3465); INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) VALUES(662, 1018, 3465); INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) VALUES(663, 1009, 3427); INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) VALUES(671, 1169, 3201); INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) VALUES(672, 1169, 3223); INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) VALUES(674, 1165, 3427); INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) VALUES(675, 1023, 3451); INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) VALUES(681, 1123, 3189); INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) VALUES(685, 1180, 3470); INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) VALUES(687, 1191, 3128); INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) VALUES(688, 1139, 3130); INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) VALUES(689, 1140, 3130); INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) VALUES(702, 1008, 3469); INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) VALUES(708, 1006, 3469); INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) VALUES(724, 1193, 3125); INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) VALUES(725, 1192, 3125); INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) VALUES(765, 1133, 3425); INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) VALUES(812, 1190, 3565); INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) VALUES(826, 1209, 3469); INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) VALUES(833, 1061, 3469); INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) VALUES(857, 1059, 3565); INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) VALUES(871, 1173, 3201); INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) VALUES(872, 1173, 3223); INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) VALUES(876, 1175, 3467); INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) VALUES(877, 1176, 3467); INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) VALUES(896, 1141, 3145); INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) VALUES(897, 1142, 3145); INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) VALUES(898, 1141, 3145); INSERT INTO `flight` (`FlightID`, `RouteID`, `AircraftID`) VALUES(899, 1142, 3145); -- -------------------------------------------------------- -- -- Table structure for table `flightclass` -- DROP TABLE IF EXISTS `flightclass`; CREATE TABLE `flightclass` ( `FlightID` smallint(6) NOT NULL, `ClassID` char(1) NOT NULL, `MaxSeats` smallint(6) NOT NULL, `BasePrice` int(11) NOT NULL, KEY `ClassID` (`ClassID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `flightclass` -- INSERT INTO `flightclass` (`FlightID`, `ClassID`, `MaxSeats`, `BasePrice`) VALUES(535, '2', 50, 200); INSERT INTO `flightclass` (`FlightID`, `ClassID`, `MaxSeats`, `BasePrice`) VALUES(535, '3', 150, 50); INSERT INTO `flightclass` (`FlightID`, `ClassID`, `MaxSeats`, `BasePrice`) VALUES(876, '2', 85, 250); INSERT INTO `flightclass` (`FlightID`, `ClassID`, `MaxSeats`, `BasePrice`) VALUES(876, '3', 100, 35); INSERT INTO `flightclass` (`FlightID`, `ClassID`, `MaxSeats`, `BasePrice`) VALUES(876, '1', 10, 300); INSERT INTO `flightclass` (`FlightID`, `ClassID`, `MaxSeats`, `BasePrice`) VALUES(652, '2', 10, 200); INSERT INTO `flightclass` (`FlightID`, `ClassID`, `MaxSeats`, `BasePrice`) VALUES(652, '3', 20, 50); -- -------------------------------------------------------- -- -- Table structure for table `flightdep` -- DROP TABLE IF EXISTS `flightdep`; CREATE TABLE `flightdep` ( `FlightID` smallint(6) NOT NULL, `DepDay` tinyint(4) NOT NULL, `DepTime` time NOT NULL, PRIMARY KEY (`FlightID`,`DepDay`,`DepTime`), KEY `DepDay` (`DepDay`,`DepTime`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `flightdep` -- INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(345, 1, '21:30:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(345, 2, '21:30:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(345, 3, '21:30:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(345, 4, '21:30:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(345, 5, '21:30:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(345, 6, '21:30:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(345, 7, '21:30:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(535, 2, '15:30:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(535, 4, '15:30:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(589, 6, '20:05:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(589, 7, '20:05:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(652, 1, '14:10:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(652, 2, '14:10:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(652, 3, '14:10:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(652, 4, '14:10:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(652, 5, '14:10:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(662, 6, '17:45:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(662, 7, '17:45:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(663, 1, '09:10:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(663, 2, '09:10:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(663, 3, '09:10:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(663, 4, '09:10:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(663, 5, '09:10:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(671, 1, '16:55:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(671, 3, '16:55:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(671, 5, '16:55:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(672, 2, '16:55:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(672, 4, '16:55:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(672, 6, '16:55:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(672, 7, '16:55:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(674, 1, '14:25:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(674, 2, '14:25:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(674, 3, '14:25:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(674, 4, '14:25:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(675, 1, '07:30:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(675, 3, '07:30:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(675, 5, '07:30:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(681, 1, '08:15:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(685, 1, '21:45:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(685, 2, '21:45:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(685, 3, '21:45:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(687, 2, '19:35:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(687, 3, '19:35:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(687, 4, '19:35:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(688, 3, '13:45:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(688, 4, '13:45:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(688, 5, '13:45:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(688, 6, '13:45:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(689, 3, '19:00:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(689, 4, '19:00:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(689, 5, '19:00:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(689, 6, '19:00:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(702, 5, '09:30:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(702, 6, '09:30:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(702, 7, '09:30:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(708, 5, '12:45:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(708, 6, '12:45:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(708, 7, '12:45:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(724, 3, '23:30:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(724, 7, '23:30:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(725, 1, '17:30:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(725, 4, '17:30:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(765, 2, '01:45:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(765, 4, '01:45:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(765, 6, '01:45:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(812, 1, '14:30:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(812, 2, '14:30:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(812, 3, '14:30:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(812, 4, '14:30:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(812, 5, '14:30:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(826, 2, '13:45:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(833, 3, '07:00:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(857, 1, '19:30:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(857, 2, '19:30:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(857, 3, '19:30:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(857, 4, '19:30:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(857, 5, '19:30:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(871, 1, '12:50:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(871, 3, '12:50:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(871, 5, '12:50:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(872, 2, '12:50:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(872, 4, '12:50:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(872, 6, '12:50:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(872, 7, '12:50:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(876, 1, '07:10:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(876, 2, '07:10:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(876, 3, '07:10:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(876, 4, '07:10:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(876, 5, '07:10:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(877, 1, '20:30:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(877, 2, '20:30:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(877, 3, '20:30:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(877, 4, '20:30:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(877, 5, '20:30:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(896, 1, '00:30:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(896, 2, '00:30:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(896, 3, '00:30:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(896, 6, '00:30:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(896, 7, '00:30:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(897, 1, '20:15:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(897, 2, '20:15:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(897, 3, '20:15:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(897, 6, '20:15:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(897, 7, '20:15:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(898, 4, '00:10:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(898, 5, '00:10:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(899, 4, '21:15:00'); INSERT INTO `flightdep` (`FlightID`, `DepDay`, `DepTime`) VALUES(899, 5, '21:15:00'); -- -------------------------------------------------------- -- -- Table structure for table `log` -- DROP TABLE IF EXISTS `log`; CREATE TABLE `log` ( `RecordID` int(11) NOT NULL AUTO_INCREMENT, `ByUser` varchar(50) NOT NULL, `Note` text NOT NULL, `EventTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`RecordID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `log` -- -- -------------------------------------------------------- -- -- Table structure for table `pax` -- DROP TABLE IF EXISTS `pax`; CREATE TABLE `pax` ( `RecordID` int(11) unsigned NOT NULL AUTO_INCREMENT, `FlightID` int(11) NOT NULL, `FlightDate` date NOT NULL, `ClassID` int(11) NOT NULL, `PaxName` varchar(255) NOT NULL, `PaxRef` varchar(255) DEFAULT NULL, `Note` text, PRIMARY KEY (`RecordID`), KEY `ClassID` (`ClassID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `pax` -- INSERT INTO `pax` (`RecordID`, `FlightID`, `FlightDate`, `ClassID`, `PaxName`, `PaxRef`, `Note`) VALUES(197, 652, '2009-01-20', 2, 'Henry Rabbit', 'TG75850303', ''); INSERT INTO `pax` (`RecordID`, `FlightID`, `FlightDate`, `ClassID`, `PaxName`, `PaxRef`, `Note`) VALUES(198, 652, '2009-01-20', 3, 'Harry Hippo', 'TG75847493', ''); INSERT INTO `pax` (`RecordID`, `FlightID`, `FlightDate`, `ClassID`, `PaxName`, `PaxRef`, `Note`) VALUES(199, 652, '2009-01-20', 3, 'Henrietta Hippo', 'TG75847493', ''); -- -------------------------------------------------------- -- -- Table structure for table `route` -- DROP TABLE IF EXISTS `route`; CREATE TABLE `route` ( `RouteID` smallint(4) unsigned NOT NULL AUTO_INCREMENT, `From` smallint(4) unsigned NOT NULL, `To` smallint(4) unsigned NOT NULL, `Distance` smallint(4) unsigned NOT NULL, `Duration` smallint(4) unsigned NOT NULL, `Status` tinyint(1) NOT NULL, PRIMARY KEY (`RouteID`), KEY `Duration` (`Duration`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `route` -- INSERT INTO `route` (`RouteID`, `From`, `To`, `Distance`, `Duration`, `Status`) VALUES(1003, 126, 56, 7200, 550, 1); INSERT INTO `route` (`RouteID`, `From`, `To`, `Distance`, `Duration`, `Status`) VALUES(1005, 34, 48, 343, 85, 1); INSERT INTO `route` (`RouteID`, `From`, `To`, `Distance`, `Duration`, `Status`) VALUES(1176, 56, 132, 1267, 150, 1); INSERT INTO `route` (`RouteID`, `From`, `To`, `Distance`, `Duration`, `Status`) VALUES(1175, 132, 56, 1267, 150, 1); INSERT INTO `route` (`RouteID`, `From`, `To`, `Distance`, `Duration`, `Status`) VALUES(1018, 34, 87, 1248, 135, 1); INSERT INTO `route` (`RouteID`, `From`, `To`, `Distance`, `Duration`, `Status`) VALUES(1023, 48, 59, 1434, 150, 1); INSERT INTO `route` (`RouteID`, `From`, `To`, `Distance`, `Duration`, `Status`) VALUES(1008, 34, 165, 686, 60, 1); INSERT INTO `route` (`RouteID`, `From`, `To`, `Distance`, `Duration`, `Status`) VALUES(1009, 34, 92, 489, 70, 1); INSERT INTO `route` (`RouteID`, `From`, `To`, `Distance`, `Duration`, `Status`) VALUES(1165, 92, 59, 683, 50, 1); INSERT INTO `route` (`RouteID`, `From`, `To`, `Distance`, `Duration`, `Status`) VALUES(1167, 92, 56, 777, 70, 0); INSERT INTO `route` (`RouteID`, `From`, `To`, `Distance`, `Duration`, `Status`) VALUES(1123, 92, 48, 777, 60, 1); INSERT INTO `route` (`RouteID`, `From`, `To`, `Distance`, `Duration`, `Status`) VALUES(1133, 74, 126, 6336, 470, 1); INSERT INTO `route` (`RouteID`, `From`, `To`, `Distance`, `Duration`, `Status`) VALUES(1141, 126, 201, 3913, 320, 1); INSERT INTO `route` (`RouteID`, `From`, `To`, `Distance`, `Duration`, `Status`) VALUES(1142, 201, 126, 3915, 320, 1); INSERT INTO `route` (`RouteID`, `From`, `To`, `Distance`, `Duration`, `Status`) VALUES(1180, 201, 56, 10863, 815, 1); INSERT INTO `route` (`RouteID`, `From`, `To`, `Distance`, `Duration`, `Status`) VALUES(1193, 201, 92, 10310, 760, 1); INSERT INTO `route` (`RouteID`, `From`, `To`, `Distance`, `Duration`, `Status`) VALUES(1191, 74, 83, 1966, 190, 1); INSERT INTO `route` (`RouteID`, `From`, `To`, `Distance`, `Duration`, `Status`) VALUES(1071, 132, 72, 505, 65, 0); INSERT INTO `route` (`RouteID`, `From`, `To`, `Distance`, `Duration`, `Status`) VALUES(1190, 72, 165, 488, 80, 1); INSERT INTO `route` (`RouteID`, `From`, `To`, `Distance`, `Duration`, `Status`) VALUES(1173, 72, 62, 1237, 130, 1); INSERT INTO `route` (`RouteID`, `From`, `To`, `Distance`, `Duration`, `Status`) VALUES(1169, 62, 92, 612, 120, 1); INSERT INTO `route` (`RouteID`, `From`, `To`, `Distance`, `Duration`, `Status`) VALUES(1139, 83, 87, 2474, 150, 1); INSERT INTO `route` (`RouteID`, `From`, `To`, `Distance`, `Duration`, `Status`) VALUES(1140, 87, 83, 2474, 150, 1); INSERT INTO `route` (`RouteID`, `From`, `To`, `Distance`, `Duration`, `Status`) VALUES(1097, 129, 165, 1134, 120, 1); INSERT INTO `route` (`RouteID`, `From`, `To`, `Distance`, `Duration`, `Status`) VALUES(1209, 56, 59, 1434, 150, 1); INSERT INTO `route` (`RouteID`, `From`, `To`, `Distance`, `Duration`, `Status`) VALUES(1006, 165, 132, 974, 125, 1); INSERT INTO `route` (`RouteID`, `From`, `To`, `Distance`, `Duration`, `Status`) VALUES(1059, 165, 62, 978, 130, 1); INSERT INTO `route` (`RouteID`, `From`, `To`, `Distance`, `Duration`, `Status`) VALUES(1061, 48, 87, 1452, 155, 1); INSERT INTO `route` (`RouteID`, `From`, `To`, `Distance`, `Duration`, `Status`) VALUES(1192, 92, 201, 10310, 760, 0); -- -------------------------------------------------------- -- -- Table structure for table `stats` -- DROP TABLE IF EXISTS `stats`; CREATE TABLE `stats` ( `FlightID` int(11) NOT NULL, `FlightDate` date NOT NULL, `ClassID` int(11) NOT NULL, `CurrSeats` int(11) NOT NULL, `CurrPrice` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `stats` -- INSERT INTO `stats` (`FlightID`, `FlightDate`, `ClassID`, `CurrSeats`, `CurrPrice`) VALUES(652, '2009-01-20', 2, 9, 200); INSERT INTO `stats` (`FlightID`, `FlightDate`, `ClassID`, `CurrSeats`, `CurrPrice`) VALUES(652, '2009-01-20', 3, 17, 50); INSERT INTO `stats` (`FlightID`, `FlightDate`, `ClassID`, `CurrSeats`, `CurrPrice`) VALUES(876, '2009-04-01', 1, 10, 300); INSERT INTO `stats` (`FlightID`, `FlightDate`, `ClassID`, `CurrSeats`, `CurrPrice`) VALUES(876, '2009-04-01', 2, 85, 250); INSERT INTO `stats` (`FlightID`, `FlightDate`, `ClassID`, `CurrSeats`, `CurrPrice`) VALUES(876, '2009-04-01', 3, 100, 35); INSERT INTO `stats` (`FlightID`, `FlightDate`, `ClassID`, `CurrSeats`, `CurrPrice`) VALUES(876, '2009-04-08', 1, 3, 300); INSERT INTO `stats` (`FlightID`, `FlightDate`, `ClassID`, `CurrSeats`, `CurrPrice`) VALUES(876, '2009-04-08', 2, 3, 250); INSERT INTO `stats` (`FlightID`, `FlightDate`, `ClassID`, `CurrSeats`, `CurrPrice`) VALUES(876, '2009-04-08', 3, 3, 35);