Migration from 5.0-Beta to 5.0-RC1

From OpenKM Documentation
Revision as of 13:13, 14 January 2011 by Jllort (talk | contribs)

Jump to: navigation, search

Some table columns have been shorten due to Oracle 30 chars entity limit. This SQL script will change the columns to the new names: 

alter table OKM_PROFILE change PRF_MISC_ADVANCED_FILTERS PRF_MSC_ADVANCED_FILTERS bit(1) DEFAULT 0;
alter table OKM_PROFILE change PRF_MISC_USER_QUOTA PRF_MSC_USER_QUOTA bigint(20) DEFAULT '0';
alter table OKM_PROFILE change PRF_MISC_WEB_SKIN PRF_MSC_WEB_SKIN varchar(255) DEFAULT 'default';
alter table OKM_PROFILE change PRF_CHAT_CHAT_ENABLED PRF_CHT_CHAT_EN bit(1) DEFAULT 0;
alter table OKM_PROFILE change PRF_CHAT_AUTO_LOGIN_ENABLED PRF_CHT_AUTO_LOGIN_EN bit(1) DEFAULT 0;
alter table OKM_PROFILE change PRF_WIZARD_PROPERTY_GROUPS PRF_WZRD_PROPERTY_GROUPS varchar(255) ;
alter table OKM_PROFILE change PRF_WIZARD_WORKFLOWS PRF_WZRD_WORKFLOWS varchar(255);
alter table OKM_PROFILE change PRF_WIZARD_KEYWORDS_ENABLED PRF_WZRD_KEYWORDS_EN bit(1) DEFAULT 0;
alter table OKM_PROFILE change PRF_WIZARD_CATEGORIES_ENABLED PRF_WZRD_CATEGORIES_EN bit(1) DEFAULT 0;
alter table OKM_PROFILE change PRF_STACK_TAXONOMY_VISIBLE PRF_STCK_TAXONOMY_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_STACK_CATEGORIES_VISIBLE PRF_STCK_CATEGORIES_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_STACK_THESAURUS_VISIBLE PRF_STCK_THESAURUS_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_STACK_TEMPLATES_VISIBLE PRF_STCK_TEMPLATES_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_STACK_PERSONAL_VISIBLE PRF_STCK_PERSONAL_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_STACK_MAIL_VISIBLE PRF_STCK_MAIL_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_STACK_TRASH_VISIBLE PRF_STCK_TRASH_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_TAB_DESKTOP_VISIBLE PRF_TB_DESKTOP_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_TAB_SEARCH_VISIBLE PRF_TB_SEARCH_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_TAB_DASHBOARD_VISIBLE PRF_TB_DASHBOARD_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_TAB_ADMINISTRATION_VISIBLE PRF_TB_ADMIN_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_TAB_DOCUMENT_PROPERTIES_VISIBLE PRF_TB_DOC_PROPS_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_TAB_DOCUMENT_SECURITY_VISIBLE PRF_TB_DOC_SECURITY_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_TAB_DOCUMENT_NOTES_VISIBLE PRF_TB_DOC_NOTES_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_TAB_DOCUMENT_VERSIONS_VISIBLE PRF_TB_DOC_VERSIONS_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_TAB_DOCUMENT_PREVIEW_VISIBLE PRF_TB_DOC_PREVIEW_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_TAB_DOCUMENT_PROPERTY_GROUPS_VISIBLE PRF_TB_DOC_PROP_GRPS_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_TAB_FOLDER_PROPERTIES_VISIBLE PRF_TB_FLD_PROPS_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_TAB_FOLDER_SECURITY_VISIBLE PRF_TB_FLD_SECURITY_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_TAB_FOLDER_NOTES_VISIBLE PRF_TB_FLD_NOTES_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_TAB_MAIL_PROPERTIES_VISIBLE PRF_TB_ML_PROPS_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_TAB_MAIL_SECURITY_VISIBLE PRF_TB_ML_SECURITY_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_DASHBOARD_USER_VISIBLE PRF_DB_USER_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_DASHBOARD_MAIL_VISIBLE PRF_DB_MAIL_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_DASHBOARD_NEWS_VISIBLE PRF_DB_NEWS_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_DASHBOARD_GENERAL_VISIBLE PRF_DB_GENERAL_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_DASHBOARD_WORKFLOW_VISIBLE PRF_DB_WORKFLOW_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_DASHBOARD_KEYWORDS_VISIBLE PRF_DB_KEYWORDS_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_MENU_FILE_VISIBLE PRF_MN_FILE_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_MENU_EDIT_VISIBLE PRF_MN_EDIT_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_MENU_TOOLS_VISIBLE PRF_MN_TOOLS_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_MENU_BOOKMARKS_VISIBLE PRF_MN_BOOKMARKS_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_MENU_HELP_VISIBLE PRF_MN_HELP_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_MENU_FILE_CREATE_FOLDER_VISIBLE PRF_MN_FI_CREATE_FLD_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_MENU_FILE_FIND_FOLDER_VISIBLE PRF_MN_FI_FIND_FLD_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_MENU_FILE_GO_FOLDER_VISIBLE PRF_MN_FI_GO_FLD_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_MENU_FILE_DOWNLOAD_VISIBLE PRF_MN_FI_DOWNLOAD_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_MENU_FILE_DOWNLOAD_PDF_VISIBLE PRF_MN_FI_DOWNLOAD_PDF_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_MENU_FILE_ADD_DOCUMENT_VISIBLE PRF_MN_FI_ADD_DOC_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_MENU_FILE_START_WORKFLOW_VISIBLE PRF_MN_FI_START_WORKFLOW_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_MENU_FILE_REFRESH_VISIBLE PRF_MN_FI_REFRESH_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_MENU_FILE_SCANNER_VISIBLE PRF_MN_FI_SCANNER_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_MENU_FILE_UPLOADER_VISIBLE PRF_MN_FI_UPLOADER_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_MENU_FILE_PURGE_VISIBLE PRF_MN_FI_PURGE_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_MENU_FILE_PURGE_TRASH_VISIBLE PRF_MN_FI_PURGE_TRASH_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_MENU_FILE_RESTORE_VISIBLE PRF_MN_FI_RESTORE_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_MENU_FILE_EXPORT_VISIBLE PRF_MN_FI_EXPORT_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_MENU_FILE_CREATE_FROM_TEMPLATE_VISIBLE PRF_MN_FI_CREATE_FROM_TPL_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_MENU_FILE_SEND_DOCUMENT_LINK_VISIBLE PRF_MN_FI_SEND_DOC_LINK_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_MENU_FILE_SEND_DOCUMENT_ATTACHMENT_VISIBLE PRF_MN_FI_SEND_DOC_ATTACH_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_MENU_EDIT_LOCK_VISIBLE PRF_MN_ED_LOCK_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_MENU_EDIT_UNLOCK_VISIBLE PRF_MN_ED_UNLOCK_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_MENU_EDIT_CHECK_IN_VISIBLE PRF_MN_ED_CIN_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_MENU_EDIT_CHECK_OUT_VISIBLE PRF_MN_ED_COUT_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_MENU_EDIT_CANCEL_CHECK_OUT_VISIBLE PRF_MN_ED_CANCEL_COUT_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_MENU_EDIT_DELETE_VISIBLE PRF_MN_ED_DELETE_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_MENU_EDIT_RENAME_VISIBLE PRF_MN_ED_RENAME_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_MENU_EDIT_COPY_VISIBLE PRF_MN_ED_COPY_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_MENU_EDIT_MOVE_VISIBLE PRF_MN_ED_MOVE_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_MENU_EDIT_ADD_PROPERTY_GROUP_VISIBLE PRF_MN_ED_ADD_PROP_GRP_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_MENU_EDIT_REMOVE_PROPERTY_GROUP_VISIBLE PRF_MN_ED_REM_PROP_GRP_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_MENU_EDIT_ADD_SUBSCRIPTION_VISIBLE PRF_MN_ED_ADD_SUBS_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_MENU_EDIT_REMOVE_SUBSCRIPTION_VISIBLE PRF_MN_ED_REM_SUBS_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_MENU_BOOKMARK_MANAGE_BOOKMARKS_VISIBLE PRF_MN_BM_MNG_BOOKMARKS_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_MENU_BOOKMARK_ADD_BOOKMARK_VISIBLE PRF_MN_BM_ADD_BOOKMARK_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_MENU_BOOKMARK_SET_HOME_VISIBLE PRF_MN_BM_SET_HOME_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_MENU_BOOKMARK_GO_HOME_VISIBLE PRF_MN_BM_GO_HOME_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_MENU_TOOL_LANGUAGES_VISIBLE PRF_MN_TL_LANGS_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_MENU_TOOL_SKIN_VISIBLE PRF_MN_TL_SKIN_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_MENU_TOOL_DEBUG_VISIBLE PRF_MN_TL_DEBUG_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_MENU_TOOL_ADMINISTRATION_VISIBLE PRF_MN_TL_ADMIN_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_MENU_TOOL_PREFERENCES_VISIBLE PRF_MN_TL_PREFS_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_MENU_HELP_DOCUMENTATION_VISIBLE PRF_MN_HLP_DOC_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_MENU_HELP_BUG_TRACKING_VISIBLE PRF_MN_HLP_BUG_TRACKING_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_MENU_HELP_SUPPORT_VISIBLE PRF_MN_HLP_SUPPORT_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_MENU_HELP_FORUM_VISIBLE PRF_MN_HLP_FORUM_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_MENU_HELP_CHANGELOG_VISIBLE PRF_MN_HLP_CHANGELOG_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_MENU_HELP_WEB_SITE_VISIBLE PRF_MN_HLP_WEB_SITE_VIS bit(1) DEFAULT 1;
alter table OKM_PROFILE change PRF_MENU_HELP_ABOUT_VISIBLE PRF_MNU_HLP_ABOUT_VIS bit(1) DEFAULT 1;

