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;

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 ;

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;

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 ;