Ngiler SH3LL 360
Home
Information
Create File
Create Folder
:
/
var
/
softaculous
/
stripe
/
Information Server
MySQL :
OFF
Perl :
OFF
CURL :
ON
WGET :
OFF
PKEXEC :
OFF
Directive
Local Value
IP Address
63.250.38.10
System
Linux premium90.web-hosting.com 4.18.0-553.44.1.lve.el8.x86_64 #1 SMP Thu Mar 13 14:29:12 UTC 2025 x86_64
User
likhxapw
PHP Version
8.3.30
Software
LiteSpeed
Doc root
Writable
close
Edit File :
stripe.sql
| Size :
52.28
KB
Copy
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `stripe610` -- -- -------------------------------------------------------- -- -- Table structure for table `BrokenExternalLink` -- CREATE TABLE `BrokenExternalLink` ( `ID` int NOT NULL AUTO_INCREMENT, `ClassName` enum('SilverStripe\\Reports\\ExternalLinks\\Model\\BrokenExternalLink') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'SilverStripe\\Reports\\ExternalLinks\\Model\\BrokenExternalLink', `LastEdited` datetime DEFAULT NULL, `Created` datetime DEFAULT NULL, `Link` varchar(2083) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `HTTPCode` int NOT NULL DEFAULT '0', `TrackID` int NOT NULL DEFAULT '0', `StatusID` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), KEY `ClassName` (`ClassName`), KEY `TrackID` (`TrackID`), KEY `StatusID` (`StatusID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `BrokenExternalPageTrack` -- CREATE TABLE `BrokenExternalPageTrack` ( `ID` int NOT NULL AUTO_INCREMENT, `ClassName` enum('SilverStripe\\Reports\\ExternalLinks\\Model\\BrokenExternalPageTrack') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'SilverStripe\\Reports\\ExternalLinks\\Model\\BrokenExternalPageTrack', `LastEdited` datetime DEFAULT NULL, `Created` datetime DEFAULT NULL, `Processed` tinyint unsigned NOT NULL DEFAULT '0', `PageID` int NOT NULL DEFAULT '0', `StatusID` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), KEY `ClassName` (`ClassName`), KEY `PageID` (`PageID`), KEY `StatusID` (`StatusID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `BrokenExternalPageTrackStatus` -- CREATE TABLE `BrokenExternalPageTrackStatus` ( `ID` int NOT NULL AUTO_INCREMENT, `ClassName` enum('SilverStripe\\Reports\\ExternalLinks\\Model\\BrokenExternalPageTrackStatus') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'SilverStripe\\Reports\\ExternalLinks\\Model\\BrokenExternalPageTrackStatus', `LastEdited` datetime DEFAULT NULL, `Created` datetime DEFAULT NULL, `Status` enum('Completed','Running') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Running', `JobInfo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`ID`), KEY `ClassName` (`ClassName`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `ChangeSet` -- CREATE TABLE `ChangeSet` ( `ID` int NOT NULL AUTO_INCREMENT, `ClassName` enum('SilverStripe\\Versioned\\ChangeSet') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'SilverStripe\\Versioned\\ChangeSet', `LastEdited` datetime DEFAULT NULL, `Created` datetime DEFAULT NULL, `Name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `State` enum('open','published','reverted') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'open', `IsInferred` tinyint unsigned NOT NULL DEFAULT '0', `Description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `PublishDate` datetime DEFAULT NULL, `LastSynced` datetime DEFAULT NULL, `OwnerID` int NOT NULL DEFAULT '0', `PublisherID` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), KEY `State` (`State`), KEY `ClassName` (`ClassName`), KEY `OwnerID` (`OwnerID`), KEY `PublisherID` (`PublisherID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `ChangeSetItem` -- CREATE TABLE `ChangeSetItem` ( `ID` int NOT NULL AUTO_INCREMENT, `ClassName` enum('SilverStripe\\Versioned\\ChangeSetItem') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'SilverStripe\\Versioned\\ChangeSetItem', `LastEdited` datetime DEFAULT NULL, `Created` datetime DEFAULT NULL, `VersionBefore` int NOT NULL DEFAULT '0', `VersionAfter` int NOT NULL DEFAULT '0', `Added` enum('explicitly','implicitly') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'implicitly', `ChangeSetID` int NOT NULL DEFAULT '0', `ObjectID` int NOT NULL DEFAULT '0', `ObjectClass` enum('SilverStripe\\Assets\\File','SilverStripe\\SiteConfig\\SiteConfig','SilverStripe\\Versioned\\ChangeSet','SilverStripe\\Versioned\\ChangeSetItem','SilverStripe\\Assets\\Shortcodes\\FileLink','SilverStripe\\CMS\\Model\\SiteTree','SilverStripe\\CMS\\Model\\SiteTreeLink','SilverStripe\\Security\\Group','SilverStripe\\Security\\LoginAttempt','SilverStripe\\Security\\Member','SilverStripe\\Security\\MemberPassword','SilverStripe\\Security\\Permission','SilverStripe\\Security\\PermissionRole','SilverStripe\\Security\\PermissionRoleCode','SilverStripe\\Security\\RememberLoginHash','SilverStripe\\SessionManager\\Models\\LoginSession','SilverStripe\\Reports\\ExternalLinks\\Model\\BrokenExternalLink','SilverStripe\\Reports\\ExternalLinks\\Model\\BrokenExternalPageTrack','SilverStripe\\Reports\\ExternalLinks\\Model\\BrokenExternalPageTrackStatus','SilverStripe\\Assets\\Folder','SilverStripe\\Assets\\Image','Page','SilverStripe\\ErrorPage\\ErrorPage','SilverStripe\\CMS\\Model\\RedirectorPage','SilverStripe\\CMS\\Model\\VirtualPage') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'SilverStripe\\Assets\\File', PRIMARY KEY (`ID`), UNIQUE KEY `ObjectUniquePerChangeSet` (`ObjectID`,`ObjectClass`,`ChangeSetID`), KEY `ClassName` (`ClassName`), KEY `ChangeSetID` (`ChangeSetID`), KEY `Object` (`ObjectID`,`ObjectClass`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `ChangeSetItem_ReferencedBy` -- CREATE TABLE `ChangeSetItem_ReferencedBy` ( `ID` int NOT NULL AUTO_INCREMENT, `ChangeSetItemID` int NOT NULL DEFAULT '0', `ChildID` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), KEY `ChangeSetItemID` (`ChangeSetItemID`), KEY `ChildID` (`ChildID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ErrorPage` -- CREATE TABLE `ErrorPage` ( `ID` int NOT NULL AUTO_INCREMENT, `ErrorCode` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=6 ; -- -- Dumping data for table `ErrorPage` -- INSERT INTO `ErrorPage` VALUES (4, 404), (5, 500); -- -------------------------------------------------------- -- -- Table structure for table `ErrorPage_Live` -- CREATE TABLE `ErrorPage_Live` ( `ID` int NOT NULL AUTO_INCREMENT, `ErrorCode` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=6 ; -- -- Dumping data for table `ErrorPage_Live` -- INSERT INTO `ErrorPage_Live` VALUES (4, 404), (5, 500); -- -------------------------------------------------------- -- -- Table structure for table `ErrorPage_Versions` -- CREATE TABLE `ErrorPage_Versions` ( `ID` int NOT NULL AUTO_INCREMENT, `RecordID` int NOT NULL DEFAULT '0', `Version` int NOT NULL DEFAULT '0', `ErrorCode` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), UNIQUE KEY `RecordID_Version` (`RecordID`,`Version`), KEY `RecordID` (`RecordID`), KEY `Version` (`Version`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=5 ; -- -- Dumping data for table `ErrorPage_Versions` -- INSERT INTO `ErrorPage_Versions` VALUES (1, 4, 1, 404), (2, 4, 2, 404), (3, 5, 1, 500), (4, 5, 2, 500); -- -------------------------------------------------------- -- -- Table structure for table `File` -- CREATE TABLE `File` ( `ID` int NOT NULL AUTO_INCREMENT, `ClassName` enum('SilverStripe\\Assets\\File','SilverStripe\\Assets\\Folder','SilverStripe\\Assets\\Image') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'SilverStripe\\Assets\\File', `LastEdited` datetime DEFAULT NULL, `Created` datetime DEFAULT NULL, `Version` int NOT NULL DEFAULT '0', `CanViewType` enum('Anyone','LoggedInUsers','OnlyTheseUsers','OnlyTheseMembers','Inherit') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Inherit', `CanEditType` enum('LoggedInUsers','OnlyTheseUsers','OnlyTheseMembers','Inherit') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Inherit', `Name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `Title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ShowInSearch` tinyint unsigned NOT NULL DEFAULT '1', `IsFolder` tinyint unsigned GENERATED ALWAYS AS ((case when (`ClassName` = _utf8mb4'SilverStripe\\Assets\\Folder') then 1 else 0 end)) STORED, `ParentID` int NOT NULL DEFAULT '0', `OwnerID` int NOT NULL DEFAULT '0', `FileHash` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `FileFilename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `FileVariant` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`ID`), KEY `Name` (`Name`), KEY `ClassName` (`ClassName`), KEY `ParentID` (`ParentID`), KEY `OwnerID` (`OwnerID`), KEY `FileHash` (`FileHash`), KEY `default_asset_sort` (`ParentID`,`IsFolder` DESC,`Title`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `FileLink` -- CREATE TABLE `FileLink` ( `ID` int NOT NULL AUTO_INCREMENT, `ClassName` enum('SilverStripe\\Assets\\Shortcodes\\FileLink') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'SilverStripe\\Assets\\Shortcodes\\FileLink', `LastEdited` datetime DEFAULT NULL, `Created` datetime DEFAULT NULL, `LinkedID` int NOT NULL DEFAULT '0', `ParentID` int NOT NULL DEFAULT '0', `ParentClass` enum('SilverStripe\\Assets\\File','SilverStripe\\SiteConfig\\SiteConfig','SilverStripe\\Versioned\\ChangeSet','SilverStripe\\Versioned\\ChangeSetItem','SilverStripe\\Assets\\Shortcodes\\FileLink','SilverStripe\\CMS\\Model\\SiteTree','SilverStripe\\CMS\\Model\\SiteTreeLink','SilverStripe\\Security\\Group','SilverStripe\\Security\\LoginAttempt','SilverStripe\\Security\\Member','SilverStripe\\Security\\MemberPassword','SilverStripe\\Security\\Permission','SilverStripe\\Security\\PermissionRole','SilverStripe\\Security\\PermissionRoleCode','SilverStripe\\Security\\RememberLoginHash','SilverStripe\\SessionManager\\Models\\LoginSession','SilverStripe\\Reports\\ExternalLinks\\Model\\BrokenExternalLink','SilverStripe\\Reports\\ExternalLinks\\Model\\BrokenExternalPageTrack','SilverStripe\\Reports\\ExternalLinks\\Model\\BrokenExternalPageTrackStatus','SilverStripe\\Assets\\Folder','SilverStripe\\Assets\\Image','Page','SilverStripe\\ErrorPage\\ErrorPage','SilverStripe\\CMS\\Model\\RedirectorPage','SilverStripe\\CMS\\Model\\VirtualPage') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'SilverStripe\\Assets\\File', PRIMARY KEY (`ID`), KEY `ClassName` (`ClassName`), KEY `LinkedID` (`LinkedID`), KEY `Parent` (`ParentID`,`ParentClass`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `File_EditorGroups` -- CREATE TABLE `File_EditorGroups` ( `ID` int NOT NULL AUTO_INCREMENT, `FileID` int NOT NULL DEFAULT '0', `GroupID` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), KEY `FileID` (`FileID`), KEY `GroupID` (`GroupID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `File_EditorMembers` -- CREATE TABLE `File_EditorMembers` ( `ID` int NOT NULL AUTO_INCREMENT, `FileID` int NOT NULL DEFAULT '0', `MemberID` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), KEY `FileID` (`FileID`), KEY `MemberID` (`MemberID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `File_Live` -- CREATE TABLE `File_Live` ( `ID` int NOT NULL AUTO_INCREMENT, `ClassName` enum('SilverStripe\\Assets\\File','SilverStripe\\Assets\\Folder','SilverStripe\\Assets\\Image') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'SilverStripe\\Assets\\File', `LastEdited` datetime DEFAULT NULL, `Created` datetime DEFAULT NULL, `Version` int NOT NULL DEFAULT '0', `CanViewType` enum('Anyone','LoggedInUsers','OnlyTheseUsers','OnlyTheseMembers','Inherit') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Inherit', `CanEditType` enum('LoggedInUsers','OnlyTheseUsers','OnlyTheseMembers','Inherit') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Inherit', `Name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `Title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ShowInSearch` tinyint unsigned NOT NULL DEFAULT '1', `IsFolder` tinyint unsigned GENERATED ALWAYS AS ((case when (`ClassName` = _utf8mb4'SilverStripe\\Assets\\Folder') then 1 else 0 end)) STORED, `ParentID` int NOT NULL DEFAULT '0', `OwnerID` int NOT NULL DEFAULT '0', `FileHash` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `FileFilename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `FileVariant` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`ID`), KEY `Name` (`Name`), KEY `ClassName` (`ClassName`), KEY `ParentID` (`ParentID`), KEY `OwnerID` (`OwnerID`), KEY `FileHash` (`FileHash`), KEY `default_asset_sort` (`ParentID`,`IsFolder` DESC,`Title`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `File_Versions` -- CREATE TABLE `File_Versions` ( `ID` int NOT NULL AUTO_INCREMENT, `RecordID` int NOT NULL DEFAULT '0', `Version` int NOT NULL DEFAULT '0', `WasPublished` tinyint unsigned NOT NULL DEFAULT '0', `WasDeleted` tinyint unsigned NOT NULL DEFAULT '0', `WasDraft` tinyint unsigned NOT NULL DEFAULT '1', `AuthorID` int NOT NULL DEFAULT '0', `PublisherID` int NOT NULL DEFAULT '0', `ClassName` enum('SilverStripe\\Assets\\File','SilverStripe\\Assets\\Folder','SilverStripe\\Assets\\Image') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'SilverStripe\\Assets\\File', `LastEdited` datetime DEFAULT NULL, `Created` datetime DEFAULT NULL, `CanViewType` enum('Anyone','LoggedInUsers','OnlyTheseUsers','OnlyTheseMembers','Inherit') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Inherit', `CanEditType` enum('LoggedInUsers','OnlyTheseUsers','OnlyTheseMembers','Inherit') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Inherit', `Name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `Title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ShowInSearch` tinyint unsigned NOT NULL DEFAULT '1', `IsFolder` tinyint unsigned GENERATED ALWAYS AS ((case when (`ClassName` = _utf8mb4'SilverStripe\\Assets\\Folder') then 1 else 0 end)) STORED, `ParentID` int NOT NULL DEFAULT '0', `OwnerID` int NOT NULL DEFAULT '0', `FileHash` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `FileFilename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `FileVariant` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`ID`), KEY `RecordID_Version` (`RecordID`,`Version`), KEY `RecordID` (`RecordID`), KEY `Version` (`Version`), KEY `AuthorID` (`AuthorID`), KEY `PublisherID` (`PublisherID`), KEY `Name` (`Name`), KEY `ClassName` (`ClassName`), KEY `ParentID` (`ParentID`), KEY `OwnerID` (`OwnerID`), KEY `FileHash` (`FileHash`), KEY `default_asset_sort` (`ParentID`,`IsFolder` DESC,`Title`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `File_ViewerGroups` -- CREATE TABLE `File_ViewerGroups` ( `ID` int NOT NULL AUTO_INCREMENT, `FileID` int NOT NULL DEFAULT '0', `GroupID` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), KEY `FileID` (`FileID`), KEY `GroupID` (`GroupID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `File_ViewerMembers` -- CREATE TABLE `File_ViewerMembers` ( `ID` int NOT NULL AUTO_INCREMENT, `FileID` int NOT NULL DEFAULT '0', `MemberID` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), KEY `FileID` (`FileID`), KEY `MemberID` (`MemberID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `Group` -- CREATE TABLE `Group` ( `ID` int NOT NULL AUTO_INCREMENT, `ClassName` enum('SilverStripe\\Security\\Group') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'SilverStripe\\Security\\Group', `LastEdited` datetime DEFAULT NULL, `Created` datetime DEFAULT NULL, `Title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `Description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `Code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `Locked` tinyint unsigned NOT NULL DEFAULT '0', `Sort` int NOT NULL DEFAULT '0', `HtmlEditorConfig` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `ParentID` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), KEY `ClassName` (`ClassName`), KEY `ParentID` (`ParentID`), KEY `Title` (`Title`), KEY `Code` (`Code`), KEY `Sort` (`Sort`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=3 ; -- -- Dumping data for table `Group` -- INSERT INTO `Group` VALUES (1, 'SilverStripe\\Security\\Group', '[[regtime]]', '[[regtime]]', 'Content Authors', NULL, 'content-authors', 0, 1, NULL, 0), (2, 'SilverStripe\\Security\\Group', '[[regtime]]', '[[regtime]]', 'Administrators', NULL, 'administrators', 0, 0, NULL, 0); -- -------------------------------------------------------- -- -- Table structure for table `Group_Members` -- CREATE TABLE `Group_Members` ( `ID` int NOT NULL AUTO_INCREMENT, `GroupID` int NOT NULL DEFAULT '0', `MemberID` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), KEY `GroupID` (`GroupID`), KEY `MemberID` (`MemberID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=2 ; -- -- 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 NOT NULL AUTO_INCREMENT, `GroupID` int NOT NULL DEFAULT '0', `PermissionRoleID` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), KEY `GroupID` (`GroupID`), KEY `PermissionRoleID` (`PermissionRoleID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `LoginAttempt` -- CREATE TABLE `LoginAttempt` ( `ID` int NOT NULL AUTO_INCREMENT, `ClassName` enum('SilverStripe\\Security\\LoginAttempt') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'SilverStripe\\Security\\LoginAttempt', `LastEdited` datetime DEFAULT NULL, `Created` datetime DEFAULT NULL, `EmailHashed` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `Status` enum('Success','Failure') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Success', `IP` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `MemberID` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), KEY `ClassName` (`ClassName`), KEY `MemberID` (`MemberID`), KEY `EmailHashed` (`EmailHashed`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `LoginSession` -- CREATE TABLE `LoginSession` ( `ID` int NOT NULL AUTO_INCREMENT, `ClassName` enum('SilverStripe\\SessionManager\\Models\\LoginSession') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'SilverStripe\\SessionManager\\Models\\LoginSession', `LastEdited` datetime DEFAULT NULL, `Created` datetime DEFAULT NULL, `LastAccessed` datetime DEFAULT NULL, `IPAddress` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `UserAgent` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `Persistent` tinyint unsigned NOT NULL DEFAULT '0', `MemberID` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), KEY `LastAccessed` (`LastAccessed`), KEY `ClassName` (`ClassName`), KEY `MemberID` (`MemberID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `Member` -- CREATE TABLE `Member` ( `ID` int NOT NULL AUTO_INCREMENT, `ClassName` enum('SilverStripe\\Security\\Member') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'SilverStripe\\Security\\Member', `LastEdited` datetime DEFAULT NULL, `Created` datetime DEFAULT NULL, `FirstName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `Surname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `Email` varchar(254) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `TempIDHash` varchar(160) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `TempIDExpired` datetime DEFAULT NULL, `Password` varchar(160) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `AutoLoginHash` varchar(160) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `AutoLoginExpired` datetime DEFAULT NULL, `AutoLoginTempHash` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `PasswordEncryption` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `Salt` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `PasswordExpiry` date DEFAULT NULL, `LockedOutUntil` datetime DEFAULT NULL, `Locale` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `FailedLoginCount` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), KEY `Surname` (`Surname`), KEY `FirstName` (`FirstName`), KEY `default_sort_composite` (`Surname`,`FirstName`), KEY `ClassName` (`ClassName`), KEY `Email` (`Email`), KEY `AutoLoginHash` (`AutoLoginHash`), KEY `AutoLoginTempHash` (`AutoLoginTempHash`), KEY `TempIDHash` (`TempIDHash`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=2 ; -- -- Dumping data for table `Member` -- INSERT INTO `Member` VALUES (1, 'SilverStripe\\Security\\Member', '[[regtime]]', '[[regtime]]', 'Default Admin', NULL, '[[admin_email]]', NULL, NULL, '[[admin_pass]]', NULL, NULL, NULL, 'blowfish', '[[salt]]', NULL, NULL, '[[language]]', 0); -- -------------------------------------------------------- -- -- Table structure for table `MemberPassword` -- CREATE TABLE `MemberPassword` ( `ID` int NOT NULL AUTO_INCREMENT, `ClassName` enum('SilverStripe\\Security\\MemberPassword') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'SilverStripe\\Security\\MemberPassword', `LastEdited` datetime DEFAULT NULL, `Created` datetime DEFAULT NULL, `Password` varchar(160) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `Salt` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `PasswordEncryption` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `MemberID` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), KEY `ClassName` (`ClassName`), KEY `MemberID` (`MemberID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=2 ; -- -- Dumping data for table `MemberPassword` -- INSERT INTO `MemberPassword` VALUES (1, 'SilverStripe\\Security\\MemberPassword', '[[regtime]]', '[[regtime]]', '[[admin_pass]]', '[[salt]]', 'blowfish', 1); -- -------------------------------------------------------- -- -- Table structure for table `Permission` -- CREATE TABLE `Permission` ( `ID` int NOT NULL AUTO_INCREMENT, `ClassName` enum('SilverStripe\\Security\\Permission') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'SilverStripe\\Security\\Permission', `LastEdited` datetime DEFAULT NULL, `Created` datetime DEFAULT NULL, `Code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `Arg` int NOT NULL DEFAULT '0', `Type` int NOT NULL DEFAULT '1', `GroupID` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), KEY `ClassName` (`ClassName`), KEY `GroupID` (`GroupID`), KEY `Code_GroupID` (`Code`,`GroupID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=6 ; -- -- Dumping data for table `Permission` -- INSERT INTO `Permission` VALUES (1, 'SilverStripe\\Security\\Permission', '[[regtime]]', '[[regtime]]', 'CMS_ACCESS_CMSMain', 0, 1, 1), (2, 'SilverStripe\\Security\\Permission', '[[regtime]]', '[[regtime]]', 'CMS_ACCESS_AssetAdmin', 0, 1, 1), (3, 'SilverStripe\\Security\\Permission', '[[regtime]]', '[[regtime]]', 'CMS_ACCESS_ReportAdmin', 0, 1, 1), (4, 'SilverStripe\\Security\\Permission', '[[regtime]]', '[[regtime]]', 'SITETREE_REORGANISE', 0, 1, 1), (5, 'SilverStripe\\Security\\Permission', '[[regtime]]', '[[regtime]]', 'ADMIN', 0, 1, 2); -- -------------------------------------------------------- -- -- Table structure for table `PermissionRole` -- CREATE TABLE `PermissionRole` ( `ID` int NOT NULL AUTO_INCREMENT, `ClassName` enum('SilverStripe\\Security\\PermissionRole') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'SilverStripe\\Security\\PermissionRole', `LastEdited` datetime DEFAULT NULL, `Created` datetime DEFAULT NULL, `Title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `OnlyAdminCanApply` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), KEY `Title` (`Title`), KEY `ClassName` (`ClassName`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `PermissionRoleCode` -- CREATE TABLE `PermissionRoleCode` ( `ID` int NOT NULL AUTO_INCREMENT, `ClassName` enum('SilverStripe\\Security\\PermissionRoleCode') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'SilverStripe\\Security\\PermissionRoleCode', `LastEdited` datetime DEFAULT NULL, `Created` datetime DEFAULT NULL, `Code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `RoleID` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), KEY `ClassName` (`ClassName`), KEY `RoleID` (`RoleID`), KEY `Code_RoleID` (`Code`,`RoleID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `RedirectorPage` -- CREATE TABLE `RedirectorPage` ( `ID` int NOT NULL AUTO_INCREMENT, `RedirectionType` enum('Internal','External','File') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Internal', `ExternalURL` varchar(2083) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `LinkToID` int NOT NULL DEFAULT '0', `LinkToFileID` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), KEY `LinkToID` (`LinkToID`), KEY `LinkToFileID` (`LinkToFileID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `RedirectorPage_Live` -- CREATE TABLE `RedirectorPage_Live` ( `ID` int NOT NULL AUTO_INCREMENT, `RedirectionType` enum('Internal','External','File') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Internal', `ExternalURL` varchar(2083) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `LinkToID` int NOT NULL DEFAULT '0', `LinkToFileID` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), KEY `LinkToID` (`LinkToID`), KEY `LinkToFileID` (`LinkToFileID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `RedirectorPage_Versions` -- CREATE TABLE `RedirectorPage_Versions` ( `ID` int NOT NULL AUTO_INCREMENT, `RecordID` int NOT NULL DEFAULT '0', `Version` int NOT NULL DEFAULT '0', `RedirectionType` enum('Internal','External','File') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Internal', `ExternalURL` varchar(2083) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `LinkToID` int NOT NULL DEFAULT '0', `LinkToFileID` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), UNIQUE KEY `RecordID_Version` (`RecordID`,`Version`), KEY `RecordID` (`RecordID`), KEY `Version` (`Version`), KEY `LinkToID` (`LinkToID`), KEY `LinkToFileID` (`LinkToFileID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `RememberLoginHash` -- CREATE TABLE `RememberLoginHash` ( `ID` int NOT NULL AUTO_INCREMENT, `ClassName` enum('SilverStripe\\Security\\RememberLoginHash') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'SilverStripe\\Security\\RememberLoginHash', `LastEdited` datetime DEFAULT NULL, `Created` datetime DEFAULT NULL, `DeviceID` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `Hash` varchar(160) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ExpiryDate` datetime DEFAULT NULL, `LoginSessionID` int NOT NULL DEFAULT '0', `MemberID` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), KEY `ClassName` (`ClassName`), KEY `LoginSessionID` (`LoginSessionID`), KEY `MemberID` (`MemberID`), KEY `DeviceID` (`DeviceID`), KEY `Hash` (`Hash`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `SiteConfig` -- CREATE TABLE `SiteConfig` ( `ID` int NOT NULL AUTO_INCREMENT, `ClassName` enum('SilverStripe\\SiteConfig\\SiteConfig') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'SilverStripe\\SiteConfig\\SiteConfig', `LastEdited` datetime DEFAULT NULL, `Created` datetime DEFAULT NULL, `Title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `Tagline` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `CanViewType` enum('Anyone','LoggedInUsers','OnlyTheseUsers','OnlyTheseMembers') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Anyone', `CanEditType` enum('LoggedInUsers','OnlyTheseUsers','OnlyTheseMembers') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'LoggedInUsers', `CanCreateTopLevelType` enum('LoggedInUsers','OnlyTheseUsers','OnlyTheseMembers') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'LoggedInUsers', PRIMARY KEY (`ID`), KEY `ClassName` (`ClassName`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=2 ; -- -- Dumping data for table `SiteConfig` -- INSERT INTO `SiteConfig` VALUES (1, 'SilverStripe\\SiteConfig\\SiteConfig', '[[regtime]]', '[[regtime]]', '[[site_name]]', '[[site_desc]]', 'Anyone', 'LoggedInUsers', 'LoggedInUsers'); -- -------------------------------------------------------- -- -- Table structure for table `SiteConfig_CreateTopLevelGroups` -- CREATE TABLE `SiteConfig_CreateTopLevelGroups` ( `ID` int NOT NULL AUTO_INCREMENT, `SiteConfigID` int NOT NULL DEFAULT '0', `GroupID` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), KEY `SiteConfigID` (`SiteConfigID`), KEY `GroupID` (`GroupID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `SiteConfig_CreateTopLevelMembers` -- CREATE TABLE `SiteConfig_CreateTopLevelMembers` ( `ID` int NOT NULL AUTO_INCREMENT, `SiteConfigID` int NOT NULL DEFAULT '0', `MemberID` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), KEY `SiteConfigID` (`SiteConfigID`), KEY `MemberID` (`MemberID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `SiteConfig_EditorGroups` -- CREATE TABLE `SiteConfig_EditorGroups` ( `ID` int NOT NULL AUTO_INCREMENT, `SiteConfigID` int NOT NULL DEFAULT '0', `GroupID` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), KEY `SiteConfigID` (`SiteConfigID`), KEY `GroupID` (`GroupID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `SiteConfig_EditorMembers` -- CREATE TABLE `SiteConfig_EditorMembers` ( `ID` int NOT NULL AUTO_INCREMENT, `SiteConfigID` int NOT NULL DEFAULT '0', `MemberID` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), KEY `SiteConfigID` (`SiteConfigID`), KEY `MemberID` (`MemberID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `SiteConfig_ViewerGroups` -- CREATE TABLE `SiteConfig_ViewerGroups` ( `ID` int NOT NULL AUTO_INCREMENT, `SiteConfigID` int NOT NULL DEFAULT '0', `GroupID` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), KEY `SiteConfigID` (`SiteConfigID`), KEY `GroupID` (`GroupID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `SiteConfig_ViewerMembers` -- CREATE TABLE `SiteConfig_ViewerMembers` ( `ID` int NOT NULL AUTO_INCREMENT, `SiteConfigID` int NOT NULL DEFAULT '0', `MemberID` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), KEY `SiteConfigID` (`SiteConfigID`), KEY `MemberID` (`MemberID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `SiteTree` -- CREATE TABLE `SiteTree` ( `ID` int NOT NULL AUTO_INCREMENT, `ClassName` enum('SilverStripe\\CMS\\Model\\SiteTree','Page','SilverStripe\\ErrorPage\\ErrorPage','SilverStripe\\CMS\\Model\\RedirectorPage','SilverStripe\\CMS\\Model\\VirtualPage') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Page', `LastEdited` datetime DEFAULT NULL, `Created` datetime DEFAULT NULL, `CanViewType` enum('Anyone','LoggedInUsers','OnlyTheseUsers','OnlyTheseMembers','Inherit') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Inherit', `CanEditType` enum('LoggedInUsers','OnlyTheseUsers','OnlyTheseMembers','Inherit') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Inherit', `Version` int NOT NULL DEFAULT '0', `Title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `URLSegment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `MenuTitle` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `Content` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `MetaDescription` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `ExtraMeta` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `ShowInMenus` tinyint unsigned NOT NULL DEFAULT '0', `ShowInSearch` tinyint unsigned NOT NULL DEFAULT '0', `Sort` int NOT NULL DEFAULT '0', `HasBrokenFile` tinyint unsigned NOT NULL DEFAULT '0', `HasBrokenLink` tinyint unsigned NOT NULL DEFAULT '0', `ReportClass` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ParentID` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), KEY `Sort` (`Sort`), KEY `ClassName` (`ClassName`), KEY `ParentID` (`ParentID`), KEY `URLSegment` (`URLSegment`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=6 ; -- -- Dumping data for table `SiteTree` -- INSERT INTO `SiteTree` VALUES (1, 'Page', '[[regtime]]', '[[regtime]]', 'Inherit', 'Inherit', 2, 'Home', 'home', NULL, '<p>Welcome to Silverstripe! This is the default homepage. You can edit this page by opening <a href="admin/">the CMS</a>.</p><p>For comprehensive information on Silverstripe CMS, see the <a target="_blank" href="http://docs.silverstripe.org">developer documentation</a>.</p>', NULL, NULL, 1, 1, 1, 0, 0, NULL, 0), (2, 'Page', '[[regtime]]', '[[regtime]]', 'Inherit', 'Inherit', 2, 'About Us', 'about-us', NULL, '<p>You can fill this page out with your own content, or delete it and create your own pages.</p>', NULL, NULL, 1, 1, 2, 0, 0, NULL, 0), (3, 'Page', '[[regtime]]', '[[regtime]]', 'Inherit', 'Inherit', 2, 'Contact Us', 'contact-us', NULL, '<p>You can fill this page out with your own content, or delete it and create your own pages.</p>', NULL, NULL, 1, 1, 3, 0, 0, NULL, 0), (4, 'SilverStripe\\ErrorPage\\ErrorPage', '[[regtime]]', '[[regtime]]', 'Inherit', 'Inherit', 2, '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, 0), (5, 'SilverStripe\\ErrorPage\\ErrorPage', '[[regtime]]', '[[regtime]]', 'Inherit', 'Inherit', 2, 'Server error', 'server-error', NULL, '<p>Sorry, there was a problem with handling your request.</p>', NULL, NULL, 0, 0, 5, 0, 0, NULL, 0); -- -------------------------------------------------------- -- -- Table structure for table `SiteTreeLink` -- CREATE TABLE `SiteTreeLink` ( `ID` int NOT NULL AUTO_INCREMENT, `ClassName` enum('SilverStripe\\CMS\\Model\\SiteTreeLink') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'SilverStripe\\CMS\\Model\\SiteTreeLink', `LastEdited` datetime DEFAULT NULL, `Created` datetime DEFAULT NULL, `LinkedID` int NOT NULL DEFAULT '0', `ParentID` int NOT NULL DEFAULT '0', `ParentClass` enum('SilverStripe\\Assets\\File','SilverStripe\\SiteConfig\\SiteConfig','SilverStripe\\Versioned\\ChangeSet','SilverStripe\\Versioned\\ChangeSetItem','SilverStripe\\Assets\\Shortcodes\\FileLink','SilverStripe\\CMS\\Model\\SiteTree','SilverStripe\\CMS\\Model\\SiteTreeLink','SilverStripe\\Security\\Group','SilverStripe\\Security\\LoginAttempt','SilverStripe\\Security\\Member','SilverStripe\\Security\\MemberPassword','SilverStripe\\Security\\Permission','SilverStripe\\Security\\PermissionRole','SilverStripe\\Security\\PermissionRoleCode','SilverStripe\\Security\\RememberLoginHash','SilverStripe\\SessionManager\\Models\\LoginSession','SilverStripe\\Reports\\ExternalLinks\\Model\\BrokenExternalLink','SilverStripe\\Reports\\ExternalLinks\\Model\\BrokenExternalPageTrack','SilverStripe\\Reports\\ExternalLinks\\Model\\BrokenExternalPageTrackStatus','SilverStripe\\Assets\\Folder','SilverStripe\\Assets\\Image','Page','SilverStripe\\ErrorPage\\ErrorPage','SilverStripe\\CMS\\Model\\RedirectorPage','SilverStripe\\CMS\\Model\\VirtualPage') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'SilverStripe\\Assets\\File', PRIMARY KEY (`ID`), KEY `ClassName` (`ClassName`), KEY `LinkedID` (`LinkedID`), KEY `Parent` (`ParentID`,`ParentClass`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `SiteTree_EditorGroups` -- CREATE TABLE `SiteTree_EditorGroups` ( `ID` int NOT NULL AUTO_INCREMENT, `SiteTreeID` int NOT NULL DEFAULT '0', `GroupID` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), KEY `SiteTreeID` (`SiteTreeID`), KEY `GroupID` (`GroupID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `SiteTree_EditorMembers` -- CREATE TABLE `SiteTree_EditorMembers` ( `ID` int NOT NULL AUTO_INCREMENT, `SiteTreeID` int NOT NULL DEFAULT '0', `MemberID` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), KEY `SiteTreeID` (`SiteTreeID`), KEY `MemberID` (`MemberID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `SiteTree_Live` -- CREATE TABLE `SiteTree_Live` ( `ID` int NOT NULL AUTO_INCREMENT, `ClassName` enum('SilverStripe\\CMS\\Model\\SiteTree','Page','SilverStripe\\ErrorPage\\ErrorPage','SilverStripe\\CMS\\Model\\RedirectorPage','SilverStripe\\CMS\\Model\\VirtualPage') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Page', `LastEdited` datetime DEFAULT NULL, `Created` datetime DEFAULT NULL, `CanViewType` enum('Anyone','LoggedInUsers','OnlyTheseUsers','OnlyTheseMembers','Inherit') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Inherit', `CanEditType` enum('LoggedInUsers','OnlyTheseUsers','OnlyTheseMembers','Inherit') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Inherit', `Version` int NOT NULL DEFAULT '0', `Title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `URLSegment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `MenuTitle` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `Content` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `MetaDescription` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `ExtraMeta` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `ShowInMenus` tinyint unsigned NOT NULL DEFAULT '0', `ShowInSearch` tinyint unsigned NOT NULL DEFAULT '0', `Sort` int NOT NULL DEFAULT '0', `HasBrokenFile` tinyint unsigned NOT NULL DEFAULT '0', `HasBrokenLink` tinyint unsigned NOT NULL DEFAULT '0', `ReportClass` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ParentID` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), KEY `Sort` (`Sort`), KEY `ClassName` (`ClassName`), KEY `ParentID` (`ParentID`), KEY `URLSegment` (`URLSegment`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=6 ; -- -- Dumping data for table `SiteTree_Live` -- INSERT INTO `SiteTree_Live` VALUES (1, 'Page', '[[regtime]]', '[[regtime]]', 'Inherit', 'Inherit', 2, 'Home', 'home', NULL, '<p>Welcome to Silverstripe! This is the default homepage. You can edit this page by opening <a href="admin/">the CMS</a>.</p><p>For comprehensive information on Silverstripe CMS, see the <a target="_blank" href="http://docs.silverstripe.org">developer documentation</a>.</p>', NULL, NULL, 1, 1, 1, 0, 0, NULL, 0), (2, 'Page', '[[regtime]]', '[[regtime]]', 'Inherit', 'Inherit', 2, 'About Us', 'about-us', NULL, '<p>You can fill this page out with your own content, or delete it and create your own pages.</p>', NULL, NULL, 1, 1, 2, 0, 0, NULL, 0), (3, 'Page', '[[regtime]]', '[[regtime]]', 'Inherit', 'Inherit', 2, 'Contact Us', 'contact-us', NULL, '<p>You can fill this page out with your own content, or delete it and create your own pages.</p>', NULL, NULL, 1, 1, 3, 0, 0, NULL, 0), (4, 'SilverStripe\\ErrorPage\\ErrorPage', '[[regtime]]', '[[regtime]]', 'Inherit', 'Inherit', 2, '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, 0), (5, 'SilverStripe\\ErrorPage\\ErrorPage', '[[regtime]]', '[[regtime]]', 'Inherit', 'Inherit', 2, 'Server error', 'server-error', NULL, '<p>Sorry, there was a problem with handling your request.</p>', NULL, NULL, 0, 0, 5, 0, 0, NULL, 0); -- -------------------------------------------------------- -- -- Table structure for table `SiteTree_Versions` -- CREATE TABLE `SiteTree_Versions` ( `ID` int NOT NULL AUTO_INCREMENT, `RecordID` int NOT NULL DEFAULT '0', `Version` int NOT NULL DEFAULT '0', `WasPublished` tinyint unsigned NOT NULL DEFAULT '0', `WasDeleted` tinyint unsigned NOT NULL DEFAULT '0', `WasDraft` tinyint unsigned NOT NULL DEFAULT '1', `AuthorID` int NOT NULL DEFAULT '0', `PublisherID` int NOT NULL DEFAULT '0', `ClassName` enum('SilverStripe\\CMS\\Model\\SiteTree','Page','SilverStripe\\ErrorPage\\ErrorPage','SilverStripe\\CMS\\Model\\RedirectorPage','SilverStripe\\CMS\\Model\\VirtualPage') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Page', `LastEdited` datetime DEFAULT NULL, `Created` datetime DEFAULT NULL, `CanViewType` enum('Anyone','LoggedInUsers','OnlyTheseUsers','OnlyTheseMembers','Inherit') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Inherit', `CanEditType` enum('LoggedInUsers','OnlyTheseUsers','OnlyTheseMembers','Inherit') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Inherit', `Title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `URLSegment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `MenuTitle` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `Content` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `MetaDescription` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `ExtraMeta` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `ShowInMenus` tinyint unsigned NOT NULL DEFAULT '0', `ShowInSearch` tinyint unsigned NOT NULL DEFAULT '0', `Sort` int NOT NULL DEFAULT '0', `HasBrokenFile` tinyint unsigned NOT NULL DEFAULT '0', `HasBrokenLink` tinyint unsigned NOT NULL DEFAULT '0', `ReportClass` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ParentID` int 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 `Sort` (`Sort`), KEY `ClassName` (`ClassName`), KEY `ParentID` (`ParentID`), KEY `URLSegment` (`URLSegment`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=11 ; -- -- Dumping data for table `SiteTree_Versions` -- INSERT INTO `SiteTree_Versions` VALUES (1, 1, 1, 0, 0, 1, 0, 0, 'Page', '[[regtime]]', '[[regtime]]', 'Inherit', 'Inherit', 'Home', 'home', NULL, '<p>Welcome to Silverstripe! This is the default homepage. You can edit this page by opening <a href="admin/">the CMS</a>.</p><p>For comprehensive information on Silverstripe CMS, see the <a target="_blank" href="http://docs.silverstripe.org">developer documentation</a>.</p>', NULL, NULL, 1, 1, 1, 0, 0, NULL, 0), (2, 1, 2, 1, 0, 1, 0, 0, 'Page', '[[regtime]]', '[[regtime]]', 'Inherit', 'Inherit', 'Home', 'home', NULL, '<p>Welcome to Silverstripe! This is the default homepage. You can edit this page by opening <a href="admin/">the CMS</a>.</p><p>For comprehensive information on Silverstripe CMS, see the <a target="_blank" href="http://docs.silverstripe.org">developer documentation</a>.</p>', NULL, NULL, 1, 1, 1, 0, 0, NULL, 0), (3, 2, 1, 0, 0, 1, 0, 0, 'Page', '[[regtime]]', '[[regtime]]', 'Inherit', 'Inherit', 'About Us', 'about-us', NULL, '<p>You can fill this page out with your own content, or delete it and create your own pages.</p>', NULL, NULL, 1, 1, 2, 0, 0, NULL, 0), (4, 2, 2, 1, 0, 1, 0, 0, 'Page', '[[regtime]]', '[[regtime]]', 'Inherit', 'Inherit', 'About Us', 'about-us', NULL, '<p>You can fill this page out with your own content, or delete it and create your own pages.</p>', NULL, NULL, 1, 1, 2, 0, 0, NULL, 0), (5, 3, 1, 0, 0, 1, 0, 0, 'Page', '[[regtime]]', '[[regtime]]', 'Inherit', 'Inherit', 'Contact Us', 'contact-us', NULL, '<p>You can fill this page out with your own content, or delete it and create your own pages.</p>', NULL, NULL, 1, 1, 3, 0, 0, NULL, 0), (6, 3, 2, 1, 0, 1, 0, 0, 'Page', '[[regtime]]', '[[regtime]]', 'Inherit', 'Inherit', 'Contact Us', 'contact-us', NULL, '<p>You can fill this page out with your own content, or delete it and create your own pages.</p>', NULL, NULL, 1, 1, 3, 0, 0, NULL, 0), (7, 4, 1, 0, 0, 1, 0, 0, 'SilverStripe\\ErrorPage\\ErrorPage', '[[regtime]]', '[[regtime]]', 'Inherit', 'Inherit', '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, 0), (8, 4, 2, 1, 0, 1, 0, 0, 'SilverStripe\\ErrorPage\\ErrorPage', '[[regtime]]', '[[regtime]]', 'Inherit', 'Inherit', '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, 0), (9, 5, 1, 0, 0, 1, 0, 0, 'SilverStripe\\ErrorPage\\ErrorPage', '[[regtime]]', '[[regtime]]', 'Inherit', 'Inherit', 'Server error', 'server-error', NULL, '<p>Sorry, there was a problem with handling your request.</p>', NULL, NULL, 0, 0, 5, 0, 0, NULL, 0), (10, 5, 2, 1, 0, 1, 0, 0, 'SilverStripe\\ErrorPage\\ErrorPage', '[[regtime]]', '[[regtime]]', 'Inherit', 'Inherit', 'Server error', 'server-error', NULL, '<p>Sorry, there was a problem with handling your request.</p>', NULL, NULL, 0, 0, 5, 0, 0, NULL, 0); -- -------------------------------------------------------- -- -- Table structure for table `SiteTree_ViewerGroups` -- CREATE TABLE `SiteTree_ViewerGroups` ( `ID` int NOT NULL AUTO_INCREMENT, `SiteTreeID` int NOT NULL DEFAULT '0', `GroupID` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), KEY `SiteTreeID` (`SiteTreeID`), KEY `GroupID` (`GroupID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `SiteTree_ViewerMembers` -- CREATE TABLE `SiteTree_ViewerMembers` ( `ID` int NOT NULL AUTO_INCREMENT, `SiteTreeID` int NOT NULL DEFAULT '0', `MemberID` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), KEY `SiteTreeID` (`SiteTreeID`), KEY `MemberID` (`MemberID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `VirtualPage` -- CREATE TABLE `VirtualPage` ( `ID` int NOT NULL AUTO_INCREMENT, `VersionID` int NOT NULL DEFAULT '0', `CustomMetaDescription` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `CustomExtraMeta` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `CopyContentFromID` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), KEY `CopyContentFromID` (`CopyContentFromID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `VirtualPage_Live` -- CREATE TABLE `VirtualPage_Live` ( `ID` int NOT NULL AUTO_INCREMENT, `VersionID` int NOT NULL DEFAULT '0', `CustomMetaDescription` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `CustomExtraMeta` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `CopyContentFromID` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), KEY `CopyContentFromID` (`CopyContentFromID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `VirtualPage_Versions` -- CREATE TABLE `VirtualPage_Versions` ( `ID` int NOT NULL AUTO_INCREMENT, `RecordID` int NOT NULL DEFAULT '0', `Version` int NOT NULL DEFAULT '0', `VersionID` int NOT NULL DEFAULT '0', `CustomMetaDescription` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `CustomExtraMeta` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `CopyContentFromID` int 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=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Back