| -! 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} |
|
|
| -Due to the length of this page, we have split it in two, please consult ReleaseTwoSchemaChangeLog1 for older changes.
|
| +! bitweaver ((ReleaseTwo)) Schema changes |
|
|
| -|| __::Date::__ | __::Table::__ | __::Reason::__ | __::Who::__
|
| -16-FEB-2007 | liberty_thumbnail_queue | move liberty_thumbnail_queue from fisheye schema_inc.php to liberty, and add processor and processor_parameters columns to liberty_thumbnail_queue for future flexibility | [/spider]
|
| - SQL92 | {code source=SQL}
|
| -ALTER TABLE liberty_thumbnail_queue ADD processor VARCHAR(250);
|
| -ALTER TABLE liberty_thumbnail_queue ADD processor_parameters VARCHAR(250);
|
| +^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|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}
|
| -16-JAN-2007 | kernel_config | update config names to tie in with the rest of bitweaver | [/xing]
|
| - SQL92 | {code source=SQL}
|
| -UPDATE kernel_config SET config_name='i18n_browser_languages' WHERE config_name='browser_languages';
|
| -UPDATE kernel_config SET config_name='i18n_interactive_translation' WHERE config_name='interactive_translation';
|
| -UPDATE kernel_config SET config_name='i18n_interactive_bittranslation' WHERE config_name='interactive_bittranslation';
|
| -UPDATE kernel_config SET config_name='i18n_record_untranslated' WHERE config_name='languages_record_untranslated';
|
| -UPDATE kernel_config SET config_name='i18n_track_translation_usage' WHERE config_name='track_translation_usage';
|
| +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}
|
| -13-OCT-2006 | liberty | Aliases for liberty content modified to allow composite primary key | [/lsces]
|
| - SQL92 | {code source=SQL}
|
| -CREATE TABLE liberty_aliases( content_id INT NOT NULL, alias_title VARCHAR(190), CONSTRAINT liberty_aliases_content_fkey FOREIGN KEY (content_id) REFERENCES liberty_content(content_id) );
|
| +|| |
| + |
| +* ((ReleaseTwo Schema Changelog 2007)) |
| +* ((ReleaseTwo Schema Changelog 2006)) |
| + |
| +||~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}
|
| -11-OCT-2006 | nexus_plugins | NexusPackage cleanup | [/xing]
|
| - SQL92 | {code source=SQL}
|
| -DROP TABLE nexus_plugins;
|
| +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}
|
| -11-OCT-2006 | nexus_plugins | NexusPackage cleanup | [/xing]
|
| - SQL92 | {code source=SQL}
|
| -DROP TABLE nexus_plugins;
|
| +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}
|
| -11-OCT-2006 | liberty_meta_data | LibertyPackage meta data tables - can be used for Fisheye EXIF, etc. | [/spider]
|
| - SQL92 | {code source=SQL}
|
| -CREATE TABLE liberty_meta_types( meta_type_guid VARCHAR(16) PRIMARY KEY, meta_type_title VARCHAR(250) );
|
| -CREATE TABLE liberty_meta_data ( content_id INT NOT NULL, meta_type_guid VARCHAR(16) NOT NULL, meta_key VARCHAR(250) NOT NULL, meta_title VARCHAR(250) NOT NULL, meta_value_short VARCHAR(250), meta_value_long TEXT, CONSTRAINT liberty_meta_content_ref FOREIGN KEY (content_id) REFERENCES liberty_content(content_id), CONSTRAINT liberty_meta_guid_ref FOREIGN KEY (meta_type_guid) REFERENCES liberty_meta_types(meta_type_guid) );
|
| +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}
|
| -11-OCT-2006 | blogs | Convert Blogs to Content | [/spider]
|
| - SQL92 | {code source=SQL}
|
| -INSERT INTO liberty_content_types (content_type_guid, content_description, maintainer_url, handler_class, handler_package, handler_file) VALUES ('bitblog', 'Blog', 'http://www.bitweaver.org', 'BitBlog', 'blogs', 'BitBlog.php');
|
| -ALTER TABLE blogs ADD content_id INT;
|
| -UPDATE blogs SET content_id = nextval('liberty_content_id_seq');
|
| -INSERT INTO liberty_content (content_id, title, data, created, last_modified, user_id, modifier_user_id, format_guid, content_type_guid, content_status_id) (SELECT content_id, title, description, created, last_modified, user_id, user_id, 'tikiwiki', 'bitblog', 50 FROM blogs);
|
| -INSERT INTO liberty_content_hits (content_id, hits) (SELECT content_id,hits FROM blogs);
|
| -ALTER TABLE blogs RENAME public_blog TO is_public;
|
| -ALTER TABLE blogs DROP title;
|
| -ALTER TABLE blogs DROP description;
|
| -ALTER TABLE blogs DROP created;
|
| -ALTER TABLE blogs DROP last_modified;
|
| -ALTER TABLE blogs DROP user_id;
|
| -ALTER TABLE blogs DROP hits;
|
| -ALTER TABLE blogs ADD CONSTRAINT blogs_content_id_ref FOREIGN KEY (content_id) REFERENCES liberty_content(content_id);
|
| -ALTER TABLE blogs ALTER content_id SET NOT NULL;
|
| +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}
|
| -06-OCT-2006 | liberty | Aliases for liberty content | [/spider]
|
| - SQL92 | {code source=SQL}
|
| -CREATE TABLE liberty_aliases( alias_name VARCHAR(250), content_id INT NOT NULL, CONSTRAINT liberty_aliases_content_fkey FOREIGN KEY (content_id) REFERENCES liberty_content(content_id) );
|
| +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}
|
| -20-SEP-2006 | ((Liberty Content Status)) | [/spider]
|
| - SQL92 | {code source=SQL}
|
| -CREATE TABLE liberty_content_status ( content_status_id INT4 NOT NULL PRIMARY KEY, content_status_name VARCHAR(128) NOT NULL );
|
| -ALTER TABLE liberty_content ADD COLUMN content_status_id INT4;
|
| -ALTER TABLE liberty_content ADD CONSTRAINT libert_content_status_ref FOREIGN KEY (content_status_id) REFERENCES liberty_content_status(content_status_id);
|
| -INSERT INTO liberty_content_status (content_status_id,content_status_name) VALUES (-999, 'Deleted');
|
| -INSERT INTO liberty_content_status (content_status_id,content_status_name) VALUES (-998, 'Spam');
|
| -INSERT INTO liberty_content_status (content_status_id,content_status_name) VALUES (-201, 'Suspended');
|
| -INSERT INTO liberty_content_status (content_status_id,content_status_name) VALUES (-100, 'Denied');
|
| -INSERT INTO liberty_content_status (content_status_id,content_status_name) VALUES (-40, 'Private');
|
| -INSERT INTO liberty_content_status (content_status_id,content_status_name) VALUES (-30, 'Password Protected');
|
| -INSERT INTO liberty_content_status (content_status_id,content_status_name) VALUES (-20, 'Group Protected');
|
| -INSERT INTO liberty_content_status (content_status_id,content_status_name) VALUES (-10, 'Hidden');
|
| -INSERT INTO liberty_content_status (content_status_id,content_status_name) VALUES (10, 'Draft');
|
| -INSERT INTO liberty_content_status (content_status_id,content_status_name) VALUES (50, 'Available');
|
| -INSERT INTO liberty_content_status (content_status_id,content_status_name) VALUES (101, 'Pending Approval');
|
| -INSERT INTO liberty_content_status (content_status_id,content_status_name) VALUES (102, 'Commercial');
|
| -INSERT INTO liberty_content_status (content_status_id,content_status_name) VALUES (200, 'Recommended');
|
| -INSERT INTO liberty_content_status (content_status_id,content_status_name) VALUES (999, 'Copy Protected');
|
| -UPDATE liberty_content SET content_status_id=50;
|
| -ALTER TABLE liberty_content ALTER content_status_id SET NOT NULL;
|
| +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}
|
| -15-SEP-2006| LibertyPackage | clean up liberty_action_log table and make use of it in liberty | [/xing]
|
| -SQL92| {code source=SQL}
|
| -ALTER TABLE liberty_action_log RENAME COLUMN log_action TO log_message;
|
| -ALTER TABLE liberty_action_log RENAME COLUMN action_comment TO -- change column action_error to have a char length limit of 250 chars
|
| -ALTER TABLE liberty_action_log ALTER COLUMN error_message TYPE VARCHAR(250);
|
| -ALTER TABLE liberty_action_log ALTER content_id DROP NOT NULL;
|
| -{/code}
|
| -13-SEP-2006| StarsPackage| reverted to original stars version and forked version rating stars to superstars | [/xing]
|
| -Please revert all stars changes in here if you want to use bitweaver version of stars or download and use _bit_superstars
|
| -09-SEP-2006| StarsPackage| remove stars table, add update_count colums to stars_version and stars_history, add indexs to enforce unique constraints | [/jht001]
|
| -SQL 92 |{code source="sql"}
|
| -drop table stars;
|
| -ALTER TABLE stars_version ADD COLUMN update_count INT4 default 0;
|
| -ALTER TABLE stars_history ADD COLUMN update_count INT4 default 0;
|
| -ALTER TABLE stars_version ADD PRIMARY KEY(content_id,version);
|
| -ALTER TABLE stars_history ADD PRIMARY KEY(content_id,version,user_id);
|
| +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; |
| + |
| +-- 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}
|
| +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; |
|
|
| -06-SEP-2006| FisheyePackage |add image position fractional ordering to image galleries | [/spider]
|
| -SQL 92 |{code source="sql"}
|
| -ALTER TABLE fisheye_gallery_image_map RENAME item_position TO old_position;
|
| -ALTER TABLE fisheye_gallery_image_map ADD COLUMN item_position FLOAT;
|
| -UPDATE fisheye_gallery_image_map SET item_position = old_position;
|
| -ALTER TABLE fisheye_gallery_image_map DROP COLUMN old_position;
|
| +-- 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}
|
| -21-AUG-2006| UsersPackage | add password expiration | [/jht001]
|
| -SQL 92 |{code source="sql"}
|
| -ALTER TABLE users_users ADD COLUMN provpass_expires INT8;
|
| -{/code}
|
| -21-AUG-2006| StarsPackage | add perversion ratings | [/hash9]
|
| -SQL 92 |{code source="sql"}
|
| -CREATE TABLE stars_version ( content_id INTEGER NOT NULL, version INTEGER NOT NULL, rating_count INTEGER, rating INTEGER, CONSTRAINT stars_version_ref FOREIGN KEY (content_id) REFERENCES liberty_content( content_id ));
|
| -ALTER TABLE stars_history ADD COLUMN version INTEGER NOT NULL;
|
| -{/code}
|
| -18-AUG-2006| LibertyPackage | move highly volatile hits columns out of liberty_content and into a separate table | [/jht001] and [/spiderr]
|
| -SQL 92 |{code source="sql"}
|
| -CREATE TABLE liberty_content_hits ( content_id INTEGER PRIMARY KEY, hits INTEGER NOT NULL DEFAULT 1, last_hit BIGINT, CONSTRAINT liberty_content_hits_ref FOREIGN KEY (content_id) REFERENCES liberty_content( content_id ));
|
| -INSERT INTO liberty_content_hits ( content_id, hits, last_hit ) (SELECT content_id, hits, last_hit FROM liberty_content);
|
| -ALTER TABLE liberty_content DROP hits;
|
| -ALTER TABLE liberty_content DROP last_hit;
|
| -{/code}
|
| -26-JUL-2006| LibertyPackage | Add anonymous name to comments | [/Hash9]
|
| -SQL 92 |{code source="sql"}
|
| -ALTER TABLE liberty_comments ADD anon_name VARCHAR(40);
|
| -{/code}
|
| -17-JUL-2006| UsersPackage | Improve users_cnxn to record user assumption ID | [/spider]
|
| -SQL 92 |{code source="sql"}
|
| -ALTER TABLE users_cnxn ADD assume_from_user_id INT;
|
| -{/code}
|
| -10-JUL-2006| multisites | added per site content restricitions | [/nickpalmer]
|
| -CREATE| {code source="sql"}
|
| -CREATE TABLE multisite_content ( multisite_id INTEGER NOT NULL, content_id INTEGER NOT NULL , CONSTRAINT multisite_content_ref FOREIGN KEY (content_id) REFERENCES liberty_content( content_id ) , CONSTRAINT multisite_multisite_ref FOREIGN KEY (multisite_id) REFERENCES multisites( multisite_id ), PRIMARY KEY (multisite_id, content_id) );
|
| -INSERT INTO `kernel_config`(`package`,`config_name`,`config_value`) VALUES ('multisites', 'multisites_per_site_content','y');
|
| -INSERT INTO `kernel_config`(`package`,`config_name`,`config_value`) VALUES ('multisites', 'multisites_use_jstab','y');
|
| -INSERT INTO `kernel_config`(`package`,`config_name`,`config_value`) VALUES ('multistes', 'multisites_limit_member_number','10');
|
| -INSERT INTO `users_permissions` (`perm_name`, `perm_desc`, `perm_level`, `package`) VALUES ('p_multisites_restrict_content', 'Can restrict content to certain sites', 'editor', 'multisites');
|
| -INSERT INTO `users_permissions` (`perm_name`, `perm_desc`, `perm_level`, `package`) VALUES ('p_multisites_view_restricted', 'Can view all site restricted content', 'admin', 'multisites');
|
| -{/code}
|
| -12-JUN-2006| fisheye | image comment - no more useful after spider changes| [/sylvie]
|
| -SQL 92 |{code source="sql"}
|
| -OBSOLETE: ALTER TABLE fisheye_gallery ADD COLUMN image_comment VARCHAR(1);
|
| -{/code}
|
| -12-MAY-2006| shoutbox | record IP | [/spider]
|
| -SQL 92 |{code source="sql"}
|
| -ALTER TABLE shoutbox ADD COLUMN shout_ip VARCHAR(16);
|
| -{/code}
|
| -12-MAY-2006|users_permissions, users_group_permissions|p_wiki_view_history|[/sylvie]
|
| -SQL 92 |{code source="sql"}
|
| -INSERT INTO `users_permissions` (`perm_name`,`perm_desc`, `perm_level`, `package`) VALUES ('p_wiki_view_history', 'Can view page history', 'basic', 'wiki');
|
| -INSERT INTO `users_group_permissions` (`group_id`, `perm_name`) VALUES (-1,'p_wiki_view_history');
|
| -{/code}
|
| -8-MAY-2006|users_groups|to have a after registration page|[/sylvie]
|
| -SQL 92 |{code source="sql"}
|
| -ALTER TABLE users_groups ADD COLUMN after_registration_page varchar(255);
|
| -{/code}
|
| -5-MAY-2006|liberty_plugins|add plugin_path column that plugins can be kept in any directory without having to scan for them when parsing|[/xing]
|
| -SQL 92 | {code source="sql"}
|
| -ALTER TABLE liberty_plugins ADD COLUMN plugin_path varchar(250);
|
| -{/code}
|
| -5-MAY-2006|liberty_content_prefs|rename some liberty_content_prefs column for consistency|[/xing]
|
| -SQL 92 | {code source="sql"}
|
| -ALTER TABLE liberty_content_prefs RENAME COLUMN name TO pref_name;
|
| +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}
|
| ||
|
| - |