-- -- PostgreSQL database dump -- SET statement_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; -- -- Name: group_ids_sequence; Type: SEQUENCE; Schema: public; Owner: sprenkle -- CREATE SEQUENCE group_ids_sequence START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.group_ids_sequence OWNER TO sprenkle; SET default_tablespace = ''; SET default_with_oids = false; -- -- Name: groups; Type: TABLE; Schema: public; Owner: sprenkle; Tablespace: -- CREATE TABLE groups ( id integer DEFAULT nextval('group_ids_sequence'::regclass) NOT NULL, name character varying(30), description text ); ALTER TABLE public.groups OWNER TO sprenkle; -- -- Name: majors_id_seq; Type: SEQUENCE; Schema: public; Owner: sprenkle -- CREATE SEQUENCE majors_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.majors_id_seq OWNER TO sprenkle; -- -- Name: majors; Type: TABLE; Schema: public; Owner: sprenkle; Tablespace: -- CREATE TABLE majors ( id integer DEFAULT nextval('majors_id_seq'::regclass) NOT NULL, name character varying(50) NOT NULL, department character varying(50) NOT NULL ); ALTER TABLE public.majors OWNER TO sprenkle; -- -- Name: students_id_seq; Type: SEQUENCE; Schema: public; Owner: sprenkle -- CREATE SEQUENCE students_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.students_id_seq OWNER TO sprenkle; -- -- Name: students; Type: TABLE; Schema: public; Owner: sprenkle; Tablespace: -- CREATE TABLE students ( id integer DEFAULT nextval('students_id_seq'::regclass) NOT NULL, lastname character varying(30) NOT NULL, firstname character varying(20) NOT NULL, gradyear integer NOT NULL ); ALTER TABLE public.students OWNER TO sprenkle; -- -- Name: studentstomajors; Type: TABLE; Schema: public; Owner: sprenkle; Tablespace: -- CREATE TABLE studentstomajors ( student_id integer NOT NULL, majors_id integer NOT NULL ); ALTER TABLE public.studentstomajors OWNER TO sprenkle; -- -- Name: user_ids_sequence; Type: SEQUENCE; Schema: public; Owner: sprenkle -- CREATE SEQUENCE user_ids_sequence START WITH 4 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.user_ids_sequence OWNER TO sprenkle; -- -- Name: users; Type: TABLE; Schema: public; Owner: sprenkle; Tablespace: -- CREATE TABLE users ( id integer DEFAULT nextval('user_ids_sequence'::regclass) NOT NULL, password character varying(64) NOT NULL, username character varying(20) NOT NULL, name character varying(30) ); ALTER TABLE public.users OWNER TO sprenkle; -- -- Name: users2groups; Type: TABLE; Schema: public; Owner: sprenkle; Tablespace: -- CREATE TABLE users2groups ( user_id integer NOT NULL, group_id integer NOT NULL ); ALTER TABLE public.users2groups OWNER TO sprenkle; -- -- Name: group_ids_sequence; Type: SEQUENCE SET; Schema: public; Owner: sprenkle -- SELECT pg_catalog.setval('group_ids_sequence', 6, true); -- -- Data for Name: groups; Type: TABLE DATA; Schema: public; Owner: sprenkle -- COPY groups (id, name, description) FROM stdin; 1 Gardening Got a green thumb? Have a brown thumb and want it to be green? Check out our group! 2 Classical Music How does music become a classic? Let's discuss it. 3 Coin Collecting For the numismaticist in you. \. -- -- Data for Name: majors; Type: TABLE DATA; Schema: public; Owner: sprenkle -- COPY majors (id, name, department) FROM stdin; 1 CSCI-BS CSCI 2 ART-BA ART 3 PHYS-BA PHYS \. -- -- Name: majors_id_seq; Type: SEQUENCE SET; Schema: public; Owner: sprenkle -- SELECT pg_catalog.setval('majors_id_seq', 4, false); -- -- Data for Name: students; Type: TABLE DATA; Schema: public; Owner: sprenkle -- COPY students (id, lastname, firstname, gradyear) FROM stdin; 1 Aaronson Aaron 2021 2 Brown Allison 2022 3 Clark Kent 2023 \. -- -- Name: students_id_seq; Type: SEQUENCE SET; Schema: public; Owner: sprenkle -- SELECT pg_catalog.setval('students_id_seq', 3, true); -- -- Data for Name: studentstomajors; Type: TABLE DATA; Schema: public; Owner: sprenkle -- COPY studentstomajors (student_id, majors_id) FROM stdin; 1 3 2 1 1 1 \. -- -- Name: user_ids_sequence; Type: SEQUENCE SET; Schema: public; Owner: sprenkle -- SELECT pg_catalog.setval('user_ids_sequence', 4, false); -- -- Data for Name: users; Type: TABLE DATA; Schema: public; Owner: sprenkle -- COPY users (id, password, username, name) FROM stdin; 3 a029d0df84eb5549c641e04a9ef389e5 lucky Lucky Leprechaun 2 bed128365216c019988915ed3add75fb username User Teststein 1 5f4dcc3b5aa765d61d8327deb882cf99 test Test McUser \. -- -- Data for Name: users2groups; Type: TABLE DATA; Schema: public; Owner: sprenkle -- COPY users2groups (user_id, group_id) FROM stdin; 1 3 1 2 2 2 \. -- -- Name: groups_pkey; Type: CONSTRAINT; Schema: public; Owner: sprenkle; Tablespace: -- ALTER TABLE ONLY groups ADD CONSTRAINT groups_pkey PRIMARY KEY (id); -- -- Name: majors_pkey; Type: CONSTRAINT; Schema: public; Owner: sprenkle; Tablespace: -- ALTER TABLE ONLY majors ADD CONSTRAINT majors_pkey PRIMARY KEY (id); -- -- Name: majors_unique_key; Type: CONSTRAINT; Schema: public; Owner: sprenkle; Tablespace: -- ALTER TABLE ONLY majors ADD CONSTRAINT majors_unique_key UNIQUE (name, department); -- -- Name: students_pkey; Type: CONSTRAINT; Schema: public; Owner: sprenkle; Tablespace: -- ALTER TABLE ONLY students ADD CONSTRAINT students_pkey PRIMARY KEY (id); -- -- Name: users_pkey; Type: CONSTRAINT; Schema: public; Owner: sprenkle; Tablespace: -- ALTER TABLE ONLY users ADD CONSTRAINT users_pkey PRIMARY KEY (id); -- -- Name: users_username_key; Type: CONSTRAINT; Schema: public; Owner: sprenkle; Tablespace: -- ALTER TABLE ONLY users ADD CONSTRAINT users_username_key UNIQUE (username); -- -- Name: studentstomajors_majors_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: sprenkle -- ALTER TABLE ONLY studentstomajors ADD CONSTRAINT studentstomajors_majors_id_fkey FOREIGN KEY (majors_id) REFERENCES majors(id); -- -- Name: studentstomajors_student_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: sprenkle -- ALTER TABLE ONLY studentstomajors ADD CONSTRAINT studentstomajors_student_id_fkey FOREIGN KEY (student_id) REFERENCES students(id); -- -- Name: users2groups_group_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: sprenkle -- ALTER TABLE ONLY users2groups ADD CONSTRAINT users2groups_group_id_fkey FOREIGN KEY (group_id) REFERENCES groups(id); -- -- Name: users2groups_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: sprenkle -- ALTER TABLE ONLY users2groups ADD CONSTRAINT users2groups_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(id); -- -- Name: public; Type: ACL; Schema: -; Owner: postgres -- REVOKE ALL ON SCHEMA public FROM PUBLIC; REVOKE ALL ON SCHEMA public FROM postgres; GRANT ALL ON SCHEMA public TO postgres; GRANT ALL ON SCHEMA public TO PUBLIC; -- -- Name: group_ids_sequence; Type: ACL; Schema: public; Owner: sprenkle -- REVOKE ALL ON SEQUENCE group_ids_sequence FROM PUBLIC; REVOKE ALL ON SEQUENCE group_ids_sequence FROM sprenkle; GRANT ALL ON SEQUENCE group_ids_sequence TO sprenkle; GRANT SELECT,UPDATE ON SEQUENCE group_ids_sequence TO cs335; -- -- Name: groups; Type: ACL; Schema: public; Owner: sprenkle -- REVOKE ALL ON TABLE groups FROM PUBLIC; REVOKE ALL ON TABLE groups FROM sprenkle; GRANT ALL ON TABLE groups TO sprenkle; GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE groups TO cs335; -- -- Name: majors_id_seq; Type: ACL; Schema: public; Owner: sprenkle -- REVOKE ALL ON SEQUENCE majors_id_seq FROM PUBLIC; REVOKE ALL ON SEQUENCE majors_id_seq FROM sprenkle; GRANT ALL ON SEQUENCE majors_id_seq TO sprenkle; GRANT UPDATE ON SEQUENCE majors_id_seq TO cs335; -- -- Name: majors; Type: ACL; Schema: public; Owner: sprenkle -- REVOKE ALL ON TABLE majors FROM PUBLIC; REVOKE ALL ON TABLE majors FROM sprenkle; GRANT ALL ON TABLE majors TO sprenkle; GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE majors TO cs335; -- -- Name: user_ids_sequence; Type: ACL; Schema: public; Owner: sprenkle -- REVOKE ALL ON SEQUENCE user_ids_sequence FROM PUBLIC; REVOKE ALL ON SEQUENCE user_ids_sequence FROM sprenkle; GRANT ALL ON SEQUENCE user_ids_sequence TO sprenkle; GRANT UPDATE ON SEQUENCE user_ids_sequence TO cs335; -- -- Name: users; Type: ACL; Schema: public; Owner: sprenkle -- REVOKE ALL ON TABLE users FROM PUBLIC; REVOKE ALL ON TABLE users FROM sprenkle; GRANT ALL ON TABLE users TO sprenkle; GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE users TO cs335; -- -- Name: users2groups; Type: ACL; Schema: public; Owner: sprenkle -- REVOKE ALL ON TABLE users2groups FROM PUBLIC; REVOKE ALL ON TABLE users2groups FROM sprenkle; GRANT ALL ON TABLE users2groups TO sprenkle; GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE users2groups TO cs335; -- -- PostgreSQL database dump complete --