Index: branches/stable/cgi-bin/ipdb.psql
===================================================================
--- branches/stable/cgi-bin/ipdb.psql	(revision 56)
+++ branches/stable/cgi-bin/ipdb.psql	(revision 59)
@@ -5,5 +5,5 @@
 
 --
--- TOC Entry ID 9 (OID 16556)
+-- TOC Entry ID 18 (OID 16556)
 --
 -- Name: "plpgsql_call_handler" () Type: FUNCTION Owner: postgres
@@ -13,5 +13,5 @@
 
 --
--- TOC Entry ID 10 (OID 16557)
+-- TOC Entry ID 19 (OID 16557)
 --
 -- Name: plpgsql Type: PROCEDURAL LANGUAGE Owner: 
@@ -40,5 +40,15 @@
 
 --
--- TOC Entry ID 3 (OID 25854)
+-- TOC Entry ID 3 (OID 25848)
+--
+-- Name: allocations Type: ACL Owner: 
+--
+
+REVOKE ALL on "allocations" from PUBLIC;
+GRANT ALL on "allocations" to "kdeugau";
+GRANT ALL on "allocations" to "ipdb";
+
+--
+-- TOC Entry ID 4 (OID 25854)
 --
 -- Name: customers Type: TABLE Owner: ipdb
@@ -61,20 +71,15 @@
 
 --
--- TOC Entry ID 4 (OID 25860)
---
--- Name: freeblocks Type: TABLE Owner: ipdb
---
-
-CREATE TABLE "freeblocks" (
-	"cidr" cidr DEFAULT '255.255.255.255/32' NOT NULL,
-	"maskbits" integer DEFAULT 128,
-	"city" character varying(30) DEFAULT '',
-	"routed" character(1) DEFAULT 'n',
-	CHECK (((routed = 'y'::bpchar) OR (routed = 'n'::bpchar))),
-	Constraint "freeblocks_pkey" Primary Key ("cidr")
-);
-
---
--- TOC Entry ID 5 (OID 25866)
+-- TOC Entry ID 5 (OID 25854)
+--
+-- Name: customers Type: ACL Owner: 
+--
+
+REVOKE ALL on "customers" from PUBLIC;
+GRANT ALL on "customers" to "kdeugau";
+GRANT ALL on "customers" to "ipdb";
+
+--
+-- TOC Entry ID 6 (OID 25866)
 --
 -- Name: poolips Type: TABLE Owner: ipdb
@@ -89,5 +94,5 @@
 	"available" character(1) DEFAULT 'y',
 	"notes" text,
-	CHECK ((((ptype = 'c'::bpchar) OR (ptype = 'd'::bpchar)) OR (ptype = 's'::bpchar))),
+	"description" character varying(64) DEFAULT '',
 	CHECK (((available = 'y'::bpchar) OR (available = 'n'::bpchar))),
 	Constraint "poolips_pkey" Primary Key ("ip")
@@ -95,5 +100,15 @@
 
 --
--- TOC Entry ID 6 (OID 25872)
+-- TOC Entry ID 7 (OID 25866)
+--
+-- Name: poolips Type: ACL Owner: 
+--
+
+REVOKE ALL on "poolips" from PUBLIC;
+GRANT ALL on "poolips" to "kdeugau";
+GRANT ALL on "poolips" to "ipdb";
+
+--
+-- TOC Entry ID 8 (OID 25872)
 --
 -- Name: masterblocks Type: TABLE Owner: ipdb
@@ -106,5 +121,15 @@
 
 --
--- TOC Entry ID 7 (OID 25875)
+-- TOC Entry ID 9 (OID 25872)
+--
+-- Name: masterblocks Type: ACL Owner: 
+--
+
+REVOKE ALL on "masterblocks" from PUBLIC;
+GRANT ALL on "masterblocks" to "kdeugau";
+GRANT ALL on "masterblocks" to "ipdb";
+
+--
+-- TOC Entry ID 10 (OID 25875)
 --
 -- Name: routed Type: TABLE Owner: ipdb
@@ -119,5 +144,15 @@
 
 --
--- TOC Entry ID 8 (OID 31131)
+-- TOC Entry ID 11 (OID 25875)
+--
+-- Name: routed Type: ACL Owner: 
+--
+
+REVOKE ALL on "routed" from PUBLIC;
+GRANT ALL on "routed" to "kdeugau";
+GRANT ALL on "routed" to "ipdb";
+
+--
+-- TOC Entry ID 12 (OID 31131)
 --
 -- Name: temp Type: TABLE Owner: ipdb
@@ -128,2 +163,54 @@
 );
 
+--
+-- TOC Entry ID 13 (OID 31131)
+--
+-- Name: temp Type: ACL Owner: 
+--
+
+REVOKE ALL on "temp" from PUBLIC;
+GRANT ALL on "temp" to "kdeugau";
+GRANT ALL on "temp" to "ipdb";
+
+--
+-- TOC Entry ID 14 (OID 73917)
+--
+-- Name: searchme Type: VIEW Owner: ipdb
+--
+
+CREATE VIEW "searchme" as SELECT allocations.cidr, allocations.custid, allocations."type", allocations.city, allocations.description FROM allocations UNION SELECT poolips.ip, poolips.custid, poolips.ptype, poolips.city, poolips.description FROM poolips;
+
+--
+-- TOC Entry ID 15 (OID 73917)
+--
+-- Name: searchme Type: ACL Owner: 
+--
+
+REVOKE ALL on "searchme" from PUBLIC;
+GRANT ALL on "searchme" to "kdeugau";
+GRANT ALL on "searchme" to "ipdb";
+
+--
+-- TOC Entry ID 16 (OID 91065)
+--
+-- Name: freeblocks Type: TABLE Owner: ipdb
+--
+
+CREATE TABLE "freeblocks" (
+	"cidr" cidr DEFAULT '255.255.255.255/32' NOT NULL,
+	"maskbits" integer DEFAULT 128,
+	"city" character varying(30) DEFAULT '',
+	"routed" character(1) DEFAULT 'n',
+	Constraint "freeblocks_pkey" Primary Key ("cidr")
+);
+
+--
+-- TOC Entry ID 17 (OID 91065)
+--
+-- Name: freeblocks Type: ACL Owner: 
+--
+
+REVOKE ALL on "freeblocks" from PUBLIC;
+GRANT ALL on "freeblocks" to "kdeugau";
+GRANT ALL on "freeblocks" to "ipdb";
+