(OLD 5.7 Discussion FORUM)

Database Error moving from dev server to live server

Permalink January 11, 2015 at 2:51 AM

After weeks of developing I'm now trying to move my concrete5 website from my local xampp server to a paid host. I found and followed this tutorial:http://www.concrete5.org/documentation/developers/5.7/installation/...

I've followed every step in detail. After finishing the guide I went ahead and test the homepage, however it is giving me two unexpected errors:

An exception occurred while executing 'select pkgID, pkgName, pkgIsInstalled, pkgDescription, pkgVersion, pkgHandle, pkgDateInstalled from Packages where pkgIsInstalled = ? order by pkgID asc' with params [1]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'pgqr288820_concrete5.Packages' doesn't exist

Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'pgqr288820_concrete5.Logs' doesn't exist' in /home/pgqr288820/domains/mywebsite.nl/public_html/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php:165 Stack trace: #0 /home/pgqr288820/domains/mywebsite.nl/public_html/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php(165): PDOStatement->execute(Array) #1 /home/pgqr288820/domains/mywebsite.nl/public_html/concrete/src/Logging/Handler/DatabaseHandler.php(31): Doctrine\DBAL\Statement->execute(Array) #2 /home/pgqr288820/domains/mywebsite.nl/public_html/concrete/vendor/monolog/monolog/src/Monolog/Handler/AbstractProcessingHandler.php(37): Concrete\Core\Logging\Handler\DatabaseHandler->write(Array) #3 /home/pgqr288820/domains/mywebsite.nl/public_html/concrete/vendor/monolog/monolog/src/Monolog/Logger.php(263): Monolog\Handler\AbstractProcessingHandler->handle(Array) #4 /home/pgqr288820/domains/mywebsite.nl/public_html/concrete/vendor/monolog/mono

I've checked on my live server's phpmyadmin, both tabels packages and logs are present. What can I do? I appreciate any comments, thanks in advance.

My concrete5 version is 5.7.2

WebcentricLtd replied on Jan 11, 2015 at 10:18 am Permalink Reply

is there a possibility you've been caught out by case sensitivity differences between the mysql on your local instance and your webserver?

If your webserver is Linux based then your table names should be camel cased - on windows they are generally all lower case.

If this is the case you'll need to make sure your tables are correctly named.

I don't think there is currently an add-on in 5.7 to help with this.

hawkagent replied on Jan 11, 2015 at 11:24 am Permalink Reply

Thanks for your reply, that seems to be it. I changed the table name from 'packages' to 'Packages', it now gives another table error, and so on.

It's a shame that concrete5 has such low flexibility, if I had known this I wouldn't develop my website on Windows.

I could manually rename all table names but some table names should start with a capital, e.g. Packages, some don't, e.g. btNavigation, so it's gonna take alot of work to rename all 250 tables. Is there a faster way to do this?

WebcentricLtd replied on Jan 11, 2015 at 12:58 pm Permalink Reply

Hi,
I don't think so. With 5.6 there was an addon that helped with this but I just checked and it hadn't been ported yet.

I don't know if you could:

set myql in your xampp installation to respect case and restart xampp
do a blank install of a new C5 instance so you now have a vanilla db with the table names correctly cased

reset MySQL in your xampp installation to ignore case, restart xampp and then restore your site database into your vanilla one so you have your site db info inside the new correctly named tables ?????

You wouldn't do any of the above on your webserver. I've never tried it and don't know if it would work - but if it does it would be much quicker and less error prone than renaming all of the tables on your webserver so might be worth a try.

MrKDilkington replied on Jan 11, 2015 at 7:52 pm Permalink Reply

For future projects, you can configure XAMPP to use the proper table name case.
In the my.ini file add the line:
lower_case_table_names = 0

This might be an option.
http://www.concrete5.org/community/forums/installation/table-names-...

I will take a look at updating this for you.

MrKDilkington replied on Jan 11, 2015 at 9:43 pm Permalink Reply 1 Attachment

First thing, the warning:
- back up your database to a safe place before using these scripts
- use at your own risk

To make a 5.7.3.1 SQL script:
1. made a fresh concrete 5.7.3.1 install
2. copied all the table names from phpMyAdmin
3. used a text editor to recreate jordanlev's rename_mysql_tables_5411.sql script
syntax example - RENAME TABLE areagroupblocktypes TO AreaGroupBlockTypes;

* the script didn't work, each attempt triggered the "#1050 - Table 'table_name_x' already exists" error

4. tried again using different syntax
syntax example - ALTER TABLE areapermissionassignments RENAME AreaPermissionAssignments;

* the script didn't work, same #1050 error

5. as a workaround, I made a script that added the number 8 to the end of each lower case table
syntax example - RENAME TABLE arealayoutcolumns TO arealayoutcolumns8;
6. from here I was able to rename the table to the CamelCase version
syntax - RENAME TABLE arealayoutcolumns8 TO AreaLayoutColumns;

There will be 2 steps:
1. use the first script that adds 8 to the end of the lower case table name
2. use the second script to convert the lower case table name + 8 to CamelCase

After running the scripts, you will have to go through and look for custom tables from packages or homemade blocks. These will have to be changed by hand.

My knowledge of MySQL is thin, so I am sure there are better ways to do this. This method works though, I triple checked it.

hawkagent replied on Jan 12, 2015 at 1:25 pm Permalink Best Answer Reply

Thanks for your reply and effort, it inspired me to extract the correct table names from a fresh install. I've used a macro program to write a fix. It seems this problem has been going around for many versions of concrete5 now, it's kinda disappointing it hasn't been mentioned in the starter's guide. IMO all table names should be lower case in future releases to avoid this total unnecessary problem.

The SQL query to fix the no-more-ignore-case problem for concrete 5.7.2:

rename table `arealayoutcolumns` to `AreaLayoutColumns`;
rename table `arealayoutcustomcolumns` to `AreaLayoutCustomColumns`;
rename table `arealayoutpresets` to `AreaLayoutPresets`;
rename table `arealayouts` to `AreaLayouts`;
rename table `arealayoutthemegridcolumns` to `AreaLayoutThemeGridColumns`;
rename table `areapermissionassignments` to `AreaPermissionAssignments`;
rename table `areapermissionblocktypeaccesslist` to `AreaPermissionBlockTypeAccessList`;
rename table `areapermissionblocktypeaccesslistcustom` to `AreaPermissionBlockTypeAccessListCustom`;
rename table `areas` to `Areas`;
rename table `ataddress` to `atAddress`;
rename table `ataddresscustomcountries` to `atAddressCustomCountries`;
rename table `ataddresssettings` to `atAddressSettings`;
rename table `atboolean` to `atBoolean`;
rename table `atbooleansettings` to `atBooleanSettings`;
rename table `atdatetime` to `atDateTime`;

Viewing 15 lines of 245 lines. View entire code block.

rename table `arealayoutcolumns` to `AreaLayoutColumns`;
rename table `arealayoutcustomcolumns` to `AreaLayoutCustomColumns`;
rename table `arealayoutpresets` to `AreaLayoutPresets`;
rename table `arealayouts` to `AreaLayouts`;
rename table `arealayoutthemegridcolumns` to `AreaLayoutThemeGridColumns`;
rename table `areapermissionassignments` to `AreaPermissionAssignments`;
rename table `areapermissionblocktypeaccesslist` to `AreaPermissionBlockTypeAccessList`;
rename table `areapermissionblocktypeaccesslistcustom` to `AreaPermissionBlockTypeAccessListCustom`;
rename table `areas` to `Areas`;
rename table `ataddress` to `atAddress`;
rename table `ataddresscustomcountries` to `atAddressCustomCountries`;
rename table `ataddresssettings` to `atAddressSettings`;
rename table `atboolean` to `atBoolean`;
rename table `atbooleansettings` to `atBooleanSettings`;
rename table `atdatetime` to `atDateTime`;
rename table `atdatetimesettings` to `atDateTimeSettings`;
rename table `atdefault` to `atDefault`;
rename table `atfile` to `atFile`;
rename table `atnumber` to `atNumber`;
rename table `atselectedtopics` to `atSelectedTopics`;
rename table `atselectoptions` to `atSelectOptions`;
rename table `atselectoptionsselected` to `atSelectOptionsSelected`;
rename table `atselectsettings` to `atSelectSettings`;
rename table `atsociallinks` to `atSocialLinks`;
rename table `attextareasettings` to `atTextareaSettings`;
rename table `attopicsettings` to `atTopicSettings`;
rename table `attributekeycategories` to `AttributeKeyCategories`;
rename table `attributekeys` to `AttributeKeys`;
rename table `attributesetkeys` to `AttributeSetKeys`;
rename table `attributesets` to `AttributeSets`;
rename table `attributetypecategories` to `AttributeTypeCategories`;
rename table `attributetypes` to `AttributeTypes`;
rename table `attributevalues` to `AttributeValues`;
rename table `authenticationtypes` to `AuthenticationTypes`;
rename table `authtypeconcretecookiemap` to `authTypeConcreteCookieMap`;
rename table `bannedwords` to `BannedWords`;
rename table `basicworkflowpermissionassignments` to `BasicWorkflowPermissionAssignments`;
rename table `basicworkflowprogressdata` to `BasicWorkflowProgressData`;
rename table `blockfeatureassignments` to `BlockFeatureAssignments`;
rename table `blockpermissionassignments` to `BlockPermissionAssignments`;
rename table `blockrelations` to `BlockRelations`;
rename table `blocks` to `Blocks`;
rename table `blocktypepermissionblocktypeaccesslist` to `BlockTypePermissionBlockTypeAccessList`;
rename table `blocktypepermissionblocktypeaccesslistcustom` to `BlockTypePermissionBlockTypeAccessListCustom`;
rename table `blocktypes` to `BlockTypes`;
rename table `blocktypesetblocktypes` to `BlockTypeSetBlockTypes`;
rename table `blocktypesets` to `BlockTypeSets`;
rename table `btcontentfile` to `btContentFile`;
rename table `btcontentimage` to `btContentImage`;
rename table `btcontentlocal` to `btContentLocal`;
rename table `btcorearealayout` to `btCoreAreaLayout`;
rename table `btcoreconversation` to `btCoreConversation`;
rename table `btcorepagetypecomposercontroloutput` to `btCorePageTypeComposerControlOutput`;
rename table `btcorescrapbookdisplay` to `btCoreScrapbookDisplay`;
rename table `btcorestackdisplay` to `btCoreStackDisplay`;
rename table `btdashboardnewsflowlatest` to `btDashboardNewsflowLatest`;
rename table `btdatenavigation` to `btDateNavigation`;
rename table `btexternalform` to `btExternalForm`;
rename table `btfaq` to `btFaq`;
rename table `btfaqentries` to `btFaqEntries`;
rename table `btfeature` to `btFeature`;
rename table `btform` to `btForm`;
rename table `btformanswers` to `btFormAnswers`;
rename table `btformanswerset` to `btFormAnswerSet`;
rename table `btformquestions` to `btFormQuestions`;
rename table `btgooglemap` to `btGoogleMap`;
rename table `btimageslider` to `btImageSlider`;
rename table `btimagesliderentries` to `btImageSliderEntries`;
rename table `btnavigation` to `btNavigation`;
rename table `btnextprevious` to `btNextPrevious`;
rename table `btpageattributedisplay` to `btPageAttributeDisplay`;
rename table `btpagelist` to `btPageList`;
rename table `btpagetitle` to `btPageTitle`;
rename table `btrssdisplay` to `btRssDisplay`;
rename table `btsearch` to `btSearch`;
rename table `btsharethispage` to `btShareThisPage`;
rename table `btsociallinks` to `btSocialLinks`;
rename table `btsurvey` to `btSurvey`;
rename table `btsurveyoptions` to `btSurveyOptions`;
rename table `btsurveyresults` to `btSurveyResults`;
rename table `bttags` to `btTags`;
rename table `bttestimonial` to `btTestimonial`;
rename table `bttopiclist` to `btTopicList`;
rename table `btvideo` to `btVideo`;
rename table `btyoutube` to `btYouTube`;
rename table `collectionattributevalues` to `CollectionAttributeValues`;
rename table `collections` to `Collections`;
rename table `collectionsearchindexattributes` to `CollectionSearchIndexAttributes`;
rename table `collectionversionareastyles` to `CollectionVersionAreaStyles`;
rename table `collectionversionblocks` to `CollectionVersionBlocks`;
rename table `collectionversionblockscachesettings` to `CollectionVersionBlocksCacheSettings`;
rename table `collectionversionblocksoutputcache` to `CollectionVersionBlocksOutputCache`;
rename table `collectionversionblockstyles` to `CollectionVersionBlockStyles`;
rename table `collectionversionfeatureassignments` to `CollectionVersionFeatureAssignments`;
rename table `collectionversionrelatededits` to `CollectionVersionRelatedEdits`;
rename table `collectionversions` to `CollectionVersions`;
rename table `collectionversionthemecustomstyles` to `CollectionVersionThemeCustomStyles`;
rename table `config` to `Config`;
rename table `configstore` to `ConfigStore`;
rename table `conversationdiscussions` to `ConversationDiscussions`;
rename table `conversationeditors` to `ConversationEditors`;
rename table `conversationfeaturedetailassignments` to `ConversationFeatureDetailAssignments`;
rename table `conversationflaggedmessages` to `ConversationFlaggedMessages`;
rename table `conversationflaggedmessagetypes` to `ConversationFlaggedMessageTypes`;
rename table `conversationmessageattachments` to `ConversationMessageAttachments`;
rename table `conversationmessageratings` to `ConversationMessageRatings`;
rename table `conversationmessages` to `ConversationMessages`;
rename table `conversationpermissionassignments` to `ConversationPermissionAssignments`;
rename table `conversationratingtypes` to `ConversationRatingTypes`;
rename table `conversations` to `Conversations`;
rename table `downloadstatistics` to `DownloadStatistics`;
rename table `featureassignments` to `FeatureAssignments`;
rename table `featurecategories` to `FeatureCategories`;
rename table `features` to `Features`;
rename table `fileattributevalues` to `FileAttributeValues`;
rename table `fileimagethumbnailtypes` to `FileImageThumbnailTypes`;
rename table `filepermissionassignments` to `FilePermissionAssignments`;
rename table `filepermissionfiletypes` to `FilePermissionFileTypes`;
rename table `files` to `Files`;
rename table `filesearchindexattributes` to `FileSearchIndexAttributes`;
rename table `filesetfiles` to `FileSetFiles`;
rename table `filesetpermissionassignments` to `FileSetPermissionAssignments`;
rename table `filesetpermissionfiletypeaccesslist` to `FileSetPermissionFileTypeAccessList`;
rename table `filesetpermissionfiletypeaccesslistcustom` to `FileSetPermissionFileTypeAccessListCustom`;
rename table `filesets` to `FileSets`;
rename table `filesetsavedsearches` to `FileSetSavedSearches`;
rename table `filestoragelocations` to `FileStorageLocations`;
rename table `filestoragelocationtypes` to `FileStorageLocationTypes`;
rename table `fileversionlog` to `FileVersionLog`;
rename table `fileversions` to `FileVersions`;
rename table `gapage` to `gaPage`;
rename table `gatheringconfigureddatasources` to `GatheringConfiguredDataSources`;
rename table `gatheringdatasources` to `GatheringDataSources`;
rename table `gatheringitemfeatureassignments` to `GatheringItemFeatureAssignments`;
rename table `gatheringitems` to `GatheringItems`;
rename table `gatheringitemselectedtemplates` to `GatheringItemSelectedTemplates`;
rename table `gatheringitemtemplatefeatures` to `GatheringItemTemplateFeatures`;
rename table `gatheringitemtemplates` to `GatheringItemTemplates`;
rename table `gatheringitemtemplatetypes` to `GatheringItemTemplateTypes`;
rename table `gatheringpermissionassignments` to `GatheringPermissionAssignments`;
rename table `gatherings` to `Gatherings`;
rename table `groups` to `Groups`;
rename table `groupsetgroups` to `GroupSetGroups`;
rename table `groupsets` to `GroupSets`;
rename table `jobs` to `Jobs`;
rename table `jobsetjobs` to `JobSetJobs`;
rename table `jobsets` to `JobSets`;
rename table `jobslog` to `JobsLog`;
rename table `logs` to `Logs`;
rename table `mailimporters` to `MailImporters`;
rename table `mailvalidationhashes` to `MailValidationHashes`;
rename table `oauthusermap` to `OauthUserMap`;
rename table `packages` to `Packages`;
rename table `pagefeeds` to `PageFeeds`;
rename table `pagepaths` to `PagePaths`;
rename table `pagepermissionassignments` to `PagePermissionAssignments`;
rename table `pagepermissionpagetypeaccesslist` to `PagePermissionPageTypeAccessList`;
rename table `pagepermissionpagetypeaccesslistcustom` to `PagePermissionPageTypeAccessListCustom`;
rename table `pagepermissionpropertyaccesslist` to `PagePermissionPropertyAccessList`;
rename table `pagepermissionpropertyattributeaccesslistcustom` to `PagePermissionPropertyAttributeAccessListCustom`;
rename table `pagepermissionthemeaccesslist` to `PagePermissionThemeAccessList`;
rename table `pagepermissionthemeaccesslistcustom` to `PagePermissionThemeAccessListCustom`;
rename table `pages` to `Pages`;
rename table `pagesearchindex` to `PageSearchIndex`;
rename table `pagestatistics` to `PageStatistics`;
rename table `pagetemplates` to `PageTemplates`;
rename table `pagethemecustomstyles` to `PageThemeCustomStyles`;
rename table `pagethemes` to `PageThemes`;
rename table `pagetypecomposercontroltypes` to `PageTypeComposerControlTypes`;
rename table `pagetypecomposerformlayoutsetcontrols` to `PageTypeComposerFormLayoutSetControls`;
rename table `pagetypecomposerformlayoutsets` to `PageTypeComposerFormLayoutSets`;
rename table `pagetypecomposeroutputblocks` to `PageTypeComposerOutputBlocks`;
rename table `pagetypecomposeroutputcontrols` to `PageTypeComposerOutputControls`;
rename table `pagetypepagetemplatedefaultpages` to `PageTypePageTemplateDefaultPages`;
rename table `pagetypepagetemplates` to `PageTypePageTemplates`;
rename table `pagetypepermissionassignments` to `PageTypePermissionAssignments`;
rename table `pagetypepublishtargettypes` to `PageTypePublishTargetTypes`;
rename table `pagetypes` to `PageTypes`;
rename table `pageworkflowprogress` to `PageWorkflowProgress`;
rename table `permissionaccess` to `PermissionAccess`;
rename table `permissionaccessentities` to `PermissionAccessEntities`;
rename table `permissionaccessentitygroups` to `PermissionAccessEntityGroups`;
rename table `permissionaccessentitygroupsets` to `PermissionAccessEntityGroupSets`;
rename table `permissionaccessentitytypecategories` to `PermissionAccessEntityTypeCategories`;
rename table `permissionaccessentitytypes` to `PermissionAccessEntityTypes`;
rename table `permissionaccessentityusers` to `PermissionAccessEntityUsers`;
rename table `permissionaccesslist` to `PermissionAccessList`;
rename table `permissionaccessworkflows` to `PermissionAccessWorkflows`;
rename table `permissionassignments` to `PermissionAssignments`;
rename table `permissiondurationobjects` to `PermissionDurationObjects`;
rename table `permissionkeycategories` to `PermissionKeyCategories`;
rename table `permissionkeys` to `PermissionKeys`;
rename table `pilecontents` to `PileContents`;
rename table `piles` to `Piles`;
rename table `queuemessages` to `QueueMessages`;
rename table `queuepageduplicationrelations` to `QueuePageDuplicationRelations`;
rename table `queues` to `Queues`;
rename table `sessions` to `Sessions`;
rename table `signuprequests` to `SignupRequests`;
rename table `sociallinks` to `SocialLinks`;
rename table `stacks` to `Stacks`;
rename table `stylecustomizercustomcssrecords` to `StyleCustomizerCustomCssRecords`;
rename table `stylecustomizerinlinestylepresets` to `StyleCustomizerInlineStylePresets`;
rename table `stylecustomizerinlinestylesets` to `StyleCustomizerInlineStyleSets`;
rename table `stylecustomizervaluelists` to `StyleCustomizerValueLists`;
rename table `stylecustomizervalues` to `StyleCustomizerValues`;
rename table `systemantispamlibraries` to `SystemAntispamLibraries`;
rename table `systemcaptchalibraries` to `SystemCaptchaLibraries`;
rename table `systemcontenteditorsnippets` to `SystemContentEditorSnippets`;
rename table `systemdatabasemigrations` to `SystemDatabaseMigrations`;
rename table `systemdatabasequerylog` to `SystemDatabaseQueryLog`;
rename table `systemimageeditorcomponents` to `SystemImageEditorComponents`;
rename table `systemimageeditorcontrolsets` to `SystemImageEditorControlSets`;
rename table `systemimageeditorfilters` to `SystemImageEditorFilters`;
rename table `systemimageeditorshapes` to `SystemImageEditorShapes`;
rename table `topictrees` to `TopicTrees`;
rename table `treecategorynodes` to `TreeCategoryNodes`;
rename table `treegroupnodes` to `TreeGroupNodes`;
rename table `treenodepermissionassignments` to `TreeNodePermissionAssignments`;
rename table `treenodes` to `TreeNodes`;
rename table `treenodetypes` to `TreeNodeTypes`;
rename table `trees` to `Trees`;
rename table `treetopicnodes` to `TreeTopicNodes`;
rename table `treetypes` to `TreeTypes`;
rename table `userattributekeys` to `UserAttributeKeys`;
rename table `userattributevalues` to `UserAttributeValues`;
rename table `userbannedips` to `UserBannedIPs`;
rename table `usergroups` to `UserGroups`;
rename table `userpermissioneditpropertyaccesslist` to `UserPermissionEditPropertyAccessList`;
rename table `userpermissioneditpropertyattributeaccesslistcustom` to `UserPermissionEditPropertyAttributeAccessListCustom`;
rename table `userpermissionviewattributeaccesslist` to `UserPermissionViewAttributeAccessList`;
rename table `userpermissionviewattributeaccesslistcustom` to `UserPermissionViewAttributeAccessListCustom`;
rename table `userpointactions` to `UserPointActions`;
rename table `userpointhistory` to `UserPointHistory`;
rename table `userprivatemessages` to `UserPrivateMessages`;
rename table `userprivatemessagesto` to `UserPrivateMessagesTo`;
rename table `users` to `Users`;
rename table `usersearchindexattributes` to `UserSearchIndexAttributes`;
rename table `uservalidationhashes` to `UserValidationHashes`;
rename table `workflowprogress` to `WorkflowProgress`;
rename table `workflowprogresscategories` to `WorkflowProgressCategories`;
rename table `workflowprogresshistory` to `WorkflowProgressHistory`;
rename table `workflowrequestobjects` to `WorkflowRequestObjects`;
rename table `workflows` to `Workflows`;
rename table `workflowtypes` to `WorkflowTypes`;

