db.out

--
-- PostgreSQL database cluster dump
--

SET default_transaction_read_only = off;

SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;

--
-- Roles
--

CREATE ROLE "Moon";
ALTER ROLE "Moon" WITH SUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN NOREPLICATION NOBYPASSRLS;
CREATE ROLE kimberlykost;
ALTER ROLE kimberlykost WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN REPLICATION BYPASSRLS;
CREATE ROLE martajohnson;
ALTER ROLE martajohnson WITH SUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN NOREPLICATION NOBYPASSRLS PASSWORD 'md568ba6e1f662e1de9a4881df1679e578b';
CREATE ROLE moon;
ALTER ROLE moon WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN NOREPLICATION NOBYPASSRLS PASSWORD 'md52845e568b63af37fe0f1dadde65df5d3';
CREATE ROLE timothybooser;
ALTER ROLE timothybooser WITH SUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN NOREPLICATION NOBYPASSRLS;






--
-- Database creation
--

CREATE DATABASE kimberlykost WITH TEMPLATE = template0 OWNER = kimberlykost;
CREATE DATABASE stackdb_db WITH TEMPLATE = template0 OWNER = kimberlykost;
REVOKE ALL ON DATABASE stackdb_db FROM PUBLIC;
REVOKE ALL ON DATABASE stackdb_db FROM kimberlykost;
GRANT ALL ON DATABASE stackdb_db TO kimberlykost;
GRANT CONNECT,TEMPORARY ON DATABASE stackdb_db TO PUBLIC;
GRANT ALL ON DATABASE stackdb_db TO moon;
GRANT ALL ON DATABASE stackdb_db TO martajohnson;
REVOKE ALL ON DATABASE template1 FROM PUBLIC;
REVOKE ALL ON DATABASE template1 FROM kimberlykost;
GRANT ALL ON DATABASE template1 TO kimberlykost;
GRANT CONNECT ON DATABASE template1 TO PUBLIC;


\connect kimberlykost

SET default_transaction_read_only = off;

--
-- PostgreSQL database dump
--

-- Dumped from database version 9.5.0
-- Dumped by pg_dump version 9.5.0

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;
SET row_security = off;

--
-- 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';


--
-- Name: public; Type: ACL; Schema: -; Owner: kimberlykost
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM kimberlykost;
GRANT ALL ON SCHEMA public TO kimberlykost;
GRANT ALL ON SCHEMA public TO PUBLIC;


--
-- PostgreSQL database dump complete
--

\connect postgres

SET default_transaction_read_only = off;

--
-- PostgreSQL database dump
--

-- Dumped from database version 9.5.0
-- Dumped by pg_dump version 9.5.0

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;
SET row_security = off;

--
-- Name: postgres; Type: COMMENT; Schema: -; Owner: kimberlykost
--

COMMENT ON DATABASE postgres IS 'default administrative connection database';


--
-- 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';


--
-- Name: public; Type: ACL; Schema: -; Owner: kimberlykost
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM kimberlykost;
GRANT ALL ON SCHEMA public TO kimberlykost;
GRANT ALL ON SCHEMA public TO PUBLIC;


--
-- PostgreSQL database dump complete
--

\connect stackdb_db

SET default_transaction_read_only = off;

--
-- PostgreSQL database dump
--

-- Dumped from database version 9.5.0
-- Dumped by pg_dump version 9.5.0

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;
SET row_security = off;

--
-- 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: answerrating; Type: TABLE; Schema: public; Owner: kimberlykost
--

CREATE TABLE answerrating (
    ratingid integer NOT NULL,
    fk_answerid integer,
    fk_votedbyuserid integer
);


ALTER TABLE answerrating OWNER TO kimberlykost;

--
-- Name: answerrating_ratingid_seq; Type: SEQUENCE; Schema: public; Owner: kimberlykost
--

CREATE SEQUENCE answerrating_ratingid_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE answerrating_ratingid_seq OWNER TO kimberlykost;

--
-- Name: answerrating_ratingid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: kimberlykost
--

ALTER SEQUENCE answerrating_ratingid_seq OWNED BY answerrating.ratingid;


