php-blog-cvs

[Garvin H. <gar...@us...>]

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

Modified Files:
	db_update_0.6_0.6.1_mysql.sql db_update_0.6_0.6.1_pgsql.sql 
Log Message:
Moved the is_up2date check to the right place.


Index: db_update_0.6_0.6.1_mysql.sql
===================================================================
RCS file: /cvsroot/php-blog/serendipity/sql/db_update_0.6_0.6.1_mysql.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- db_update_0.6_0.6.1_mysql.sql	4 Apr 2004 16:20:15 -0000	1.1
+++ db_update_0.6_0.6.1_mysql.sql	7 Apr 2004 08:17:50 -0000	1.2
@@ -2,7 +2,7 @@
 UPDATE {PREFIX}authors SET userlevel = 255 WHERE authorid = 1;
 UPDATE {PREFIX}authors SET userlevel = 1 WHERE authorid > 1;
 
-ALTER TABLE {PREFIX}config  ADD authorid  INT UNSIGNED DEFAULT '0';
+ALTER TABLE {PREFIX}config  ADD authorid  INT UNSIGNED NOT NULL DEFAULT '0';
 ALTER TABLE {PREFIX}config  ADD INDEX (authorid);
 
 ALTER TABLE {PREFIX}config  DROP PRIMARY KEY;

Index: db_update_0.6_0.6.1_pgsql.sql
===================================================================
RCS file: /cvsroot/php-blog/serendipity/sql/db_update_0.6_0.6.1_pgsql.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- db_update_0.6_0.6.1_pgsql.sql	4 Apr 2004 16:20:16 -0000	1.1
+++ db_update_0.6_0.6.1_pgsql.sql	7 Apr 2004 08:17:50 -0000	1.2
@@ -2,7 +2,7 @@
 UPDATE {PREFIX}authors SET userlevel = 255 WHERE authorid = 1;
 UPDATE {PREFIX}authors SET userlevel = 1 WHERE authorid > 1;
 
-ALTER TABLE {PREFIX}config  ADD authorid  INT UNSIGNED DEFAULT '0';
+ALTER TABLE {PREFIX}config  ADD authorid  INT UNSIGNED NOT NULL DEFAULT '0';
 CREATE INDEX authorid ON {PREFIX}config  (authorid);
 
 DROP INDEX name ON {PREFIX}config;