diff options
Diffstat (limited to 'database/init.sql')
| -rw-r--r-- | database/init.sql | 188 |
1 files changed, 188 insertions, 0 deletions
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 + |