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

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

--
-- TOC Entry ID 9 (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 10 (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 25848)
--
-- 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 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 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)
--
-- 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,
        CHECK ((((ptype = 'c'::bpchar) OR (ptype = 'd'::bpchar)) OR (ptype = 's'::bpchar))),
        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
);