Changeset 34

Timestamp:

10/28/04 12:31:12 (20 years ago)

Author:

Kris Deugau

Message:

/trunk

Updated Postgres schema dump

File:

• trunk/cgi-bin/ipdb.psql (modified) (7 diffs)

trunk/cgi-bin/ipdb.psql

@@ -5 +5 @@
 
 --
--- TOC Entry ID 9 (OID 16556)
+-- TOC Entry ID 18 (OID 16559)
 --
 -- Name: "plpgsql_call_handler" () Type: FUNCTION Owner: postgres
@@ -13 +13 @@
 
 --
--- TOC Entry ID 10 (OID 16557)
+-- TOC Entry ID 19 (OID 16560)
 --
 -- Name: plpgsql Type: PROCEDURAL LANGUAGE Owner: 
@@ -23 +23 @@
 
 --
--- TOC Entry ID 2 (OID 25848)
+-- TOC Entry ID 2 (OID 16561)
 --
 -- Name: allocations Type: TABLE Owner: ipdb
@@ -40 +40 @@
 
 --
--- TOC Entry ID 3 (OID 25854)
+-- TOC Entry ID 3 (OID 16561)
+--
+-- Name: allocations Type: ACL Owner: 
+--
+
+REVOKE ALL on "allocations" from PUBLIC;
+GRANT ALL on "allocations" to "ipdb";
+GRANT ALL on "allocations" to "kdeugau";
+
+--
+-- TOC Entry ID 4 (OID 16567)
 --
 -- Name: customers Type: TABLE Owner: ipdb
@@ -61 +71 @@
 
 --
--- TOC Entry ID 4 (OID 25860)
+-- TOC Entry ID 5 (OID 16567)
+--
+-- Name: customers Type: ACL Owner: 
+--
+
+REVOKE ALL on "customers" from PUBLIC;
+GRANT ALL on "customers" to "ipdb";
+GRANT ALL on "customers" to "kdeugau";
+
+--
+-- TOC Entry ID 6 (OID 16573)
 --
 -- Name: freeblocks Type: TABLE Owner: ipdb
@@ -76 +96 @@
 
 --
--- TOC Entry ID 5 (OID 25866)
+-- TOC Entry ID 7 (OID 16573)
+--
+-- Name: freeblocks Type: ACL Owner: 
+--
+
+REVOKE ALL on "freeblocks" from PUBLIC;
+GRANT ALL on "freeblocks" to "ipdb";
+GRANT ALL on "freeblocks" to "kdeugau";
+
+--
+-- TOC Entry ID 8 (OID 16585)
+--
+-- Name: masterblocks Type: TABLE Owner: ipdb
+--
+
+CREATE TABLE "masterblocks" (
+        "cidr" cidr DEFAULT '255.255.255.255/32' NOT NULL,
+        Constraint "masterblocks_pkey" Primary Key ("cidr")
+);
+
+--
+-- TOC Entry ID 9 (OID 16585)
+--
+-- Name: masterblocks Type: ACL Owner: 
+--
+
+REVOKE ALL on "masterblocks" from PUBLIC;
+GRANT ALL on "masterblocks" to "ipdb";
+GRANT ALL on "masterblocks" to "kdeugau";
+
+--
+-- TOC Entry ID 10 (OID 16588)
+--
+-- Name: routed Type: TABLE Owner: ipdb
+--
+
+CREATE TABLE "routed" (
+        "cidr" cidr DEFAULT '255.255.255.255/32' NOT NULL,
+        "maskbits" integer DEFAULT 128,
+        "city" character varying(30) DEFAULT '',
+        Constraint "routed_pkey" Primary Key ("cidr")
+);
+
+--
+-- TOC Entry ID 11 (OID 16588)
+--
+-- Name: routed Type: ACL Owner: 
+--
+
+REVOKE ALL on "routed" from PUBLIC;
+GRANT ALL on "routed" to "ipdb";
+GRANT ALL on "routed" to "kdeugau";
+
+--
+-- TOC Entry ID 12 (OID 16594)
+--
+-- Name: temp Type: TABLE Owner: ipdb
+--
+
+CREATE TABLE "temp" (
+        "ofs" integer
+);
+
+--
+-- TOC Entry ID 13 (OID 16594)
+--
+-- Name: temp Type: ACL Owner: 
+--
+
+REVOKE ALL on "temp" from PUBLIC;
+GRANT ALL on "temp" to "ipdb";
+GRANT ALL on "temp" to "kdeugau";
+
+--
+-- TOC Entry ID 14 (OID 16598)
+--
+-- 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 16598)
+--
+-- Name: searchme Type: ACL Owner: 
+--
+
+REVOKE ALL on "searchme" from PUBLIC;
+GRANT ALL on "searchme" to "ipdb";
+GRANT ALL on "searchme" to "kdeugau";
+
+--
+-- TOC Entry ID 16 (OID 19130)
+--
+-- Name: temp2 Type: TABLE Owner: ipdb
+--
+
+CREATE TABLE "temp2" (
+        "pool" cidr,
+        "ip" cidr,
+        "custid" character varying(16),
+        "city" character varying(30),
+        "ptype" character(1),
+        "available" character(1),
+        "notes" text,
+        "description" character varying(64)
+);
+
+--
+-- TOC Entry ID 17 (OID 20316)
 --
 -- Name: poolips Type: TABLE Owner: ipdb
@@ -89 +218 @@
         "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")
 );
 
---
--- TOC Entry ID 6 (OID 25872)
---
--- Name: masterblocks Type: TABLE Owner: ipdb
---
-
-CREATE TABLE "masterblocks" (
-        "cidr" cidr DEFAULT '255.255.255.255/32' NOT NULL,
-        Constraint "masterblocks_pkey" Primary Key ("cidr")
-);
-
---
--- TOC Entry ID 7 (OID 25875)
---
--- Name: routed Type: TABLE Owner: ipdb
---
-
-CREATE TABLE "routed" (
-        "cidr" cidr DEFAULT '255.255.255.255/32' NOT NULL,
-        "maskbits" integer DEFAULT 128,
-        "city" character varying(30) DEFAULT '',
-        Constraint "routed_pkey" Primary Key ("cidr")
-);
-
---
--- TOC Entry ID 8 (OID 31131)
---
--- Name: temp Type: TABLE Owner: ipdb
---
-
-CREATE TABLE "temp" (
-        "ofs" integer
-);
-