login | register
25 Jul 2008 [00:47 UTC]

bitweaver - Web Application Framework and CMS

Web Application Framework and CMS

Refresh cacheHistoryPrint

ReleaseTwoSchemaChangeLog1

part one of the database changes in the R2 branch of bitweaver

Created by: xing,Last modification on 12 Sep 2006 [21:56 UTC]

bitweaver ReleaseTwo Schema changes


This is the first part of the ongoing Schema changes in ReleaseTwo. For more recent changes, please consult SchemaChangeLog

These are ReleaseTwo database changes. DO NOT USE these changes if you are on ReleaseOne. If you need to know the changes for ReleaseOne, see the ReleaseOneSchemaChangelog.

Date
Table
Reason
Who
30-APRIL-2006liberty_content_prefsrename some liberty_content_prefs settings for consistency/xing
SQL 92 
UPDATE liberty_content_prefs SET name='users_country' WHERE name='country';
UPDATE liberty_content_prefs SET name='users_homepage' WHERE name='homePage';
UPDATE liberty_content_prefs SET name='users_double_click' WHERE name='user_dbl';
UPDATE liberty_content_prefs SET name='users_bread_crumb' WHERE name='userbreadCrumb';
UPDATE liberty_content_prefs SET name='users_information' WHERE name='user_information';
UPDATE liberty_content_prefs SET name='users_email_display' WHERE name='email is public';
UPDATE liberty_content_prefs SET name='messages_max_records' WHERE name='mess_max_records';
UPDATE liberty_content_prefs SET name='messages_min_priority' WHERE name='minPrio';
UPDATE liberty_content_prefs SET name='messages_alert' WHERE name='message_alert';
19-APRIL-2006kernel_configmore kernel_config settings renamed for consistency/xing
SQL 92 
UPDATE kernel_config SET config_name='site_session_lifetime' WHERE config_name='session_lifetime';
UPDATE kernel_config SET config_name='site_use_load_threshold' WHERE config_name='use_load_threshold';
UPDATE kernel_config SET config_name='site_load_threshold' WHERE config_name='load_threshold';
UPDATE kernel_config SET config_name='site_output_obzip' WHERE config_name='output_obzip';
UPDATE kernel_config SET config_name='site_help_popup' WHERE config_name='help_popup';
UPDATE kernel_config SET config_name='site_store_session_db' WHERE config_name='session_db';
UPDATE kernel_config SET config_name='site_use_proxy' WHERE config_name='use_proxy';
UPDATE kernel_config SET config_name='site_proxy_host' WHERE config_name='proxy_host';
UPDATE kernel_config SET config_name='site_proxy_port' WHERE config_name='proxy_port';
UPDATE kernel_config SET config_name='site_user_assigned_modules' WHERE config_name='user_assigned_modules';
UPDATE kernel_config SET config_name='site_http_domain' WHERE config_name='http_domain';
UPDATE kernel_config SET config_name='site_https_domain' WHERE config_name='https_domain';
UPDATE kernel_config SET config_name='site_https_login' WHERE config_name='https_login';
UPDATE kernel_config SET config_name='site_https_login_required' WHERE config_name='https_login_required';
UPDATE kernel_config SET config_name='site_direct_pagination' WHERE config_name='direct_pagination';
UPDATE kernel_config SET config_name='site_edit_help' WHERE config_name='wiki_help';
UPDATE kernel_config SET config_name='site_form_help' WHERE config_name='help_notes';
UPDATE kernel_config SET config_name='site_long_date_format' WHERE config_name='long_date_format';
UPDATE kernel_config SET config_name='site_long_time_format' WHERE config_name='long_time_format';
UPDATE kernel_config SET config_name='site_short_date_format' WHERE config_name='short_date_format';
UPDATE kernel_config SET config_name='site_short_time_format' WHERE config_name='short_time_format';
UPDATE kernel_config SET config_name='site_display_timezone' WHERE config_name='display_timezone';
UPDATE kernel_config SET config_name='site_upload_dir' WHERE config_name='centralized_upload_dir';
UPDATE kernel_config SET config_name='site_temp_dir' WHERE config_name='temp_dir';
UPDATE kernel_config SET config_name='site_http_port' WHERE config_name='http_port';
UPDATE kernel_config SET config_name='site_http_prefix' WHERE config_name='http_prefix';
UPDATE kernel_config SET config_name='site_https_port' WHERE config_name='https_port';
UPDATE kernel_config SET config_name='site_https_prefix' WHERE config_name='https_prefix';
UPDATE kernel_config SET config_name='site_sender_email' WHERE config_name='sender_email';
UPDATE kernel_config SET config_name='site_url_index' WHERE config_name='url_index';
UPDATE kernel_config SET config_name='site_online_help' WHERE config_name='help';
UPDATE kernel_config SET config_name='auth_ldap_userdn' WHERE config_name='users_ldap_userdn';
UPDATE kernel_config SET config_name='auth_ldap_memberisdn' WHERE config_name='users_ldap_memberisdn';
UPDATE kernel_config SET config_name='auth_ldap_groupdn' WHERE config_name='users_ldap_groupdn';
UPDATE kernel_config SET config_name='auth_ldap_basedn' WHERE config_name='users_ldap_basedn';
UPDATE kernel_config SET config_name='auth_ldap_adminuser' WHERE config_name='users_ldap_adminuser';
UPDATE kernel_config SET config_name='auth_ldap_adminpass' WHERE config_name='users_ldap_adminpass';
UPDATE kernel_config SET config_name='auth_ldap_groupattr' WHERE config_name='users_ldap_groupattr';
UPDATE kernel_config SET config_name='auth_ldap_groupoc' WHERE config_name='users_ldap_groupoc';
UPDATE kernel_config SET config_name='auth_ldap_host' WHERE config_name='users_ldap_host';
UPDATE kernel_config SET config_name='auth_ldap_memberattr' WHERE config_name='users_ldap_memberattr';
UPDATE kernel_config SET config_name='auth_ldap_port' WHERE config_name='users_ldap_port';
UPDATE kernel_config SET config_name='auth_ldap_scope' WHERE config_name='users_ldap_scope';
UPDATE kernel_config SET config_name='auth_ldap_userattr' WHERE config_name='users_ldap_userattr';
UPDATE kernel_config SET config_name='auth_ldap_useroc' WHERE config_name='users_ldap_useroc';
UPDATE kernel_config SET config_name='auth_method' WHERE config_name='users_auth_method';
UPDATE kernel_config SET config_name='auth_skip_admin' WHERE config_name='users_auth_skip_admin';
UPDATE kernel_config SET config_name='auth_create_gBitDbUser' WHERE config_name='users_auth_create_gBitDbUser';
UPDATE kernel_config SET config_name='auth_create_user_auth' WHERE config_name='users_auth_create_user_auth';
UPDATE kernel_config SET config_name='webserverauth' WHERE config_name='users_webserverauth';
UPDATE kernel_config SET config_name='count_admin_pvs' WHERE config_name='users_count_admin_pageviews';
UPDATE kernel_config SET config_name='allow_register' WHERE config_name='users_allow_register';
UPDATE kernel_config SET config_name='forgot_pass' WHERE config_name='users_forgot_pass';
UPDATE kernel_config SET config_name='pass_due' WHERE config_name='users_pass_due';
UPDATE kernel_config SET config_name='rememberme' WHERE config_name='users_remember_me';
UPDATE kernel_config SET config_name='remembertime' WHERE config_name='users_remember_time';
UPDATE kernel_config SET config_name='userfiles_quota' WHERE config_name='users_userfiles_quota';
UPDATE kernel_config SET config_name='uf_use_db' WHERE config_name='users_uf_use_db';
UPDATE kernel_config SET config_name='min_pass_length' WHERE config_name='users_min_pass_length';
UPDATE kernel_config SET config_name='change_language' WHERE config_name='users_change_language';
UPDATE kernel_config SET config_name='case_sensitive_login' WHERE config_name='users_case_sensitive_login';
UPDATE kernel_config SET config_name='user_watches' WHERE config_name='users_watches';
UPDATE kernel_config SET config_name='custom_home' WHERE config_name='users_custom_home';
UPDATE kernel_config SET config_name='clear_passwords' WHERE config_name='users_clear_passwords';
UPDATE kernel_config SET config_name='validate_email' WHERE config_name='users_validate_email';
UPDATE kernel_config SET config_name='validate_user' WHERE config_name='users_validate_user';
UPDATE kernel_config SET config_name='use_register_passcode' WHERE config_name='users_register_passcode';
UPDATE kernel_config SET config_name='rnd_num_reg' WHERE config_name='users_random_number_reg';
UPDATE kernel_config SET config_name='register_passcode' WHERE config_name='users_register_passcode';
UPDATE kernel_config SET config_name='pass_chr_num' WHERE config_name='users_pass_chr_num';
UPDATE kernel_config SET config_name='eponymous_groups' WHERE config_name='users_eponymous_groups';
UPDATE kernel_config SET config_name='display_name' WHERE config_name='users_display_name';
17-APRIL-2006kernel_configmore kernel_config settings renamed for consistency/xing
SQL 92 
UPDATE kernel_config SET config_name='site_slide_style' WHERE config_name='slide_style';
UPDATE kernel_config SET config_name='site_top_bar_dropdown' WHERE config_name='top_bar_dropdown';
UPDATE kernel_config SET config_name='site_show_all_modules_always' WHERE config_name='modallgroups';
UPDATE kernel_config SET config_name='site_disable_jstabs' WHERE config_name='disable_jstabs';
UPDATE kernel_config SET config_name='site_bot_bar' WHERE config_name='bot_bar';
UPDATE kernel_config SET config_name='site_top_bar' WHERE config_name='top_bar';
UPDATE kernel_config SET config_name='site_left_column' WHERE config_name='left_column';
UPDATE kernel_config SET config_name='site_right_column' WHERE config_name='right_column';
UPDATE kernel_config SET config_name='site_biticon_display_style' WHERE config_name='biticon_display';
UPDATE kernel_config SET config_name='site_disable_fat' WHERE config_name='disable_fat';
UPDATE kernel_config SET config_name='site_hide_my_top_bar_link' WHERE config_name='hide_my_top_bar_link';
UPDATE kernel_config SET config_name='site_collapsible_modules' WHERE config_name='themes_collapsible_modules';
UPDATE kernel_config SET config_name='site_module_controls' WHERE config_name='themes_module_controls';
The above changes will probably require changes to your templates if you have a custom theme. in particular, you will probably have to apply the following changes: 
top_bar_dropdown    -->   site_top_bar_dropdown
bot_bar             -->   site_bot_bar
top_bar             -->   site_top_bar
left_column         -->   site_left_column
right_column        -->   site_right_column
14-APRIL-2006kernel_configmore kernel_config settings renamed for consistency/xing
SQL 92 
UPDATE kernel_config SET config_name='articles_list_author' WHERE config_name='art_list_author';
UPDATE kernel_config SET config_name='articles_list_date' WHERE config_name='art_list_date';
UPDATE kernel_config SET config_name='articles_list_img' WHERE config_name='art_list_img';
UPDATE kernel_config SET config_name='articles_list_reads' WHERE config_name='art_list_reads';
UPDATE kernel_config SET config_name='articles_list_size' WHERE config_name='art_list_size';
UPDATE kernel_config SET config_name='articles_list_title' WHERE config_name='art_list_title';
UPDATE kernel_config SET config_name='articles_list_topic' WHERE config_name='art_list_topic';
UPDATE kernel_config SET config_name='articles_list_type' WHERE config_name='art_list_type';
UPDATE kernel_config SET config_name='articles_list_expire' WHERE config_name='art_list_expire';
UPDATE kernel_config SET config_name='articles_max_list' WHERE config_name='max_articles';
UPDATE kernel_config SET config_name='articles_rankings' WHERE config_name='cms_rankings';
UPDATE kernel_config SET config_name='articles_submissions' WHERE config_name='article_submissions';
UPDATE kernel_config SET config_name='articles_description_length' WHERE config_name='article_description_length';
UPDATE kernel_config SET config_name='articles_date_threshold' WHERE config_name='article_date_threshold';
 
