schemas.sql

--
-- PostgreSQL database dump
--

-- Dumped from database version 13.1
-- Dumped by pg_dump version 13.1

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

--
-- Name: ivlrange; Type: TYPE; Schema: public; Owner: postgres
--

CREATE TYPE public.ivlrange AS RANGE (
    subtype = interval
);


ALTER TYPE public.ivlrange OWNER TO postgres;

--
-- Name: sun_day(interval); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION public.sun_day(interval) RETURNS interval
    LANGUAGE sql IMMUTABLE STRICT
    AS $_$SELECT DATE_TRUNC('hour', $1 / 12) * 12;$_$;


ALTER FUNCTION public.sun_day(interval) OWNER TO postgres;

SET default_tablespace = '';

SET default_table_access_method = heap;

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

CREATE TABLE public.locs (
    id integer NOT NULL,
    lat double precision,
    lng double precision
);


ALTER TABLE public.locs OWNER TO postgres;

--
-- Name: locs_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.locs_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.locs_id_seq OWNER TO postgres;

--
-- Name: locs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.locs_id_seq OWNED BY public.locs.id;


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

CREATE TABLE public.suns (
    id integer NOT NULL,
    rise timestamp without time zone,
    falls tsrange,
    loc_id integer,
    year integer,
    unix_cumsum public.ivlrange,
    year_cumsum public.ivlrange
);


ALTER TABLE public.suns OWNER TO postgres;

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

CREATE TABLE public.suns_corners (
    id integer NOT NULL,
    rise timestamp without time zone,
    falls tsrange,
    loc_id integer,
    year integer,
    unix_cumsum public.ivlrange,
    year_cumsum public.ivlrange
);


ALTER TABLE public.suns_corners OWNER TO postgres;

--
-- Name: suns_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.suns_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.suns_id_seq OWNER TO postgres;

--
-- Name: suns_id_seq1; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.suns_id_seq1
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.suns_id_seq1 OWNER TO postgres;

--
-- Name: suns_id_seq1; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.suns_id_seq1 OWNED BY public.suns.id;


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

CREATE TABLE public.unix_day_bases (
    sun_day interval NOT NULL,
    loc_id integer NOT NULL,
    base timestamp without time zone
);


ALTER TABLE public.unix_day_bases OWNER TO postgres;

--
-- Name: locs id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.locs ALTER COLUMN id SET DEFAULT nextval('public.locs_id_seq'::regclass);


--
-- Name: suns id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.suns ALTER COLUMN id SET DEFAULT nextval('public.suns_id_seq1'::regclass);


--
-- Name: locs locs_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.locs
    ADD CONSTRAINT locs_pkey PRIMARY KEY (id);


--
-- Name: suns suns_pkey1; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.suns
    ADD CONSTRAINT suns_pkey1 PRIMARY KEY (id);


--
-- Name: unix_day_bases unix_day_bases_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.unix_day_bases
    ADD CONSTRAINT unix_day_bases_pkey PRIMARY KEY (sun_day, loc_id);


--
-- Name: locs_lat_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX locs_lat_idx ON public.locs USING btree (lat);


--
-- Name: locs_lng_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX locs_lng_idx ON public.locs USING btree (lng);


--
-- Name: suns_falls_idx1; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX suns_falls_idx1 ON public.suns USING gist (falls);


--
-- Name: suns_falls_idx2; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX suns_falls_idx2 ON public.suns USING gist (falls);


--
-- Name: suns_rise_idx1; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX suns_rise_idx1 ON public.suns USING btree (rise);


--
-- Name: suns_unix_cumsum_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX suns_unix_cumsum_idx ON public.suns USING gist (unix_cumsum);


--
-- Name: suns_year_cumsum_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX suns_year_cumsum_idx ON public.suns USING gist (year_cumsum);


--
-- Name: suns_year_idx1; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX suns_year_idx1 ON public.suns USING btree (year);


--
-- Name: unix_day_bases_loc_id_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX unix_day_bases_loc_id_idx ON public.unix_day_bases USING btree (loc_id);


--
-- Name: suns suns_loc_id_fkey1; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.suns
    ADD CONSTRAINT suns_loc_id_fkey1 FOREIGN KEY (loc_id) REFERENCES public.locs(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: unix_day_bases unix_day_bases_loc_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.unix_day_bases
    ADD CONSTRAINT unix_day_bases_loc_id_fkey FOREIGN KEY (loc_id) REFERENCES public.locs(id);


--
-- PostgreSQL database dump complete
--