--
-- PostgreSQL database dump
--

-- Dumped from database version 9.5.2
-- Dumped by pg_dump version 9.5.2

SET statement_timeout = 0;
SET lock_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET row_security = off;

SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: allzeagbsv27; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE allzeagbsv27 (
    full_name character varying(100),
    lib_prep_id character varying(25),
    dna_sample character varying(100),
    project character varying(50),
    inbred character varying(50)
);


ALTER TABLE allzeagbsv27 OWNER TO postgres;

--
-- Name: b73v2ranges; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE b73v2ranges (
    type character varying(10),
    model character varying(400),
    chr integer,
    pos integer,
    ends integer
);


ALTER TABLE b73v2ranges OWNER TO postgres;

--
-- Name: b73v3ranges; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE b73v3ranges (
    type character varying(20) NOT NULL,
    model character varying(200),
    chr integer NOT NULL,
    pos integer NOT NULL,
    ends integer NOT NULL
);


ALTER TABLE b73v3ranges OWNER TO postgres;

--
-- Name: genotype_queries; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE genotype_queries (
    token character(40) NOT NULL,
    tstamp integer NOT NULL,
    extension character varying(20),
    files integer,
    format character varying(20) NOT NULL,
    resultspp integer,
    query character varying(500) NOT NULL,
    version character varying(100) NOT NULL
);


ALTER TABLE genotype_queries OWNER TO postgres;

--
-- Name: hapmapv3; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE hapmapv3 (
    taxon character varying(50) NOT NULL
);


ALTER TABLE hapmapv3 OWNER TO postgres;

--
-- Name: taxa_mappings; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE taxa_mappings (
    inbred character varying(50) NOT NULL,
    accession character varying(50) NOT NULL
);


ALTER TABLE taxa_mappings OWNER TO postgres;

--
-- Name: genotype_queries_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY genotype_queries
    ADD CONSTRAINT genotype_queries_pkey PRIMARY KEY (token);


--
-- Name: hapmapv3_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY hapmapv3
    ADD CONSTRAINT hapmapv3_pkey PRIMARY KEY (taxon);


--
-- Name: taxa_mappings_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY taxa_mappings
    ADD CONSTRAINT taxa_mappings_pkey PRIMARY KEY (inbred);


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