UPDATE kernel_config SET config_name='wiki_backlinks' WHERE config_name='backlinks';
UPDATE kernel_config SET config_name='wiki_allow_dup_page_names' WHERE config_name='allow_dup_wiki_page_names';
UPDATE kernel_config SET config_name='wiki_page_title' WHERE config_name='page_title';
UPDATE kernel_config SET config_name='wiki_sandbox' WHERE config_name='sandbox';
UPDATE kernel_config SET config_name='wiki_attachments_use_db' WHERE config_name='w_use_db';
UPDATE kernel_config SET config_name='wiki_attachments_use_dir' WHERE config_name='w_use_dir';
UPDATE kernel_config SET config_name='wiki_warn_on_edit_time' WHERE config_name='warn_on_edit_time';
UPDATE kernel_config SET config_name='wiki_book_show_path' WHERE config_name='wikibook_show_path';
UPDATE kernel_config SET config_name='wiki_book_show_navigation' WHERE config_name='wikibook_show_navigation';
UPDATE kernel_config SET config_name='wiki_min_versions' WHERE config_name='keep_versions';
UPDATE kernel_config SET config_name='wiki_max_versions' WHERE config_name='max_versions';
 
UPDATE kernel_config SET config_name='messages_site_contact' WHERE config_name='site_contact';
UPDATE kernel_config SET config_name='messages_contact_user' WHERE config_name='contact_user';
UPDATE kernel_config SET config_name='chatterbox_prune_threshold' WHERE config_name='prune_threshold';
UPDATE kernel_config SET config_name='languages_record_untranslated' WHERE config_name='record_untranslated';
UPDATE kernel_config SET config_name='hotwords_new_window' WHERE config_name='hotwords_nw';
UPDATE kernel_config SET config_name='blog_posts_comments' WHERE config_name='blogposts_comments';
UPDATE kernel_config SET config_name='pigeonholes_display_members' WHERE config_name='display_pigeonhole_members';
UPDATE kernel_config SET config_name='pigeonholes_limit_member_number' WHERE config_name='limit_member_number';
UPDATE kernel_config SET config_name='pgv_session_time' WHERE config_name='pgv_session_time';
UPDATE kernel_config SET config_name='pgv_calendar_format' WHERE config_name='calendar_format';
UPDATE kernel_config SET config_name='pgv_default_pedigree_generations' WHERE config_name='default_pedigree_generations';
UPDATE kernel_config SET config_name='pgv_max_pedigree_generations' WHERE config_name='max_pedigree_generations';
UPDATE kernel_config SET config_name='pgv_max_descendancy_generations' WHERE config_name='max_descendancy_generations';
UPDATE kernel_config SET config_name='pgv_use_RIN' WHERE config_name='use_RIN';
UPDATE kernel_config SET config_name='pgv_pedigree_root_id' WHERE config_name='pedigree_root_id';
UPDATE kernel_config SET config_name='pgv_gedcom_prefix_id' WHERE config_name='gedcom_prefix_id';
UPDATE kernel_config SET config_name='pgv_source_prefix_id' WHERE config_name='source_prefix_id';
UPDATE kernel_config SET config_name='pgv_repo_prefix_id' WHERE config_name='repo_prefix_id';
UPDATE kernel_config SET config_name='pgv_fam_prefix_id' WHERE config_name='fam_prefix_id';
UPDATE kernel_config SET config_name='pgv_media_prefix_id' WHERE config_name='media_prefix_id';
UPDATE kernel_config SET config_name='stats_referers' WHERE config_name='referer_stats';
UPDATE kernel_config SET config_name='liberty_cache_images' WHERE config_name='cacheimages';
UPDATE kernel_config SET config_name='liberty_cache_pages' WHERE config_name='cachepages';
UPDATE kernel_config SET config_name='tidbits_banning' WHERE config_name='banning';
UPDATE kernel_config SET config_name='tidbits_userfiles' WHERE config_name='user_files';
UPDATE kernel_config SET config_name='tidbits_userfiles_use_dir' WHERE config_name='uf_use_dir';
UPDATE kernel_config SET config_name='tidbits_tasks' WHERE config_name='feature_tasks';
UPDATE kernel_config SET config_name='tidbits_usermenu' WHERE config_name='usermenu';
UPDATE kernel_config SET config_name='tidbits_bookmarks' WHERE config_name='user_bookmarks';
5-APRIL-2006kernel_configchange kernel_prefs to kernel_config, name => config_name, pref_value=>config_value for consistency and avoid confusion with content_prefs/spider
SQL 92 
ALTER TABLE kernel_prefs RENAME TO kernel_config;
ALTER TABLE kernel_config RENAME name TO config_name;
ALTER TABLE kernel_config RENAME pref_value TO config_value;
5-APRIL-2006users_permissionsrename permissions to us a common standard/xing
SQL 92 
-- Real databases will need to drop their foreign key
-- ALTER TABLE users_group_permissions DROP CONSTRAINT USERS_GROUP_PERM_PERM_REF;
 
