CREATE TABLE `pages` (
  `PageID` int(11) NOT NULL AUTO_INCREMENT,
  `MenuTitle` varchar(255) NOT NULL,
  `PageTitle` varchar(255) DEFAULT NULL,
  `URL` varchar(100) NOT NULL,
  `Tags` varchar(255) NOT NULL,
  `Content` text DEFAULT NULL,
  `ParentPageID` int(11) NOT NULL,
  `PageOrder` int(11) NOT NULL,
  `ShowHeader` int(1) NOT NULL,
  `ExternalLink` tinyint(1) DEFAULT NULL,
  `ExternalLinkUrl` varchar(255) DEFAULT NULL,
  `News` tinyint(1) NOT NULL,
  `Snippets1IDLNK` int(11) DEFAULT NULL,
  `SnippetFooterID` int(11) NOT NULL,
  `Published` tinyint(4) NOT NULL,
  `Hidden` tinyint(1) NOT NULL,
  `Private` tinyint(1) NOT NULL,
  `Template` int(11) NOT NULL,
  `SubHomepage` tinyint(4) NOT NULL,
  `Updated` datetime NOT NULL,
  `UpdatedByIDLNK` int(11) NOT NULL,
  `Icon` varchar(25) DEFAULT NULL,
  `VersionIDLNK` int(11) NOT NULL,
  `AllowOldVersions` tinyint(1) NOT NULL,
  `HeaderColour` varchar(6) DEFAULT NULL,
  `SnippetColour` varchar(6) DEFAULT NULL,
  `Deleted` tinyint(1) NOT NULL,
  PRIMARY KEY (`PageID`),
  KEY `isHomepage` (`Published`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1