jchatkinson replied on Jan 20, 2015 at 1:12 am Permalink Reply

The query worked great for my site... Thanks for sharing it!

deanbonnici replied on Feb 13, 2015 at 2:23 am Permalink Reply

Awesome. Thank you for sharing. Saved us too!

jmcgarvey replied on Apr 20, 2015 at 9:33 am Permalink Reply

Thank you! Much appreciated.

Chuy2042 replied on May 31, 2015 at 11:43 pm Permalink Reply

YOU ARE GREAT!!

hawkagent replied on Jul 16, 2015 at 12:46 am Permalink Reply

Updated for 5.7.4.2

rename table `arealayoutcolumns` to `AreaLayoutColumns`;
rename table `arealayoutcustomcolumns` to `AreaLayoutCustomColumns`;
rename table `arealayoutpresets` to `AreaLayoutPresets`;
rename table `arealayouts` to `AreaLayouts`;
rename table `arealayoutthemegridcolumns` to `AreaLayoutThemeGridColumns`;
rename table `areapermissionassignments` to `AreaPermissionAssignments`;
rename table `areapermissionblocktypeaccesslist` to `AreaPermissionBlockTypeAccessList`;
rename table `areapermissionblocktypeaccesslistcustom` to `AreaPermissionBlockTypeAccessListCustom`;
rename table `areas` to `Areas`;
rename table `ataddress` to `atAddress`;
rename table `ataddresscustomcountries` to `atAddressCustomCountries`;
rename table `ataddresssettings` to `atAddressSettings`;
rename table `atboolean` to `atBoolean`;
rename table `atbooleansettings` to `atBooleanSettings`;
rename table `atdatetime` to `atDateTime`;