Microsoft SQL Server

exec sp_rename @objname='OKM_PROFILE.PRF_MISC_ADVANCED_FILTERS', @newname='PRF_MSC_ADVANCED_FILTERS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_MISC_USER_QUOTA', @newname='PRF_MSC_USER_QUOTA', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_MISC_WEB_SKIN', @newname='PRF_MSC_WEB_SKIN', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_CHAT_CHAT_ENABLED', @newname='PRF_CHT_CHAT_EN', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_CHAT_AUTO_LOGIN_ENABLED', @newname='PRF_CHT_AUTO_LOGIN_EN', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_WIZARD_PROPERTY_GROUPS', @newname='PRF_WZRD_PROPERTY_GROUPS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_WIZARD_WORKFLOWS', @newname='PRF_WZRD_WORKFLOWS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_WIZARD_KEYWORDS_ENABLED', @newname='PRF_WZRD_KEYWORDS_EN', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_WIZARD_CATEGORIES_ENABLED', @newname='PRF_WZRD_CATEGORIES_EN', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_STACK_TAXONOMY_VISIBLE', @newname='PRF_STCK_TAXONOMY_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_STACK_CATEGORIES_VISIBLE', @newname='PRF_STCK_CATEGORIES_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_STACK_THESAURUS_VISIBLE', @newname='PRF_STCK_THESAURUS_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_STACK_TEMPLATES_VISIBLE', @newname='PRF_STCK_TEMPLATES_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_STACK_PERSONAL_VISIBLE', @newname='PRF_STCK_PERSONAL_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_STACK_MAIL_VISIBLE', @newname='PRF_STCK_MAIL_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_STACK_TRASH_VISIBLE', @newname='PRF_STCK_TRASH_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_TAB_DESKTOP_VISIBLE', @newname='PRF_TB_DESKTOP_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_TAB_SEARCH_VISIBLE', @newname='PRF_TB_SEARCH_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_TAB_DASHBOARD_VISIBLE', @newname='PRF_TB_DASHBOARD_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_TAB_ADMINISTRATION_VISIBLE', @newname='PRF_TB_ADMIN_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_TAB_DOCUMENT_PROPERTIES_VISIBLE', @newname='PRF_TB_DOC_PROPS_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_TAB_DOCUMENT_SECURITY_VISIBLE', @newname='PRF_TB_DOC_SECURITY_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_TAB_DOCUMENT_NOTES_VISIBLE', @newname='PRF_TB_DOC_NOTES_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_TAB_DOCUMENT_VERSIONS_VISIBLE', @newname='PRF_TB_DOC_VERSIONS_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_TAB_DOCUMENT_PREVIEW_VISIBLE', @newname='PRF_TB_DOC_PREVIEW_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_TAB_DOCUMENT_PROPERTY_GROUPS_VISIBLE', @newname='PRF_TB_DOC_PROP_GRPS_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_TAB_FOLDER_PROPERTIES_VISIBLE', @newname='PRF_TB_FLD_PROPS_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_TAB_FOLDER_SECURITY_VISIBLE', @newname='PRF_TB_FLD_SECURITY_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_TAB_FOLDER_NOTES_VISIBLE', @newname='PRF_TB_FLD_NOTES_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_TAB_MAIL_PROPERTIES_VISIBLE', @newname='PRF_TB_ML_PROPS_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_TAB_MAIL_SECURITY_VISIBLE', @newname='PRF_TB_ML_SECURITY_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_DASHBOARD_USER_VISIBLE', @newname='PRF_DB_USER_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_DASHBOARD_MAIL_VISIBLE', @newname='PRF_DB_MAIL_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_DASHBOARD_NEWS_VISIBLE', @newname='PRF_DB_NEWS_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_DASHBOARD_GENERAL_VISIBLE', @newname='PRF_DB_GENERAL_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_DASHBOARD_WORKFLOW_VISIBLE', @newname='PRF_DB_WORKFLOW_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_DASHBOARD_KEYWORDS_VISIBLE', @newname='PRF_DB_KEYWORDS_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_MENU_FILE_VISIBLE', @newname='PRF_MN_FILE_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_MENU_EDIT_VISIBLE', @newname='PRF_MN_EDIT_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_MENU_TOOLS_VISIBLE', @newname='PRF_MN_TOOLS_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_MENU_BOOKMARKS_VISIBLE', @newname='PRF_MN_BOOKMARKS_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_MENU_HELP_VISIBLE', @newname='PRF_MN_HELP_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_MENU_FILE_CREATE_FOLDER_VISIBLE', @newname='PRF_MN_FI_CREATE_FLD_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_MENU_FILE_FIND_FOLDER_VISIBLE', @newname='PRF_MN_FI_FIND_FLD_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_MENU_FILE_GO_FOLDER_VISIBLE', @newname='PRF_MN_FI_GO_FLD_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_MENU_FILE_DOWNLOAD_VISIBLE', @newname='PRF_MN_FI_DOWNLOAD_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_MENU_FILE_DOWNLOAD_PDF_VISIBLE', @newname='PRF_MN_FI_DOWNLOAD_PDF_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_MENU_FILE_ADD_DOCUMENT_VISIBLE', @newname='PRF_MN_FI_ADD_DOC_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_MENU_FILE_START_WORKFLOW_VISIBLE', @newname='PRF_MN_FI_START_WORKFLOW_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_MENU_FILE_REFRESH_VISIBLE', @newname='PRF_MN_FI_REFRESH_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_MENU_FILE_SCANNER_VISIBLE', @newname='PRF_MN_FI_SCANNER_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_MENU_FILE_UPLOADER_VISIBLE', @newname='PRF_MN_FI_UPLOADER_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_MENU_FILE_PURGE_VISIBLE', @newname='PRF_MN_FI_PURGE_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_MENU_FILE_PURGE_TRASH_VISIBLE', @newname='PRF_MN_FI_PURGE_TRASH_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_MENU_FILE_RESTORE_VISIBLE', @newname='PRF_MN_FI_RESTORE_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_MENU_FILE_EXPORT_VISIBLE', @newname='PRF_MN_FI_EXPORT_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_MENU_FILE_CREATE_FROM_TEMPLATE_VISIBLE', @newname='PRF_MN_FI_CREATE_FROM_TPL_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_MENU_FILE_SEND_DOCUMENT_LINK_VISIBLE', @newname='PRF_MN_FI_SEND_DOC_LINK_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_MENU_FILE_SEND_DOCUMENT_ATTACHMENT_VISIBLE', @newname='PRF_MN_FI_SEND_DOC_ATTACH_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_MENU_EDIT_LOCK_VISIBLE', @newname='PRF_MN_ED_LOCK_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_MENU_EDIT_UNLOCK_VISIBLE', @newname='PRF_MN_ED_UNLOCK_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_MENU_EDIT_CHECK_IN_VISIBLE', @newname='PRF_MN_ED_CIN_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_MENU_EDIT_CHECK_OUT_VISIBLE', @newname='PRF_MN_ED_COUT_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_MENU_EDIT_CANCEL_CHECK_OUT_VISIBLE', @newname='PRF_MN_ED_CANCEL_COUT_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_MENU_EDIT_DELETE_VISIBLE', @newname='PRF_MN_ED_DELETE_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_MENU_EDIT_RENAME_VISIBLE', @newname='PRF_MN_ED_RENAME_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_MENU_EDIT_COPY_VISIBLE', @newname='PRF_MN_ED_COPY_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_MENU_EDIT_MOVE_VISIBLE', @newname='PRF_MN_ED_MOVE_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_MENU_EDIT_ADD_PROPERTY_GROUP_VISIBLE', @newname='PRF_MN_ED_ADD_PROP_GRP_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_MENU_EDIT_REMOVE_PROPERTY_GROUP_VISIBLE', @newname='PRF_MN_ED_REM_PROP_GRP_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_MENU_EDIT_ADD_SUBSCRIPTION_VISIBLE', @newname='PRF_MN_ED_ADD_SUBS_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_MENU_EDIT_REMOVE_SUBSCRIPTION_VISIBLE', @newname='PRF_MN_ED_REM_SUBS_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_MENU_BOOKMARK_MANAGE_BOOKMARKS_VISIBLE', @newname='PRF_MN_BM_MNG_BOOKMARKS_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_MENU_BOOKMARK_ADD_BOOKMARK_VISIBLE', @newname='PRF_MN_BM_ADD_BOOKMARK_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_MENU_BOOKMARK_SET_HOME_VISIBLE', @newname='PRF_MN_BM_SET_HOME_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_MENU_BOOKMARK_GO_HOME_VISIBLE', @newname='PRF_MN_BM_GO_HOME_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_MENU_TOOL_LANGUAGES_VISIBLE', @newname='PRF_MN_TL_LANGS_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_MENU_TOOL_SKIN_VISIBLE', @newname='PRF_MN_TL_SKIN_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_MENU_TOOL_DEBUG_VISIBLE', @newname='PRF_MN_TL_DEBUG_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_MENU_TOOL_ADMINISTRATION_VISIBLE', @newname='PRF_MN_TL_ADMIN_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_MENU_TOOL_PREFERENCES_VISIBLE', @newname='PRF_MN_TL_PREFS_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_MENU_HELP_DOCUMENTATION_VISIBLE', @newname='PRF_MN_HLP_DOC_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_MENU_HELP_BUG_TRACKING_VISIBLE', @newname='PRF_MN_HLP_BUG_TRACKING_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_MENU_HELP_SUPPORT_VISIBLE', @newname='PRF_MN_HLP_SUPPORT_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_MENU_HELP_FORUM_VISIBLE', @newname='PRF_MN_HLP_FORUM_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_MENU_HELP_CHANGELOG_VISIBLE', @newname='PRF_MN_HLP_CHANGELOG_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_MENU_HELP_WEB_SITE_VISIBLE', @newname='PRF_MN_HLP_WEB_SITE_VIS', @objtype='COLUMN';
exec sp_rename @objname='OKM_PROFILE.PRF_MENU_HELP_ABOUT_VISIBLE', @newname='PRF_MNU_HLP_ABOUT_VIS', @objtype='COLUMN';
Retrieved from "https://www.openkm.com/wiki/index.php?title=Migration_from_5.0-Beta_to_5.0-RC1&oldid=3447"