View source for Migration from 5.0-Beta to 5.0-RC1

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

<source lang="sql">
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;
</source>