--
-- PostgreSQL database dump
--

SET client_encoding = 'UTF8';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;

SET search_path = public, pg_catalog;

DROP INDEX public.image_inventory_dhs_idx;
DROP TABLE public.image_inventory;
SET default_tablespace = '';

SET default_with_oids = false;

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

CREATE TABLE image_inventory (
    date date,
    hemis character(1),
    scan smallint,
    coadd smallint,
    band character(1),
    f_name character(25),
    f_size integer,
    ra double precision,
    decl double precision,
    s_type character(3),
    naxis2 smallint,
    disk character(4),
    f_type character(1),
    cat character(1),
    qual smallint
);


ALTER TABLE public.image_inventory OWNER TO postgres;

--
-- Name: image_inventory_dhs_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX image_inventory_dhs_idx ON image_inventory USING btree (date, hemis, scan);


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

REVOKE ALL ON TABLE image_inventory FROM PUBLIC;
REVOKE ALL ON TABLE image_inventory FROM postgres;
GRANT ALL ON TABLE image_inventory TO postgres;
GRANT SELECT ON TABLE image_inventory TO PUBLIC;


--
-- PostgreSQL database dump complete
--