diff -r def792dd9b1b -r 1e2c9819ede3 install/schemas/upgrade/1.1.6-1.1.7-postgresql.sql
--- a/install/schemas/upgrade/1.1.6-1.1.7-postgresql.sql	Fri Dec 18 09:39:18 2009 -0500
+++ b/install/schemas/upgrade/1.1.6-1.1.7-postgresql.sql	Fri Dec 18 19:06:49 2009 -0500
@@ -1,4 +1,5 @@
 ALTER TABLE {{TABLE_PREFIX}}users_extra ADD COLUMN date_format varchar(32) NOT NULL DEFAULT 'F d, Y';
 ALTER TABLE {{TABLE_PREFIX}}users_extra ADD COLUMN time_format varchar(32) NOT NULL DEFAULT 'G:i';
 ALTER TABLE {{TABLE_PREFIX}}lockout ADD COLUMN username varchar(255) NOT NULL DEFAULT '';
-
+ALTER TABLE {{TABLE_PREFIX}}logs ADD COLUMN author_uid int NOT NULL DEFAULT 1;
+UPDATE {{TABLE_PREFIX}}logs SET author_uid = 1;