view pgsql_schema.sql @ 47:c3812802146c

Move Rocket.toml to example file
author Lewin Bormann <lbo@spheniscida.de>
date Thu, 03 Dec 2020 17:44:36 +0100
parents 625c0c52e631
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
--