These are ReleaseTwo database changes.
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.
| Date | Table | Reason | Who |
| 09-SEP-2006 | StarsPackage | remove stars table, add update_count colums to stars_version and stars_history, add indexs to enforce unique constraints | /jht001 |
| SQL 92 |
drop table stars;
ALTER TABLE stars_version ADD COLUMN update_count INT4 default 0;
ALTER TABLE stars_history ADD COLUMN update_count INT4 default 0;
ALTER TABLE stars_version ADD PRIMARY KEY(content_id,version);
ALTER TABLE stars_history ADD PRIMARY KEY(content_id,version,user_id);
|
| 06-SEP-2006 | FisheyePackage | add image position fractional ordering to image galleries | /spider |
| SQL 92 |
ALTER TABLE fisheye_gallery_image_map RENAME item_position TO old_position;
ALTER TABLE fisheye_gallery_image_map ADD COLUMN item_position FLOAT;
UPDATE fisheye_gallery_image_map SET item_position = old_position;
ALTER TABLE fisheye_gallery_image_map DROP COLUMN old_position;
|
| 21-AUG-2006 | UsersPackage | add password expiration | /jht001 |
| SQL 92 |
ALTER TABLE users_users ADD COLUMN provpass_expires INT8;
|
| 21-AUG-2006 | StarsPackage | add perversion ratings | /hash9 |
| SQL 92 |
CREATE TABLE stars_version ( content_id INTEGER NOT NULL, version INTEGER NOT NULL, rating_count INTEGER, rating INTEGER, CONSTRAINT stars_version_ref FOREIGN KEY (content_id) REFERENCES liberty_content( content_id ));
ALTER TABLE stars_history ADD COLUMN version INTEGER NOT NULL;
|
| 18-AUG-2006 | LibertyPackage | move highly volatile hits columns out of liberty_content and into a separate table | /jht001 and /spiderr |
| SQL 92 |
CREATE TABLE liberty_content_hits ( content_id INTEGER PRIMARY KEY, hits INTEGER NOT NULL DEFAULT 1, last_hit BIGINT, CONSTRAINT liberty_content_hits_ref FOREIGN KEY (content_id) REFERENCES liberty_content( content_id ));
INSERT INTO liberty_content_hits ( content_id, hits, last_hit ) (SELECT content_id, hits, last_hit FROM liberty_content);
ALTER TABLE liberty_content DROP hits;
ALTER TABLE liberty_content DROP last_hit;
|
| 26-JUL-2006 | LibertyPackage | Add anonymous name to comments | /Hash9 |
| SQL 92 |
ALTER TABLE liberty_comments ADD anon_name VARCHAR(40);
|
| 17-JUL-2006 | UsersPackage | Improve users_cnxn to record user assumption ID | /spider |
| SQL 92 |
ALTER TABLE users_cnxn ADD assume_from_user_id INT;
|
| 10-JUL-2006 | multisites | added per site content restricitions | /nickpalmer |
| CREATE |
CREATE TABLE multisite_content ( multisite_id INTEGER NOT NULL, content_id INTEGER NOT NULL , CONSTRAINT multisite_content_ref FOREIGN KEY (content_id) REFERENCES liberty_content( content_id ) , CONSTRAINT multisite_multisite_ref FOREIGN KEY (multisite_id) REFERENCES multisites( multisite_id ), PRIMARY KEY (multisite_id, content_id) );
INSERT INTO `kernel_config`(`package`,`config_name`,`config_value`) VALUES ('multisites', 'multisites_per_site_content','y');
INSERT INTO `kernel_config`(`package`,`config_name`,`config_value`) VALUES ('multisites', 'multisites_use_jstab','y');
INSERT INTO `kernel_config`(`package`,`config_name`,`config_value`) VALUES ('multistes', 'multisites_limit_member_number','10');
INSERT INTO `users_permissions` (`perm_name`, `perm_desc`, `perm_level`, `package`) VALUES ('p_multisites_restrict_content', 'Can restrict content to certain sites', 'editor', 'multisites');
INSERT INTO `users_permissions` (`perm_name`, `perm_desc`, `perm_level`, `package`) VALUES ('p_multisites_view_restricted', 'Can view all site restricted content', 'admin', 'multisites');
|
| 12-JUN-2006 | fisheye | image comment - no more useful after spider changes | /sylvie |
| SQL 92 |
OBSOLETE: ALTER TABLE fisheye_gallery ADD COLUMN image_comment VARCHAR(1);
|
| 12-MAY-2006 | shoutbox | record IP | /spider |
| SQL 92 |
ALTER TABLE shoutbox ADD COLUMN shout_ip VARCHAR(16);
|
| 12-MAY-2006 | users_permissions, users_group_permissions | p_wiki_view_history | /sylvie |
| SQL 92 |
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');
|
| 8-MAY-2006 | users_groups | to have a after registration page | /sylvie |
| SQL 92 |
ALTER TABLE users_groups ADD COLUMN after_registration_page varchar(255);
|
| 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 |
ALTER TABLE liberty_plugins ADD COLUMN plugin_path varchar(250);
|
| 5-MAY-2006 | liberty_content_prefs | rename some liberty_content_prefs column for consistency | /xing |
| SQL 92 |
ALTER TABLE liberty_content_prefs RENAME COLUMN name TO pref_name;
|
| 30-APRIL-2006 | liberty_content_prefs | rename 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-2006 | kernel_config | more 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-2006 | kernel_config | more 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: |
<?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
?>
|
| 14-APRIL-2006 | kernel_config | more 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-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 |
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-2006 | users_permissions | rename 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_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);
|