UPDATE users_permissions SET perm_name='p_shoutbox_view' WHERE perm_name='bit_p_view_shoutbox';
UPDATE users_permissions SET perm_name='p_shoutbox_admin' WHERE perm_name='bit_p_admin_shoutbox';
UPDATE users_permissions SET perm_name='p_shoutbox_post' WHERE perm_name='bit_p_post_shoutbox';
 
UPDATE users_permissions SET perm_name='p_xmlrpc_send_content' WHERE perm_name='bit_p_send_pages';
UPDATE users_permissions SET perm_name='p_xmlrpc_sendme_content' WHERE perm_name='bit_p_sendme_pages';
UPDATE users_permissions SET perm_name='p_xmlrpc_admin_content' WHERE perm_name='bit_p_admin_received_pages';
 
UPDATE users_permissions SET perm_name='p_admin' WHERE perm_name='bit_p_admin';
UPDATE users_permissions SET perm_name='p_access_closed_site' WHERE perm_name='bit_p_access_closed_site';
 
UPDATE users_permissions SET perm_name='p_gatekeeper_create' WHERE perm_name='bit_p_create_gatekeeper';
UPDATE users_permissions SET perm_name='p_gatekeeper_edit' WHERE perm_name='bit_p_gatekeeper_edit';
UPDATE users_permissions SET perm_name='p_gatekeeper_admin' WHERE perm_name='bit_p_gatekeeper_admin';
UPDATE users_permissions SET perm_name='p_gatekeeper_read' WHERE perm_name='bit_p_read_gatekeeper';
 
