install/schemas/upgrade/1.1.6-1.1.7-mysql.sql
changeset 1175 1e2c9819ede3
parent 1170 71cb87b7dc3f
--- a/install/schemas/upgrade/1.1.6-1.1.7-mysql.sql	Fri Dec 18 09:39:18 2009 -0500
+++ b/install/schemas/upgrade/1.1.6-1.1.7-mysql.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 mediumint(8) NOT NULL DEFAULT 1;
+UPDATE {{TABLE_PREFIX}}logs SET author_uid = 1;