Viewing 15 lines of 250 lines. View entire code block.

 
rename table `arealayoutcolumns` to `AreaLayoutColumns`;
rename table `arealayoutcustomcolumns` to `AreaLayoutCustomColumns`;
rename table `arealayoutpresets` to `AreaLayoutPresets`;
rename table `arealayouts` to `AreaLayouts`;
rename table `arealayoutthemegridcolumns` to `AreaLayoutThemeGridColumns`;
rename table `areapermissionassignments` to `AreaPermissionAssignments`;
rename table `areapermissionblocktypeaccesslist` to `AreaPermissionBlockTypeAccessList`;
rename table `areapermissionblocktypeaccesslistcustom` to `AreaPermissionBlockTypeAccessListCustom`;
rename table `areas` to `Areas`;
rename table `ataddress` to `atAddress`;
rename table `ataddresscustomcountries` to `atAddressCustomCountries`;
rename table `ataddresssettings` to `atAddressSettings`;
rename table `atboolean` to `atBoolean`;
rename table `atbooleansettings` to `atBooleanSettings`;
rename table `atdatetime` to `atDateTime`;
rename table `atdatetimesettings` to `atDateTimeSettings`;
rename table `atdefault` to `atDefault`;
rename table `atfile` to `atFile`;
rename table `atnumber` to `atNumber`;
rename table `atselectedtopics` to `atSelectedTopics`;
rename table `atselectoptions` to `atSelectOptions`;
rename table `atselectoptionsselected` to `atSelectOptionsSelected`;
rename table `atselectsettings` to `atSelectSettings`;
rename table `atsociallinks` to `atSocialLinks`;
rename table `attextareasettings` to `atTextareaSettings`;
rename table `attopicsettings` to `atTopicSettings`;
rename table `attributekeycategories` to `AttributeKeyCategories`;
rename table `attributekeys` to `AttributeKeys`;
rename table `attributesetkeys` to `AttributeSetKeys`;
rename table `attributesets` to `AttributeSets`;
rename table `attributetypecategories` to `AttributeTypeCategories`;
rename table `attributetypes` to `AttributeTypes`;
rename table `attributevalues` to `AttributeValues`;
rename table `authenticationtypes` to `AuthenticationTypes`;
rename table `authtypeconcretecookiemap` to `authTypeConcreteCookieMap`;
rename table `bannedwords` to `BannedWords`;
rename table `basicworkflowpermissionassignments` to `BasicWorkflowPermissionAssignments`;
rename table `basicworkflowprogressdata` to `BasicWorkflowProgressData`;
rename table `blockfeatureassignments` to `BlockFeatureAssignments`;
rename table `blockpermissionassignments` to `BlockPermissionAssignments`;
rename table `blockrelations` to `BlockRelations`;
rename table `blocks` to `Blocks`;
rename table `blocktypepermissionblocktypeaccesslist` to `BlockTypePermissionBlockTypeAccessList`;
rename table `blocktypepermissionblocktypeaccesslistcustom` to `BlockTypePermissionBlockTypeAccessListCustom`;
rename table `blocktypes` to `BlockTypes`;
rename table `blocktypesetblocktypes` to `BlockTypeSetBlockTypes`;
rename table `blocktypesets` to `BlockTypeSets`;
rename table `btcontentfile` to `btContentFile`;
rename table `btcontentimage` to `btContentImage`;
rename table `btcontentlocal` to `btContentLocal`;
rename table `btcorearealayout` to `btCoreAreaLayout`;
rename table `btcoreconversation` to `btCoreConversation`;
rename table `btcorepagetypecomposercontroloutput` to `btCorePageTypeComposerControlOutput`;
rename table `btcorescrapbookdisplay` to `btCoreScrapbookDisplay`;
rename table `btcorestackdisplay` to `btCoreStackDisplay`;
rename table `btdashboardnewsflowlatest` to `btDashboardNewsflowLatest`;
rename table `btdatenavigation` to `btDateNavigation`;
rename table `btexternalform` to `btExternalForm`;
rename table `btfaq` to `btFaq`;
rename table `btfaqentries` to `btFaqEntries`;
rename table `btfeature` to `btFeature`;
rename table `btform` to `btForm`;
rename table `btformanswers` to `btFormAnswers`;
rename table `btformanswerset` to `btFormAnswerSet`;
rename table `btformquestions` to `btFormQuestions`;
rename table `btgooglemap` to `btGoogleMap`;
rename table `btimageslider` to `btImageSlider`;
rename table `btimagesliderentries` to `btImageSliderEntries`;
rename table `btnavigation` to `btNavigation`;
rename table `btnextprevious` to `btNextPrevious`;
rename table `btpageattributedisplay` to `btPageAttributeDisplay`;
rename table `btpagelist` to `btPageList`;
rename table `btpagetitle` to `btPageTitle`;
rename table `btrssdisplay` to `btRssDisplay`;
rename table `btsearch` to `btSearch`;
rename table `btsharethispage` to `btShareThisPage`;
rename table `btsociallinks` to `btSocialLinks`;
rename table `btsurvey` to `btSurvey`;
rename table `btsurveyoptions` to `btSurveyOptions`;
rename table `btsurveyresults` to `btSurveyResults`;
rename table `btswitchlanguage` to `btSwitchLanguage`;
rename table `bttags` to `btTags`;
rename table `bttestimonial` to `btTestimonial`;
rename table `bttopiclist` to `btTopicList`;
rename table `btvideo` to `btVideo`;
rename table `btyoutube` to `btYouTube`;
rename table `collectionattributevalues` to `CollectionAttributeValues`;
rename table `collections` to `Collections`;
rename table `collectionsearchindexattributes` to `CollectionSearchIndexAttributes`;
rename table `collectionversionareastyles` to `CollectionVersionAreaStyles`;
rename table `collectionversionblocks` to `CollectionVersionBlocks`;
rename table `collectionversionblockscachesettings` to `CollectionVersionBlocksCacheSettings`;
rename table `collectionversionblocksoutputcache` to `CollectionVersionBlocksOutputCache`;
rename table `collectionversionblockstyles` to `CollectionVersionBlockStyles`;
rename table `collectionversionfeatureassignments` to `CollectionVersionFeatureAssignments`;
rename table `collectionversionrelatededits` to `CollectionVersionRelatedEdits`;
rename table `collectionversions` to `CollectionVersions`;
rename table `collectionversionthemecustomstyles` to `CollectionVersionThemeCustomStyles`;
rename table `config` to `Config`;
rename table `configstore` to `ConfigStore`;
rename table `conversationdiscussions` to `ConversationDiscussions`;
rename table `conversationeditors` to `ConversationEditors`;
rename table `conversationfeaturedetailassignments` to `ConversationFeatureDetailAssignments`;
rename table `conversationflaggedmessages` to `ConversationFlaggedMessages`;
rename table `conversationflaggedmessagetypes` to `ConversationFlaggedMessageTypes`;
rename table `conversationmessageattachments` to `ConversationMessageAttachments`;
rename table `conversationmessageratings` to `ConversationMessageRatings`;
rename table `conversationmessages` to `ConversationMessages`;
rename table `conversationpermissionaddmessageaccesslist` to `ConversationPermissionAddMessageAccessList`;
rename table `conversationpermissionassignments` to `ConversationPermissionAssignments`;
rename table `conversationratingtypes` to `ConversationRatingTypes`;
rename table `conversations` to `Conversations`;
rename table `conversationsubscriptions` to `ConversationSubscriptions`;
rename table `downloadstatistics` to `DownloadStatistics`;
rename table `featureassignments` to `FeatureAssignments`;
rename table `featurecategories` to `FeatureCategories`;
rename table `features` to `Features`;
rename table `fileattributevalues` to `FileAttributeValues`;
rename table `fileimagethumbnailtypes` to `FileImageThumbnailTypes`;
rename table `filepermissionassignments` to `FilePermissionAssignments`;
rename table `filepermissionfiletypes` to `FilePermissionFileTypes`;
rename table `files` to `Files`;
rename table `filesearchindexattributes` to `FileSearchIndexAttributes`;
rename table `filesetfiles` to `FileSetFiles`;
rename table `filesetpermissionassignments` to `FileSetPermissionAssignments`;
rename table `filesetpermissionfiletypeaccesslist` to `FileSetPermissionFileTypeAccessList`;
rename table `filesetpermissionfiletypeaccesslistcustom` to `FileSetPermissionFileTypeAccessListCustom`;
rename table `filesets` to `FileSets`;
rename table `filesetsavedsearches` to `FileSetSavedSearches`;
rename table `filestoragelocations` to `FileStorageLocations`;
rename table `filestoragelocationtypes` to `FileStorageLocationTypes`;
rename table `fileversionlog` to `FileVersionLog`;
rename table `fileversions` to `FileVersions`;
rename table `gapage` to `gaPage`;
rename table `gatheringconfigureddatasources` to `GatheringConfiguredDataSources`;
rename table `gatheringdatasources` to `GatheringDataSources`;
rename table `gatheringitemfeatureassignments` to `GatheringItemFeatureAssignments`;
rename table `gatheringitems` to `GatheringItems`;
rename table `gatheringitemselectedtemplates` to `GatheringItemSelectedTemplates`;
rename table `gatheringitemtemplatefeatures` to `GatheringItemTemplateFeatures`;
rename table `gatheringitemtemplates` to `GatheringItemTemplates`;
rename table `gatheringitemtemplatetypes` to `GatheringItemTemplateTypes`;
rename table `gatheringpermissionassignments` to `GatheringPermissionAssignments`;
rename table `gatherings` to `Gatherings`;
rename table `groups` to `Groups`;
rename table `groupsetgroups` to `GroupSetGroups`;
rename table `groupsets` to `GroupSets`;
rename table `jobs` to `Jobs`;
rename table `jobsetjobs` to `JobSetJobs`;
rename table `jobsets` to `JobSets`;
rename table `jobslog` to `JobsLog`;
rename table `logs` to `Logs`;
rename table `mailimporters` to `MailImporters`;
rename table `mailvalidationhashes` to `MailValidationHashes`;
rename table `multilingualpagerelations` to `MultilingualPageRelations`;
rename table `multilingualsections` to `MultilingualSections`;
rename table `multilingualtranslations` to `MultilingualTranslations`;
rename table `oauthusermap` to `OauthUserMap`;
rename table `packages` to `Packages`;
rename table `pagefeeds` to `PageFeeds`;
rename table `pagepaths` to `PagePaths`;
rename table `pagepermissionassignments` to `PagePermissionAssignments`;
rename table `pagepermissionpagetypeaccesslist` to `PagePermissionPageTypeAccessList`;
rename table `pagepermissionpagetypeaccesslistcustom` to `PagePermissionPageTypeAccessListCustom`;
rename table `pagepermissionpropertyaccesslist` to `PagePermissionPropertyAccessList`;
rename table `pagepermissionpropertyattributeaccesslistcustom` to `PagePermissionPropertyAttributeAccessListCustom`;
rename table `pagepermissionthemeaccesslist` to `PagePermissionThemeAccessList`;
rename table `pagepermissionthemeaccesslistcustom` to `PagePermissionThemeAccessListCustom`;
rename table `pages` to `Pages`;
rename table `pagesearchindex` to `PageSearchIndex`;
rename table `pagetemplates` to `PageTemplates`;
rename table `pagethemecustomstyles` to `PageThemeCustomStyles`;
rename table `pagethemes` to `PageThemes`;
rename table `pagetypecomposercontroltypes` to `PageTypeComposerControlTypes`;
rename table `pagetypecomposerformlayoutsetcontrols` to `PageTypeComposerFormLayoutSetControls`;
rename table `pagetypecomposerformlayoutsets` to `PageTypeComposerFormLayoutSets`;
rename table `pagetypecomposeroutputblocks` to `PageTypeComposerOutputBlocks`;
rename table `pagetypecomposeroutputcontrols` to `PageTypeComposerOutputControls`;
rename table `pagetypepagetemplatedefaultpages` to `PageTypePageTemplateDefaultPages`;
rename table `pagetypepagetemplates` to `PageTypePageTemplates`;
rename table `pagetypepermissionassignments` to `PageTypePermissionAssignments`;
rename table `pagetypepublishtargettypes` to `PageTypePublishTargetTypes`;
rename table `pagetypes` to `PageTypes`;
rename table `pageworkflowprogress` to `PageWorkflowProgress`;
rename table `permissionaccess` to `PermissionAccess`;
rename table `permissionaccessentities` to `PermissionAccessEntities`;
rename table `permissionaccessentitygroups` to `PermissionAccessEntityGroups`;
rename table `permissionaccessentitygroupsets` to `PermissionAccessEntityGroupSets`;
rename table `permissionaccessentitytypecategories` to `PermissionAccessEntityTypeCategories`;
rename table `permissionaccessentitytypes` to `PermissionAccessEntityTypes`;
rename table `permissionaccessentityusers` to `PermissionAccessEntityUsers`;
rename table `permissionaccesslist` to `PermissionAccessList`;
rename table `permissionaccessworkflows` to `PermissionAccessWorkflows`;
rename table `permissionassignments` to `PermissionAssignments`;
rename table `permissiondurationobjects` to `PermissionDurationObjects`;
rename table `permissionkeycategories` to `PermissionKeyCategories`;
rename table `permissionkeys` to `PermissionKeys`;
rename table `pilecontents` to `PileContents`;
rename table `piles` to `Piles`;
rename table `queuemessages` to `QueueMessages`;
rename table `queuepageduplicationrelations` to `QueuePageDuplicationRelations`;
rename table `queues` to `Queues`;
rename table `sessions` to `Sessions`;
rename table `signuprequests` to `SignupRequests`;
rename table `sociallinks` to `SocialLinks`;
rename table `stacks` to `Stacks`;
rename table `stylecustomizercustomcssrecords` to `StyleCustomizerCustomCssRecords`;
rename table `stylecustomizerinlinestylepresets` to `StyleCustomizerInlineStylePresets`;
rename table `stylecustomizerinlinestylesets` to `StyleCustomizerInlineStyleSets`;
rename table `stylecustomizervaluelists` to `StyleCustomizerValueLists`;
rename table `stylecustomizervalues` to `StyleCustomizerValues`;
rename table `systemantispamlibraries` to `SystemAntispamLibraries`;
rename table `systemcaptchalibraries` to `SystemCaptchaLibraries`;
rename table `systemcontenteditorsnippets` to `SystemContentEditorSnippets`;
rename table `systemdatabasemigrations` to `SystemDatabaseMigrations`;
rename table `systemdatabasequerylog` to `SystemDatabaseQueryLog`;
rename table `systemimageeditorcomponents` to `SystemImageEditorComponents`;
rename table `systemimageeditorcontrolsets` to `SystemImageEditorControlSets`;
rename table `systemimageeditorfilters` to `SystemImageEditorFilters`;
rename table `systemimageeditorshapes` to `SystemImageEditorShapes`;
rename table `topictrees` to `TopicTrees`;
rename table `treecategorynodes` to `TreeCategoryNodes`;
rename table `treegroupnodes` to `TreeGroupNodes`;
rename table `treenodepermissionassignments` to `TreeNodePermissionAssignments`;
rename table `treenodes` to `TreeNodes`;
rename table `treenodetypes` to `TreeNodeTypes`;
rename table `trees` to `Trees`;
rename table `treetopicnodes` to `TreeTopicNodes`;
rename table `treetypes` to `TreeTypes`;
rename table `userattributekeys` to `UserAttributeKeys`;
rename table `userattributevalues` to `UserAttributeValues`;
rename table `userbannedips` to `UserBannedIPs`;
rename table `usergroups` to `UserGroups`;
rename table `userpermissioneditpropertyaccesslist` to `UserPermissionEditPropertyAccessList`;
rename table `userpermissioneditpropertyattributeaccesslistcustom` to `UserPermissionEditPropertyAttributeAccessListCustom`;
rename table `userpermissionviewattributeaccesslist` to `UserPermissionViewAttributeAccessList`;
rename table `userpermissionviewattributeaccesslistcustom` to `UserPermissionViewAttributeAccessListCustom`;
rename table `userpointactions` to `UserPointActions`;
rename table `userpointhistory` to `UserPointHistory`;
rename table `userprivatemessages` to `UserPrivateMessages`;
rename table `userprivatemessagesto` to `UserPrivateMessagesTo`;
rename table `users` to `Users`;
rename table `usersearchindexattributes` to `UserSearchIndexAttributes`;
rename table `uservalidationhashes` to `UserValidationHashes`;
rename table `workflowprogress` to `WorkflowProgress`;
rename table `workflowprogresscategories` to `WorkflowProgressCategories`;
rename table `workflowprogresshistory` to `WorkflowProgressHistory`;
rename table `workflowrequestobjects` to `WorkflowRequestObjects`;
rename table `workflows` to `Workflows`;
rename table `workflowtypes` to `WorkflowTypes`;

SmoothPixel replied on Jul 28, 2015 at 10:54 am Permalink Reply

Thanks @hawkagent for sharing an updated version - really saved my bacon today!

ranvijaykumarb replied on Jul 16, 2015 at 12:16 pm Permalink Reply

Find updated for Concrete5.7.4.2

5 new tables were added for rename.(`multilingualpagerelations`, `multilingualsections` and `multilingualtranslations`, `conversationpermissionaddmessageaccesslist` and `conversationsubscriptions`)

rename table `arealayoutcolumns` to `AreaLayoutColumns`;
rename table `arealayoutcustomcolumns` to `AreaLayoutCustomColumns`;
rename table `arealayoutpresets` to `AreaLayoutPresets`;
rename table `arealayouts` to `AreaLayouts`;
rename table `arealayoutthemegridcolumns` to `AreaLayoutThemeGridColumns`;
rename table `areapermissionassignments` to `AreaPermissionAssignments`;
rename table `areapermissionblocktypeaccesslist` to `AreaPermissionBlockTypeAccessList`;
rename table `areapermissionblocktypeaccesslistcustom` to `AreaPermissionBlockTypeAccessListCustom`;
rename table `areas` to `Areas`;
rename table `ataddress` to `atAddress`;
rename table `ataddresscustomcountries` to `atAddressCustomCountries`;
rename table `ataddresssettings` to `atAddressSettings`;
rename table `atboolean` to `atBoolean`;
rename table `atbooleansettings` to `atBooleanSettings`;
rename table `atdatetime` to `atDateTime`;

