backup_file.sql

--
-- PostgreSQL database dump
--

\restrict ACksw2s2l9hCSijYdBQw1gNgKJvi1aNZWQmn5xgQzjBjMlw1tP75XByW7geAR6k

-- Dumped from database version 16.14 (Debian 16.14-1.pgdg13+1)
-- Dumped by pg_dump version 16.14 (Debian 16.14-1.pgdg13+1)

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: notes; Type: TABLE; Schema: public; Owner: admin
--

CREATE TABLE public.notes (
    id integer NOT NULL,
    title character varying(255) NOT NULL,
    content text,
    is_completed boolean,
    created_at timestamp with time zone DEFAULT now(),
    user_id integer NOT NULL
);


ALTER TABLE public.notes OWNER TO admin;

--
-- Name: notes_id_seq; Type: SEQUENCE; Schema: public; Owner: admin
--

CREATE SEQUENCE public.notes_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.notes_id_seq OWNER TO admin;

--
-- Name: notes_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.notes_id_seq OWNED BY public.notes.id;


--
-- Name: users; Type: TABLE; Schema: public; Owner: admin
--

CREATE TABLE public.users (
    id integer NOT NULL,
    username character varying(50) NOT NULL,
    hashed_password character varying(255) NOT NULL
);


ALTER TABLE public.users OWNER TO admin;

--
-- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: admin
--

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 admin;

--
-- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.users_id_seq OWNED BY public.users.id;


--
-- Name: notes id; Type: DEFAULT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.notes ALTER COLUMN id SET DEFAULT nextval('public.notes_id_seq'::regclass);


--
-- Name: users id; Type: DEFAULT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.users ALTER COLUMN id SET DEFAULT nextval('public.users_id_seq'::regclass);


--
-- Data for Name: notes; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.notes (id, title, content, is_completed, created_at, user_id) FROM stdin;
12	asdadasdas	das dvas das das dassda sdas 	f	2026-07-08 11:48:22.751072+00	1
5	PHP Note	Built from scratch!	f	2026-07-06 14:20:08.12342+00	1
14	asdasdasdasdasd	ass dfdsfafasdfdsa f asdfasdfa	f	2026-07-08 12:19:04.874101+00	1
3	Test #3	Testing more notes. Again.	f	2026-07-03 12:51:07.011356+00	1
7	My First Go Note	Compiled and fast!	f	2026-07-06 18:44:59.60644+00	1
8	My Second Go Note	Compiled and faster!	t	2026-07-06 18:46:22.104984+00	1
\.


--
-- Data for Name: users; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.users (id, username, hashed_password) FROM stdin;
1	demoniodojo	$2b$12$Odwn/8zUzmsC/VuoAB4bR.1i8j7yprj0rG/MX9/FOjqMQKc30iJDa
2	guest	$2b$12$E3p5Ck7h72Jnnrp9jh9NnOP/MeGsfSaHs7Ngq8ChN2aqGP456aZua
3	php_ninja	$2y$10$BsogFU4kx912QrJE8dlb5uu/jgGj5xKM2qqeAEGYw3YhysNsz96/K
4	golang_ninja	$2a$10$txX/6wyARZXwj0A6EB02f.8vmlz57z7f543sNpU6TmWBs26X4Go9m
5	user001	$2b$12$5J9nVDSyEPo1SCyeGBHXZe0wYuzgueFRFdsiYjRqo5FtYgHQebSTa
\.


--
-- Name: notes_id_seq; Type: SEQUENCE SET; Schema: public; Owner: admin
--

SELECT pg_catalog.setval('public.notes_id_seq', 14, true);


--
-- Name: users_id_seq; Type: SEQUENCE SET; Schema: public; Owner: admin
--

SELECT pg_catalog.setval('public.users_id_seq', 5, true);


--
-- Name: notes notes_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.notes
    ADD CONSTRAINT notes_pkey PRIMARY KEY (id);


--
-- Name: users users_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.users
    ADD CONSTRAINT users_pkey PRIMARY KEY (id);


--
-- Name: ix_notes_id; Type: INDEX; Schema: public; Owner: admin
--

CREATE INDEX ix_notes_id ON public.notes USING btree (id);


--
-- Name: ix_users_id; Type: INDEX; Schema: public; Owner: admin
--

CREATE INDEX ix_users_id ON public.users USING btree (id);


--
-- Name: ix_users_username; Type: INDEX; Schema: public; Owner: admin
--

CREATE UNIQUE INDEX ix_users_username ON public.users USING btree (username);


--
-- Name: notes notes_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.notes
    ADD CONSTRAINT notes_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE CASCADE;


--
-- PostgreSQL database dump complete
--

\unrestrict ACksw2s2l9hCSijYdBQw1gNgKJvi1aNZWQmn5xgQzjBjMlw1tP75XByW7geAR6k