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.
Date | Table | Reason | Who |
7-FEB-2006 | kernel_prefs | rename preferences to under_score bitweaver standard | /xing |
SQL 92 |
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'; 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='content_history' WHERE name='feature_history'; 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'
|
1-FEB-2006 | liberty_content | increase lang_code size | /xing |
SQL 92 |
ALTER TABLE liberty_content RENAME COLUMN language TO lang_code var_char(32);
|
2-FEB-2006 | everything | unify table names | /spider, /xing |
SQL 92 |
-- 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;
|
1-FEB-2006 | everything | rename non-table objects such as sequences and indices | /spider |
Postgesql | |
detikify_objects.sql |
SQL92 |
-- 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
|
29-JAN-2006 | users / liberty | generalize tiki_user_preferences to liberty_content_prefs | /spiderr |
SQL 92 |
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;
|
25-JAN-2006 | articles | shorten names of sequence generators | lsces |
PHP UPDATE: |
<?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 ); ?>
|
23-JAN-2006 | tiki_content | add timestamps for hits and events | lsces |
Sql92 UPDATE: |
ALTER TABLE tiki_content ADD last_hit INT8; ALTER TABLE tiki_content ADD event_time INT8; UPDATE tiki_content SET last_hit = last_modified;
|
23-JAN-2006 | bit_pigeonholes_members | drop custom positioning of items | xing |
Sql92 UPDATE: |
ALTER TABLE bit_pigeonhole_members DROP COLUMN pos;
|
23-JAN-2006 | users_favorites_map | New favorites map to flag favorite content | spiderr |
Sql92 UPDATE: |
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)
|
23-JAN-2006 | messu_system_message_map | MessuPackage updates for system messages and group_id sending to enable mass scaling | spiderr |
Sql92 UPDATE: |
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;
|