Viewing 15 lines of 250 lines. View entire code block.

 
rename table `arealayoutcolumns` to `AreaLayoutColumns`;
rename table `arealayoutcustomcolumns` to `AreaLayoutCustomColumns`;
rename table `arealayoutpresets` to `AreaLayoutPresets`;
rename table `arealayouts` to `AreaLayouts`;
rename table `arealayoutthemegridcolumns` to `AreaLayoutThemeGridColumns`;
rename table `areapermissionassignments` to `AreaPermissionAssignments`;
rename table `areapermissionblocktypeaccesslist` to `AreaPermissionBlockTypeAccessList`;
rename table `areapermissionblocktypeaccesslistcustom` to `AreaPermissionBlockTypeAccessListCustom`;
rename table `areas` to `Areas`;
rename table `ataddress` to `atAddress`;
rename table `ataddresscustomcountries` to `atAddressCustomCountries`;
rename table `ataddresssettings` to `atAddressSettings`;
rename table `atboolean` to `atBoolean`;
rename table `atbooleansettings` to `atBooleanSettings`;
rename table `atdatetime` to `atDateTime`;
rename table `atdatetimesettings` to `atDateTimeSettings`;
rename table `atdefault` to `atDefault`;
rename table `atfile` to `atFile`;
rename table `atnumber` to `atNumber`;
rename table `atselectedtopics` to `atSelectedTopics`;
rename table `atselectoptions` to `atSelectOptions`;
rename table `atselectoptionsselected` to `atSelectOptionsSelected`;
rename table `atselectsettings` to `atSelectSettings`;
rename table `atsociallinks` to `atSocialLinks`;
rename table `attextareasettings` to `atTextareaSettings`;
rename table `attopicsettings` to `atTopicSettings`;
rename table `attributekeycategories` to `AttributeKeyCategories`;
rename table `attributekeys` to `AttributeKeys`;
rename table `attributesetkeys` to `AttributeSetKeys`;
rename table `attributesets` to `AttributeSets`;
rename table `attributetypecategories` to `AttributeTypeCategories`;
rename table `attributetypes` to `AttributeTypes`;
rename table `attributevalues` to `AttributeValues`;
rename table `authenticationtypes` to `AuthenticationTypes`;
rename table `authtypeconcretecookiemap` to `authTypeConcreteCookieMap`;
rename table `bannedwords` to `BannedWords`;
rename table `basicworkflowpermissionassignments` to `BasicWorkflowPermissionAssignments`;
rename table `basicworkflowprogressdata` to `BasicWorkflowProgressData`;
rename table `blockfeatureassignments` to `BlockFeatureAssignments`;
rename table `blockpermissionassignments` to `BlockPermissionAssignments`;
rename table `blockrelations` to `BlockRelations`;
rename table `blocks` to `Blocks`;
rename table `blocktypepermissionblocktypeaccesslist` to `BlockTypePermissionBlockTypeAccessList`;
rename table `blocktypepermissionblocktypeaccesslistcustom` to `BlockTypePermissionBlockTypeAccessListCustom`;
rename table `blocktypes` to `BlockTypes`;
rename table `blocktypesetblocktypes` to `BlockTypeSetBlockTypes`;
rename table `blocktypesets` to `BlockTypeSets`;
rename table `btcontentfile` to `btContentFile`;
rename table `btcontentimage` to `btContentImage`;
rename table `btcontentlocal` to `btContentLocal`;
rename table `btcorearealayout` to `btCoreAreaLayout`;
rename table `btcoreconversation` to `btCoreConversation`;
rename table `btcorepagetypecomposercontroloutput` to `btCorePageTypeComposerControlOutput`;
rename table `btcorescrapbookdisplay` to `btCoreScrapbookDisplay`;
rename table `btcorestackdisplay` to `btCoreStackDisplay`;
rename table `btdashboardnewsflowlatest` to `btDashboardNewsflowLatest`;
rename table `btdatenavigation` to `btDateNavigation`;
rename table `btexternalform` to `btExternalForm`;
rename table `btfaq` to `btFaq`;
rename table `btfaqentries` to `btFaqEntries`;
rename table `btfeature` to `btFeature`;
rename table `btform` to `btForm`;
rename table `btformanswers` to `btFormAnswers`;
rename table `btformanswerset` to `btFormAnswerSet`;
rename table `btformquestions` to `btFormQuestions`;
rename table `btgooglemap` to `btGoogleMap`;
rename table `btimageslider` to `btImageSlider`;
rename table `btimagesliderentries` to `btImageSliderEntries`;
rename table `btnavigation` to `btNavigation`;
rename table `btnextprevious` to `btNextPrevious`;
rename table `btpageattributedisplay` to `btPageAttributeDisplay`;
rename table `btpagelist` to `btPageList`;
rename table `btpagetitle` to `btPageTitle`;
rename table `btrssdisplay` to `btRssDisplay`;
rename table `btsearch` to `btSearch`;
rename table `btsharethispage` to `btShareThisPage`;
rename table `btsociallinks` to `btSocialLinks`;
rename table `btsurvey` to `btSurvey`;
rename table `btsurveyoptions` to `btSurveyOptions`;
rename table `btsurveyresults` to `btSurveyResults`;
rename table `bttags` to `btTags`;
rename table `bttestimonial` to `btTestimonial`;
rename table `bttopiclist` to `btTopicList`;
rename table `btvideo` to `btVideo`;
rename table `btyoutube` to `btYouTube`;
rename table `collectionattributevalues` to `CollectionAttributeValues`;
rename table `collections` to `Collections`;
rename table `collectionsearchindexattributes` to `CollectionSearchIndexAttributes`;
rename table `collectionversionareastyles` to `CollectionVersionAreaStyles`;
rename table `collectionversionblocks` to `CollectionVersionBlocks`;
rename table `collectionversionblockscachesettings` to `CollectionVersionBlocksCacheSettings`;
rename table `collectionversionblocksoutputcache` to `CollectionVersionBlocksOutputCache`;
rename table `collectionversionblockstyles` to `CollectionVersionBlockStyles`;
rename table `collectionversionfeatureassignments` to `CollectionVersionFeatureAssignments`;
rename table `collectionversionrelatededits` to `CollectionVersionRelatedEdits`;
rename table `collectionversions` to `CollectionVersions`;
rename table `collectionversionthemecustomstyles` to `CollectionVersionThemeCustomStyles`;
rename table `config` to `Config`;
rename table `configstore` to `ConfigStore`;
rename table `conversationdiscussions` to `ConversationDiscussions`;
rename table `conversationeditors` to `ConversationEditors`;
rename table `conversationfeaturedetailassignments` to `ConversationFeatureDetailAssignments`;
rename table `conversationflaggedmessages` to `ConversationFlaggedMessages`;
rename table `conversationflaggedmessagetypes` to `ConversationFlaggedMessageTypes`;
rename table `conversationmessageattachments` to `ConversationMessageAttachments`;
rename table `conversationmessageratings` to `ConversationMessageRatings`;
rename table `conversationmessages` to `ConversationMessages`;
rename table `conversationpermissionaddmessageaccesslist` to `ConversationPermissionAddMessageAccessList`;
rename table `conversationpermissionassignments` to `ConversationPermissionAssignments`;
rename table `conversationratingtypes` to `ConversationRatingTypes`;
rename table `conversations` to `Conversations`;
rename table `conversationsubscriptions` to `ConversationSubscriptions`;
rename table `downloadstatistics` to `DownloadStatistics`;
rename table `featureassignments` to `FeatureAssignments`;
rename table `featurecategories` to `FeatureCategories`;
rename table `features` to `Features`;
rename table `fileattributevalues` to `FileAttributeValues`;
rename table `fileimagethumbnailtypes` to `FileImageThumbnailTypes`;
rename table `filepermissionassignments` to `FilePermissionAssignments`;
rename table `filepermissionfiletypes` to `FilePermissionFileTypes`;
rename table `files` to `Files`;
rename table `filesearchindexattributes` to `FileSearchIndexAttributes`;
rename table `filesetfiles` to `FileSetFiles`;
rename table `filesetpermissionassignments` to `FileSetPermissionAssignments`;
rename table `filesetpermissionfiletypeaccesslist` to `FileSetPermissionFileTypeAccessList`;
rename table `filesetpermissionfiletypeaccesslistcustom` to `FileSetPermissionFileTypeAccessListCustom`;
rename table `filesets` to `FileSets`;
rename table `filesetsavedsearches` to `FileSetSavedSearches`;
rename table `filestoragelocations` to `FileStorageLocations`;
rename table `filestoragelocationtypes` to `FileStorageLocationTypes`;
rename table `fileversionlog` to `FileVersionLog`;
rename table `fileversions` to `FileVersions`;
rename table `gapage` to `gaPage`;
rename table `gatheringconfigureddatasources` to `GatheringConfiguredDataSources`;
rename table `gatheringdatasources` to `GatheringDataSources`;
rename table `gatheringitemfeatureassignments` to `GatheringItemFeatureAssignments`;
rename table `gatheringitems` to `GatheringItems`;
rename table `gatheringitemselectedtemplates` to `GatheringItemSelectedTemplates`;
rename table `gatheringitemtemplatefeatures` to `GatheringItemTemplateFeatures`;
rename table `gatheringitemtemplates` to `GatheringItemTemplates`;
rename table `gatheringitemtemplatetypes` to `GatheringItemTemplateTypes`;
rename table `gatheringpermissionassignments` to `GatheringPermissionAssignments`;
rename table `gatherings` to `Gatherings`;
rename table `groups` to `Groups`;
rename table `groupsetgroups` to `GroupSetGroups`;
rename table `groupsets` to `GroupSets`;
rename table `jobs` to `Jobs`;
rename table `jobsetjobs` to `JobSetJobs`;
rename table `jobsets` to `JobSets`;
rename table `jobslog` to `JobsLog`;
rename table `logs` to `Logs`;
rename table `mailimporters` to `MailImporters`;
rename table `mailvalidationhashes` to `MailValidationHashes`;
rename table `multilingualpagerelations` to `MultilingualPageRelations`;
rename table `multilingualsections` to `MultilingualSections`;
rename table `multilingualtranslations` to `MultilingualTranslations`;
rename table `oauthusermap` to `OauthUserMap`;
rename table `packages` to `Packages`;
rename table `pagefeeds` to `PageFeeds`;
rename table `pagepaths` to `PagePaths`;
rename table `pagepermissionassignments` to `PagePermissionAssignments`;
rename table `pagepermissionpagetypeaccesslist` to `PagePermissionPageTypeAccessList`;
rename table `pagepermissionpagetypeaccesslistcustom` to `PagePermissionPageTypeAccessListCustom`;
rename table `pagepermissionpropertyaccesslist` to `PagePermissionPropertyAccessList`;
rename table `pagepermissionpropertyattributeaccesslistcustom` to `PagePermissionPropertyAttributeAccessListCustom`;
rename table `pagepermissionthemeaccesslist` to `PagePermissionThemeAccessList`;
rename table `pagepermissionthemeaccesslistcustom` to `PagePermissionThemeAccessListCustom`;
rename table `pages` to `Pages`;
rename table `pagesearchindex` to `PageSearchIndex`;
rename table `pagestatistics` to `PageStatistics`;
rename table `pagetemplates` to `PageTemplates`;
rename table `pagethemecustomstyles` to `PageThemeCustomStyles`;
rename table `pagethemes` to `PageThemes`;
rename table `pagetypecomposercontroltypes` to `PageTypeComposerControlTypes`;
rename table `pagetypecomposerformlayoutsetcontrols` to `PageTypeComposerFormLayoutSetControls`;
rename table `pagetypecomposerformlayoutsets` to `PageTypeComposerFormLayoutSets`;
rename table `pagetypecomposeroutputblocks` to `PageTypeComposerOutputBlocks`;
rename table `pagetypecomposeroutputcontrols` to `PageTypeComposerOutputControls`;
rename table `pagetypepagetemplatedefaultpages` to `PageTypePageTemplateDefaultPages`;
rename table `pagetypepagetemplates` to `PageTypePageTemplates`;
rename table `pagetypepermissionassignments` to `PageTypePermissionAssignments`;
rename table `pagetypepublishtargettypes` to `PageTypePublishTargetTypes`;
rename table `pagetypes` to `PageTypes`;
rename table `pageworkflowprogress` to `PageWorkflowProgress`;
rename table `permissionaccess` to `PermissionAccess`;
rename table `permissionaccessentities` to `PermissionAccessEntities`;
rename table `permissionaccessentitygroups` to `PermissionAccessEntityGroups`;
rename table `permissionaccessentitygroupsets` to `PermissionAccessEntityGroupSets`;
rename table `permissionaccessentitytypecategories` to `PermissionAccessEntityTypeCategories`;
rename table `permissionaccessentitytypes` to `PermissionAccessEntityTypes`;
rename table `permissionaccessentityusers` to `PermissionAccessEntityUsers`;
rename table `permissionaccesslist` to `PermissionAccessList`;
rename table `permissionaccessworkflows` to `PermissionAccessWorkflows`;
rename table `permissionassignments` to `PermissionAssignments`;
rename table `permissiondurationobjects` to `PermissionDurationObjects`;
rename table `permissionkeycategories` to `PermissionKeyCategories`;
rename table `permissionkeys` to `PermissionKeys`;
rename table `pilecontents` to `PileContents`;
rename table `piles` to `Piles`;
rename table `queuemessages` to `QueueMessages`;
rename table `queuepageduplicationrelations` to `QueuePageDuplicationRelations`;
rename table `queues` to `Queues`;
rename table `sessions` to `Sessions`;
rename table `signuprequests` to `SignupRequests`;
rename table `sociallinks` to `SocialLinks`;
rename table `stacks` to `Stacks`;
rename table `stylecustomizercustomcssrecords` to `StyleCustomizerCustomCssRecords`;
rename table `stylecustomizerinlinestylepresets` to `StyleCustomizerInlineStylePresets`;
rename table `stylecustomizerinlinestylesets` to `StyleCustomizerInlineStyleSets`;
rename table `stylecustomizervaluelists` to `StyleCustomizerValueLists`;
rename table `stylecustomizervalues` to `StyleCustomizerValues`;
rename table `systemantispamlibraries` to `SystemAntispamLibraries`;
rename table `systemcaptchalibraries` to `SystemCaptchaLibraries`;
rename table `systemcontenteditorsnippets` to `SystemContentEditorSnippets`;
rename table `systemdatabasemigrations` to `SystemDatabaseMigrations`;
rename table `systemdatabasequerylog` to `SystemDatabaseQueryLog`;
rename table `systemimageeditorcomponents` to `SystemImageEditorComponents`;
rename table `systemimageeditorcontrolsets` to `SystemImageEditorControlSets`;
rename table `systemimageeditorfilters` to `SystemImageEditorFilters`;
rename table `systemimageeditorshapes` to `SystemImageEditorShapes`;
rename table `topictrees` to `TopicTrees`;
rename table `treecategorynodes` to `TreeCategoryNodes`;
rename table `treegroupnodes` to `TreeGroupNodes`;
rename table `treenodepermissionassignments` to `TreeNodePermissionAssignments`;
rename table `treenodes` to `TreeNodes`;
rename table `treenodetypes` to `TreeNodeTypes`;
rename table `trees` to `Trees`;
rename table `treetopicnodes` to `TreeTopicNodes`;
rename table `treetypes` to `TreeTypes`;
rename table `userattributekeys` to `UserAttributeKeys`;
rename table `userattributevalues` to `UserAttributeValues`;
rename table `userbannedips` to `UserBannedIPs`;
rename table `usergroups` to `UserGroups`;
rename table `userpermissioneditpropertyaccesslist` to `UserPermissionEditPropertyAccessList`;
rename table `userpermissioneditpropertyattributeaccesslistcustom` to `UserPermissionEditPropertyAttributeAccessListCustom`;
rename table `userpermissionviewattributeaccesslist` to `UserPermissionViewAttributeAccessList`;
rename table `userpermissionviewattributeaccesslistcustom` to `UserPermissionViewAttributeAccessListCustom`;
rename table `userpointactions` to `UserPointActions`;
rename table `userpointhistory` to `UserPointHistory`;
rename table `userprivatemessages` to `UserPrivateMessages`;
rename table `userprivatemessagesto` to `UserPrivateMessagesTo`;
rename table `users` to `Users`;
rename table `usersearchindexattributes` to `UserSearchIndexAttributes`;
rename table `uservalidationhashes` to `UserValidationHashes`;
rename table `workflowprogress` to `WorkflowProgress`;
rename table `workflowprogresscategories` to `WorkflowProgressCategories`;
rename table `workflowprogresshistory` to `WorkflowProgressHistory`;
rename table `workflowrequestobjects` to `WorkflowRequestObjects`;
rename table `workflows` to `Workflows`;
rename table `workflowtypes` to `WorkflowTypes`;

hayaka26 replied on Mar 30, 2016 at 1:23 am Permalink Reply

For concrete5.7.5.6

