psql-update

--
-- PostgreSQL database dump
--

SET statement_timeout = 0;
SET client_encoding = 'SQL_ASCII';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;

SET search_path = public, pg_catalog;

SET default_tablespace = sdcard;

SET default_with_oids = false;

--
-- Name: histograms; Type: TABLE; Schema: public; Owner: radiation; Tablespace: sdcard
--

CREATE TABLE histograms (
    hdop double precision,
    "time" timestamp with time zone,
    sampletime double precision,
    temp double precision,
    cps double precision,
    histogram integer[],
    id integer NOT NULL,
    location geometry,
    simulated boolean DEFAULT false NOT NULL,
    compression integer DEFAULT 7 NOT NULL,
    altitude real,
    sensor integer DEFAULT 0,
    version double precision DEFAULT 0,
    locguess boolean DEFAULT false
);


ALTER TABLE public.histograms OWNER TO radiation;

--
-- Name: COLUMN histograms.altitude; Type: COMMENT; Schema: public; Owner: radiation
--

COMMENT ON COLUMN histograms.altitude IS 'Altitude above mean sea level.';


--
-- Name: histograms_id_seq; Type: SEQUENCE; Schema: public; Owner: radiation
--

CREATE SEQUENCE histograms_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.histograms_id_seq OWNER TO radiation;

--
-- Name: histograms_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: radiation
--

ALTER SEQUENCE histograms_id_seq OWNED BY histograms.id;


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: radiation
--

ALTER TABLE ONLY histograms ALTER COLUMN id SET DEFAULT nextval('histograms_id_seq'::regclass);


--
-- Data for Name: histograms; Type: TABLE DATA; Schema: public; Owner: radiation
--

COPY histograms (hdop, "time", sampletime, temp, cps, histogram, id, location, simulated, compression, altitude, sensor, version, locguess) FROM stdin;
\.


--
-- Name: histograms_id_seq; Type: SEQUENCE SET; Schema: public; Owner: radiation
--

SELECT pg_catalog.setval('histograms_id_seq', 389191, true);


SET default_tablespace = '';

--
-- Name: key; Type: CONSTRAINT; Schema: public; Owner: radiation; Tablespace: 
--

ALTER TABLE ONLY histograms
    ADD CONSTRAINT key PRIMARY KEY (id);


--
-- Name: id_index; Type: INDEX; Schema: public; Owner: radiation; Tablespace: 
--

CREATE INDEX id_index ON histograms USING btree (id);


--
-- Name: location; Type: INDEX; Schema: public; Owner: radiation; Tablespace: 
--

CREATE INDEX location ON histograms USING gist (location);


--
-- Name: time_index; Type: INDEX; Schema: public; Owner: radiation; Tablespace: 
--

CREATE INDEX time_index ON histograms USING btree ("time");


--
-- PostgreSQL database dump complete
--