view pgsql_schema.sql @ 10:625c0c52e631

Implement live updates
author Lewin Bormann <lbo@spheniscida.de>
date Tue, 01 Dec 2020 22:44:34 +0100
parents a5de18a5e99e
children 6ee4923958f0
line wrap: on
line source

--
-- PostgreSQL database dump
--

-- Dumped from database version 12.4
-- Dumped by pg_dump version 12.4

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;

SET default_tablespace = '';

SET default_table_access_method = heap;

--
-- Name: geodata; Type: TABLE; Schema: public; Owner: lbo
--

CREATE SCHEMA IF NOT EXISTS geohub;

CREATE TABLE geohub.geodata (
    id serial primary key,
    client text not null,
    lat double precision,
    long double precision,
    spd double precision,
    t timestamp with time zone not null,
    ele double precision
    secret bytea,
);


ALTER TABLE geohub.geodata OWNER TO lbo;

--
-- PostgreSQL database dump complete
--