Scarab commit: svn commit: r11013 - branches/release/0.22/src/sql/upgrade/upgrade-0.22-global-booleans-to-longForm.sql
[email protected] Wed, 5 May 2010 05:18:23 -0700 (PDT)
| Newsgroups | gmane.comp.java.scarab.cvs |
|---|---|
| Message-ID | <[email protected]> |
Author: jhoech Date: 2010-05-05 05:18:22-0700 New Revision: 11013 Added: branches/release/0.22/src/sql/upgrade/upgrade-0.22-global-booleans-to-longForm.sql Log: CHG - Update script provided to change values for boolean values in table SCARAB_GLOBAL_PARAMETER in scarab's database from single characters into long form. Added: branches/release/0.22/src/sql/upgrade/upgrade-0.22-global-booleans-to-longForm.sql Url: http://scarab.tigris.org/source/browse/scarab/branches/release/0.22/src/sql/upgrade/upgrade-0.22-global-booleans-to-longForm.sql?view=markup&pathrev=11013 ============================================================================== --- (empty file) +++ branches/release/0.22/src/sql/upgrade/upgrade-0.22-global-booleans-to-longForm.sql 2010-05-05 05:18:22-0700 @@ -0,0 +1,5 @@ +/* + * Converts all short form booleans into long form for SCARAB_GLOBAL_PARAMETER. + */ +UPDATE SCARAB_GLOBAL_PARAMETER SET VALUE = 'TRUE' WHERE upper(VALUE) = 'T'; +UPDATE SCARAB_GLOBAL_PARAMETER SET VALUE = 'FALSE' WHERE upper(VALUE) = 'F'; \ No newline at end of file ------------------------------------------------------ http://scarab.tigris.org/ds/viewMessage.do?dsForumId=3577&dsMessageId=2603370