test.sql

--
-- PostgreSQL database dump
--

-- Dumped from database version 9.5.5
-- Dumped by pg_dump version 9.5.5

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: ar_internal_metadata; Type: TABLE; Schema: public; Owner: kyle
--

CREATE TABLE ar_internal_metadata (
    key character varying NOT NULL,
    value character varying,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL
);


ALTER TABLE ar_internal_metadata OWNER TO kyle;

--
-- Name: schema_migrations; Type: TABLE; Schema: public; Owner: kyle
--

CREATE TABLE schema_migrations (
    version character varying NOT NULL
);


ALTER TABLE schema_migrations OWNER TO kyle;

--
-- Name: tokens; Type: TABLE; Schema: public; Owner: kyle
--

CREATE TABLE tokens (
    id integer NOT NULL,
    token_type integer,
    token character varying,
    secret character varying,
    user_id integer,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL
);


ALTER TABLE tokens OWNER TO kyle;

--
-- Name: tokens_id_seq; Type: SEQUENCE; Schema: public; Owner: kyle
--

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


ALTER TABLE tokens_id_seq OWNER TO kyle;

--
-- Name: tokens_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: kyle
--

ALTER SEQUENCE tokens_id_seq OWNED BY tokens.id;


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

CREATE TABLE users (
    id integer NOT NULL,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL,
    uuid character varying,
    iam_uuid character varying
);


ALTER TABLE users OWNER TO kyle;

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

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


ALTER TABLE users_id_seq OWNER TO kyle;

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

ALTER SEQUENCE users_id_seq OWNED BY users.id;


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

ALTER TABLE ONLY tokens ALTER COLUMN id SET DEFAULT nextval('tokens_id_seq'::regclass);


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

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


--
-- Data for Name: ar_internal_metadata; Type: TABLE DATA; Schema: public; Owner: kyle
--

COPY ar_internal_metadata (key, value, created_at, updated_at) FROM stdin;
environment	development	2016-10-10 18:49:21.815583	2016-10-10 18:49:21.815583
\.


--
-- Data for Name: schema_migrations; Type: TABLE DATA; Schema: public; Owner: kyle
--

COPY schema_migrations (version) FROM stdin;
20161010184204
20161010201117
20161021015444
20161021022755
20161128214011
\.


--
-- Data for Name: tokens; Type: TABLE DATA; Schema: public; Owner: kyle
--

COPY tokens (id, token_type, token, secret, user_id, created_at, updated_at) FROM stdin;
18	0	3d8d441386ee8548e9a23291d34eedd75ede61aabf0161c578cdf8daf80b98ba	\N	15	2016-10-21 02:39:13.274044	2016-10-21 02:39:13.274044
19	1	db8899e9-c68e-476a-925d-601ab6140b10	17b58bd39634a40c8496219ce1daed6e	15	2016-10-21 02:39:14.31285	2016-10-21 02:39:14.31285
20	0	test1	\N	16	2016-10-26 05:07:16.915477	2016-10-26 05:07:16.915477
21	0	bullshit	\N	17	2016-11-27 22:14:16.845306	2016-11-27 22:14:16.845306
\.


--
-- Name: tokens_id_seq; Type: SEQUENCE SET; Schema: public; Owner: kyle
--

SELECT pg_catalog.setval('tokens_id_seq', 21, true);


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

COPY users (id, created_at, updated_at, uuid, iam_uuid) FROM stdin;
15	2016-10-21 02:39:13.266464	2016-10-22 03:56:49.005686	63b2cabe-8075-4777-a814-dcc54c54ccb7	\N
16	2016-10-26 05:07:16.878854	2016-10-26 05:07:16.878854	9476e7b7-d68a-4a64-b07c-827327ffece1	\N
17	2016-11-27 22:14:16.820618	2016-11-27 22:14:16.820618	8c50d6e9-de35-4c1f-88c9-aa5d66e6ddbe	\N
\.


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

SELECT pg_catalog.setval('users_id_seq', 17, true);


--
-- Name: ar_internal_metadata_pkey; Type: CONSTRAINT; Schema: public; Owner: kyle
--

ALTER TABLE ONLY ar_internal_metadata
    ADD CONSTRAINT ar_internal_metadata_pkey PRIMARY KEY (key);


--
-- Name: schema_migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: kyle
--

ALTER TABLE ONLY schema_migrations
    ADD CONSTRAINT schema_migrations_pkey PRIMARY KEY (version);


--
-- Name: tokens_pkey; Type: CONSTRAINT; Schema: public; Owner: kyle
--

ALTER TABLE ONLY tokens
    ADD CONSTRAINT tokens_pkey PRIMARY KEY (id);


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

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


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

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


--
-- PostgreSQL database dump complete
--