source: branches/sql-cleanup/cgi-bin/ipdb.psql@ 232

--
-- Selected TOC Entries:
--
\connect - postgres

--
-- TOC Entry ID 22 (OID 16556)
--
-- Name: "plpgsql_call_handler" () Type: FUNCTION Owner: postgres
--

CREATE FUNCTION "plpgsql_call_handler" () RETURNS opaque AS '$libdir/plpgsql', 'plpgsql_call_handler' LANGUAGE 'C';

--
-- TOC Entry ID 23 (OID 16557)
--
-- Name: plpgsql Type: PROCEDURAL LANGUAGE Owner: 
--

CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql' HANDLER "plpgsql_call_handler" LANCOMPILER '';

\connect - ipdb

--
-- TOC Entry ID 2 (OID 25854)
--
-- Name: customers Type: TABLE Owner: ipdb
--

CREATE TABLE "customers" (
        "custid" character varying(16) DEFAULT '' NOT NULL,
        "name" character varying(64),
        "street" character varying(25),
        "street2" character varying(25),
        "city" character varying(30),
        "province" character(2),
        "pocode" character varying(7),
        "phone" character varying(15),
        "abuse" character varying(50),
        "def_rdns" character varying(40),
        "description" text,
        Constraint "customers_pkey" Primary Key ("custid")
);

--
-- TOC Entry ID 3 (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 4 (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 5 (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 6 (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 7 (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 8 (OID 31131)
--
-- Name: temp Type: TABLE Owner: ipdb
--

CREATE TABLE "temp" (
        "ofs" integer
);

--
-- TOC Entry ID 9 (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 10 (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 11 (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 12 (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 13 (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";

--
-- TOC Entry ID 14 (OID 92444)
--
-- Name: poolips Type: TABLE Owner: ipdb
--

CREATE TABLE "poolips" (
        "pool" cidr DEFAULT '255.255.255.255/32' NOT NULL,
        "ip" cidr DEFAULT '255.255.255.255/32' NOT NULL,
        "custid" character varying(16) DEFAULT '' NOT NULL,
        "city" character varying(30) DEFAULT '',
        "ptype" character(1) DEFAULT 'c' NOT NULL,
        "available" character(1) DEFAULT 'y',
        "notes" text DEFAULT '',
        "description" character varying(64) DEFAULT '',
        "circuitid" character varying(128) DEFAULT '',
        CHECK (((available = 'y'::bpchar) OR (available = 'n'::bpchar))),
        Constraint "poolips_pkey" Primary Key ("ip")
);

--
-- TOC Entry ID 15 (OID 92444)
--
-- 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 16 (OID 92725)
--
-- Name: allocations Type: TABLE Owner: ipdb
--

CREATE TABLE "allocations" (
        "cidr" cidr DEFAULT '255.255.255.255/32' NOT NULL,
        "custid" character varying(16) DEFAULT '',
        "type" character(2) DEFAULT '',
        "city" character varying(30) DEFAULT '',
        "description" character varying(64) DEFAULT '',
        "notes" text DEFAULT '',
        "maskbits" integer DEFAULT 128,
        "circuitid" character varying(128) DEFAULT '',
        Constraint "allocations_pkey" Primary Key ("cidr")
);

--
-- TOC Entry ID 17 (OID 92725)
--
-- 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 18 (OID 92809)
--
-- Name: alloctypes Type: TABLE Owner: ipdb
--

CREATE TABLE "alloctypes" (
        "type" character(2) DEFAULT '' NOT NULL,
        "listname" character varying(40) DEFAULT '',
        "dispname" character varying(40) DEFAULT '',
        "listorder" integer DEFAULT 0,
        Constraint "alloctypes_pkey" Primary Key ("type")
);

--
-- TOC Entry ID 19 (OID 92809)
--
-- Name: alloctypes Type: ACL Owner: 
--

REVOKE ALL on "alloctypes" from PUBLIC;
GRANT ALL on "alloctypes" to "kdeugau";
GRANT ALL on "alloctypes" to "ipdb";

--
-- TOC Entry ID 20 (OID 93964)
--
-- Name: cities Type: TABLE Owner: ipdb
--

CREATE TABLE "cities" (
        "city" character varying(30) DEFAULT '' NOT NULL,
        "routing" character(1) DEFAULT 'n' NOT NULL,
        Constraint "cities_pkey" Primary Key ("city")
);

--
-- TOC Entry ID 21 (OID 93964)
--
-- Name: cities Type: ACL Owner: 
--

REVOKE ALL on "cities" from PUBLIC;
GRANT ALL on "cities" to "kdeugau";
GRANT ALL on "cities" to "ipdb";