php-blog-cvs

[Joseph T. <jt...@us...>]

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

Modified Files:
	db_update_0.6_0.6.1_postgres.sql 
Log Message:
update from 0.6 to 0.6.1 now works for postgresql

Index: db_update_0.6_0.6.1_postgres.sql
===================================================================
RCS file: /cvsroot/php-blog/serendipity/sql/db_update_0.6_0.6.1_postgres.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- db_update_0.6_0.6.1_postgres.sql	11 Apr 2004 04:29:55 -0000	1.1
+++ db_update_0.6_0.6.1_postgres.sql	11 Apr 2004 05:03:27 -0000	1.2
@@ -1,20 +1,22 @@
-ALTER TABLE {PREFIX}authors ADD userlevel INT(4);
+
+ALTER TABLE {PREFIX}authors ADD userlevel SMALLINT;
 ALTER TABLE {PREFIX}authors ALTER COLUMN userlevel SET DEFAULT '0';
 UPDATE {PREFIX}authors SET userlevel = 255 WHERE authorid = 1;
 UPDATE {PREFIX}authors SET userlevel = 1 WHERE authorid > 1;
 
-ALTER TABLE {PREFIX}config  ADD COLUMN authorid  INT 
+ALTER TABLE {PREFIX}config  ADD COLUMN authorid  INT;
+UPDATE {PREFIX}config SET authorid=0;
 ALTER TABLE {PREFIX}config  ALTER COLUMN authorid SET NOT NULL;
 ALTER TABLE {PREFIX}config  ALTER COLUMN authorid SET DEFAULT '0';
-ALTER TABLE {PREFIX}config  ADD INDEX (authorid);
+CREATE INDEX config_authorid ON {PREFIX}config (authorid);
 
-ALTER TABLE {PREFIX}config  DROP PRIMARY KEY;
+ALTER TABLE {PREFIX}config  DROP CONSTRAINT {PREFIX}config_pkey;
 ALTER TABLE {PREFIX}config  ADD PRIMARY KEY (name, authorid);
 
 ALTER TABLE {PREFIX}plugins  ADD COLUMN authorid  INT;
 ALTER TABLE {PREFIX}plugins  ALTER COLUMN authorid SET DEFAULT '0';
-ALTER TABLE {PREFIX}plugins  ADD INDEX (authorid);
+CREATE INDEX plugins_authorid ON {PREFIX}plugins (authorid);
 
 ALTER TABLE {PREFIX}images  ADD COLUMN authorid  INT;
 ALTER TABLE {PREFIX}images  ALTER COLUMN authorid SET DEFAULT '0';
-ALTER TABLE {PREFIX}images  ADD INDEX (authorid);
+CREATE INDEX images_authorid ON {PREFIX}images (authorid);