candyshop.dump

--
-- PostgreSQL database dump
--

-- Dumped from database version 9.5.4
-- Dumped by pg_dump version 9.5.4

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: migrations; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE migrations (
    id integer NOT NULL,
    migration character varying(255) NOT NULL,
    batch integer NOT NULL
);


ALTER TABLE migrations OWNER TO postgres;

--
-- Name: migrations_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER TABLE migrations_id_seq OWNER TO postgres;

--
-- Name: migrations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE migrations_id_seq OWNED BY migrations.id;


--
-- Name: orders; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE orders (
    id integer NOT NULL,
    "timestamp" timestamp(0) without time zone NOT NULL,
    quantity integer NOT NULL,
    status character varying(255) NOT NULL,
    user_id integer NOT NULL,
    product_id integer NOT NULL,
    fullname character varying(255),
    address text,
    relationship character varying(255)
);


ALTER TABLE orders OWNER TO postgres;

--
-- Name: orders_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER TABLE orders_id_seq OWNER TO postgres;

--
-- Name: orders_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE orders_id_seq OWNED BY orders.id;


--
-- Name: password_resets; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE password_resets (
    email character varying(255) NOT NULL,
    token character varying(255) NOT NULL,
    created_at timestamp(0) without time zone
);


ALTER TABLE password_resets OWNER TO postgres;

--
-- Name: products; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE products (
    id integer NOT NULL,
    item character varying(50) NOT NULL,
    description character varying(240) NOT NULL,
    status character varying(20) NOT NULL,
    available_items integer NOT NULL
);


ALTER TABLE products OWNER TO postgres;

--
-- Name: products_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER TABLE products_id_seq OWNER TO postgres;

--
-- Name: products_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE products_id_seq OWNED BY products.id;


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

CREATE TABLE users (
    id integer NOT NULL,
    username character varying(255) NOT NULL,
    email character varying(255) NOT NULL,
    password character varying(255) NOT NULL,
    is_admin boolean DEFAULT false NOT NULL,
    remember_token character varying(100),
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    fullname character varying(255),
    address text,
    relationship character varying(255)
);


ALTER TABLE users OWNER TO postgres;

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

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


ALTER TABLE users_id_seq OWNER TO postgres;

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

ALTER SEQUENCE users_id_seq OWNED BY users.id;


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

ALTER TABLE ONLY migrations ALTER COLUMN id SET DEFAULT nextval('migrations_id_seq'::regclass);


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

ALTER TABLE ONLY orders ALTER COLUMN id SET DEFAULT nextval('orders_id_seq'::regclass);


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

ALTER TABLE ONLY products ALTER COLUMN id SET DEFAULT nextval('products_id_seq'::regclass);


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

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


--
-- Data for Name: migrations; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY migrations (id, migration, batch) FROM stdin;
4	2014_10_12_000000_create_users_table	1
5	2014_10_12_100000_create_password_resets_table	1
6	2016_11_02_033231_create_users	1
7	2016_11_03_073213_add_is_admin	2
8	2016_11_03_075443_create_table	3
9	2016_11_03_080525_set_default_admin_value	4
10	2016_11_03_095058_createproductmodel	5
11	2016_11_10_070709_create_orders_table	6
12	2016_11_10_161159_add_table_fkeys	7
13	2016_11_10_163303_add_product_fkeys	8
15	2016_11_23_094237_add_info_to_profile	9
\.


--
-- Name: migrations_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('migrations_id_seq', 15, true);


