comoblog-commit

[Mark W. \(a. serialmonkey\) <mar...@us...>]

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

Modified Files:
	1.1_to_1.2.xml 
Log Message:
Upgrade to 1.2 script fixes. Adds in missing tags table and posts column.

Index: 1.1_to_1.2.xml
===================================================================
RCS file: /cvsroot/comoblog/comoblog/_install/upgrades/1.1_to_1.2.xml,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- 1.1_to_1.2.xml	21 Feb 2006 06:39:12 -0000	1.2
+++ 1.1_to_1.2.xml	21 Feb 2006 06:46:42 -0000	1.3
@@ -8,7 +8,15 @@
    </dbquery>
 
    <dbquery> 
-	ALTER TABLE `comoblog_comments` ADD `comment_author_url` VARCHAR( 128 ) NOT NULL AFTER `comment_author_email` ;
+	ALTER TABLE comoblog_comments ADD comment_author_url VARCHAR( 128 ) NOT NULL AFTER comment_author_email;
+   </dbquery>
+
+   <dbquery>
+	ALTER TABLE comoblog_posts ADD post_tags varchar(255) default NULL AFTER topic_id;
+   </dbquery> 
+
+   <dbquery>
+	CREATE TABLE comoblog_tags (tag_id int(10) unsigned NOT NULL auto_increment, tag_keyword varchar(64) default NULL, tag_name varchar(63) default NULL, tag_description varchar(255) default NULL, img_id int(10) unsigned default NULL, PRIMARY KEY (tag_id), KEY (tag_keyword));
    </dbquery>
 
    <dbquery>