--
-- Name: answers; Type: TABLE; Schema: public; Owner: kimberlykost
--

CREATE TABLE answers (
    answerid integer NOT NULL,
    answertext character varying(255),
    fk_questionid integer,
    fk_answeredbyuserid integer,
    answerdate timestamp with time zone
);


ALTER TABLE answers OWNER TO kimberlykost;

--
-- Name: answers_answerid_seq; Type: SEQUENCE; Schema: public; Owner: kimberlykost
--

CREATE SEQUENCE answers_answerid_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE answers_answerid_seq OWNER TO kimberlykost;

--
-- Name: answers_answerid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: kimberlykost
--

ALTER SEQUENCE answers_answerid_seq OWNED BY answers.answerid;


--
-- Name: knex_migrations; Type: TABLE; Schema: public; Owner: kimberlykost
--

CREATE TABLE knex_migrations (
    id integer NOT NULL,
    name character varying(255),
    batch integer,
    migration_time timestamp with time zone
);


ALTER TABLE knex_migrations OWNER TO kimberlykost;

--
-- Name: knex_migrations_id_seq; Type: SEQUENCE; Schema: public; Owner: kimberlykost
--

CREATE SEQUENCE knex_migrations_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE knex_migrations_id_seq OWNER TO kimberlykost;

--
-- Name: knex_migrations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: kimberlykost
--

ALTER SEQUENCE knex_migrations_id_seq OWNED BY knex_migrations.id;


--
-- Name: knex_migrations_lock; Type: TABLE; Schema: public; Owner: kimberlykost
--

CREATE TABLE knex_migrations_lock (
    is_locked integer
);


ALTER TABLE knex_migrations_lock OWNER TO kimberlykost;

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

CREATE TABLE questions (
    questionid integer NOT NULL,
    questiontitle character varying(255),
    questiontext character varying(255),
    fk_askedbyuserid integer,
    questiondate timestamp with time zone
);


ALTER TABLE questions OWNER TO kimberlykost;

--
-- Name: questions_questionid_seq; Type: SEQUENCE; Schema: public; Owner: kimberlykost
--

CREATE SEQUENCE questions_questionid_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE questions_questionid_seq OWNER TO kimberlykost;

--
-- Name: questions_questionid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: kimberlykost
--

ALTER SEQUENCE questions_questionid_seq OWNED BY questions.questionid;


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

CREATE TABLE users (
    userid integer NOT NULL,
    username character varying(255),
    makerpassuuid character varying(255),
    avatar_url character varying(75),
    useremail character varying(100),
    password character varying(50) NOT NULL
);


ALTER TABLE users OWNER TO kimberlykost;

--
-- Name: users_userid_seq; Type: SEQUENCE; Schema: public; Owner: kimberlykost
--

CREATE SEQUENCE users_userid_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE users_userid_seq OWNER TO kimberlykost;

--
-- Name: users_userid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: kimberlykost
--

ALTER SEQUENCE users_userid_seq OWNED BY users.userid;


--
-- Name: ratingid; Type: DEFAULT; Schema: public; Owner: kimberlykost
--

ALTER TABLE ONLY answerrating ALTER COLUMN ratingid SET DEFAULT nextval('answerrating_ratingid_seq'::regclass);


--
-- Name: answerid; Type: DEFAULT; Schema: public; Owner: kimberlykost
--

