diff -r e4bbd6fb8df3 -r 194a19711346 install/schemas/postgresql_stage2.sql --- a/install/schemas/postgresql_stage2.sql Sat Mar 01 18:56:37 2008 -0500 +++ b/install/schemas/postgresql_stage2.sql Sat Mar 01 18:57:07 2008 -0500 @@ -74,7 +74,7 @@ salt varchar(32), user_id int, auth_level smallint NOT NULL DEFAULT '0', - source_ip varchar(10) DEFAULT '0x7f000001', + source_ip varchar(39) NOT NULL DEFAULT '127.0.0.1', time bigint DEFAULT '0' ); @@ -85,8 +85,8 @@ default_style varchar(63) NOT NULL DEFAULT '', enabled smallint NOT NULL DEFAULT '1', group_list text DEFAULT NULL, - group_policy varchar(5) NOT NULL DEFAULT 'deny', - CHECK (group_policy IN ('allow', 'deny')) + group_policy varchar(5) NOT NULL DEFAULT 'allow_all', + CHECK (group_policy IN ('allow_all', 'whitelist', 'blacklist')) ); CREATE TABLE {{TABLE_PREFIX}}users(