History of SchemaChangelog

! 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::__
2-FEB-2006 | everything | unify table names | [/spider], [/xing]
SQL 92 | {code source="sql"}
-- not sure how to express this in SQL lingo
-- 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}
1-FEB-2006 | everything | unify table names | [/spider], [/xing]
SQL 92 | {code source="sql"}
-- de-tikify sequences

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

ALTER TABLE tiki_dynamic_variables RENAME TO liberty_dynamic_variables;

ALTER TABLE tiki_user_menus RENAME TO tidbits_user_menus;
ALTER TABLE tiki_user_modules RENAME TO tidbits_user_modules;
ALTER TABLE tiki_cookies RENAME TO tidbits_fortune_cookies;
ALTER TABLE tiki_content_templates RENAME TO themes_content_templates;
ALTER TABLE tiki_content_templates_sections RENAME TO themes_content_templates_sections;
ALTER TABLE tiki_dynamic_variables RENAME TO liberty_dynamic_variables;
ALTER TABLE tiki_pageviews RENAME TO stats_pageviews;
ALTER TABLE tiki_preferences RENAME TO kernel_prefs;
ALTER TABLE tiki_layouts RENAME TO themes_layouts;
ALTER TABLE tiki_layouts_modules RENAME TO themes_layouts_modules;
ALTER TABLE tiki_layouts_layout RENAME TO themes_layouts_layout;
ALTER TABLE tiki_banning RENAME TO tidbits_banning;
ALTER TABLE tiki_banning_sections RENAME TO tidbits_banning_sections;
ALTER TABLE tiki_mail_events RENAME TO mail_notifications;


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

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

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

-- 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 in postgres | [/spider]
Postgresql: |^[/storage/detikify_objects.sql|detikify_objects.sql]^
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;
{/code}
||