[vhffs-dev] [1183] set NOT NULL to allowpop and allowimap columns

[subversion@xxxxxxxxxxxxx]

Revision: 1183
Author:   gradator
Date:     2008-04-03 00:00:59 +0200 (Thu, 03 Apr 2008)

Log Message:
-----------
set NOT NULL to allowpop and allowimap columns

Modified Paths:
--------------
    trunk/vhffs-backend/src/pgsql/initdb.sql.in


Modified: trunk/vhffs-backend/src/pgsql/initdb.sql.in
===================================================================
--- trunk/vhffs-backend/src/pgsql/initdb.sql.in	2008-04-02 21:56:40 UTC (rev 1182)
+++ trunk/vhffs-backend/src/pgsql/initdb.sql.in	2008-04-02 22:00:59 UTC (rev 1183)
@@ -151,9 +151,9 @@
 -- Is antivirus activated?
 	novirus boolean,
 -- Allow pop login ?
-	allowpop boolean,
+	allowpop boolean NOT NULL,
 -- Allow imap login ?
-	allowimap boolean,
+	allowimap boolean NOT NULL,
 -- State of the box (we don't have object for this entity...)
 	state int4 NOT NULL,
 	CONSTRAINT vhffs_boxes_pkey PRIMARY KEY (domain,local_part)