NickIPdatabase

From PrgmrWiki
--
-- PostgreSQL database dump
--

SET client_encoding = 'UTF8';
SET check_function_bodies = false;
SET client_min_messages = warning;

--
-- Name: ipdb; Type: DATABASE; Schema: -; Owner: ipdb
--

CREATE DATABASE ipdb WITH TEMPLATE = template0 ENCODING = 'UTF8';


ALTER DATABASE ipdb OWNER TO ipdb;

\connect ipdb

SET client_encoding = 'UTF8';
SET check_function_bodies = false;
SET client_min_messages = warning;

--
-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
--

COMMENT ON SCHEMA public IS 'Standard public schema';


SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: dom0s; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE dom0s (
    name text NOT NULL,
    vlanid integer,
    readyfornewhosts boolean
);


ALTER TABLE public.dom0s OWNER TO postgres;

--
-- Name: ipaddresses; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE ipaddresses (
    ipaddress inet NOT NULL,
    macaddress macaddr,
    svcnum integer
);


ALTER TABLE public.ipaddresses OWNER TO postgres;

--
-- Name: ipnetworks; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE ipnetworks (
    networkaddress cidr,
    vlanid integer,
    gateway inet,
    customer integer,
    rdnszone text,
    subnet boolean,
    supernet boolean,
    werouteit boolean
);


ALTER TABLE public.ipnetworks OWNER TO postgres;

--
-- Name: dom0s_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY dom0s
    ADD CONSTRAINT dom0s_pkey PRIMARY KEY (name);


--
-- Name: ipaddresses_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY ipaddresses
    ADD CONSTRAINT ipaddresses_pkey PRIMARY KEY (ipaddress);


--
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;


--
-- PostgreSQL database dump complete
--