[php-blog-cvs] serendipity/sql db.sql,1.11,1.12

[Justin A. <jba...@us...>]

Update of /cvsroot/php-blog/serendipity/sql
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv29134/sql

Modified Files:
	db.sql 
Log Message:
Damn!  How did I do that.

This time, make sure it's the CATEGORY table that's fixed.


Index: db.sql
===================================================================
RCS file: /cvsroot/php-blog/serendipity/sql/db.sql,v
retrieving revision 1.11
retrieving revision 1.12
diff -u -d -r1.11 -r1.12
--- db.sql	10 Jun 2004 19:34:32 -0000	1.11
+++ db.sql	10 Jun 2004 19:41:14 -0000	1.12
@@ -52,8 +52,7 @@
   categoryid int(11) default null,
   isdraft {BOOLEAN},
   allow_comments {BOOLEAN},
-  last_modified int(10) {UNSIGNED} default null,
-  parentid INT(11) DEFAULT '0' NOT NULL
+  last_modified int(10) {UNSIGNED} default null
 );
 
 CREATE {FULLTEXT} INDEX entry on {PREFIX}entries (title,body,extended);
@@ -154,7 +153,8 @@
   category_description text,
   authorid int(11) default NULL,
   category_left int(11) default '0',
-  category_right int(11) default '0'
+  category_right int(11) default '0',
+  parentid INT(11) DEFAULT '0' NOT NULL
 );
 
 CREATE TABLE {PREFIX}images (