From a28e6fbcbfc8feccdcba200c2421f5c42a78d97a Mon Sep 17 00:00:00 2001
From: Arne Rief <riearn@proton.me>
Date: Sat, 10 Jan 2026 22:33:36 +0100
Subject: Docker

---
 database/init.sql | 188 ++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 188 insertions(+)
 create mode 100644 database/init.sql

(limited to 'database/init.sql')

diff --git a/database/init.sql b/database/init.sql
new file mode 100644
index 0000000..6b2c79e
--- /dev/null
+++ b/database/init.sql
@@ -0,0 +1,188 @@
+--
+-- PostgreSQL database dump
+--
+
+\restrict glJa3ruKbCYJ5e028FR51030DZ2dUgDjNP4bVEcrCnFu1K7MGF5Og3eeAMdRNGu
+
+-- Dumped from database version 18.1
+-- Dumped by pg_dump version 18.1
+
+SET statement_timeout = 0;
+SET lock_timeout = 0;
+SET idle_in_transaction_session_timeout = 0;
+SET transaction_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: robots; Type: TABLE; Schema: public; Owner: robot_master
+--
+
+CREATE TABLE public.robots (
+    id integer NOT NULL,
+    name character varying(100) NOT NULL,
+    status character varying(10) NOT NULL,
+    lat numeric(10,7) NOT NULL,
+    lon numeric(10,7) NOT NULL,
+    robot_positions jsonb DEFAULT '[]'::jsonb,
+    created_at timestamp without time zone DEFAULT CURRENT_TIMESTAMP,
+    updated_at timestamp without time zone DEFAULT CURRENT_TIMESTAMP,
+    CONSTRAINT robots_status_check CHECK (((status)::text = ANY ((ARRAY['idle'::character varying, 'moving'::character varying])::text[])))
+);
+
+
+ALTER TABLE public.robots OWNER TO robot_master;
+
+--
+-- Name: robots_id_seq; Type: SEQUENCE; Schema: public; Owner: robot_master
+--
+
+CREATE SEQUENCE public.robots_id_seq
+    AS integer
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER SEQUENCE public.robots_id_seq OWNER TO robot_master;
+
+--
+-- Name: robots_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: robot_master
+--
+
+ALTER SEQUENCE public.robots_id_seq OWNED BY public.robots.id;
+
+
+--
+-- Name: users; Type: TABLE; Schema: public; Owner: robot_master
+--
+
+CREATE TABLE public.users (
+    id integer NOT NULL,
+    email character varying(255) NOT NULL,
+    password_hash text NOT NULL,
+    created_at timestamp without time zone DEFAULT CURRENT_TIMESTAMP
+);
+
+
+ALTER TABLE public.users OWNER TO robot_master;
+
+--
+-- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: robot_master
+--
+
+CREATE SEQUENCE public.users_id_seq
+    AS integer
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER SEQUENCE public.users_id_seq OWNER TO robot_master;
+
+--
+-- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: robot_master
+--
+
+ALTER SEQUENCE public.users_id_seq OWNED BY public.users.id;
+
+
+--
+-- Name: robots id; Type: DEFAULT; Schema: public; Owner: robot_master
+--
+
+ALTER TABLE ONLY public.robots ALTER COLUMN id SET DEFAULT nextval('public.robots_id_seq'::regclass);
+
+
+--
+-- Name: users id; Type: DEFAULT; Schema: public; Owner: robot_master
+--
+
+ALTER TABLE ONLY public.users ALTER COLUMN id SET DEFAULT nextval('public.users_id_seq'::regclass);
+
+
+--
+-- Data for Name: robots; Type: TABLE DATA; Schema: public; Owner: robot_master
+--
+
+COPY public.robots (id, name, status, lat, lon, robot_positions, created_at, updated_at) FROM stdin;
+1	R2-D2	idle	51.3408630	12.3759190	[]	2026-01-09 22:04:04.983244	2026-01-09 22:04:04.983244
+2	Wall-E	idle	51.3408630	12.3759190	[]	2026-01-09 22:04:04.983244	2026-01-09 22:04:04.983244
+3	Bender	idle	51.3408630	12.3759190	[]	2026-01-09 22:04:04.983244	2026-01-09 22:04:04.983244
+4	Marvin	idle	51.3408630	12.3759190	[]	2026-01-09 22:04:04.983244	2026-01-09 22:04:04.983244
+\.
+
+
+--
+-- Data for Name: users; Type: TABLE DATA; Schema: public; Owner: robot_master
+--
+
+COPY public.users (id, email, password_hash, created_at) FROM stdin;
+1	admin@test.com	$2b$10$nPoFqcBSa4wrfUsAXDTeyeuxXN2KMFgbBcbttI0QG/KPq3JhtQH5K	2026-01-09 21:54:32.719188
+\.
+
+
+--
+-- Name: robots_id_seq; Type: SEQUENCE SET; Schema: public; Owner: robot_master
+--
+
+SELECT pg_catalog.setval('public.robots_id_seq', 4, true);
+
+
+--
+-- Name: users_id_seq; Type: SEQUENCE SET; Schema: public; Owner: robot_master
+--
+
+SELECT pg_catalog.setval('public.users_id_seq', 1, true);
+
+
+--
+-- Name: robots robots_pkey; Type: CONSTRAINT; Schema: public; Owner: robot_master
+--
+
+ALTER TABLE ONLY public.robots
+    ADD CONSTRAINT robots_pkey PRIMARY KEY (id);
+
+
+--
+-- Name: users users_email_key; Type: CONSTRAINT; Schema: public; Owner: robot_master
+--
+
+ALTER TABLE ONLY public.users
+    ADD CONSTRAINT users_email_key UNIQUE (email);
+
+
+--
+-- Name: users users_pkey; Type: CONSTRAINT; Schema: public; Owner: robot_master
+--
+
+ALTER TABLE ONLY public.users
+    ADD CONSTRAINT users_pkey PRIMARY KEY (id);
+
+
+--
+-- Name: SCHEMA public; Type: ACL; Schema: -; Owner: pg_database_owner
+--
+
+GRANT ALL ON SCHEMA public TO robot_master;
+
+
+--
+-- PostgreSQL database dump complete
+--
+
+\unrestrict glJa3ruKbCYJ5e028FR51030DZ2dUgDjNP4bVEcrCnFu1K7MGF5Og3eeAMdRNGu
+
-- 
cgit v1.2.3

