History of SchemaChangelog

! bitweaver ReleaseTwo Schema changes

^This is an ongoing list of __any__ changes to __any__ DataDict array in a schema_inc in __any__ package (except the BitcommercePackage ).^

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.

Due to the length of this page, we have split it in two, please consult ReleaseTwoSchemaChangeLog1 for older changes.

! ToDo list
* convert blogs to liberty content
* meta info table? would be useful to store exif data and the like (change liberty_content_prefs to X ?)
* what is liberty_dynamic_variables? i think it's something old from the tikiwiki parser
* more stats tables?
* tidbits_banning.ban_user should be turned into a user_id


|| __::Date::__ | __::Table::__ | __::Reason::__ | __::Who::__
12-JUIN-2006 | fisheye | image comment - no more useful after spider changes| [/sylvie]
SQL 92 |{code source="sql"}
OBSOLETE: ALTER TABLE fisheye_gallery ADD COLUMN image_comment VARCHAR(1);
{/code}
12-MAY-2006 | shoutbox | record IP | [/spider]
SQL 92 |{code source="sql"}
ALTER TABLE shoutbox ADD COLUMN shout_ip VARCHAR(16);
{/code}
12-MAY-2006|users_permissions, users_group_permissions|p_wiki_view_history|[/sylvie]
SQL 92 |{code source="sql"}
INSERT INTO `users_permissions` (`perm_name`,`perm_desc`, `perm_level`, `package`) VALUES ('p_wiki_view_history', 'Can view page history', 'basic', 'wiki');
INSERT INTO `users_group_permissions` (`group_id`, `perm_name`) VALUES (-1,'p_wiki_view_history');
{/code}
8-MAY-2006|users_groups|to have a after registration page|[/sylvie]
SQL 92 |{code source="sql"}
ALTER TABLE users_groups ADD COLUMN after_registration_page varchar(255);
{/code}
5-MAY-2006|liberty_plugins|add plugin_path column that plugins can be kept in any directory without having to scan for them when parsing|[/xing]
SQL 92 | {code source="sql"}
ALTER TABLE liberty_plugins ADD COLUMN plugin_path varchar(250);
{/code}
5-MAY-2006|liberty_content_prefs|rename some liberty_content_prefs column for consistency|[/xing]
SQL 92 | {code source="sql"}
ALTER TABLE liberty_content_prefs RENAME COLUMN name TO pref_name;
{/code}
30-APRIL-2006|liberty_content_prefs|rename some liberty_content_prefs settings for consistency|[/xing]
SQL 92 | {code source="sql"}
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';
{/code}
19-APRIL-2006|kernel_config|more kernel_config settings renamed for consistency|[/xing]
SQL 92 | {code source="sql"}
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';
{/code}
17-APRIL-2006|kernel_config|more kernel_config settings renamed for consistency|[/xing]
SQL 92 | {code source="sql"}
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';
{/code}
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:
{code source=PHP}
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
{/code}
14-APRIL-2006|kernel_config|more kernel_config settings renamed for consistency|[/xing]
SQL 92 | {code source="sql"}
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';

{/code}
5-APRIL-2006|kernel_config|change kernel_prefs to kernel_config, name => config_name, pref_value=>config_value for consistency and avoid confusion with content_prefs|[/spider]
SQL 92 | {code source="sql"}
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;
{/code}
5-APRIL-2006|users_permissions|rename permissions to us a common standard|[/xing]
SQL 92 | {code source="sql"}
-- 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_name='bit_p_edit_pigeonholes';

UPDATE users_group_permissions SET perm_name='p_stickies_edit' WHERE perm_name='bit_p_stickies_edit';
UPDATE users_group_permissions SET perm_name='p_stickies_admin' WHERE perm_name='bit_p_stickies_admin';

UPDATE users_group_permissions SET perm_name='p_stats_view_referer' WHERE perm_name='bit_p_view_referer_stats';
UPDATE users_group_permissions SET perm_name='p_stats_view' WHERE perm_name='bit_p_view_stats';

UPDATE users_group_permissions SET perm_name='p_liberty_edit_html_style' WHERE perm_name='bit_p_edit_html_style';
UPDATE users_group_permissions SET perm_name='p_liberty_post_comments' WHERE perm_name='bit_p_post_comments';
UPDATE users_group_permissions SET perm_name='p_liberty_read_comments' WHERE perm_name='bit_p_read_comments';
UPDATE users_group_permissions SET perm_name='p_liberty_remove_comments' WHERE perm_name='bit_p_remove_comments';
UPDATE users_group_permissions SET perm_name='p_liberty_vote_comments' WHERE perm_name='bit_p_vote_comments';
UPDATE users_group_permissions SET perm_name='p_liberty_edit_comments' WHERE perm_name='bit_p_edit_comments';
UPDATE users_group_permissions SET perm_name='p_liberty_attach_attachments' WHERE perm_name='bit_p_content_attachments';
UPDATE users_group_permissions SET perm_name='p_liberty_detach_attachment' WHERE perm_name='bit_p_detach_attachment';
UPDATE users_group_permissions SET perm_name='p_liberty_print' WHERE perm_name='bit_p_print';

UPDATE users_group_permissions SET perm_name='p_articles_edit' WHERE perm_name='bit_p_edit_article';
UPDATE users_group_permissions SET perm_name='p_articles_remove' WHERE perm_name='bit_p_remove_article';
UPDATE users_group_permissions SET perm_name='p_articles_read' WHERE perm_name='bit_p_read_article';
UPDATE users_group_permissions SET perm_name='p_articles_submit' WHERE perm_name='bit_p_submit_article';
UPDATE users_group_permissions SET perm_name='p_articles_edit_submission' WHERE perm_name='bit_p_edit_submission';
UPDATE users_group_permissions SET perm_name='p_articles_remove_submission' WHERE perm_name='bit_p_remove_submission';
UPDATE users_group_permissions SET perm_name='p_articles_approve_submission' WHERE perm_name='bit_p_approve_submission';
UPDATE users_group_permissions SET perm_name='p_articles_send' WHERE perm_name='bit_p_send_articles';
UPDATE users_group_permissions SET perm_name='p_articles_sendme' WHERE perm_name='bit_p_sendme_articles';
UPDATE users_group_permissions SET perm_name='p_articles_auto_approve' WHERE perm_name='bit_p_autoapprove_submission';
UPDATE users_group_permissions SET perm_name='p_articles_admin' WHERE perm_name='bit_p_admin_articles';

UPDATE users_group_permissions SET perm_name='p_nexus_insert_item' WHERE perm_name='bit_p_insert_nexus_item';
UPDATE users_group_permissions SET perm_name='p_nexus_create_menus' WHERE perm_name='bit_p_create_nexus_menus';

-- Add the FOREIGN KEY back
-- ALTER TABLE users_group_permissions ADD CONSTRAINT users_group_perm_perm_ref FOREIGN KEY (perm_name) REFERENCES users_permissions (perm_name);
{/code}
||