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 the following pages for older schema changes:
Date | Table | Reason | Who |
---|
24-MAR-2009 | multiple | Update ip columns to 39 chars for IPv6 support | /spider |
PGSQL | longer
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 semaphore 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);
OCI | longer
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 semaphore 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);
|
MYSQL | longer
ALTER TABLE users_cnxn MODIFY ip TYPE VARCHAR(39); ALTER TABLE liberty_content_history MODIFY ip TYPE VARCHAR(39);ALTER TABLE liberty_action_log MODIFY ip TYPE VARCHAR(39); ALTER TABLE semaphoe MODIFY ip TYPE VARCHAR(39); ALTER TABLE shoutbox MODIFY shout_ip TYPE VARCHAR(39); ALTER TABLE mail_queue MODIFY last_read_ip TYPE VARCHAR(39);
|
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);
|