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