UPDATE users_permissions SET perm_name='p_calendar_view' WHERE perm_name='bit_p_view_calendar';
 
UPDATE users_permissions SET perm_name='p_sample_admin' WHERE perm_name='bit_p_admin_sample';
UPDATE users_permissions SET perm_name='p_sample_create' WHERE perm_name='bit_p_create_sample';
UPDATE users_permissions SET perm_name='p_sample_edit' WHERE perm_name='bit_p_edit_sample';
UPDATE users_permissions SET perm_name='p_sample_read' WHERE perm_name='bit_p_read_sample';
UPDATE users_permissions SET perm_name='p_sample_remove' WHERE perm_name='bit_p_remove_sample';
 
UPDATE users_permissions SET perm_name='p_categories_admin' WHERE perm_name='bit_p_admin_categories';
UPDATE users_permissions SET perm_name='p_categories_view' WHERE perm_name='bit_p_view_categories';
 
UPDATE users_permissions SET perm_name='p_tidbits_admin_banning' WHERE perm_name='bit_p_admin_banning';
UPDATE users_permissions SET perm_name='p_tidbits_upload_userfiles' WHERE perm_name='bit_p_userfiles';
UPDATE users_permissions SET perm_name='p_tidbits_create_bookmarks' WHERE perm_name='bit_p_create_bookmarks';
UPDATE users_permissions SET perm_name='p_tidbits_cache_bookmarks' WHERE perm_name='bit_p_cache_bookmarks';
UPDATE users_permissions SET perm_name='p_tidbits_configure_modules' WHERE perm_name='bit_p_configure_modules';
UPDATE users_permissions SET perm_name='p_tidbits_use_usermenu' WHERE perm_name='bit_p_usermenu';
UPDATE users_permissions SET perm_name='p_tidbits_use_tasks' WHERE perm_name='bit_p_tasks';
UPDATE users_permissions SET perm_name='p_tidbits_custom_home_theme' WHERE perm_name='bit_p_custom_home_theme';
UPDATE users_permissions SET perm_name='p_tidbits_custom_home_layout' WHERE perm_name='bit_p_custom_home_layout';
UPDATE users_permissions SET perm_name='p_tidbits_use_custom_css' WHERE perm_name='bit_p_custom_css';
UPDATE users_permissions SET perm_name='p_tidbits_edit_fortune_cookies' WHERE perm_name='bit_p_edit_cookies';
 
UPDATE users_permissions SET perm_name='p_quota_create' WHERE perm_name='bit_p_create_quota';
UPDATE users_permissions SET perm_name='p_quota_edit' WHERE perm_name='bit_p_quota_edit';
UPDATE users_permissions SET perm_name='p_quota_admin' WHERE perm_name='bit_p_quota_admin';
UPDATE users_permissions SET perm_name='p_quota_read' WHERE perm_name='bit_p_read_quota';
 
UPDATE users_permissions SET perm_name='p_smileys_use' WHERE perm_name='bit_p_use_smileys';
 
UPDATE users_permissions SET perm_name='p_chatterbox_use' WHERE perm_name='bit_p_use_chatterbox';
 
