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 |
12-JUIN-2006 | fisheye | image comment | /sylvie |
SQL 92 |
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);
|