ALTER TABLE ONLY answers ALTER COLUMN answerid SET DEFAULT nextval('answers_answerid_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: kimberlykost
--

ALTER TABLE ONLY knex_migrations ALTER COLUMN id SET DEFAULT nextval('knex_migrations_id_seq'::regclass);


--
-- Name: questionid; Type: DEFAULT; Schema: public; Owner: kimberlykost
--

ALTER TABLE ONLY questions ALTER COLUMN questionid SET DEFAULT nextval('questions_questionid_seq'::regclass);


--
-- Name: userid; Type: DEFAULT; Schema: public; Owner: kimberlykost
--

ALTER TABLE ONLY users ALTER COLUMN userid SET DEFAULT nextval('users_userid_seq'::regclass);


--
-- Data for Name: answerrating; Type: TABLE DATA; Schema: public; Owner: kimberlykost
--

COPY answerrating (ratingid, fk_answerid, fk_votedbyuserid) FROM stdin;
\.


--
-- Name: answerrating_ratingid_seq; Type: SEQUENCE SET; Schema: public; Owner: kimberlykost
--

SELECT pg_catalog.setval('answerrating_ratingid_seq', 1, false);


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

COPY answers (answerid, answertext, fk_questionid, fk_answeredbyuserid, answerdate) FROM stdin;
\.


--
-- Name: answers_answerid_seq; Type: SEQUENCE SET; Schema: public; Owner: kimberlykost
--

SELECT pg_catalog.setval('answers_answerid_seq', 6, true);


--
-- Data for Name: knex_migrations; Type: TABLE DATA; Schema: public; Owner: kimberlykost
--

COPY knex_migrations (id, name, batch, migration_time) FROM stdin;
1	20160219123025_stackdb.js	1	2016-02-19 12:44:02.058-06
\.


--
-- Name: knex_migrations_id_seq; Type: SEQUENCE SET; Schema: public; Owner: kimberlykost
--

SELECT pg_catalog.setval('knex_migrations_id_seq', 1, true);


--
-- Data for Name: knex_migrations_lock; Type: TABLE DATA; Schema: public; Owner: kimberlykost
--

COPY knex_migrations_lock (is_locked) FROM stdin;
0
\.


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

COPY questions (questionid, questiontitle, questiontext, fk_askedbyuserid, questiondate) FROM stdin;
55	How does a function work?	Que es function?	\N	\N
\.


--
-- Name: questions_questionid_seq; Type: SEQUENCE SET; Schema: public; Owner: kimberlykost
--

SELECT pg_catalog.setval('questions_questionid_seq', 55, true);


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

COPY users (userid, username, makerpassuuid, avatar_url, useremail, password) FROM stdin;
8	andreas	\N	\N	\N	amem
9	andreas1	\N	\N	\N	amem
10	2	\N	\N	\N	amem
11	4	\N	\N	\N	amem
12	41	\N	\N	\N	asd
13	1	\N	\N	\N	asd
14	11	\N	\N	\N	asd
15	111	\N	\N	\N	asd
16	1112	\N	\N	\N	asd
17	111111	\N	\N	\N	asd
18	1111119	\N	\N	\N	asd
19	dsaf	\N	\N	\N	kj;
20	dsaf2	\N	\N	\N	kj;
21	dsaf22	\N	\N	\N	kj;
22	1231	\N	\N	\N	1341
23	q1324	\N	\N	\N	1341
24	andrew	\N	\N	\N	moon
\.


--
-- Name: users_userid_seq; Type: SEQUENCE SET; Schema: public; Owner: kimberlykost
--

SELECT pg_catalog.setval('users_userid_seq', 24, true);


--
-- Name: answerrating_pkey; Type: CONSTRAINT; Schema: public; Owner: kimberlykost
--

ALTER TABLE ONLY answerrating
    ADD CONSTRAINT answerrating_pkey PRIMARY KEY (ratingid);


--
-- Name: answers_pkey; Type: CONSTRAINT; Schema: public; Owner: kimberlykost
--

ALTER TABLE ONLY answers
    ADD CONSTRAINT answers_pkey PRIMARY KEY (answerid);


--
-- Name: knex_migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: kimberlykost
--

ALTER TABLE ONLY knex_migrations
    ADD CONSTRAINT knex_migrations_pkey PRIMARY KEY (id);


--
-- Name: questions_pkey; Type: CONSTRAINT; Schema: public; Owner: kimberlykost
--

ALTER TABLE ONLY questions
    ADD CONSTRAINT questions_pkey PRIMARY KEY (questionid);


--
-- Name: users_pkey; Type: CONSTRAINT; Schema: public; Owner: kimberlykost
--

ALTER TABLE ONLY users
    ADD CONSTRAINT users_pkey PRIMARY KEY (userid);


--
-- Name: answerrating_fk_answerid_foreign; Type: FK CONSTRAINT; Schema: public; Owner: kimberlykost
--

ALTER TABLE ONLY answerrating
    ADD CONSTRAINT answerrating_fk_answerid_foreign FOREIGN KEY (fk_answerid) REFERENCES answers(answerid);


--
-- Name: answerrating_fk_votedbyuserid_foreign; Type: FK CONSTRAINT; Schema: public; Owner: kimberlykost
--

ALTER TABLE ONLY answerrating
    ADD CONSTRAINT answerrating_fk_votedbyuserid_foreign FOREIGN KEY (fk_votedbyuserid) REFERENCES users(userid);


--
-- Name: answers_fk_answeredbyuserid_foreign; Type: FK CONSTRAINT; Schema: public; Owner: kimberlykost
--

ALTER TABLE ONLY answers
    ADD CONSTRAINT answers_fk_answeredbyuserid_foreign FOREIGN KEY (fk_answeredbyuserid) REFERENCES users(userid);


--
-- Name: answers_fk_questionid_foreign; Type: FK CONSTRAINT; Schema: public; Owner: kimberlykost
--

ALTER TABLE ONLY answers
    ADD CONSTRAINT answers_fk_questionid_foreign FOREIGN KEY (fk_questionid) REFERENCES questions(questionid);


--
-- Name: questions_fk_askedbyuserid_foreign; Type: FK CONSTRAINT; Schema: public; Owner: kimberlykost
--

ALTER TABLE ONLY questions
    ADD CONSTRAINT questions_fk_askedbyuserid_foreign FOREIGN KEY (fk_askedbyuserid) REFERENCES users(userid);


--
-- Name: public; Type: ACL; Schema: -; Owner: kimberlykost
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM kimberlykost;
GRANT ALL ON SCHEMA public TO kimberlykost;
GRANT ALL ON SCHEMA public TO PUBLIC;


--
-- Name: answerrating; Type: ACL; Schema: public; Owner: kimberlykost
--

REVOKE ALL ON TABLE answerrating FROM PUBLIC;
REVOKE ALL ON TABLE answerrating FROM kimberlykost;
GRANT ALL ON TABLE answerrating TO kimberlykost;
GRANT ALL ON TABLE answerrating TO martajohnson;
GRANT ALL ON TABLE answerrating TO moon;


--
-- Name: answers; Type: ACL; Schema: public; Owner: kimberlykost
--

REVOKE ALL ON TABLE answers FROM PUBLIC;
REVOKE ALL ON TABLE answers FROM kimberlykost;
GRANT ALL ON TABLE answers TO kimberlykost;
GRANT ALL ON TABLE answers TO martajohnson;
GRANT ALL ON TABLE answers TO moon;


--
-- Name: questions; Type: ACL; Schema: public; Owner: kimberlykost
--

REVOKE ALL ON TABLE questions FROM PUBLIC;
REVOKE ALL ON TABLE questions FROM kimberlykost;
GRANT ALL ON TABLE questions TO kimberlykost;
GRANT ALL ON TABLE questions TO martajohnson;
GRANT ALL ON TABLE questions TO moon;


--
-- Name: users; Type: ACL; Schema: public; Owner: kimberlykost
--

REVOKE ALL ON TABLE users FROM PUBLIC;
REVOKE ALL ON TABLE users FROM kimberlykost;
GRANT ALL ON TABLE users TO kimberlykost;
GRANT ALL ON TABLE users TO martajohnson;
GRANT ALL ON TABLE users TO moon;


--
-- PostgreSQL database dump complete
--

\connect template1

SET default_transaction_read_only = off;

--
-- PostgreSQL database dump
--

-- Dumped from database version 9.5.0
-- Dumped by pg_dump version 9.5.0

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;
SET row_security = off;

--
-- Name: template1; Type: COMMENT; Schema: -; Owner: kimberlykost
--

COMMENT ON DATABASE template1 IS 'default template for new databases';


--
-- 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';


--
-- Name: public; Type: ACL; Schema: -; Owner: kimberlykost
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM kimberlykost;
GRANT ALL ON SCHEMA public TO kimberlykost;
GRANT ALL ON SCHEMA public TO PUBLIC;


--
-- PostgreSQL database dump complete
--

--
-- PostgreSQL database cluster dump complete
--