source: trunk/cgi-bin/ipdb.psql@ 34

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

--
-- TOC Entry ID 18 (OID 16559)
--
-- 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 19 (OID 16560)
--
-- Name: plpgsql Type: PROCEDURAL LANGUAGE Owner: 
--

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

\connect - ipdb

--
-- TOC Entry ID 2 (OID 16561)
--
-- 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,
        "maskbits" integer DEFAULT 128,
        Constraint "allocations_pkey" Primary Key ("cidr")
);

--
-- 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
--

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 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
--

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 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
--

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,
        "description" character varying(64) DEFAULT '',
        CHECK (((available = 'y'::bpchar) OR (available = 'n'::bpchar))),
        Constraint "poolips_pkey" Primary Key ("ip")
);