[Comoblog-commit] comoblog/_install/upgrades 1.1_to_1.2.xml,1.2,1.3
Status: Inactive
Brought to you by:
markwallis
|
From: Mark W. \(a. serialmonkey\) <mar...@us...> - 2006-02-21 06:46:45
|
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> |