[Comoblog-commit] comoblog/_install comoblog_db.xml,1.5,1.6 patch_1.php,1.1,1.2

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

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

Modified Files:
	comoblog_db.xml patch_1.php 
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 
 ----------------------------------------------------------------------


Index: comoblog_db.xml
===================================================================
RCS file: /cvsroot/comoblog/comoblog/_install/comoblog_db.xml,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -d -r1.5 -r1.6
--- comoblog_db.xml	13 Nov 2005 12:35:27 -0000	1.5
+++ comoblog_db.xml	17 Feb 2006 15:16:36 -0000	1.6
@@ -7,6 +7,7 @@
       <field name="comment_text"                specs="mediumtext" />
       <field name="comment_author"              specs="varchar(128) default NULL" />
       <field name="comment_author_email"        specs="varchar(128) default NULL" />
+      <field name="comment_author_url"        specs="varchar(128) default NULL" />      
       <field name="comment_added"               specs="int(10) unsigned default NULL" />
       <field name="post_id"                     specs="int(10) unsigned NOT NULL default '0'" />
       
@@ -80,6 +81,10 @@
       <field name="post_mail_user_agent"        specs="varchar(255) default NULL" />
       <field name="topic_id"                    specs="int(10) unsigned NOT NULL default '0'" />
       
+      <field name="post_tags"        specs="varchar(255) default NULL" />
+      
+      
+      
       <pk name="post_id" />
    </table>
 
@@ -250,6 +255,19 @@
       <uk name="topic_keyword" />
    </table>
 
+   <table name="comoblog_tags">
+      <field name="tag_id"                    specs="int(10) unsigned NOT NULL auto_increment" />
+      <field name="tag_keyword"               specs="varchar(64) default NULL" />
+      <field name="tag_name"                  specs="varchar(63) default NULL" />
+      <field name="tag_description"           specs="varchar(255) default NULL" />
+      <field name="img_id"                      specs="int(10) unsigned default NULL" />
+      
+      <pk name="tag_id" />
+      <uk name="tag_keyword" />
+   </table>   
+   
+   
+   
    <table name="comoblog_trackback_pings">
       <field name="trackback_id"                specs="int(10) unsigned NOT NULL auto_increment" />
       <field name="trackback_title"             specs="varchar(255) default NULL" />

Index: patch_1.php
===================================================================
RCS file: /cvsroot/comoblog/comoblog/_install/patch_1.php,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- patch_1.php	22 Dec 2005 05:30:18 -0000	1.1
+++ patch_1.php	17 Feb 2006 15:16:36 -0000	1.2
@@ -13,6 +13,10 @@
 if ($ver = "1.0")
    $errors = run_script(dirname(__FILE__)."/upgrades/1.0_to_1.1.xml");
 
+if ($ver = "1.1")
+   $errors = run_script(dirname(__FILE__)."/upgrades/1.1_to_1.2.xml");   
+   
+   
 if (count($errors) == 0)
 {
     Header ('Location: patch_2.php');