History of SchemaChangelog

Version 314

SchemaChangelog

log of data base changes made to officially released packages

Created by: xing, Last modification: 13 Nov 2008 (10:13 UTC) by xing

bitweaver ReleaseTwo Schema changes


This is an ongoing list of any changes to any DataDict array in a schema_inc in any package (except: 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. 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.

Due to the length of this page, we have split it in two, please consult ReleaseTwoSchemaChangeLog1 for older changes.
For older schema changes, please visit:

DateTableReasonWho
13-NOV-2008 wiki Drop unused wiki tables /xing
SQL92

Drop unused wiki tables


DROP TABLE wiki_received_pages;
DROP TABLE wiki_tags;
DROP TABLE wiki_ext;
12-NOV-2008 liberty fix column types /SpOOnman
SQL92

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;
14-AUG-2008 gmap update icon table to have a theme_id association /wjames5
SQL92

longer maptype descriptions.


ALTER TABLE gmaps_maptypes ALTER COLUMN description TYPE TEXT;
--mysql use:
ALTER TABLE gmaps_maptypes CHANGE description description TEXT;
14-AUG-2008 gmap update icon table to have a theme_id association /wjames5
SQL92

Add theme_id


ALTER TABLE gmaps_icon_styles ADD COLUMN theme_id INT4 NOT NULL;

-- 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);
23-MAY-2008 liberty replace old unused meta tables with new ones /xing
SQL92

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;

-- 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);
10-MAY-2008 liberty add a liberty_attachment_prefs table /xing
SQL92

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

Page History
Date/CommentUserIPVersion
21 Apr 2010 (15:51 UTC)
spiderr24.171.168.221329
Current • Source
spiderr24.171.168.223328
View • Compare • Difference • Source
spiderr69.134.250.112327
View • Compare • Difference • Source
spiderr69.134.250.112326
View • Compare • Difference • Source
spiderr69.134.250.112325
View • Compare • Difference • Source
Tyler Bello69.134.250.112324
View • Compare • Difference • Source
Tyler Bello69.134.250.112323
View • Compare • Difference • Source
Tyler Bello69.134.250.112322
View • Compare • Difference • Source
Daniel Sutcliffe71.161.102.6321
View • Compare • Difference • Source
Lester Caine81.138.11.136320
View • Compare • Difference • Source
spiderr71.77.29.231319
View • Compare • Difference • Source
spiderr71.77.29.231317
View • Compare • Difference • Source
spiderr71.77.29.231316
View • Compare • Difference • Source
xing62.47.247.26315
View • Compare • Difference • Source
xing62.47.247.26314
View • Compare • Difference • Source
xing62.47.247.26313
View • Compare • Difference • Source
SpOOnman83.143.43.103312
View • Compare • Difference • Source
xing62.47.234.56309
View • Compare • Difference • Source
xing62.47.234.56308
View • Compare • Difference • Source
Will69.203.72.161307
View • Compare • Difference • Source
Will69.203.72.161306
View • Compare • Difference • Source
Will69.203.72.161305
View • Compare • Difference • Source
Will69.203.72.161304
View • Compare • Difference • Source
Lester Caine81.138.11.136303
View • Compare • Difference • Source
xing194.152.164.45302
View • Compare • Difference • Source
xing194.152.164.45301
View • Compare • Difference • Source