rename table `arealayoutcolumns` to `AreaLayoutColumns`;
rename table `arealayoutcustomcolumns` to `AreaLayoutCustomColumns`;
rename table `arealayoutpresets` to `AreaLayoutPresets`;
rename table `arealayouts` to `AreaLayouts`;
rename table `arealayoutsusingpresets` to `AreaLayoutsUsingPresets`;
rename table `arealayoutthemegridcolumns` to `AreaLayoutThemeGridColumns`;
rename table `areapermissionassignments` to `AreaPermissionAssignments`;
rename table `areapermissionblocktypeaccesslist` to `AreaPermissionBlockTypeAccessList`;
rename table `areapermissionblocktypeaccesslistcustom` to `AreaPermissionBlockTypeAccessListCustom`;
rename table `areas` to `Areas`;
rename table `ataddress` to `atAddress`;
rename table `ataddresscustomcountries` to `atAddressCustomCountries`;
rename table `ataddresssettings` to `atAddressSettings`;
rename table `atboolean` to `atBoolean`;
rename table `atbooleansettings` to `atBooleanSettings`;

Viewing 15 lines of 247 lines. View entire code block.

 
rename table `arealayoutcolumns` to `AreaLayoutColumns`;
rename table `arealayoutcustomcolumns` to `AreaLayoutCustomColumns`;
rename table `arealayoutpresets` to `AreaLayoutPresets`;
rename table `arealayouts` to `AreaLayouts`;
rename table `arealayoutsusingpresets` to `AreaLayoutsUsingPresets`;
rename table `arealayoutthemegridcolumns` to `AreaLayoutThemeGridColumns`;
rename table `areapermissionassignments` to `AreaPermissionAssignments`;
rename table `areapermissionblocktypeaccesslist` to `AreaPermissionBlockTypeAccessList`;
rename table `areapermissionblocktypeaccesslistcustom` to `AreaPermissionBlockTypeAccessListCustom`;
rename table `areas` to `Areas`;
rename table `ataddress` to `atAddress`;
rename table `ataddresscustomcountries` to `atAddressCustomCountries`;
rename table `ataddresssettings` to `atAddressSettings`;
rename table `atboolean` to `atBoolean`;
rename table `atbooleansettings` to `atBooleanSettings`;
rename table `atdatetime` to `atDateTime`;
rename table `atdatetimesettings` to `atDateTimeSettings`;
rename table `atdefault` to `atDefault`;
rename table `atfile` to `atFile`;
rename table `atnumber` to `atNumber`;
rename table `atselectedtopics` to `atSelectedTopics`;
rename table `atselectoptions` to `atSelectOptions`;
rename table `atselectoptionsselected` to `atSelectOptionsSelected`;
rename table `atselectsettings` to `atSelectSettings`;
rename table `atsociallinks` to `atSocialLinks`;
rename table `attextareasettings` to `atTextareaSettings`;
rename table `attopicsettings` to `atTopicSettings`;
rename table `attributekeycategories` to `AttributeKeyCategories`;
rename table `attributekeys` to `AttributeKeys`;
rename table `attributesetkeys` to `AttributeSetKeys`;
rename table `attributesets` to `AttributeSets`;
rename table `attributetypecategories` to `AttributeTypeCategories`;
rename table `attributetypes` to `AttributeTypes`;
rename table `attributevalues` to `AttributeValues`;
rename table `authenticationtypes` to `AuthenticationTypes`;
rename table `authtypeconcretecookiemap` to `authTypeConcreteCookieMap`;
rename table `bannedwords` to `BannedWords`;
rename table `basicworkflowpermissionassignments` to `BasicWorkflowPermissionAssignments`;
rename table `basicworkflowprogressdata` to `BasicWorkflowProgressData`;
rename table `blockfeatureassignments` to `BlockFeatureAssignments`;
rename table `blockpermissionassignments` to `BlockPermissionAssignments`;
rename table `blockrelations` to `BlockRelations`;
rename table `blocks` to `Blocks`;
rename table `blocktypepermissionblocktypeaccesslist` to `BlockTypePermissionBlockTypeAccessList`;
rename table `blocktypepermissionblocktypeaccesslistcustom` to `BlockTypePermissionBlockTypeAccessListCustom`;
rename table `blocktypes` to `BlockTypes`;
rename table `blocktypesetblocktypes` to `BlockTypeSetBlockTypes`;
rename table `blocktypesets` to `BlockTypeSets`;
rename table `btcontentfile` to `btContentFile`;
rename table `btcontentimage` to `btContentImage`;
rename table `btcontentlocal` to `btContentLocal`;
rename table `btcorearealayout` to `btCoreAreaLayout`;
rename table `btcoreconversation` to `btCoreConversation`;
rename table `btcorepagetypecomposercontroloutput` to `btCorePageTypeComposerControlOutput`;
rename table `btcorescrapbookdisplay` to `btCoreScrapbookDisplay`;
rename table `btcorestackdisplay` to `btCoreStackDisplay`;
rename table `btdashboardnewsflowlatest` to `btDashboardNewsflowLatest`;
rename table `btdatenavigation` to `btDateNavigation`;
rename table `btexternalform` to `btExternalForm`;
rename table `btfaq` to `btFaq`;
rename table `btfaqentries` to `btFaqEntries`;
rename table `btfeature` to `btFeature`;
rename table `btform` to `btForm`;
rename table `btformanswers` to `btFormAnswers`;
rename table `btformanswerset` to `btFormAnswerSet`;
rename table `btformquestions` to `btFormQuestions`;
rename table `btgooglemap` to `btGoogleMap`;
rename table `btimageslider` to `btImageSlider`;
rename table `btimagesliderentries` to `btImageSliderEntries`;
rename table `btnavigation` to `btNavigation`;
rename table `btnextprevious` to `btNextPrevious`;
rename table `btpageattributedisplay` to `btPageAttributeDisplay`;
rename table `btpagelist` to `btPageList`;
rename table `btpagetitle` to `btPageTitle`;
rename table `btrssdisplay` to `btRssDisplay`;
rename table `btsearch` to `btSearch`;
rename table `btsharethispage` to `btShareThisPage`;
rename table `btsociallinks` to `btSocialLinks`;
rename table `btsurvey` to `btSurvey`;
rename table `btsurveyoptions` to `btSurveyOptions`;
rename table `btsurveyresults` to `btSurveyResults`;
rename table `btswitchlanguage` to `btSwitchLanguage`;
rename table `bttags` to `btTags`;
rename table `bttestimonial` to `btTestimonial`;
rename table `bttopiclist` to `btTopicList`;
rename table `btvideo` to `btVideo`;
rename table `btyoutube` to `btYouTube`;
rename table `collectionattributevalues` to `CollectionAttributeValues`;
rename table `collections` to `Collections`;
rename table `collectionsearchindexattributes` to `CollectionSearchIndexAttributes`;
rename table `collectionversionareastyles` to `CollectionVersionAreaStyles`;
rename table `collectionversionblocks` to `CollectionVersionBlocks`;
rename table `collectionversionblockscachesettings` to `CollectionVersionBlocksCacheSettings`;
rename table `collectionversionblocksoutputcache` to `CollectionVersionBlocksOutputCache`;
rename table `collectionversionblockstyles` to `CollectionVersionBlockStyles`;
rename table `collectionversionfeatureassignments` to `CollectionVersionFeatureAssignments`;
rename table `collectionversionrelatededits` to `CollectionVersionRelatedEdits`;
rename table `collectionversions` to `CollectionVersions`;
rename table `collectionversionthemecustomstyles` to `CollectionVersionThemeCustomStyles`;
rename table `config` to `Config`;
rename table `configstore` to `ConfigStore`;
rename table `conversationdiscussions` to `ConversationDiscussions`;
rename table `conversationeditors` to `ConversationEditors`;
rename table `conversationfeaturedetailassignments` to `ConversationFeatureDetailAssignments`;
rename table `conversationflaggedmessages` to `ConversationFlaggedMessages`;
rename table `conversationflaggedmessagetypes` to `ConversationFlaggedMessageTypes`;
rename table `conversationmessageattachments` to `ConversationMessageAttachments`;
rename table `conversationmessageratings` to `ConversationMessageRatings`;
rename table `conversationmessages` to `ConversationMessages`;
rename table `conversationpermissionaddmessageaccesslist` to `ConversationPermissionAddMessageAccessList`;
rename table `conversationpermissionassignments` to `ConversationPermissionAssignments`;
rename table `conversationratingtypes` to `ConversationRatingTypes`;
rename table `conversations` to `Conversations`;
rename table `conversationsubscriptions` to `ConversationSubscriptions`;
rename table `downloadstatistics` to `DownloadStatistics`;
rename table `featureassignments` to `FeatureAssignments`;
rename table `featurecategories` to `FeatureCategories`;
rename table `features` to `Features`;
rename table `fileattributevalues` to `FileAttributeValues`;
rename table `fileimagethumbnailtypes` to `FileImageThumbnailTypes`;
rename table `filepermissionassignments` to `FilePermissionAssignments`;
rename table `filepermissionfiletypes` to `FilePermissionFileTypes`;
rename table `files` to `Files`;
rename table `filesearchindexattributes` to `FileSearchIndexAttributes`;
rename table `filesetfiles` to `FileSetFiles`;
rename table `filesetpermissionassignments` to `FileSetPermissionAssignments`;
rename table `filesetpermissionfiletypeaccesslist` to `FileSetPermissionFileTypeAccessList`;
rename table `filesetpermissionfiletypeaccesslistcustom` to `FileSetPermissionFileTypeAccessListCustom`;
rename table `filesets` to `FileSets`;
rename table `filesetsavedsearches` to `FileSetSavedSearches`;
rename table `filestoragelocations` to `FileStorageLocations`;
rename table `filestoragelocationtypes` to `FileStorageLocationTypes`;
rename table `fileversionlog` to `FileVersionLog`;
rename table `fileversions` to `FileVersions`;
rename table `gapage` to `gaPage`;
rename table `gatheringconfigureddatasources` to `GatheringConfiguredDataSources`;
rename table `gatheringdatasources` to `GatheringDataSources`;
rename table `gatheringitemfeatureassignments` to `GatheringItemFeatureAssignments`;
rename table `gatheringitems` to `GatheringItems`;
rename table `gatheringitemselectedtemplates` to `GatheringItemSelectedTemplates`;
rename table `gatheringitemtemplatefeatures` to `GatheringItemTemplateFeatures`;
rename table `gatheringitemtemplates` to `GatheringItemTemplates`;
rename table `gatheringitemtemplatetypes` to `GatheringItemTemplateTypes`;
rename table `gatheringpermissionassignments` to `GatheringPermissionAssignments`;
rename table `gatherings` to `Gatherings`;
rename table `groups` to `Groups`;
rename table `groupsetgroups` to `GroupSetGroups`;
rename table `groupsets` to `GroupSets`;
rename table `jobs` to `Jobs`;
rename table `jobsetjobs` to `JobSetJobs`;
rename table `jobsets` to `JobSets`;
rename table `jobslog` to `JobsLog`;
rename table `logs` to `Logs`;
rename table `mailimporters` to `MailImporters`;
rename table `mailvalidationhashes` to `MailValidationHashes`;
rename table `multilingualpagerelations` to `MultilingualPageRelations`;
rename table `multilingualsections` to `MultilingualSections`;
rename table `multilingualtranslations` to `MultilingualTranslations`;
rename table `oauthusermap` to `OauthUserMap`;
rename table `packages` to `Packages`;
rename table `pagefeeds` to `PageFeeds`;
rename table `pagepaths` to `PagePaths`;
rename table `pagepermissionassignments` to `PagePermissionAssignments`;
rename table `pagepermissionpagetypeaccesslist` to `PagePermissionPageTypeAccessList`;
rename table `pagepermissionpagetypeaccesslistcustom` to `PagePermissionPageTypeAccessListCustom`;
rename table `pagepermissionpropertyaccesslist` to `PagePermissionPropertyAccessList`;
rename table `pagepermissionpropertyattributeaccesslistcustom` to `PagePermissionPropertyAttributeAccessListCustom`;
rename table `pagepermissionthemeaccesslist` to `PagePermissionThemeAccessList`;
rename table `pagepermissionthemeaccesslistcustom` to `PagePermissionThemeAccessListCustom`;
rename table `pages` to `Pages`;
rename table `pagesearchindex` to `PageSearchIndex`;
rename table `pagetemplates` to `PageTemplates`;
rename table `pagethemecustomstyles` to `PageThemeCustomStyles`;
rename table `pagethemes` to `PageThemes`;
rename table `pagetypecomposercontroltypes` to `PageTypeComposerControlTypes`;
rename table `pagetypecomposerformlayoutsetcontrols` to `PageTypeComposerFormLayoutSetControls`;
rename table `pagetypecomposerformlayoutsets` to `PageTypeComposerFormLayoutSets`;
rename table `pagetypecomposeroutputblocks` to `PageTypeComposerOutputBlocks`;
rename table `pagetypecomposeroutputcontrols` to `PageTypeComposerOutputControls`;
rename table `pagetypepagetemplatedefaultpages` to `PageTypePageTemplateDefaultPages`;
rename table `pagetypepagetemplates` to `PageTypePageTemplates`;
rename table `pagetypepermissionassignments` to `PageTypePermissionAssignments`;
rename table `pagetypepublishtargettypes` to `PageTypePublishTargetTypes`;
rename table `pagetypes` to `PageTypes`;
rename table `pageworkflowprogress` to `PageWorkflowProgress`;
rename table `permissionaccess` to `PermissionAccess`;
rename table `permissionaccessentities` to `PermissionAccessEntities`;
rename table `permissionaccessentitygroups` to `PermissionAccessEntityGroups`;
rename table `permissionaccessentitygroupsets` to `PermissionAccessEntityGroupSets`;
rename table `permissionaccessentitytypecategories` to `PermissionAccessEntityTypeCategories`;
rename table `permissionaccessentitytypes` to `PermissionAccessEntityTypes`;
rename table `permissionaccessentityusers` to `PermissionAccessEntityUsers`;
rename table `permissionaccesslist` to `PermissionAccessList`;
rename table `permissionaccessworkflows` to `PermissionAccessWorkflows`;
rename table `permissionassignments` to `PermissionAssignments`;
rename table `permissiondurationobjects` to `PermissionDurationObjects`;
rename table `permissionkeycategories` to `PermissionKeyCategories`;
rename table `permissionkeys` to `PermissionKeys`;
rename table `pilecontents` to `PileContents`;
rename table `piles` to `Piles`;
rename table `queuemessages` to `QueueMessages`;
rename table `queuepageduplicationrelations` to `QueuePageDuplicationRelations`;
rename table `queues` to `Queues`;
rename table `sessions` to `Sessions`;
rename table `signuprequests` to `SignupRequests`;
rename table `sociallinks` to `SocialLinks`;
rename table `stacks` to `Stacks`;
rename table `stylecustomizercustomcssrecords` to `StyleCustomizerCustomCssRecords`;
rename table `stylecustomizerinlinestylepresets` to `StyleCustomizerInlineStylePresets`;
rename table `stylecustomizerinlinestylesets` to `StyleCustomizerInlineStyleSets`;
rename table `stylecustomizervaluelists` to `StyleCustomizerValueLists`;
rename table `stylecustomizervalues` to `StyleCustomizerValues`;
rename table `systemantispamlibraries` to `SystemAntispamLibraries`;
rename table `systemcaptchalibraries` to `SystemCaptchaLibraries`;
rename table `systemcontenteditorsnippets` to `SystemContentEditorSnippets`;
rename table `systemdatabasemigrations` to `SystemDatabaseMigrations`;
rename table `systemdatabasequerylog` to `SystemDatabaseQueryLog`;
rename table `topictrees` to `TopicTrees`;
rename table `treecategorynodes` to `TreeCategoryNodes`;
rename table `treegroupnodes` to `TreeGroupNodes`;
rename table `treenodepermissionassignments` to `TreeNodePermissionAssignments`;
rename table `treenodes` to `TreeNodes`;
rename table `treenodetypes` to `TreeNodeTypes`;
rename table `trees` to `Trees`;
rename table `treetopicnodes` to `TreeTopicNodes`;
rename table `treetypes` to `TreeTypes`;
rename table `userattributekeys` to `UserAttributeKeys`;
rename table `userattributevalues` to `UserAttributeValues`;
rename table `userbannedips` to `UserBannedIPs`;
rename table `usergroups` to `UserGroups`;
rename table `userpermissioneditpropertyaccesslist` to `UserPermissionEditPropertyAccessList`;
rename table `userpermissioneditpropertyattributeaccesslistcustom` to `UserPermissionEditPropertyAttributeAccessListCustom`;
rename table `userpermissionviewattributeaccesslist` to `UserPermissionViewAttributeAccessList`;
rename table `userpermissionviewattributeaccesslistcustom` to `UserPermissionViewAttributeAccessListCustom`;
rename table `userpointactions` to `UserPointActions`;
rename table `userpointhistory` to `UserPointHistory`;
rename table `userprivatemessages` to `UserPrivateMessages`;
rename table `userprivatemessagesto` to `UserPrivateMessagesTo`;
rename table `users` to `Users`;
rename table `usersearchindexattributes` to `UserSearchIndexAttributes`;
rename table `uservalidationhashes` to `UserValidationHashes`;
rename table `workflowprogress` to `WorkflowProgress`;
rename table `workflowprogresscategories` to `WorkflowProgressCategories`;
rename table `workflowprogresshistory` to `WorkflowProgressHistory`;
rename table `workflowrequestobjects` to `WorkflowRequestObjects`;
rename table `workflows` to `Workflows`;
rename table `workflowtypes` to `WorkflowTypes`;

