Mercurial > lbo > hg > geohub
view pgsql_schema.sql @ 56:e47f25aef153
track_ICE: better collect logging
author | Lewin Bormann <lbo@spheniscida.de> |
---|---|
date | Thu, 03 Dec 2020 22:38:54 +0100 |
parents | 6ee4923958f0 |
children | 373b6ad155ba |
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, note text ); ALTER TABLE geohub.geodata OWNER TO lbo; -- -- PostgreSQL database dump complete --