-- -- PostgreSQL database dump -- SET statement_timeout = 0; SET lock_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; SET check_function_bodies = false; SET client_min_messages = warning; -- -- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: - -- CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog; -- -- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: - -- --COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language'; SET search_path = public, pg_catalog; SET default_tablespace = ''; SET default_with_oids = false; -- -- Name: lesson_students; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE lesson_students ( lesson_id integer, student_id integer, visit boolean DEFAULT false ); -- -- Name: lesson_teachers; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE lesson_teachers ( lesson_id integer, teacher_id integer ); -- -- Name: lessons; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE lessons ( id integer NOT NULL, date date NOT NULL, title character varying(100), status integer DEFAULT 0 ); -- -- Name: lessons_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- CREATE SEQUENCE lessons_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; -- -- Name: lessons_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- ALTER SEQUENCE lessons_id_seq OWNED BY lessons.id; -- -- Name: students; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE students ( id integer NOT NULL, name character varying(10) ); -- -- Name: students_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- CREATE SEQUENCE students_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; -- -- Name: students_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- ALTER SEQUENCE students_id_seq OWNED BY students.id; -- -- Name: teachers; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE teachers ( id integer NOT NULL, name character varying(10) ); -- -- Name: teachers_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- CREATE SEQUENCE teachers_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; -- -- Name: teachers_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- ALTER SEQUENCE teachers_id_seq OWNED BY teachers.id; -- -- Name: id; Type: DEFAULT; Schema: public; Owner: - -- ALTER TABLE ONLY lessons ALTER COLUMN id SET DEFAULT nextval('lessons_id_seq'::regclass); -- -- Name: id; Type: DEFAULT; Schema: public; Owner: - -- ALTER TABLE ONLY students ALTER COLUMN id SET DEFAULT nextval('students_id_seq'::regclass); -- -- Name: id; Type: DEFAULT; Schema: public; Owner: - -- ALTER TABLE ONLY teachers ALTER COLUMN id SET DEFAULT nextval('teachers_id_seq'::regclass); -- -- Data for Name: lesson_students; Type: TABLE DATA; Schema: public; Owner: - -- COPY lesson_students (lesson_id, student_id, visit) FROM stdin; 1 1 t 1 2 t 1 3 f 2 2 t 2 3 t 4 1 t 4 2 t 4 3 t 4 4 t 5 4 f 5 2 f 6 1 f 6 3 f 7 2 t 7 1 t 8 1 f 8 4 t 8 2 t 9 2 f 10 1 f 10 3 t \. -- -- Data for Name: lesson_teachers; Type: TABLE DATA; Schema: public; Owner: - -- COPY lesson_teachers (lesson_id, teacher_id) FROM stdin; 1 1 1 3 2 1 2 4 3 3 4 4 6 3 7 1 8 4 8 3 8 2 9 3 10 3 \. -- -- Data for Name: lessons; Type: TABLE DATA; Schema: public; Owner: - -- COPY lessons (id, date, title, status) FROM stdin; 2 2019-09-02 Red Color 0 5 2019-05-10 Purple Color 0 7 2019-06-17 White Color 0 10 2019-06-24 Brown Color 0 9 2019-06-20 Yellow Color 1 1 2019-09-01 Green Color 1 3 2019-09-03 Orange Color 1 4 2019-09-04 Blue Color 1 6 2019-05-15 Red Color 1 8 2019-06-17 Black Color 1 \. -- -- Name: lessons_id_seq; Type: SEQUENCE SET; Schema: public; Owner: - -- SELECT pg_catalog.setval('lessons_id_seq', 10, true); -- -- Data for Name: students; Type: TABLE DATA; Schema: public; Owner: - -- COPY students (id, name) FROM stdin; 1 Ivan 2 Sergey 3 Maxim 4 Slava \. -- -- Name: students_id_seq; Type: SEQUENCE SET; Schema: public; Owner: - -- SELECT pg_catalog.setval('students_id_seq', 4, true); -- -- Data for Name: teachers; Type: TABLE DATA; Schema: public; Owner: - -- COPY teachers (id, name) FROM stdin; 1 Sveta 2 Marina 3 Anglessonselina 4 Masha \. -- -- Name: teachers_id_seq; Type: SEQUENCE SET; Schema: public; Owner: - -- SELECT pg_catalog.setval('teachers_id_seq', 4, true); -- -- Name: lessons_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE ONLY lessons ADD CONSTRAINT lessons_pkey PRIMARY KEY (id); -- -- Name: students_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE ONLY students ADD CONSTRAINT students_pkey PRIMARY KEY (id); -- -- Name: teachers_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE ONLY teachers ADD CONSTRAINT teachers_pkey PRIMARY KEY (id); -- -- Name: lesson_students_lesson_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY lesson_students ADD CONSTRAINT lesson_students_lesson_id_fkey FOREIGN KEY (lesson_id) REFERENCES lessons(id); -- -- Name: lesson_students_student_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY lesson_students ADD CONSTRAINT lesson_students_student_id_fkey FOREIGN KEY (student_id) REFERENCES students(id); -- -- Name: lesson_teachers_lesson_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY lesson_teachers ADD CONSTRAINT lesson_teachers_lesson_id_fkey FOREIGN KEY (lesson_id) REFERENCES lessons(id); -- -- Name: lesson_teachers_teacher_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY lesson_teachers ADD CONSTRAINT lesson_teachers_teacher_id_fkey FOREIGN KEY (teacher_id) REFERENCES teachers(id); -- -- Name: public; Type: ACL; Schema: -; Owner: - -- REVOKE ALL ON SCHEMA public FROM PUBLIC; REVOKE ALL ON SCHEMA public FROM dimon; GRANT ALL ON SCHEMA public TO dimon; GRANT ALL ON SCHEMA public TO PUBLIC; -- -- PostgreSQL database dump complete --