--
-- Data for Name: orders; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY orders (id, "timestamp", quantity, status, user_id, product_id, fullname, address, relationship) FROM stdin;
11	2016-11-10 17:18:57	1	in-cart	5	1	\N	\N	\N
12	2016-11-10 17:19:50	1	in-cart	5	4	\N	\N	\N
13	2016-11-10 17:21:25	1	in-cart	5	4	\N	\N	\N
14	2016-11-10 17:23:40	1	in-cart	5	4	\N	\N	\N
15	2016-11-10 17:23:54	1	in-cart	5	1	\N	\N	\N
16	2016-11-10 17:38:16	1	in-cart	5	11	\N	\N	\N
63	2016-11-13 13:12:17	1	sold	7	1	\N	\N	\N
64	2016-11-13 13:24:50	1	sold	7	2	\N	\N	\N
65	2016-11-13 13:25:02	1	sold	7	3	\N	\N	\N
66	2016-11-13 13:25:05	1	sold	7	4	\N	\N	\N
67	2016-11-13 13:25:08	1	sold	7	4	\N	\N	\N
68	2016-11-13 13:25:11	1	sold	7	5	\N	\N	\N
69	2016-11-13 13:25:15	1	sold	7	6	\N	\N	\N
70	2016-11-13 13:28:55	1	sold	7	10	\N	\N	\N
23	2016-11-11 02:35:49	1	sold	6	6	\N	\N	\N
24	2016-11-11 02:36:08	1	sold	6	6	\N	\N	\N
25	2016-11-11 02:38:17	1	sold	6	3	\N	\N	\N
71	2016-11-13 13:49:59	1	sold	7	1	\N	\N	\N
72	2016-11-13 13:50:09	1	sold	7	2	\N	\N	\N
73	2016-11-13 13:50:12	1	sold	7	3	\N	\N	\N
74	2016-11-13 13:52:55	1	sold	7	1	\N	\N	\N
75	2016-11-13 13:54:40	1	sold	7	1	\N	\N	\N
76	2016-11-13 13:55:16	1	sold	7	1	\N	\N	\N
79	2016-11-13 14:05:03	1	sold	7	7	\N	\N	\N
85	2016-11-23 10:29:23	1	sold	7	14	\N	\N	\N
87	2016-12-09 06:59:56	1	in-cart	8	7	\N	\N	\N
86	2016-11-25 11:46:40	1	sold	6	7	\N	\N	\N
88	2016-12-09 19:09:45	1	sold	6	50	\N	\N	\N
89	2016-12-09 19:55:56	1	sold	6	50	\N	\N	\N
\.


--
-- Name: orders_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('orders_id_seq', 89, true);


--
-- Data for Name: password_resets; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY password_resets (email, token, created_at) FROM stdin;
\.


--
-- Data for Name: products; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY products (id, item, description, status, available_items) FROM stdin;
43	 Lemonheads	A yummy sweet candy everyone would love!	sold	17
44	 Teaberry Gum	A fun-sized sweet treat for all ages!	sold	29
45	 Smarties	A big lollipop that lasts for a day!	on_cart	7
46	 Lemonheads	A yummy sweet candy everyone would love!	sold	2
47	 Atomic Fire Balls	A big lollipop that lasts for a day!	on_cart	38
48	 Fizzies Drink Tablets	Your mouth will surely love this	sold	9
49	 Red Hots	Stretchy toffee candy covered in strawberry syrup	available	25
51	 Chick-o-Stick	A fun-sized sweet treat for all ages!	on_cart	20
52	 Chuckles	Your mouth will surely love this	on_cart	33
53	Mik-Mik	White sweet powder	available	10
54	Lemon Drops	Slightly sweet, good for the throat	available	9
50	 Atomic Fire Balls	Stretchy toffee candy covered in strawberry syrup	sold	9
\.


--
-- Name: products_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('products_id_seq', 54, true);


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