UPDATE users_permissions SET perm_name='p_fisheye_view' WHERE perm_name='bit_p_view_fisheye';
UPDATE users_permissions SET perm_name='p_fisheye_create' WHERE perm_name='bit_p_create_fisheye';
UPDATE users_permissions SET perm_name='p_fisheye_edit' WHERE perm_name='bit_p_edit_fisheye';
UPDATE users_permissions SET perm_name='p_fisheye_upload' WHERE perm_name='bit_p_upload_fisheye';
UPDATE users_permissions SET perm_name='p_fisheye_admin' WHERE perm_name='bit_p_admin_fisheye';
UPDATE users_permissions SET perm_name='p_fisheye_upload_nonimages' WHERE perm_name='bit_p_fisheye_upload_nonimages';
 
UPDATE users_permissions SET perm_name='p_languages_create' WHERE perm_name='bit_p_create_languages';
UPDATE users_permissions SET perm_name='p_languages_edit' WHERE perm_name='bit_p_edit_languages';
UPDATE users_permissions SET perm_name='p_languages_delete' WHERE perm_name='bit_p_delete_languages';
UPDATE users_permissions SET perm_name='p_languages_edit_master' WHERE perm_name='bit_p_edit_master_strings';
UPDATE users_permissions SET perm_name='p_languages_import' WHERE perm_name='bit_p_import_languages';
 
UPDATE users_permissions SET perm_name='p_users_assign_group_perms' WHERE perm_name='bit_p_user_group_perms';
UPDATE users_permissions SET perm_name='p_users_assign_group_members' WHERE perm_name='bit_p_user_group_members';
UPDATE users_permissions SET perm_name='p_users_group_subgroups' WHERE perm_name='bit_p_user_group_subgroups';
UPDATE users_permissions SET perm_name='p_users_admin' WHERE perm_name='bit_p_admin_users';
UPDATE users_permissions SET perm_name='p_users_view_icons_and_tools' WHERE perm_name='bit_p_view_tabs_and_tools';
UPDATE users_permissions SET perm_name='p_users_create_personal_groups' WHERE perm_name='bit_p_create_personal_groups';
UPDATE users_permissions SET perm_name='p_users_view_user_list' WHERE perm_name='bit_p_view_user_list';
UPDATE users_permissions SET perm_name='p_users_view_user_homepage' WHERE perm_name='bit_p_view_user_homepage';
UPDATE users_permissions SET perm_name='p_users_edit_user_homepage' WHERE perm_name='bit_p_edit_user_homepage';
 
UPDATE users_permissions SET perm_name='p_galaxia_admin' WHERE perm_name='bit_p_admin_workflow';
UPDATE users_permissions SET perm_name='p_galaxia_abort_instance' WHERE perm_name='bit_p_abort_instance';
UPDATE users_permissions SET perm_name='p_galaxia_use' WHERE perm_name='bit_p_use_workflow';
UPDATE users_permissions SET perm_name='p_galaxia_exception_instance' WHERE perm_name='bit_p_exception_instance';
UPDATE users_permissions SET perm_name='p_galaxia_send_instance' WHERE perm_name='bit_p_send_instance';
 
UPDATE users_permissions SET perm_name='p_newsletters_admin' WHERE perm_name='bit_p_admin_newsletters';
UPDATE users_permissions SET perm_name='p_newsletters_create' WHERE perm_name='bit_p_create_newsletters';
UPDATE users_permissions SET perm_name='p_newsletters_create_editions' WHERE perm_name='bit_p_create_editions';
UPDATE users_permissions SET perm_name='p_newsletters_subscribe' WHERE perm_name='bit_p_subscribe_newsletters';
UPDATE users_permissions SET perm_name='p_newsletters_subscribe_email' WHERE perm_name='bit_p_subscribe_email';
 
UPDATE users_permissions SET perm_name='p_blogs_create' WHERE perm_name='bit_p_create_blogs';
UPDATE users_permissions SET perm_name='p_blogs_create_public_blog' WHERE perm_name='bit_p_create_public_blog';
UPDATE users_permissions SET perm_name='p_blogs_post' WHERE perm_name='bit_p_blog_post';
UPDATE users_permissions SET perm_name='p_blogs_admin' WHERE perm_name='bit_p_blog_admin';
UPDATE users_permissions SET perm_name='p_blogs_view' WHERE perm_name='bit_p_read_blog';
 
UPDATE users_permissions SET perm_name='p_pdf_generation' WHERE perm_name='bit_p_pdf_generation';
 
UPDATE users_permissions SET perm_name='p_messages_send' WHERE perm_name='bit_p_messages';
 
