--
-- Host: localhost    Database: ss
-- ------------------------------------------------------


--
-- Table structure for table `ContactPage`
--

CREATE TABLE `ContactPage` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Telephone` varchar(20) DEFAULT NULL,
  `Email` varchar(100) DEFAULT NULL,
  `Address1` varchar(50) DEFAULT NULL,
  `Address2` varchar(50) DEFAULT NULL,
  `TownCity` varchar(50) DEFAULT NULL,
  `Twitter` varchar(20) DEFAULT NULL,
  `Facebook` varchar(20) DEFAULT NULL,
  `Postcode` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ContactPage`
--

INSERT INTO `ContactPage` VALUES (3,'01904 123456','james@reetgood.co.uk','16 St Olave\'s Road','Bootham','York','reetgoodyork','reetgoodyorkfacebook','YO30 7AL');

--
-- Table structure for table `ContactPage_Live`
--

CREATE TABLE `ContactPage_Live` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Telephone` varchar(20) DEFAULT NULL,
  `Email` varchar(100) DEFAULT NULL,
  `Address1` varchar(50) DEFAULT NULL,
  `Address2` varchar(50) DEFAULT NULL,
  `TownCity` varchar(50) DEFAULT NULL,
  `Twitter` varchar(20) DEFAULT NULL,
  `Facebook` varchar(20) DEFAULT NULL,
  `Postcode` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ContactPage_Live`
--

INSERT INTO `ContactPage_Live` VALUES (3,'01904 123456','james@reetgood.co.uk','16 St Olave\'s Road','Bootham','York','reetgoodyork','reetgoodyorkfacebook','YO30 7AL');

--
-- Table structure for table `ContactPage_versions`
--

