-- phpMyAdmin SQL Dump
-- version 2.6.1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Mar 23, 2005 at 02:09 AM
-- Server version: 4.1.9
-- PHP Version: 4.3.10
-- 
-- Database: `whitg15`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `nw_aircraft`
-- 

CREATE TABLE `nw_aircraft` (
  `type` varchar(10) default NULL,
  `maxseats` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `nw_aircraft`
-- 

INSERT INTO `nw_aircraft` VALUES ('DC12', 120);
INSERT INTO `nw_aircraft` VALUES ('787', 160);
INSERT INTO `nw_aircraft` VALUES ('797', 200);

-- --------------------------------------------------------

-- 
-- Table structure for table `nw_bookedflights`
-- 

CREATE TABLE `nw_bookedflights` (
  `thedate` date default NULL,
  `number` int(11) default NULL,
  `availableseats` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `nw_bookedflights`
-- 

INSERT INTO `nw_bookedflights` VALUES ('2005-03-08', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-08', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-08', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-08', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-08', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-08', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-08', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-08', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-08', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-08', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-08', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-08', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-08', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-08', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-08', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-08', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-08', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-08', 204, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-09', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-09', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-09', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-09', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-09', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-09', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-09', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-09', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-09', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-09', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-09', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-09', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-09', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-09', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-09', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-09', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-09', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-09', 204, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-10', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-10', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-10', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-10', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-10', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-10', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-10', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-10', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-10', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-10', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-10', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-10', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-10', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-10', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-10', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-10', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-10', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-10', 204, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-11', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-11', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-11', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-11', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-11', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-11', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-11', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-11', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-11', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-11', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-11', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-11', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-11', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-11', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-11', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-11', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-11', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-11', 204, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-12', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-12', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-12', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-12', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-12', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-12', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-12', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-12', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-12', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-12', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-12', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-12', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-12', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-12', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-12', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-12', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-12', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-12', 204, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-13', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-13', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-13', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-13', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-13', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-13', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-13', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-13', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-13', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-13', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-13', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-13', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-13', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-13', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-13', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-13', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-13', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-13', 204, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-14', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-14', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-14', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-14', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-14', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-14', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-14', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-14', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-14', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-14', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-14', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-14', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-14', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-14', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-14', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-14', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-14', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-14', 204, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-15', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-15', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-15', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-15', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-15', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-15', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-15', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-15', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-15', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-15', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-15', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-15', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-15', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-15', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-15', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-15', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-15', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-15', 204, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-16', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-16', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-16', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-16', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-16', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-16', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-16', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-16', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-16', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-16', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-16', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-16', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-16', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-16', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-16', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-16', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-16', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-16', 204, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-17', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-17', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-17', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-17', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-17', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-17', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-17', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-17', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-17', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-17', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-17', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-17', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-17', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-17', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-17', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-17', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-17', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-17', 204, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-18', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-18', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-18', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-18', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-18', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-18', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-18', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-18', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-18', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-18', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-18', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-18', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-18', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-18', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-18', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-18', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-18', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-18', 204, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-19', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-19', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-19', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-19', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-19', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-19', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-19', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-19', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-19', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-19', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-19', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-19', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-19', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-19', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-19', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-19', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-19', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-19', 204, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-20', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-20', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-20', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-20', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-20', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-20', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-20', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-20', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-20', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-20', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-20', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-20', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-20', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-20', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-20', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-20', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-20', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-20', 204, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-21', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-21', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-21', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-21', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-21', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-21', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-21', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-21', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-21', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-21', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-21', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-21', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-21', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-21', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-21', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-21', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-21', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-21', 204, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-22', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-22', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-22', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-22', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-22', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-22', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-22', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-22', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-22', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-22', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-22', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-22', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-22', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-22', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-22', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-22', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-22', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-22', 204, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-23', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-23', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-23', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-23', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-23', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-23', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-23', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-23', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-23', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-23', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-23', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-23', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-23', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-23', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-23', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-23', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-23', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-23', 204, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-24', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-24', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-24', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-24', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-24', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-24', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-24', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-24', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-24', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-24', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-24', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-24', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-24', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-24', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-24', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-24', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-24', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-24', 204, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-25', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-25', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-25', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-25', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-25', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-25', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-25', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-25', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-25', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-25', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-25', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-25', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-25', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-25', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-25', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-25', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-25', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-25', 204, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-26', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-26', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-26', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-26', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-26', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-26', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-26', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-26', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-26', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-26', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-26', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-26', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-26', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-26', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-26', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-26', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-26', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-26', 204, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-27', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-27', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-27', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-27', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-27', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-27', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-27', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-27', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-27', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-27', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-27', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-27', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-27', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-27', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-27', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-27', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-27', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-27', 204, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-28', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-28', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-28', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-28', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-28', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-28', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-28', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-28', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-28', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-28', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-28', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-28', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-28', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-28', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-28', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-28', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-28', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-28', 204, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-29', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-29', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-29', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-29', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-29', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-29', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-29', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-29', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-29', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-29', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-29', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-29', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-29', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-29', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-29', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-29', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-29', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-29', 204, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-30', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-30', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-30', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-30', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-30', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-30', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-30', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-30', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-30', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-30', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-30', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-30', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-30', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-30', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-30', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-30', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-30', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-30', 204, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-31', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-31', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-31', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-31', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-31', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-31', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-31', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-31', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-31', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-31', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-31', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-31', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-31', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-31', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-31', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-31', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-31', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-03-31', 204, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-01', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-01', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-01', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-01', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-01', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-01', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-01', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-01', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-01', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-01', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-01', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-01', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-01', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-01', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-01', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-01', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-01', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-01', 204, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-02', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-02', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-02', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-02', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-02', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-02', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-02', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-02', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-02', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-02', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-02', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-02', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-02', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-02', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-02', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-02', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-02', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-02', 204, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-03', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-03', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-03', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-03', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-03', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-03', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-03', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-03', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-03', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-03', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-03', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-03', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-03', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-03', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-03', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-03', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-03', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-03', 204, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-04', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-04', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-04', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-04', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-04', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-04', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-04', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-04', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-04', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-04', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-04', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-04', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-04', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-04', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-04', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-04', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-04', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-04', 204, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-05', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-05', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-05', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-05', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-05', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-05', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-05', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-05', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-05', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-05', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-05', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-05', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-05', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-05', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-05', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-05', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-05', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-05', 204, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-06', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-06', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-06', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-06', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-06', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-06', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-06', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-06', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-06', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-06', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-06', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-06', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-06', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-06', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-06', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-06', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-06', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-06', 204, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-07', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-07', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-07', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-07', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-07', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-07', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-07', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-07', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-07', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-07', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-07', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-07', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-07', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-07', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-07', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-07', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-07', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-07', 204, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-08', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-08', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-08', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-08', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-08', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-08', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-08', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-08', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-08', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-08', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-08', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-08', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-08', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-08', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-08', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-08', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-08', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-08', 204, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-09', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-09', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-09', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-09', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-09', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-09', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-09', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-09', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-09', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-09', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-09', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-09', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-09', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-09', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-09', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-09', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-09', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-09', 204, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-10', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-10', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-10', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-10', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-10', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-10', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-10', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-10', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-10', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-10', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-10', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-10', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-10', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-10', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-10', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-10', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-10', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-10', 204, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-11', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-11', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-11', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-11', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-11', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-11', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-11', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-11', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-11', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-11', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-11', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-11', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-11', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-11', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-11', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-11', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-11', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-11', 204, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-12', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-12', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-12', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-12', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-12', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-12', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-12', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-12', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-12', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-12', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-12', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-12', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-12', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-12', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-12', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-12', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-12', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-12', 204, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-13', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-13', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-13', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-13', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-13', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-13', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-13', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-13', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-13', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-13', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-13', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-13', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-13', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-13', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-13', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-13', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-13', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-13', 204, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-14', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-14', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-14', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-14', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-14', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-14', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-14', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-14', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-14', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-14', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-14', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-14', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-14', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-14', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-14', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-14', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-14', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-14', 204, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-15', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-15', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-15', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-15', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-15', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-15', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-15', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-15', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-15', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-15', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-15', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-15', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-15', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-15', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-15', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-15', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-15', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-15', 204, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-16', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-16', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-16', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-16', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-16', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-16', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-16', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-16', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-16', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-16', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-16', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-16', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-16', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-16', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-16', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-16', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-16', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-16', 204, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-17', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-17', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-17', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-17', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-17', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-17', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-17', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-17', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-17', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-17', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-17', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-17', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-17', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-17', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-17', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-17', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-17', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-17', 204, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-18', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-18', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-18', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-18', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-18', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-18', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-18', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-18', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-18', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-18', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-18', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-18', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-18', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-18', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-18', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-18', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-18', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-18', 204, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-19', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-19', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-19', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-19', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-19', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-19', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-19', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-19', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-19', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-19', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-19', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-19', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-19', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-19', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-19', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-19', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-19', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-19', 204, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-20', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-20', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-20', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-20', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-20', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-20', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-20', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-20', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-20', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-20', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-20', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-20', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-20', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-20', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-20', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-20', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-20', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-20', 204, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-21', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-21', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-21', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-21', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-21', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-21', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-21', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-21', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-21', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-21', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-21', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-21', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-21', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-21', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-21', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-21', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-21', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-21', 204, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-22', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-22', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-22', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-22', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-22', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-22', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-22', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-22', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-22', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-22', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-22', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-22', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-22', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-22', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-22', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-22', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-22', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-22', 204, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-23', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-23', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-23', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-23', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-23', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-23', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-23', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-23', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-23', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-23', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-23', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-23', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-23', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-23', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-23', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-23', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-23', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-23', 204, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-24', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-24', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-24', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-24', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-24', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-24', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-24', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-24', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-24', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-24', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-24', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-24', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-24', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-24', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-24', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-24', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-24', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-24', 204, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-25', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-25', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-25', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-25', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-25', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-25', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-25', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-25', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-25', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-25', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-25', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-25', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-25', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-25', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-25', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-25', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-25', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-25', 204, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-26', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-26', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-26', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-26', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-26', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-26', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-26', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-26', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-26', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-26', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-26', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-26', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-26', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-26', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-26', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-26', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-26', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-26', 204, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-27', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-27', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-27', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-27', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-27', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-27', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-27', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-27', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-27', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-27', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-27', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-27', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-27', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-27', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-27', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-27', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-27', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-27', 204, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-28', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-28', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-28', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-28', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-28', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-28', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-28', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-28', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-28', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-28', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-28', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-28', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-28', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-28', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-28', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-28', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-28', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-28', 204, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-29', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-29', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-29', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-29', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-29', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-29', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-29', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-29', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-29', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-29', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-29', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-29', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-29', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-29', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-29', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-29', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-29', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-29', 204, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-30', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-30', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-30', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-30', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-30', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-30', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-30', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-30', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-30', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-30', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-30', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-30', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-30', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-30', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-30', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-30', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-30', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-04-30', 204, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-05-01', 1, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-05-01', 101, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-05-01', 201, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-05-01', 301, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-05-01', 401, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-05-01', 3, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-05-01', 203, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-05-01', 103, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-05-01', 5, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-05-01', 102, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-05-01', 202, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-05-01', 2, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-05-01', 402, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-05-01', 104, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-05-01', 4, 160);
INSERT INTO `nw_bookedflights` VALUES ('2005-05-01', 302, 200);
INSERT INTO `nw_bookedflights` VALUES ('2005-05-01', 6, 120);
INSERT INTO `nw_bookedflights` VALUES ('2005-05-01', 204, 160);

-- --------------------------------------------------------

-- 
-- Table structure for table `nw_bookings`
-- 

CREATE TABLE `nw_bookings` (
  `username` varchar(255) default NULL,
  `thedate` date default NULL,
  `flightnumber` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `nw_bookings`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `nw_destinations`
-- 

CREATE TABLE `nw_destinations` (
  `destination` varchar(30) default NULL,
  `price` float default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `nw_destinations`
-- 

INSERT INTO `nw_destinations` VALUES ('Dublin', 40);
INSERT INTO `nw_destinations` VALUES ('Paris', 80);
INSERT INTO `nw_destinations` VALUES ('Ibiza', 150);
INSERT INTO `nw_destinations` VALUES ('New York', 200);
INSERT INTO `nw_destinations` VALUES ('Los Angeles', 400);

-- --------------------------------------------------------

-- 
-- Table structure for table `nw_flights`
-- 

CREATE TABLE `nw_flights` (
  `number` int(11) default NULL,
  `origin` varchar(255) default NULL,
  `destination` varchar(255) default NULL,
  `hours` int(11) default NULL,
  `weekend` int(11) default NULL,
  `summer` int(11) default NULL,
  `type` varchar(10) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `nw_flights`
-- 

INSERT INTO `nw_flights` VALUES (1, 'Southampton', 'Paris', 9, 0, 0, '787');
INSERT INTO `nw_flights` VALUES (101, 'Southampton', 'Dublin', 10, 0, 0, 'DC12');
INSERT INTO `nw_flights` VALUES (201, 'Southampton', 'New York', 11, 0, 0, '787');
INSERT INTO `nw_flights` VALUES (301, 'Southampton', 'Los Angeles', 12, 1, 0, '797');
INSERT INTO `nw_flights` VALUES (401, 'Southampton', 'Ibiza', 13, 0, 1, '787');
INSERT INTO `nw_flights` VALUES (3, 'Southampton', 'Paris', 14, 0, 0, 'DC12');
INSERT INTO `nw_flights` VALUES (203, 'Southampton', 'New York', 15, 0, 0, '797');
INSERT INTO `nw_flights` VALUES (103, 'Southampton', 'Dublin', 16, 0, 0, 'DC12');
INSERT INTO `nw_flights` VALUES (5, 'Southampton', 'Paris', 17, 0, 0, '787');
INSERT INTO `nw_flights` VALUES (102, 'Dublin', 'Southampton', 8, 0, 0, 'DC12');
INSERT INTO `nw_flights` VALUES (202, 'New York', 'Southampton', 9, 0, 0, '797');
INSERT INTO `nw_flights` VALUES (2, 'Paris', 'Southampton', 10, 0, 0, '787');
INSERT INTO `nw_flights` VALUES (402, 'Ibiza', 'Southampton', 11, 0, 1, '787');
INSERT INTO `nw_flights` VALUES (104, 'Dublin', 'Southampton', 14, 0, 0, 'DC12');
INSERT INTO `nw_flights` VALUES (4, 'Paris', 'Southampton', 15, 0, 0, 'DC12');
INSERT INTO `nw_flights` VALUES (302, 'Los Angeles', 'Southampton', 18, 1, 0, '797');
INSERT INTO `nw_flights` VALUES (6, 'Paris', 'Southampton', 19, 0, 0, 'DC12');
INSERT INTO `nw_flights` VALUES (204, 'New York', 'Southampton', 20, 0, 0, '787');

-- --------------------------------------------------------

-- 
-- Table structure for table `nw_users`
-- 

CREATE TABLE `nw_users` (
  `Name` varchar(255) default NULL,
  `username` varchar(255) default NULL,
  `address` text,
  `postcode` varchar(255) default NULL,
  `email` varchar(255) default NULL,
  `password` varchar(255) default NULL,
  `admin` int(11) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `nw_users`
-- 

INSERT INTO `nw_users` VALUES ('', '', '', '', '', 'zh6mxv0g', 0);
        