--- 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(