UPDATE users_permissions SET perm_name='p_wiki_edit_dynvar' WHERE perm_name='bit_p_edit_dynvar';
UPDATE users_permissions SET perm_name='p_wiki_edit_page' WHERE perm_name='bit_p_edit';
UPDATE users_permissions SET perm_name='p_wiki_view_page' WHERE perm_name='bit_p_view';
UPDATE users_permissions SET perm_name='p_wiki_remove_page' WHERE perm_name='bit_p_remove';
UPDATE users_permissions SET perm_name='p_wiki_rollback' WHERE perm_name='bit_p_rollback';
UPDATE users_permissions SET perm_name='p_wiki_admin' WHERE perm_name='bit_p_admin_wiki';
UPDATE users_permissions SET perm_name='p_wiki_admin_attachments' WHERE perm_name='bit_p_wiki_admin_attachments';
UPDATE users_permissions SET perm_name='p_wiki_view_attachments' WHERE perm_name='bit_p_wiki_view_attachments';
UPDATE users_permissions SET perm_name='p_wiki_upload_picture' WHERE perm_name='bit_p_upload_picture';
UPDATE users_permissions SET perm_name='p_wiki_save_minor' WHERE perm_name='bit_p_minor';
UPDATE users_permissions SET perm_name='p_wiki_rename_page' WHERE perm_name='bit_p_rename';
UPDATE users_permissions SET perm_name='p_wiki_lock_page' WHERE perm_name='bit_p_lock';
UPDATE users_permissions SET perm_name='p_wiki_edit_book' WHERE perm_name='bit_p_edit_books';
UPDATE users_permissions SET perm_name='p_wiki_admin_book' WHERE perm_name='bit_p_admin_books';
UPDATE users_permissions SET perm_name='p_wiki_edit_copyright' WHERE perm_name='bit_p_edit_copyrights';
 
UPDATE users_permissions SET perm_name='p_pigeonholes_view' WHERE perm_name='bit_p_view_pigeonholes';
UPDATE users_permissions SET perm_name='p_pigeonholes_insert_member' WHERE perm_name='bit_p_insert_pigeonhole_member';
UPDATE users_permissions SET perm_name='p_pigeonholes_edit' WHERE perm_name='bit_p_edit_pigeonholes';
 
UPDATE users_permissions SET perm_name='p_stickies_edit' WHERE perm_name='bit_p_stickies_edit';
UPDATE users_permissions SET perm_name='p_stickies_admin' WHERE perm_name='bit_p_stickies_admin';
 
UPDATE users_permissions SET perm_name='p_stats_view_referer' WHERE perm_name='bit_p_view_referer_stats';
UPDATE users_permissions SET perm_name='p_stats_view' WHERE perm_name='bit_p_view_stats';
 
UPDATE users_permissions SET perm_name='p_liberty_edit_html_style' WHERE perm_name='bit_p_edit_html_style';
UPDATE users_permissions SET perm_name='p_liberty_post_comments' WHERE perm_name='bit_p_post_comments';
UPDATE users_permissions SET perm_name='p_liberty_read_comments' WHERE perm_name='bit_p_read_comments';
UPDATE users_permissions SET perm_name='p_liberty_remove_comments' WHERE perm_name='bit_p_remove_comments';
UPDATE users_permissions SET perm_name='p_liberty_vote_comments' WHERE perm_name='bit_p_vote_comments';
UPDATE users_permissions SET perm_name='p_liberty_edit_comments' WHERE perm_name='bit_p_edit_comments';
UPDATE users_permissions SET perm_name='p_liberty_attach_attachments' WHERE perm_name='bit_p_content_attachments';
UPDATE users_permissions SET perm_name='p_liberty_detach_attachment' WHERE perm_name='bit_p_detach_attachment';
UPDATE users_permissions SET perm_name='p_liberty_print' WHERE perm_name='bit_p_print';
 
UPDATE users_permissions SET perm_name='p_articles_edit' WHERE perm_name='bit_p_edit_article';
UPDATE users_permissions SET perm_name='p_articles_remove' WHERE perm_name='bit_p_remove_article';
UPDATE users_permissions SET perm_name='p_articles_read' WHERE perm_name='bit_p_read_article';
UPDATE users_permissions SET perm_name='p_articles_submit' WHERE perm_name='bit_p_submit_article';
UPDATE users_permissions SET perm_name='p_articles_edit_submission' WHERE perm_name='bit_p_edit_submission';
UPDATE users_permissions SET perm_name='p_articles_remove_submission' WHERE perm_name='bit_p_remove_submission';
UPDATE users_permissions SET perm_name='p_articles_approve_submission' WHERE perm_name='bit_p_approve_submission';
UPDATE users_permissions SET perm_name='p_articles_send' WHERE perm_name='bit_p_send_articles';
UPDATE users_permissions SET perm_name='p_articles_sendme' WHERE perm_name='bit_p_sendme_articles';
UPDATE users_permissions SET perm_name='p_articles_auto_approve' WHERE perm_name='bit_p_autoapprove_submission';
UPDATE users_permissions SET perm_name='p_articles_admin' WHERE perm_name='bit_p_admin_articles';
 
UPDATE users_permissions SET perm_name='p_nexus_insert_item' WHERE perm_name='bit_p_insert_nexus_item';
UPDATE users_permissions SET perm_name='p_nexus_create_menus' WHERE perm_name='bit_p_create_nexus_menus';
 
 
UPDATE users_group_permissions SET perm_name='p_shoutbox_view' WHERE perm_name='bit_p_view_shoutbox';
UPDATE users_group_permissions SET perm_name='p_shoutbox_admin' WHERE perm_name='bit_p_admin_shoutbox';
UPDATE users_group_permissions SET perm_name='p_shoutbox_post' WHERE perm_name='bit_p_post_shoutbox';
 
UPDATE users_group_permissions SET perm_name='p_xmlrpc_send_content' WHERE perm_name='bit_p_send_pages';
UPDATE users_group_permissions SET perm_name='p_xmlrpc_sendme_content' WHERE perm_name='bit_p_sendme_pages';
UPDATE users_group_permissions SET perm_name='p_xmlrpc_admin_content' WHERE perm_name='bit_p_admin_received_pages';
 