serdarde replied on Jun 28, 2016 at 3:05 pm Permalink Reply

Hi friends,

I have got the same error and thanks to "SHOW TABLES" and PHP's foreach I creeated this sql for 5.7

Before this action PLEASE backup your DB.

Dont forget there will be some custom tables from in db. You can rename them by yourself easily.

RENAME TABLE arealayoutcolumns TO AreaLayoutColumns;
RENAME TABLE arealayoutcustomcolumns TO AreaLayoutCustomColumns;
RENAME TABLE arealayoutpresets TO AreaLayoutPresets;
RENAME TABLE arealayoutthemegridcolumns TO AreaLayoutThemeGridColumns;
RENAME TABLE arealayouts TO AreaLayouts;
RENAME TABLE arealayoutsusingpresets TO AreaLayoutsUsingPresets;
RENAME TABLE areapermissionassignments TO AreaPermissionAssignments;
RENAME TABLE areapermissionblocktypeaccesslist TO AreaPermissionBlockTypeAccessList;
RENAME TABLE areapermissionblocktypeaccesslistcustom TO AreaPermissionBlockTypeAccessListCustom;
RENAME TABLE areas TO Areas;
RENAME TABLE attributekeycategories TO AttributeKeyCategories;
RENAME TABLE attributekeys TO AttributeKeys;
RENAME TABLE attributesetkeys TO AttributeSetKeys;
RENAME TABLE attributesets TO AttributeSets;
RENAME TABLE attributetypecategories TO AttributeTypeCategories;
RENAME TABLE attributetypes TO AttributeTypes;
RENAME TABLE attributevalues TO AttributeValues;
RENAME TABLE authenticationtypes TO AuthenticationTypes;
RENAME TABLE bannedwords TO BannedWords;
RENAME TABLE basicworkflowpermissionassignments TO BasicWorkflowPermissionAssignments;
RENAME TABLE basicworkflowprogressdata TO BasicWorkflowProgressData;
RENAME TABLE blockfeatureassignments TO BlockFeatureAssignments;
RENAME TABLE blockpermissionassignments TO BlockPermissionAssignments;
RENAME TABLE blockrelations TO BlockRelations;
RENAME TABLE blocktypepermissionblocktypeaccesslist TO BlockTypePermissionBlockTypeAccessList;
RENAME TABLE blocktypepermissionblocktypeaccesslistcustom TO BlockTypePermissionBlockTypeAccessListCustom;
RENAME TABLE blocktypesetblocktypes TO BlockTypeSetBlockTypes;
RENAME TABLE blocktypesets TO BlockTypeSets;
RENAME TABLE blocktypes TO BlockTypes;
RENAME TABLE blocks TO Blocks;
RENAME TABLE collectionattributevalues TO CollectionAttributeValues;
RENAME TABLE collectionsearchindexattributes TO CollectionSearchIndexAttributes;
RENAME TABLE collectionversionareastyles TO CollectionVersionAreaStyles;
RENAME TABLE collectionversionblockstyles TO CollectionVersionBlockStyles;
RENAME TABLE collectionversionblocks TO CollectionVersionBlocks;
RENAME TABLE collectionversionblockscachesettings TO CollectionVersionBlocksCacheSettings;
RENAME TABLE collectionversionblocksoutputcache TO CollectionVersionBlocksOutputCache;
RENAME TABLE collectionversionfeatureassignments TO CollectionVersionFeatureAssignments;
RENAME TABLE collectionversionrelatededits TO CollectionVersionRelatedEdits;
RENAME TABLE collectionversionthemecustomstyles TO CollectionVersionThemeCustomStyles;
RENAME TABLE collectionversions TO CollectionVersions;
RENAME TABLE collections TO Collections;
RENAME TABLE config TO Config;
RENAME TABLE configstore TO ConfigStore;
RENAME TABLE conversationdiscussions TO ConversationDiscussions;
RENAME TABLE conversationeditors TO ConversationEditors;
RENAME TABLE conversationfeaturedetailassignments TO ConversationFeatureDetailAssignments;
RENAME TABLE conversationflaggedmessagetypes TO ConversationFlaggedMessageTypes;
RENAME TABLE conversationflaggedmessages TO ConversationFlaggedMessages;
RENAME TABLE conversationmessageattachments TO ConversationMessageAttachments;
RENAME TABLE conversationmessageratings TO ConversationMessageRatings;
RENAME TABLE conversationmessages TO ConversationMessages;
RENAME TABLE conversationpermissionaddmessageaccesslist TO ConversationPermissionAddMessageAccessList;
RENAME TABLE conversationpermissionassignments TO ConversationPermissionAssignments;
RENAME TABLE conversationratingtypes TO ConversationRatingTypes;
RENAME TABLE conversationsubscriptions TO ConversationSubscriptions;
RENAME TABLE conversations TO Conversations;
RENAME TABLE downloadstatistics TO DownloadStatistics;
RENAME TABLE featureassignments TO FeatureAssignments;
RENAME TABLE featurecategories TO FeatureCategories;
RENAME TABLE features TO Features;
RENAME TABLE fileattributevalues TO FileAttributeValues;
RENAME TABLE fileimagethumbnailpaths TO FileImageThumbnailPaths;
RENAME TABLE fileimagethumbnailtypes TO FileImageThumbnailTypes;
RENAME TABLE filepermissionassignments TO FilePermissionAssignments;
RENAME TABLE filepermissionfiletypes TO FilePermissionFileTypes;
RENAME TABLE filesearchindexattributes TO FileSearchIndexAttributes;
RENAME TABLE filesetfiles TO FileSetFiles;
RENAME TABLE filesetpermissionassignments TO FileSetPermissionAssignments;
RENAME TABLE filesetpermissionfiletypeaccesslist TO FileSetPermissionFileTypeAccessList;
RENAME TABLE filesetpermissionfiletypeaccesslistcustom TO FileSetPermissionFileTypeAccessListCustom;
RENAME TABLE filesetsavedsearches TO FileSetSavedSearches;
RENAME TABLE filesets TO FileSets;
RENAME TABLE filestoragelocationtypes TO FileStorageLocationTypes;
RENAME TABLE filestoragelocations TO FileStorageLocations;
RENAME TABLE fileversionlog TO FileVersionLog;
RENAME TABLE fileversions TO FileVersions;
RENAME TABLE files TO Files;
RENAME TABLE gatheringconfigureddatasources TO GatheringConfiguredDataSources;
RENAME TABLE gatheringdatasources TO GatheringDataSources;
RENAME TABLE gatheringitemfeatureassignments TO GatheringItemFeatureAssignments;
RENAME TABLE gatheringitemselectedtemplates TO GatheringItemSelectedTemplates;
RENAME TABLE gatheringitemtemplatefeatures TO GatheringItemTemplateFeatures;
RENAME TABLE gatheringitemtemplatetypes TO GatheringItemTemplateTypes;
RENAME TABLE gatheringitemtemplates TO GatheringItemTemplates;
RENAME TABLE gatheringitems TO GatheringItems;
RENAME TABLE gatheringpermissionassignments TO GatheringPermissionAssignments;
RENAME TABLE gatherings TO Gatherings;
RENAME TABLE groupsetgroups TO GroupSetGroups;
RENAME TABLE groupsets TO GroupSets;
RENAME TABLE groups TO Groups;
RENAME TABLE jobsetjobs TO JobSetJobs;
RENAME TABLE jobsets TO JobSets;
RENAME TABLE jobs TO Jobs;
RENAME TABLE jobslog TO JobsLog;
RENAME TABLE logs TO Logs;
RENAME TABLE mailimporters TO MailImporters;
RENAME TABLE mailvalidationhashes TO MailValidationHashes;
RENAME TABLE multilingualpagerelations TO MultilingualPageRelations;
RENAME TABLE multilingualsections TO MultilingualSections;
RENAME TABLE multilingualtranslations TO MultilingualTranslations;
RENAME TABLE oauthusermap TO OauthUserMap;
RENAME TABLE packages TO Packages;
RENAME TABLE pagefeeds TO PageFeeds;
RENAME TABLE pagepaths TO PagePaths;
RENAME TABLE pagepermissionassignments TO PagePermissionAssignments;
RENAME TABLE pagepermissionpagetypeaccesslist TO PagePermissionPageTypeAccessList;
RENAME TABLE pagepermissionpagetypeaccesslistcustom TO PagePermissionPageTypeAccessListCustom;
RENAME TABLE pagepermissionpropertyaccesslist TO PagePermissionPropertyAccessList;
RENAME TABLE pagepermissionpropertyattributeaccesslistcustom TO PagePermissionPropertyAttributeAccessListCustom;
RENAME TABLE pagepermissionthemeaccesslist TO PagePermissionThemeAccessList;
RENAME TABLE pagepermissionthemeaccesslistcustom TO PagePermissionThemeAccessListCustom;
RENAME TABLE pagesearchindex TO PageSearchIndex;
RENAME TABLE pagetemplates TO PageTemplates;
RENAME TABLE pagethemecustomstyles TO PageThemeCustomStyles;
RENAME TABLE pagethemes TO PageThemes;
RENAME TABLE pagetypecomposercontroltypes TO PageTypeComposerControlTypes;
RENAME TABLE pagetypecomposerformlayoutsetcontrols TO PageTypeComposerFormLayoutSetControls;
RENAME TABLE pagetypecomposerformlayoutsets TO PageTypeComposerFormLayoutSets;
RENAME TABLE pagetypecomposeroutputblocks TO PageTypeComposerOutputBlocks;
RENAME TABLE pagetypecomposeroutputcontrols TO PageTypeComposerOutputControls;
RENAME TABLE pagetypepagetemplatedefaultpages TO PageTypePageTemplateDefaultPages;
RENAME TABLE pagetypepagetemplates TO PageTypePageTemplates;
RENAME TABLE pagetypepermissionassignments TO PageTypePermissionAssignments;
RENAME TABLE pagetypepublishtargettypes TO PageTypePublishTargetTypes;
RENAME TABLE pagetypes TO PageTypes;
RENAME TABLE pageworkflowprogress TO PageWorkflowProgress;
RENAME TABLE pages TO Pages;
RENAME TABLE permissionaccess TO PermissionAccess;
RENAME TABLE permissionaccessentities TO PermissionAccessEntities;
RENAME TABLE permissionaccessentitygroupsets TO PermissionAccessEntityGroupSets;
RENAME TABLE permissionaccessentitygroups TO PermissionAccessEntityGroups;
RENAME TABLE permissionaccessentitytypecategories TO PermissionAccessEntityTypeCategories;
RENAME TABLE permissionaccessentitytypes TO PermissionAccessEntityTypes;
RENAME TABLE permissionaccessentityusers TO PermissionAccessEntityUsers;
RENAME TABLE permissionaccesslist TO PermissionAccessList;
RENAME TABLE permissionaccessworkflows TO PermissionAccessWorkflows;
RENAME TABLE permissionassignments TO PermissionAssignments;
RENAME TABLE permissiondurationobjects TO PermissionDurationObjects;
RENAME TABLE permissionkeycategories TO PermissionKeyCategories;
RENAME TABLE permissionkeys TO PermissionKeys;
RENAME TABLE pilecontents TO PileContents;
RENAME TABLE piles TO Piles;
RENAME TABLE queuemessages TO QueueMessages;
RENAME TABLE queuepageduplicationrelations TO QueuePageDuplicationRelations;
RENAME TABLE queues TO Queues;
RENAME TABLE sessions TO Sessions;
RENAME TABLE signuprequests TO SignupRequests;
RENAME TABLE sociallinks TO SocialLinks;
RENAME TABLE stacks TO Stacks;
RENAME TABLE stylecustomizercustomcssrecords TO StyleCustomizerCustomCssRecords;
RENAME TABLE stylecustomizerinlinestylepresets TO StyleCustomizerInlineStylePresets;
RENAME TABLE stylecustomizerinlinestylesets TO StyleCustomizerInlineStyleSets;
RENAME TABLE stylecustomizervaluelists TO StyleCustomizerValueLists;
RENAME TABLE stylecustomizervalues TO StyleCustomizerValues;
RENAME TABLE systemantispamlibraries TO SystemAntispamLibraries;
RENAME TABLE systemcaptchalibraries TO SystemCaptchaLibraries;
RENAME TABLE systemcontenteditorsnippets TO SystemContentEditorSnippets;
RENAME TABLE systemdatabasemigrations TO SystemDatabaseMigrations;
RENAME TABLE systemdatabasequerylog TO SystemDatabaseQueryLog;
RENAME TABLE topictrees TO TopicTrees;
RENAME TABLE treecategorynodes TO TreeCategoryNodes;
RENAME TABLE treegroupnodes TO TreeGroupNodes;
RENAME TABLE treenodepermissionassignments TO TreeNodePermissionAssignments;
RENAME TABLE treenodetypes TO TreeNodeTypes;
RENAME TABLE treenodes TO TreeNodes;
RENAME TABLE treetopicnodes TO TreeTopicNodes;
RENAME TABLE treetypes TO TreeTypes;
RENAME TABLE trees TO Trees;
RENAME TABLE userattributekeys TO UserAttributeKeys;
RENAME TABLE userattributevalues TO UserAttributeValues;
RENAME TABLE userbannedips TO UserBannedIPs;
RENAME TABLE usergroups TO UserGroups;
RENAME TABLE userpermissioneditpropertyaccesslist TO UserPermissionEditPropertyAccessList;
RENAME TABLE userpermissioneditpropertyattributeaccesslistcustom TO UserPermissionEditPropertyAttributeAccessListCustom;
RENAME TABLE userpermissionviewattributeaccesslist TO UserPermissionViewAttributeAccessList;
RENAME TABLE userpermissionviewattributeaccesslistcustom TO UserPermissionViewAttributeAccessListCustom;
RENAME TABLE userpointactions TO UserPointActions;
RENAME TABLE userpointhistory TO UserPointHistory;
RENAME TABLE userprivatemessages TO UserPrivateMessages;
RENAME TABLE userprivatemessagesto TO UserPrivateMessagesTo;
RENAME TABLE usersearchindexattributes TO UserSearchIndexAttributes;
RENAME TABLE uservalidationhashes TO UserValidationHashes;
RENAME TABLE users TO Users;
RENAME TABLE workflowprogress TO WorkflowProgress;
RENAME TABLE workflowprogresscategories TO WorkflowProgressCategories;
RENAME TABLE workflowprogresshistory TO WorkflowProgressHistory;
RENAME TABLE workflowrequestobjects TO WorkflowRequestObjects;
RENAME TABLE workflowtypes TO WorkflowTypes;
RENAME TABLE workflows TO Workflows;
RENAME TABLE ataddress TO atAddress;
RENAME TABLE ataddresscustomcountries TO atAddressCustomCountries;
RENAME TABLE ataddresssettings TO atAddressSettings;
RENAME TABLE atboolean TO atBoolean;
RENAME TABLE atbooleansettings TO atBooleanSettings;
RENAME TABLE atdatetime TO atDateTime;
RENAME TABLE atdatetimesettings TO atDateTimeSettings;
RENAME TABLE atdefault TO atDefault;
RENAME TABLE atfile TO atFile;
RENAME TABLE atnumber TO atNumber;
RENAME TABLE atselectoptions TO atSelectOptions;
RENAME TABLE atselectoptionsselected TO atSelectOptionsSelected;
RENAME TABLE atselectsettings TO atSelectSettings;
RENAME TABLE atselectedtopics TO atSelectedTopics;
RENAME TABLE atsociallinks TO atSocialLinks;
RENAME TABLE attextareasettings TO atTextareaSettings;
RENAME TABLE attopicsettings TO atTopicSettings;
RENAME TABLE authtypeconcretecookiemap TO authTypeConcreteCookieMap;
RENAME TABLE btcontentfile TO btContentFile;
RENAME TABLE btcontentimage TO btContentImage;
RENAME TABLE btcontentlocal TO btContentLocal;
RENAME TABLE btcorearealayout TO btCoreAreaLayout;
RENAME TABLE btcoreconversation TO btCoreConversation;
RENAME TABLE btcorepagetypecomposercontroloutput TO btCorePageTypeComposerControlOutput;
RENAME TABLE btcorescrapbookdisplay TO btCoreScrapbookDisplay;
RENAME TABLE btcorestackdisplay TO btCoreStackDisplay;
RENAME TABLE btdashboardnewsflowlatest TO btDashboardNewsflowLatest;
RENAME TABLE btdatenavigation TO btDateNavigation;
RENAME TABLE btexternalform TO btExternalForm;
RENAME TABLE btfaq TO btFaq;
RENAME TABLE btfaqentries TO btFaqEntries;
RENAME TABLE btfeature TO btFeature;
RENAME TABLE btform TO btForm;
RENAME TABLE btformanswerset TO btFormAnswerSet;
RENAME TABLE btformanswers TO btFormAnswers;
RENAME TABLE btformquestions TO btFormQuestions;
RENAME TABLE btgooglemap TO btGoogleMap;
RENAME TABLE btimageslider TO btImageSlider;
RENAME TABLE btimagesliderentries TO btImageSliderEntries;
RENAME TABLE btnavigation TO btNavigation;
RENAME TABLE btnextprevious TO btNextPrevious;
RENAME TABLE btpageattributedisplay TO btPageAttributeDisplay;
RENAME TABLE btpagelist TO btPageList;
RENAME TABLE btpagetitle TO btPageTitle;
RENAME TABLE btrssdisplay TO btRssDisplay;
RENAME TABLE btsearch TO btSearch;
RENAME TABLE btsharethispage TO btShareThisPage;
RENAME TABLE btsociallinks TO btSocialLinks;
RENAME TABLE btsurvey TO btSurvey;
RENAME TABLE btsurveyoptions TO btSurveyOptions;
RENAME TABLE btsurveyresults TO btSurveyResults;
RENAME TABLE btswitchlanguage TO btSwitchLanguage;
RENAME TABLE bttags TO btTags;
RENAME TABLE bttestimonial TO btTestimonial;
RENAME TABLE bttopiclist TO btTopicList;
RENAME TABLE btvideo TO btVideo;
RENAME TABLE btyoutube TO btYouTube;
RENAME TABLE gapage TO gaPage;

