install/schemas/postgresql_stage2.sql
changeset 468 194a19711346
parent 436 242353360e37
child 499 6b7fdd898ba3
--- 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(