--
-- PostgreSQL database dump
--

-- Dumped from database version 13.1 (Debian 13.1-1.pgdg100+1)
-- Dumped by pg_dump version 13.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: answers; Type: TABLE; Schema: public; Owner: root
--

CREATE TABLE public.answers (
    id integer NOT NULL,
    id_user integer NOT NULL,
    list_answers jsonb NOT NULL
);


ALTER TABLE public.answers OWNER TO root;

--
-- Name: answers_id_seq; Type: SEQUENCE; Schema: public; Owner: root
--

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


ALTER TABLE public.answers_id_seq OWNER TO root;

--
-- Name: answers_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root
--

ALTER SEQUENCE public.answers_id_seq OWNED BY public.answers.id;


--
-- Name: questions; Type: TABLE; Schema: public; Owner: root
--

CREATE TABLE public.questions (
    id integer NOT NULL,
    content character varying NOT NULL,
    value character varying NOT NULL,
    id_exam integer NOT NULL,
    correct_answers jsonb DEFAULT '[]'::jsonb NOT NULL,
    answers_list jsonb DEFAULT '[]'::jsonb NOT NULL,
    meta jsonb DEFAULT '{}'::jsonb NOT NULL
);


ALTER TABLE public.questions OWNER TO root;

--
-- Name: question_id_seq; Type: SEQUENCE; Schema: public; Owner: root
--

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


ALTER TABLE public.question_id_seq OWNER TO root;

--
-- Name: question_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root
--

ALTER SEQUENCE public.question_id_seq OWNED BY public.questions.id;


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

CREATE TABLE public.users (
    id integer NOT NULL,
    username character varying NOT NULL,
    password character varying NOT NULL,
    status integer
);


ALTER TABLE public.users OWNER TO root;

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

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


ALTER TABLE public.users_id_seq OWNER TO root;

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

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


--
-- Name: answers id; Type: DEFAULT; Schema: public; Owner: root
--

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


--
-- Name: questions id; Type: DEFAULT; Schema: public; Owner: root
--

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


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

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


--
-- Data for Name: answers; Type: TABLE DATA; Schema: public; Owner: root
--

INSERT INTO public.answers VALUES
	(2, 3, '[]'),
	(3, 3, '[]'),
	(5, 3, '[{"answer": 1, "id_question": 1}, {"answer": 2, "id_question": 2}, {"answer": 2, "id_question": 3}, {"answer": 2, "id_question": 4}, {"answer": 2, "id_question": 5}]'),
	(6, 3, '[{"answer": 1, "id_question": 1}, {"answer": 2, "id_question": 2}, {"answer": 2, "id_question": 3}, {"answer": 2, "id_question": 4}, {"answer": 2, "id_question": 5}]'),
	(7, 3, '[{"answer": 1, "id_question": 1}, {"answer": 2, "id_question": 2}, {"answer": 2, "id_question": 3}, {"answer": 2, "id_question": 4}, {"answer": 2, "id_question": 5}]'),
	(8, 3, '[{"answer": 1, "id_question": 1}, {"answer": 2, "id_question": 2}, {"answer": 2, "id_question": 3}, {"answer": 2, "id_question": 4}, {"answer": 2, "id_question": 5}]');


--
-- Data for Name: questions; Type: TABLE DATA; Schema: public; Owner: root
--

INSERT INTO public.questions VALUES
	(1, 'what''s color is fire ?', '', 1, '[1]', '[{"id": 1, "text": "red"}, {"id": 2, "text": "blue"}]', '{}'),
	(4, 'what''s color is the cloud ?', '', 1, '[1]', '[[{"id": 1, "text": "white"}, {"id": 2, "text": "blue"}]]', '{}'),
	(5, 'what''s color of ruby ?', '', 1, '[1]', '[[{"id": 1, "text": "red"}, {"id": 2, "text": "blue"}]]', '{}'),
	(2, 'what''s color of the sky?', '', 1, '[2]', '[[{"id": 1, "text": "red"}, {"id": 2, "text": "blue"}]]', '{}'),
	(3, 'what''s color is hope ?', '', 1, '[2]', '[[{"id": 1, "text": "red"}, {"id": 2, "text": "blue"}]]', '{}');


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

INSERT INTO public.users VALUES
	(1, 'test1', '$2b$04$bVu7n43I1giDqmU7Pvhgd.BZ6k9JVo4GP6qmi3LIlNysprQxjNFzq', NULL),
	(2, 'test12', '$2b$04$Buot9yVUOCOIfUEVFdGwNOpiRjCg0zxrS49V9nZBnEH4PPIUobG8C', NULL),
	(4, 'quan123', '$2b$04$q0nveNh.9zPHVBmqs0MfkO.Dm510C9n.uXiuNuRXll1PT/1HqZWaS', NULL),
	(5, 'test123456', '$2b$04$1Tt2r5lY0.bO8WHvXgdJu.Sl.84bTKGy0AQVr1PWqoBsDuoZJXkWC', NULL),
	(3, 'quan', '$2b$04$SruE.e1oz2Nwh7Hyqtfw0OQ0e5a0eDh7Ioe4123lt1Rq0j8fMiQc6', NULL),
	(6, 'test1212', '$2b$04$R26cPGrj9Xke/vVsLm2JZejDxVUe/4BtTjpnA8JGsAmiEcYOOM.Du', 1);


--
-- Name: answers_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root
--

SELECT pg_catalog.setval('public.answers_id_seq', 8, true);


--
-- Name: question_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root
--

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


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

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


--
-- Name: answers unique_answers_id; Type: CONSTRAINT; Schema: public; Owner: root
--

ALTER TABLE ONLY public.answers
    ADD CONSTRAINT unique_answers_id UNIQUE (id);


--
-- Name: questions unique_question_id; Type: CONSTRAINT; Schema: public; Owner: root
--

ALTER TABLE ONLY public.questions
    ADD CONSTRAINT unique_question_id PRIMARY KEY (id);


--
-- Name: users unique_users_id; Type: CONSTRAINT; Schema: public; Owner: root
--

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


--
-- PostgreSQL database dump complete
--