CREATE TABLE IF NOT EXISTS `award_booking` (
  `ID` int(11) NOT NULL auto_increment,
  `Reference` varchar(255) default NULL,
  `Total_Price_Net` varchar(255) default NULL,
  `Total_Price_Gross` varchar(255) default NULL,
  `Title` varchar(255) default NULL,
  `Forename` varchar(255) default NULL,
  `Surname` varchar(255) default NULL,
  `Organisation` varchar(255) default NULL,
  `Address_1` varchar(255) default NULL,
  `Address_2` varchar(255) default NULL,
  `Town` varchar(255) default NULL,
  `County` varchar(255) default NULL,
  `Postcode` varchar(255) default NULL,
  `Telephone` varchar(255) default NULL,
  `Email` varchar(255) default NULL,
  `PO` varchar(255) NOT NULL,
  `Award_Payment_Option_ID` int(255) default NULL,
  `Payment_Received` tinyint(1) default NULL,
  `Tickets_Sent` tinyint(1) default NULL,
  `Included_On_Table_Plan` tinyint(1) default NULL,
  `Notes` text,
  `Booking_Line_Count` int(11) default NULL,
  `Invoice_Location` varchar(255) default NULL,
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  `Job_Title` varchar(255) NOT NULL,
  PRIMARY KEY  (`ID`),
  KEY `Title` (`Reference`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `award_booking_line` (
  `ID` int(11) NOT NULL auto_increment,
  `Award_Booking_ID` varchar(255) default NULL,
  `Ticket` varchar(255) default NULL,
  `Price` varchar(255) default NULL,
  `Title` varchar(255) default NULL,
  `Forename` varchar(255) default NULL,
  `Surname` varchar(255) default NULL,
  `Organisation` varchar(255) default NULL,
  `Email` varchar(255) default NULL,
  `Special_Requirements` varchar(255) default NULL,
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `award_payment_option` (
  `ID` int(11) NOT NULL auto_increment,
  `Title` varchar(255) default NULL,
  `Content` text,
  `Surcharge` decimal(10,2) default NULL,
  `Surcharge_Text` varchar(255) default NULL,
  `Order_By` int(11) default NULL,
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  PRIMARY KEY  (`ID`),
  KEY `Order_By` (`Order_By`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `award_ticket` (
  `ID` int(11) NOT NULL auto_increment,
  `Title` varchar(255) default NULL,
  `Price` decimal(10,2) default NULL,
  `Date` date default NULL,
  `Order_By` int(11) default NULL,
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  PRIMARY KEY  (`ID`),
  KEY `Title` (`Title`),
  KEY `Order_By` (`Order_By`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;