Changeset 59

Timestamp:

11/10/04 17:08:23 (20 years ago)

Author:

Kris Deugau

Message:

/branches/stable

Update IPDB schema dump from /trunk

File:

• branches/stable/cgi-bin/ipdb.psql (modified) (9 diffs)

branches/stable/cgi-bin/ipdb.psql

@@ -5 +5 @@
 
 --
--- TOC Entry ID 9 (OID 16556)
+-- TOC Entry ID 18 (OID 16556)
 --
 -- Name: "plpgsql_call_handler" () Type: FUNCTION Owner: postgres
@@ -13 +13 @@
 
 --
--- TOC Entry ID 10 (OID 16557)
+-- TOC Entry ID 19 (OID 16557)
 --
 -- Name: plpgsql Type: PROCEDURAL LANGUAGE Owner: 
@@ -40 +40 @@
 
 --
--- 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 +71 @@
 
 --
--- 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 +94 @@
         "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 +100 @@
 
 --
--- 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 +121 @@
 
 --
--- 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 +144 @@
 
 --
--- 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 +163 @@
 );
 
+--
+-- 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";
+