psql 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: browsing; Type: TABLE; Schema: public; Owner: hduser
--

CREATE TABLE browsing (
product_name character varying(100),
product_count integer
);


ALTER TABLE browsing OWNER TO hduser;

--
-- Name: categories; Type: TABLE; Schema: public; Owner: hduser
--

CREATE TABLE categories (
category_id integer NOT NULL,
category_department_id integer,
category_name character varying(50)
);


ALTER TABLE categories OWNER TO hduser;

--
-- Name: departments; Type: TABLE; Schema: public; Owner: hduser
--

CREATE TABLE departments (
department_id integer NOT NULL,
department_name character varying(20)
);


ALTER TABLE departments OWNER TO hduser;

--
-- Name: order_items; Type: TABLE; Schema: public; Owner: hduser
--

CREATE TABLE order_items (
order_item_id integer NOT NULL,
order_item_order_id integer,
order_item_product_id integer,
order_item_quantity integer,
order_item_subtotal real,
order_item_product_price real
);


ALTER TABLE order_items OWNER TO hduser;

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

CREATE TABLE orders (
order_id integer NOT NULL,
order_date date,
order_customer_id integer,
order_status character varying(100)
);


ALTER TABLE orders OWNER TO hduser;

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

CREATE TABLE products (
product_id integer NOT NULL,
product_category_id integer,
product_name character varying(100),
product_description character varying(20),
product_price real,
product_image character varying(256)
);


ALTER TABLE products OWNER TO hduser;

--
-- Data for Name: browsing; Type: TABLE DATA; Schema: public; Owner: hduser
--

COPY browsing (product_name, product_count) FROM stdin;
Glove It Urban Brick Golf Towel 213
Glove It Women's Imperial Golf Glove 167
Glove It Women's Mod Oval Golf Glove 155
Hirzl Men's Hybrid Golf Glove 159


[...]


TaylorMade 2014 Purelite Stand Bag 110
Team Golf New England Patriots Putter Grip 152
Team Golf Pittsburgh Steelers Putter Grip 111
Team Golf St. Louis Cardinals Putter Grip 128
Team Golf Tennessee Volunteers Putter Grip 152
Team Golf Texas Longhorns Putter Grip 137
The North Face Women's Recon Backpack 792
Titleist Club Glove Travel Cover 151
\.


--
-- Data for Name: categories; Type: TABLE DATA; Schema: public; Owner: hduser
--

COPY categories (category_id, category_department_id, category_name) FROM stdin;
1 2 Football
2 2 Soccer
3 2 Baseball & Softball
4 2 Basketball
5 2 Lacrosse
6 2 Tennis & Racquet
7 2 Hockey
8 2 More Sports
9 3 Cardio Equipment
10 3 Strength Training
11 3 Fitness Accessories
12 3 Boxing & MMA
13 3 Electronics
14 3 Yoga & Pilates
15 3 Training by Sport
16 3 As Seen on TV!
17 4 Cleats
18 4 Men's Footwear
19 4 Women's Footwear
20 4 Kids' Footwear
21 4 Featured Shops
22 4 Accessories
23 5 Men's Apparel
24 5 Women's Apparel
25 5 Boys' Apparel
26 5 Girls' Apparel


[...]


41 6 Trade-In
42 7 Bike & Skate Shop
43 7 Camping & Hiking
44 7 Hunting & Shooting
45 7 Fishing
46 7 Indoor/Outdoor Games
47 7 Boating
48 7 Water Sports
49 8 MLB
50 8 NFL
51 8 NHL
52 8 NBA
53 8 NCAA
54 8 MLS
55 8 International Soccer
56 8 World Cup Shop
57 8 MLB Players
58 8 NFL Players
59 8 Football Players
\.


--
-- Data for Name: departments; Type: TABLE DATA; Schema: public; Owner: hduser
--

COPY departments (department_id, department_name) FROM stdin;
2 Fitness
3 Footwear
4 Apparel
5 Golf
6 Outdoors
7 Fan Shop
8 Games
\.


--
-- Data for Name: order_items; Type: TABLE DATA; Schema: public; Owner: hduser
--

COPY order_items (order_item_id, order_item_order_id, order_item_product_id, order_item_quantity, order_item_subtotal, order_item_product_price) FROM stdin;
1 1 957 1 299.980011 299.980011
2 2 1073 1 199.990005 199.990005
3 2 502 5 250 50
4 2 403 1 129.990005 129.990005


[...]


[...]


Rangers Russell 69.9700012 http://images.acmesports.sports/Majestic+Men%27s+Replica+Texas+Rangers+Russell+Wilson+%233+Home...
1341 59 Nike Women's Cleveland Browns Johnny Football 34 http://images.acmesports.sports/Nike+Women%27s+Cleveland+Browns+Johnny+Football+Orange+T-Shirt
1342 59 Nike Men's St. Louis Rams Michael Sam #96 Nam 32 http://images.acmesports.sports/Nike+Men%27s+St.+Louis+Rams+Michael+Sam+%2396+Name+and+Number...
1343 59 Nike Men's Home Game Jersey St. Louis Rams Mi 100 http://images.acmesports.sports/Nike+Men%27s+Home+Game+Jersey+St.+Louis+Rams+Michael+Sam+%2396