UPDATE users_group_permissions SET perm_name='p_admin' WHERE perm_name='bit_p_admin';
UPDATE users_group_permissions SET perm_name='p_access_closed_site' WHERE perm_name='bit_p_access_closed_site';
 
UPDATE users_group_permissions SET perm_name='p_gatekeeper_create' WHERE perm_name='bit_p_create_gatekeeper';
UPDATE users_group_permissions SET perm_name='p_gatekeeper_edit' WHERE perm_name='bit_p_gatekeeper_edit';
UPDATE users_group_permissions SET perm_name='p_gatekeeper_admin' WHERE perm_name='bit_p_gatekeeper_admin';
UPDATE users_group_permissions SET perm_name='p_gatekeeper_read' WHERE perm_name='bit_p_read_gatekeeper';
 
UPDATE users_group_permissions SET perm_name='p_calendar_view' WHERE perm_name='bit_p_view_calendar';
 
UPDATE users_group_permissions SET perm_name='p_sample_admin' WHERE perm_name='bit_p_admin_sample';
UPDATE users_group_permissions SET perm_name='p_sample_create' WHERE perm_name='bit_p_create_sample';
UPDATE users_group_permissions SET perm_name='p_sample_edit' WHERE perm_name='bit_p_edit_sample';
UPDATE users_group_permissions SET perm_name='p_sample_read' WHERE perm_name='bit_p_read_sample';
UPDATE users_group_permissions SET perm_name='p_sample_remove' WHERE perm_name='bit_p_remove_sample';
 
UPDATE users_group_permissions SET perm_name='p_categories_admin' WHERE perm_name='bit_p_admin_categories';
UPDATE users_group_permissions SET perm_name='p_categories_view' WHERE perm_name='bit_p_view_categories';
 
UPDATE users_group_permissions SET perm_name='p_tidbits_admin_banning' WHERE perm_name='bit_p_admin_banning';
UPDATE users_group_permissions SET perm_name='p_tidbits_upload_userfiles' WHERE perm_name='bit_p_userfiles';
UPDATE users_group_permissions SET perm_name='p_tidbits_create_bookmarks' WHERE perm_name='bit_p_create_bookmarks';
UPDATE users_group_permissions SET perm_name='p_tidbits_cache_bookmarks' WHERE perm_name='bit_p_cache_bookmarks';
UPDATE users_group_permissions SET perm_name='p_tidbits_configure_modules' WHERE perm_name='bit_p_configure_modules';
UPDATE users_group_permissions SET perm_name='p_tidbits_use_usermenu' WHERE perm_name='bit_p_usermenu';
UPDATE users_group_permissions SET perm_name='p_tidbits_use_tasks' WHERE perm_name='bit_p_tasks';
UPDATE users_group_permissions SET perm_name='p_tidbits_custom_home_theme' WHERE perm_name='bit_p_custom_home_theme';
UPDATE users_group_permissions SET perm_name='p_tidbits_custom_home_layout' WHERE perm_name='bit_p_custom_home_layout';
UPDATE users_group_permissions SET perm_name='p_tidbits_use_custom_css' WHERE perm_name='bit_p_custom_css';
UPDATE users_group_permissions SET perm_name='p_tidbits_edit_fortune_cookies' WHERE perm_name='bit_p_edit_cookies';
 
UPDATE users_group_permissions SET perm_name='p_quota_create' WHERE perm_name='bit_p_create_quota';
UPDATE users_group_permissions SET perm_name='p_quota_edit' WHERE perm_name='bit_p_quota_edit';
UPDATE users_group_permissions SET perm_name='p_quota_admin' WHERE perm_name='bit_p_quota_admin';
UPDATE users_group_permissions SET perm_name='p_quota_read' WHERE perm_name='bit_p_read_quota';
 
UPDATE users_group_permissions SET perm_name='p_smileys_use' WHERE perm_name='bit_p_use_smileys';
 
UPDATE users_group_permissions SET perm_name='p_chatterbox_use' WHERE perm_name='bit_p_use_chatterbox';
 
UPDATE users_group_permissions SET perm_name='p_fisheye_view' WHERE perm_name='bit_p_view_fisheye';
UPDATE users_group_permissions SET perm_name='p_fisheye_create' WHERE perm_name='bit_p_create_fisheye';
UPDATE users_group_permissions SET perm_name='p_fisheye_edit' WHERE perm_name='bit_p_edit_fisheye';
UPDATE users_group_permissions SET perm_name='p_fisheye_upload' WHERE perm_name='bit_p_upload_fisheye';
UPDATE users_group_permissions SET perm_name='p_fisheye_admin' WHERE perm_name='bit_p_admin_fisheye';
UPDATE users_group_permissions SET perm_name='p_fisheye_upload_nonimages' WHERE perm_name='bit_p_fisheye_upload_nonimages';
 
UPDATE users_group_permissions SET perm_name='p_languages_create' WHERE perm_name='bit_p_create_languages';
UPDATE users_group_permissions SET perm_name='p_languages_edit' WHERE perm_name='bit_p_edit_languages';
UPDATE users_group_permissions SET perm_name='p_languages_delete' WHERE perm_name='bit_p_delete_languages';
UPDATE users_group_permissions SET perm_name='p_languages_edit_master' WHERE perm_name='bit_p_edit_master_strings';
UPDATE users_group_permissions SET perm_name='p_languages_import' WHERE perm_name='bit_p_import_languages';
 
