[Comoblog-commit] comoblog/_install/upgrades 1.1_to_1.2.xml,1.1,1.2
Status: Inactive
Brought to you by:
markwallis
|
From: Mark W. \(a. serialmonkey\) <mar...@us...> - 2006-02-21 06:39:16
|
Update of /cvsroot/comoblog/comoblog/_install/upgrades In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv24018 Modified Files: 1.1_to_1.2.xml Log Message: Whitespace cleanup Index: 1.1_to_1.2.xml =================================================================== RCS file: /cvsroot/comoblog/comoblog/_install/upgrades/1.1_to_1.2.xml,v retrieving revision 1.1 retrieving revision 1.2 diff -u -d -r1.1 -r1.2 --- 1.1_to_1.2.xml 17 Feb 2006 15:16:36 -0000 1.1 +++ 1.1_to_1.2.xml 21 Feb 2006 06:39:12 -0000 1.2 @@ -4,13 +4,15 @@ <dbquery> - update comoblog_preferences set pref_value='1.2' where pref_name='CFG_VERSION'; - </dbquery> + insert into comoblog_preferences (pref_name, pref_value, pref_description, pref_topic_id, pref_encrypt, pref_type, pref_restrict_values, pref_accept_null, pref_editable, pref_display_order, mod_name) VALUES ('CFG_USE_FRIENDLY_URLS', 'no', 'use SEO friendly URLS (requires apache)', 4, 'N', 'select', 'no|yes', 'N', 'Y', 5, ''); + </dbquery> + + <dbquery> + ALTER TABLE `comoblog_comments` ADD `comment_author_url` VARCHAR( 128 ) NOT NULL AFTER `comment_author_email` ; + </dbquery> - <dbquery> - insert into comoblog_preferences (pref_name, pref_value, pref_description, pref_topic_id, pref_encrypt, pref_type, pref_restrict_values, pref_accept_null, pref_editable, pref_display_order, mod_name) VALUES ('CFG_USE_FRIENDLY_URLS', 'no', 'use SEO friendly URLS (requires apache)', 4, 'N', 'select', 'no|yes', 'N', 'Y', 5, ''); + update comoblog_preferences set pref_value='1.2' where pref_name='CFG_VERSION'; </dbquery> - <dbquery> - ALTER TABLE `comoblog_comments` ADD `comment_author_url` VARCHAR( 128 ) NOT NULL AFTER `comment_author_email` ;</dbquery> + </comoblog_upgrade> |