--- a/pgsql_schema.sql	Sat Mar 06 14:49:00 2021 +0100
+++ b/pgsql_schema.sql	Thu Apr 15 11:56:25 2021 +0200
@@ -2,8 +2,10 @@
 -- PostgreSQL database dump
 --
 
--- Dumped from database version 12.4
--- Dumped by pg_dump version 12.4
+-- Dumped from database version 12.6
+-- Dumped by pg_dump version 12.6
+
+-- pg_dump -s  -U <owner> -n geohub -O
 
 SET statement_timeout = 0;
 SET lock_timeout = 0;
@@ -16,31 +18,85 @@
 SET client_min_messages = warning;
 SET row_security = off;
 
+--
+-- Name: geohub; Type: SCHEMA; Schema: -; Owner: -
+--
+
+CREATE SCHEMA geohub;
+
+
 SET default_tablespace = '';
 
 SET default_table_access_method = heap;
 
 --
--- Name: geodata; Type: TABLE; Schema: geohub
+-- Name: geodata; Type: TABLE; Schema: geohub; Owner: -
 --
 
-CREATE SCHEMA IF NOT EXISTS geohub;
-
 CREATE TABLE geohub.geodata (
-    id serial primary key,
-    client text not null,
+    client text NOT NULL,
     lat double precision,
     long double precision,
     spd double precision,
-    accuracy double precision,
-    t timestamp with time zone not null,
+    t timestamp with time zone,
     ele double precision,
     secret bytea,
+    id integer NOT NULL,
+    accuracy double precision,
     note text
 );
 
 
 --
+-- Name: geodata_id_seq; Type: SEQUENCE; Schema: geohub; Owner: -
+--
+
+CREATE SEQUENCE geohub.geodata_id_seq
+    AS integer
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+--
+-- Name: geodata_id_seq; Type: SEQUENCE OWNED BY; Schema: geohub; Owner: -
+--
+
+ALTER SEQUENCE geohub.geodata_id_seq OWNED BY geohub.geodata.id;
+
+
+--
+-- Name: geodata id; Type: DEFAULT; Schema: geohub; Owner: -
+--
+
+ALTER TABLE ONLY geohub.geodata ALTER COLUMN id SET DEFAULT nextval('geohub.geodata_id_seq'::regclass);
+
+
+--
+-- Name: geodata geodata_pkey; Type: CONSTRAINT; Schema: geohub; Owner: -
+--
+
+ALTER TABLE ONLY geohub.geodata
+    ADD CONSTRAINT geodata_pkey PRIMARY KEY (id);
+
+
+--
+-- Name: geodata_client_secret_idx; Type: INDEX; Schema: geohub; Owner: -
+--
+
+CREATE INDEX geodata_client_secret_idx ON geohub.geodata USING btree (client, secret);
+
+
+--
+-- Name: geodata_t_idx; Type: INDEX; Schema: geohub; Owner: -
+--
+
+CREATE INDEX geodata_t_idx ON geohub.geodata USING btree (t);
+
+
+--
 -- PostgreSQL database dump complete
 --