--
-- PostgreSQL database dump
--
SET SESSION AUTHORIZATION 'postgres';

--
-- TOC entry 3 (OID 2200)
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--
REVOKE ALL ON SCHEMA public FROM PUBLIC;
GRANT ALL ON SCHEMA public TO PUBLIC;

SET SESSION AUTHORIZATION 'sma';
SET search_path = public, pg_catalog;

--
-- TOC entry 4 (OID 8562513)
-- Name: comments; Type: TABLE; Schema: public; Owner: sma
--
CREATE TABLE comments (
    stamp timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone,
    addr integer,
    "comment" text
);

--
-- TOC entry 5 (OID 13542410)
-- Name: stats; Type: TABLE; Schema: public; Owner: sma
--
CREATE TABLE stats (
    stamp timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone,
    addr integer,
    "E-Total" double precision,
    "h-Total" double precision,
    "Pac" double precision,
    "Vac" double precision,
    "Fac" double precision,
    "Ipv" double precision,
    "Vpv" double precision,
    "Temperature" double precision
);

--
-- TOC entry 6 (OID 13565009)
-- Name: stats_oid; Type: INDEX; Schema: public; Owner: sma
--
CREATE INDEX stats_oid ON stats USING btree (oid);

--
-- TOC entry 7 (OID 13565011)
-- Name: stats_stamp; Type: INDEX; Schema: public; Owner: sma
--
CREATE INDEX stats_stamp ON stats USING btree (stamp);

SET SESSION AUTHORIZATION 'postgres';

--
-- TOC entry 2 (OID 2200)
-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
--
COMMENT ON SCHEMA public IS 'Standard public schema';