craveitla replied on Dec 16, 2016 at 8:58 am Permalink Reply

For version 5.8.0.2

ALTER TABLE arealayoutcolumns RENAME AreaLayoutColumns;
ALTER TABLE arealayoutcustomcolumns RENAME AreaLayoutCustomColumns;
ALTER TABLE arealayoutpresets RENAME AreaLayoutPresets;
ALTER TABLE arealayoutthemegridcolumns RENAME AreaLayoutThemeGridColumns;
ALTER TABLE arealayouts RENAME AreaLayouts;
ALTER TABLE arealayoutsusingpresets RENAME AreaLayoutsUsingPresets;
ALTER TABLE areapermissionassignments RENAME AreaPermissionAssignments;
ALTER TABLE areapermissionblocktypeaccesslist RENAME AreaPermissionBlockTypeAccessList;
ALTER TABLE areapermissionblocktypeaccesslistcustom RENAME AreaPermissionBlockTypeAccessListCustom;
ALTER TABLE areas RENAME Areas;
ALTER TABLE attributekeycategories RENAME AttributeKeyCategories;
ALTER TABLE attributekeys RENAME AttributeKeys;
ALTER TABLE attributesetkeys RENAME AttributeSetKeys;
ALTER TABLE attributesets RENAME AttributeSets;
ALTER TABLE attributetypecategories RENAME AttributeTypeCategories;

Viewing 15 lines of 298 lines. View entire code block.

