| -! bitweaver ReleaseTwo Schema changes
|
| +! bitweaver ((ReleaseThree)) Schema & Structural changes |
|
|
| -^This is an ongoing list of __any__ changes to __any__ DataDict array in a schema_inc in __any__ package (except the BitcommercePackage ).^
|
| +||~Date|Package|Reason|Who |
| +17-APR-2010 | liberty | plural content name support | [/will] |
| +SQL92|{code source=SQL title="Add pos column"} |
| +ALTER TABLE liberty_content_types RENAME COLUMN content_description TO content_name; |
| +ALTER TABLE liberty_content_types ADD COLUMN content_name_plural VARCHAR(250); |
| +{/code} |
| +API| {div} |
| +* Change content type hash references from content_description to content_name |
| +* Change hash key content_description passed to LibertyContent::getTitle to content_name |
| +* Better than changing content_description to content_name is to change hash references to __use the get methods__ of LibertyContent or LibertySystem with the content_type_guid {code} |
| + LibertyContent::getContentTypeName( plural_version:boolean ) |
| + LibertySystem::getContentTypeName( content_type_guid:string, plural_version:boolean ){/code}These return the singular by default when the optional 'plural_version' param is not set |
| +* Change sql selects from liberty_content_type for content_description to content_name and add content_name_plural if desired |
| +* Update registerContentType in class declarations - change content_description to content_name; you can also add content_name_plural to your class if you wish to add a unique plural of the name, otherwise a default one will be created from the singular by appending an 's' to the end. For example by default a content_name of 'Image' will have a plural of 'Images'. You'll want to set the plural value in cases where appending 's' doesnt not just work; for example words that end in 'y', like 'Gallery' you can specificy the plural as 'Galleries'. For those managing content such as wild animals, like 'Moose' with bitweaver, you would want to declare a plural that is same as the singular: Moose; otherwise bitweaver would create 'Mooses' for you.{/div} |
| +|| |
|
|
| -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.
|
| +* Use of javascript functions in utils/javascript/bitweaver.js should now always be prefaced with the "BitBase." namespace, ala "BitBase.insertAt('foo')", also toggle & flip are replaced with toggleElementDisplay. See bitweaver.js deprecated functions for more. To find deprecated functions, you can run this bash script:{code source="bash" name="check_js.sh"}for func in addLoadHook setCookieArray getCookieArray setCookie getCookie deleteCookie flip toggle setupShowHide utf16to8 utf8to16 serialize unserialize genPass toggle_dynamic_var setSelectionRange setCaretToPos insertAt showById hideById flipMulti flipIcon setFlipIcon flipWithSign setFlipWithSign getElementValue setElementValue switchCheckboxes disableSubmit go popUpWin closeWin |
| +do |
| + echo "CHECKING FOR FUNCTION $func" |
| + grep -r "$func[ ]*(" */templates/*tpl |grep -v BitBase |
| +done{/code} |
| +* Logic files no longer should require the root 'bit_setup_inc.php' to start up bitweaver, but instead use a relative pathing mechanism to require_once( '../kernel/setup_inc.php' ); If you have your own code, you can update it with:{code source="bash"}find . -name "*.php" -exec perl -i -wpe 's/\.\.\/bit_setup_inc\.php/..\/kernel\/setup_inc.php/g' {} \;{/code} |
|
|
| -! 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
|
| +! bitweaver ((ReleaseTwo)) Schema changes |
|
|
| -||__::Date::__|__::Table::__|__::Reason::__|__::Who::__
|
| -5-APRIL-2006|users_permissions|rename permissions to us a common standard|[/xing]
|
| -SQL 92 | {code source="sql"}
|
| --- Real databases will need to drop their foreign key
|
| --- ALTER TABLE users_group_permissions DROP CONSTRAINT USERS_GROUP_PERM_PERM_REF;
|
| +^This is an ongoing list of __any__ changes to __any__ DataDict array in a schema_inc in __any__ package (except: ((BitcommercePackage)) ).^ |
|
|
| -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';
|
| +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)). If you are not sure what this is all about or how to use the information on this page, read the ((How To Use SchemaChangelog)). |
|
|
| -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';
|
| +Due to the length of this page, we have split it in two, please consult the following pages for older schema changes: |
|
|
| -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';
|
| +||~Date|Package|Reason|Who |
| +23-NOV-2009 | liberty | Add pos column | [/lsces] |
| +SQL92|{code source=SQL title="Add pos column"} |
| +ALTER TABLE liberty_content_links ADD COLUMN pos FLOAT; |
| +{/code} |
| +23-NOV-2009 | liberty | Rename reads column | [/lsces] |
| +SQL92|{code source=SQL title="Rename reads column"} |
| +ALTER TABLE mail_queue RENAME reads TO hits; |
| +{/code} |
| +|| |
|
|
| -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';
|
| +* ((ReleaseTwo Schema Changelog 2007)) |
| +* ((ReleaseTwo Schema Changelog 2006)) |
|
|
| -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);
|
| +||~Date|Package|Reason|Who |
| +20-AUG-2009 | boards | Add section tables | [/spider] |
| +SQL92|{code source=SQL title="Add section tables"} |
| +CREATE TABLE boards_sections (section_id INT PRIMARY KEY, section_title VARCHAR(255)); |
| +ALTER TABLE boards ADD COLUMN section_id INT; |
| +ALTER TABLE boards ADD COLUMN pos INT; |
| {/code}
|
| -5-APRIL-2006|users_groups|A user can choose a group at registration|[/sylvie]
|
| -SQL 92 | {code source="sql"}
|
| -ALTER TABLE users_groups ADD is_public VARCHAR(1);
|
| +24-MAR-2009 | users,liberty,newsletters,semaphore | Update ip columns to 39 chars for IPv6 support | [/spider] |
| +PGSQL and FIREBIRD|{code source=SQL title="update columns for IPv6"} |
| +ALTER TABLE users_cnxn ALTER ip TYPE VARCHAR(39); |
| +ALTER TABLE liberty_content_history ALTER ip TYPE VARCHAR(39); |
| +ALTER TABLE liberty_action_log ALTER ip TYPE VARCHAR(39); |
| +ALTER TABLE shoutbox ALTER shout_ip TYPE VARCHAR(39); |
| +ALTER TABLE mail_queue ALTER last_read_ip TYPE VARCHAR(39); |
| +ALTER TABLE semaphore ALTER ip TYPE VARCHAR(39); |
| {/code}
|
| -29-MARCH-2006|search|rename search tables in accordance to our standards|[/xing]
|
| -SQL 92 | {code source="sql"}
|
| -ALTER TABLE tiki_searchsyllable RENAME TO search_syllable;
|
| -ALTER TABLE tiki_searchwords RENAME TO search_words;
|
| -ALTER TABLE tiki_searchindex RENAME TO search_index;
|
| -ALTER TABLE tiki_search_stats RENAME TO search_stats;
|
| +MYSQL|{code source=SQL title="update columns for IPv6"} |
| +ALTER TABLE users_cnxn MODIFY ip VARCHAR(39); |
| +ALTER TABLE liberty_content_history MODIFY ip VARCHAR(39); |
| +ALTER TABLE liberty_action_log MODIFY ip VARCHAR(39); |
| +ALTER TABLE shoutbox MODIFY shout_ip VARCHAR(39); |
| +ALTER TABLE mail_queue MODIFY last_read_ip VARCHAR(39); |
| +ALTER TABLE semaphore MODIFY ip VARCHAR(39); |
| {/code}
|
| -24-FEB-2006 | liberty_content_links |Remove "to_content_id" from compound primary key add seperate index for "to_content_id" to allow null values | [/seannerd]
|
| -SQL 92 | {code source="sql"}
|
| --- Drop primary key
|
| -ALTER TABLE liberty_content_links
|
| - DROP CONSTRAINT PK__liberty_cont__336AA144 -- depends on your install
|
| --- Add new primary key
|
| -ALTER TABLE liberty_content_links ADD CONSTRAINT
|
| - PK__liberty_cont__0E391C95 PRIMARY KEY CLUSTERED
|
| - ( from_content_id, to_title )
|
| --- Create new (seperate) index
|
| -CREATE NONCLUSTERED INDEX to_content_id_idx ON liberty_content_links
|
| - ( to_content_id )
|
| +OCI|{code source=SQL title="update columns for IPv6"}ALTER TABLE users_cnxn MODIFY (ip TYPE VARCHAR2(39)); |
| +ALTER TABLE liberty_content_history MODIFY (ip TYPE VARCHAR2(39)); |
| +ALTER TABLE liberty_action_log MODIFY (ip TYPE VARCHAR2(39)); |
| +ALTER TABLE shoutbox MODIFY (shout_ip TYPE VARCHAR2(39); |
| +ALTER TABLE mail_queue MODIFY (last_read_ip TYPE VARCHAR2(39); |
| +ALTER TABLE semaphore MODIFY (ip TYPE VARCHAR2(39); |
| {/code}
|
| -21-FEB-2006 | liberty_content_links |add to_title to fix several issues and improve performance | [/jht001]
|
| -SQL 92 | {code source="sql"}
|
| -alter table liberty_content_links add column to_title varchar(160);
|
| -alter table liberty_content_links DROP PRIMARY KEY; -- mysql only
|
| -UPDATE liberty_content_links SET to_title = (SELECT title FROM liberty_content WHERE liberty_content_links.to_content_id=content_id);
|
| -DELETE FROM liberty_content_links WHERE to_title IS NULL;
|
| -ALTER TABLE liberty_content_links ALTER to_content_id DROP NOT NULL;
|
| -CREATE INDEX liberty_content_links_title_idx ON liberty_content_links (to_title);
|
| -{/code}to update liberty_content_links , please [/storage/rebuild_liberty_content_links.txt|download this file], place it in your liberty directory and run it from the commandline. use the followwing command: __php rebuild_liberty_content_links.php__
|
| -20-FEB-2006 | languages | SQL reserved words renamed to allow unquoted field names | [/lsces]
|
| -SQL 92 | {code source="sql"}
|
| -ALTER TABLE i18n_strings RENAME tran TO trans;
|
| +13-NOV-2008 | wiki | Drop unused wiki tables | [/xing] |
| +SQL92|{code source=SQL title="Drop unused wiki tables"} |
| +DROP TABLE wiki_received_pages; |
| +DROP TABLE wiki_tags; |
| +DROP TABLE wiki_ext; |
| {/code}
|
| -19-FEB-2006 | galaxia | SQL reserved words renamed to allow unquoted field names | [/lsces]
|
| -SQL 92 | {code source="sql"}
|
| -ALTER TABLE galaxia_activities RENAME type TO act_type;
|
| -ALTER TABLE galaxia_instance_comments RENAME timestamp TO com_timestamp;
|
| +12-NOV-2008 | liberty | fix column types | [/SpOOnman] |
| +SQL92|{code source=SQL title="fix column types"} |
| +ALTER TABLE liberty_content_history ALTER COLUMN user_id TYPE INTEGER; |
| +ALTER TABLE wiki_footnotes ALTER COLUMN user_id TYPE INTEGER; |
| +--pgsql use: |
| +ALTER TABLE liberty_content_history ALTER COLUMN user_id TYPE INTEGER USING user_id::int; |
| +ALTER TABLE wiki_footnotes ALTER COLUMN user_id TYPE INTEGER USING user_id::int; |
| +--mysql use: |
| +ALTER TABLE `liberty_content_history` CHANGE `user_id` `user_id` INTEGER; |
| +ALTER TABLE `wiki_footnotes` CHANGE `user_id` `user_id` INTEGER; |
| {/code}
|
| -19-FEB-2006 | nexus, multisite, messages, fisheye | SQL reserved words renamed to allow unquoted field names | [/lsces]
|
| -SQL 92 | {code source="sql"}
|
| -ALTER TABLE nexus_menus RENAME type TO menu_type;
|
| -ALTER TABLE multisite_preferences RENAME value TO pref_value;
|
| -ALTER TABLE messages RENAME date TO msg_date;
|
| -ALTER TABLE fisheye_gallery_image_map RENAME position TO item_position;
|
| +14-AUG-2008 | gmap | update icon table to have a theme_id association | [/wjames5] |
| +SQL92|{code source=SQL title="longer maptype descriptions."} |
| +ALTER TABLE gmaps_maptypes ALTER COLUMN description TYPE TEXT; |
| +--mysql use: |
| +ALTER TABLE gmaps_maptypes CHANGE description description TEXT; |
| {/code}
|
| -19-FEB-2006 | tidbits, stats | SQL reserved words renamed to allow unquoted field names | [/lsces]
|
| -SQL 92 | {code source="sql"}
|
| -ALTER TABLE tidbits_banning RENAME "user" TO ban_user;
|
| -ALTER TABLE tidbits_banning RENAME message TO ban_message;
|
| -ALTER TABLE tidbits_tasks RENAME date TO task_date;
|
| -ALTER TABLE tidbits_menus RENAME position TO menu_position;
|
| -ALTER TABLE stats_pageviews RENAME day TO stats_day;
|
| -{/code}
|
| -18-FEB-2006 | wiki, articles, blogs | SQL reserved words renamed to allow unquoted field names | [/lsces]
|
| -SQL 92 | {code source="sql"}
|
| -ALTER TABLE wiki_pages RENAME page_size TO wiki_page_size;
|
| -ALTER TABLE wiki_pages RENAME cache TO page_cache;
|
| -ALTER TABLE article_topics RENAME active TO active_topic;
|
| -ALTER TABLE blogs RENAME public TO public_blog;
|
| -ALTER TABLE rss_feeds RENAME cache TO rss_cache;
|
| -{/code}
|
| -18-FEB-2006 | users, kernel, liberty,themes | SQL reserved words renamed to allow unquoted field names | [/lsces]
|
| -SQL 92 | {code source="sql"}
|
| -ALTER TABLE users_users RENAME password TO user_password;
|
| -ALTER TABLE users_favorites_map RENAME position TO map_postion;
|
| -ALTER TABLE users_group_permissions RENAME value TO perm_value;
|
| -ALTER TABLE users_watches RENAME type TO watch_type;
|
| -ALTER TABLE kernel_prefs RENAME value TO pref_value;
|
| -ALTER TABLE liberty_action_log RENAME action TO log_action;
|
| -ALTER TABLE liberty_copyrights RENAME year TO copyright_year;
|
| -ALTER TABLE liberty_content_prefs RENAME value TO pref_value;
|
| -ALTER TABLE themes_layouts RENAME position TO layout_position;
|
| -{/code}
|
| -17-FEB-2006 | users, liberty, wiki | rename and move wiki_action_log to generalized content_action_log in liberty, rename columns with the universally poorly named title of 'comment' | [/spider]
|
| -SQL 92 | {code source="sql"}
|
| -ALTER TABLE wiki_action_log RENAME TO liberty_action_log;
|
| -ALTER TABLE liberty_action_log ADD COLUMN content_id INT;
|
| -UPDATE liberty_action_log SET content_id=(SELECT content_id FROM wiki_pages WHERE page_id=liberty_action_log.page_id);
|
| -ALTER TABLE liberty_action_log DROP COLUMN page_id;
|
| -ALTER TABLE liberty_files RENAME size TO file_size;
|
| -ALTER TABLE liberty_structures RENAME level TO structure_level;
|
| -ALTER TABLE liberty_content_history RENAME comment TO history_comment;
|
| -ALTER TABLE liberty_action_log RENAME comment TO action_comment;
|
| -ALTER TABLE wiki_pages RENAME comment TO edit_comment;
|
| -ALTER TABLE users_permissions RENAME level TO perm_level;
|
| -ALTER TABLE themes_layouts RENAME rows TO module_rows;
|
| -ALTER TABLE themes_layouts_modules RENAME rows TO module_rows;
|
| -{/code}
|
| -15-FEB-2006 | i18n_content_trans_map | Translation map to allow tracking of content translations - name shortened for compatibility | [/xing]
|
| -SQL 92 | {code source="sql"}
|
| -CREATE TABLE i18n_content_trans_map ( content_id INT4 NOT NULL, translation_id INT4 NOT NULL );
|
| -UPDATE liberty_content SET lang_code=(SELECT value FROM kernel_prefs WHERE name='bitlanguage');
|
| -{/code}
|
| -if you added group_id and source_id to liberty_content on the 8-FEB-2006, you can remove these again
|
| -13-FEB-2006 | kernel_prefs | rename preferences to under_score bitweaver standard | [/xing]
|
| -SQL 92 | {code source="sql"}
|
| +14-AUG-2008 | gmap | update icon table to have a theme_id association | [/wjames5] |
| +SQL92|{code source=SQL title="Add theme_id"} |
| +ALTER TABLE gmaps_icon_styles ADD COLUMN theme_id INT4 NOT NULL; |
|
|
| -UPDATE kernel_prefs SET name='pretty_urls_extended' WHERE name='feature_pretty_urls_extended';
|
| -UPDATE kernel_prefs SET name='messages_allow_messages' WHERE name='allowMsgs';
|
| -UPDATE kernel_prefs SET name='users_themes' WHERE name='feature_user_theme';
|
| -UPDATE kernel_prefs SET name='categories_objects' WHERE name='feature_categoryobjects';
|
| -UPDATE kernel_prefs SET name='categories_path' WHERE name='feature_categorypath';
|
| -UPDATE kernel_prefs SET name='liberty_offline_thumbnailer' WHERE name='feature_offline_thumbnailer';
|
| -UPDATE kernel_prefs SET name='kernel_server_name' WHERE name='feature_server_name';
|
| -UPDATE kernel_prefs SET name='output_obzip' WHERE name='feature_obzip';
|
| -UPDATE kernel_prefs SET name='themes_edit_css' WHERE name='feature_editcss';
|
| -UPDATE kernel_prefs SET name='html_pages' WHERE name='feature_html_pages';
|
| -UPDATE kernel_prefs SET name='themes_module_controls' WHERE name='feature_modulecontrols';
|
| -UPDATE kernel_prefs SET name='themes_collapsible_modules' WHERE name='feature_collapsible_modules';
|
| -UPDATE kernel_prefs SET name='kernel_live_support' WHERE name='feature_live_support';
|
| -UPDATE kernel_prefs SET name='themes_dropdown_navbar' WHERE name='feature_dropdown_navbar';
|
| -UPDATE kernel_prefs SET name='users_layouts' WHERE name='feature_user_layout';
|
| -UPDATE kernel_prefs SET name='users_preferences' WHERE name='feature_user_preferences';
|
| -UPDATE kernel_prefs SET name='sample_list_samples' WHERE name='feature_listSamples';
|
| -UPDATE kernel_prefs SET name='stats_search' WHERE name='feature_search_stats';
|
| -UPDATE kernel_prefs SET name='wiki_last_changes' WHERE name='feature_last_changes';
|
| -UPDATE kernel_prefs SET name='wiki_like_pages' WHERE name='feature_like_pages';
|
| -UPDATE kernel_prefs SET name='wiki_list_pages' WHERE name='feature_list_pages';
|
| -UPDATE kernel_prefs SET name='wiki_user_versions' WHERE name='feature_userVersions';
|
| -UPDATE kernel_prefs SET name='wiki_url_import' WHERE name='feature_wiki_url_import';
|
| -{/code}
|
| -UPDATE kernel_prefs SET name='bit_index' WHERE name='bitIndex';
|
| -12-FEB-2006 | liberty_comments | Implement Materialized Path for comments | [/jht001]
|
| -SQL 92 | {code source="sql"}
|
| -ALTER TABLE liberty_comments ADD COLUMN root_id INT4;
|
| -ALTER TABLE liberty_comments ADD COLUMN thread_forward_sequence varchar(250);
|
| -ALTER TABLE liberty_comments ADD COLUMN thread_reverse_sequence varchar(250);
|
| -CREATE UNIQUE INDEX liberty_comments_rt_fwd_idx ON liberty_comments (root_id, thread_forward_sequence);
|
| -CREATE UNIQUE INDEX liberty_comments_rt_rev_idx ON liberty_comments (root_id, thread_reverse_sequence);
|
| -{/code}
|
| -to update comments, please [/storage/comments_updater.txt|download this file], place it in your liberty directory and run it from the commandline. use the followwing command: __php comments_updater.php__
|
| -12-FEB-2006 | i18n_languages | add a column to flag right to left languages | [/xing]
|
| -SQL 92 | {code source="sql"}
|
| -ALTER TABLE i18n_languages ADD COLUMN right_to_left VARCHAR(1);
|
| -{/code}
|
| -7-FEB-2006 | liberty_content_history | complete transition to generic content history in liberty | [/spider]
|
| -SQL 92 | {code source="sql"}
|
| -ALTER TABLE liberty_content_history ADD COLUMN content_id INT;
|
| -UPDATE liberty_content_history SET content_id=(SELECT content_id FROM wiki_pages WHERE page_id=liberty_content_history.page_id);
|
| -ALTER TABLE liberty_content_history DROP COLUMN page_id;
|
| -ALTER TABLE liberty_content ADD COLUMN version INTEGER;
|
| -UPDATE liberty_content SET version=(SELECT version from wiki_pages WHERE content_id=liberty_content.content_id);
|
| -ALTER TABLE wiki_pages DROP COLUMN version;
|
| +-- NOTE: You must run the installer step 4 "Resolve Conflicts" to also add a new gmaps_icon_themes table before trying to add this constraint. |
| +ALTER TABLE gmaps_icon_styles ADD CONSTRAINT gmaps_icon_theme_ref FOREIGN KEY (theme_id) REFERENCES gmaps_icon_themes(theme_id); |
| {/code}
|
| -7-FEB-2006 | kernel_prefs | rename preferences to under_score bitweaver standard | [/xing]
|
| -SQL 92 | {code source="sql"}
|
| -UPDATE kernel_prefs SET name='bit_index' WHERE name='bitIndex';
|
| -UPDATE kernel_prefs SET name='allow_register' WHERE name='allowRegister';
|
| -UPDATE kernel_prefs SET name='forgot_pass' WHERE name='forgotPass';
|
| -UPDATE kernel_prefs SET name='eponymous_groups' WHERE name='eponymousGroups';
|
| -UPDATE kernel_prefs SET name='register_passcode' WHERE name='registerPasscode';
|
| +23-MAY-2008 | liberty | replace old unused meta tables with new ones | [/xing] |
| +SQL92|{code source=SQL title="Remove old unused tables and replace them with new ones"} |
| +-- remove unused meta tables |
| +DROP TABLE liberty_meta_content_map; |
| +DROP TABLE liberty_meta_data; |
| +DROP TABLE liberty_meta_types; |
|
|
| -UPDATE kernel_prefs SET name='use_register_passcode' WHERE name='useRegisterPasscode';
|
| -UPDATE kernel_prefs SET name='validate_user' WHERE name='validateUsers';
|
| -UPDATE kernel_prefs SET name='validate_email' WHERE name='validateEmail';
|
| -UPDATE kernel_prefs SET name='temp_dir' WHERE name='tmpDir';
|
| -UPDATE kernel_prefs SET name='max_records' WHERE name='maxRecords';
|
| -UPDATE kernel_prefs SET name='url_index' WHERE name='urlIndex';
|
| -
|
| -UPDATE kernel_prefs SET name='anon_can_edit' WHERE name='anonCanEdit';
|
| -UPDATE kernel_prefs SET name='max_versions' WHERE name='maxVersions';
|
| -UPDATE kernel_prefs SET name='wiki_home_page' WHERE name='wikiHomePage';
|
| -UPDATE kernel_prefs SET name='wiki_license_page' WHERE name='wikiLicensePage';
|
| -UPDATE kernel_prefs SET name='wiki_submit_notice' WHERE name='wikiSubmitNotice';
|
| -UPDATE kernel_prefs SET name='site_title' WHERE name='siteTitle';
|
| -UPDATE kernel_prefs SET name='feature_last_changes' WHERE name='feature_lastChanges';
|
| -UPDATE kernel_prefs SET name='feature_like_pages' WHERE name='feature_likePages';
|
| -UPDATE kernel_prefs SET name='feature_list_pages' WHERE name='feature_listPages';
|
| -UPDATE kernel_prefs SET name='feature_user_preferences' WHERE name='feature_userPreferences';
|
| -
|
| -UPDATE kernel_prefs SET name='allow_dup_wiki_page_names' WHERE name='feature_allow_dup_wiki_page_names';
|
| -UPDATE kernel_prefs SET name='article_submissions' WHERE name='feature_article_submissions';
|
| -UPDATE kernel_prefs SET name='autolinks' WHERE name='feature_autolinks';
|
| -UPDATE kernel_prefs SET name='babelfish' WHERE name='feature_babelfish';
|
| -UPDATE kernel_prefs SET name='babelfish_logo' WHERE name='feature_babelfish_logo';
|
| -UPDATE kernel_prefs SET name='backlinks' WHERE name='feature_backlinks';
|
| -UPDATE kernel_prefs SET name='banning' WHERE name='feature_banning';
|
| -UPDATE kernel_prefs SET name='bidirectional_text' WHERE name='feature_bidi';
|
| -UPDATE kernel_prefs SET name='blogposts_comments' WHERE name='feature_blogposts_comments';
|
| -UPDATE kernel_prefs SET name='blog_rankings' WHERE name='feature_blog_rankings';
|
| -UPDATE kernel_prefs SET name='bot_bar' WHERE name='feature_bot_bar';
|
| -UPDATE kernel_prefs SET name='clear_passwords' WHERE name='feature_clear_passwords';
|
| -UPDATE kernel_prefs SET name='cms_rankings' WHERE name='feature_cms_rankings';
|
| -UPDATE kernel_prefs SET name='site_contact' WHERE name='feature_contact';
|
| -UPDATE kernel_prefs SET name='custom_home' WHERE name='feature_custom_home';
|
| -
|
| -UPDATE kernel_prefs SET name='wiki_dump' WHERE name='feature_dump';
|
| -UPDATE kernel_prefs SET name='help' WHERE name='feature_help';
|
| -UPDATE kernel_prefs SET name='help_notes' WHERE name='feature_helpnotes';
|
| -UPDATE kernel_prefs SET name='help_popup' WHERE name='feature_helppopup';
|
| -UPDATE kernel_prefs SET name='hotwords' WHERE name='feature_hotwords';
|
| -UPDATE kernel_prefs SET name='hotwords_nw' WHERE name='feature_hotwords_nw';
|
| -UPDATE kernel_prefs SET name='jstabs' WHERE name='feature_jstabs';
|
| -UPDATE kernel_prefs SET name='last_changes' WHERE name='feature_lastChanges';
|
| -UPDATE kernel_prefs SET name='left_column' WHERE name='feature_left_column';
|
| -UPDATE kernel_prefs SET name='like_pages' WHERE name='feature_likePages';
|
| -UPDATE kernel_prefs SET name='list_pages' WHERE name='feature_listPages';
|
| -UPDATE kernel_prefs SET name='page_title' WHERE name='feature_page_title';
|
| -UPDATE kernel_prefs SET name='wiki_ranking' WHERE name='feature_ranking';
|
| -UPDATE kernel_prefs SET name='referer_stats' WHERE name='feature_referer_stats';
|
| -UPDATE kernel_prefs SET name='right_column' WHERE name='feature_right_column';
|
| -UPDATE kernel_prefs SET name='sandbox' WHERE name='feature_sandbox';
|
| -UPDATE kernel_prefs SET name='search_fulltext' WHERE name='feature_search_fulltext';
|
| -UPDATE kernel_prefs SET name='search_stats' WHERE name='feature_search_stats';
|
| -UPDATE kernel_prefs SET name='theme_control' WHERE name='feature_theme_control';
|
| -UPDATE kernel_prefs SET name='top_bar' WHERE name='feature_top_bar';
|
| -UPDATE kernel_prefs SET name='top_bar_dropdown' WHERE name='feature_top_bar_dropdown';
|
| -UPDATE kernel_prefs SET name='user_bookmarks' WHERE name='feature_user_bookmarks';
|
| -UPDATE kernel_prefs SET name='user_files' WHERE name='feature_userfiles';
|
| -
|
| -UPDATE kernel_prefs SET name='usermenu' WHERE name='feature_usermenu';
|
| -UPDATE kernel_prefs SET name='user_preferences' WHERE name='feature_userPreferences';
|
| -UPDATE kernel_prefs SET name='user_watches' WHERE name='feature_user_watches';
|
| -UPDATE kernel_prefs SET name='warn_on_edit' WHERE name='feature_warn_on_edit';
|
| -UPDATE kernel_prefs SET name='wiki_attachments' WHERE name='feature_wiki_attachments';
|
| -UPDATE kernel_prefs SET name='wiki_books' WHERE name='feature_wiki_books';
|
| -UPDATE kernel_prefs SET name='wiki_comments' WHERE name='feature_wiki_comments';
|
| -UPDATE kernel_prefs SET name='wiki_description' WHERE name='feature_wiki_description';
|
| -UPDATE kernel_prefs SET name='wiki_discuss' WHERE name='feature_wiki_discuss';
|
| -UPDATE kernel_prefs SET name='wiki_footnotes' WHERE name='feature_wiki_footnotes';
|
| -UPDATE kernel_prefs SET name='wiki_generate_pdf' WHERE name='feature_wiki_generate_pdf';
|
| -UPDATE kernel_prefs SET name='wiki_help' WHERE name='feature_wikihelp';
|
| -UPDATE kernel_prefs SET name='wiki_icache' WHERE name='feature_wiki_icache';
|
| -UPDATE kernel_prefs SET name='wiki_monosp' WHERE name='feature_wiki_monosp';
|
| -UPDATE kernel_prefs SET name='wiki_multiprint' WHERE name='feature_wiki_multiprint';
|
| -UPDATE kernel_prefs SET name='wiki_notepad' WHERE name='feature_wiki_notepad';
|
| -UPDATE kernel_prefs SET name='wiki_pictures' WHERE name='feature_wiki_pictures';
|
| -UPDATE kernel_prefs SET name='wiki_plurals' WHERE name='feature_wiki_plurals';
|
| -UPDATE kernel_prefs SET name='wiki_rankings' WHERE name='feature_wiki_rankings';
|
| -UPDATE kernel_prefs SET name='wiki_tables' WHERE name='feature_wiki_tables';
|
| -UPDATE kernel_prefs SET name='wiki_templates' WHERE name='feature_wiki_templates';
|
| -UPDATE kernel_prefs SET name='wiki_undo' WHERE name='feature_wiki_undo';
|
| -UPDATE kernel_prefs SET name='wiki_usrlock' WHERE name='feature_wiki_usrlock';
|
| -UPDATE kernel_prefs SET name='wiki_words' WHERE name='feature_wikiwords';
|
| -UPDATE kernel_prefs SET name='wiki_copyrights' WHERE name='wiki_feature_copyrights';
|
| -UPDATE kernel_prefs SET name='wiki_history' WHERE name='feature_history';
|
| +-- add new meta tables |
| +-- Expand TEXT as appropriate ( FB -> BLOB SUB_TYPE TEXT ) |
| +CREATE TABLE liberty_attachment_meta_data ( |
| + attachment_id INT NOT NULL, |
| + meta_type_id INT NOT NULL, |
| + meta_title_id INT NOT NULL, |
| + meta_value TEXT |
| +); |
| +CREATE TABLE liberty_meta_types ( |
| + meta_type_id INT PRIMARY KEY, |
| + meta_type VARCHAR(250) NOT NULL |
| +); |
| +CREATE TABLE liberty_meta_titles ( |
| + meta_title_id INT PRIMARY KEY, |
| + meta_title VARCHAR(250) NOT NULL |
| +); |
| +ALTER TABLE liberty_attachment_meta_data ADD CONSTRAINT lib_attachment_meta_id_ref FOREIGN KEY (attachment_id) REFERENCES liberty_attachments(attachment_id); |
| +ALTER TABLE liberty_attachment_meta_data ADD CONSTRAINT lib_attachment_meta_type_ref FOREIGN KEY (meta_type_id) REFERENCES liberty_meta_types(meta_type_id); |
| +ALTER TABLE liberty_attachment_meta_data ADD CONSTRAINT lib_attachment_meta_title_ref FOREIGN KEY (meta_title_id) REFERENCES liberty_meta_titles(meta_title_id); |
| +CREATE UNIQUE INDEX lib_attachment_meta_idx ON liberty_attachment_meta_data(attachment_id,meta_type_id,meta_title_id); |
| {/code}
|
| -1-FEB-2006 | liberty_content | increase lang_code size | [/xing]
|
| -SQL 92 | {code source="sql"}
|
| -ALTER TABLE liberty_content RENAME COLUMN language TO lang_code;
|
| -ALTER TABLE liberty_content ALTER language TYPE varchar(32);
|
| -{/code}
|
| -2-FEB-2006 | everything | unify table names | [/spider], [/xing]
|
| -SQL 92 | {code source="sql"}
|
| --- de-tikify articles
|
| -ALTER TABLE tiki_articles RENAME TO articles;
|
| -ALTER TABLE tiki_article_status RENAME TO article_status;
|
| -ALTER TABLE tiki_article_topics RENAME TO article_topics;
|
| -ALTER TABLE tiki_article_types RENAME TO article_types;
|
| -
|
| --- de-tikify blogs
|
| -ALTER TABLE tiki_blogs RENAME TO blogs;
|
| -
|
| -ALTER TABLE tiki_blog_posts RENAME TO blog_posts;
|
| -ALTER TABLE tiki_blog_activity RENAME TO blog_activity;
|
| -ALTER TABLE tiki_blog_posts_images RENAME TO blog_posts_images;
|
| -
|
| --- de-tikify categories
|
| -ALTER TABLE tiki_categories RENAME TO categories;
|
| -ALTER TABLE tiki_categorized_objects RENAME TO categories_objects;
|
| -ALTER TABLE tiki_category_objects RENAME TO categories_objects_map;
|
| -ALTER TABLE tiki_category_sites RENAME TO categories_sites;
|
| -
|
| --- de-tikify chatterbox
|
| -ALTER TABLE bit_chatterbox RENAME TO chatterbox;
|
| -
|
| --- de-tikify events
|
| -ALTER TABLE bit_events RENAME TO events;
|
| -
|
| --- de-tikify fisheye
|
| -ALTER TABLE tiki_fisheye_gallery RENAME TO fisheye_gallery;
|
| -ALTER TABLE tiki_fisheye_image RENAME TO fisheye_image;
|
| -ALTER TABLE tiki_fisheye_gallery_image_map RENAME TO fisheye_gallery_image_map;
|
| -ALTER TABLE tiki_thumbnail_queue RENAME TO liberty_thumbnail_queue;
|
| -
|
| -
|
| --- galaxia does not need de-tikifying
|
| -
|
| --- de-tikify gatekeeper
|
| -ALTER TABLE tiki_security RENAME TO gatekeeper_security;
|
| -ALTER TABLE tiki_content_security_map RENAME TO gatekeeper_security_map;
|
| -
|
| --- de-tikify hotwords
|
| -ALTER TABLE tiki_hotwords RENAME TO hotwords;
|
| -
|
| --- de-tikify kernel
|
| -DROP TABLE tiki_dsn;
|
| -DROP TABLE tiki_menus;
|
| -DROP TABLE tiki_menu_options;
|
| -DROP TABLE tiki_programmed_content;
|
| -DROP TABLE tiki_content_templates;
|
| -DROP TABLE tiki_content_templates_sections;
|
| -
|
| -ALTER TABLE tiki_banning RENAME TO tidbits_banning;
|
| -ALTER TABLE tiki_banning_sections RENAME TO tidbits_banning_sections;
|
| -ALTER TABLE tiki_cookies RENAME TO tidbits_fortune_cookies;
|
| -ALTER TABLE tiki_dynamic_variables RENAME TO liberty_dynamic_variables;
|
| -ALTER TABLE tiki_layouts RENAME TO themes_layouts;
|
| -ALTER TABLE tiki_layouts_modules RENAME TO themes_layouts_modules;
|
| -ALTER TABLE tiki_mail_events RENAME TO mail_notifications;
|
| -ALTER TABLE tiki_module_map RENAME TO themes_module_map;
|
| -ALTER TABLE tiki_pageviews RENAME TO stats_pageviews;
|
| -ALTER TABLE tiki_preferences RENAME TO kernel_prefs;
|
| -ALTER TABLE tiki_user_menus RENAME TO tidbits_user_menus;
|
| -
|
| -
|
| --- de-tikify languages
|
| -ALTER TABLE tiki_i18n_languages RENAME TO i18n_languages;
|
| -ALTER TABLE tiki_i18n_masters RENAME TO i18n_masters;
|
| -ALTER TABLE tiki_i18n_strings RENAME TO i18n_strings;
|
| -ALTER TABLE tiki_i18n_version_map RENAME TO i18n_version_map;
|
| -
|
| -
|
| --- de-tikify liberty
|
| -ALTER TABLE tiki_content RENAME TO liberty_content;
|
| -ALTER TABLE tiki_attachments RENAME TO liberty_attachments;
|
| -ALTER TABLE tiki_files RENAME TO liberty_files;
|
| -ALTER TABLE tiki_structures RENAME TO liberty_structures;
|
| -ALTER TABLE tiki_comments RENAME TO liberty_comments;
|
| -ALTER TABLE tiki_plugins RENAME TO liberty_plugins;
|
| -ALTER TABLE tiki_content_types RENAME TO liberty_content_types;
|
| -ALTER TABLE tiki_link_cache RENAME TO liberty_link_cache;
|
| -
|
| -
|
| --- de-tikify messages
|
| -ALTER TABLE messu_messages RENAME TO messages;
|
| -
|
| -ALTER TABLE messu_system_message_map RENAME TO messages_system_map;
|
| -
|
| --- de-tikify multisites
|
| -ALTER TABLE tiki_multisites RENAME TO multisites;
|
| -ALTER TABLE tiki_multisite_preferences RENAME TO multisite_preferences;
|
| -
|
| --- de-tikify newsletters
|
| -ALTER TABLE tiki_newsletters RENAME TO newsletters;
|
| -ALTER TABLE tiki_newsletters_editions RENAME TO newsletters_editions;
|
| -ALTER TABLE tiki_mail_subscriptions RENAME TO mail_subscriptions;
|
| -ALTER TABLE tiki_mail_errors RENAME TO mail_errors;
|
| -ALTER TABLE tiki_mail_mailings RENAME TO mail_mailings;
|
| -ALTER TABLE tiki_mail_queue RENAME TO mail_queue;
|
| -
|
| --- de-tikify nexus
|
| -ALTER TABLE tiki_nexus_plugins RENAME TO nexus_plugins;
|
| -ALTER TABLE tiki_nexus_menus RENAME TO nexus_menus;
|
| -ALTER TABLE tiki_nexus_menu_items RENAME TO nexus_menu_items;
|
| -
|
| --- de-tikify pigeonholes
|
| -ALTER TABLE bit_pigeonholes RENAME TO pigeonholes;
|
| -ALTER TABLE bit_pigeonhole_members RENAME TO pigeonhole_members;
|
| -ALTER TABLE bit_pigeonhole_settings RENAME TO pigeonhole_settings;
|
| -
|
| --- de-tikify quicktags
|
| -ALTER TABLE tiki_quicktags RENAME TO quicktags;
|
| -
|
| --- de-tikify quota
|
| -ALTER TABLE tiki_quotas RENAME TO quotas;
|
| -ALTER TABLE tiki_quotas_group_map RENAME TO quotas_group_map;
|
| -
|
| --- de-tikify rss
|
| -ALTER TABLE tiki_rss_feeds RENAME TO rss_feeds;
|
| -ALTER TABLE tiki_rss_modules RENAME TO rss_modules;
|
| -
|
| --- de-tikify shoutbox
|
| -ALTER TABLE tiki_shoutbox RENAME TO shoutbox;
|
| -
|
| --- de-tikify stats
|
| -
|
| -ALTER TABLE tiki_referer_stats RENAME TO stats_referers;
|
| -
|
| --- de-tikify stickies
|
| -ALTER TABLE tiki_stickies RENAME TO stickies;
|
| -
|
| --- de-tikify themes
|
| -ALTER TABLE tiki_theme_control_categs RENAME TO theme_control_categs;
|
| -ALTER TABLE tiki_theme_control_sections RENAME TO theme_control_sections;
|
| -ALTER TABLE tiki_theme_control_objects RENAME TO theme_control_objects;
|
| -ALTER TABLE tiki_user_modules RENAME TO themes_custom_modules;
|
| -
|
| --- de-tikify users
|
| -DROP TABLE tiki_sessions;
|
| -ALTER TABLE users_objectpermissions RENAME TO users_object_permissions;
|
| -ALTER TABLE users_grouppermissions RENAME TO users_group_permissions;
|
| -ALTER TABLE tiki_semaphores RENAME TO users_semaphores;
|
| -ALTER TABLE tiki_user_watches RENAME TO users_watches;
|
| -ALTER TABLE tiki_user_votings RENAME TO tidbits_votings;
|
| -ALTER TABLE tiki_user_tasks RENAME TO tidbits_tasks;
|
| -ALTER TABLE tiki_user_postings RENAME TO tidbits_postings;
|
| -ALTER TABLE tiki_user_bookmarks_urls RENAME TO tidbits_bookmarks_urls;
|
| -ALTER TABLE tiki_user_bookmarks_folders RENAME TO tidbits_bookmarks_folders;
|
| -ALTER TABLE tiki_userpoints RENAME TO tidbits_points;
|
| -DROP TABLE tiki_userfiles;
|
| -
|
| --- de-tikify wiki
|
| -ALTER TABLE tiki_pages RENAME TO wiki_pages;
|
| -ALTER TABLE tiki_extwiki RENAME TO wiki_ext;
|
| -ALTER TABLE tiki_received_pages RENAME TO wiki_received_pages;
|
| -ALTER TABLE tiki_tags RENAME TO wiki_tags;
|
| -ALTER TABLE tiki_copyrights RENAME TO liberty_copyrights;
|
| -ALTER TABLE tiki_actionlog RENAME TO wiki_action_log;
|
| -ALTER TABLE tiki_page_footnotes RENAME TO wiki_footnotes;
|
| -ALTER TABLE tiki_history RENAME TO liberty_content_history;
|
| -ALTER TABLE tiki_links RENAME TO liberty_content_links;
|
| -{/code}
|
| -1-FEB-2006 | everything | rename non-table objects such as sequences and indices | [/spider]
|
| -Postgesql |^[/storage/detikify_objects.sql|detikify_objects.sql]^
|
| -SQL92 | {code source="sql"}
|
| --- Different database use different technique to rename these things. If you can send use some SQL to alter your db, please email to spider @ viovio . com . postgres users - please look at entry above first.
|
| --- sequences:
|
| -tiki_security_id_seq => gatekeeper_id_seq
|
| -tiki_content_id_seq => liberty_content_id_seq
|
| -tiki_comments_comment_id_seq => liberty_comments_id_seq
|
| -tiki_files_file_id_seq => liberty_files_id_seq
|
| -tiki_attachments_id_seq => liberty_attachments_id_seq
|
| -tiki_structures_id_seq => liberty_structures_id_seq
|
| -tiki_stickies_sticky_id_seq => stickies_sticky_id_seq
|
| -tiki_pages_page_id_seq => wiki_pages_page_id_seq
|
| -
|
| --- indeces
|
| -tiki_security_user_idx => gatekeeper_security_user_idx
|
| -tiki_consec_security_idx => gatekeeper_consec_security_idx
|
| -tiki_consec_content_idx => gatekeeper_consec_content_idx
|
| -{/code}
|
| -29-JAN-2006 | users / liberty | generalize tiki_user_preferences to liberty_content_prefs | [/spiderr]
|
| -SQL 92 | {code source="sql"}
|
| -ALTER TABLE tiki_user_preferences RENAME TO liberty_content_prefs;
|
| -ALTER TABLE liberty_content_prefs RENAME pref_name TO name;
|
| -ALTER TABLE liberty_content_prefs ADD content_id INT;
|
| -UPDATE liberty_content_prefs SET content_id = (SELECT tc.content_id FROM tiki_content tc INNER JOIN users_users uu ON(tc.content_id=uu.content_id) WHERE uu.user_id=liberty_content_prefs.user_id );
|
| -ALTER TABLE liberty_content_prefs DROP user_id;
|
| -{/code}
|
| -25-JAN-2006 | articles | shorten names of sequence generators | lsces
|
| -PHP UPDATE: |{code source="PHP"}
|
| -global $gBitSystem;
|
| -$current = $gBitSystem->mDb->GenID( "tiki_article_topics_topic_id_seq" );
|
| -$gBitSystem->mDb->DropSequence( "tiki_article_topics_topic_id_seq");
|
| -$gBitSystem->mDb->CreateSequence( "tiki_article_topics_t_id_seq", $current );
|
| -$current = $gBitSystem->mDb->GenID( "tiki_article_types_article_type_id_seq" );
|
| -$gBitSystem->mDb->DropSequence( "tiki_article_types_article_type_id_seq");
|
| -$gBitSystem->mDb->CreateSequence( "tiki_article_types_a_t_id_seq", $current );
|
| -{/code}
|
| -23-JAN-2006 | tiki_content | add timestamps for hits and events | lsces
|
| -Sql92 UPDATE: |{code source="sql"}
|
| -ALTER TABLE tiki_content ADD last_hit INT8;
|
| -ALTER TABLE tiki_content ADD event_time INT8;
|
| -UPDATE tiki_content SET last_hit = last_modified;
|
| -{/code}
|
| -23-JAN-2006 | bit_pigeonholes_members | drop custom positioning of items | xing
|
| -Sql92 UPDATE: |{code source="sql"}
|
| -ALTER TABLE bit_pigeonhole_members DROP COLUMN pos;
|
| -{/code}
|
| -23-JAN-2006 | users_favorites_map | New favorites map to flag favorite content | spiderr
|
| -Sql92 UPDATE: |{code source="sql"}
|
| -CREATE TABLE users_favorites_map ( favorite_content_id INT4 NOT NULL, user_id INT4 NOT NULL, PRIMARY KEY (favorite_content_id, user_id) ) ;
|
| -CREATE INDEX users_fav_con_idx ON users_favorites_map (favorite_content_id) ;
|
| -CREATE INDEX users_fav_user_idx ON users_favorites_map (user_id)
|
| -{/code}
|
| -23-JAN-2006 | messu_system_message_map | MessuPackage updates for system messages and group_id sending to enable mass scaling | spiderr
|
| -Sql92 UPDATE: |{code source="sql"}
|
| -CREATE TABLE messu_system_message_map ( msg_id INT NOT NULL, to_user_id INT NOT NULL, is_read VARCHAR(1), is_flagged VARCHAR(1), is_replied VARCHAR(1), priority INT, is_hidden VARCHAR(1), CONSTRAINT tiki_messu_sys_message_ref FOREIGN KEY (msg_id) REFERENCES messu_messages (msg_id), CONSTRAINT tiki_messu_sys_to_user_ref FOREIGN KEY (to_user_id) REFERENCES users_users (user_id) );
|
| -ALTER TABLE messu_messages ADD COLUMN group_id INT;
|
| +10-MAY-2008 | liberty | add a liberty_attachment_prefs table | [/xing] |
| +SQL92|{code source=SQL} |
| +CREATE TABLE liberty_attachment_prefs ( |
| + attachment_id INT, |
| + pref_name VARCHAR(40), |
| + pref_value VARCHAR(250) |
| +); |
| +CREATE UNIQUE INDEX liberty_att_prefs_att_name_idx ON liberty_attachment_prefs(attachment_id,pref_name); |
| +CREATE INDEX liberty_att_prefs_att_idx ON liberty_attachment_prefs(attachment_id); |
| +ALTER TABLE liberty_attachment_prefs ADD CONSTRAINT lib_att_prefs_content_ref FOREIGN KEY (attachment_id) REFERENCES liberty_attachments(attachment_id); |
| {/code}
|
| ||
|
| -
|
| -! code upgrade script
|
| -if you have your own package running on R1, you can use this simple script to make the appropriate changes in the code. just download the script, backup the pacakge, place this script inside your package and run it. it will rename tables and preferences to be in accordance with R2. there is __no guarantee__ that this script will keep your code in tact, so please make sure you have a copy of your code somewhere! you can get the file [/storage/R1-to-R2.sh.txt|here]
|
| - |