-- -- PostgreSQL database dump -- SET client_encoding = 'UTF8'; SET standard_conforming_strings = off; SET check_function_bodies = false; SET client_min_messages = warning; SET escape_string_warning = off; -- -- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres -- COMMENT ON SCHEMA public IS 'Standard public schema'; SET search_path = public, pg_catalog; -- -- Name: group_ids_sequence; Type: SEQUENCE; Schema: public; Owner: sprenkle -- CREATE SEQUENCE group_ids_sequence INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; ALTER TABLE public.group_ids_sequence OWNER TO sprenkle; -- -- Name: group_ids_sequence; Type: SEQUENCE SET; Schema: public; Owner: sprenkle -- SELECT pg_catalog.setval('group_ids_sequence', 4, true); 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 INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; ALTER TABLE public.majors_id_seq OWNER TO sprenkle; -- -- Name: majors_id_seq; Type: SEQUENCE SET; Schema: public; Owner: sprenkle -- SELECT pg_catalog.setval('majors_id_seq', 26, true); -- -- 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: user_ids_sequence; Type: SEQUENCE; Schema: public; Owner: sprenkle -- CREATE SEQUENCE user_ids_sequence INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; ALTER TABLE public.user_ids_sequence OWNER TO sprenkle; -- -- Name: user_ids_sequence; Type: SEQUENCE SET; Schema: public; Owner: sprenkle -- SELECT pg_catalog.setval('user_ids_sequence', 2, true); -- -- 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; -- -- 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 \. -- -- Data for Name: users; Type: TABLE DATA; Schema: public; Owner: sprenkle -- COPY users (id, "password", username, name) FROM stdin; 1 098f6bcd4621d373cade4e832627b4f6 test Test McUser 2 bed128365216c019988915ed3add75fb username User Teststein \. -- -- Data for Name: users2groups; Type: TABLE DATA; Schema: public; Owner: sprenkle -- COPY users2groups (user_id, group_id) FROM stdin; 1 1 2 2 1 3 \. -- -- Name: groups_pkey; Type: CONSTRAINT; Schema: public; Owner: sprenkle; Tablespace: -- ALTER TABLE ONLY groups ADD CONSTRAINT groups_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: 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 --