install/schemas/upgrade/1.1.4-1.1.5-postgresql.sql
changeset 688 f2a824ce5f18
parent 685 17ebe24cdf85
child 711 f70d764aab33
--- a/install/schemas/upgrade/1.1.4-1.1.5-postgresql.sql	Tue Aug 12 00:05:09 2008 -0400
+++ b/install/schemas/upgrade/1.1.4-1.1.5-postgresql.sql	Tue Aug 12 00:06:35 2008 -0400
@@ -1,2 +1,3 @@
 ALTER TABLE {{TABLE_PREFIX}}session_keys ADD COLUMN key_type smallint NOT NULL DEFAULT 0;
+UPDATE {{TABLE_PREFIX}}session_keys SET key_type = 2 WHERE auth_level > 2;