COPY users (id, username, email, password, is_admin, remember_token, created_at, updated_at, fullname, address, relationship) FROM stdin;
2	ebilord	gabrnavarro@gmail.com	$2y$10$jKvXFPymv.qvA4zczDDAm.7oVwANCwAAdzAE872apGUQq2R6LRP8C	f	zbyWbrY2pNllOqzVdeSBKwXazYvruwW96oZTXfEhYiXSfkKMDLKXMhxderXz	2016-11-03 08:07:45	2016-11-03 11:11:48	\N	\N	\N
3	kelly500	kelly@gmail.com	$2y$10$aVJjfEiPfbNBm2e4o2GAOe2c5xaIlhHnzcxjFYUouQWf5blPFyrjK	f	EpnQvfW8MlHbPumnFHIHsZVW0SNLnKJb67r7yG22uPPFym2fQbpdoxIJFkCh	2016-11-08 09:12:38	2016-11-08 09:15:32	\N	\N	\N
4	rizarae700	rizarae700@yahoo.com	$2y$10$oAZrVZUzXm9gIvDlRzcZAOQIlr94oMNGoi7b4yEtbPrA8lQE0xK0m	f	LkaA1TtD3tO2NQbNsIAiP3CTAvQh9ZLMghCbx3cMggEZiIMWJ5H6A6gh2M9N	2016-11-08 09:16:18	2016-11-08 09:17:56	\N	\N	\N
5	jfranco600	jfranco600@yahoo.com	$2y$10$nHRC7DlH/33lB87b2YSmFuiFpmys8JJjJweQ0qrK9nL/UaXGQ.X62	f	sU4KAtvn2vMi6u1U6TPLLhAe8zFW5Hg15a2cABgKJn7uasOS66v37bRw6l4M	2016-11-08 09:18:15	2016-11-10 17:39:41	\N	\N	\N
9	kellynavarro1	kellynavarro1@gmail.com	$2y$10$tRaNJOaWggDvvrrrGt8Z/eFIv6idG7g6IL6mMnJqC0oIx/sgK8xki	f	\N	2016-12-09 07:08:18	2016-12-09 07:08:18	\N	\N	\N
8	gabrnavarro12345	kellynavarro12345@gmail.com	$2y$10$zmd1poQ4C50WRzo85P5rS.9.e68DTz10X5lzWQpLLn.tdKSVKpBC2	f	h4MJwmJrbuGeWTquoOFA0a0qfA4zUSRFZB9U686OZFFCSvHnW8CyVaJQNOdO	2016-12-09 06:59:22	2016-12-09 19:06:38	Kelly Navarro	Ph1 Blk 2b Lt 36 Ciudad Real SJDM, Bulacan	Single
7	gabrnavarro_gwapo	gabrnavarro1@gmail.com	$2y$10$9YCBsKA7V3WBBhm7G9hnx.k23PTKEVuCvusZtVF/T9M7XutG8ko1W	t	G20ZmUWXmkX67jQz2NkCmNwvcwFRtib6WTG4eosNUgTZ9SNZyKaqini39V3w	2016-11-13 13:12:11	2016-11-25 11:45:36	Kelly Navarro	Quezon City	Single
6	kellynavarro	kellynavarro@gmail.com	$2y$10$HMfbExKCt/arYYx3uCbk7uoqhkyPdSNGetmhYBBNZh5/Sr7qHag9m	t	iqumiDswCpJO6vckG7FcS3SJtsFNQhu16vSD0TczuwGunRBR4fMbXnQryiEf	2016-11-09 01:57:20	2016-11-25 12:29:40	Gabriel Kelly Navarro	Ph1 Blk 2b Lt 36 Ciudad Real SJDM, Bulacan	In a relationship
\.


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

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


--
-- Name: migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY migrations
    ADD CONSTRAINT migrations_pkey PRIMARY KEY (id);


--
-- Name: orders_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY orders
    ADD CONSTRAINT orders_pkey PRIMARY KEY (id);


--
-- Name: products_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY products
    ADD CONSTRAINT products_pkey PRIMARY KEY (id);


--
-- Name: users_email_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY users
    ADD CONSTRAINT users_email_unique UNIQUE (email);


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

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


--
-- Name: password_resets_email_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX password_resets_email_index ON password_resets USING btree (email);


--
-- Name: password_resets_token_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX password_resets_token_index ON password_resets USING btree (token);


--
-- PostgreSQL database dump complete
--