History of SchemaChangelog

Differences from version 315 to 329



@@ -1,14 +1,81 @@

-! bitweaver ReleaseTwo Schema changes
+! bitweaver ((ReleaseThree)) Schema & Structural changes
+
+||~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}
+||
+
+* 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}
+
+! 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|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}
+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}
+||
+
 * ((ReleaseTwo Schema Changelog 2007))
 * ((ReleaseTwo Schema Changelog 2006))
 
-||~Date|Table|Reason|Who
+||~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}
+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}
+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}
+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}
 13-NOV-2008 | wiki | Drop unused wiki tables | [/xing]
 SQL92|{code source=SQL title="Drop unused wiki tables"}
 DROP TABLE wiki_received_pages;
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