SQL For renaming Liferay tables to mixed case.

rename.sql

RENAME TABLE account_ TO Account_;
RENAME TABLE address TO Address;
RENAME TABLE announcementsdelivery TO AnnouncementsDelivery;
RENAME TABLE announcementsentry TO AnnouncementsEntry;
RENAME TABLE announcementsflag TO AnnouncementsFlag;
RENAME TABLE assetcategory TO AssetCategory;
RENAME TABLE assetcategoryproperty TO AssetCategoryProperty;
RENAME TABLE assetentries_assetcategories TO AssetEntries_AssetCategories;
RENAME TABLE assetentries_assettags TO AssetEntries_AssetTags;
RENAME TABLE assetentry TO AssetEntry;
RENAME TABLE assetlink TO AssetLink;
RENAME TABLE assettag TO AssetTag;
RENAME TABLE assettagstats TO AssetTagStats;
RENAME TABLE assetvocabulary TO AssetVocabulary;
RENAME TABLE audit_auditevent TO Audit_AuditEvent;
RENAME TABLE backgroundtask TO BackgroundTask;
RENAME TABLE blogsentry TO BlogsEntry;
RENAME TABLE blogsstatsuser TO BlogsStatsUser;
RENAME TABLE browsertracker TO BrowserTracker;
RENAME TABLE calendar TO Calendar;
RENAME TABLE calendarbooking TO CalendarBooking;
RENAME TABLE calendarnotificationtemplate TO CalendarNotificationTemplate;
RENAME TABLE calendarresource TO CalendarResource;
RENAME TABLE classname_ TO ClassName_;
RENAME TABLE clustergroup TO ClusterGroup;
RENAME TABLE company TO Company;
RENAME TABLE configuration_ TO Configuration_;
RENAME TABLE contact_ TO Contact_;
RENAME TABLE contacts_entry TO Contacts_Entry;
RENAME TABLE counter TO Counter;
RENAME TABLE country TO Country;
RENAME TABLE ddlrecord TO DDLRecord;
RENAME TABLE ddlrecordset TO DDLRecordSet;
RENAME TABLE ddlrecordversion TO DDLRecordVersion;
RENAME TABLE ddmcontent TO DDMContent;
RENAME TABLE ddmdataproviderinstance TO DDMDataProviderInstance;
RENAME TABLE ddmdataproviderinstancelink TO DDMDataProviderInstanceLink;
RENAME TABLE ddmstoragelink TO DDMStorageLink;
RENAME TABLE ddmstructure TO DDMStructure;
RENAME TABLE ddmstructurelayout TO DDMStructureLayout;
RENAME TABLE ddmstructurelink TO DDMStructureLink;
RENAME TABLE ddmstructureversion TO DDMStructureVersion;
RENAME TABLE ddmtemplate TO DDMTemplate;
RENAME TABLE ddmtemplatelink TO DDMTemplateLink;
RENAME TABLE ddmtemplateversion TO DDMTemplateVersion;
RENAME TABLE dlcontent TO DLContent;
RENAME TABLE dlfileentry TO DLFileEntry;
RENAME TABLE dlfileentrymetadata TO DLFileEntryMetadata;
RENAME TABLE dlfileentrytype TO DLFileEntryType;
RENAME TABLE dlfileentrytypes_dlfolders TO DLFileEntryTypes_DLFolders;
RENAME TABLE dlfilerank TO DLFileRank;
RENAME TABLE dlfileshortcut TO DLFileShortcut;
RENAME TABLE dlfileversion TO DLFileVersion;
RENAME TABLE dlfolder TO DLFolder;
RENAME TABLE dlsyncevent TO DLSyncEvent;
RENAME TABLE emailaddress TO EmailAddress;
RENAME TABLE expandocolumn TO ExpandoColumn;
RENAME TABLE expandorow TO ExpandoRow;
RENAME TABLE expandotable TO ExpandoTable;
RENAME TABLE expandovalue TO ExpandoValue;
RENAME TABLE exportimportconfiguration TO ExportImportConfiguration;
RENAME TABLE group_ TO Group_;
RENAME TABLE groups_orgs TO Groups_Orgs;
RENAME TABLE groups_roles TO Groups_Roles;
RENAME TABLE groups_usergroups TO Groups_UserGroups;
RENAME TABLE im_memberrequest TO IM_MemberRequest;
RENAME TABLE image TO Image;
RENAME TABLE journalarticle TO JournalArticle;
RENAME TABLE journalarticleresource TO JournalArticleResource;
RENAME TABLE journalcontentsearch TO JournalContentSearch;
RENAME TABLE journalfeed TO JournalFeed;
RENAME TABLE journalfolder TO JournalFolder;
RENAME TABLE kaleoaction TO KaleoAction;
RENAME TABLE kaleocondition TO KaleoCondition;
RENAME TABLE kaleodefinition TO KaleoDefinition;
RENAME TABLE kaleoinstance TO KaleoInstance;
RENAME TABLE kaleoinstancetoken TO KaleoInstanceToken;
RENAME TABLE kaleolog TO KaleoLog;
RENAME TABLE kaleonode TO KaleoNode;
RENAME TABLE kaleonotification TO KaleoNotification;
RENAME TABLE kaleonotificationrecipient TO KaleoNotificationRecipient;
RENAME TABLE kaleoprocess TO KaleoProcess;
RENAME TABLE kaleoprocesslink TO KaleoProcessLink;
RENAME TABLE kaleotask TO KaleoTask;
RENAME TABLE kaleotaskassignment TO KaleoTaskAssignment;
RENAME TABLE kaleotaskassignmentinstance TO KaleoTaskAssignmentInstance;
RENAME TABLE kaleotaskinstancetoken TO KaleoTaskInstanceToken;
RENAME TABLE kaleotimer TO KaleoTimer;
RENAME TABLE kaleotimerinstancetoken TO KaleoTimerInstanceToken;
RENAME TABLE kaleotransition TO KaleoTransition;
RENAME TABLE layout TO Layout;
RENAME TABLE layoutbranch TO LayoutBranch;
RENAME TABLE layoutfriendlyurl TO LayoutFriendlyURL;
RENAME TABLE layoutprototype TO LayoutPrototype;
RENAME TABLE layoutrevision TO LayoutRevision;
RENAME TABLE layoutset TO LayoutSet;
RENAME TABLE layoutsetbranch TO LayoutSetBranch;
RENAME TABLE layoutsetprototype TO LayoutSetPrototype;
RENAME TABLE listtype TO ListType;
RENAME TABLE lock_ TO Lock_;
RENAME TABLE mbban TO MBBan;
RENAME TABLE mbcategory TO MBCategory;
RENAME TABLE mbdiscussion TO MBDiscussion;
RENAME TABLE mbmailinglist TO MBMailingList;
RENAME TABLE mbmessage TO MBMessage;
RENAME TABLE mbstatsuser TO MBStatsUser;
RENAME TABLE mbthread TO MBThread;
RENAME TABLE mbthreadflag TO MBThreadFlag;
RENAME TABLE mdraction TO MDRAction;
RENAME TABLE mdrrule TO MDRRule;
RENAME TABLE mdrrulegroup TO MDRRuleGroup;
RENAME TABLE mdrrulegroupinstance TO MDRRuleGroupInstance;
RENAME TABLE marketplace_app TO Marketplace_App;
RENAME TABLE marketplace_module TO Marketplace_Module;
RENAME TABLE membershiprequest TO MembershipRequest;
RENAME TABLE orggrouprole TO OrgGroupRole;
RENAME TABLE orglabor TO OrgLabor;
RENAME TABLE organization_ TO Organization_;
RENAME TABLE passwordpolicy TO PasswordPolicy;
RENAME TABLE passwordpolicyrel TO PasswordPolicyRel;
RENAME TABLE passwordtracker TO PasswordTracker;
RENAME TABLE phone TO Phone;
RENAME TABLE pluginsetting TO PluginSetting;
RENAME TABLE pollschoice TO PollsChoice;
RENAME TABLE pollsquestion TO PollsQuestion;
RENAME TABLE pollsvote TO PollsVote;
RENAME TABLE portalpreferences TO PortalPreferences;
RENAME TABLE portlet TO Portlet;
RENAME TABLE portletitem TO PortletItem;
RENAME TABLE portletpreferences TO PortletPreferences;
RENAME TABLE quartz_blob_triggers TO QUARTZ_BLOB_TRIGGERS;
RENAME TABLE quartz_calendars TO QUARTZ_CALENDARS;
RENAME TABLE quartz_cron_triggers TO QUARTZ_CRON_TRIGGERS;
RENAME TABLE quartz_fired_triggers TO QUARTZ_FIRED_TRIGGERS;
RENAME TABLE quartz_job_details TO QUARTZ_JOB_DETAILS;
RENAME TABLE quartz_locks TO QUARTZ_LOCKS;
RENAME TABLE quartz_paused_trigger_grps TO QUARTZ_PAUSED_TRIGGER_GRPS;
RENAME TABLE quartz_scheduler_state TO QUARTZ_SCHEDULER_STATE;
RENAME TABLE quartz_simple_triggers TO QUARTZ_SIMPLE_TRIGGERS;
RENAME TABLE quartz_simprop_triggers TO QUARTZ_SIMPROP_TRIGGERS;
RENAME TABLE quartz_triggers TO QUARTZ_TRIGGERS;
RENAME TABLE ratingsentry TO RatingsEntry;
RENAME TABLE ratingsstats TO RatingsStats;
RENAME TABLE recentlayoutbranch TO RecentLayoutBranch;
RENAME TABLE recentlayoutrevision TO RecentLayoutRevision;
RENAME TABLE recentlayoutsetbranch TO RecentLayoutSetBranch;
RENAME TABLE region TO Region;
RENAME TABLE release_ TO Release_;
RENAME TABLE repository TO Repository;
RENAME TABLE repositoryentry TO RepositoryEntry;
RENAME TABLE resourceaction TO ResourceAction;
RENAME TABLE resourceblock TO ResourceBlock;
RENAME TABLE resourceblockpermission TO ResourceBlockPermission;
RENAME TABLE resourcepermission TO ResourcePermission;
RENAME TABLE resourcetypepermission TO ResourceTypePermission;
RENAME TABLE role_ TO Role_;
RENAME TABLE sapentry TO SAPEntry;
RENAME TABLE servicecomponent TO ServiceComponent;
RENAME TABLE socialactivity TO SocialActivity;
RENAME TABLE socialactivityachievement TO SocialActivityAchievement;
RENAME TABLE socialactivitycounter TO SocialActivityCounter;
RENAME TABLE socialactivitylimit TO SocialActivityLimit;
RENAME TABLE socialactivityset TO SocialActivitySet;
RENAME TABLE socialactivitysetting TO SocialActivitySetting;
RENAME TABLE socialrelation TO SocialRelation;
RENAME TABLE socialrequest TO SocialRequest;
RENAME TABLE subscription TO Subscription;
RENAME TABLE systemevent TO SystemEvent;
RENAME TABLE team TO Team;
RENAME TABLE ticket TO Ticket;
RENAME TABLE trashentry TO TrashEntry;
RENAME TABLE trashversion TO TrashVersion;
RENAME TABLE usergroup TO UserGroup;
RENAME TABLE usergroupgrouprole TO UserGroupGroupRole;
RENAME TABLE usergrouprole TO UserGroupRole;
RENAME TABLE usergroups_teams TO UserGroups_Teams;
RENAME TABLE useridmapper TO UserIdMapper;
RENAME TABLE usernotificationdelivery TO UserNotificationDelivery;
RENAME TABLE usernotificationevent TO UserNotificationEvent;
RENAME TABLE usertracker TO UserTracker;
RENAME TABLE usertrackerpath TO UserTrackerPath;
RENAME TABLE user_ TO User_;
RENAME TABLE users_groups TO Users_Groups;
RENAME TABLE users_orgs TO Users_Orgs;
RENAME TABLE users_roles TO Users_Roles;
RENAME TABLE users_teams TO Users_Teams;
RENAME TABLE users_usergroups TO Users_UserGroups;
RENAME TABLE virtualhost TO VirtualHost;
RENAME TABLE webdavprops TO WebDAVProps;
RENAME TABLE website TO Website;
RENAME TABLE wikinode TO WikiNode;
RENAME TABLE wikipage TO WikiPage;
RENAME TABLE wikipageresource TO WikiPageResource;
RENAME TABLE workflowdefinitionlink TO WorkflowDefinitionLink;
RENAME TABLE workflowinstancelink TO WorkflowInstanceLink;
RENAME TABLE bookmarksentry TO BookmarksEntry;
RENAME TABLE bookmarksfolder TO BookmarksFolder;
RENAME TABLE journalarticleimage TO JournalArticleImage;
RENAME TABLE kaleodraftdefinition TO KaleoDraftDefinition;
RENAME TABLE microblogsentry TO MicroblogsEntry;
RENAME TABLE oauth_oauthapplication TO OAuth_OAuthApplication;
RENAME TABLE oauth_oauthuser TO OAuth_OAuthUser;
RENAME TABLE syncdevice TO SyncDevice;
RENAME TABLE syncdlfileversiondiff TO SyncDLFileVersionDiff;
RENAME TABLE syncdlobject TO SyncDLObject;