UPDATE users_group_permissions SET perm_name='p_users_assign_group_perms' WHERE perm_name='bit_p_user_group_perms';
UPDATE users_group_permissions SET perm_name='p_users_assign_group_members' WHERE perm_name='bit_p_user_group_members';
UPDATE users_group_permissions SET perm_name='p_users_group_subgroups' WHERE perm_name='bit_p_user_group_subgroups';
UPDATE users_group_permissions SET perm_name='p_users_admin' WHERE perm_name='bit_p_admin_users';
UPDATE users_group_permissions SET perm_name='p_users_view_icons_and_tools' WHERE perm_name='bit_p_view_tabs_and_tools';
UPDATE users_group_permissions SET perm_name='p_users_create_personal_groups' WHERE perm_name='bit_p_create_personal_groups';
UPDATE users_group_permissions SET perm_name='p_users_view_user_list' WHERE perm_name='bit_p_view_user_list';
UPDATE users_group_permissions SET perm_name='p_users_view_user_homepage' WHERE perm_name='bit_p_view_user_homepage';
UPDATE users_group_permissions SET perm_name='p_users_edit_user_homepage' WHERE perm_name='bit_p_edit_user_homepage';
 
UPDATE users_group_permissions SET perm_name='p_galaxia_admin' WHERE perm_name='bit_p_admin_workflow';
UPDATE users_group_permissions SET perm_name='p_galaxia_abort_instance' WHERE perm_name='bit_p_abort_instance';
UPDATE users_group_permissions SET perm_name='p_galaxia_use' WHERE perm_name='bit_p_use_workflow';
UPDATE users_group_permissions SET perm_name='p_galaxia_exception_instance' WHERE perm_name='bit_p_exception_instance';
UPDATE users_group_permissions SET perm_name='p_galaxia_send_instance' WHERE perm_name='bit_p_send_instance';
 
UPDATE users_group_permissions SET perm_name='p_newsletters_admin' WHERE perm_name='bit_p_admin_newsletters';
UPDATE users_group_permissions SET perm_name='p_newsletters_create' WHERE perm_name='bit_p_create_newsletters';
UPDATE users_group_permissions SET perm_name='p_newsletters_create_editions' WHERE perm_name='bit_p_create_editions';
UPDATE users_group_permissions SET perm_name='p_newsletters_subscribe' WHERE perm_name='bit_p_subscribe_newsletters';
UPDATE users_group_permissions SET perm_name='p_newsletters_subscribe_email' WHERE perm_name='bit_p_subscribe_email';
 
UPDATE users_group_permissions SET perm_name='p_blogs_create' WHERE perm_name='bit_p_create_blogs';
UPDATE users_group_permissions SET perm_name='p_blogs_create_public_blog' WHERE perm_name='bit_p_create_public_blog';
UPDATE users_group_permissions SET perm_name='p_blogs_post' WHERE perm_name='bit_p_blog_post';
UPDATE users_group_permissions SET perm_name='p_blogs_admin' WHERE perm_name='bit_p_blog_admin';
UPDATE users_group_permissions SET perm_name='p_blogs_view' WHERE perm_name='bit_p_read_blog';
 
UPDATE users_group_permissions SET perm_name='p_pdf_generation' WHERE perm_name='bit_p_pdf_generation';
 
UPDATE users_group_permissions SET perm_name='p_messages_send' WHERE perm_name='bit_p_messages';
 
UPDATE users_group_permissions SET perm_name='p_wiki_edit_dynvar' WHERE perm_name='bit_p_edit_dynvar';
UPDATE users_group_permissions SET perm_name='p_wiki_edit_page' WHERE perm_name='bit_p_edit';
UPDATE users_group_permissions SET perm_name='p_wiki_view_page' WHERE perm_name='bit_p_view';
UPDATE users_group_permissions SET perm_name='p_wiki_remove_page' WHERE perm_name='bit_p_remove';
UPDATE users_group_permissions SET perm_name='p_wiki_rollback' WHERE perm_name='bit_p_rollback';
UPDATE users_group_permissions SET perm_name='p_wiki_admin' WHERE perm_name='bit_p_admin_wiki';
UPDATE users_group_permissions SET perm_name='p_wiki_admin_attachments' WHERE perm_name='bit_p_wiki_admin_attachments';
UPDATE users_group_permissions SET perm_name='p_wiki_view_attachments' WHERE perm_name='bit_p_wiki_view_attachments';
UPDATE users_group_permissions SET perm_name='p_wiki_upload_picture' WHERE perm_name='bit_p_upload_picture';
UPDATE users_group_permissions SET perm_name='p_wiki_save_minor' WHERE perm_name='bit_p_minor';
UPDATE users_group_permissions SET perm_name='p_wiki_rename_page' WHERE perm_name='bit_p_rename';
UPDATE users_group_permissions SET perm_name='p_wiki_lock_page' WHERE perm_name='bit_p_lock';
UPDATE users_group_permissions SET perm_name='p_wiki_edit_book' WHERE perm_name='bit_p_edit_books';
UPDATE users_group_permissions SET perm_name='p_wiki_admin_book' WHERE perm_name='bit_p_admin_books';
UPDATE users_group_permissions SET perm_name='p_wiki_edit_copyright' WHERE perm_name='bit_p_edit_copyrights';
 
UPDATE users_group_permissions SET perm_name='p_pigeonholes_view' WHERE perm_name='bit_p_view_pigeonholes';
UPDATE users_group_permissions SET perm_name='p_pigeonholes_insert_member' WHERE perm_name='bit_p_insert_pigeonhole_member';
UPDATE users_group_permissions SET perm_name='p_pigeonholes_edit' WHERE perm