Environment Builder

Building database spotmarket using SilverStripe\SQLite\SQLite3 3.37.2

Creating database tables

• Checking database integrity
• VACUUMing
• SpotMarket_ConsentRequest
• Table SpotMarket_ConsentRequest: created
• Field SpotMarket_ConsentRequest.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field SpotMarket_ConsentRequest.ClassName: created as TEXT DEFAULT 'SpotMarket\Models\ConsentRequest'
• Field SpotMarket_ConsentRequest.LastEdited: created as DATETIME
• Field SpotMarket_ConsentRequest.Created: created as DATETIME
• Field SpotMarket_ConsentRequest.Name: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_ConsentRequest.Email: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_ConsentRequest.RequestTypes: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_ConsentRequest.Message: created as TEXT
• Field SpotMarket_ConsentRequest.Status: created as TEXT DEFAULT 'Nowy'
• Field SpotMarket_ConsentRequest.ResolvedAt: created as DATETIME
• Index SpotMarket_ConsentRequest.Created: created as index ("Created" ASC)
• Index SpotMarket_ConsentRequest.ClassName: created as index ("ClassName" ASC)
• SpotMarket_ContactSubmission
• Table SpotMarket_ContactSubmission: created
• Field SpotMarket_ContactSubmission.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field SpotMarket_ContactSubmission.ClassName: created as TEXT DEFAULT 'SpotMarket\Models\ContactSubmission'
• Field SpotMarket_ContactSubmission.LastEdited: created as DATETIME
• Field SpotMarket_ContactSubmission.Created: created as DATETIME
• Field SpotMarket_ContactSubmission.Name: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_ContactSubmission.Email: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_ContactSubmission.Company: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_ContactSubmission.Phone: created as VARCHAR(50) COLLATE NOCASE
• Field SpotMarket_ContactSubmission.Product: created as VARCHAR(50) COLLATE NOCASE
• Field SpotMarket_ContactSubmission.Message: created as TEXT
• Field SpotMarket_ContactSubmission.ConsentData: created as BOOL NOT NULL DEFAULT 0
• Field SpotMarket_ContactSubmission.ConsentMarketing: created as BOOL NOT NULL DEFAULT 0
• Index SpotMarket_ContactSubmission.Created: created as index ("Created" ASC)
• Index SpotMarket_ContactSubmission.ClassName: created as index ("ClassName" ASC)
• SpotMarket_HomeFeature
• Table SpotMarket_HomeFeature: created
• Field SpotMarket_HomeFeature.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field SpotMarket_HomeFeature.ClassName: created as TEXT DEFAULT 'SpotMarket\Models\HomeFeature'
• Field SpotMarket_HomeFeature.LastEdited: created as DATETIME
• Field SpotMarket_HomeFeature.Created: created as DATETIME
• Field SpotMarket_HomeFeature.Version: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SpotMarket_HomeFeature.Title: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_HomeFeature.Content: created as TEXT
• Field SpotMarket_HomeFeature.Icon: created as VARCHAR(30) COLLATE NOCASE
• Field SpotMarket_HomeFeature.Sort: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SpotMarket_HomeFeature.PageID: created as INTEGER(11) NOT NULL DEFAULT 0
• Index SpotMarket_HomeFeature.Sort: created as index ("Sort" ASC)
• Index SpotMarket_HomeFeature.ClassName: created as index ("ClassName" ASC)
• Index SpotMarket_HomeFeature.PageID: created as index ("PageID" ASC)
• Table SpotMarket_HomeFeature_Live: created
• Field SpotMarket_HomeFeature_Live.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field SpotMarket_HomeFeature_Live.ClassName: created as TEXT DEFAULT 'SpotMarket\Models\HomeFeature'
• Field SpotMarket_HomeFeature_Live.LastEdited: created as DATETIME
• Field SpotMarket_HomeFeature_Live.Created: created as DATETIME
• Field SpotMarket_HomeFeature_Live.Version: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SpotMarket_HomeFeature_Live.Title: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_HomeFeature_Live.Content: created as TEXT
• Field SpotMarket_HomeFeature_Live.Icon: created as VARCHAR(30) COLLATE NOCASE
• Field SpotMarket_HomeFeature_Live.Sort: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SpotMarket_HomeFeature_Live.PageID: created as INTEGER(11) NOT NULL DEFAULT 0
• Index SpotMarket_HomeFeature_Live.Sort: created as index ("Sort" ASC)
• Index SpotMarket_HomeFeature_Live.ClassName: created as index ("ClassName" ASC)
• Index SpotMarket_HomeFeature_Live.PageID: created as index ("PageID" ASC)
• Table SpotMarket_HomeFeature_Versions: created
• Field SpotMarket_HomeFeature_Versions.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field SpotMarket_HomeFeature_Versions.RecordID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SpotMarket_HomeFeature_Versions.Version: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SpotMarket_HomeFeature_Versions.WasPublished: created as BOOL NOT NULL DEFAULT 0
• Field SpotMarket_HomeFeature_Versions.WasDeleted: created as BOOL NOT NULL DEFAULT 0
• Field SpotMarket_HomeFeature_Versions.WasDraft: created as BOOL NOT NULL DEFAULT 1
• Field SpotMarket_HomeFeature_Versions.AuthorID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SpotMarket_HomeFeature_Versions.PublisherID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SpotMarket_HomeFeature_Versions.ClassName: created as TEXT DEFAULT 'SpotMarket\Models\HomeFeature'
• Field SpotMarket_HomeFeature_Versions.LastEdited: created as DATETIME
• Field SpotMarket_HomeFeature_Versions.Created: created as DATETIME
• Field SpotMarket_HomeFeature_Versions.Title: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_HomeFeature_Versions.Content: created as TEXT
• Field SpotMarket_HomeFeature_Versions.Icon: created as VARCHAR(30) COLLATE NOCASE
• Field SpotMarket_HomeFeature_Versions.Sort: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SpotMarket_HomeFeature_Versions.PageID: created as INTEGER(11) NOT NULL DEFAULT 0
• Index SpotMarket_HomeFeature_Versions.RecordID_Version: created as index ("RecordID" ASC,"Version" ASC)
• Index SpotMarket_HomeFeature_Versions.RecordID: created as index ("RecordID" ASC)
• Index SpotMarket_HomeFeature_Versions.Version: created as index ("Version" ASC)
• Index SpotMarket_HomeFeature_Versions.AuthorID: created as index ("AuthorID" ASC)
• Index SpotMarket_HomeFeature_Versions.PublisherID: created as index ("PublisherID" ASC)
• Index SpotMarket_HomeFeature_Versions.Sort: created as index ("Sort" ASC)
• Index SpotMarket_HomeFeature_Versions.ClassName: created as index ("ClassName" ASC)
• Index SpotMarket_HomeFeature_Versions.PageID: created as index ("PageID" ASC)
• SpotMarket_ProductBenefit
• Table SpotMarket_ProductBenefit: created
• Field SpotMarket_ProductBenefit.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field SpotMarket_ProductBenefit.ClassName: created as TEXT DEFAULT 'SpotMarket\Models\ProductBenefit'
• Field SpotMarket_ProductBenefit.LastEdited: created as DATETIME
• Field SpotMarket_ProductBenefit.Created: created as DATETIME
• Field SpotMarket_ProductBenefit.Version: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SpotMarket_ProductBenefit.Title: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_ProductBenefit.Sort: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SpotMarket_ProductBenefit.PageID: created as INTEGER(11) NOT NULL DEFAULT 0
• Index SpotMarket_ProductBenefit.Sort: created as index ("Sort" ASC)
• Index SpotMarket_ProductBenefit.ClassName: created as index ("ClassName" ASC)
• Index SpotMarket_ProductBenefit.PageID: created as index ("PageID" ASC)
• Table SpotMarket_ProductBenefit_Live: created
• Field SpotMarket_ProductBenefit_Live.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field SpotMarket_ProductBenefit_Live.ClassName: created as TEXT DEFAULT 'SpotMarket\Models\ProductBenefit'
• Field SpotMarket_ProductBenefit_Live.LastEdited: created as DATETIME
• Field SpotMarket_ProductBenefit_Live.Created: created as DATETIME
• Field SpotMarket_ProductBenefit_Live.Version: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SpotMarket_ProductBenefit_Live.Title: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_ProductBenefit_Live.Sort: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SpotMarket_ProductBenefit_Live.PageID: created as INTEGER(11) NOT NULL DEFAULT 0
• Index SpotMarket_ProductBenefit_Live.Sort: created as index ("Sort" ASC)
• Index SpotMarket_ProductBenefit_Live.ClassName: created as index ("ClassName" ASC)
• Index SpotMarket_ProductBenefit_Live.PageID: created as index ("PageID" ASC)
• Table SpotMarket_ProductBenefit_Versions: created
• Field SpotMarket_ProductBenefit_Versions.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field SpotMarket_ProductBenefit_Versions.RecordID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SpotMarket_ProductBenefit_Versions.Version: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SpotMarket_ProductBenefit_Versions.WasPublished: created as BOOL NOT NULL DEFAULT 0
• Field SpotMarket_ProductBenefit_Versions.WasDeleted: created as BOOL NOT NULL DEFAULT 0
• Field SpotMarket_ProductBenefit_Versions.WasDraft: created as BOOL NOT NULL DEFAULT 1
• Field SpotMarket_ProductBenefit_Versions.AuthorID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SpotMarket_ProductBenefit_Versions.PublisherID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SpotMarket_ProductBenefit_Versions.ClassName: created as TEXT DEFAULT 'SpotMarket\Models\ProductBenefit'
• Field SpotMarket_ProductBenefit_Versions.LastEdited: created as DATETIME
• Field SpotMarket_ProductBenefit_Versions.Created: created as DATETIME
• Field SpotMarket_ProductBenefit_Versions.Title: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_ProductBenefit_Versions.Sort: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SpotMarket_ProductBenefit_Versions.PageID: created as INTEGER(11) NOT NULL DEFAULT 0
• Index SpotMarket_ProductBenefit_Versions.RecordID_Version: created as index ("RecordID" ASC,"Version" ASC)
• Index SpotMarket_ProductBenefit_Versions.RecordID: created as index ("RecordID" ASC)
• Index SpotMarket_ProductBenefit_Versions.Version: created as index ("Version" ASC)
• Index SpotMarket_ProductBenefit_Versions.AuthorID: created as index ("AuthorID" ASC)
• Index SpotMarket_ProductBenefit_Versions.PublisherID: created as index ("PublisherID" ASC)
• Index SpotMarket_ProductBenefit_Versions.Sort: created as index ("Sort" ASC)
• Index SpotMarket_ProductBenefit_Versions.ClassName: created as index ("ClassName" ASC)
• Index SpotMarket_ProductBenefit_Versions.PageID: created as index ("PageID" ASC)
• SpotMarket_ProductModule
• Table SpotMarket_ProductModule: created
• Field SpotMarket_ProductModule.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field SpotMarket_ProductModule.ClassName: created as TEXT DEFAULT 'SpotMarket\Models\ProductModule'
• Field SpotMarket_ProductModule.LastEdited: created as DATETIME
• Field SpotMarket_ProductModule.Created: created as DATETIME
• Field SpotMarket_ProductModule.Version: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SpotMarket_ProductModule.Title: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_ProductModule.Content: created as TEXT
• Field SpotMarket_ProductModule.Icon: created as VARCHAR(30) COLLATE NOCASE
• Field SpotMarket_ProductModule.Sort: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SpotMarket_ProductModule.PageID: created as INTEGER(11) NOT NULL DEFAULT 0
• Index SpotMarket_ProductModule.Sort: created as index ("Sort" ASC)
• Index SpotMarket_ProductModule.ClassName: created as index ("ClassName" ASC)
• Index SpotMarket_ProductModule.PageID: created as index ("PageID" ASC)
• Table SpotMarket_ProductModule_Live: created
• Field SpotMarket_ProductModule_Live.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field SpotMarket_ProductModule_Live.ClassName: created as TEXT DEFAULT 'SpotMarket\Models\ProductModule'
• Field SpotMarket_ProductModule_Live.LastEdited: created as DATETIME
• Field SpotMarket_ProductModule_Live.Created: created as DATETIME
• Field SpotMarket_ProductModule_Live.Version: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SpotMarket_ProductModule_Live.Title: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_ProductModule_Live.Content: created as TEXT
• Field SpotMarket_ProductModule_Live.Icon: created as VARCHAR(30) COLLATE NOCASE
• Field SpotMarket_ProductModule_Live.Sort: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SpotMarket_ProductModule_Live.PageID: created as INTEGER(11) NOT NULL DEFAULT 0
• Index SpotMarket_ProductModule_Live.Sort: created as index ("Sort" ASC)
• Index SpotMarket_ProductModule_Live.ClassName: created as index ("ClassName" ASC)
• Index SpotMarket_ProductModule_Live.PageID: created as index ("PageID" ASC)
• Table SpotMarket_ProductModule_Versions: created
• Field SpotMarket_ProductModule_Versions.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field SpotMarket_ProductModule_Versions.RecordID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SpotMarket_ProductModule_Versions.Version: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SpotMarket_ProductModule_Versions.WasPublished: created as BOOL NOT NULL DEFAULT 0
• Field SpotMarket_ProductModule_Versions.WasDeleted: created as BOOL NOT NULL DEFAULT 0
• Field SpotMarket_ProductModule_Versions.WasDraft: created as BOOL NOT NULL DEFAULT 1
• Field SpotMarket_ProductModule_Versions.AuthorID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SpotMarket_ProductModule_Versions.PublisherID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SpotMarket_ProductModule_Versions.ClassName: created as TEXT DEFAULT 'SpotMarket\Models\ProductModule'
• Field SpotMarket_ProductModule_Versions.LastEdited: created as DATETIME
• Field SpotMarket_ProductModule_Versions.Created: created as DATETIME
• Field SpotMarket_ProductModule_Versions.Title: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_ProductModule_Versions.Content: created as TEXT
• Field SpotMarket_ProductModule_Versions.Icon: created as VARCHAR(30) COLLATE NOCASE
• Field SpotMarket_ProductModule_Versions.Sort: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SpotMarket_ProductModule_Versions.PageID: created as INTEGER(11) NOT NULL DEFAULT 0
• Index SpotMarket_ProductModule_Versions.RecordID_Version: created as index ("RecordID" ASC,"Version" ASC)
• Index SpotMarket_ProductModule_Versions.RecordID: created as index ("RecordID" ASC)
• Index SpotMarket_ProductModule_Versions.Version: created as index ("Version" ASC)
• Index SpotMarket_ProductModule_Versions.AuthorID: created as index ("AuthorID" ASC)
• Index SpotMarket_ProductModule_Versions.PublisherID: created as index ("PublisherID" ASC)
• Index SpotMarket_ProductModule_Versions.Sort: created as index ("Sort" ASC)
• Index SpotMarket_ProductModule_Versions.ClassName: created as index ("ClassName" ASC)
• Index SpotMarket_ProductModule_Versions.PageID: created as index ("PageID" ASC)
• SpotMarket_ProductStep
• Table SpotMarket_ProductStep: created
• Field SpotMarket_ProductStep.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field SpotMarket_ProductStep.ClassName: created as TEXT DEFAULT 'SpotMarket\Models\ProductStep'
• Field SpotMarket_ProductStep.LastEdited: created as DATETIME
• Field SpotMarket_ProductStep.Created: created as DATETIME
• Field SpotMarket_ProductStep.Version: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SpotMarket_ProductStep.Title: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_ProductStep.Sort: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SpotMarket_ProductStep.PageID: created as INTEGER(11) NOT NULL DEFAULT 0
• Index SpotMarket_ProductStep.Sort: created as index ("Sort" ASC)
• Index SpotMarket_ProductStep.ClassName: created as index ("ClassName" ASC)
• Index SpotMarket_ProductStep.PageID: created as index ("PageID" ASC)
• Table SpotMarket_ProductStep_Live: created
• Field SpotMarket_ProductStep_Live.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field SpotMarket_ProductStep_Live.ClassName: created as TEXT DEFAULT 'SpotMarket\Models\ProductStep'
• Field SpotMarket_ProductStep_Live.LastEdited: created as DATETIME
• Field SpotMarket_ProductStep_Live.Created: created as DATETIME
• Field SpotMarket_ProductStep_Live.Version: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SpotMarket_ProductStep_Live.Title: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_ProductStep_Live.Sort: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SpotMarket_ProductStep_Live.PageID: created as INTEGER(11) NOT NULL DEFAULT 0
• Index SpotMarket_ProductStep_Live.Sort: created as index ("Sort" ASC)
• Index SpotMarket_ProductStep_Live.ClassName: created as index ("ClassName" ASC)
• Index SpotMarket_ProductStep_Live.PageID: created as index ("PageID" ASC)
• Table SpotMarket_ProductStep_Versions: created
• Field SpotMarket_ProductStep_Versions.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field SpotMarket_ProductStep_Versions.RecordID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SpotMarket_ProductStep_Versions.Version: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SpotMarket_ProductStep_Versions.WasPublished: created as BOOL NOT NULL DEFAULT 0
• Field SpotMarket_ProductStep_Versions.WasDeleted: created as BOOL NOT NULL DEFAULT 0
• Field SpotMarket_ProductStep_Versions.WasDraft: created as BOOL NOT NULL DEFAULT 1
• Field SpotMarket_ProductStep_Versions.AuthorID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SpotMarket_ProductStep_Versions.PublisherID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SpotMarket_ProductStep_Versions.ClassName: created as TEXT DEFAULT 'SpotMarket\Models\ProductStep'
• Field SpotMarket_ProductStep_Versions.LastEdited: created as DATETIME
• Field SpotMarket_ProductStep_Versions.Created: created as DATETIME
• Field SpotMarket_ProductStep_Versions.Title: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_ProductStep_Versions.Sort: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SpotMarket_ProductStep_Versions.PageID: created as INTEGER(11) NOT NULL DEFAULT 0
• Index SpotMarket_ProductStep_Versions.RecordID_Version: created as index ("RecordID" ASC,"Version" ASC)
• Index SpotMarket_ProductStep_Versions.RecordID: created as index ("RecordID" ASC)
• Index SpotMarket_ProductStep_Versions.Version: created as index ("Version" ASC)
• Index SpotMarket_ProductStep_Versions.AuthorID: created as index ("AuthorID" ASC)
• Index SpotMarket_ProductStep_Versions.PublisherID: created as index ("PublisherID" ASC)
• Index SpotMarket_ProductStep_Versions.Sort: created as index ("Sort" ASC)
• Index SpotMarket_ProductStep_Versions.ClassName: created as index ("ClassName" ASC)
• Index SpotMarket_ProductStep_Versions.PageID: created as index ("PageID" ASC)
• SpotMarket_UILabel
• Table SpotMarket_UILabel: created
• Field SpotMarket_UILabel.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field SpotMarket_UILabel.ClassName: created as TEXT DEFAULT 'SpotMarket\Models\UILabel'
• Field SpotMarket_UILabel.LastEdited: created as DATETIME
• Field SpotMarket_UILabel.Created: created as DATETIME
• Field SpotMarket_UILabel.Key: created as VARCHAR(100) COLLATE NOCASE
• Field SpotMarket_UILabel.GroupName: created as VARCHAR(100) COLLATE NOCASE
• Field SpotMarket_UILabel.Value: created as TEXT
• Field SpotMarket_UILabel.Description: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_UILabel.AllowHTML: created as BOOL NOT NULL DEFAULT 0
• Index SpotMarket_UILabel.GroupName: created as index ("GroupName" ASC)
• Index SpotMarket_UILabel.Key: created as unique ("Key" ASC)
• Index SpotMarket_UILabel.default_sort_composite: created as index ("GroupName" ASC,"Key" ASC)
• Index SpotMarket_UILabel.ClassName: created as index ("ClassName" ASC)
• File
• Table File: created
• Field File.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field File.ClassName: created as TEXT DEFAULT 'SilverStripe\Assets\File'
• Field File.LastEdited: created as DATETIME
• Field File.Created: created as DATETIME
• Field File.Version: created as INTEGER(11) NOT NULL DEFAULT 0
• Field File.CanViewType: created as TEXT DEFAULT 'Inherit'
• Field File.CanEditType: created as TEXT DEFAULT 'Inherit'
• Field File.Name: created as VARCHAR(255) COLLATE NOCASE
• Field File.Title: created as VARCHAR(255) COLLATE NOCASE
• Field File.ShowInSearch: created as BOOL NOT NULL DEFAULT 1
• Field File.IsFolder: created as BOOL GENERATED ALWAYS AS (CASE WHEN "ClassName"='SilverStripe\\Assets\\Folder' THEN 1 ELSE 0 END) STORED
• Field File.ParentID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field File.OwnerID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field File.FileHash: created as VARCHAR(255) COLLATE NOCASE
• Field File.FileFilename: created as VARCHAR(255) COLLATE NOCASE
• Field File.FileVariant: created as VARCHAR(255) COLLATE NOCASE
• Index File.Name: created as index ("Name" ASC)
• Index File.ClassName: created as index ("ClassName" ASC)
• Index File.ParentID: created as index ("ParentID" ASC)
• Index File.OwnerID: created as index ("OwnerID" ASC)
• Index File.FileHash: created as index ("FileHash" ASC)
• Index File.default_asset_sort: created as index ("ParentID" ASC,"IsFolder" DESC,"Title" ASC)
• Table File_ViewerGroups: created
• Field File_ViewerGroups.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field File_ViewerGroups.FileID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field File_ViewerGroups.GroupID: created as INTEGER(11) NOT NULL DEFAULT 0
• Index File_ViewerGroups.FileID: created as index ("FileID" ASC)
• Index File_ViewerGroups.GroupID: created as index ("GroupID" ASC)
• Table File_EditorGroups: created
• Field File_EditorGroups.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field File_EditorGroups.FileID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field File_EditorGroups.GroupID: created as INTEGER(11) NOT NULL DEFAULT 0
• Index File_EditorGroups.FileID: created as index ("FileID" ASC)
• Index File_EditorGroups.GroupID: created as index ("GroupID" ASC)
• Table File_ViewerMembers: created
• Field File_ViewerMembers.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field File_ViewerMembers.FileID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field File_ViewerMembers.MemberID: created as INTEGER(11) NOT NULL DEFAULT 0
• Index File_ViewerMembers.FileID: created as index ("FileID" ASC)
• Index File_ViewerMembers.MemberID: created as index ("MemberID" ASC)
• Table File_EditorMembers: created
• Field File_EditorMembers.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field File_EditorMembers.FileID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field File_EditorMembers.MemberID: created as INTEGER(11) NOT NULL DEFAULT 0
• Index File_EditorMembers.FileID: created as index ("FileID" ASC)
• Index File_EditorMembers.MemberID: created as index ("MemberID" ASC)
• Table File_Live: created
• Field File_Live.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field File_Live.ClassName: created as TEXT DEFAULT 'SilverStripe\Assets\File'
• Field File_Live.LastEdited: created as DATETIME
• Field File_Live.Created: created as DATETIME
• Field File_Live.Version: created as INTEGER(11) NOT NULL DEFAULT 0
• Field File_Live.CanViewType: created as TEXT DEFAULT 'Inherit'
• Field File_Live.CanEditType: created as TEXT DEFAULT 'Inherit'
• Field File_Live.Name: created as VARCHAR(255) COLLATE NOCASE
• Field File_Live.Title: created as VARCHAR(255) COLLATE NOCASE
• Field File_Live.ShowInSearch: created as BOOL NOT NULL DEFAULT 1
• Field File_Live.IsFolder: created as BOOL GENERATED ALWAYS AS (CASE WHEN "ClassName"='SilverStripe\\Assets\\Folder' THEN 1 ELSE 0 END) STORED
• Field File_Live.ParentID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field File_Live.OwnerID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field File_Live.FileHash: created as VARCHAR(255) COLLATE NOCASE
• Field File_Live.FileFilename: created as VARCHAR(255) COLLATE NOCASE
• Field File_Live.FileVariant: created as VARCHAR(255) COLLATE NOCASE
• Index File_Live.Name: created as index ("Name" ASC)
• Index File_Live.ClassName: created as index ("ClassName" ASC)
• Index File_Live.ParentID: created as index ("ParentID" ASC)
• Index File_Live.OwnerID: created as index ("OwnerID" ASC)
• Index File_Live.FileHash: created as index ("FileHash" ASC)
• Index File_Live.default_asset_sort: created as index ("ParentID" ASC,"IsFolder" DESC,"Title" ASC)
• Table File_Versions: created
• Field File_Versions.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field File_Versions.RecordID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field File_Versions.Version: created as INTEGER(11) NOT NULL DEFAULT 0
• Field File_Versions.WasPublished: created as BOOL NOT NULL DEFAULT 0
• Field File_Versions.WasDeleted: created as BOOL NOT NULL DEFAULT 0
• Field File_Versions.WasDraft: created as BOOL NOT NULL DEFAULT 1
• Field File_Versions.AuthorID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field File_Versions.PublisherID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field File_Versions.ClassName: created as TEXT DEFAULT 'SilverStripe\Assets\File'
• Field File_Versions.LastEdited: created as DATETIME
• Field File_Versions.Created: created as DATETIME
• Field File_Versions.CanViewType: created as TEXT DEFAULT 'Inherit'
• Field File_Versions.CanEditType: created as TEXT DEFAULT 'Inherit'
• Field File_Versions.Name: created as VARCHAR(255) COLLATE NOCASE
• Field File_Versions.Title: created as VARCHAR(255) COLLATE NOCASE
• Field File_Versions.ShowInSearch: created as BOOL NOT NULL DEFAULT 1
• Field File_Versions.IsFolder: created as BOOL GENERATED ALWAYS AS (CASE WHEN "ClassName"='SilverStripe\\Assets\\Folder' THEN 1 ELSE 0 END) STORED
• Field File_Versions.ParentID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field File_Versions.OwnerID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field File_Versions.FileHash: created as VARCHAR(255) COLLATE NOCASE
• Field File_Versions.FileFilename: created as VARCHAR(255) COLLATE NOCASE
• Field File_Versions.FileVariant: created as VARCHAR(255) COLLATE NOCASE
• Index File_Versions.RecordID_Version: created as index ("RecordID" ASC,"Version" ASC)
• Index File_Versions.RecordID: created as index ("RecordID" ASC)
• Index File_Versions.Version: created as index ("Version" ASC)
• Index File_Versions.AuthorID: created as index ("AuthorID" ASC)
• Index File_Versions.PublisherID: created as index ("PublisherID" ASC)
• Index File_Versions.Name: created as index ("Name" ASC)
• Index File_Versions.ClassName: created as index ("ClassName" ASC)
• Index File_Versions.ParentID: created as index ("ParentID" ASC)
• Index File_Versions.OwnerID: created as index ("OwnerID" ASC)
• Index File_Versions.FileHash: created as index ("FileHash" ASC)
• Index File_Versions.default_asset_sort: created as index ("ParentID" ASC,"IsFolder" DESC,"Title" ASC)
• SiteConfig
• Table SiteConfig: created
• Field SiteConfig.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field SiteConfig.ClassName: created as TEXT DEFAULT 'SilverStripe\SiteConfig\SiteConfig'
• Field SiteConfig.LastEdited: created as DATETIME
• Field SiteConfig.Created: created as DATETIME
• Field SiteConfig.Phone: created as VARCHAR(50) COLLATE NOCASE
• Field SiteConfig.Email: created as VARCHAR(255) COLLATE NOCASE
• Field SiteConfig.AddressStreet: created as VARCHAR(255) COLLATE NOCASE
• Field SiteConfig.PostalCode: created as VARCHAR(20) COLLATE NOCASE
• Field SiteConfig.City: created as VARCHAR(100) COLLATE NOCASE
• Field SiteConfig.CountryCode: created as VARCHAR(2) COLLATE NOCASE
• Field SiteConfig.MapsUrl: created as VARCHAR(500) COLLATE NOCASE
• Field SiteConfig.ResponseTime: created as VARCHAR(50) COLLATE NOCASE
• Field SiteConfig.FooterText: created as TEXT
• Field SiteConfig.CompanyDetails: created as VARCHAR(255) COLLATE NOCASE
• Field SiteConfig.CTATitle: created as VARCHAR(255) COLLATE NOCASE
• Field SiteConfig.CTAText: created as TEXT
• Field SiteConfig.Title: created as VARCHAR(255) COLLATE NOCASE
• Field SiteConfig.Tagline: created as VARCHAR(255) COLLATE NOCASE
• Field SiteConfig.CanViewType: created as TEXT DEFAULT 'Anyone'
• Field SiteConfig.CanEditType: created as TEXT DEFAULT 'LoggedInUsers'
• Field SiteConfig.CanCreateTopLevelType: created as TEXT DEFAULT 'LoggedInUsers'
• Field SiteConfig.OgImageID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SiteConfig.PrivacyPolicyPageID: created as INTEGER(11) NOT NULL DEFAULT 0
• Index SiteConfig.ClassName: created as index ("ClassName" ASC)
• Index SiteConfig.OgImageID: created as index ("OgImageID" ASC)
• Index SiteConfig.PrivacyPolicyPageID: created as index ("PrivacyPolicyPageID" ASC)
• Table SiteConfig_FooterLinks: created
• Field SiteConfig_FooterLinks.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field SiteConfig_FooterLinks.SiteConfigID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SiteConfig_FooterLinks.SiteTreeID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SiteConfig_FooterLinks.FooterSort: created as INTEGER(11) NOT NULL DEFAULT 0
• Index SiteConfig_FooterLinks.SiteConfigID: created as index ("SiteConfigID" ASC)
• Index SiteConfig_FooterLinks.SiteTreeID: created as index ("SiteTreeID" ASC)
• Table SiteConfig_ViewerGroups: created
• Field SiteConfig_ViewerGroups.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field SiteConfig_ViewerGroups.SiteConfigID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SiteConfig_ViewerGroups.GroupID: created as INTEGER(11) NOT NULL DEFAULT 0
• Index SiteConfig_ViewerGroups.SiteConfigID: created as index ("SiteConfigID" ASC)
• Index SiteConfig_ViewerGroups.GroupID: created as index ("GroupID" ASC)
• Table SiteConfig_EditorGroups: created
• Field SiteConfig_EditorGroups.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field SiteConfig_EditorGroups.SiteConfigID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SiteConfig_EditorGroups.GroupID: created as INTEGER(11) NOT NULL DEFAULT 0
• Index SiteConfig_EditorGroups.SiteConfigID: created as index ("SiteConfigID" ASC)
• Index SiteConfig_EditorGroups.GroupID: created as index ("GroupID" ASC)
• Table SiteConfig_CreateTopLevelGroups: created
• Field SiteConfig_CreateTopLevelGroups.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field SiteConfig_CreateTopLevelGroups.SiteConfigID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SiteConfig_CreateTopLevelGroups.GroupID: created as INTEGER(11) NOT NULL DEFAULT 0
• Index SiteConfig_CreateTopLevelGroups.SiteConfigID: created as index ("SiteConfigID" ASC)
• Index SiteConfig_CreateTopLevelGroups.GroupID: created as index ("GroupID" ASC)
• Table SiteConfig_ViewerMembers: created
• Field SiteConfig_ViewerMembers.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field SiteConfig_ViewerMembers.SiteConfigID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SiteConfig_ViewerMembers.MemberID: created as INTEGER(11) NOT NULL DEFAULT 0
• Index SiteConfig_ViewerMembers.SiteConfigID: created as index ("SiteConfigID" ASC)
• Index SiteConfig_ViewerMembers.MemberID: created as index ("MemberID" ASC)
• Table SiteConfig_EditorMembers: created
• Field SiteConfig_EditorMembers.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field SiteConfig_EditorMembers.SiteConfigID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SiteConfig_EditorMembers.MemberID: created as INTEGER(11) NOT NULL DEFAULT 0
• Index SiteConfig_EditorMembers.SiteConfigID: created as index ("SiteConfigID" ASC)
• Index SiteConfig_EditorMembers.MemberID: created as index ("MemberID" ASC)
• Table SiteConfig_CreateTopLevelMembers: created
• Field SiteConfig_CreateTopLevelMembers.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field SiteConfig_CreateTopLevelMembers.SiteConfigID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SiteConfig_CreateTopLevelMembers.MemberID: created as INTEGER(11) NOT NULL DEFAULT 0
• Index SiteConfig_CreateTopLevelMembers.SiteConfigID: created as index ("SiteConfigID" ASC)
• Index SiteConfig_CreateTopLevelMembers.MemberID: created as index ("MemberID" ASC)
• ChangeSet
• Table ChangeSet: created
• Field ChangeSet.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field ChangeSet.ClassName: created as TEXT DEFAULT 'SilverStripe\Versioned\ChangeSet'
• Field ChangeSet.LastEdited: created as DATETIME
• Field ChangeSet.Created: created as DATETIME
• Field ChangeSet.Name: created as VARCHAR(255) COLLATE NOCASE
• Field ChangeSet.State: created as TEXT DEFAULT 'open'
• Field ChangeSet.IsInferred: created as BOOL NOT NULL DEFAULT 0
• Field ChangeSet.Description: created as TEXT
• Field ChangeSet.PublishDate: created as DATETIME
• Field ChangeSet.LastSynced: created as DATETIME
• Field ChangeSet.OwnerID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field ChangeSet.PublisherID: created as INTEGER(11) NOT NULL DEFAULT 0
• Index ChangeSet.State: created as index ("State" ASC)
• Index ChangeSet.ClassName: created as index ("ClassName" ASC)
• Index ChangeSet.OwnerID: created as index ("OwnerID" ASC)
• Index ChangeSet.PublisherID: created as index ("PublisherID" ASC)
• ChangeSetItem
• Table ChangeSetItem: created
• Field ChangeSetItem.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field ChangeSetItem.ClassName: created as TEXT DEFAULT 'SilverStripe\Versioned\ChangeSetItem'
• Field ChangeSetItem.LastEdited: created as DATETIME
• Field ChangeSetItem.Created: created as DATETIME
• Field ChangeSetItem.VersionBefore: created as INTEGER(11) NOT NULL DEFAULT 0
• Field ChangeSetItem.VersionAfter: created as INTEGER(11) NOT NULL DEFAULT 0
• Field ChangeSetItem.Added: created as TEXT DEFAULT 'implicitly'
• Field ChangeSetItem.ChangeSetID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field ChangeSetItem.ObjectID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field ChangeSetItem.ObjectClass: created as TEXT DEFAULT 'SpotMarket\Models\ConsentRequest'
• Index ChangeSetItem.ClassName: created as index ("ClassName" ASC)
• Index ChangeSetItem.ChangeSetID: created as index ("ChangeSetID" ASC)
• Index ChangeSetItem.Object: created as index ("ObjectID" ASC,"ObjectClass" ASC)
• Index ChangeSetItem.ObjectUniquePerChangeSet: created as unique ("ObjectID" ASC,"ObjectClass" ASC,"ChangeSetID" ASC)
• Table ChangeSetItem_ReferencedBy: created
• Field ChangeSetItem_ReferencedBy.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field ChangeSetItem_ReferencedBy.ChangeSetItemID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field ChangeSetItem_ReferencedBy.ChildID: created as INTEGER(11) NOT NULL DEFAULT 0
• Index ChangeSetItem_ReferencedBy.ChangeSetItemID: created as index ("ChangeSetItemID" ASC)
• Index ChangeSetItem_ReferencedBy.ChildID: created as index ("ChildID" ASC)
• FileLink
• Table FileLink: created
• Field FileLink.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field FileLink.ClassName: created as TEXT DEFAULT 'SilverStripe\Assets\Shortcodes\FileLink'
• Field FileLink.LastEdited: created as DATETIME
• Field FileLink.Created: created as DATETIME
• Field FileLink.LinkedID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field FileLink.ParentID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field FileLink.ParentClass: created as TEXT DEFAULT 'SpotMarket\Models\ConsentRequest'
• Index FileLink.ClassName: created as index ("ClassName" ASC)
• Index FileLink.LinkedID: created as index ("LinkedID" ASC)
• Index FileLink.Parent: created as index ("ParentID" ASC,"ParentClass" ASC)
• SiteTree
• Table SiteTree: created
• Field SiteTree.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field SiteTree.ClassName: created as TEXT DEFAULT 'Page'
• Field SiteTree.LastEdited: created as DATETIME
• Field SiteTree.Created: created as DATETIME
• Field SiteTree.Priority: created as VARCHAR(5) COLLATE NOCASE
• Field SiteTree.CanViewType: created as TEXT DEFAULT 'Inherit'
• Field SiteTree.CanEditType: created as TEXT DEFAULT 'Inherit'
• Field SiteTree.Version: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SiteTree.Title: created as VARCHAR(255) COLLATE NOCASE
• Field SiteTree.URLSegment: created as VARCHAR(255) COLLATE NOCASE
• Field SiteTree.MenuTitle: created as VARCHAR(100) COLLATE NOCASE
• Field SiteTree.Content: created as TEXT
• Field SiteTree.MetaDescription: created as TEXT
• Field SiteTree.ExtraMeta: created as TEXT
• Field SiteTree.ShowInMenus: created as BOOL NOT NULL DEFAULT 0
• Field SiteTree.ShowInSearch: created as BOOL NOT NULL DEFAULT 0
• Field SiteTree.Sort: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SiteTree.HasBrokenFile: created as BOOL NOT NULL DEFAULT 0
• Field SiteTree.HasBrokenLink: created as BOOL NOT NULL DEFAULT 0
• Field SiteTree.ReportClass: created as VARCHAR(255) COLLATE NOCASE
• Field SiteTree.ParentID: created as INTEGER(11) NOT NULL DEFAULT 0
• Index SiteTree.Sort: created as index ("Sort" ASC)
• Index SiteTree.ClassName: created as index ("ClassName" ASC)
• Index SiteTree.ParentID: created as index ("ParentID" ASC)
• Index SiteTree.URLSegment: created as index ("URLSegment" ASC)
• Table SiteTree_ViewerGroups: created
• Field SiteTree_ViewerGroups.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field SiteTree_ViewerGroups.SiteTreeID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SiteTree_ViewerGroups.GroupID: created as INTEGER(11) NOT NULL DEFAULT 0
• Index SiteTree_ViewerGroups.SiteTreeID: created as index ("SiteTreeID" ASC)
• Index SiteTree_ViewerGroups.GroupID: created as index ("GroupID" ASC)
• Table SiteTree_EditorGroups: created
• Field SiteTree_EditorGroups.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field SiteTree_EditorGroups.SiteTreeID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SiteTree_EditorGroups.GroupID: created as INTEGER(11) NOT NULL DEFAULT 0
• Index SiteTree_EditorGroups.SiteTreeID: created as index ("SiteTreeID" ASC)
• Index SiteTree_EditorGroups.GroupID: created as index ("GroupID" ASC)
• Table SiteTree_ViewerMembers: created
• Field SiteTree_ViewerMembers.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field SiteTree_ViewerMembers.SiteTreeID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SiteTree_ViewerMembers.MemberID: created as INTEGER(11) NOT NULL DEFAULT 0
• Index SiteTree_ViewerMembers.SiteTreeID: created as index ("SiteTreeID" ASC)
• Index SiteTree_ViewerMembers.MemberID: created as index ("MemberID" ASC)
• Table SiteTree_EditorMembers: created
• Field SiteTree_EditorMembers.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field SiteTree_EditorMembers.SiteTreeID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SiteTree_EditorMembers.MemberID: created as INTEGER(11) NOT NULL DEFAULT 0
• Index SiteTree_EditorMembers.SiteTreeID: created as index ("SiteTreeID" ASC)
• Index SiteTree_EditorMembers.MemberID: created as index ("MemberID" ASC)
• Table SiteTree_Live: created
• Field SiteTree_Live.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field SiteTree_Live.ClassName: created as TEXT DEFAULT 'Page'
• Field SiteTree_Live.LastEdited: created as DATETIME
• Field SiteTree_Live.Created: created as DATETIME
• Field SiteTree_Live.Priority: created as VARCHAR(5) COLLATE NOCASE
• Field SiteTree_Live.CanViewType: created as TEXT DEFAULT 'Inherit'
• Field SiteTree_Live.CanEditType: created as TEXT DEFAULT 'Inherit'
• Field SiteTree_Live.Version: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SiteTree_Live.Title: created as VARCHAR(255) COLLATE NOCASE
• Field SiteTree_Live.URLSegment: created as VARCHAR(255) COLLATE NOCASE
• Field SiteTree_Live.MenuTitle: created as VARCHAR(100) COLLATE NOCASE
• Field SiteTree_Live.Content: created as TEXT
• Field SiteTree_Live.MetaDescription: created as TEXT
• Field SiteTree_Live.ExtraMeta: created as TEXT
• Field SiteTree_Live.ShowInMenus: created as BOOL NOT NULL DEFAULT 0
• Field SiteTree_Live.ShowInSearch: created as BOOL NOT NULL DEFAULT 0
• Field SiteTree_Live.Sort: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SiteTree_Live.HasBrokenFile: created as BOOL NOT NULL DEFAULT 0
• Field SiteTree_Live.HasBrokenLink: created as BOOL NOT NULL DEFAULT 0
• Field SiteTree_Live.ReportClass: created as VARCHAR(255) COLLATE NOCASE
• Field SiteTree_Live.ParentID: created as INTEGER(11) NOT NULL DEFAULT 0
• Index SiteTree_Live.Sort: created as index ("Sort" ASC)
• Index SiteTree_Live.ClassName: created as index ("ClassName" ASC)
• Index SiteTree_Live.ParentID: created as index ("ParentID" ASC)
• Index SiteTree_Live.URLSegment: created as index ("URLSegment" ASC)
• Table SiteTree_Versions: created
• Field SiteTree_Versions.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field SiteTree_Versions.RecordID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SiteTree_Versions.Version: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SiteTree_Versions.WasPublished: created as BOOL NOT NULL DEFAULT 0
• Field SiteTree_Versions.WasDeleted: created as BOOL NOT NULL DEFAULT 0
• Field SiteTree_Versions.WasDraft: created as BOOL NOT NULL DEFAULT 1
• Field SiteTree_Versions.AuthorID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SiteTree_Versions.PublisherID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SiteTree_Versions.ClassName: created as TEXT DEFAULT 'Page'
• Field SiteTree_Versions.LastEdited: created as DATETIME
• Field SiteTree_Versions.Created: created as DATETIME
• Field SiteTree_Versions.Priority: created as VARCHAR(5) COLLATE NOCASE
• Field SiteTree_Versions.CanViewType: created as TEXT DEFAULT 'Inherit'
• Field SiteTree_Versions.CanEditType: created as TEXT DEFAULT 'Inherit'
• Field SiteTree_Versions.Title: created as VARCHAR(255) COLLATE NOCASE
• Field SiteTree_Versions.URLSegment: created as VARCHAR(255) COLLATE NOCASE
• Field SiteTree_Versions.MenuTitle: created as VARCHAR(100) COLLATE NOCASE
• Field SiteTree_Versions.Content: created as TEXT
• Field SiteTree_Versions.MetaDescription: created as TEXT
• Field SiteTree_Versions.ExtraMeta: created as TEXT
• Field SiteTree_Versions.ShowInMenus: created as BOOL NOT NULL DEFAULT 0
• Field SiteTree_Versions.ShowInSearch: created as BOOL NOT NULL DEFAULT 0
• Field SiteTree_Versions.Sort: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SiteTree_Versions.HasBrokenFile: created as BOOL NOT NULL DEFAULT 0
• Field SiteTree_Versions.HasBrokenLink: created as BOOL NOT NULL DEFAULT 0
• Field SiteTree_Versions.ReportClass: created as VARCHAR(255) COLLATE NOCASE
• Field SiteTree_Versions.ParentID: created as INTEGER(11) NOT NULL DEFAULT 0
• Index SiteTree_Versions.RecordID_Version: created as index ("RecordID" ASC,"Version" ASC)
• Index SiteTree_Versions.RecordID: created as index ("RecordID" ASC)
• Index SiteTree_Versions.Version: created as index ("Version" ASC)
• Index SiteTree_Versions.AuthorID: created as index ("AuthorID" ASC)
• Index SiteTree_Versions.PublisherID: created as index ("PublisherID" ASC)
• Index SiteTree_Versions.Sort: created as index ("Sort" ASC)
• Index SiteTree_Versions.ClassName: created as index ("ClassName" ASC)
• Index SiteTree_Versions.ParentID: created as index ("ParentID" ASC)
• Index SiteTree_Versions.URLSegment: created as index ("URLSegment" ASC)
• SiteTreeLink
• Table SiteTreeLink: created
• Field SiteTreeLink.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field SiteTreeLink.ClassName: created as TEXT DEFAULT 'SilverStripe\CMS\Model\SiteTreeLink'
• Field SiteTreeLink.LastEdited: created as DATETIME
• Field SiteTreeLink.Created: created as DATETIME
• Field SiteTreeLink.LinkedID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SiteTreeLink.ParentID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SiteTreeLink.ParentClass: created as TEXT DEFAULT 'SpotMarket\Models\ConsentRequest'
• Index SiteTreeLink.ClassName: created as index ("ClassName" ASC)
• Index SiteTreeLink.LinkedID: created as index ("LinkedID" ASC)
• Index SiteTreeLink.Parent: created as index ("ParentID" ASC,"ParentClass" ASC)
• Group
• Table Group: created
• Field Group.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field Group.ClassName: created as TEXT DEFAULT 'SilverStripe\Security\Group'
• Field Group.LastEdited: created as DATETIME
• Field Group.Created: created as DATETIME
• Field Group.Title: created as VARCHAR(255) COLLATE NOCASE
• Field Group.Description: created as TEXT
• Field Group.Code: created as VARCHAR(255) COLLATE NOCASE
• Field Group.Locked: created as BOOL NOT NULL DEFAULT 0
• Field Group.Sort: created as INTEGER(11) NOT NULL DEFAULT 0
• Field Group.HtmlEditorConfig: created as TEXT
• Field Group.ParentID: created as INTEGER(11) NOT NULL DEFAULT 0
• Index Group.ClassName: created as index ("ClassName" ASC)
• Index Group.ParentID: created as index ("ParentID" ASC)
• Index Group.Title: created as index ("Title" ASC)
• Index Group.Code: created as index ("Code" ASC)
• Index Group.Sort: created as index ("Sort" ASC)
• Table Group_Members: created
• Field Group_Members.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field Group_Members.GroupID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field Group_Members.MemberID: created as INTEGER(11) NOT NULL DEFAULT 0
• Index Group_Members.GroupID: created as index ("GroupID" ASC)
• Index Group_Members.MemberID: created as index ("MemberID" ASC)
• Table Group_Roles: created
• Field Group_Roles.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field Group_Roles.GroupID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field Group_Roles.PermissionRoleID: created as INTEGER(11) NOT NULL DEFAULT 0
• Index Group_Roles.GroupID: created as index ("GroupID" ASC)
• Index Group_Roles.PermissionRoleID: created as index ("PermissionRoleID" ASC)
• LoginAttempt
• Table LoginAttempt: created
• Field LoginAttempt.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field LoginAttempt.ClassName: created as TEXT DEFAULT 'SilverStripe\Security\LoginAttempt'
• Field LoginAttempt.LastEdited: created as DATETIME
• Field LoginAttempt.Created: created as DATETIME
• Field LoginAttempt.EmailHashed: created as VARCHAR(255) COLLATE NOCASE
• Field LoginAttempt.Status: created as TEXT DEFAULT 'Success'
• Field LoginAttempt.IP: created as VARCHAR(255) COLLATE NOCASE
• Field LoginAttempt.MemberID: created as INTEGER(11) NOT NULL DEFAULT 0
• Index LoginAttempt.ClassName: created as index ("ClassName" ASC)
• Index LoginAttempt.MemberID: created as index ("MemberID" ASC)
• Index LoginAttempt.EmailHashed: created as index ("EmailHashed" ASC)
• Member
• Table Member: created
• Field Member.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field Member.ClassName: created as TEXT DEFAULT 'SilverStripe\Security\Member'
• Field Member.LastEdited: created as DATETIME
• Field Member.Created: created as DATETIME
• Field Member.FirstName: created as VARCHAR(255) COLLATE NOCASE
• Field Member.Surname: created as VARCHAR(255) COLLATE NOCASE
• Field Member.Email: created as VARCHAR(254) COLLATE NOCASE
• Field Member.TempIDHash: created as VARCHAR(160) COLLATE NOCASE
• Field Member.TempIDExpired: created as DATETIME
• Field Member.Password: created as VARCHAR(160) COLLATE NOCASE
• Field Member.AutoLoginHash: created as VARCHAR(160) COLLATE NOCASE
• Field Member.AutoLoginExpired: created as DATETIME
• Field Member.AutoLoginTempHash: created as VARCHAR(64) COLLATE NOCASE
• Field Member.PasswordEncryption: created as VARCHAR(50) COLLATE NOCASE
• Field Member.Salt: created as VARCHAR(50) COLLATE NOCASE
• Field Member.PasswordExpiry: created as TEXT
• Field Member.LockedOutUntil: created as DATETIME
• Field Member.Locale: created as VARCHAR(6) COLLATE NOCASE
• Field Member.FailedLoginCount: created as INTEGER(11) NOT NULL DEFAULT 0
• Index Member.Surname: created as index ("Surname" ASC)
• Index Member.FirstName: created as index ("FirstName" ASC)
• Index Member.default_sort_composite: created as index ("Surname" ASC,"FirstName" ASC)
• Index Member.ClassName: created as index ("ClassName" ASC)
• Index Member.Email: created as index ("Email" ASC)
• Index Member.AutoLoginHash: created as index ("AutoLoginHash" ASC)
• Index Member.AutoLoginTempHash: created as index ("AutoLoginTempHash" ASC)
• Index Member.TempIDHash: created as index ("TempIDHash" ASC)
• MemberPassword
• Table MemberPassword: created
• Field MemberPassword.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field MemberPassword.ClassName: created as TEXT DEFAULT 'SilverStripe\Security\MemberPassword'
• Field MemberPassword.LastEdited: created as DATETIME
• Field MemberPassword.Created: created as DATETIME
• Field MemberPassword.Password: created as VARCHAR(160) COLLATE NOCASE
• Field MemberPassword.Salt: created as VARCHAR(50) COLLATE NOCASE
• Field MemberPassword.PasswordEncryption: created as VARCHAR(50) COLLATE NOCASE
• Field MemberPassword.MemberID: created as INTEGER(11) NOT NULL DEFAULT 0
• Index MemberPassword.ClassName: created as index ("ClassName" ASC)
• Index MemberPassword.MemberID: created as index ("MemberID" ASC)
• Permission
• Table Permission: created
• Field Permission.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field Permission.ClassName: created as TEXT DEFAULT 'SilverStripe\Security\Permission'
• Field Permission.LastEdited: created as DATETIME
• Field Permission.Created: created as DATETIME
• Field Permission.Code: created as VARCHAR(255) COLLATE NOCASE
• Field Permission.Arg: created as INTEGER(11) NOT NULL DEFAULT 0
• Field Permission.Type: created as INTEGER(11) NOT NULL DEFAULT 1
• Field Permission.GroupID: created as INTEGER(11) NOT NULL DEFAULT 0
• Index Permission.ClassName: created as index ("ClassName" ASC)
• Index Permission.GroupID: created as index ("GroupID" ASC)
• Index Permission.Code_GroupID: created as index ("Code" ASC,"GroupID" ASC)
• PermissionRole
• Table PermissionRole: created
• Field PermissionRole.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field PermissionRole.ClassName: created as TEXT DEFAULT 'SilverStripe\Security\PermissionRole'
• Field PermissionRole.LastEdited: created as DATETIME
• Field PermissionRole.Created: created as DATETIME
• Field PermissionRole.Title: created as VARCHAR(255) COLLATE NOCASE
• Field PermissionRole.OnlyAdminCanApply: created as BOOL NOT NULL DEFAULT 0
• Index PermissionRole.Title: created as index ("Title" ASC)
• Index PermissionRole.ClassName: created as index ("ClassName" ASC)
• PermissionRoleCode
• Table PermissionRoleCode: created
• Field PermissionRoleCode.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field PermissionRoleCode.ClassName: created as TEXT DEFAULT 'SilverStripe\Security\PermissionRoleCode'
• Field PermissionRoleCode.LastEdited: created as DATETIME
• Field PermissionRoleCode.Created: created as DATETIME
• Field PermissionRoleCode.Code: created as VARCHAR(255) COLLATE NOCASE
• Field PermissionRoleCode.RoleID: created as INTEGER(11) NOT NULL DEFAULT 0
• Index PermissionRoleCode.ClassName: created as index ("ClassName" ASC)
• Index PermissionRoleCode.RoleID: created as index ("RoleID" ASC)
• Index PermissionRoleCode.Code_RoleID: created as index ("Code" ASC,"RoleID" ASC)
• RememberLoginHash
• Table RememberLoginHash: created
• Field RememberLoginHash.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field RememberLoginHash.ClassName: created as TEXT DEFAULT 'SilverStripe\Security\RememberLoginHash'
• Field RememberLoginHash.LastEdited: created as DATETIME
• Field RememberLoginHash.Created: created as DATETIME
• Field RememberLoginHash.DeviceID: created as VARCHAR(40) COLLATE NOCASE
• Field RememberLoginHash.Hash: created as VARCHAR(160) COLLATE NOCASE
• Field RememberLoginHash.ExpiryDate: created as DATETIME
• Field RememberLoginHash.LoginSessionID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field RememberLoginHash.MemberID: created as INTEGER(11) NOT NULL DEFAULT 0
• Index RememberLoginHash.ClassName: created as index ("ClassName" ASC)
• Index RememberLoginHash.LoginSessionID: created as index ("LoginSessionID" ASC)
• Index RememberLoginHash.MemberID: created as index ("MemberID" ASC)
• Index RememberLoginHash.DeviceID: created as index ("DeviceID" ASC)
• Index RememberLoginHash.Hash: created as index ("Hash" ASC)
• LoginSession
• Table LoginSession: created
• Field LoginSession.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field LoginSession.ClassName: created as TEXT DEFAULT 'SilverStripe\SessionManager\Models\LoginSession'
• Field LoginSession.LastEdited: created as DATETIME
• Field LoginSession.Created: created as DATETIME
• Field LoginSession.LastAccessed: created as DATETIME
• Field LoginSession.IPAddress: created as VARCHAR(45) COLLATE NOCASE
• Field LoginSession.UserAgent: created as TEXT
• Field LoginSession.Persistent: created as BOOL NOT NULL DEFAULT 0
• Field LoginSession.MemberID: created as INTEGER(11) NOT NULL DEFAULT 0
• Index LoginSession.LastAccessed: created as index ("LastAccessed" ASC)
• Index LoginSession.ClassName: created as index ("ClassName" ASC)
• Index LoginSession.MemberID: created as index ("MemberID" ASC)
• BrokenExternalLink
• Table BrokenExternalLink: created
• Field BrokenExternalLink.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field BrokenExternalLink.ClassName: created as TEXT DEFAULT 'SilverStripe\Reports\ExternalLinks\Model\BrokenExternalLink'
• Field BrokenExternalLink.LastEdited: created as DATETIME
• Field BrokenExternalLink.Created: created as DATETIME
• Field BrokenExternalLink.Link: created as VARCHAR(2083) COLLATE NOCASE
• Field BrokenExternalLink.HTTPCode: created as INTEGER(11) NOT NULL DEFAULT 0
• Field BrokenExternalLink.TrackID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field BrokenExternalLink.StatusID: created as INTEGER(11) NOT NULL DEFAULT 0
• Index BrokenExternalLink.ClassName: created as index ("ClassName" ASC)
• Index BrokenExternalLink.TrackID: created as index ("TrackID" ASC)
• Index BrokenExternalLink.StatusID: created as index ("StatusID" ASC)
• BrokenExternalPageTrack
• Table BrokenExternalPageTrack: created
• Field BrokenExternalPageTrack.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field BrokenExternalPageTrack.ClassName: created as TEXT DEFAULT 'SilverStripe\Reports\ExternalLinks\Model\BrokenExternalPageTrack'
• Field BrokenExternalPageTrack.LastEdited: created as DATETIME
• Field BrokenExternalPageTrack.Created: created as DATETIME
• Field BrokenExternalPageTrack.Processed: created as BOOL NOT NULL DEFAULT 0
• Field BrokenExternalPageTrack.PageID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field BrokenExternalPageTrack.StatusID: created as INTEGER(11) NOT NULL DEFAULT 0
• Index BrokenExternalPageTrack.ClassName: created as index ("ClassName" ASC)
• Index BrokenExternalPageTrack.PageID: created as index ("PageID" ASC)
• Index BrokenExternalPageTrack.StatusID: created as index ("StatusID" ASC)
• BrokenExternalPageTrackStatus
• Table BrokenExternalPageTrackStatus: created
• Field BrokenExternalPageTrackStatus.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field BrokenExternalPageTrackStatus.ClassName: created as TEXT DEFAULT 'SilverStripe\Reports\ExternalLinks\Model\BrokenExternalPageTrackStatus'
• Field BrokenExternalPageTrackStatus.LastEdited: created as DATETIME
• Field BrokenExternalPageTrackStatus.Created: created as DATETIME
• Field BrokenExternalPageTrackStatus.Status: created as TEXT DEFAULT 'Running'
• Field BrokenExternalPageTrackStatus.JobInfo: created as VARCHAR(255) COLLATE NOCASE
• Index BrokenExternalPageTrackStatus.ClassName: created as index ("ClassName" ASC)
• Folder
• Image
• Page
• Table Page: created
• Field Page.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field Page.MetaTitle: created as VARCHAR(255) COLLATE NOCASE
• Field Page.HideCTA: created as BOOL NOT NULL DEFAULT 0
• Field Page.CTATitleOverride: created as VARCHAR(255) COLLATE NOCASE
• Field Page.CTATextOverride: created as TEXT
• Table Page_Live: created
• Field Page_Live.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field Page_Live.MetaTitle: created as VARCHAR(255) COLLATE NOCASE
• Field Page_Live.HideCTA: created as BOOL NOT NULL DEFAULT 0
• Field Page_Live.CTATitleOverride: created as VARCHAR(255) COLLATE NOCASE
• Field Page_Live.CTATextOverride: created as TEXT
• Table Page_Versions: created
• Field Page_Versions.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field Page_Versions.RecordID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field Page_Versions.Version: created as INTEGER(11) NOT NULL DEFAULT 0
• Field Page_Versions.MetaTitle: created as VARCHAR(255) COLLATE NOCASE
• Field Page_Versions.HideCTA: created as BOOL NOT NULL DEFAULT 0
• Field Page_Versions.CTATitleOverride: created as VARCHAR(255) COLLATE NOCASE
• Field Page_Versions.CTATextOverride: created as TEXT
• Index Page_Versions.RecordID_Version: created as unique ("RecordID" ASC,"Version" ASC)
• Index Page_Versions.RecordID: created as index ("RecordID" ASC)
• Index Page_Versions.Version: created as index ("Version" ASC)
• SpotMarket_ConsentPage
• Table SpotMarket_ConsentPage: created
• Field SpotMarket_ConsentPage.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field SpotMarket_ConsentPage.FormTitle: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_ConsentPage.ImportantNote: created as TEXT
• Field SpotMarket_ConsentPage.SuccessMessage: created as VARCHAR(500) COLLATE NOCASE
• Field SpotMarket_ConsentPage.RecipientEmail: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_ConsentPage.ConfirmationEmailBody: created as TEXT
• Table SpotMarket_ConsentPage_Live: created
• Field SpotMarket_ConsentPage_Live.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field SpotMarket_ConsentPage_Live.FormTitle: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_ConsentPage_Live.ImportantNote: created as TEXT
• Field SpotMarket_ConsentPage_Live.SuccessMessage: created as VARCHAR(500) COLLATE NOCASE
• Field SpotMarket_ConsentPage_Live.RecipientEmail: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_ConsentPage_Live.ConfirmationEmailBody: created as TEXT
• Table SpotMarket_ConsentPage_Versions: created
• Field SpotMarket_ConsentPage_Versions.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field SpotMarket_ConsentPage_Versions.RecordID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SpotMarket_ConsentPage_Versions.Version: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SpotMarket_ConsentPage_Versions.FormTitle: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_ConsentPage_Versions.ImportantNote: created as TEXT
• Field SpotMarket_ConsentPage_Versions.SuccessMessage: created as VARCHAR(500) COLLATE NOCASE
• Field SpotMarket_ConsentPage_Versions.RecipientEmail: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_ConsentPage_Versions.ConfirmationEmailBody: created as TEXT
• Index SpotMarket_ConsentPage_Versions.RecordID_Version: created as unique ("RecordID" ASC,"Version" ASC)
• Index SpotMarket_ConsentPage_Versions.RecordID: created as index ("RecordID" ASC)
• Index SpotMarket_ConsentPage_Versions.Version: created as index ("Version" ASC)
• SpotMarket_ContactPage
• Table SpotMarket_ContactPage: created
• Field SpotMarket_ContactPage.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field SpotMarket_ContactPage.FormTitle: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_ContactPage.RecipientEmail: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_ContactPage.ThankYouTitle: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_ContactPage.ThankYouContent: created as TEXT
• Table SpotMarket_ContactPage_Live: created
• Field SpotMarket_ContactPage_Live.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field SpotMarket_ContactPage_Live.FormTitle: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_ContactPage_Live.RecipientEmail: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_ContactPage_Live.ThankYouTitle: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_ContactPage_Live.ThankYouContent: created as TEXT
• Table SpotMarket_ContactPage_Versions: created
• Field SpotMarket_ContactPage_Versions.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field SpotMarket_ContactPage_Versions.RecordID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SpotMarket_ContactPage_Versions.Version: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SpotMarket_ContactPage_Versions.FormTitle: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_ContactPage_Versions.RecipientEmail: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_ContactPage_Versions.ThankYouTitle: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_ContactPage_Versions.ThankYouContent: created as TEXT
• Index SpotMarket_ContactPage_Versions.RecordID_Version: created as unique ("RecordID" ASC,"Version" ASC)
• Index SpotMarket_ContactPage_Versions.RecordID: created as index ("RecordID" ASC)
• Index SpotMarket_ContactPage_Versions.Version: created as index ("Version" ASC)
• SpotMarket_HomePage
• Table SpotMarket_HomePage: created
• Field SpotMarket_HomePage.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field SpotMarket_HomePage.HeroEyebrow: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_HomePage.HeroTitle: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_HomePage.HeroLead: created as TEXT
• Field SpotMarket_HomePage.SolutionsEyebrow: created as VARCHAR(100) COLLATE NOCASE
• Field SpotMarket_HomePage.SolutionsTitle: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_HomePage.SolutionsLead: created as TEXT
• Field SpotMarket_HomePage.FeaturesEyebrow: created as VARCHAR(100) COLLATE NOCASE
• Field SpotMarket_HomePage.FeaturesTitle: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_HomePage.FeaturesLead: created as TEXT
• Field SpotMarket_HomePage.HeroCard1Title: created as VARCHAR(100) COLLATE NOCASE
• Field SpotMarket_HomePage.HeroCard1Text: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_HomePage.HeroCard2Title: created as VARCHAR(100) COLLATE NOCASE
• Field SpotMarket_HomePage.HeroCard2Text: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_HomePage.HeroImageID: created as INTEGER(11) NOT NULL DEFAULT 0
• Index SpotMarket_HomePage.HeroImageID: created as index ("HeroImageID" ASC)
• Table SpotMarket_HomePage_Live: created
• Field SpotMarket_HomePage_Live.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field SpotMarket_HomePage_Live.HeroEyebrow: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_HomePage_Live.HeroTitle: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_HomePage_Live.HeroLead: created as TEXT
• Field SpotMarket_HomePage_Live.SolutionsEyebrow: created as VARCHAR(100) COLLATE NOCASE
• Field SpotMarket_HomePage_Live.SolutionsTitle: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_HomePage_Live.SolutionsLead: created as TEXT
• Field SpotMarket_HomePage_Live.FeaturesEyebrow: created as VARCHAR(100) COLLATE NOCASE
• Field SpotMarket_HomePage_Live.FeaturesTitle: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_HomePage_Live.FeaturesLead: created as TEXT
• Field SpotMarket_HomePage_Live.HeroCard1Title: created as VARCHAR(100) COLLATE NOCASE
• Field SpotMarket_HomePage_Live.HeroCard1Text: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_HomePage_Live.HeroCard2Title: created as VARCHAR(100) COLLATE NOCASE
• Field SpotMarket_HomePage_Live.HeroCard2Text: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_HomePage_Live.HeroImageID: created as INTEGER(11) NOT NULL DEFAULT 0
• Index SpotMarket_HomePage_Live.HeroImageID: created as index ("HeroImageID" ASC)
• Table SpotMarket_HomePage_Versions: created
• Field SpotMarket_HomePage_Versions.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field SpotMarket_HomePage_Versions.RecordID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SpotMarket_HomePage_Versions.Version: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SpotMarket_HomePage_Versions.HeroEyebrow: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_HomePage_Versions.HeroTitle: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_HomePage_Versions.HeroLead: created as TEXT
• Field SpotMarket_HomePage_Versions.SolutionsEyebrow: created as VARCHAR(100) COLLATE NOCASE
• Field SpotMarket_HomePage_Versions.SolutionsTitle: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_HomePage_Versions.SolutionsLead: created as TEXT
• Field SpotMarket_HomePage_Versions.FeaturesEyebrow: created as VARCHAR(100) COLLATE NOCASE
• Field SpotMarket_HomePage_Versions.FeaturesTitle: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_HomePage_Versions.FeaturesLead: created as TEXT
• Field SpotMarket_HomePage_Versions.HeroCard1Title: created as VARCHAR(100) COLLATE NOCASE
• Field SpotMarket_HomePage_Versions.HeroCard1Text: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_HomePage_Versions.HeroCard2Title: created as VARCHAR(100) COLLATE NOCASE
• Field SpotMarket_HomePage_Versions.HeroCard2Text: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_HomePage_Versions.HeroImageID: created as INTEGER(11) NOT NULL DEFAULT 0
• Index SpotMarket_HomePage_Versions.RecordID_Version: created as unique ("RecordID" ASC,"Version" ASC)
• Index SpotMarket_HomePage_Versions.RecordID: created as index ("RecordID" ASC)
• Index SpotMarket_HomePage_Versions.Version: created as index ("Version" ASC)
• Index SpotMarket_HomePage_Versions.HeroImageID: created as index ("HeroImageID" ASC)
• SpotMarket_ProductPage
• Table SpotMarket_ProductPage: created
• Field SpotMarket_ProductPage.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field SpotMarket_ProductPage.Subtitle: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_ProductPage.Icon: created as VARCHAR(30) COLLATE NOCASE
• Field SpotMarket_ProductPage.ProductKey: created as VARCHAR(50) COLLATE NOCASE
• Field SpotMarket_ProductPage.CardTitle: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_ProductPage.CardSummary: created as TEXT
• Field SpotMarket_ProductPage.CardHighlights: created as TEXT
• Field SpotMarket_ProductPage.ModulesTitle: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_ProductPage.BenefitsTitle: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_ProductPage.StepsTitle: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_ProductPage.StepsLead: created as VARCHAR(255) COLLATE NOCASE
• Table SpotMarket_ProductPage_Live: created
• Field SpotMarket_ProductPage_Live.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field SpotMarket_ProductPage_Live.Subtitle: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_ProductPage_Live.Icon: created as VARCHAR(30) COLLATE NOCASE
• Field SpotMarket_ProductPage_Live.ProductKey: created as VARCHAR(50) COLLATE NOCASE
• Field SpotMarket_ProductPage_Live.CardTitle: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_ProductPage_Live.CardSummary: created as TEXT
• Field SpotMarket_ProductPage_Live.CardHighlights: created as TEXT
• Field SpotMarket_ProductPage_Live.ModulesTitle: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_ProductPage_Live.BenefitsTitle: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_ProductPage_Live.StepsTitle: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_ProductPage_Live.StepsLead: created as VARCHAR(255) COLLATE NOCASE
• Table SpotMarket_ProductPage_Versions: created
• Field SpotMarket_ProductPage_Versions.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field SpotMarket_ProductPage_Versions.RecordID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SpotMarket_ProductPage_Versions.Version: created as INTEGER(11) NOT NULL DEFAULT 0
• Field SpotMarket_ProductPage_Versions.Subtitle: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_ProductPage_Versions.Icon: created as VARCHAR(30) COLLATE NOCASE
• Field SpotMarket_ProductPage_Versions.ProductKey: created as VARCHAR(50) COLLATE NOCASE
• Field SpotMarket_ProductPage_Versions.CardTitle: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_ProductPage_Versions.CardSummary: created as TEXT
• Field SpotMarket_ProductPage_Versions.CardHighlights: created as TEXT
• Field SpotMarket_ProductPage_Versions.ModulesTitle: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_ProductPage_Versions.BenefitsTitle: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_ProductPage_Versions.StepsTitle: created as VARCHAR(255) COLLATE NOCASE
• Field SpotMarket_ProductPage_Versions.StepsLead: created as VARCHAR(255) COLLATE NOCASE
• Index SpotMarket_ProductPage_Versions.RecordID_Version: created as unique ("RecordID" ASC,"Version" ASC)
• Index SpotMarket_ProductPage_Versions.RecordID: created as index ("RecordID" ASC)
• Index SpotMarket_ProductPage_Versions.Version: created as index ("Version" ASC)
• ErrorPage
• Table ErrorPage: created
• Field ErrorPage.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field ErrorPage.ErrorCode: created as INTEGER(11) NOT NULL DEFAULT 0
• Table ErrorPage_Live: created
• Field ErrorPage_Live.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field ErrorPage_Live.ErrorCode: created as INTEGER(11) NOT NULL DEFAULT 0
• Table ErrorPage_Versions: created
• Field ErrorPage_Versions.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field ErrorPage_Versions.RecordID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field ErrorPage_Versions.Version: created as INTEGER(11) NOT NULL DEFAULT 0
• Field ErrorPage_Versions.ErrorCode: created as INTEGER(11) NOT NULL DEFAULT 0
• Index ErrorPage_Versions.RecordID_Version: created as unique ("RecordID" ASC,"Version" ASC)
• Index ErrorPage_Versions.RecordID: created as index ("RecordID" ASC)
• Index ErrorPage_Versions.Version: created as index ("Version" ASC)
• RedirectorPage
• Table RedirectorPage: created
• Field RedirectorPage.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field RedirectorPage.RedirectionType: created as TEXT DEFAULT 'Internal'
• Field RedirectorPage.ExternalURL: created as VARCHAR(2083) COLLATE NOCASE
• Field RedirectorPage.LinkToID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field RedirectorPage.LinkToFileID: created as INTEGER(11) NOT NULL DEFAULT 0
• Index RedirectorPage.LinkToID: created as index ("LinkToID" ASC)
• Index RedirectorPage.LinkToFileID: created as index ("LinkToFileID" ASC)
• Table RedirectorPage_Live: created
• Field RedirectorPage_Live.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field RedirectorPage_Live.RedirectionType: created as TEXT DEFAULT 'Internal'
• Field RedirectorPage_Live.ExternalURL: created as VARCHAR(2083) COLLATE NOCASE
• Field RedirectorPage_Live.LinkToID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field RedirectorPage_Live.LinkToFileID: created as INTEGER(11) NOT NULL DEFAULT 0
• Index RedirectorPage_Live.LinkToID: created as index ("LinkToID" ASC)
• Index RedirectorPage_Live.LinkToFileID: created as index ("LinkToFileID" ASC)
• Table RedirectorPage_Versions: created
• Field RedirectorPage_Versions.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field RedirectorPage_Versions.RecordID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field RedirectorPage_Versions.Version: created as INTEGER(11) NOT NULL DEFAULT 0
• Field RedirectorPage_Versions.RedirectionType: created as TEXT DEFAULT 'Internal'
• Field RedirectorPage_Versions.ExternalURL: created as VARCHAR(2083) COLLATE NOCASE
• Field RedirectorPage_Versions.LinkToID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field RedirectorPage_Versions.LinkToFileID: created as INTEGER(11) NOT NULL DEFAULT 0
• Index RedirectorPage_Versions.RecordID_Version: created as unique ("RecordID" ASC,"Version" ASC)
• Index RedirectorPage_Versions.RecordID: created as index ("RecordID" ASC)
• Index RedirectorPage_Versions.Version: created as index ("Version" ASC)
• Index RedirectorPage_Versions.LinkToID: created as index ("LinkToID" ASC)
• Index RedirectorPage_Versions.LinkToFileID: created as index ("LinkToFileID" ASC)
• VirtualPage
• Table VirtualPage: created
• Field VirtualPage.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field VirtualPage.VersionID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field VirtualPage.CustomMetaDescription: created as TEXT
• Field VirtualPage.CustomExtraMeta: created as TEXT
• Field VirtualPage.CopyContentFromID: created as INTEGER(11) NOT NULL DEFAULT 0
• Index VirtualPage.CopyContentFromID: created as index ("CopyContentFromID" ASC)
• Table VirtualPage_Live: created
• Field VirtualPage_Live.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field VirtualPage_Live.VersionID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field VirtualPage_Live.CustomMetaDescription: created as TEXT
• Field VirtualPage_Live.CustomExtraMeta: created as TEXT
• Field VirtualPage_Live.CopyContentFromID: created as INTEGER(11) NOT NULL DEFAULT 0
• Index VirtualPage_Live.CopyContentFromID: created as index ("CopyContentFromID" ASC)
• Table VirtualPage_Versions: created
• Field VirtualPage_Versions.ID: created as INTEGER PRIMARY KEY AUTOINCREMENT
• Field VirtualPage_Versions.RecordID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field VirtualPage_Versions.Version: created as INTEGER(11) NOT NULL DEFAULT 0
• Field VirtualPage_Versions.VersionID: created as INTEGER(11) NOT NULL DEFAULT 0
• Field VirtualPage_Versions.CustomMetaDescription: created as TEXT
• Field VirtualPage_Versions.CustomExtraMeta: created as TEXT
• Field VirtualPage_Versions.CopyContentFromID: created as INTEGER(11) NOT NULL DEFAULT 0
• Index VirtualPage_Versions.RecordID_Version: created as unique ("RecordID" ASC,"Version" ASC)
• Index VirtualPage_Versions.RecordID: created as index ("RecordID" ASC)
• Index VirtualPage_Versions.Version: created as index ("Version" ASC)
• Index VirtualPage_Versions.CopyContentFromID: created as index ("CopyContentFromID" ASC)

Creating database records

• SpotMarket\Models\ConsentRequest
• SpotMarket\Models\ContactSubmission
• SpotMarket\Models\HomeFeature
• SpotMarket\Models\ProductBenefit
• SpotMarket\Models\ProductModule
• SpotMarket\Models\ProductStep
• SpotMarket\Models\UILabel
• SilverStripe\Assets\File
• SilverStripe\SiteConfig\SiteConfig
• Added default site config
• 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
• SpotMarket\Pages\ConsentPage
• SpotMarket\Pages\ContactPage
• SpotMarket\Pages\HomePage
• SpotMarket\Pages\ProductPage
• SilverStripe\ErrorPage\ErrorPage
• SilverStripe\CMS\Model\RedirectorPage
• SilverStripe\CMS\Model\VirtualPage

Database build completed!