CREATE TABLE `ContactPage_versions` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `RecordID` int(11) NOT NULL DEFAULT '0',
  `Version` int(11) NOT NULL DEFAULT '0',
  `Telephone` varchar(20) DEFAULT NULL,
  `Email` varchar(100) DEFAULT NULL,
  `Address1` varchar(50) DEFAULT NULL,
  `Address2` varchar(50) DEFAULT NULL,
  `TownCity` varchar(50) DEFAULT NULL,
  `Twitter` varchar(20) DEFAULT NULL,
  `Facebook` varchar(20) DEFAULT NULL,
  `Postcode` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `RecordID_Version` (`RecordID`,`Version`),
  KEY `RecordID` (`RecordID`),
  KEY `Version` (`Version`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ContactPage_versions`
--

INSERT INTO `ContactPage_versions` VALUES (1,3,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `ContactPage_versions` VALUES (2,3,3,'01904 123456','james@reetgood.co.uk','16 St Olave\'s Road','Bootham','York','reetgoodyork','reetgoodyorkfacebook',NULL);
INSERT INTO `ContactPage_versions` VALUES (3,3,4,'01904 123456','james@reetgood.co.uk','16 St Olave\'s Road','Bootham','York','reetgoodyork','reetgoodyorkfacebook',NULL);
INSERT INTO `ContactPage_versions` VALUES (4,3,5,'01904 123456','james@reetgood.co.uk','16 St Olave\'s Road','Bootham','York','reetgoodyork','reetgoodyorkfacebook',NULL);
INSERT INTO `ContactPage_versions` VALUES (5,3,6,'01904 123456','james@reetgood.co.uk','16 St Olave\'s Road','Bootham','York','reetgoodyork','reetgoodyorkfacebook','YO30 7AL');

--
-- Table structure for table `ErrorPage`
--

CREATE TABLE `ErrorPage` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `ErrorCode` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ErrorPage`
--

INSERT INTO `ErrorPage` VALUES (4,404);
INSERT INTO `ErrorPage` VALUES (5,500);

--
-- Table structure for table `ErrorPage_Live`
--

CREATE TABLE `ErrorPage_Live` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `ErrorCode` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ErrorPage_Live`
--

INSERT INTO `ErrorPage_Live` VALUES (4,404);
INSERT INTO `ErrorPage_Live` VALUES (5,500);

--
-- Table structure for table `ErrorPage_versions`
--

CREATE TABLE `ErrorPage_versions` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `RecordID` int(11) NOT NULL DEFAULT '0',
  `Version` int(11) NOT NULL DEFAULT '0',
  `ErrorCode` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `RecordID_Version` (`RecordID`,`Version`),
  KEY `RecordID` (`RecordID`),
  KEY `Version` (`Version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ErrorPage_versions`
--


--
-- Table structure for table `File`
--

CREATE TABLE `File` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `ClassName` enum('File','Folder','Image','Image_Cached') DEFAULT 'File',
  `LastEdited` datetime DEFAULT NULL,
  `Created` datetime DEFAULT NULL,
  `Name` varchar(255) DEFAULT NULL,
  `Title` varchar(255) DEFAULT NULL,
  `Filename` mediumtext,
  `Content` mediumtext,
  `ShowInSearch` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `ParentID` int(11) NOT NULL DEFAULT '0',
  `OwnerID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `ParentID` (`ParentID`),
  KEY `OwnerID` (`OwnerID`),
  KEY `ClassName` (`ClassName`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `File`
--

INSERT INTO `File` VALUES (1,'Folder','2017-07-11 19:13:32','2017-07-11 19:13:32','Uploads','Uploads','assets/Uploads/',NULL,1,0,1);
INSERT INTO `File` VALUES (2,'Image','2017-07-11 19:13:53','2017-07-11 19:13:32','sarah-brown.jpg','Sarah Brown','assets/Uploads/sarah-brown.jpg',NULL,1,1,1);
INSERT INTO `File` VALUES (3,'Image','2017-07-11 20:01:24','2017-07-11 20:01:24','team-bg.jpg','team bg','assets/Uploads/team-bg.jpg',NULL,1,1,1);
INSERT INTO `File` VALUES (4,'Image','2017-07-11 21:34:37','2017-07-11 21:34:37','home-bg.jpg','home bg','assets/Uploads/home-bg.jpg',NULL,1,1,1);
INSERT INTO `File` VALUES (5,'Image','2017-07-20 18:31:29','2017-07-20 18:31:29','contact-bg.jpg','contact bg','assets/Uploads/contact-bg.jpg',NULL,1,1,1);

--
-- Table structure for table `GlossaryEntry`
--

CREATE TABLE `GlossaryEntry` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `ClassName` enum('GlossaryEntry') DEFAULT 'GlossaryEntry',
  `LastEdited` datetime DEFAULT NULL,
  `Created` datetime DEFAULT NULL,
  `Title` varchar(30) DEFAULT NULL,
  `Details` varchar(250) DEFAULT NULL,
  `GlossaryID` int(11) NOT NULL DEFAULT '0',
  `ImageID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `GlossaryID` (`GlossaryID`),
  KEY `ImageID` (`ImageID`),
  KEY `ClassName` (`ClassName`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `GlossaryEntry`
--

INSERT INTO `GlossaryEntry` VALUES (1,'GlossaryEntry','2017-06-05 16:10:54','2017-06-05 16:10:41','Abrade','To grind away the coloured upper surface of a flashed glass, revealing the base glass beneath. Tell-tale scratches left by the grinding tool will often remain around the edges of the abraded area. This technique is most commonly found in the context ',6,0);
INSERT INTO `GlossaryEntry` VALUES (2,'GlossaryEntry','2017-06-12 17:28:55','2017-06-12 17:28:55','Banana','Banana text',6,0);
INSERT INTO `GlossaryEntry` VALUES (3,'GlossaryEntry','2017-06-12 17:30:55','2017-06-12 17:30:55','Zebra','Zebra text',6,0);
INSERT INTO `GlossaryEntry` VALUES (4,'GlossaryEntry','2017-06-12 17:31:09','2017-06-12 17:31:09','Beach Ball','Beach ball details',6,0);

--
-- Table structure for table `Group`
--

CREATE TABLE `Group` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `ClassName` enum('Group') DEFAULT 'Group',
  `LastEdited` datetime DEFAULT NULL,
  `Created` datetime DEFAULT NULL,
  `Title` varchar(255) DEFAULT NULL,
  `Description` mediumtext,
  `Code` varchar(255) DEFAULT NULL,
  `Locked` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `Sort` int(11) NOT NULL DEFAULT '0',
  `HtmlEditorConfig` mediumtext,
  `ParentID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `ParentID` (`ParentID`),
  KEY `ClassName` (`ClassName`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Group`
--

INSERT INTO `Group` VALUES (1,'Group','2017-05-11 09:48:32','2017-05-11 09:48:32','Content Authors',NULL,'content-authors',0,1,NULL,0);
INSERT INTO `Group` VALUES (2,'Group','2017-05-11 09:48:33','2017-05-11 09:48:33','Administrators',NULL,'administrators',0,0,NULL,0);

--
-- Table structure for table `Group_Members`
--

CREATE TABLE `Group_Members` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `GroupID` int(11) NOT NULL DEFAULT '0',
  `MemberID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `GroupID` (`GroupID`),
  KEY `MemberID` (`MemberID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Group_Members`
--

INSERT INTO `Group_Members` VALUES (1,2,1);

--
-- Table structure for table `Group_Roles`
--

CREATE TABLE `Group_Roles` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `GroupID` int(11) NOT NULL DEFAULT '0',
  `PermissionRoleID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `GroupID` (`GroupID`),
  KEY `PermissionRoleID` (`PermissionRoleID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Group_Roles`
--


--
-- Table structure for table `HomePage`
--

CREATE TABLE `HomePage` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `FeaturedProductTitle` varchar(50) DEFAULT NULL,
  `TeamTitle` varchar(50) DEFAULT NULL,
  `TeamContent` mediumtext,
  `ReadingListContent` mediumtext,
  `TeamImageID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `TeamImageID` (`TeamImageID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `HomePage`
--

INSERT INTO `HomePage` VALUES (1,NULL,NULL,NULL,NULL,0);

--
-- Table structure for table `HomePage_Live`
--

CREATE TABLE `HomePage_Live` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `FeaturedProductTitle` varchar(50) DEFAULT NULL,
  `TeamTitle` varchar(50) DEFAULT NULL,
  `TeamContent` mediumtext,
  `ReadingListContent` mediumtext,
  `TeamImageID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `TeamImageID` (`TeamImageID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `HomePage_Live`
--

INSERT INTO `HomePage_Live` VALUES (1,NULL,NULL,NULL,NULL,0);

--
-- Table structure for table `HomePage_versions`
--

CREATE TABLE `HomePage_versions` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `RecordID` int(11) NOT NULL DEFAULT '0',
  `Version` int(11) NOT NULL DEFAULT '0',
  `FeaturedProductTitle` varchar(50) DEFAULT NULL,
  `TeamTitle` varchar(50) DEFAULT NULL,
  `TeamContent` mediumtext,
  `ReadingListContent` mediumtext,
  `TeamImageID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `RecordID_Version` (`RecordID`,`Version`),
  KEY `RecordID` (`RecordID`),
  KEY `Version` (`Version`),
  KEY `TeamImageID` (`TeamImageID`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `HomePage_versions`
--

INSERT INTO `HomePage_versions` VALUES (1,1,3,NULL,NULL,NULL,NULL,0);
INSERT INTO `HomePage_versions` VALUES (2,1,4,NULL,NULL,NULL,NULL,0);
INSERT INTO `HomePage_versions` VALUES (3,1,5,NULL,NULL,NULL,NULL,0);

--
-- Table structure for table `LoginAttempt`
--

CREATE TABLE `LoginAttempt` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `ClassName` enum('LoginAttempt') DEFAULT 'LoginAttempt',
  `LastEdited` datetime DEFAULT NULL,
  `Created` datetime DEFAULT NULL,
  `Email` varchar(255) DEFAULT NULL,
  `Status` enum('Success','Failure') DEFAULT 'Success',
  `IP` varchar(255) DEFAULT NULL,
  `MemberID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `MemberID` (`MemberID`),
  KEY `ClassName` (`ClassName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `LoginAttempt`
--


--
-- Table structure for table `Page`
--

CREATE TABLE `Page` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `MainImageID` int(11) NOT NULL DEFAULT '0',
  `MainImageCaption` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `MainImageID` (`MainImageID`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Page`
--

INSERT INTO `Page` VALUES (1,4,'50 years of Excellence in Stained Glass Craft and conservation, 1967 – 2017');
INSERT INTO `Page` VALUES (3,5,NULL);
INSERT INTO `Page` VALUES (6,0,NULL);
INSERT INTO `Page` VALUES (9,3,'Caption Test');

--
-- Table structure for table `Page_Live`
--

CREATE TABLE `Page_Live` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `MainImageID` int(11) NOT NULL DEFAULT '0',
  `MainImageCaption` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `MainImageID` (`MainImageID`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Page_Live`
--

INSERT INTO `Page_Live` VALUES (1,4,'50 years of Excellence in Stained Glass Craft and conservation, 1967 – 2017');
INSERT INTO `Page_Live` VALUES (3,5,NULL);
INSERT INTO `Page_Live` VALUES (6,0,NULL);
INSERT INTO `Page_Live` VALUES (9,3,'Caption Test');

--
-- Table structure for table `Page_versions`
--

CREATE TABLE `Page_versions` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `RecordID` int(11) NOT NULL DEFAULT '0',
  `Version` int(11) NOT NULL DEFAULT '0',
  `MainImageID` int(11) NOT NULL DEFAULT '0',
  `MainImageCaption` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `RecordID_Version` (`RecordID`,`Version`),
  KEY `RecordID` (`RecordID`),
  KEY `Version` (`Version`),
  KEY `MainImageID` (`MainImageID`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Page_versions`
--

INSERT INTO `Page_versions` VALUES (1,3,2,0,NULL);
INSERT INTO `Page_versions` VALUES (2,6,1,0,NULL);
INSERT INTO `Page_versions` VALUES (3,6,2,0,NULL);
INSERT INTO `Page_versions` VALUES (4,3,3,0,NULL);
INSERT INTO `Page_versions` VALUES (5,3,4,0,NULL);
INSERT INTO `Page_versions` VALUES (6,7,1,0,NULL);
INSERT INTO `Page_versions` VALUES (7,8,1,0,NULL);
INSERT INTO `Page_versions` VALUES (8,9,1,0,NULL);
INSERT INTO `Page_versions` VALUES (9,9,2,0,NULL);
INSERT INTO `Page_versions` VALUES (10,9,3,3,NULL);
INSERT INTO `Page_versions` VALUES (11,9,4,3,NULL);
INSERT INTO `Page_versions` VALUES (12,9,5,3,'Caption Test');
INSERT INTO `Page_versions` VALUES (13,1,3,4,'50 years of Excellence in Stained Glass Craft and conservation, 1967 – 2017');
INSERT INTO `Page_versions` VALUES (14,1,4,4,'50 years of Excellence in Stained Glass Craft and conservation, 1967 – 2017');
INSERT INTO `Page_versions` VALUES (15,3,5,5,NULL);
INSERT INTO `Page_versions` VALUES (16,3,6,5,NULL);
INSERT INTO `Page_versions` VALUES (17,1,5,4,'50 years of Excellence in Stained Glass Craft and conservation, 1967 – 2017');

--
-- Table structure for table `Permission`
--

CREATE TABLE `Permission` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `ClassName` enum('Permission') DEFAULT 'Permission',
  `LastEdited` datetime DEFAULT NULL,
  `Created` datetime DEFAULT NULL,
  `Code` varchar(255) DEFAULT NULL,
  `Arg` int(11) NOT NULL DEFAULT '0',
  `Type` int(11) NOT NULL DEFAULT '1',
  `GroupID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `GroupID` (`GroupID`),
  KEY `Code` (`Code`),
  KEY `ClassName` (`ClassName`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Permission`
--

INSERT INTO `Permission` VALUES (1,'Permission','2017-05-11 09:48:33','2017-05-11 09:48:33','CMS_ACCESS_CMSMain',0,1,1);
INSERT INTO `Permission` VALUES (2,'Permission','2017-05-11 09:48:33','2017-05-11 09:48:33','CMS_ACCESS_AssetAdmin',0,1,1);
INSERT INTO `Permission` VALUES (3,'Permission','2017-05-11 09:48:33','2017-05-11 09:48:33','CMS_ACCESS_ReportAdmin',0,1,1);
INSERT INTO `Permission` VALUES (4,'Permission','2017-05-11 09:48:33','2017-05-11 09:48:33','SITETREE_REORGANISE',0,1,1);
INSERT INTO `Permission` VALUES (5,'Permission','2017-05-11 09:48:33','2017-05-11 09:48:33','ADMIN',0,1,2);

--
-- Table structure for table `PermissionRole`
--

CREATE TABLE `PermissionRole` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `ClassName` enum('PermissionRole') DEFAULT 'PermissionRole',
  `LastEdited` datetime DEFAULT NULL,
  `Created` datetime DEFAULT NULL,
  `Title` varchar(50) DEFAULT NULL,
  `OnlyAdminCanApply` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `ClassName` (`ClassName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `PermissionRole`
--


--
-- Table structure for table `PermissionRoleCode`
--

CREATE TABLE `PermissionRoleCode` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `ClassName` enum('PermissionRoleCode') DEFAULT 'PermissionRoleCode',
  `LastEdited` datetime DEFAULT NULL,
  `Created` datetime DEFAULT NULL,
  `Code` varchar(50) DEFAULT NULL,
  `RoleID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `RoleID` (`RoleID`),
  KEY `ClassName` (`ClassName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `PermissionRoleCode`
--


--
-- Table structure for table `RedirectorPage`
--

CREATE TABLE `RedirectorPage` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `RedirectionType` enum('Internal','External') DEFAULT 'Internal',
  `ExternalURL` varchar(2083) DEFAULT NULL,
  `LinkToID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `LinkToID` (`LinkToID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `RedirectorPage`
--


--
-- Table structure for table `RedirectorPage_Live`
--

CREATE TABLE `RedirectorPage_Live` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `RedirectionType` enum('Internal','External') DEFAULT 'Internal',
  `ExternalURL` varchar(2083) DEFAULT NULL,
  `LinkToID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `LinkToID` (`LinkToID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `RedirectorPage_Live`
--


--
-- Table structure for table `RedirectorPage_versions`
--

CREATE TABLE `RedirectorPage_versions` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `RecordID` int(11) NOT NULL DEFAULT '0',
  `Version` int(11) NOT NULL DEFAULT '0',
  `RedirectionType` enum('Internal','External') DEFAULT 'Internal',
  `ExternalURL` varchar(2083) DEFAULT NULL,
  `LinkToID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `RecordID_Version` (`RecordID`,`Version`),
  KEY `RecordID` (`RecordID`),
  KEY `Version` (`Version`),
  KEY `LinkToID` (`LinkToID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `RedirectorPage_versions`
--


--
-- Table structure for table `SiteConfig`
--

CREATE TABLE `SiteConfig` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `ClassName` enum('SiteConfig') DEFAULT 'SiteConfig',
  `LastEdited` datetime DEFAULT NULL,
  `Created` datetime DEFAULT NULL,
  `Title` varchar(255) DEFAULT NULL,
  `Tagline` varchar(255) DEFAULT NULL,
  `Theme` varchar(255) DEFAULT NULL,
  `CanViewType` enum('Anyone','LoggedInUsers','OnlyTheseUsers') DEFAULT 'Anyone',
  `CanEditType` enum('LoggedInUsers','OnlyTheseUsers') DEFAULT 'LoggedInUsers',
  `CanCreateTopLevelType` enum('LoggedInUsers','OnlyTheseUsers') DEFAULT 'LoggedInUsers',
  PRIMARY KEY (`ID`),
  KEY `ClassName` (`ClassName`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `SiteConfig`
--

INSERT INTO `SiteConfig` VALUES (1,'SiteConfig','2017-05-11 09:48:33','2017-05-11 09:48:33','Your Site Name','your tagline here',NULL,'Anyone','LoggedInUsers','LoggedInUsers');

--
-- Table structure for table `SiteConfig_CreateTopLevelGroups`
--

CREATE TABLE `SiteConfig_CreateTopLevelGroups` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `SiteConfigID` int(11) NOT NULL DEFAULT '0',
  `GroupID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `SiteConfigID` (`SiteConfigID`),
  KEY `GroupID` (`GroupID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `SiteConfig_CreateTopLevelGroups`
--


--
-- Table structure for table `SiteConfig_EditorGroups`
--

CREATE TABLE `SiteConfig_EditorGroups` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `SiteConfigID` int(11) NOT NULL DEFAULT '0',
  `GroupID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `SiteConfigID` (`SiteConfigID`),
  KEY `GroupID` (`GroupID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `SiteConfig_EditorGroups`
--


--
-- Table structure for table `SiteConfig_ViewerGroups`
--

CREATE TABLE `SiteConfig_ViewerGroups` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `SiteConfigID` int(11) NOT NULL DEFAULT '0',
  `GroupID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `SiteConfigID` (`SiteConfigID`),
  KEY `GroupID` (`GroupID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `SiteConfig_ViewerGroups`
--


--
-- Table structure for table `SiteTree`
--

CREATE TABLE `SiteTree` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `ClassName` enum('SiteTree','Page','ErrorPage','RedirectorPage','VirtualPage','ContactPage','GlossaryPage','HomePage','ServicePage','TeamPage') DEFAULT 'SiteTree',
  `LastEdited` datetime DEFAULT NULL,
  `Created` datetime DEFAULT NULL,
  `URLSegment` varchar(255) DEFAULT NULL,
  `Title` varchar(255) DEFAULT NULL,
  `MenuTitle` varchar(100) DEFAULT NULL,
  `Content` mediumtext,
  `MetaDescription` mediumtext,
  `ExtraMeta` mediumtext,
  `ShowInMenus` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `ShowInSearch` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `Sort` int(11) NOT NULL DEFAULT '0',
  `HasBrokenFile` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `HasBrokenLink` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `ReportClass` varchar(50) DEFAULT NULL,
  `CanViewType` enum('Anyone','LoggedInUsers','OnlyTheseUsers','Inherit') DEFAULT 'Inherit',
  `CanEditType` enum('LoggedInUsers','OnlyTheseUsers','Inherit') DEFAULT 'Inherit',
  `MetaTitle` varchar(255) DEFAULT NULL,
  `Version` int(11) NOT NULL DEFAULT '0',
  `ParentID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `ParentID` (`ParentID`),
  KEY `URLSegment` (`URLSegment`),
  KEY `ClassName` (`ClassName`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `SiteTree`
--

INSERT INTO `SiteTree` VALUES (1,'HomePage','2017-07-20 18:57:25','2017-05-11 09:48:33','home','The York Glaziers Trust','Home',NULL,NULL,NULL,1,1,1,0,0,NULL,'Inherit','Inherit',NULL,5,0);
INSERT INTO `SiteTree` VALUES (2,'Page','2017-05-11 09:48:33','2017-05-11 09:48:33','about-us','About Us',NULL,'<p>You can fill this page out with your own content, or delete it and create your own pages.<br></p>',NULL,NULL,1,1,2,0,0,NULL,'Inherit','Inherit',NULL,1,0);
INSERT INTO `SiteTree` VALUES (3,'ContactPage','2017-07-20 18:52:11','2017-05-11 09:48:33','contact-us','Contact Us',NULL,'<p>You can fill this page out with your own content, or delete it and create your own pages.<br></p>',NULL,NULL,1,1,3,0,0,NULL,'Inherit','Inherit',NULL,6,0);
INSERT INTO `SiteTree` VALUES (4,'ErrorPage','2017-05-11 09:48:33','2017-05-11 09:48:33','page-not-found','Page not found',NULL,'<p>Sorry, it seems you were trying to access a page that doesn\'t exist.</p><p>Please check the spelling of the URL you were trying to access and try again.</p>',NULL,NULL,0,0,4,0,0,NULL,'Inherit','Inherit',NULL,1,0);
INSERT INTO `SiteTree` VALUES (5,'ErrorPage','2017-05-11 09:48:33','2017-05-11 09:48:33','server-error','Server error',NULL,'<p>Sorry, there was a problem handling your request.</p>',NULL,NULL,0,0,5,0,0,NULL,'Inherit','Inherit',NULL,1,0);
INSERT INTO `SiteTree` VALUES (6,'GlossaryPage','2017-06-05 15:00:50','2017-06-05 15:00:37','illustrated-glossary','Illustrated Glossary',NULL,NULL,NULL,NULL,1,1,6,0,0,NULL,'Inherit','Inherit',NULL,2,0);
INSERT INTO `SiteTree` VALUES (9,'TeamPage','2017-07-11 20:16:51','2017-06-12 17:45:09','team','Meet The Team','Team',NULL,NULL,NULL,1,1,7,0,0,NULL,'Inherit','Inherit',NULL,5,0);

--
-- Table structure for table `SiteTree_EditorGroups`
--

CREATE TABLE `SiteTree_EditorGroups` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `SiteTreeID` int(11) NOT NULL DEFAULT '0',
  `GroupID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `SiteTreeID` (`SiteTreeID`),
  KEY `GroupID` (`GroupID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `SiteTree_EditorGroups`
--


--
-- Table structure for table `SiteTree_ImageTracking`
--

CREATE TABLE `SiteTree_ImageTracking` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `SiteTreeID` int(11) NOT NULL DEFAULT '0',
  `FileID` int(11) NOT NULL DEFAULT '0',
  `FieldName` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `SiteTreeID` (`SiteTreeID`),
  KEY `FileID` (`FileID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `SiteTree_ImageTracking`
--


--
-- Table structure for table `SiteTree_LinkTracking`
--

CREATE TABLE `SiteTree_LinkTracking` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `SiteTreeID` int(11) NOT NULL DEFAULT '0',
  `ChildID` int(11) NOT NULL DEFAULT '0',
  `FieldName` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `SiteTreeID` (`SiteTreeID`),
  KEY `ChildID` (`ChildID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `SiteTree_LinkTracking`
--


--
-- Table structure for table `SiteTree_Live`
--

CREATE TABLE `SiteTree_Live` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `ClassName` enum('SiteTree','Page','ErrorPage','RedirectorPage','VirtualPage','ContactPage','GlossaryPage','HomePage','ServicePage','TeamPage') DEFAULT 'SiteTree',
  `LastEdited` datetime DEFAULT NULL,
  `Created` datetime DEFAULT NULL,
  `URLSegment` varchar(255) DEFAULT NULL,
  `Title` varchar(255) DEFAULT NULL,
  `MenuTitle` varchar(100) DEFAULT NULL,
  `Content` mediumtext,
  `MetaDescription` mediumtext,
  `ExtraMeta` mediumtext,
  `ShowInMenus` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `ShowInSearch` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `Sort` int(11) NOT NULL DEFAULT '0',
  `HasBrokenFile` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `HasBrokenLink` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `ReportClass` varchar(50) DEFAULT NULL,
  `CanViewType` enum('Anyone','LoggedInUsers','OnlyTheseUsers','Inherit') DEFAULT 'Inherit',
  `CanEditType` enum('LoggedInUsers','OnlyTheseUsers','Inherit') DEFAULT 'Inherit',
  `MetaTitle` varchar(255) DEFAULT NULL,
  `Version` int(11) NOT NULL DEFAULT '0',
  `ParentID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `ParentID` (`ParentID`),
  KEY `URLSegment` (`URLSegment`),
  KEY `ClassName` (`ClassName`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `SiteTree_Live`
--

INSERT INTO `SiteTree_Live` VALUES (1,'HomePage','2017-07-20 18:57:25','2017-05-11 09:48:33','home','The York Glaziers Trust','Home',NULL,NULL,NULL,1,1,1,0,0,NULL,'Inherit','Inherit',NULL,5,0);
INSERT INTO `SiteTree_Live` VALUES (2,'Page','2017-05-11 09:48:33','2017-05-11 09:48:33','about-us','About Us',NULL,'<p>You can fill this page out with your own content, or delete it and create your own pages.<br></p>',NULL,NULL,1,1,2,0,0,NULL,'Inherit','Inherit',NULL,1,0);
INSERT INTO `SiteTree_Live` VALUES (3,'ContactPage','2017-07-20 18:52:11','2017-05-11 09:48:33','contact-us','Contact Us',NULL,'<p>You can fill this page out with your own content, or delete it and create your own pages.<br></p>',NULL,NULL,1,1,3,0,0,NULL,'Inherit','Inherit',NULL,6,0);
INSERT INTO `SiteTree_Live` VALUES (4,'ErrorPage','2017-05-11 09:48:33','2017-05-11 09:48:33','page-not-found','Page not found',NULL,'<p>Sorry, it seems you were trying to access a page that doesn\'t exist.</p><p>Please check the spelling of the URL you were trying to access and try again.</p>',NULL,NULL,0,0,4,0,0,NULL,'Inherit','Inherit',NULL,1,0);
INSERT INTO `SiteTree_Live` VALUES (5,'ErrorPage','2017-05-11 09:48:33','2017-05-11 09:48:33','server-error','Server error',NULL,'<p>Sorry, there was a problem handling your request.</p>',NULL,NULL,0,0,5,0,0,NULL,'Inherit','Inherit',NULL,1,0);
INSERT INTO `SiteTree_Live` VALUES (6,'GlossaryPage','2017-06-05 15:00:50','2017-06-05 15:00:37','illustrated-glossary','Illustrated Glossary',NULL,NULL,NULL,NULL,1,1,6,0,0,NULL,'Inherit','Inherit',NULL,2,0);
INSERT INTO `SiteTree_Live` VALUES (9,'TeamPage','2017-07-11 20:16:51','2017-06-12 17:45:09','team','Meet The Team','Team',NULL,NULL,NULL,1,1,7,0,0,NULL,'Inherit','Inherit',NULL,5,0);

--
-- Table structure for table `SiteTree_ViewerGroups`
--

CREATE TABLE `SiteTree_ViewerGroups` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `SiteTreeID` int(11) NOT NULL DEFAULT '0',
  `GroupID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `SiteTreeID` (`SiteTreeID`),
  KEY `GroupID` (`GroupID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `SiteTree_ViewerGroups`
--


--
-- Table structure for table `SiteTree_versions`
--

CREATE TABLE `SiteTree_versions` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `RecordID` int(11) NOT NULL DEFAULT '0',
  `Version` int(11) NOT NULL DEFAULT '0',
  `WasPublished` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `AuthorID` int(11) NOT NULL DEFAULT '0',
  `PublisherID` int(11) NOT NULL DEFAULT '0',
  `ClassName` enum('SiteTree','Page','ErrorPage','RedirectorPage','VirtualPage','ContactPage','GlossaryPage','HomePage','ServicePage','TeamPage') DEFAULT 'SiteTree',
  `LastEdited` datetime DEFAULT NULL,
  `Created` datetime DEFAULT NULL,
  `URLSegment` varchar(255) DEFAULT NULL,
  `Title` varchar(255) DEFAULT NULL,
  `MenuTitle` varchar(100) DEFAULT NULL,
  `Content` mediumtext,
  `MetaDescription` mediumtext,
  `ExtraMeta` mediumtext,
  `ShowInMenus` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `ShowInSearch` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `Sort` int(11) NOT NULL DEFAULT '0',
  `HasBrokenFile` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `HasBrokenLink` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `ReportClass` varchar(50) DEFAULT NULL,
  `CanViewType` enum('Anyone','LoggedInUsers','OnlyTheseUsers','Inherit') DEFAULT 'Inherit',
  `CanEditType` enum('LoggedInUsers','OnlyTheseUsers','Inherit') DEFAULT 'Inherit',
  `MetaTitle` varchar(255) DEFAULT NULL,
  `ParentID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `RecordID_Version` (`RecordID`,`Version`),
  KEY `RecordID` (`RecordID`),
  KEY `Version` (`Version`),
  KEY `AuthorID` (`AuthorID`),
  KEY `PublisherID` (`PublisherID`),
  KEY `ParentID` (`ParentID`),
  KEY `URLSegment` (`URLSegment`),
  KEY `ClassName` (`ClassName`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `SiteTree_versions`
--

INSERT INTO `SiteTree_versions` VALUES (1,1,1,1,0,0,'Page','2017-05-11 09:48:33','2017-05-11 09:48:33','home','Home',NULL,'<p>Welcome to SilverStripe! This is the default home page. You can edit this page by opening <a href=\"admin/\">the CMS</a>. You can now access the <a href=\"http://doc.silverstripe.org\">developer documentation</a>, or begin <a href=\"http://doc.silverstripe.org/doku.php?id=tutorials\">the tutorials.</a></p>',NULL,NULL,1,1,1,0,0,NULL,'Inherit','Inherit',NULL,0);
INSERT INTO `SiteTree_versions` VALUES (2,2,1,1,0,0,'Page','2017-05-11 09:48:33','2017-05-11 09:48:33','about-us','About Us',NULL,'<p>You can fill this page out with your own content, or delete it and create your own pages.<br></p>',NULL,NULL,1,1,2,0,0,NULL,'Inherit','Inherit',NULL,0);
INSERT INTO `SiteTree_versions` VALUES (3,3,1,1,0,0,'Page','2017-05-11 09:48:33','2017-05-11 09:48:33','contact-us','Contact Us',NULL,'<p>You can fill this page out with your own content, or delete it and create your own pages.<br></p>',NULL,NULL,1,1,3,0,0,NULL,'Inherit','Inherit',NULL,0);
INSERT INTO `SiteTree_versions` VALUES (4,4,1,1,0,0,'ErrorPage','2017-05-11 09:48:33','2017-05-11 09:48:33','page-not-found','Page not found',NULL,'<p>Sorry, it seems you were trying to access a page that doesn\'t exist.</p><p>Please check the spelling of the URL you were trying to access and try again.</p>',NULL,NULL,0,0,4,0,0,NULL,'Inherit','Inherit',NULL,0);
INSERT INTO `SiteTree_versions` VALUES (5,5,1,1,0,0,'ErrorPage','2017-05-11 09:48:33','2017-05-11 09:48:33','server-error','Server error',NULL,'<p>Sorry, there was a problem handling your request.</p>',NULL,NULL,0,0,5,0,0,NULL,'Inherit','Inherit',NULL,0);
INSERT INTO `SiteTree_versions` VALUES (6,1,2,1,1,1,'HomePage','2017-05-11 10:37:04','2017-05-11 09:48:33','home','Home',NULL,'<p>Welcome to SilverStripe! This is the default home page. You can edit this page by opening <a href=\"admin/\">the CMS</a>. You can now access the <a href=\"http://doc.silverstripe.org\">developer documentation</a>, or begin <a href=\"http://doc.silverstripe.org/doku.php?id=tutorials\">the tutorials.</a></p>',NULL,NULL,1,1,1,0,0,NULL,'Inherit','Inherit',NULL,0);
INSERT INTO `SiteTree_versions` VALUES (7,3,2,1,1,1,'ContactPage','2017-06-02 09:52:43','2017-05-11 09:48:33','contact-us','Contact Us',NULL,'<p>You can fill this page out with your own content, or delete it and create your own pages.<br></p>',NULL,NULL,1,1,3,0,0,NULL,'Inherit','Inherit',NULL,0);
INSERT INTO `SiteTree_versions` VALUES (8,6,1,0,1,0,'GlossaryPage','2017-06-05 15:00:37','2017-06-05 15:00:37','new-glossary-page','New Glossary Page',NULL,NULL,NULL,NULL,1,1,6,0,0,NULL,'Inherit','Inherit',NULL,0);
INSERT INTO `SiteTree_versions` VALUES (9,6,2,1,1,1,'GlossaryPage','2017-06-05 15:00:50','2017-06-05 15:00:37','illustrated-glossary','Illustrated Glossary',NULL,NULL,NULL,NULL,1,1,6,0,0,NULL,'Inherit','Inherit',NULL,0);
INSERT INTO `SiteTree_versions` VALUES (10,3,3,1,1,1,'ContactPage','2017-06-12 17:08:16','2017-05-11 09:48:33','contact-us','Contact Us',NULL,'<p>You can fill this page out with your own content, or delete it and create your own pages.<br></p>',NULL,NULL,1,1,3,0,0,NULL,'Inherit','Inherit',NULL,0);
INSERT INTO `SiteTree_versions` VALUES (11,3,4,1,1,1,'ContactPage','2017-06-12 17:13:56','2017-05-11 09:48:33','contact-us','Contact Us',NULL,'<p>You can fill this page out with your own content, or delete it and create your own pages.<br></p>',NULL,NULL,1,1,3,0,0,NULL,'Inherit','Inherit',NULL,0);
INSERT INTO `SiteTree_versions` VALUES (12,7,1,0,1,0,'TeamPage','2017-06-12 17:23:26','2017-06-12 17:23:26','new-team-page','New Team Page',NULL,NULL,NULL,NULL,1,1,1,0,0,NULL,'Inherit','Inherit',NULL,3);
INSERT INTO `SiteTree_versions` VALUES (13,8,1,0,1,0,'GlossaryPage','2017-06-12 17:25:24','2017-06-12 17:25:24','new-glossary-page','New Glossary Page',NULL,NULL,NULL,NULL,1,1,7,0,0,NULL,'Inherit','Inherit',NULL,0);
INSERT INTO `SiteTree_versions` VALUES (14,9,1,0,1,0,'TeamPage','2017-06-12 17:45:09','2017-06-12 17:45:09','new-team-page','New Team Page',NULL,NULL,NULL,NULL,1,1,7,0,0,NULL,'Inherit','Inherit',NULL,0);
INSERT INTO `SiteTree_versions` VALUES (15,9,2,1,1,1,'TeamPage','2017-06-12 17:45:18','2017-06-12 17:45:09','team','Team',NULL,NULL,NULL,NULL,1,1,7,0,0,NULL,'Inherit','Inherit',NULL,0);
INSERT INTO `SiteTree_versions` VALUES (16,9,3,1,1,1,'TeamPage','2017-07-11 20:02:14','2017-06-12 17:45:09','team','Team',NULL,NULL,NULL,NULL,1,1,7,0,0,NULL,'Inherit','Inherit',NULL,0);
INSERT INTO `SiteTree_versions` VALUES (17,9,4,1,1,1,'TeamPage','2017-07-11 20:08:22','2017-06-12 17:45:09','team','Meet The Team','Team',NULL,NULL,NULL,1,1,7,0,0,NULL,'Inherit','Inherit',NULL,0);
INSERT INTO `SiteTree_versions` VALUES (18,9,5,1,1,1,'TeamPage','2017-07-11 20:16:51','2017-06-12 17:45:09','team','Meet The Team','Team',NULL,NULL,NULL,1,1,7,0,0,NULL,'Inherit','Inherit',NULL,0);
INSERT INTO `SiteTree_versions` VALUES (19,1,3,1,1,1,'HomePage','2017-07-11 21:36:50','2017-05-11 09:48:33','home','Home',NULL,'<p>Welcome to SilverStripe! This is the default home page. You can edit this page by opening <a href=\"admin/\">the CMS</a>. You can now access the <a href=\"http://doc.silverstripe.org\">developer documentation</a>, or begin <a href=\"http://doc.silverstripe.org/doku.php?id=tutorials\">the tutorials.</a></p>',NULL,NULL,1,1,1,0,0,NULL,'Inherit','Inherit',NULL,0);
INSERT INTO `SiteTree_versions` VALUES (20,1,4,1,1,1,'HomePage','2017-07-11 21:37:36','2017-05-11 09:48:33','home','The York Glaziers Trust',NULL,'<p>Welcome to SilverStripe! This is the default home page. You can edit this page by opening <a href=\"admin/\">the CMS</a>. You can now access the <a href=\"http://doc.silverstripe.org\">developer documentation</a>, or begin <a href=\"http://doc.silverstripe.org/doku.php?id=tutorials\">the tutorials.</a></p>',NULL,NULL,1,1,1,0,0,NULL,'Inherit','Inherit',NULL,0);
INSERT INTO `SiteTree_versions` VALUES (21,3,5,1,1,1,'ContactPage','2017-07-20 18:31:33','2017-05-11 09:48:33','contact-us','Contact Us',NULL,'<p>You can fill this page out with your own content, or delete it and create your own pages.<br></p>',NULL,NULL,1,1,3,0,0,NULL,'Inherit','Inherit',NULL,0);
INSERT INTO `SiteTree_versions` VALUES (22,3,6,1,1,1,'ContactPage','2017-07-20 18:52:11','2017-05-11 09:48:33','contact-us','Contact Us',NULL,'<p>You can fill this page out with your own content, or delete it and create your own pages.<br></p>',NULL,NULL,1,1,3,0,0,NULL,'Inherit','Inherit',NULL,0);
INSERT INTO `SiteTree_versions` VALUES (23,1,5,1,1,1,'HomePage','2017-07-20 18:57:25','2017-05-11 09:48:33','home','The York Glaziers Trust','Home',NULL,NULL,NULL,1,1,1,0,0,NULL,'Inherit','Inherit',NULL,0);

--
-- Table structure for table `TeamGroup`
--

CREATE TABLE `TeamGroup` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `ClassName` enum('TeamGroup') DEFAULT 'TeamGroup',
  `LastEdited` datetime DEFAULT NULL,
  `Created` datetime DEFAULT NULL,
  `Title` varchar(25) DEFAULT NULL,
  `TeamPageID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `ClassName` (`ClassName`),
  KEY `TeamPageID` (`TeamPageID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `TeamGroup`
--

INSERT INTO `TeamGroup` VALUES (1,'TeamGroup','2017-07-11 19:06:29','2017-07-11 19:06:29','Management',9);

--
-- Table structure for table `TeamMember`
--

CREATE TABLE `TeamMember` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `ClassName` enum('TeamMember') DEFAULT 'TeamMember',
  `LastEdited` datetime DEFAULT NULL,
  `Created` datetime DEFAULT NULL,
  `Name` varchar(30) DEFAULT NULL,
  `Role` varchar(30) DEFAULT NULL,
  `Details` mediumtext,
  `TeamGroupID` int(11) NOT NULL DEFAULT '0',
  `ImageID` int(11) NOT NULL DEFAULT '0',
  `Honours` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `TeamGroupID` (`TeamGroupID`),
  KEY `ImageID` (`ImageID`),
  KEY `ClassName` (`ClassName`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `TeamMember`
--

INSERT INTO `TeamMember` VALUES (1,'TeamMember','2017-07-11 19:13:35','2017-07-11 19:09:22','Sarah Brown','Director and CEO','<p>After a long career in the heritage sector, Sarah joined the Trust as its director in 2008, having served as a trustee for a number of years. She has researched and published widely on stained glass history and conservation. She is currently Chairman of the Corpus Vitrearum Medii Aevi for Great Britain, General Secretary of the International Scientific Committee for the Conservation of Stained Glass and Chairman of the Institute of Conservation (ICON) stained glass group. She is also a senior lecturer in History of Art at the University of York and course director of its MA in Stained Glass Conservation and Heritage Management.</p>',1,2,'FSA FRHistS');
INSERT INTO `TeamMember` VALUES (2,'TeamMember','2017-07-11 19:59:04','2017-07-11 19:59:04','Trevor Lawson','Business Manager','<p class=\"p1\"><span class=\"s1\">Trevor joined the Trust in 2011. He has extensive experience in the construction industry, as a qualified quality surveyor and project manager. He leads the Trust in matters of financial management and project planning.</span></p>',1,0,'MRICS MAPM');

--
-- Table structure for table `VirtualPage`
--

CREATE TABLE `VirtualPage` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `VersionID` int(11) NOT NULL DEFAULT '0',
  `CopyContentFromID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `CopyContentFromID` (`CopyContentFromID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `VirtualPage`
--


--
-- Table structure for table `VirtualPage_Live`
--

CREATE TABLE `VirtualPage_Live` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `VersionID` int(11) NOT NULL DEFAULT '0',
  `CopyContentFromID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `CopyContentFromID` (`CopyContentFromID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `VirtualPage_Live`
--


--
-- Table structure for table `VirtualPage_versions`
--

CREATE TABLE `VirtualPage_versions` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `RecordID` int(11) NOT NULL DEFAULT '0',
  `Version` int(11) NOT NULL DEFAULT '0',
  `VersionID` int(11) NOT NULL DEFAULT '0',
  `CopyContentFromID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `RecordID_Version` (`RecordID`,`Version`),
  KEY `RecordID` (`RecordID`),
  KEY `Version` (`Version`),
  KEY `CopyContentFromID` (`CopyContentFromID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `VirtualPage_versions`
--



