[php-blog-cvs] serendipity/sql db_update_0.6_0.6.1_postgres.sql,NONE,1.1

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

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

Added Files:
	db_update_0.6_0.6.1_postgres.sql 
Log Message:
update file for 0.6.1

--- NEW FILE: db_update_0.6_0.6.1_postgres.sql ---
ALTER TABLE {PREFIX}authors ADD userlevel INT(4);
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  ALTER COLUMN authorid SET NOT NULL;
ALTER TABLE {PREFIX}config  ALTER COLUMN authorid SET DEFAULT '0';
ALTER TABLE {PREFIX}config  ADD INDEX (authorid);

ALTER TABLE {PREFIX}config  DROP PRIMARY KEY;
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);

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);