[Comoblog-commit] comoblog/_install/upgrades 1.1_to_1.2.xml,NONE,1.1

[iamdecal <iam...@us...>]

Update of /cvsroot/comoblog/comoblog/_install/upgrades
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv2179/_install/upgrades

Added Files:
	1.1_to_1.2.xml 
Log Message:
work towards the 1.2 release - this adds 

 url for commentors as well as an email address
-- NB may need to move exisinting data to the new row (will on my site,but not sure if thats public code or not)

 SEO friendly URLS on apache to the main site and most of the modules (optionally turned on by new config setting)


 ----------------------------------------------------------------------

 Enter Log.  Lines beginning with `CVS:' are removed automatically
 
 Committing in .
 
 Modified Files:
 	_install/comoblog_db.xml _install/patch_1.php 
 	include/libraries.inc.php lang/english.inc.php 
 	templates/add_comment.tpl.htm templates/index.tpl.htm 
 	templates/list_comments.tpl.htm 
 Added Files:
 	htaccess _install/upgrades/1.1_to_1.2.xml 
 ----------------------------------------------------------------------


--- NEW FILE: 1.1_to_1.2.xml ---
<?xml version="1.0" standalone="yes"?>

<comoblog_upgrade>


   <dbquery>
	update comoblog_preferences set pref_value='1.2' where pref_name='CFG_VERSION';
   </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, '');
   </dbquery>
  <dbquery> 
   ALTER TABLE `comoblog_comments` ADD `comment_author_url` VARCHAR( 128 ) NOT NULL AFTER `comment_author_email` ;</dbquery>
</comoblog_upgrade>