| 1 |
b748cb5f
|
Tomáš Pašek
|
--
|
| 2 |
|
|
-- PostgreSQL database dump
|
| 3 |
|
|
--
|
| 4 |
|
|
|
| 5 |
|
|
-- Dumped from database version 10.16
|
| 6 |
|
|
-- Dumped by pg_dump version 10.16
|
| 7 |
|
|
|
| 8 |
|
|
-- Started on 2021-04-10 22:53:56
|
| 9 |
|
|
|
| 10 |
|
|
SET statement_timeout = 0;
|
| 11 |
|
|
SET lock_timeout = 0;
|
| 12 |
|
|
SET idle_in_transaction_session_timeout = 0;
|
| 13 |
|
|
SET client_encoding = 'UTF8';
|
| 14 |
|
|
SET standard_conforming_strings = on;
|
| 15 |
|
|
SELECT pg_catalog.set_config('search_path', '', false);
|
| 16 |
|
|
SET check_function_bodies = false;
|
| 17 |
|
|
SET xmloption = content;
|
| 18 |
|
|
SET client_min_messages = warning;
|
| 19 |
|
|
SET row_security = off;
|
| 20 |
|
|
|
| 21 |
|
|
SET default_tablespace = '';
|
| 22 |
|
|
|
| 23 |
|
|
SET default_with_oids = false;
|
| 24 |
|
|
|
| 25 |
|
|
--
|
| 26 |
|
|
-- TOC entry 203 (class 1259 OID 16487)
|
| 27 |
|
|
-- Name: users; Type: TABLE; Schema: public; Owner: postgres
|
| 28 |
|
|
--
|
| 29 |
|
|
|
| 30 |
|
|
CREATE TABLE public.users (
|
| 31 |
|
|
id integer NOT NULL,
|
| 32 |
|
|
password character varying(100) NOT NULL,
|
| 33 |
|
|
username character varying NOT NULL,
|
| 34 |
|
|
role character varying NOT NULL
|
| 35 |
|
|
);
|
| 36 |
|
|
|
| 37 |
|
|
|
| 38 |
|
|
ALTER TABLE public.users OWNER TO postgres;
|
| 39 |
|
|
|
| 40 |
|
|
--
|
| 41 |
|
|
-- TOC entry 204 (class 1259 OID 16497)
|
| 42 |
|
|
-- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
|
| 43 |
|
|
--
|
| 44 |
|
|
|
| 45 |
|
|
ALTER TABLE public.users ALTER COLUMN id ADD GENERATED ALWAYS AS IDENTITY (
|
| 46 |
|
|
SEQUENCE NAME public.users_id_seq
|
| 47 |
|
|
START WITH 1
|
| 48 |
|
|
INCREMENT BY 1
|
| 49 |
|
|
NO MINVALUE
|
| 50 |
|
|
NO MAXVALUE
|
| 51 |
|
|
CACHE 1
|
| 52 |
|
|
);
|
| 53 |
|
|
|
| 54 |
|
|
|
| 55 |
|
|
--
|
| 56 |
|
|
-- TOC entry 2814 (class 0 OID 16487)
|
| 57 |
|
|
-- Dependencies: 203
|
| 58 |
|
|
-- Data for Name: users; Type: TABLE DATA; Schema: public; Owner: postgres
|
| 59 |
|
|
--
|
| 60 |
|
|
|
| 61 |
|
|
COPY public.users (id, password, username, role) FROM stdin;
|
| 62 |
|
|
4 $2y$10$liQbaSxcPykR4516JVQ/G.pDYu0niSOF7q/IhJlOrUqXsHwIwp/p2 admin editor
|
| 63 |
|
|
\.
|
| 64 |
|
|
|
| 65 |
|
|
|
| 66 |
|
|
--
|
| 67 |
|
|
-- TOC entry 2821 (class 0 OID 0)
|
| 68 |
|
|
-- Dependencies: 204
|
| 69 |
|
|
-- Name: users_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
|
| 70 |
|
|
--
|
| 71 |
|
|
|
| 72 |
|
|
SELECT pg_catalog.setval('public.users_id_seq', 4, true);
|
| 73 |
|
|
|
| 74 |
|
|
|
| 75 |
|
|
--
|
| 76 |
|
|
-- TOC entry 2690 (class 2606 OID 16496)
|
| 77 |
|
|
-- Name: users username_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
|
| 78 |
|
|
--
|
| 79 |
|
|
|
| 80 |
|
|
ALTER TABLE ONLY public.users
|
| 81 |
|
|
ADD CONSTRAINT username_unique UNIQUE (username);
|
| 82 |
|
|
|
| 83 |
|
|
|
| 84 |
|
|
--
|
| 85 |
|
|
-- TOC entry 2692 (class 2606 OID 16491)
|
| 86 |
|
|
-- Name: users users_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
|
| 87 |
|
|
--
|
| 88 |
|
|
|
| 89 |
|
|
ALTER TABLE ONLY public.users
|
| 90 |
|
|
ADD CONSTRAINT users_pkey PRIMARY KEY (id);
|
| 91 |
|
|
|
| 92 |
|
|
|
| 93 |
|
|
-- Completed on 2021-04-10 22:53:56
|
| 94 |
|
|
|
| 95 |
|
|
--
|
| 96 |
|
|
-- PostgreSQL database dump complete
|
| 97 |
|
|
--
|