view pgsql_schema.sql @ 7:ebcf9edce874

Add 'secret' column
author Lewin Bormann <lbo@spheniscida.de>
date Tue, 01 Dec 2020 20:28:22 +0100
parents 6b97ebb6ee9c
children a5de18a5e99e
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 text not null,
    secret text,
    lat double precision,
    long double precision,
    spd double precision,
    t timestamp with time zone,
    ele double precision
);


ALTER TABLE geohub.geodata OWNER TO lbo;

--
-- PostgreSQL database dump complete
--