chat.sql

--
-- PostgreSQL database dump
--

-- Dumped from database version 13.3
-- Dumped by pg_dump version 13.3

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;

--
-- Name: tamaro-skaljic; Type: DATABASE; Schema: -; Owner: tamaro-skaljic
--

CREATE DATABASE tamaro-skaljic WITH TEMPLATE = template0 ENCODING = 'UTF8' LOCALE = 'en_US.utf8';


ALTER DATABASE tamaro-skaljic OWNER TO tamaro-skaljic;

\connect tamaro-skaljic

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;

--
-- Name: DATABASE tamaro-skaljic; Type: COMMENT; Schema: -; Owner: tamaro-skaljic
--

COMMENT ON DATABASE tamaro-skaljic IS 'default administrative connection database';

SET default_tablespace = '';

SET default_table_access_method = heap;

--
-- Name: chat_message; Type: TABLE; Schema: public; Owner: tamaro-skaljic
--

CREATE TABLE public.chat_message (
    message_id bigint NOT NULL,
    user_id bigint NOT NULL,
    message character varying(500) NOT NULL,
    sent timestamp(0) with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
    deleted boolean DEFAULT false NOT NULL
);


ALTER TABLE public.chat_message OWNER TO tamaro-skaljic;

--
-- Name: COLUMN chat_message.message_id; Type: COMMENT; Schema: public; Owner: tamaro-skaljic
--

COMMENT ON COLUMN public.chat_message.message_id IS 'The ID of the message';


--
-- Name: COLUMN chat_message.user_id; Type: COMMENT; Schema: public; Owner: tamaro-skaljic
--

COMMENT ON COLUMN public.chat_message.user_id IS 'The ID of the user which send the message';


--
-- Name: COLUMN chat_message.message; Type: COMMENT; Schema: public; Owner: tamaro-skaljic
--

COMMENT ON COLUMN public.chat_message.message IS 'The message itself';


--
-- Name: COLUMN chat_message.sent; Type: COMMENT; Schema: public; Owner: tamaro-skaljic
--

COMMENT ON COLUMN public.chat_message.sent IS 'When the message was sent';


--
-- Name: COLUMN chat_message.deleted; Type: COMMENT; Schema: public; Owner: tamaro-skaljic
--

COMMENT ON COLUMN public.chat_message.deleted IS 'Whether the message is deleted or not';


--
-- Name: chat_m_message_id_seq; Type: SEQUENCE; Schema: public; Owner: tamaro-skaljic
--

CREATE SEQUENCE public.chat_m_message_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.chat_m_message_id_seq OWNER TO tamaro-skaljic;

--
-- Name: chat_m_message_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: tamaro-skaljic
--

ALTER SEQUENCE public.chat_m_message_id_seq OWNED BY public.chat_message.message_id;


--
-- Name: user; Type: TABLE; Schema: public; Owner: tamaro-skaljic
--

CREATE TABLE public."user" (
    user_id bigint NOT NULL,
    username character varying(32) NOT NULL,
    unencrypted_password character varying(64) NOT NULL,
    is_admin boolean NOT NULL
);


ALTER TABLE public."user" OWNER TO tamaro-skaljic;

--
-- Name: COLUMN "user".user_id; Type: COMMENT; Schema: public; Owner: tamaro-skaljic
--

COMMENT ON COLUMN public."user".user_id IS 'The ID of the user';


--
-- Name: COLUMN "user".username; Type: COMMENT; Schema: public; Owner: tamaro-skaljic
--

COMMENT ON COLUMN public."user".username IS 'The name of the user';


--
-- Name: COLUMN "user".unencrypted_password; Type: COMMENT; Schema: public; Owner: tamaro-skaljic
--

COMMENT ON COLUMN public."user".unencrypted_password IS 'The unencrypted password of the user';


--
-- Name: COLUMN "user".is_admin; Type: COMMENT; Schema: public; Owner: tamaro-skaljic
--

COMMENT ON COLUMN public."user".is_admin IS 'Whether the user is an administrator or not';


--
-- Name: user_user_id_seq; Type: SEQUENCE; Schema: public; Owner: tamaro-skaljic
--

CREATE SEQUENCE public.user_user_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.user_user_id_seq OWNER TO tamaro-skaljic;

--
-- Name: user_user_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: tamaro-skaljic
--

ALTER SEQUENCE public.user_user_id_seq OWNED BY public."user".user_id;


--
-- Name: chat_message message_id; Type: DEFAULT; Schema: public; Owner: tamaro-skaljic
--

ALTER TABLE ONLY public.chat_message ALTER COLUMN message_id SET DEFAULT nextval('public.chat_m_message_id_seq'::regclass);


--
-- Name: user user_id; Type: DEFAULT; Schema: public; Owner: tamaro-skaljic
--

ALTER TABLE ONLY public."user" ALTER COLUMN user_id SET DEFAULT nextval('public.user_user_id_seq'::regclass);


--
-- Data for Name: chat_message; Type: TABLE DATA; Schema: public; Owner: tamaro-skaljic
--

COPY public.chat_message (message_id, user_id, message, sent, deleted) FROM stdin;
\.


--
-- Data for Name: user; Type: TABLE DATA; Schema: public; Owner: tamaro-skaljic
--

COPY public."user" (user_id, username, unencrypted_password, is_admin) FROM stdin;
\.


--
-- Name: chat_m_message_id_seq; Type: SEQUENCE SET; Schema: public; Owner: tamaro-skaljic
--

SELECT pg_catalog.setval('public.chat_m_message_id_seq', 1, false);


--
-- Name: user_user_id_seq; Type: SEQUENCE SET; Schema: public; Owner: tamaro-skaljic
--

SELECT pg_catalog.setval('public.user_user_id_seq', 1, false);


--
-- Name: chat_message chat_m_pk; Type: CONSTRAINT; Schema: public; Owner: tamaro-skaljic
--

ALTER TABLE ONLY public.chat_message
    ADD CONSTRAINT chat_m_pk PRIMARY KEY (message_id);


--
-- Name: user user_pk; Type: CONSTRAINT; Schema: public; Owner: tamaro-skaljic
--

ALTER TABLE ONLY public."user"
    ADD CONSTRAINT user_pk PRIMARY KEY (user_id);


--
-- Name: user user_un; Type: CONSTRAINT; Schema: public; Owner: tamaro-skaljic
--

ALTER TABLE ONLY public."user"
    ADD CONSTRAINT user_un UNIQUE (username);


--
-- Name: chat_message_sent_idx; Type: INDEX; Schema: public; Owner: tamaro-skaljic
--

CREATE INDEX chat_message_sent_idx ON public.chat_message USING btree (sent);


--
-- Name: chat_message chat_m_fk; Type: FK CONSTRAINT; Schema: public; Owner: tamaro-skaljic
--

ALTER TABLE ONLY public.chat_message
    ADD CONSTRAINT chat_m_fk FOREIGN KEY (user_id) REFERENCES public."user"(user_id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: TABLE chat_message; Type: ACL; Schema: public; Owner: tamaro-skaljic
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.chat_message TO "tamaro-skaljic_chat";


--
-- Name: TABLE "user"; Type: ACL; Schema: public; Owner: tamaro-skaljic
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public."user" TO "tamaro-skaljic_chat";


--
-- PostgreSQL database dump complete
--