--
-- Default CMS database
--


--
-- Table structure for table `availability_booking`
--

CREATE TABLE IF NOT EXISTS `availability_booking` (
  `ID` int(11) NOT NULL auto_increment,
  `Resource_ID` int(11) default NULL,
  `Date_From` date default NULL,
  `Date_To` date default NULL,
  `Nights` tinyint(4) NOT NULL default '1',
  `Notes` longtext,
  `Unavailable` tinyint(1) NOT NULL default '0',
  `Price` varchar(255) default NULL,
  `Name` 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,
  `Country` varchar(255) default NULL,
  `Telephone` varchar(255) default NULL,
  `Email` varchar(255) default NULL,
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  PRIMARY KEY  (`ID`),
  KEY `BookableID` (`Resource_ID`,`Date_From`,`Date_To`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

--
-- Table structure for table `availability_resource`
--

CREATE TABLE IF NOT EXISTS `availability_resource` (
  `ID` int(11) NOT NULL auto_increment,
  `Availability_Resource_Group_ID` int(1) default NULL,
  `Title` 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`),
  KEY `Availability_Resource_Group_ID` (`Availability_Resource_Group_ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

--
-- Table structure for table `availability_resource_period`
--

CREATE TABLE IF NOT EXISTS `availability_resource_period` (
  `ID` int(11) NOT NULL auto_increment,
  `Title` varchar(255) default NULL,
  `Availability_Resource_ID` int(11) default NULL,
  `Order_By` int(11) default NULL,
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  PRIMARY KEY  (`ID`),
  KEY `Title` (`Title`),
  KEY `Availability_Resource_ID` (`Availability_Resource_ID`,`Order_By`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

--
-- Table structure for table `availability_resource_price`
--

CREATE TABLE IF NOT EXISTS `availability_resource_price` (
  `ID` int(11) NOT NULL auto_increment,
  `Title` varchar(255) default NULL,
  `Availability_Resource_ID` int(11) default NULL,
  `Availability_Resource_Period_ID` int(11) default NULL,
  `Date` date default NULL,
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  PRIMARY KEY  (`ID`),
  KEY `Availability_Resource_ID` (`Availability_Resource_ID`,`Availability_Resource_Period_ID`,`Date`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;


--
-- Table structure for table `banner`
--

CREATE TABLE IF NOT EXISTS `banner` (
  `ID` int(11) NOT NULL auto_increment,
  `_undeletable` tinyint(1) default NULL,
  `Title` 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=InnoDB  DEFAULT CHARSET=latin1;

--
-- Table structure for table `banner_image`
--

CREATE TABLE IF NOT EXISTS `banner_image` (
  `ID` int(11) NOT NULL auto_increment,
  `Banner_ID` int(11) default NULL,
  `Title` varchar(255) default NULL,
  `Alt` varchar(255) default NULL,
  `Description` text,
  `Link` varchar(255) default NULL,
  `Order_By` int(11) default NULL,
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  PRIMARY KEY  (`ID`),
  KEY `Banner_ID` (`Banner_ID`),
  KEY `Order_By` (`Order_By`),
  KEY `Select` (`Banner_ID`,`Order_By`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1;

--
-- Table structure for table `blog_post`
--

CREATE TABLE IF NOT EXISTS `blog_post` (
  `ID` int(11) NOT NULL auto_increment,
  `Title` varchar(255) default NULL,
  `Date` date default NULL,
  `Intro` text,
  `Content` text,
  `Published` tinyint(4) NOT NULL default '0',
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  PRIMARY KEY  (`ID`),
  KEY `Date` (`Date`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

--
-- Table structure for table `brochure`
--

CREATE TABLE IF NOT EXISTS `brochure` (
  `ID` int(11) NOT NULL auto_increment,
  `Title` varchar(255) NOT NULL,
  `Description` varchar(255) NOT NULL,
  `Path` varchar(255) NOT NULL,
  `Created` datetime NOT NULL,
  `Updated` datetime NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

--
-- Table structure for table `brochure_request`
--

CREATE TABLE IF NOT EXISTS `brochure_request` (
  `ID` int(11) NOT NULL auto_increment,
  `Brochure_ID` int(11) NOT NULL,
  `Name` varchar(255) NOT NULL,
  `Email` varchar(255) NOT NULL,
  `Telephone` varchar(255) NOT NULL,
  `Address_1` varchar(255) NOT NULL,
  `Address_2` varchar(255) NOT NULL,
  `Town` varchar(255) NOT NULL,
  `County` varchar(255) NOT NULL,
  `Postcode` varchar(255) NOT NULL,
  `Options` int(11) NOT NULL,
  `Status` int(11) NOT NULL,
  `Created` datetime NOT NULL,
  `Updated` datetime NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

--
-- Table structure for table `business_item`
--

CREATE TABLE IF NOT EXISTS `business_item` (
  `ID` int(11) NOT NULL auto_increment,
  `Title` varchar(255) NOT NULL,
  `Summary` text NOT NULL,
  `Featured` tinyint(1) NOT NULL default '0',
  `Latitude` varchar(255) NOT NULL,
  `Longitude` varchar(255) NOT NULL,
  `Content` text NOT NULL,
  `Subtitle` varchar(255) NOT NULL,
  `Gallery_ID` int(11) NOT NULL,
  `Banner_ID` int(11) NOT NULL,
  `Created` datetime NOT NULL,
  `Updated` datetime NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

--
-- Table structure for table `business_item_category`
--

CREATE TABLE IF NOT EXISTS `business_item_category` (
  `ID` int(11) NOT NULL auto_increment,
  `Title` varchar(255) default NULL,
  `Order_By` int(11) default NULL,
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

--
-- Table structure for table `business_item_to_category`
--

CREATE TABLE IF NOT EXISTS `business_item_to_category` (
  `ID` int(11) NOT NULL auto_increment,
  `Business_Item_ID` int(11) default NULL,
  `Category_ID` int(11) default NULL,
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

--
-- Table structure for table `comments`
--

CREATE TABLE IF NOT EXISTS `comments` (
  `ID` int(11) NOT NULL auto_increment,
  `Title` varchar(255) default NULL,
  `Date` datetime default NULL,
  `Content` text,
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  PRIMARY KEY  (`ID`),
  KEY `Title` (`Title`),
  KEY `Date` (`Date`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1;

--
-- Table structure for table `contact`
--

CREATE TABLE IF NOT EXISTS `contact` (
  `ID` int(11) NOT NULL auto_increment,
  `Title` varchar(255) default NULL,
  `Related_Details` varchar(255) default NULL,
  `Phone` varchar(255) default NULL,
  `Email` varchar(255) default NULL,
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

--
-- Table structure for table `error`
--

CREATE TABLE IF NOT EXISTS `error` (
  `ID` int(11) NOT NULL auto_increment,
  `Error` text,
  `Created` datetime default NULL,
  PRIMARY KEY  (`ID`),
  KEY `Created` (`Created`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `event`
--

CREATE TABLE IF NOT EXISTS `event` (
  `ID` int(11) NOT NULL auto_increment,
  `Title` varchar(255) default NULL,
  `Intro` text,
  `Content` text,
  `Start_Date` date default NULL,
  `End_Date` date default NULL,
  `Gallery_ID` int(11) default NULL,
  `Show_On_Map` tinyint(1) NOT NULL default '0',
  `Venue` varchar(255) default NULL,
  `Venue_Address_1` varchar(255) default NULL,
  `Venue_Address_2` varchar(255) default NULL,
  `Venue_Town` varchar(255) default NULL,
  `Venue_County` varchar(255) default NULL,
  `Venue_Postcode` varchar(255) default NULL,
  `Venue_Lat` varchar(255) NOT NULL,
  `Venue_Long` varchar(255) NOT NULL,
  `Venue_Website` text,
  `Venue_Telephone` varchar(50) default NULL,
  `Venue_Email` varchar(250) default NULL,
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  PRIMARY KEY  (`ID`),
  KEY `Title` (`Title`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

--
-- Table structure for table `fact_box`
--

CREATE TABLE IF NOT EXISTS `fact_box` (
  `ID` int(11) NOT NULL auto_increment,
  `Title` varchar(255) default NULL,
  `Description` text,
  `Link` varchar(255) default NULL,
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `file_meta`
--

CREATE TABLE IF NOT EXISTS `file_meta` (
  `ID` int(11) NOT NULL auto_increment,
  `Item_Type` varchar(255) default NULL,
  `Item_ID` int(11) default NULL,
  `Item_Field` varchar(255) default NULL,
  `Item_Index` int(11) default NULL,
  `Title` varchar(255) default NULL,
  `Size` int(11) default NULL,
  `Mime` varchar(255) default NULL,
  `Extension` varchar(10) default NULL,
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  PRIMARY KEY  (`ID`),
  KEY `Item_Type` (`Item_Type`,`Item_ID`,`Item_Field`,`Item_Index`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `gallery`
--

CREATE TABLE IF NOT EXISTS `gallery` (
  `ID` int(11) NOT NULL auto_increment,
  `Publish_To_Gallery` tinyint(1) NOT NULL default '0',
  `Title` varchar(255) default NULL,
  `Order_By` int(11) default NULL,
  `Public` tinyint(1) NOT NULL default '0',
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  PRIMARY KEY  (`ID`),
  KEY `Order_By` (`Order_By`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1;

INSERT INTO `gallery` (`ID`, `Title`, `Order_By`, `Public`, `Created`, `Updated`) VALUES
(1, 'Gallery Test', NULL, 0, '2014-05-02 13:00:02', '2014-05-02 13:00:02');

--
-- Table structure for table `gallery_image`
--

CREATE TABLE IF NOT EXISTS `gallery_image` (
  `ID` int(11) NOT NULL auto_increment,
  `Gallery_ID` int(11) default NULL,
  `Title` varchar(255) default NULL,
  `Alt` varchar(255) default NULL,
  `Description` text,
  `Order_By` int(11) default NULL,
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  PRIMARY KEY  (`ID`),
  KEY `Gallery_ID` (`Gallery_ID`),
  KEY `Order_By` (`Order_By`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `image_meta`
--

CREATE TABLE IF NOT EXISTS `image_meta` (
  `ID` int(11) NOT NULL auto_increment,
  `Original_Image_ID` int(11) default NULL,
  `Item_Type` varchar(255) default NULL,
  `Item_ID` varchar(255) default NULL,
  `Item_Field` varchar(255) default NULL,
  `Item_Index` int(11) default NULL,
  `Title` varchar(255) default NULL,
  `Size` int(11) default NULL,
  `Mime` varchar(255) default NULL,
  `Extension` varchar(10) default NULL,
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  PRIMARY KEY  (`ID`),
  KEY `Item_Type` (`Item_Type`,`Item_ID`,`Item_Field`,`Item_Index`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1;

--
-- Table structure for table `image_request`
--

CREATE TABLE IF NOT EXISTS `image_request` (
  `ID` int(11) NOT NULL auto_increment,
  `Title` varchar(255) NOT NULL,
  `Email` varchar(255) NOT NULL,
  `Status` tinyint(11) NOT NULL default '1',
  `Created` datetime NOT NULL,
  `Updated` datetime NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `image_request_item`
--

CREATE TABLE IF NOT EXISTS `image_request_item` (
  `ID` int(11) NOT NULL auto_increment,
  `Gallery_Image_ID` int(11) NOT NULL,
  `Request_ID` int(11) NOT NULL,
  `Created` datetime NOT NULL,
  `Updated` datetime NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `image_request_to_item`
--

CREATE TABLE IF NOT EXISTS `image_request_to_item` (
  `ID` int(11) NOT NULL auto_increment,
  `Request_ID` int(11) NOT NULL,
  `Request_Item_ID` int(11) NOT NULL,
  `Created` datetime NOT NULL,
  `Updated` datetime NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `image_uploader`
--

CREATE TABLE IF NOT EXISTS `image_uploader` (
  `ID` int(11) NOT NULL auto_increment,
  `Title` varchar(255) default NULL,
  `Name` varchar(255) default NULL,
  `Phone` varchar(255) NOT NULL,
  `Email` varchar(255) NOT NULL,
  `Approved` tinyint(4) NOT NULL default '0',
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `landing_page_location`
--

CREATE TABLE IF NOT EXISTS `landing_page_location` (
  `ID` int(11) NOT NULL auto_increment,
  `Title` 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,
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  PRIMARY KEY  (`ID`),
  KEY `Title` (`Title`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

INSERT INTO `landing_page_location` (`ID`, `Title`, `Address_1`, `Address_2`, `Town`, `County`, `Postcode`, `Telephone`, `Created`, `Updated`) VALUES
(null, 'Bishop''s Castle', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(null, 'Bridgnorth', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(null, 'Ironbridge', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(null, 'Church Stretton', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(null, 'Cleobury Mortimer', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(null, 'Clun', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(null, 'Craven Arms', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(null, 'Shifnal', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(null, 'Ellesmere', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(null, 'Ludlow', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(null, 'Telford', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(null, 'Market Drayton', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(null, 'Much Wenlock', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(null, 'Newport', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(null, 'Oswestry', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(null, 'Shrewsbury', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(null, 'Whitchurch', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(null, 'Wellington', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(null, 'Wem', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(null, 'Madeley', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(null, 'Broseley', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(null, 'Albrighton', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(null, 'Cosford', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(null, 'North Shropshire', '', '', '', '', '', '', '2013-07-15 16:26:42', '2013-07-15 16:26:42'),
(null, 'South Shropshire', '', '', '', '', '', '', '2013-07-15 16:26:54', '2013-07-15 16:26:54');

--
-- Table structure for table `landing_page_service`
--

CREATE TABLE IF NOT EXISTS `landing_page_service` (
  `ID` int(11) NOT NULL auto_increment,
  `Title` varchar(255) default NULL,
  `Content` text,
  `SEO_URL` varchar(255) default NULL,
  `SEO_Title` varchar(255) default NULL,
  `SEO_Keywords` varchar(255) default NULL,
  `SEO_Description` 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 `marquee` (
  `ID` int(11) NOT NULL auto_increment,
  `Title` varchar(255) NOT NULL,
  `Enabled` tinyint(1) NOT NULL,
  `Content` text NOT NULL,
  `Created` datetime NOT NULL,
  `Updated` datetime NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

--
-- Table structure for table `news`
--

CREATE TABLE IF NOT EXISTS `news` (
  `ID` int(11) NOT NULL auto_increment,
  `Title` varchar(255) default NULL,
  `Date` date default NULL,
  `Intro` text,
  `Content` text,
  `Gallery_ID` int(11) default NULL,
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  PRIMARY KEY  (`ID`),
  KEY `Date` (`Date`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

--
-- Table structure for table `newsletter_clickthrough`
--

CREATE TABLE IF NOT EXISTS `newsletter_clickthrough` (
  `ID` int(11) NOT NULL auto_increment,
  `Newsletter_Message_Sent_ID` int(11) default NULL,
  `Newsletter_Email_Sent_ID` int(11) default NULL,
  `URL` varchar(255) default NULL,
  `Click_Date` datetime default NULL,
  PRIMARY KEY  (`ID`),
  KEY `Newsletter_Message_Sent_ID` (`Newsletter_Message_Sent_ID`,`Newsletter_Email_Sent_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `newsletter_email_sent`
--

CREATE TABLE IF NOT EXISTS `newsletter_email_sent` (
  `ID` int(11) NOT NULL auto_increment,
  `Newsletter_Message_Sent_ID` int(11) default NULL,
  `Contact_ID` int(255) default NULL,
  `Contact_Name` varchar(255) default NULL,
  `Contact_Email` varchar(255) default NULL,
  `Read_First` datetime default NULL,
  `Read_Last` datetime default NULL,
  `Read_Count` int(11) default NULL,
  `Unsubscribed` tinyint(1) default NULL,
  `Unsubscribed_Date` datetime default NULL,
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  PRIMARY KEY  (`ID`),
  KEY `Newsletter_Message_Sent_ID` (`Newsletter_Message_Sent_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `newsletter_message`
--

CREATE TABLE IF NOT EXISTS `newsletter_message` (
  `ID` int(11) NOT NULL auto_increment,
  `Title` varchar(255) default NULL,
  `Subject` varchar(255) default NULL,
  `HTML_Content` text,
  `Content` text,
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  PRIMARY KEY  (`ID`),
  KEY `Title` (`Title`),
  KEY `Updated` (`Updated`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `newsletter_message_sent`
--

CREATE TABLE IF NOT EXISTS `newsletter_message_sent` (
  `ID` int(11) NOT NULL auto_increment,
  `Newsletter_Message_ID` int(11) default NULL,
  `Newsletter_Message_Title` varchar(255) default NULL,
  `Date_Sent` datetime default NULL,
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  PRIMARY KEY  (`ID`),
  KEY `Newsletter_Message_ID` (`Newsletter_Message_ID`,`Newsletter_Message_Title`),
  KEY `Newsletter_Message_Title` (`Newsletter_Message_Title`,`Date_Sent`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `newsletter_queue`
--

CREATE TABLE IF NOT EXISTS `newsletter_queue` (
  `ID` int(11) NOT NULL auto_increment,
  `Customer_ID` int(11) default NULL,
  `Name` varchar(255) default NULL,
  `Email` varchar(255) default NULL,
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  PRIMARY KEY  (`ID`),
  KEY `Customer_ID` (`Customer_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `newsletter_template`
--

CREATE TABLE IF NOT EXISTS `newsletter_template` (
  `ID` int(10) NOT NULL auto_increment,
  `Title` varchar(255) default NULL,
  `HTML_Content` text,
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `newsletter_template` (`ID`, `Title`, `HTML_Content`, `Created`, `Updated`) VALUES
(1, 'Template', '', NULL, NULL);

--
-- Table structure for table `page`
--

CREATE TABLE IF NOT EXISTS `page` (
  `ID` int(11) NOT NULL auto_increment,
  `_undeletable` tinyint(1) default NULL,
  `Title` varchar(255) default NULL,
  `Custom_URL` varchar(255) default NULL,
  `Location` int(11) default NULL,
  `Parent` int(11) default NULL,
  `Content` text,
  `Banner_ID` int(11) default NULL,
  `Side_Banner_ID` int(11) default NULL,
  `Gallery_ID` int(11) default NULL,
  `Body_Class` varchar(255) default NULL,
  `Video_URL` varchar(255) default NULL,
  `SEO_Title` varchar(255) default NULL,
  `SEO_Keywords` varchar(255) default NULL,
  `SEO_Description` text,
  `SEO_URL` varchar(255) default NULL,
  `Order_By` int(11) default NULL,
  `Show_Nav` tinyint(1) NOT NULL default '1',
  `Published` tinyint(1) default NULL,
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  PRIMARY KEY  (`ID`),
  KEY `Order_By` (`Order_By`),
  KEY `Parent` (`Parent`),
  KEY `Main` (`Location`,`Parent`,`Published`,`Order_By`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;

--
-- Dumping data for table `page`
--

INSERT INTO `page` (`ID`, `_undeletable`, `Title`, `Location`, `Parent`, `Content`, `Banner_ID`, `Side_Banner_ID`, `Gallery_ID`, `Body_Class`, `Video_URL`, `SEO_Title`, `SEO_Keywords`, `SEO_Description`, `SEO_URL`, `Order_By`, `Show_Nav`, `Published`, `Created`, `Updated`) VALUES
(1, 1, 'Home', 1, 0, '<h1>\r\n	Home</h1>\r\n', 0, 0, 0, '0', '', '', '', '', '0', 999999, 1, 1, '2013-04-30 16:26:17', '2013-04-30 16:41:32'),
(2, 1, 'Contact', 1, 0, '<h1>\r\n	Contact</h1>\r\n', 0, 0, 0, '0', '', '', '', '', '0', 999999, 1, 1, '2013-04-30 16:40:35', '2013-06-21 09:06:15'),
(3, 1, 'Find Us', 1, 0, '<h1>\r\n	Find Us</h1>\r\n', 0, 0, 0, '0', '', '', '', '', '0', 999999, 1, 1, '2013-04-30 16:40:50', '2013-06-18 12:18:20'),
(4, 1, 'Gallery', 1, 0, '<h1>\r\n	Gallery</h1><p>Please click on the thumbnails below to enlarge</p>\r\n', 0, 0, 0, '0', '', '', '', '', '0', 999999, 1, 1, '2013-04-30 16:41:22', '2013-05-01 09:16:00'),
(5, 1, 'Comments', 1, 0, '<h1>\r\n	Comments</h1>\r\n', 0, 0, 0, '0', '', '', '', '', '0', 999999, 1, 1, '2013-04-30 16:42:18', '2013-05-01 09:15:52'),
(6, 1, 'News', 1, 0, '<h1>\r\n	News</h1>\r\n', 0, 0, 0, '0', '', '', '', '', '0', 999999, 1, 1, '2013-05-01 09:15:35', '2013-05-01 09:15:41'),
(7, 1, 'Events', 1, 0, '<h1>\r\n	Events</h1>\r\n', 0, 0, 0, '0', '', '', '', '', '0', 999999, 1, 1, '2013-05-01 09:16:16', '2013-05-01 09:16:16'),
(8, 1, 'Blog', 1, 0, '<h1>\r\n	Blog</h1>\r\n', 0, 0, 0, '0', '', '', '', '', '0', 999999, 1, 1, '2013-05-01 09:16:32', '2013-05-02 15:32:20'),
(9, 1, 'Resources', 1, 0, '<h1>\r\n	Resources</h1>\r\n', 0, 0, 0, '0', '', '', '', '', '0', 999999, 1, 1, '2013-05-01 09:16:55', '2013-05-01 09:16:55'),
(10, 1, 'Resource Search', 0, 0, '<h1>\r\n	Resource Search</h1>\r\n', 0, 0, 0, '0', '', '', '', '', '0', 999999, 1, 1, '2013-05-01 09:18:02', '2013-05-01 09:18:02'),
(11, 1, 'Submit your Photos', 0, 0, '<h1>\r\n	Submit your Photos</h1>\r\n', 0, 0, 0, '0', '', '', '', '', '0', 999999, 1, 1, '2013-05-01 09:18:19', '2013-05-01 09:18:19'),
(12, 1, '404 Page', 0, 0, '<h1>\r\n	404 Error</h1>\r\n<p>\r\n	Oops - something seems to have gone wrong. Please use the menu links to navigate to the page you are looking for.</p>\r\n', 0, 0, 0, '0', '', '', '', '', '0', 999999, 1, 1, '2013-05-02 14:08:14', '2013-05-02 14:08:46'),
(13, 1, 'Landing Page', 0, 0, '', 0, 0, 0, '0', '', '', '', '', '0', 999999, 1, 1, '2013-05-03 15:08:21', '2013-05-03 15:08:26'),
(14, 1, 'Privacy Policy', 0, 0, '<h1>Privacy Policy</h1>\r\n\r\n<h2>What is this Privacy Policy for?</h2>\r\n\r\n<p>This privacy policy governs the privacy of this website and it&#39;s users who choose to use it.</p>\r\n\r\n<p>The policy sets out the different areas where user privacy is concerned and outlines the obligations &amp; requirements of the users, the website and website owners. Furthermore the way this website processes, stores and protects user data and information will also be detailed within this policy.</p>\r\n\r\n<h2>The Website</h2>\r\n\r\n<p>This website and its owners take a proactive approach to user privacy and ensure the necessary steps are taken to protect the privacy of its users throughout their visiting experience. This website complies to all UK national laws and requirements for user privacy.</p>\r\n\r\n<h2>Use of Cookies</h2>\r\n\r\n<p>This website uses cookies to better the users experience while visiting the website.</p>\r\n\r\n<p>Cookies are small files saved to the users computer&rsquo;s hard drive that track, save and store information about the users&rsquo; interactions and usage of the website. This allows the website, through its server to provide the users with a tailored experience within this website.<br />\r\nUsers are advised that if they wish to deny the use and saving of cookies from this website on to their computers hard drive they should take necessary steps within their web browsers security settings to block all cookies from this website and its external serving vendors.</p>\r\n\r\n<p>This website uses tracking software to monitor it&#39;s visitors to better understand how they use it. This software is provided by Google Analytics which uses cookies to track visitor usage. The software will save a cookie to your computer&rsquo;s hard drive in order to track and monitor your engagement and usage of the website but will not store, save or collect personal information. You can read Google&#39;s privacy policy here for further information [<a href="http://www.legislation.gov.uk/ukpga/1998/29/contents" target="_blank">http://www.google.com/privacy.html&nbsp;</a>].</p>\r\n\r\n<p>Other cookies may be stored to your computer&rsquo;s hard drive by external vendors when this website uses referral programs, sponsored links or adverts. Such cookies are used for conversion and referral tracking and typically expire after 30 days, though some may take longer. No personal information is stored, saved or collected.</p>\r\n\r\n<h2>Contact &amp; Communication</h2>\r\n\r\n<p>Users contacting this website and/or its owners do so at their own discretion and provide any such personal details requested at their own risk. Your personal information is kept private and stored securely until a time it is no longer required or has no use, as detailed in the Data Protection Act 1998. Every effort has been made to ensure a safe and secure form to email submission process but advise users using such form to email processes that they do so at their own risk.</p>\r\n\r\n<p>This website and it&#39;s owners use any information submitted to provide you with further information about the products / services they offer or to assist you in answering any questions or queries you may have submitted. This includes using your details to subscribe you to any email newsletter program the website operates but only if your express permission was granted when submitting any form to email process.&nbsp;<br />\r\nYour details are not passed on to any third parties.</p>\r\n\r\n<h2>Email Newsletter</h2>\r\n\r\n<p>This website operates an email newsletter program, used to inform subscribers about products and services supplied by this website. Users can subscribe through an online automated process should they wish to do so but do so at their own discretion. Some subscriptions may be manually processed through prior written agreement with the user.</p>\r\n\r\n<p>Subscriptions are taken in compliance with UK Spam Laws detailed in the Privacy and Electronic Communications Regulations 2003. All personal details relating to subscriptions are held securely and in accordance with the Data Protection Act 1998. No personal details are passed on to third parties nor shared with companies / people outside of the company that operates this website. Under the Data Protection Act 1998 you may request a copy of personal information held about you by this website&#39;s email newsletter program. A small fee will be payable. If you would like a copy of the information held on you please contact us.</p>\r\n\r\n<p>Email marketing campaigns published by this website or its owners may contain tracking facilities within the actual email. Subscriber activity is tracked and stored in a database for future analysis and evaluation. Such tracked activity may include; the opening of emails, forwarding of emails, the clicking of links within the email content, times, dates and frequency of activity [this is by not a comprehensive list].<br />\r\nThis information is used to refine future email campaigns and supply the user with more relevant content based around their activity.</p>\r\n\r\n<p>In compliance with UK Spam Laws and the Privacy and Electronic Communications Regulations 2003 subscribers are given the opportunity to un-subscribe at any time through an automated system. This process is detailed at the footer of each email campaign.</p>\r\n\r\n<h2>External Links</h2>\r\n\r\n<p>Although this website only looks to include quality, safe and relevant external links users should always adopt a policy of caution before clicking any external web links mentioned throughout this website.</p>\r\n\r\n<p>The owners of this website cannot guarantee or verify the contents of any externally linked website despite their best efforts. Users should therefore note they click on external links at their own risk and this website and its owners cannot be held liable for any damages or implications caused by visiting any external links mentioned.</p>\r\n\r\n<h2>Adverts and Sponsored Links</h2>\r\n\r\n<p>This website may contain sponsored links and adverts. These will typically be served through our advertising partners, to whom may have detailed privacy policies relating directly to the adverts they serve.</p>\r\n\r\n<p>Clicking on any such adverts will send you to the advertiser&rsquo;s website through a referral program which may use cookies and will tracks the number of referrals sent from this website. This may include the use of cookies which may in turn be saved on your computer&rsquo;s hard drive. Users should therefore note they click on sponsored external links at their own risk and this website and it&#39;s owners cannot be held liable for any damages or implications caused by visiting any external links mentioned.</p>\r\n\r\n<h2>Social Media Platforms</h2>\r\n\r\n<p>Communication, engagement and actions taken through external social media platforms that this website and it&#39;s owners participate on are custom to the terms and conditions as well as the privacy policies held with each social media platform respectively.</p>\r\n\r\n<p>Users are advised to use social media platforms wisely and communicate / engage upon them with due care and caution with regards to their own privacy and personal details. This website, nor its owners, will ever ask for personal or sensitive information through social media platforms and encourage users wishing to discuss sensitive details to contact them through primary communication channels such as by telephone or email.</p>\r\n\r\n<p>This website may use social sharing buttons which help share web content directly from web pages to the social media platform in question. Users are advised before using such social sharing buttons that they do so at their own discretion and note that the social media platform may track and save your request to share a web page respectively through your social media platform account.</p>\r\n\r\n<h2>Shortened Links in Social Media</h2>\r\n\r\n<p>This website and it&#39;s owners through their social media platform accounts may share web links to relevant web pages. By default some social media platforms shorten lengthy URL&#39;s (web addresses).&nbsp;</p>\r\n\r\n<p>Users are advised to take caution and good judgment before clicking any shortened URL&#39;s published on social media platforms by this website and it&#39;s owners. Despite the best efforts to ensure only genuine url&#39;s are published many social media platforms are prone to spam and hacking and therefore this website and it&#39;s owners cannot be held liable for any damages or implications caused by visiting any shortened links.</p>\r\n\r\n<h2>Resources &amp; Further Information</h2>\r\n\r\n<ul>\r\n	<li><a href="http://www.legislation.gov.uk/ukpga/1998/29/contents" target="_blank">Data Protection Act 1998</a></li>\r\n	<li><a href="http://www.ico.gov.uk/for_organisations/privacy_and_electronic_communications/the_guide.aspx" target="_blank">Privacy and Electronic Communications Regulations 2003 - The Guide</a></li>\r\n	<li><a href="http://twitter.com/privacy" target="_blank">Twitter Privacy Policy</a></li>\r\n	<li><a href="http://www.facebook.com/about/privacy/" target="_blank">Facebook Privacy Policy</a></li>\r\n	<li><a href="http://www.google.com/privacy.html" target="_blank">Google Privacy Policy</a></li>\r\n</ul>\r\n', 0, 0, 0, '0', '', '', '', '', '0', 999999, 1, 1, '2013-12-19 17:53:30', '2013-12-19 17:56:07'),
(15, 1, 'Availability', 1, 0, '<h1>Availability</h1>\r\n\r\n<p>To send us a booking enquiry simply click the date of the first night&#39;s stay.&nbsp; You will then be asked to enter a few more details regarding your stay.&nbsp; Once you have entered the information, click &#39;submit&#39; to send us your enquiry and we will respond as soon as we can.</p>\r\n<p>Please do not hesitate to contact us if the dates you require are not available.&nbsp; We can then contact you in the event of a cancellation.</p>\r\n', 0, 0, 0, '0', '', '', '', '', '0', 3, 1, 1, '2013-05-03 15:08:21', '2014-02-27 13:44:37'),
(16, 1, 'Availability Completed', '', 0, 0, '<h1>Booking Enquiry Sent</h1>\r\n\r\n<p>Thank you for your booking enquiry. We will contact you as soon as possible to confirm the booking.</p>\r\n\r\n<p>If you would like to speak to someone sooner, please <a href="/page/2/contact.htm" title="Contact About Booking Information">contact us</a> directly.</p>\r\n', 0, 0, 0, '0', '', '', '', '', '0', 999999, 1, 1, '2013-05-03 15:08:21', '2015-03-24 14:59:49'),
(17, 1, 'Newsletter Completed', 0, 0, '<h1>Newsletter Complete</h1>\r\n\r\n<p>Thank you for signing up to our online newsletter.</p>\r\n', 0, 0, 0, '0', '', '', '', '', '0', 999999, 1, 1, '2013-05-03 15:08:21', '2013-05-03 15:08:26'),
(18, 1, 'Contact Completed', 0, 0, '<h1>Message Sent</h1>\r\n\r\n<p>Thank you for your enquiry, we will contact you as soon as possible.</p>\r\n', 0, 0, 0, '0', '', '', '', '', '0', 999999, 1, 1, '2013-05-03 15:08:21', '2013-05-03 15:08:26'),
(19, 1, 'Cookies', 0, 0, '<h1>Use of Cookies</h1>\r\n\r\n<p>This website uses cookies to better the users experience while visiting the website.</p>\r\n\r\n<p>Cookies are small files saved to the users computer&rsquo;s hard drive that track, save and store information about the users&rsquo; interactions and usage of the website. This allows the website, through its server to provide the users with a tailored experience within this website.<br>\r\nUsers are advised that if they wish to deny the use and saving of cookies from this website on to their computers hard drive they should take necessary steps within their web browsers security settings to block all cookies from this website and its external serving vendors.</p>\r\n\r\n<p>This website uses tracking software to monitor it&#39;s visitors to better understand how they use it. This software is provided by Google Analytics which uses cookies to track visitor usage. The software will save a cookie to your computer&rsquo;s hard drive in order to track and monitor your engagement and usage of the website but will not store, save or collect personal information. You can read Google&#39;s privacy policy here for further information [<a href="http://www.legislation.gov.uk/ukpga/1998/29/contents" target="_blank">http://www.google.com/privacy.html&nbsp;</a>].</p>\r\n\r\n<p>Other cookies may be stored to your computer&rsquo;s hard drive by external vendors when this website uses referral programs, sponsored links or adverts. Such cookies are used for conversion and referral tracking and typically expire after 30 days, though some may take longer. No personal information is stored, saved or collected.</p>\r\n', 0, 0, 0, '0', '', '', '', '', '0', 999999, 1, 1, '2013-05-03 15:08:21', '2013-05-03 15:08:26'),
(20, 1, 'Accommodation', 1, 0, '<h1>\r\n	Accommodation</h1>\r\n', 0, 0, 0, '0', '', '', '', '', '0', 999999, 1, 1, '2013-05-01 09:15:35', '2013-05-01 09:15:41');

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

--
-- Table structure for table `page_contact`
--

CREATE TABLE IF NOT EXISTS `page_contact` (
  `ID` int(11) NOT NULL auto_increment,
  `Contact_ID` int(11) NOT NULL,
  `Page_ID` int(11) NOT NULL,
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

--
-- Table structure for table `page_location`
--

CREATE TABLE IF NOT EXISTS `page_location` (
  `ID` int(11) NOT NULL auto_increment,
  `Title` varchar(255) default NULL,
  `Order_By` int(11) default NULL,
  `Depth_Cap` int(11) default NULL,
  `Number_Cap` int(11) default NULL,
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  PRIMARY KEY  (`ID`),
  KEY `Title` (`Title`),
  KEY `Order_By` (`Order_By`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

INSERT INTO `page_location` (`ID`, `Title`, `Order_By`, `Depth_Cap`, `Number_Cap`, `Created`, `Updated`) VALUES
(1, 'Main Menu', 1, 1, 0, NULL, NULL);

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

--
-- Table structure for table `partner_logo`
--

CREATE TABLE IF NOT EXISTS `partner_logo` (
  `ID` int(11) NOT NULL auto_increment,
  `Title` varchar(255) default NULL,
  `Content` text,
  `Link` varchar(255) default NULL,
  `Gallery_ID` int(11) default NULL,
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `pc_product`
--

CREATE TABLE IF NOT EXISTS `pc_product` (
  `ID` int(11) NOT NULL auto_increment,
  `Title` varchar(255) default NULL,
  `Active` tinyint(1) default NULL,
  `Price` decimal(10,2) default NULL,
  `Price_Before` decimal(10,2) default NULL,
  `Description_Short` varchar(255) default NULL,
  `Content` text,
  `Gallery_ID` int(11) default NULL,
  `Video_URL` varchar(255) default NULL,
  `Search` text,
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  PRIMARY KEY  (`ID`),
  KEY `Title` (`Title`),
  KEY `Active` (`Active`,`ID`),
  FULLTEXT KEY `Search` (`Search`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `pc_product_category`
--

CREATE TABLE IF NOT EXISTS `pc_product_category` (
  `ID` int(11) NOT NULL auto_increment,
  `Title` varchar(255) default NULL,
  `Parent` int(11) default NULL,
  `Description_Short` varchar(255) default NULL,
  `Content` text,
  `Order_By` int(11) default NULL,
  `SEO_Title` varchar(255) default NULL,
  `SEO_Keywords` varchar(255) default NULL,
  `SEO_Description` text,
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  PRIMARY KEY  (`ID`),
  KEY `Title` (`Title`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `pc_product_to_category`
--

CREATE TABLE IF NOT EXISTS `pc_product_to_category` (
  `ID` int(11) NOT NULL auto_increment,
  `PC_Product_ID` int(11) default NULL,
  `PC_Product_Category_ID` int(11) default NULL,
  `Order_By` int(11) default NULL,
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  PRIMARY KEY  (`ID`),
  KEY `Product_ID` (`PC_Product_ID`,`PC_Product_Category_ID`,`Order_By`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

--
-- Table structure for table `portfolio_video`
--

CREATE TABLE IF NOT EXISTS `portfolio_video` (
  `ID` int(11) NOT NULL auto_increment,
  `Title` varchar(255) NOT NULL,
  `URL` varchar(255) NOT NULL,
  `Created` datetime NOT NULL,
  `Updated` datetime NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

--
-- Table structure for table `ratings`
--

CREATE TABLE IF NOT EXISTS `ratings` (
  `ID` int(11) NOT NULL auto_increment,
  `Title` varchar(255) default NULL,
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `resource_category`
--

CREATE TABLE IF NOT EXISTS `resource_category` (
  `ID` int(11) NOT NULL auto_increment,
  `Title` varchar(255) default NULL,
  `Order_By` int(11) default NULL,
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `resource_document`
--

CREATE TABLE IF NOT EXISTS `resource_document` (
  `ID` int(11) NOT NULL auto_increment,
  `Resource_ID` int(11) NOT NULL,
  `Title` varchar(255) NOT NULL,
  `Description` varchar(255) NOT NULL,
  `Path` varchar(255) NOT NULL,
  `Extension` varchar(20) default NULL,
  `Created` datetime NOT NULL,
  `Updated` datetime NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `resource_item`
--

CREATE TABLE IF NOT EXISTS `resource_item` (
  `ID` int(11) NOT NULL auto_increment,
  `Title` varchar(255) default NULL,
  `Date` datetime default NULL,
  `Description` varchar(255) default NULL,
  `Content` text,
  `Gallery_ID` int(11) default NULL,
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `resource_item_category`
--

CREATE TABLE IF NOT EXISTS `resource_item_category` (
  `ID` int(11) NOT NULL auto_increment,
  `Resource_ID` int(11) NOT NULL,
  `Category_ID` int(11) NOT NULL,
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `resource_link`
--

CREATE TABLE IF NOT EXISTS `resource_link` (
  `ID` int(11) NOT NULL auto_increment,
  `Resource_ID` int(11) NOT NULL,
  `Title` varchar(255) NOT NULL,
  `URL` varchar(255) NOT NULL,
  `Created` datetime NOT NULL,
  `Updated` datetime NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `resource_video`
--

CREATE TABLE IF NOT EXISTS `resource_video` (
  `ID` int(11) NOT NULL auto_increment,
  `Resource_ID` int(11) NOT NULL,
  `Title` varchar(255) default NULL,
  `URL` varchar(255) default NULL,
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `side_banner`
--

CREATE TABLE IF NOT EXISTS `side_banner` (
  `ID` int(11) NOT NULL auto_increment,
  `_undeletable` tinyint(1) default NULL,
  `Title` 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=InnoDB  DEFAULT CHARSET=latin1;

--
-- Table structure for table `side_banner_image`
--

CREATE TABLE IF NOT EXISTS `side_banner_image` (
  `ID` int(11) NOT NULL auto_increment,
  `Side_Banner_ID` int(11) default NULL,
  `Title` varchar(255) default NULL,
  `Alt` varchar(255) default NULL,
  `Description` text,
  `Link` varchar(255) default NULL,
  `Order_By` int(11) default NULL,
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  PRIMARY KEY  (`ID`),
  KEY `Banner_ID` (`Side_Banner_ID`),
  KEY `Order_By` (`Order_By`),
  KEY `Select` (`Side_Banner_ID`,`Order_By`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1;

--
-- Table structure for table `subscriber`
--

CREATE TABLE IF NOT EXISTS `subscriber` (
  `ID` int(11) NOT NULL auto_increment,
  `Title` varchar(255) default NULL,
  `Email` varchar(255) NOT NULL,
  `IP` varchar(255) NOT NULL,
  `Unsubscribed` tinyint(1) NOT NULL default '0',
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `subscriber`
--

INSERT INTO `subscriber` (`ID`, `Title`, `Email`, `Unsubscribed`, `Created`, `Updated`) VALUES
(1, 'William Stewart', 'wstewart@shropshiretourism.co.uk', 0, NOW(), NOW()),
(2, 'Kay Corbett', 'kcorbett@shropshiretourism.co.uk', 0, NOW(), NOW());

--
-- Table structure for table `subscriber_category`
--

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

--
-- Dumping data for table `subscriber_category`
--

INSERT INTO `subscriber_category` (`ID`, `Title`, `Order_By`, `Created`, `Updated`) VALUES
(1, 'Shropshire Tourism', 0, NOW(), NOW());

--
-- Table structure for table `subscriber_to_category`
--

CREATE TABLE IF NOT EXISTS `subscriber_to_category` (
  `ID` int(11) NOT NULL auto_increment,
  `Subscriber_ID` int(11) default NULL,
  `Category_ID` int(11) default NULL,
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `subscriber_to_category`
--

INSERT INTO `subscriber_to_category` (`ID`, `Subscriber_ID`, `Category_ID`, `Created`, `Updated`) VALUES
(1, 1, 1, NOW(), NOW()),
(2, 2, 1, NOW(), NOW());

--
-- Table structure for table `website_settings`
--

CREATE TABLE IF NOT EXISTS `website_settings` (
  `ID` int(11) NOT NULL auto_increment,
  `Settings_Ref` varchar(255) NOT NULL,
  `Value` varchar(255) NOT NULL,
  `Admin` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

--
-- Table structure for table `widget`
--

CREATE TABLE IF NOT EXISTS `widget` (
  `ID` int(11) NOT NULL auto_increment,
  `Title` varchar(255) NOT NULL,
  `Summary` text NOT NULL,
  `Featured` tinyint(1) NOT NULL default '0',
  `Content` text NOT NULL,
  `Published` tinyint(1) NOT NULL default '1', 
  `Subtitle` varchar(255) NOT NULL,
  `Gallery_ID` int(11) NOT NULL,
  `Banner_ID` int(11) NOT NULL,
  `Side_Banner_ID` int(11) NOT NULL,
  `Video_URL` varchar(255) NOT NULL,
  `SEO_Title` varchar(255) NOT NULL,
  `SEO_Keywords` varchar(255) NOT NULL,
  `SEO_Description` text NOT NULL,
  `Created` datetime NOT NULL,
  `Updated` datetime NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

INSERT INTO `widget` (`ID`, `Title`, `Summary`, `Featured`, `Content`, `Subtitle`, `Gallery_ID`, `Banner_ID`, `Side_Banner_ID`, `Video_URL`, `SEO_Title`, `SEO_Keywords`, `SEO_Description`, `Created`, `Updated`) VALUES
(1, 'Widget 1', 'Home Widget 1', 0, '<p>Home Widget 1</p>\r\n', 'Home Widget 1', 1, 0, 0, '', '', '', '', '2014-05-02 12:45:17', '2014-05-02 13:07:52'),
(2, 'Widget 2', 'Home Widget 2', 1, '<p>Home Widget 2</p>\r\n', 'Home Widget 2', 1, 0, 0, '', '', '', '', '2014-05-02 12:45:33', '2014-05-02 13:00:53'),
(3, 'Widget 3', 'Home Widget 3', 0, '<p>Home Widget 3</p>\r\n', 'Home Widget 3', 1, 0, 0, '', '', '', '', '2014-05-02 12:45:44', '2014-05-02 13:01:04'),
(5, 'Widget 4', 'Home Widget 4', 0, '<p>Home Widget 4</p>\r\n', 'Home Widget 4', 1, 0, 0, '', '', '', '', '2014-05-02 12:45:56', '2014-05-02 13:01:12'),
(6, 'Widget 5', 'Home Widget 5', 1, '<p>Home Widget 5</p>\r\n', 'Home Widget 5', 1, 0, 0, '', '', '', '', '2014-05-02 12:46:06', '2014-05-02 13:07:45');

--
-- Table structure for table `widget_category`
--

CREATE TABLE IF NOT EXISTS `widget_category` (
  `ID` int(11) NOT NULL auto_increment,
  `Title` varchar(255) default NULL,
  `Order_By` int(11) default NULL,
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

INSERT INTO `widget_category` (`ID`, `Title`, `Order_By`, `Created`, `Updated`) VALUES
(1, 'Home Widget', 0, '2014-05-02 12:44:47', '2014-05-02 12:44:47');

--
-- Table structure for table `widget_to_category`
--

CREATE TABLE IF NOT EXISTS `widget_to_category` (
  `ID` int(11) NOT NULL auto_increment,
  `Widget_ID` int(11) default NULL,
  `Category_ID` int(11) default NULL,
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

INSERT INTO `widget_to_category` (`ID`, `Widget_ID`, `Category_ID`, `Created`, `Updated`) VALUES
(1, 6, 1, '2014-05-02 12:46:14', '2014-05-02 12:46:14'),
(2, 1, 1, '2014-05-02 12:46:27', '2014-05-02 12:46:27'),
(3, 2, 1, '2014-05-02 12:46:34', '2014-05-02 12:46:35'),
(4, 3, 1, '2014-05-02 12:46:49', '2014-05-02 12:46:49'),
(5, 5, 1, '2014-05-02 12:48:02', '2014-05-02 12:48:02');