Building database ifte7726_Pm13iFKt using MySQL 5.5.5-10.11.17-MariaDB-cll-lve
Creating database tables
File
Field File.ClassName: changed to enum('File','Folder','Image','Image_Cached') character set utf8 collate utf8_general_ci default 'File' (from enum('File','Folder','Image','Image_Cached') character set utf8mb3 collate utf8mb3_general_ci default 'File')Field File.Name: changed to varchar(255) character set utf8 collate utf8_general_ci (from varchar(255) character set utf8mb3 collate utf8mb3_general_ci)Field File.Title: changed to varchar(255) character set utf8 collate utf8_general_ci (from varchar(255) character set utf8mb3 collate utf8mb3_general_ci)Field File.Filename: changed to mediumtext character set utf8 collate utf8_general_ci (from mediumtext character set utf8mb3 collate utf8mb3_general_ci)Field File.Content: changed to mediumtext character set utf8 collate utf8_general_ci (from mediumtext character set utf8mb3 collate utf8mb3_general_ci)Folder
Image
Image_Cached
Group
Field Group.ClassName: changed to enum('Group') character set utf8 collate utf8_general_ci default 'Group' (from enum('Group') character set utf8mb3 collate utf8mb3_general_ci default 'Group')Field Group.Title: changed to varchar(255) character set utf8 collate utf8_general_ci (from varchar(255) character set utf8mb3 collate utf8mb3_general_ci)Field Group.Description: changed to mediumtext character set utf8 collate utf8_general_ci (from mediumtext character set utf8mb3 collate utf8mb3_general_ci)Field Group.Code: changed to varchar(255) character set utf8 collate utf8_general_ci (from varchar(255) character set utf8mb3 collate utf8mb3_general_ci)Field Group.HtmlEditorConfig: changed to mediumtext character set utf8 collate utf8_general_ci (from mediumtext character set utf8mb3 collate utf8mb3_general_ci)LoginAttempt
Field LoginAttempt.ClassName: changed to enum('LoginAttempt') character set utf8 collate utf8_general_ci default 'LoginAttempt' (from enum('LoginAttempt') character set utf8mb3 collate utf8mb3_general_ci default 'LoginAttempt')Field LoginAttempt.Email: changed to varchar(255) character set utf8 collate utf8_general_ci (from varchar(255) character set utf8mb3 collate utf8mb3_general_ci)Field LoginAttempt.Status: changed to enum('Success','Failure') character set utf8 collate utf8_general_ci default 'Success' (from enum('Success','Failure') character set utf8mb3 collate utf8mb3_general_ci default 'Success')Field LoginAttempt.IP: changed to varchar(255) character set utf8 collate utf8_general_ci (from varchar(255) character set utf8mb3 collate utf8mb3_general_ci)Member
Field Member.ClassName: changed to enum('Member') character set utf8 collate utf8_general_ci default 'Member' (from enum('Member') character set utf8mb3 collate utf8mb3_general_ci default 'Member')Field Member.FirstName: changed to varchar(50) character set utf8 collate utf8_general_ci (from varchar(50) character set utf8mb3 collate utf8mb3_general_ci)Field Member.Surname: changed to varchar(50) character set utf8 collate utf8_general_ci (from varchar(50) character set utf8mb3 collate utf8mb3_general_ci)Field Member.Email: changed to varchar(254) character set utf8 collate utf8_general_ci (from varchar(254) character set utf8mb3 collate utf8mb3_general_ci)Field Member.TempIDHash: changed to varchar(160) character set utf8 collate utf8_general_ci (from varchar(160) character set utf8mb3 collate utf8mb3_general_ci)Field Member.Password: changed to varchar(160) character set utf8 collate utf8_general_ci (from varchar(160) character set utf8mb3 collate utf8mb3_general_ci)Field Member.RememberLoginToken: changed to varchar(160) character set utf8 collate utf8_general_ci (from varchar(160) character set utf8mb3 collate utf8mb3_general_ci)Field Member.AutoLoginHash: changed to varchar(160) character set utf8 collate utf8_general_ci (from varchar(160) character set utf8mb3 collate utf8mb3_general_ci)Field Member.PasswordEncryption: changed to varchar(50) character set utf8 collate utf8_general_ci (from varchar(50) character set utf8mb3 collate utf8mb3_general_ci)Field Member.Salt: changed to varchar(50) character set utf8 collate utf8_general_ci (from varchar(50) character set utf8mb3 collate utf8mb3_general_ci)Field Member.Locale: changed to varchar(6) character set utf8 collate utf8_general_ci (from varchar(6) character set utf8mb3 collate utf8mb3_general_ci)Field Member.DateFormat: changed to varchar(30) character set utf8 collate utf8_general_ci (from varchar(30) character set utf8mb3 collate utf8mb3_general_ci)Field Member.TimeFormat: changed to varchar(30) character set utf8 collate utf8_general_ci (from varchar(30) character set utf8mb3 collate utf8mb3_general_ci)MemberPassword
Field MemberPassword.ClassName: changed to enum('MemberPassword') character set utf8 collate utf8_general_ci default 'MemberPassword' (from enum('MemberPassword') character set utf8mb3 collate utf8mb3_general_ci default 'MemberPassword')Field MemberPassword.Password: changed to varchar(160) character set utf8 collate utf8_general_ci (from varchar(160) character set utf8mb3 collate utf8mb3_general_ci)Field MemberPassword.Salt: changed to varchar(50) character set utf8 collate utf8_general_ci (from varchar(50) character set utf8mb3 collate utf8mb3_general_ci)Field MemberPassword.PasswordEncryption: changed to varchar(50) character set utf8 collate utf8_general_ci (from varchar(50) character set utf8mb3 collate utf8mb3_general_ci)Permission
Field Permission.ClassName: changed to enum('Permission') character set utf8 collate utf8_general_ci default 'Permission' (from enum('Permission') character set utf8mb3 collate utf8mb3_general_ci default 'Permission')Field Permission.Code: changed to varchar(50) character set utf8 collate utf8_general_ci (from varchar(50) character set utf8mb3 collate utf8mb3_general_ci)PermissionRole
Field PermissionRole.ClassName: changed to enum('PermissionRole') character set utf8 collate utf8_general_ci default 'PermissionRole' (from enum('PermissionRole') character set utf8mb3 collate utf8mb3_general_ci default 'PermissionRole')Field PermissionRole.Title: changed to varchar(50) character set utf8 collate utf8_general_ci (from varchar(50) character set utf8mb3 collate utf8mb3_general_ci)PermissionRoleCode
Field PermissionRoleCode.ClassName: changed to enum('PermissionRoleCode') character set utf8 collate utf8_general_ci default 'PermissionRoleCode' (from enum('PermissionRoleCode') character set utf8mb3 collate utf8mb3_general_ci default 'PermissionRoleCode')Field PermissionRoleCode.Code: changed to varchar(50) character set utf8 collate utf8_general_ci (from varchar(50) character set utf8mb3 collate utf8mb3_general_ci)SiteConfig
Field SiteConfig.ClassName: changed to enum('SiteConfig') character set utf8 collate utf8_general_ci default 'SiteConfig' (from enum('SiteConfig') character set utf8mb3 collate utf8mb3_general_ci default 'SiteConfig')Field SiteConfig.Title: changed to varchar(255) character set utf8 collate utf8_general_ci (from varchar(255) character set utf8mb3 collate utf8mb3_general_ci)Field SiteConfig.Tagline: changed to varchar(255) character set utf8 collate utf8_general_ci (from varchar(255) character set utf8mb3 collate utf8mb3_general_ci)Field SiteConfig.Theme: changed to varchar(255) character set utf8 collate utf8_general_ci (from varchar(255) character set utf8mb3 collate utf8mb3_general_ci)Field SiteConfig.CanViewType: changed to enum('Anyone','LoggedInUsers','OnlyTheseUsers') character set utf8 collate utf8_general_ci default 'Anyone' (from enum('Anyone','LoggedInUsers','OnlyTheseUsers') character set utf8mb3 collate utf8mb3_general_ci default 'Anyone')Field SiteConfig.CanEditType: changed to enum('LoggedInUsers','OnlyTheseUsers') character set utf8 collate utf8_general_ci default 'LoggedInUsers' (from enum('LoggedInUsers','OnlyTheseUsers') character set utf8mb3 collate utf8mb3_general_ci default 'LoggedInUsers')Field SiteConfig.CanCreateTopLevelType: changed to enum('LoggedInUsers','OnlyTheseUsers') character set utf8 collate utf8_general_ci default 'LoggedInUsers' (from enum('LoggedInUsers','OnlyTheseUsers') character set utf8mb3 collate utf8mb3_general_ci default 'LoggedInUsers')Field SiteConfig.Domain: changed to varchar(255) character set utf8 collate utf8_general_ci (from varchar(255) character set utf8mb3 collate utf8mb3_general_ci)Field SiteConfig.Address: changed to mediumtext character set utf8 collate utf8_general_ci (from mediumtext character set utf8mb3 collate utf8mb3_general_ci)Field SiteConfig.GoogleAnalyticsScript: changed to mediumtext character set utf8 collate utf8_general_ci (from mediumtext character set utf8mb3 collate utf8mb3_general_ci)Field SiteConfig.FacebookURL: changed to varchar(255) character set utf8 collate utf8_general_ci (from varchar(255) character set utf8mb3 collate utf8mb3_general_ci)Field SiteConfig.TwitterURL: changed to varchar(255) character set utf8 collate utf8_general_ci (from varchar(255) character set utf8mb3 collate utf8mb3_general_ci)Field SiteConfig.GooglePlusURL: changed to varchar(255) character set utf8 collate utf8_general_ci (from varchar(255) character set utf8mb3 collate utf8mb3_general_ci)Field SiteConfig.InstagramURL: changed to varchar(255) character set utf8 collate utf8_general_ci (from varchar(255) character set utf8mb3 collate utf8mb3_general_ci)Field SiteConfig.IMScript: changed to mediumtext character set utf8 collate utf8_general_ci (from mediumtext character set utf8mb3 collate utf8mb3_general_ci)Field SiteConfig.LocationScript: changed to mediumtext character set utf8 collate utf8_general_ci (from mediumtext character set utf8mb3 collate utf8mb3_general_ci)Field SiteConfig.EmailFrom: changed to varchar(255) character set utf8 collate utf8_general_ci (from varchar(255) character set utf8mb3 collate utf8mb3_general_ci)Field SiteConfig.EmailTo: changed to varchar(255) character set utf8 collate utf8_general_ci (from varchar(255) character set utf8mb3 collate utf8mb3_general_ci)Field SiteConfig.EmailContact: changed to varchar(255) character set utf8 collate utf8_general_ci (from varchar(255) character set utf8mb3 collate utf8mb3_general_ci)Field SiteConfig.PhoneContact: changed to varchar(255) character set utf8 collate utf8_general_ci (from varchar(255) character set utf8mb3 collate utf8mb3_general_ci)Field SiteConfig.AddressContact: changed to varchar(255) character set utf8 collate utf8_general_ci (from varchar(255) character set utf8mb3 collate utf8mb3_general_ci)Field SiteConfig.FooterMessage: changed to mediumtext character set utf8 collate utf8_general_ci (from mediumtext character set utf8mb3 collate utf8mb3_general_ci)Field SiteConfig.FooterScript: changed to mediumtext character set utf8 collate utf8_general_ci (from mediumtext character set utf8mb3 collate utf8mb3_general_ci)Field SiteConfig.ReservationScript: changed to mediumtext character set utf8 collate utf8_general_ci (from mediumtext character set utf8mb3 collate utf8mb3_general_ci)Field SiteConfig.OrderFinishInfo: changed to mediumtext character set utf8 collate utf8_general_ci (from mediumtext character set utf8mb3 collate utf8mb3_general_ci)Field SiteConfig.ShippingInfo: changed to mediumtext character set utf8 collate utf8_general_ci (from mediumtext character set utf8mb3 collate utf8mb3_general_ci)Field SiteConfig.RegisterInfo: changed to mediumtext character set utf8 collate utf8_general_ci (from mediumtext character set utf8mb3 collate utf8mb3_general_ci)Field SiteConfig.MerchantAccessInfo: changed to mediumtext character set utf8 collate utf8_general_ci (from mediumtext character set utf8mb3 collate utf8mb3_general_ci)Field SiteConfig.PartnerLink: changed to varchar(255) character set utf8 collate utf8_general_ci (from varchar(255) character set utf8mb3 collate utf8mb3_general_ci)Field SiteConfig.InstagramScript: changed to mediumtext character set utf8 collate utf8_general_ci (from mediumtext character set utf8mb3 collate utf8mb3_general_ci)Field SiteConfig.FacebookScript: changed to mediumtext character set utf8 collate utf8_general_ci (from mediumtext character set utf8mb3 collate utf8mb3_general_ci)Field SiteConfig.SMTPHost: changed to varchar(255) character set utf8 collate utf8_general_ci (from varchar(255) character set utf8mb3 collate utf8mb3_general_ci)Field SiteConfig.SMTPUsername: changed to varchar(255) character set utf8 collate utf8_general_ci (from varchar(255) character set utf8mb3 collate utf8mb3_general_ci)Field SiteConfig.SMTPPassword: changed to varchar(255) character set utf8 collate utf8_general_ci (from varchar(255) character set utf8mb3 collate utf8mb3_general_ci)SiteTree
Field SiteTree.ClassName: changed to enum('SiteTree','Page','HomePage','InfoPage','ErrorPage','RedirectorPage','VirtualPage','StudyIndexPage') character set utf8 collate utf8_general_ci default 'SiteTree' (from enum('SiteTree','Page','HomePage','InfoPage','ErrorPage','RedirectorPage','VirtualPage','StudyIndexPage') character set utf8mb3 collate utf8mb3_general_ci default 'SiteTree')Field SiteTree.URLSegment: changed to varchar(255) character set utf8 collate utf8_general_ci (from varchar(255) character set utf8mb3 collate utf8mb3_general_ci)Field SiteTree.Title: changed to varchar(255) character set utf8 collate utf8_general_ci (from varchar(255) character set utf8mb3 collate utf8mb3_general_ci)Field SiteTree.MenuTitle: changed to varchar(100) character set utf8 collate utf8_general_ci (from varchar(100) character set utf8mb3 collate utf8mb3_general_ci)Field SiteTree.Content: changed to mediumtext character set utf8 collate utf8_general_ci (from mediumtext character set utf8mb3 collate utf8mb3_general_ci)Field SiteTree.MetaDescription: changed to mediumtext character set utf8 collate utf8_general_ci (from mediumtext character set utf8mb3 collate utf8mb3_general_ci)Field SiteTree.ExtraMeta: changed to mediumtext character set utf8 collate utf8_general_ci (from mediumtext character set utf8mb3 collate utf8mb3_general_ci)Field SiteTree.ReportClass: changed to varchar(50) character set utf8 collate utf8_general_ci (from varchar(50) character set utf8mb3 collate utf8mb3_general_ci)Field SiteTree.CanViewType: changed to enum('Anyone','LoggedInUsers','OnlyTheseUsers','Inherit') character set utf8 collate utf8_general_ci default 'Inherit' (from enum('Anyone','LoggedInUsers','OnlyTheseUsers','Inherit') character set utf8mb3 collate utf8mb3_general_ci default 'Inherit')Field SiteTree.CanEditType: changed to enum('LoggedInUsers','OnlyTheseUsers','Inherit') character set utf8 collate utf8_general_ci default 'Inherit' (from enum('LoggedInUsers','OnlyTheseUsers','Inherit') character set utf8mb3 collate utf8mb3_general_ci default 'Inherit')Field SiteTree_LinkTracking.FieldName: changed to varchar(50) character set utf8 collate utf8_general_ci (from varchar(50) character set utf8mb3 collate utf8mb3_general_ci)Field SiteTree_ImageTracking.FieldName: changed to varchar(50) character set utf8 collate utf8_general_ci (from varchar(50) character set utf8mb3 collate utf8mb3_general_ci)Field SiteTree_Live.ClassName: changed to enum('SiteTree','Page','HomePage','InfoPage','ErrorPage','RedirectorPage','VirtualPage','StudyIndexPage') character set utf8 collate utf8_general_ci default 'SiteTree' (from enum('SiteTree','Page','HomePage','InfoPage','ErrorPage','RedirectorPage','VirtualPage','StudyIndexPage') character set utf8mb3 collate utf8mb3_general_ci default 'SiteTree')Field SiteTree_Live.URLSegment: changed to varchar(255) character set utf8 collate utf8_general_ci (from varchar(255) character set utf8mb3 collate utf8mb3_general_ci)Field SiteTree_Live.Title: changed to varchar(255) character set utf8 collate utf8_general_ci (from varchar(255) character set utf8mb3 collate utf8mb3_general_ci)Field SiteTree_Live.MenuTitle: changed to varchar(100) character set utf8 collate utf8_general_ci (from varchar(100) character set utf8mb3 collate utf8mb3_general_ci)Field SiteTree_Live.Content: changed to mediumtext character set utf8 collate utf8_general_ci (from mediumtext character set utf8mb3 collate utf8mb3_general_ci)Field SiteTree_Live.MetaDescription: changed to mediumtext character set utf8 collate utf8_general_ci (from mediumtext character set utf8mb3 collate utf8mb3_general_ci)Field SiteTree_Live.ExtraMeta: changed to mediumtext character set utf8 collate utf8_general_ci (from mediumtext character set utf8mb3 collate utf8mb3_general_ci)Field SiteTree_Live.ReportClass: changed to varchar(50) character set utf8 collate utf8_general_ci (from varchar(50) character set utf8mb3 collate utf8mb3_general_ci)Field SiteTree_Live.CanViewType: changed to enum('Anyone','LoggedInUsers','OnlyTheseUsers','Inherit') character set utf8 collate utf8_general_ci default 'Inherit' (from enum('Anyone','LoggedInUsers','OnlyTheseUsers','Inherit') character set utf8mb3 collate utf8mb3_general_ci default 'Inherit')Field SiteTree_Live.CanEditType: changed to enum('LoggedInUsers','OnlyTheseUsers','Inherit') character set utf8 collate utf8_general_ci default 'Inherit' (from enum('LoggedInUsers','OnlyTheseUsers','Inherit') character set utf8mb3 collate utf8mb3_general_ci default 'Inherit')Field SiteTree_versions.ClassName: changed to enum('SiteTree','Page','HomePage','InfoPage','ErrorPage','RedirectorPage','VirtualPage','StudyIndexPage') character set utf8 collate utf8_general_ci default 'SiteTree' (from enum('SiteTree','Page','HomePage','InfoPage','ErrorPage','RedirectorPage','VirtualPage','StudyIndexPage') character set utf8mb3 collate utf8mb3_general_ci default 'SiteTree')Field SiteTree_versions.URLSegment: changed to varchar(255) character set utf8 collate utf8_general_ci (from varchar(255) character set utf8mb3 collate utf8mb3_general_ci)Field SiteTree_versions.Title: changed to varchar(255) character set utf8 collate utf8_general_ci (from varchar(255) character set utf8mb3 collate utf8mb3_general_ci)Field SiteTree_versions.MenuTitle: changed to varchar(100) character set utf8 collate utf8_general_ci (from varchar(100) character set utf8mb3 collate utf8mb3_general_ci)Field SiteTree_versions.Content: changed to mediumtext character set utf8 collate utf8_general_ci (from mediumtext character set utf8mb3 collate utf8mb3_general_ci)Field SiteTree_versions.MetaDescription: changed to mediumtext character set utf8 collate utf8_general_ci (from mediumtext character set utf8mb3 collate utf8mb3_general_ci)Field SiteTree_versions.ExtraMeta: changed to mediumtext character set utf8 collate utf8_general_ci (from mediumtext character set utf8mb3 collate utf8mb3_general_ci)Field SiteTree_versions.ReportClass: changed to varchar(50) character set utf8 collate utf8_general_ci (from varchar(50) character set utf8mb3 collate utf8mb3_general_ci)Field SiteTree_versions.CanViewType: changed to enum('Anyone','LoggedInUsers','OnlyTheseUsers','Inherit') character set utf8 collate utf8_general_ci default 'Inherit' (from enum('Anyone','LoggedInUsers','OnlyTheseUsers','Inherit') character set utf8mb3 collate utf8mb3_general_ci default 'Inherit')Field SiteTree_versions.CanEditType: changed to enum('LoggedInUsers','OnlyTheseUsers','Inherit') character set utf8 collate utf8_general_ci default 'Inherit' (from enum('LoggedInUsers','OnlyTheseUsers','Inherit') character set utf8mb3 collate utf8mb3_general_ci default 'Inherit')Page
HomePage
Field HomePage.AdmissionTitle: changed to varchar(255) character set utf8 collate utf8_general_ci (from varchar(255) character set utf8mb3 collate utf8mb3_general_ci)Field HomePage.AdmissionSubTitle: changed to varchar(255) character set utf8 collate utf8_general_ci (from varchar(255) character set utf8mb3 collate utf8mb3_general_ci)Field HomePage.AdmissionLinkSubmission: changed to mediumtext character set utf8 collate utf8_general_ci (from mediumtext character set utf8mb3 collate utf8mb3_general_ci)Field HomePage_Live.AdmissionTitle: changed to varchar(255) character set utf8 collate utf8_general_ci (from varchar(255) character set utf8mb3 collate utf8mb3_general_ci)Field HomePage_Live.AdmissionSubTitle: changed to varchar(255) character set utf8 collate utf8_general_ci (from varchar(255) character set utf8mb3 collate utf8mb3_general_ci)Field HomePage_Live.AdmissionLinkSubmission: changed to mediumtext character set utf8 collate utf8_general_ci (from mediumtext character set utf8mb3 collate utf8mb3_general_ci)Field HomePage_versions.AdmissionTitle: changed to varchar(255) character set utf8 collate utf8_general_ci (from varchar(255) character set utf8mb3 collate utf8mb3_general_ci)Field HomePage_versions.AdmissionSubTitle: changed to varchar(255) character set utf8 collate utf8_general_ci (from varchar(255) character set utf8mb3 collate utf8mb3_general_ci)Field HomePage_versions.AdmissionLinkSubmission: changed to mediumtext character set utf8 collate utf8_general_ci (from mediumtext character set utf8mb3 collate utf8mb3_general_ci)InfoPage
ErrorPage
RedirectorPage
Field RedirectorPage.RedirectionType: changed to enum('Internal','External') character set utf8 collate utf8_general_ci default 'Internal' (from enum('Internal','External') character set utf8mb3 collate utf8mb3_general_ci default 'Internal')Field RedirectorPage.ExternalURL: changed to varchar(2083) character set utf8 collate utf8_general_ci (from varchar(2083) character set utf8mb3 collate utf8mb3_general_ci)Field RedirectorPage_Live.RedirectionType: changed to enum('Internal','External') character set utf8 collate utf8_general_ci default 'Internal' (from enum('Internal','External') character set utf8mb3 collate utf8mb3_general_ci default 'Internal')Field RedirectorPage_Live.ExternalURL: changed to varchar(2083) character set utf8 collate utf8_general_ci (from varchar(2083) character set utf8mb3 collate utf8mb3_general_ci)Field RedirectorPage_versions.RedirectionType: changed to enum('Internal','External') character set utf8 collate utf8_general_ci default 'Internal' (from enum('Internal','External') character set utf8mb3 collate utf8mb3_general_ci default 'Internal')Field RedirectorPage_versions.ExternalURL: changed to varchar(2083) character set utf8 collate utf8_general_ci (from varchar(2083) character set utf8mb3 collate utf8mb3_general_ci)VirtualPage
StudyIndexPage
SlideData
Field SlideData.ClassName: changed to enum('SlideData') character set utf8 collate utf8_general_ci default 'SlideData' (from enum('SlideData') character set utf8mb3 collate utf8mb3_general_ci default 'SlideData')Field SlideData.Content: changed to mediumtext character set utf8 collate utf8_general_ci (from mediumtext character set utf8mb3 collate utf8mb3_general_ci)Field SlideData.Link: changed to varchar(255) character set utf8 collate utf8_general_ci (from varchar(255) character set utf8mb3 collate utf8mb3_general_ci)Field SlideData.Title: changed to varchar(255) character set utf8 collate utf8_general_ci (from varchar(255) character set utf8mb3 collate utf8mb3_general_ci)SocialData
Field SocialData.ClassName: changed to enum('SocialData') character set utf8 collate utf8_general_ci default 'SocialData' (from enum('SocialData') character set utf8mb3 collate utf8mb3_general_ci default 'SocialData')Field SocialData.Title: changed to varchar(255) character set utf8 collate utf8_general_ci (from varchar(255) character set utf8mb3 collate utf8mb3_general_ci)Field SocialData.Link: changed to varchar(255) character set utf8 collate utf8_general_ci (from varchar(255) character set utf8mb3 collate utf8mb3_general_ci)Field SocialData.URLSegment: changed to varchar(255) character set utf8 collate utf8_general_ci (from varchar(255) character set utf8mb3 collate utf8mb3_general_ci)Field SocialData.IconScript: changed to mediumtext character set utf8 collate utf8_general_ci (from mediumtext character set utf8mb3 collate utf8mb3_general_ci)ThingData
Field ThingData.ClassName: changed to enum('ThingData','PartnershipData','StudyData','TestimoniData') character set utf8 collate utf8_general_ci default 'ThingData' (from enum('ThingData','PartnershipData','StudyData','TestimoniData') character set utf8mb3 collate utf8mb3_general_ci default 'ThingData')Field ThingData.Title: changed to varchar(255) character set utf8 collate utf8_general_ci (from varchar(255) character set utf8mb3 collate utf8mb3_general_ci)Field ThingData.URLSegment: changed to varchar(255) character set utf8 collate utf8_general_ci (from varchar(255) character set utf8mb3 collate utf8mb3_general_ci)Index ThingData.SearchFields: changed to fulltext (Title) (from fulltext ("Title"))PartnershipData
Field PartnershipData.URL: changed to varchar(255) character set utf8 collate utf8_general_ci (from varchar(255) character set utf8mb3 collate utf8mb3_general_ci)StudyData
Field StudyData.Content: changed to mediumtext character set utf8 collate utf8_general_ci (from mediumtext character set utf8mb3 collate utf8mb3_general_ci)Field StudyData.Level: changed to varchar(5) character set utf8 collate utf8_general_ci (from varchar(5) character set utf8mb3 collate utf8mb3_general_ci)TestimoniData
Field TestimoniData.Message: changed to mediumtext character set utf8 collate utf8_general_ci (from mediumtext character set utf8mb3 collate utf8mb3_general_ci)Field TestimoniData.Level: changed to varchar(100) character set utf8 collate utf8_general_ci (from varchar(100) character set utf8mb3 collate utf8mb3_general_ci)
Creating database records
File
Folder
Image
Image_Cached
Group
LoginAttempt
Member
MemberPassword
Permission
PermissionRole
PermissionRoleCode
SiteConfig
SiteTree
Page
HomePage
InfoPage
ErrorPage
RedirectorPage
VirtualPage
StudyIndexPage
SlideData
SocialData
ThingData
PartnershipData
StudyData
TestimoniData
Database build completed!