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 |
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);
|