ALTER TABLE arealayoutcolumns RENAME AreaLayoutColumns;
ALTER TABLE arealayoutcustomcolumns RENAME AreaLayoutCustomColumns;
ALTER TABLE arealayoutpresets RENAME AreaLayoutPresets;
ALTER TABLE arealayoutthemegridcolumns RENAME AreaLayoutThemeGridColumns;
ALTER TABLE arealayouts RENAME AreaLayouts;
ALTER TABLE arealayoutsusingpresets RENAME AreaLayoutsUsingPresets;
ALTER TABLE areapermissionassignments RENAME AreaPermissionAssignments;
ALTER TABLE areapermissionblocktypeaccesslist RENAME AreaPermissionBlockTypeAccessList;
ALTER TABLE areapermissionblocktypeaccesslistcustom RENAME AreaPermissionBlockTypeAccessListCustom;
ALTER TABLE areas RENAME Areas;
ALTER TABLE attributekeycategories RENAME AttributeKeyCategories;
ALTER TABLE attributekeys RENAME AttributeKeys;
ALTER TABLE attributesetkeys RENAME AttributeSetKeys;
ALTER TABLE attributesets RENAME AttributeSets;
ALTER TABLE attributetypecategories RENAME AttributeTypeCategories;
ALTER TABLE attributetypes RENAME AttributeTypes;
ALTER TABLE attributevalues RENAME AttributeValues;
ALTER TABLE authenticationtypes RENAME AuthenticationTypes;
ALTER TABLE bannedwords RENAME BannedWords;
ALTER TABLE basicworkflowpermissionassignments RENAME BasicWorkflowPermissionAssignments;
ALTER TABLE basicworkflowprogressdata RENAME BasicWorkflowProgressData;
ALTER TABLE blockfeatureassignments RENAME BlockFeatureAssignments;
ALTER TABLE blockpermissionassignments RENAME BlockPermissionAssignments;
ALTER TABLE blocktypepermissionblocktypeaccesslist RENAME BlockTypePermissionBlockTypeAccessList;
ALTER TABLE blocktypepermissionblocktypeaccesslistcustom RENAME BlockTypePermissionBlockTypeAccessListCustom;
ALTER TABLE blocktypesetblocktypes RENAME BlockTypeSetBlockTypes;
ALTER TABLE blocktypesets RENAME BlockTypeSets;
ALTER TABLE blocktypes RENAME BlockTypes;
ALTER TABLE blocks RENAME Blocks;
ALTER TABLE collectionattributekeys RENAME CollectionAttributeKeys;
ALTER TABLE collectionattributevalues RENAME CollectionAttributeValues;
ALTER TABLE collectionsearchindexattributes RENAME CollectionSearchIndexAttributes;
ALTER TABLE collectionversionareastyles RENAME CollectionVersionAreaStyles;
ALTER TABLE collectionversionblockstyles RENAME CollectionVersionBlockStyles;
ALTER TABLE collectionversionblocks RENAME CollectionVersionBlocks;
ALTER TABLE collectionversionblockscachesettings RENAME CollectionVersionBlocksCacheSettings;
ALTER TABLE collectionversionblocksoutputcache RENAME CollectionVersionBlocksOutputCache;
ALTER TABLE collectionversionfeatureassignments RENAME CollectionVersionFeatureAssignments;
ALTER TABLE collectionversionrelatededits RENAME CollectionVersionRelatedEdits;
ALTER TABLE collectionversionthemecustomstyles RENAME CollectionVersionThemeCustomStyles;
ALTER TABLE collectionversions RENAME CollectionVersions;
ALTER TABLE collections RENAME Collections;
ALTER TABLE config RENAME Config;
ALTER TABLE configstore RENAME ConfigStore;
ALTER TABLE conversationdiscussions RENAME ConversationDiscussions;
ALTER TABLE conversationeditors RENAME ConversationEditors;
ALTER TABLE conversationfeaturedetailassignments RENAME ConversationFeatureDetailAssignments;
ALTER TABLE conversationflaggedmessagetypes RENAME ConversationFlaggedMessageTypes;
ALTER TABLE conversationflaggedmessages RENAME ConversationFlaggedMessages;
ALTER TABLE conversationmessageattachments RENAME ConversationMessageAttachments;
ALTER TABLE conversationmessagenotifications RENAME ConversationMessageNotifications;
ALTER TABLE conversationmessageratings RENAME ConversationMessageRatings;
ALTER TABLE conversationmessages RENAME ConversationMessages;
ALTER TABLE conversationpermissionaddmessageaccesslist RENAME ConversationPermissionAddMessageAccessList;
ALTER TABLE conversationpermissionassignments RENAME ConversationPermissionAssignments;
ALTER TABLE conversationratingtypes RENAME ConversationRatingTypes;
ALTER TABLE conversationsubscriptions RENAME ConversationSubscriptions;
ALTER TABLE conversations RENAME Conversations;
ALTER TABLE downloadstatistics RENAME DownloadStatistics;
ALTER TABLE expressattributekeys RENAME ExpressAttributeKeys;
ALTER TABLE expressentities RENAME ExpressEntities;
ALTER TABLE expressentityassociationselectedentries RENAME ExpressEntityAssociationSelectedEntries;
ALTER TABLE expressentityassociations RENAME ExpressEntityAssociations;
ALTER TABLE expressentityentries RENAME ExpressEntityEntries;
ALTER TABLE expressentityentryassociations RENAME ExpressEntityEntryAssociations;
ALTER TABLE expressentityentryattributevalues RENAME ExpressEntityEntryAttributeValues;
ALTER TABLE expressformfieldsetassociationcontrols RENAME ExpressFormFieldSetAssociationControls;
ALTER TABLE expressformfieldsetattributekeycontrols RENAME ExpressFormFieldSetAttributeKeyControls;
ALTER TABLE expressformfieldsetcontrols RENAME ExpressFormFieldSetControls;
ALTER TABLE expressformfieldsettextcontrols RENAME ExpressFormFieldSetTextControls;
ALTER TABLE expressformfieldsets RENAME ExpressFormFieldSets;
ALTER TABLE expressforms RENAME ExpressForms;
ALTER TABLE featureassignments RENAME FeatureAssignments;
ALTER TABLE featurecategories RENAME FeatureCategories;
ALTER TABLE features RENAME Features;
ALTER TABLE fileattributekeys RENAME FileAttributeKeys;
ALTER TABLE fileattributevalues RENAME FileAttributeValues;
ALTER TABLE fileimagethumbnailpaths RENAME FileImageThumbnailPaths;
ALTER TABLE fileimagethumbnailtypes RENAME FileImageThumbnailTypes;
ALTER TABLE filepermissionassignments RENAME FilePermissionAssignments;
ALTER TABLE filepermissionfiletypeaccesslist RENAME FilePermissionFileTypeAccessList;
ALTER TABLE filepermissionfiletypeaccesslistcustom RENAME FilePermissionFileTypeAccessListCustom;
ALTER TABLE filepermissionfiletypes RENAME FilePermissionFileTypes;
ALTER TABLE filesearchindexattributes RENAME FileSearchIndexAttributes;
ALTER TABLE filesetfiles RENAME FileSetFiles;
ALTER TABLE filesetsavedsearches RENAME FileSetSavedSearches;
ALTER TABLE filesets RENAME FileSets;
ALTER TABLE filestoragelocationtypes RENAME FileStorageLocationTypes;
ALTER TABLE filestoragelocations RENAME FileStorageLocations;
ALTER TABLE fileusagerecord RENAME FileUsageRecord;
ALTER TABLE fileversionlog RENAME FileVersionLog;
ALTER TABLE fileversions RENAME FileVersions;
ALTER TABLE files RENAME Files;
ALTER TABLE gatheringconfigureddatasources RENAME GatheringConfiguredDataSources;
ALTER TABLE gatheringdatasources RENAME GatheringDataSources;
ALTER TABLE gatheringitemfeatureassignments RENAME GatheringItemFeatureAssignments;
ALTER TABLE gatheringitemselectedtemplates RENAME GatheringItemSelectedTemplates;
ALTER TABLE gatheringitemtemplatefeatures RENAME GatheringItemTemplateFeatures;
ALTER TABLE gatheringitemtemplatetypes RENAME GatheringItemTemplateTypes;
ALTER TABLE gatheringitemtemplates RENAME GatheringItemTemplates;
ALTER TABLE gatheringitems RENAME GatheringItems;
ALTER TABLE gatheringpermissionassignments RENAME GatheringPermissionAssignments;
ALTER TABLE gatherings RENAME Gatherings;
ALTER TABLE groupsetgroups RENAME GroupSetGroups;
ALTER TABLE groupsets RENAME GroupSets;
ALTER TABLE groups RENAME Groups;
ALTER TABLE jobsetjobs RENAME JobSetJobs;
ALTER TABLE jobsets RENAME JobSets;
ALTER TABLE jobs RENAME Jobs;
ALTER TABLE jobslog RENAME JobsLog;
ALTER TABLE legacyattributekeys RENAME LegacyAttributeKeys;
ALTER TABLE logs RENAME Logs;
ALTER TABLE mailimporters RENAME MailImporters;
ALTER TABLE mailvalidationhashes RENAME MailValidationHashes;
ALTER TABLE multilingualpagerelations RENAME MultilingualPageRelations;
ALTER TABLE multilingualtranslations RENAME MultilingualTranslations;
ALTER TABLE notificationalerts RENAME NotificationAlerts;
ALTER TABLE notificationpermissionsubscriptionlist RENAME NotificationPermissionSubscriptionList;
ALTER TABLE notificationpermissionsubscriptionlistcustom RENAME NotificationPermissionSubscriptionListCustom;
ALTER TABLE notifications RENAME Notifications;
ALTER TABLE oauthusermap RENAME OauthUserMap;
ALTER TABLE packages RENAME Packages;
ALTER TABLE pagefeeds RENAME PageFeeds;
ALTER TABLE pagepaths RENAME PagePaths;
ALTER TABLE pagepermissionassignments RENAME PagePermissionAssignments;
ALTER TABLE pagepermissionpagetypeaccesslist RENAME PagePermissionPageTypeAccessList;
ALTER TABLE pagepermissionpagetypeaccesslistcustom RENAME PagePermissionPageTypeAccessListCustom;
ALTER TABLE pagepermissionpropertyaccesslist RENAME PagePermissionPropertyAccessList;
ALTER TABLE pagepermissionpropertyattributeaccesslistcustom RENAME PagePermissionPropertyAttributeAccessListCustom;
ALTER TABLE pagepermissionthemeaccesslist RENAME PagePermissionThemeAccessList;
ALTER TABLE pagepermissionthemeaccesslistcustom RENAME PagePermissionThemeAccessListCustom;
ALTER TABLE pagesearchindex RENAME PageSearchIndex;
ALTER TABLE pagetemplates RENAME PageTemplates;
ALTER TABLE pagethemecustomstyles RENAME PageThemeCustomStyles;
ALTER TABLE pagethemes RENAME PageThemes;
ALTER TABLE pagetypecomposercontroltypes RENAME PageTypeComposerControlTypes;
ALTER TABLE pagetypecomposerformlayoutsetcontrols RENAME PageTypeComposerFormLayoutSetControls;
ALTER TABLE pagetypecomposerformlayoutsets RENAME PageTypeComposerFormLayoutSets;
ALTER TABLE pagetypecomposeroutputblocks RENAME PageTypeComposerOutputBlocks;
ALTER TABLE pagetypecomposeroutputcontrols RENAME PageTypeComposerOutputControls;
ALTER TABLE pagetypepagetemplatedefaultpages RENAME PageTypePageTemplateDefaultPages;
ALTER TABLE pagetypepagetemplates RENAME PageTypePageTemplates;
ALTER TABLE pagetypepermissionassignments RENAME PageTypePermissionAssignments;
ALTER TABLE pagetypepublishtargettypes RENAME PageTypePublishTargetTypes;
ALTER TABLE pagetypes RENAME PageTypes;
ALTER TABLE pageworkflowprogress RENAME PageWorkflowProgress;
ALTER TABLE pages RENAME Pages;
ALTER TABLE permissionaccess RENAME PermissionAccess;
ALTER TABLE permissionaccessentities RENAME PermissionAccessEntities;
ALTER TABLE permissionaccessentitygroupsets RENAME PermissionAccessEntityGroupSets;
ALTER TABLE permissionaccessentitygroups RENAME PermissionAccessEntityGroups;
ALTER TABLE permissionaccessentitytypecategories RENAME PermissionAccessEntityTypeCategories;
ALTER TABLE permissionaccessentitytypes RENAME PermissionAccessEntityTypes;
ALTER TABLE permissionaccessentityusers RENAME PermissionAccessEntityUsers;
ALTER TABLE permissionaccesslist RENAME PermissionAccessList;
ALTER TABLE permissionaccessworkflows RENAME PermissionAccessWorkflows;
ALTER TABLE permissionassignments RENAME PermissionAssignments;
ALTER TABLE permissiondurationobjects RENAME PermissionDurationObjects;
ALTER TABLE permissionkeycategories RENAME PermissionKeyCategories;
ALTER TABLE permissionkeys RENAME PermissionKeys;
ALTER TABLE pilecontents RENAME PileContents;
ALTER TABLE piles RENAME Piles;
ALTER TABLE privatemessagenotifications RENAME PrivateMessageNotifications;
ALTER TABLE queuemessages RENAME QueueMessages;
ALTER TABLE queuepageduplicationrelations RENAME QueuePageDuplicationRelations;
ALTER TABLE queues RENAME Queues;
ALTER TABLE savedfilesearchqueries RENAME SavedFileSearchQueries;
ALTER TABLE savedpagesearchqueries RENAME SavedPageSearchQueries;
ALTER TABLE savedusersearchqueries RENAME SavedUserSearchQueries;
ALTER TABLE sessions RENAME Sessions;
ALTER TABLE siblingpagerelations RENAME SiblingPageRelations;
ALTER TABLE signuprequests RENAME SignupRequests;
ALTER TABLE siteattributekeys RENAME SiteAttributeKeys;
ALTER TABLE siteattributevalues RENAME SiteAttributeValues;
ALTER TABLE sitelocales RENAME SiteLocales;
ALTER TABLE sitesearchindexattributes RENAME SiteSearchIndexAttributes;
ALTER TABLE sitetreetrees RENAME SiteTreeTrees;
ALTER TABLE sitetrees RENAME SiteTrees;
ALTER TABLE sitetypes RENAME SiteTypes;
ALTER TABLE sites RENAME Sites;
ALTER TABLE sociallinks RENAME SocialLinks;
ALTER TABLE stackusagerecord RENAME StackUsageRecord;
ALTER TABLE stacks RENAME Stacks;
ALTER TABLE stylecustomizercustomcssrecords RENAME StyleCustomizerCustomCssRecords;
ALTER TABLE stylecustomizerinlinestylepresets RENAME StyleCustomizerInlineStylePresets;
ALTER TABLE stylecustomizerinlinestylesets RENAME StyleCustomizerInlineStyleSets;
ALTER TABLE stylecustomizervaluelists RENAME StyleCustomizerValueLists;
ALTER TABLE stylecustomizervalues RENAME StyleCustomizerValues;
ALTER TABLE systemantispamlibraries RENAME SystemAntispamLibraries;
ALTER TABLE systemcaptchalibraries RENAME SystemCaptchaLibraries;
ALTER TABLE systemcontenteditorsnippets RENAME SystemContentEditorSnippets;
ALTER TABLE systemdatabasemigrations RENAME SystemDatabaseMigrations;
ALTER TABLE systemdatabasequerylog RENAME SystemDatabaseQueryLog;
ALTER TABLE topictrees RENAME TopicTrees;
ALTER TABLE treefilenodes RENAME TreeFileNodes;
ALTER TABLE treegroupnodes RENAME TreeGroupNodes;
ALTER TABLE treenodepermissionassignments RENAME TreeNodePermissionAssignments;
ALTER TABLE treenodetypes RENAME TreeNodeTypes;
ALTER TABLE treenodes RENAME TreeNodes;
ALTER TABLE treesearchquerynodes RENAME TreeSearchQueryNodes;
ALTER TABLE treetypes RENAME TreeTypes;
ALTER TABLE trees RENAME Trees;
ALTER TABLE userattributekeys RENAME UserAttributeKeys;
ALTER TABLE userattributevalues RENAME UserAttributeValues;
ALTER TABLE userbannedips RENAME UserBannedIPs;
ALTER TABLE usergroups RENAME UserGroups;
ALTER TABLE userpermissioneditpropertyaccesslist RENAME UserPermissionEditPropertyAccessList;
ALTER TABLE userpermissioneditpropertyattributeaccesslistcustom RENAME UserPermissionEditPropertyAttributeAccessListCustom;
ALTER TABLE userpermissionviewattributeaccesslist RENAME UserPermissionViewAttributeAccessList;
ALTER TABLE userpermissionviewattributeaccesslistcustom RENAME UserPermissionViewAttributeAccessListCustom;
ALTER TABLE userpointactions RENAME UserPointActions;
ALTER TABLE userpointhistory RENAME UserPointHistory;
ALTER TABLE userprivatemessages RENAME UserPrivateMessages;
ALTER TABLE userprivatemessagesto RENAME UserPrivateMessagesTo;
ALTER TABLE usersearchindexattributes RENAME UserSearchIndexAttributes;
ALTER TABLE usersignupnotifications RENAME UserSignupNotifications;
ALTER TABLE usersignups RENAME UserSignups;
ALTER TABLE uservalidationhashes RENAME UserValidationHashes;
ALTER TABLE userworkflowprogress RENAME UserWorkflowProgress;
ALTER TABLE users RENAME Users;
ALTER TABLE workflowprogress RENAME WorkflowProgress;
ALTER TABLE workflowprogresscategories RENAME WorkflowProgressCategories;
ALTER TABLE workflowprogresshistory RENAME WorkflowProgressHistory;
ALTER TABLE workflowprogressnotifications RENAME WorkflowProgressNotifications;
ALTER TABLE workflowrequestobjects RENAME WorkflowRequestObjects;
ALTER TABLE workflowtypes RENAME WorkflowTypes;
ALTER TABLE workflows RENAME Workflows;
ALTER TABLE ataddress RENAME atAddress;
ALTER TABLE ataddresssettings RENAME atAddressSettings;
ALTER TABLE atboolean RENAME atBoolean;
ALTER TABLE atbooleansettings RENAME atBooleanSettings;
ALTER TABLE atdatetime RENAME atDateTime;
ALTER TABLE atdatetimesettings RENAME atDateTimeSettings;
ALTER TABLE atdefault RENAME atDefault;
ALTER TABLE atemptysettings RENAME atEmptySettings;
ALTER TABLE atexpress RENAME atExpress;
ALTER TABLE atexpressselectedentries RENAME atExpressSelectedEntries;
ALTER TABLE atexpresssettings RENAME atExpressSettings;
ALTER TABLE atfile RENAME atFile;
ALTER TABLE atfilesettings RENAME atFileSettings;
ALTER TABLE atnumber RENAME atNumber;
ALTER TABLE atselect RENAME atSelect;
ALTER TABLE atselectoptionlists RENAME atSelectOptionLists;
ALTER TABLE atselectoptions RENAME atSelectOptions;
ALTER TABLE atselectoptionsselected RENAME atSelectOptionsSelected;
ALTER TABLE atselectsettings RENAME atSelectSettings;
ALTER TABLE atselectedsociallinks RENAME atSelectedSocialLinks;
ALTER TABLE atselectedtopics RENAME atSelectedTopics;
ALTER TABLE atsociallinks RENAME atSocialLinks;
ALTER TABLE attextsettings RENAME atTextSettings;
ALTER TABLE attextareasettings RENAME atTextareaSettings;
ALTER TABLE attopic RENAME atTopic;
ALTER TABLE attopicsettings RENAME atTopicSettings;
ALTER TABLE authtypeconcretecookiemap RENAME authTypeConcreteCookieMap;
ALTER TABLE btcontentfile RENAME btContentFile;
ALTER TABLE btcontentimage RENAME btContentImage;
ALTER TABLE btcontentlocal RENAME btContentLocal;
ALTER TABLE btcorearealayout RENAME btCoreAreaLayout;
ALTER TABLE btcoreconversation RENAME btCoreConversation;
ALTER TABLE btcorepagetypecomposercontroloutput RENAME btCorePageTypeComposerControlOutput;
ALTER TABLE btcorescrapbookdisplay RENAME btCoreScrapbookDisplay;
ALTER TABLE btcorestackdisplay RENAME btCoreStackDisplay;
ALTER TABLE btdatenavigation RENAME btDateNavigation;
ALTER TABLE btdesktopnewsflowlatest RENAME btDesktopNewsflowLatest;
ALTER TABLE btdesktopsiteactivity RENAME btDesktopSiteActivity;
ALTER TABLE btexpressentrydetail RENAME btExpressEntryDetail;
ALTER TABLE btexpressentrylist RENAME btExpressEntryList;
ALTER TABLE btexpressform RENAME btExpressForm;
ALTER TABLE btexternalform RENAME btExternalForm;
ALTER TABLE btfaq RENAME btFaq;
ALTER TABLE btfaqentries RENAME btFaqEntries;
ALTER TABLE btfeature RENAME btFeature;
ALTER TABLE btform RENAME btForm;
ALTER TABLE btformanswerset RENAME btFormAnswerSet;
ALTER TABLE btformanswers RENAME btFormAnswers;
ALTER TABLE btformquestions RENAME btFormQuestions;
ALTER TABLE btgooglemap RENAME btGoogleMap;
ALTER TABLE btimageslider RENAME btImageSlider;
ALTER TABLE btimagesliderentries RENAME btImageSliderEntries;
ALTER TABLE btnavigation RENAME btNavigation;
ALTER TABLE btnextprevious RENAME btNextPrevious;
ALTER TABLE btpageattributedisplay RENAME btPageAttributeDisplay;
ALTER TABLE btpagelist RENAME btPageList;
ALTER TABLE btpagetitle RENAME btPageTitle;
ALTER TABLE btrssdisplay RENAME btRssDisplay;
ALTER TABLE btsearch RENAME btSearch;
ALTER TABLE btsharethispage RENAME btShareThisPage;
ALTER TABLE btsociallinks RENAME btSocialLinks;
ALTER TABLE btsurvey RENAME btSurvey;
ALTER TABLE btsurveyoptions RENAME btSurveyOptions;
ALTER TABLE btsurveyresults RENAME btSurveyResults;
ALTER TABLE btswitchlanguage RENAME btSwitchLanguage;
ALTER TABLE bttags RENAME btTags;
ALTER TABLE bttestimonial RENAME btTestimonial;
ALTER TABLE bttopiclist RENAME btTopicList;
ALTER TABLE btvideo RENAME btVideo;
ALTER TABLE btyoutube RENAME btYouTube;
ALTER TABLE gapage RENAME gaPage;

craveitla replied on Dec 16, 2016 at 9:16 am Permalink Reply

In case someone needs a new table list. Here is the codehttps://gist.github.com/jian118/cfc413a090523d0c4308b6b9e20217df...

Forums

(OLD 5.7 Discussion FORUM)

Database Error moving from dev server to live server

Code

Post Reply

Delete Post

Mark Post as Spam

Destroy Spammer

Sign In?