--
--

SET escape_string_warning = off;

--
-- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: postgres
--

CREATE PROCEDURAL LANGUAGE plpgsql;


ALTER PROCEDURAL LANGUAGE plpgsql OWNER TO postgres;


--
-- Name: address_type; Type: TYPE; Schema: public; Owner: puye
--

CREATE TYPE address_type AS ENUM (
    'shipping',
    'billing'
);


ALTER TYPE public.address_type OWNER TO puye;



--
-- Name: addresses; Type: TABLE; Schema: public; Owner: puye; Tablespace: 
--

CREATE TABLE addresses (
    id integer NOT NULL,
    user_id integer,
    name character varying NOT NULL,
    address character varying NOT NULL,
    city character varying NOT NULL,
    state character varying NOT NULL,
    zip character varying(12) NOT NULL,
    phone character varying NOT NULL,
    type address_type NOT NULL
);


ALTER TABLE public.addresses OWNER TO puye;

--
-- Name: addresses_id_seq; Type: SEQUENCE; Schema: public; Owner: puye
--

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


ALTER TABLE public.addresses_id_seq OWNER TO puye;

--
-- Name: addresses_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: puye
--

ALTER SEQUENCE addresses_id_seq OWNED BY addresses.id;


--
-- Name: event_dates; Type: TABLE; Schema: public; Owner: puye; Tablespace: 
--

CREATE TABLE event_dates (
    event_id integer NOT NULL,
    event_date date DEFAULT now() NOT NULL
);


ALTER TABLE public.event_dates OWNER TO puye;

--
-- Name: events; Type: TABLE; Schema: public; Owner: puye; Tablespace: 
--

CREATE TABLE events (
    id integer NOT NULL,
    title character varying(255) NOT NULL,
    type character varying(255) NOT NULL,
    copy text NOT NULL,
    active boolean DEFAULT true NOT NULL
);


ALTER TABLE public.events OWNER TO puye;

--
-- Name: events_id_seq; Type: SEQUENCE; Schema: public; Owner: puye
--

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


ALTER TABLE public.events_id_seq OWNER TO puye;

--
-- Name: events_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: puye
--

ALTER SEQUENCE events_id_seq OWNED BY events.id;


--
-- Name: home_message; Type: TABLE; Schema: public; Owner: puye; Tablespace: 
--

CREATE TABLE home_message (
    default_message character varying(255),
    override character varying(255)
);


ALTER TABLE public.home_message OWNER TO puye;

--
-- Name: orders; Type: TABLE; Schema: public; Owner: puye; Tablespace: 
--

CREATE TABLE orders (
    id integer NOT NULL,
    billing_address integer NOT NULL,
    shipping_address integer NOT NULL,
    cart_id integer NOT NULL,
    created_at timestamp without time zone DEFAULT now() NOT NULL,
    user_id integer NOT NULL,
    order_status character varying(30) DEFAULT 'NEW'::character varying NOT NULL,
    total_tax numeric(10,2) NOT NULL,
    order_total numeric(10,2) NOT NULL,
    shipping_total numeric(10,2) NOT NULL,
    shipping_type character varying DEFAULT 'unknown'::character varying NOT NULL
);


ALTER TABLE public.orders OWNER TO puye;

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

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


ALTER TABLE public.orders_id_seq OWNER TO puye;

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

ALTER SEQUENCE orders_id_seq OWNED BY orders.id;


--
-- Name: partners; Type: TABLE; Schema: public; Owner: puye; Tablespace: 
--

CREATE TABLE partners (
    id integer NOT NULL,
    title character varying(255) NOT NULL,
    copy text NOT NULL,
    active boolean DEFAULT true NOT NULL
);


ALTER TABLE public.partners OWNER TO puye;

--
-- Name: partners_id_seq; Type: SEQUENCE; Schema: public; Owner: puye
--

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


ALTER TABLE public.partners_id_seq OWNER TO puye;

--
-- Name: partners_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: puye
--

ALTER SEQUENCE partners_id_seq OWNED BY partners.id;


--
-- Name: reservations; Type: TABLE; Schema: public; Owner: puye; Tablespace: 
--

CREATE TABLE reservations (
    id integer NOT NULL,
    group_request boolean DEFAULT false NOT NULL,
    firstname character varying(255) NOT NULL,
    lastname character varying(255) NOT NULL,
    address character varying(255) NOT NULL,
    city character varying(255) NOT NULL,
    state character varying(255) NOT NULL,
    zip character varying(10) NOT NULL,
    email character varying(255) NOT NULL,
    phone character varying(255) NOT NULL,
    party_size_adults integer DEFAULT 0 NOT NULL,
    party_size_children integer DEFAULT 0 NOT NULL,
    party_size_seniors integer DEFAULT 0 NOT NULL,
    requested_time timestamp without time zone DEFAULT now() NOT NULL,
    submitted timestamp without time zone DEFAULT now() NOT NULL,
    comments text
);


ALTER TABLE public.reservations OWNER TO puye;

--
-- Name: reservations_id_seq; Type: SEQUENCE; Schema: public; Owner: puye
--

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


ALTER TABLE public.reservations_id_seq OWNER TO puye;

--
-- Name: reservations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: puye
--

ALTER SEQUENCE reservations_id_seq OWNED BY reservations.id;


--
-- Name: reservations_tours; Type: TABLE; Schema: public; Owner: puye; Tablespace: 
--

CREATE TABLE reservations_tours (
    reservation_id integer NOT NULL,
    tours_id integer NOT NULL
);


ALTER TABLE public.reservations_tours OWNER TO puye;

--
-- Name: shop_cart; Type: TABLE; Schema: public; Owner: puye; Tablespace: 
--

CREATE TABLE shop_cart (
    id integer NOT NULL,
    session_name character varying(255) NOT NULL,
    created timestamp without time zone DEFAULT now() NOT NULL
);


ALTER TABLE public.shop_cart OWNER TO puye;

--
-- Name: shop_cart_id_seq; Type: SEQUENCE; Schema: public; Owner: puye
--

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


ALTER TABLE public.shop_cart_id_seq OWNER TO puye;

--
-- Name: shop_cart_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: puye
--

ALTER SEQUENCE shop_cart_id_seq OWNED BY shop_cart.id;


--
-- Name: shop_cart_items; Type: TABLE; Schema: public; Owner: puye; Tablespace: 
--

CREATE TABLE shop_cart_items (
    id integer NOT NULL,
    item_id integer NOT NULL,
    cart_id integer NOT NULL,
    quantity integer DEFAULT 1 NOT NULL,
    price numeric(10,2) NOT NULL
);


ALTER TABLE public.shop_cart_items OWNER TO puye;

--
-- Name: shop_cart_items_id_seq; Type: SEQUENCE; Schema: public; Owner: puye
--

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


ALTER TABLE public.shop_cart_items_id_seq OWNER TO puye;

--
-- Name: shop_cart_items_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: puye
--

ALTER SEQUENCE shop_cart_items_id_seq OWNED BY shop_cart_items.id;


--
-- Name: shop_categories; Type: TABLE; Schema: public; Owner: puye; Tablespace: 
--

CREATE TABLE shop_categories (
    id integer NOT NULL,
    name character varying(255) NOT NULL,
    active boolean DEFAULT true NOT NULL
);


ALTER TABLE public.shop_categories OWNER TO puye;

--
-- Name: shop_categories_id_seq; Type: SEQUENCE; Schema: public; Owner: puye
--

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


ALTER TABLE public.shop_categories_id_seq OWNER TO puye;

--
-- Name: shop_categories_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: puye
--

ALTER SEQUENCE shop_categories_id_seq OWNED BY shop_categories.id;


--
-- Name: shop_item_categories; Type: TABLE; Schema: public; Owner: puye; Tablespace: 
--

CREATE TABLE shop_item_categories (
    category_id integer NOT NULL,
    item_id integer NOT NULL
);


ALTER TABLE public.shop_item_categories OWNER TO puye;

--
-- Name: shop_items; Type: TABLE; Schema: public; Owner: puye; Tablespace: 
--

CREATE TABLE shop_items (
    id integer NOT NULL,
    name character varying(255) NOT NULL,
    sku character varying(255) NOT NULL,
    details character varying(255) NOT NULL,
    price numeric(10,2) NOT NULL,
    active boolean DEFAULT true NOT NULL,
    image_path character varying(255),
    free_shipping boolean DEFAULT false NOT NULL,
    weight numeric(6,2) DEFAULT 1 NOT NULL,
    quantity integer DEFAULT 1 NOT NULL,
    available_online integer DEFAULT 1 NOT NULL
);


ALTER TABLE public.shop_items OWNER TO puye;

--
-- Name: shop_items_id_seq; Type: SEQUENCE; Schema: public; Owner: puye
--

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


ALTER TABLE public.shop_items_id_seq OWNER TO puye;

--
-- Name: shop_items_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: puye
--

ALTER SEQUENCE shop_items_id_seq OWNED BY shop_items.id;


--
-- Name: slideshow; Type: TABLE; Schema: public; Owner: puye; Tablespace: 
--

CREATE TABLE slideshow (
    id integer NOT NULL,
    image_path character varying(255) NOT NULL,
    link_to character varying(255),
    sort_order integer DEFAULT 0 NOT NULL
);


ALTER TABLE public.slideshow OWNER TO puye;

--
-- Name: slideshow_id_seq; Type: SEQUENCE; Schema: public; Owner: puye
--

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


ALTER TABLE public.slideshow_id_seq OWNER TO puye;

--
-- Name: slideshow_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: puye
--

ALTER SEQUENCE slideshow_id_seq OWNED BY slideshow.id;


--
-- Name: tours; Type: TABLE; Schema: public; Owner: puye; Tablespace: 
--

CREATE TABLE tours (
    id integer NOT NULL,
    name character varying(255) NOT NULL,
    active boolean DEFAULT true NOT NULL
);


ALTER TABLE public.tours OWNER TO puye;

--
-- Name: tours_id_seq; Type: SEQUENCE; Schema: public; Owner: puye
--

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


ALTER TABLE public.tours_id_seq OWNER TO puye;

--
-- Name: tours_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: puye
--

ALTER SEQUENCE tours_id_seq OWNED BY tours.id;

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

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


ALTER TABLE public.users_id_seq OWNER TO puye;

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

ALTER SEQUENCE users_id_seq OWNED BY users.id;


--
-- Name: videos; Type: TABLE; Schema: public; Owner: puye; Tablespace: 
--

CREATE TABLE videos (
    id integer NOT NULL,
    video_id character varying NOT NULL,
    active boolean DEFAULT true NOT NULL
);


ALTER TABLE public.videos OWNER TO puye;

--
-- Name: videos_id_seq; Type: SEQUENCE; Schema: public; Owner: puye
--

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


ALTER TABLE public.videos_id_seq OWNER TO puye;

--
-- Name: videos_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: puye
--

ALTER SEQUENCE videos_id_seq OWNED BY videos.id;


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

ALTER TABLE addresses ALTER COLUMN id SET DEFAULT nextval('addresses_id_seq'::regclass);


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

ALTER TABLE events ALTER COLUMN id SET DEFAULT nextval('events_id_seq'::regclass);


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

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


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

ALTER TABLE partners ALTER COLUMN id SET DEFAULT nextval('partners_id_seq'::regclass);


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

ALTER TABLE reservations ALTER COLUMN id SET DEFAULT nextval('reservations_id_seq'::regclass);


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

ALTER TABLE shop_cart ALTER COLUMN id SET DEFAULT nextval('shop_cart_id_seq'::regclass);


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

ALTER TABLE shop_cart_items ALTER COLUMN id SET DEFAULT nextval('shop_cart_items_id_seq'::regclass);


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

ALTER TABLE shop_categories ALTER COLUMN id SET DEFAULT nextval('shop_categories_id_seq'::regclass);


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

ALTER TABLE shop_items ALTER COLUMN id SET DEFAULT nextval('shop_items_id_seq'::regclass);


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

ALTER TABLE slideshow ALTER COLUMN id SET DEFAULT nextval('slideshow_id_seq'::regclass);


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

ALTER TABLE tours ALTER COLUMN id SET DEFAULT nextval('tours_id_seq'::regclass);


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

ALTER TABLE videos ALTER COLUMN id SET DEFAULT nextval('videos_id_seq'::regclass);


--
-- Data for Name: addresses; Type: TABLE DATA; Schema: public; Owner: puye
--

COPY addresses (id, user_id, name, address, city, state, zip, phone, type) FROM stdin;
19	1	Reid Givens	1872 Sierra Norte Loop NE	Rio Rancho	NM	87144	5048426	billing
20	1	Reid Givens	1872 Sierra Norte Loop NE	Rio Rancho	NM	87144	5048426	shipping
21	1	Reid Givens	1872 Sierra Norte Loop NE	Rio Rancho	NM	87144	5048426	billing
22	1	Reid Givens	1872 Sierra Norte Loop NE	Rio Rancho	NM	87144	5048426	shipping
25	1	Reid Givens	1872 Sierra Norte Loop NE	Rio Rancho	NM	87144	5048426	billing
26	1	Reid Givens	1872 Sierra Norte Loop NE	Rio Rancho	NM	87144	5048426	shipping
\.


--
-- Data for Name: event_dates; Type: TABLE DATA; Schema: public; Owner: puye
--

COPY event_dates (event_id, event_date) FROM stdin;
1	2012-04-14
1	2012-04-15
1	2012-04-28
1	2012-04-29
3	2012-06-12
12	1969-12-31
12	1969-12-31
20	2012-08-22
26	2012-10-01
34	2012-11-01
35	2012-10-23
36	2012-11-07
37	2012-10-20
38	2012-11-22
\.


--
-- Data for Name: events; Type: TABLE DATA; Schema: public; Owner: puye
--

COPY events (id, title, type, copy, active) FROM stdin;
1	Earth & Sky Weekend 	Dance Demo	<p><em>Dance demonstration at 11am and again at 3pm. Dances will last approx. 20 minutes. Art vendors will also be on-site to answer your questions. Visit our Partners page for more information.</em></p>	t
3	Open Half Day	Closure	We will be open from 9am - 11am.	t
5	Closed	Closure		t
12	Dance Performance	Dance Demo	<p>Daryl Sakeva will be performing the Hopi Corn and Hopi Hunter dances with his group. Dances will be at 11am and 3pm. </p>  	t
13	Dance Performance	Dance Demo		t
14	Dance Performance	Dance Demo		t
15	Dance Performance	Dance Demo		t
16	Closure	Closure		t
18	Closure	Closure		t
19	Site closed	Closure		t
20	Closed	Closure	<p>Puye Cliff Dwellings closed today Wednesday, August 22, 2012. Mountain lion on trails.</p>	t
22	Earth and Sky Weekend	Area Attractions	<p>Join us for dance performances at 11am and 3pm</p>  	t
35	 Mid Day Closure- Puye Cliffs Will be Closed from 11a-12:30p.	Closure	 Mid Day Closure- Puye Cliffs Will be Closed from 11a-12:30p.	f
23	Earth and Sky Weekend	Dance Demo	Earth and Sky Weekend	t
38	Dances and Bread Demonstration	Cultural Packages	Dances and Bread Demonstration	f
26	Winter Hours Begin	None	Winter Hours Begin	f
39	Christmas Day	Closure	Christmas Day	f
40	Christmas Day	Closure	Christmas Day	f
29	Earth and Sky Weekend postponed until further notice	Area Attractions	Earth and Sky Weekend postponed until further notice	f
31	Hands-on Archaeology Exhibit	Area Attractions	Hands-on Archaeology Exhibit	f
32	Closure	Closure	Closure	f
33	All Souls Day	Closure		t
34	Closed- All Souls Day	Closure	All Souls Day- Closed	f
36	Closed	Closure	Closure	t
37	NEW HOURS! First tour will now start at 9:00am and the last 2 hour tour will be at 2:00pm and the last 1 hour tour will be at 3:00pm. The site will close at 4:00pm. Tours leave on the hour between 9a-3p.	None	NEW HOURS! First tour will now start at 9:00am and the last 1 hour tour will be at 3:00pm and the last 2 hour tour will be at 2:00pm. The site will close at 4:00pm. 	t
\.


--
-- Data for Name: home_message; Type: TABLE DATA; Schema: public; Owner: puye
--

COPY home_message (default_message, override) FROM stdin;
Puye Cliff Dwellings will be opened tomorrow Sunday February 10, 2013. But we will be closed Sunday February 17, 2013. We will reopen on Monday February 18, 2013. Gates open at 8:30am first tour starts at 9:00am. 	Puye Cliff Dwellings will be opened tomorrow Sunday February 10, 2013. But we will be closed Sunday February 17, 2013. We will reopen on Monday February 18, 2013. Gates open at 8:30am first tour starts at 9:00am.
\.


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

COPY orders (id, billing_address, shipping_address, cart_id, created_at, user_id, order_status, total_tax, order_total, shipping_total, shipping_type) FROM stdin;
11	21	22	4	2012-03-30 01:38:08.569423	1	PROCESSING	0.00	22.00	0.00	Free Shipping
10	19	20	3	2012-03-30 00:13:35.743666	1	SHIPPED	0.00	12.00	0.00	Free Shipping
13	25	26	5	2012-04-05 16:24:04.315092	1	PROCESSING	0.00	34.01	20.01	2nd Day Air
\.


--
-- Data for Name: partners; Type: TABLE DATA; Schema: public; Owner: puye
--

COPY partners (id, title, copy, active) FROM stdin;
\.


--
-- Data for Name: reservations; Type: TABLE DATA; Schema: public; Owner: puye
--

COPY reservations (id, group_request, firstname, lastname, address, city, state, zip, email, phone, party_size_adults, party_size_children, party_size_seniors, requested_time, submitted, comments) FROM stdin;
1	f	Testing	tester	PO Boc 9382	Espanola	NC	87542	twhitegeese@santaclaradevcorp.com	5059272731	2	0	0	2012-07-03 10:00:00	2012-04-21 16:26:36.699003	\N
2	f	Reid	Givens	1872 Sierra Norte Loop NE	Rio Rancho	NM	87144	reidgivens@viadcutdigital.com	5048426	1	0	0	2012-05-22 09:00:00	2012-05-03 16:08:24.915151	testing
3	f	Loretta	Folz	7016 Baxtershire	Dallas	TX	75230	lorifolz@sbcglobal.net	214-891-1728	1	0	1	2012-06-08 10:00:00	2012-06-07 13:59:10.82789	none
5	f	Ruth 	Damico	1728 Stagecoach Ct.	Powell	OH	43065	damicoruth@yahoo.com	6148322507	2	0	0	2012-06-12 10:00:00	2012-06-11 11:34:49.611187	thanks
6	f	Michelle	Lee	14010 W Cypress Forest	Houston	TX	77070	michelle_lee_09@yahoo.com	713-591-349	2	1	0	2012-07-05 11:00:00	2012-06-15 12:49:35.873707	Does the one-hour cliff dwelling tour include the Harvey House?
7	f	Mike	Forbau	5603 Palisade Falls Trl	Kingwood	TX	77345	mforbau@yahoo.com	7137519072	2	0	2	2012-07-05 14:00:00	2012-06-18 09:35:18.747008	Please call 713.751.9072 with questions.  Thanks!
8	f	Marti 	Hogan Koehn	837 West San Mateo Drive	Gilbert	AZ	85233	mhkski@aol.com	602 6302353	8	0	0	2012-06-23 10:00:00	2012-06-19 00:03:27.432748	Some of us did this hike a few years ago- wanted to share since it is so good & some in our group have not been.
9	f	elizabeth	lundqvist	146 Central Park West	new york	NY	10023	Elizlund@gmail.com	9173301423	4	2	0	2012-07-03 15:00:00	2012-06-20 12:30:57.963285	One child is 3, the other is 11
10	f	David	Bollinger	2101 Greenslope Trl NE	Huntsville	AL	35811	bollingerd@knology.net	256-221-9160	2	1	0	2012-06-22 10:00:00	2012-06-20 17:13:26.87174	None
11	f	Nancy	Kantz	230 W. Birch	Clovis	CA	93611	nan.i.kantz@gmail.com	(559) 260-8342	2	0	0	2012-07-08 15:00:00	2012-06-21 16:52:29.697779	We would like to know if there are any fees for the tour.  Thank you!
13	f	Mayer	Schames	1160 S. Beverwil Drive	Los Angeles	CA	90035	mschames@ca.rr.com	310-869-8911	0	0	1	2012-08-11 09:00:00	2012-06-25 18:10:35.665593	I will only be in Santa Fe that day.  I would like to make the earliest tour possible.
14	f	Ashley	Disbrow	1420 Lee Circle	Yardley	PA	19067	adisbrow@andrew.cmu.edu	2155956987	3	0	0	2012-07-04 10:00:00	2012-06-27 09:03:48.25481	If this tour date is full, we are also available 2012-07-11. Any time of day is fine on either day as well. Thank you!
15	f	howard	fishman	8478 Windy Hill Drive	Colroado Springs	CO	80920	walkingfish35@yahoo.com	719-351-8175	2	2	0	2012-06-30 09:00:00	2012-06-29 21:53:58.750593	We will be there bu 8:30 tomorrow morning
16	f	George	Mace	1516 Gatewood Street	Leavenworth 	KS	66048	george.macejr@us.army.mil	19139046267	2	0	0	2012-07-08 09:00:00	2012-07-04 14:07:52.618533	Thank You!
17	t	Tass	Waterston	4101 Colgate Ave.	Dallas	TX	75225	tdwlaw@sbcglobal.net	214-455-4333	2	2	0	2012-07-12 11:00:00	2012-07-07 15:52:01.513055	\N
18	f	George	Mace	1516 Gatewood Street	Leavenworth 	KS	66048	george.macejr@us.army.mil	19139046267	2	0	0	2012-07-08 09:00:00	2012-07-08 07:13:55.870997	Thank You!
19	f	Frank	Muyard	1300 30th Street	Boulder	CO	80303	frank.muyard@gmail.com	720-347-0474	2	0	0	2012-07-12 09:00:00	2012-07-08 23:02:49.029719	Looking forward to go on the Puye Adventure Tour
20	f	greg 	smith	6133 w. 74th st.	los angeles	CA	90045	gregsmith819@hotmail.com	3106256864	0	0	2	2012-07-21 12:00:00	2012-07-11 08:31:17.175014	hello
21	f	Elaine	Smith	1612 Leopard Ct	College Station	TX	77840	relainesmith84@gmail.com	979-324-6094	2	1	1	2012-07-14 10:00:00	2012-07-11 17:46:57.360969	none
22	f	Elaine	Smith	1612 Leopard Ct	College Station	TX	77840	relainesmith84@gmail.com	979-324-6094	2	1	1	2012-07-15 10:00:00	2012-07-11 18:01:27.563673	We previously asked for a tour on Saturday, July 14, but we would like to change that to Sunday. Thank you
23	t	Cassandra	Smallwood	PO Box 731	Farwell	TX	79325	kcsmallwood@hotmail.com	8069469880	2	3	2	1969-12-31 17:00:00	2012-07-14 11:23:34.218533	\N
24	f	Stefanie	Shoults	1415 N. Jefferson Street 	Hobbs	NM	88240	stefanieshoultsgomez@hotmail.com	575-318-1329	2	1	0	2012-07-23 11:00:00	2012-07-15 12:03:10.977804	Please let us know the ability level required for the cliff dwelling tour?  Is is climbing requiring balance and strength?
25	f	laura	holland	19501 shelburne road	shaker hts.	OH	44118	dembroidery@aol.com	216-409-8604	2	1	0	2012-07-22 09:00:00	2012-07-16 09:05:14.111629	please call me re availability and if open due to flash floods
26	f	Rita	Luce	P.O. Box 1629	Green Valley	AZ	85622	rcal.zz@cox.net	520-609-2899	0	0	3	2012-07-17 10:00:00	2012-07-16 21:05:08.789765	Thank you
27	f	Beth	Parisi	213 W. Alicante	Santa Fe	NM	87505	osito@newmexico.com	505-982-1534	4	0	0	2012-07-27 11:00:00	2012-07-17 09:42:57.844391	Thank you
28	f	Chris	Curtis	131 Buckboard Dr	Bastrop	TX	78602	c.s.curtis@earthlink.net	512-422-2887	3	0	0	2012-07-21 10:00:00	2012-07-17 12:49:50.433523	This sounds really neat!
29	f	Diane	McBride	11250 Road 22	Cortez	CO	81321	trowelgal54@gmail.com	970-560-1643	0	0	6	2012-07-27 09:00:00	2012-07-18 07:47:32.550475	Is Porter Swentzell doing tours for you?  If so, we would like to have Porter do our tour. Also, our group may include a mentally challenged (Downs Syndrome)adult who is more like a young child.  I wasn't sure how to include her. Thanks for the information!
30	f	Sally	Heath	1928 East Haven Dr.	Santa Rosa	CA	95404	slheath@sonic.net	(707) 542-4459	0	0	3	2012-07-29 14:00:00	2012-07-18 18:07:50.499949	It would not let me make the reservation without putting something in the comments!
31	f	Tamina J	Dilling	125 Chesapeake Estates Dr.	Stevensville	MD	21666	taminaj@verizon.net	410 643-0299	2	2	0	2012-07-24 10:00:00	2012-07-22 23:26:09.237196	See you Tuesday morning.
32	f	Melinda	Morin	6 Cogswell Rd	Milan	NH	03588	melmrn41@gmail.com	16037231760	2	2	0	2012-07-24 14:00:00	2012-07-24 11:29:03.496881	The time is approximate. Please call my cellphone and or email with confirmation.
33	f	Rob	Thorwald	2515 Lunada Ln	Alamo	CA	94507	mail@thorwald.com	775-527-2582	1	0	0	2012-07-26 14:00:00	2012-07-24 20:44:02.220173	    
34	f	Sally	Heath	1928 East Haven Dr.	Santa Rosa	CA	95404	slheath@sonic.net	(707) 542-4459	0	0	3	2012-07-29 14:00:00	2012-07-27 18:32:11.486812	Please CANCEL the reservation I made for this tour a few days ago. One of the potential tour takers is ill so we will not be coming.
35	f	Deborah	Baxter	360 N. Yale	Wichita	KS	67208	deborah.baxter	316-213-6793	3	0	0	2012-07-31 11:00:00	2012-07-30 13:35:00.033391	Two members may not be able to go on the cliff dwelling portion---they will have to see how steep it is before determining that.
36	f	Jennifer	Clearman	6317 Belmont	Houston	TX	77005	jclearman@clearmanlaw.com	(713) 823-9360	2	2	0	2012-08-05 09:00:00	2012-08-04 10:33:11.993441	We look forward to our visit!
37	t	dvgnwwlbbx	dvgnwwlbbx	http://www.ljumcqmwcn.com/	New York	AK	rqyjawrk	ivjsbnouib@dpsric.com	rqyjawrk	1	1	1	1969-12-31 17:00:00	2012-08-08 13:47:44.192563	\N
38	t	kvgtjqevpv	kvgtjqevpv	http://www.yigzcvgdma.com/	Rome	AK	exzeabir	dpfnabszhf@qbpzbo.com	exzeabir	1	1	1	1969-12-31 17:00:00	2012-08-09 16:00:57.927558	\N
39	t	zrkabsgplt	zrkabsgplt	http://www.skqxixgdpc.com/	Amsterdam	AK	eozwcbgk	xotqzvljoq@kqfvgx.com	eozwcbgk	1	1	1	1969-12-31 17:00:00	2012-08-10 22:26:49.811273	\N
40	f	Jenessa	Shapiro	1924 washington ave	santa monica	CA	90403	jenessa.shapiro@gmail.com	480-332-3438	2	0	0	2012-08-19 10:00:00	2012-08-12 14:44:09.732367	Thank you. 
41	t	syzkmqasjp	syzkmqasjp	http://www.fodmlhjhlr.com/	New York	AK	acovrveg	xaaqpnyhbu@bqxucj.com	acovrveg	1	1	1	1969-12-31 17:00:00	2012-08-12 20:28:08.53073	\N
42	f	Susan	Senecah	435 Bushnell Road	Chatham	NY	12037	groundwork11@gmail.com	518-210-3027	0	0	2	2012-08-14 10:00:00	2012-08-13 09:31:26.766466	We're flexible on tour time, but prefer the cooler earlier times.
43	t	dqvxmynezp	dqvxmynezp	http://www.bjmdxdcsln.com/	Lyon	AK	mmqvfdug	nlkzqqtffo@kkuatn.com	mmqvfdug	1	1	1	1969-12-31 17:00:00	2012-08-14 20:26:38.892816	\N
44	f	Todd	Shaw	300 Camino De Los Marquez #4	Santa Fe	NM	87505	tddshw@gmail.com	585-200-7994	3	2	0	2012-08-17 12:00:00	2012-08-15 12:34:20.051127	q
45	t	mrxzlppwgc	mrxzlppwgc	http://www.ptaxglbnku.com/	Brussels	AK	naxaxcdu	biircuzwwq@efacpz.com	naxaxcdu	1	1	1	1969-12-31 17:00:00	2012-08-16 23:34:18.308315	\N
46	t	dbdefagagv	dbdefagagv	http://www.ncgkszbbvq.com/	NY	AK	zxdecxys	nqnrvhfjsy@znyrng.com	zxdecxys	1	1	1	1969-12-31 17:00:00	2012-08-19 03:05:56.664918	\N
47	f	howard	jacobs	59oxbow place	wayne	NJ	07470	Howie121333@gmail.com	9734647416	0	1	2	2012-08-22 11:00:00	2012-08-21 22:12:19.529411	We are in Santa Fe.
48	f	howard	jacobs	59oxbow place	wayne	NJ	07470	Howie121333@gmail.com	9734647416	0	1	2	2012-08-22 11:00:00	2012-08-21 22:12:19.788784	We are in Santa Fe.
49	f	howard	jacobs	59oxbow place	wayne	NJ	07470	Howie121333@gmail.com	9734647416	0	1	2	2012-08-22 11:00:00	2012-08-22 22:08:12.871927	We are in Santa Fe.
50	f	Reid	Givens	1872 Sierra Norte Loop NE	Rio Rancho	NM	87144	Viaduct Digital, LLC	505-504-8426	2	0	0	2012-08-29 09:00:00	2012-08-27 10:46:53.153516	This is a test
51	f	Carolyn	Gutierrez	6113 Downey St NE	Alb	NM	87109	jahlivec@yahoo.com	505-712-8922	1	4	1	2012-08-27 14:00:00	2012-08-27 11:32:42.943407	Puye Cliff Dwellings\r\n
52	f	Kenneth	Durham	909 26th Street NW	Washington	DC	20037	kdurham@gmail.com	202-338-2471	0	0	2	2012-09-17 10:00:00	2012-08-28 15:05:07.549924	Would like to pay cash
53	f	Kenneth	Durham	909 26th Street NW	Washington	DC	20037	kdurham@gmail.com	202-338-2471	0	0	2	2012-09-17 09:00:00	2012-09-01 14:52:45.103909	Would like to pay with cash
54	f	gary	bardwell	po box 552	woodacre	CA	94973	gjbardwell@gmail.com	415-302-2454	0	0	2	2012-09-06 09:00:00	2012-09-03 15:29:10.778681	will we notified if we are reserved by e-mail?
55	f	http://pexlnndfcbiq.com/	http://pexlnndfcbiq.com/	http://pexlnndfcbiq.com/	New York	KY	58895	ngjiyk@xshlky.com	94272421309	8	26	2	1969-12-31 17:00:00	2012-09-16 23:07:53.930285	35t744  <a href="http://cimgdrmzrlpl.com/">cimgdrmzrlpl</a>, [url=http://cxgkmhkhfoyk.com/]cxgkmhkhfoyk[/url], [link=http://ovreuauqzxof.com/]ovreuauqzxof[/link], http://egdcjhyogbvv.com/
56	f	Michelle	Chavarria	Hwy 30 & Santa Clara Rd	Santa Clara 	NM	87532	yomomma.com	505-917-6650	18	0	1	2012-09-20 09:00:00	2012-09-19 11:26:06.649048	This is a test.... This is only a test..\r\n
57	f	Andrea 	Garcia	Santa Clara 	Espanola	NM	87532	askabout me@puye.net	505-917-6650	1	0	0	2012-09-25 09:00:00	2012-09-19 11:35:08.401414	Testing 123
58	t	ANN drea 	Jenkins	123 Puye Rd Dwelling H-5	Puye	NM	87532	wheretherabbits@gather.com	505-747-0551	40	2	0	2012-09-30 10:00:00	2012-09-19 11:39:40.509971	\N
59	f	Carolyn	Gutierrez	Puye Cliff Dwellings	Santa Clara	NM	87532	c.gutierrez@santaclaradevcorp.com	505-712-8922	1	0	0	2012-09-27 09:00:00	2012-09-19 12:31:13.130343	YAY PUYE
60	f	reid	givens	1872 Sierra Norte Loop NE	Rio Rancho	NM	87144	reid@reidgivens.com	5055048426	2	0	0	2012-09-20 09:00:00	2012-09-19 13:01:58.320066	this is a test
61	t	Terri	Graves	3 Tierra de Tano	Santa Fw	NM	87506	terri@dmcnewmexico.com	5059130900	3	0	0	1969-12-31 17:00:00	2012-09-19 17:41:01.856055	\N
62	f	Terri	Graves	3 Tierra de Tano	santa Fe	NM	87506	terri@dmcnewmexico.com	505 989 8342	3	0	0	1969-12-31 17:00:00	2012-09-19 17:44:33.608276	Hope you are available.
63	t	Arlene	Larson	7656N County Road E	Hayward	WI	54843	alarson@lco.edu	7156344790x196	8	0	0	2012-10-30 10:00:00	2012-09-20 11:48:23.171095	\N
110	t	'baddata	'baddata	'baddata	'baddata	AL	'baddata	'baddata	'baddata	0	0	0	1969-12-31 17:00:00	2012-09-20 17:12:18.00631	\N
111	t	'baddata	'baddata	'baddata	'baddata	AL	'baddata	'baddata	'baddata	0	0	0	1969-12-31 17:00:00	2012-09-20 17:12:18.159651	\N
112	t	%27baddata	%27baddata	%27baddata	%27baddata	AL	%27baddata	%27baddata	%27baddata	0	0	0	1969-12-31 17:00:00	2012-09-20 17:12:18.306467	\N
120	f	'baddata	'baddata	'baddata	'baddata	AL	'baddata	'baddata	'baddata	0	0	0	1969-12-31 17:00:00	2012-09-20 17:12:20.801197	'baddata
121	f	'baddata	'baddata	'baddata	'baddata	AL	'baddata	'baddata	'baddata	0	0	0	1969-12-31 17:00:00	2012-09-20 17:12:20.96532	'baddata
122	f	%27baddata	%27baddata	%27baddata	%27baddata	AL	%27baddata	%27baddata	%27baddata	0	0	0	1969-12-31 17:00:00	2012-09-20 17:12:21.117231	%27baddata
130	t	Darbie	Cummings	2265 Calle de Ortiz	Los Lunas	NM	87031	darbie cummings@gmail.com	509-592-7137	6	0	0	2012-10-16 11:00:00	2012-09-23 19:51:41.888629	\N
131	f	Hal	Davis	1099 Scenic Loop Dr.	Goliad	TX	77963	bridgetandhal@yahoo.com	(713) 825-1202	0	0	12	2012-10-15 11:00:00	2012-09-25 16:51:46.54615	I left my name and ph.# on your answering machine. Hope to talk with someone for more info. Thanks -Hal Davis
132	f	Jim 	Mericle	PO Box 127	Forest Lake	MN	55025	jimmericle@msn.com	651-249-6261	2	0	0	2012-10-01 10:00:00	2012-09-25 21:59:33.882084	Looking forward to it.
133	f	Louise	Gibson	3906 Simms Ave. SE	Albuquerque	NM	871084338	lgibson@swcp.com	505-243-7773	1	0	1	2012-10-13 11:00:00	2012-09-27 11:56:28.652955	I have a gift certificate
134	f	Joel	Fishman	617 East Hillendale Road	Chadds Ford	PA	19317	jef13@mac.com	914.760.8952	2	1	0	2012-10-07 14:00:00	2012-09-29 14:57:43.212099	We are only in town for the weekend. Hope you can accommodate us.
135	f	Richard	Kawasaki	27932 Indian Rock Dr.	Rancho Palos Verdes	CA	90275	rtkawasaki@verizon.net	310 3773468	0	0	3	2012-10-01 10:00:00	2012-09-30 20:23:47.438418	arrived in Santa Fe 9/30
136	f	Carolyn	Gutierrez	6113 Downey St N	Albuquerque	NM	87109	fgnklgbvslkv	505-917-6650	1	0	0	2012-10-03 10:00:00	2012-10-02 11:52:04.948899	Hi there!!!\r\n
137	f	Andy	Henderson	355?cedar Lane Farm	New Hill	NC	27562	Andyh6552@gmail.com	919-812-0701	2	0	0	2012-10-05 11:00:00	2012-10-04 16:56:07.815075	Pure adventure tour
139	f	Mark	Warren	330 East Palace Avenue 	Santa Fe	NM	87501	mwarren@xplornet.com	505-986-0000	2	0	0	2012-10-13 10:00:00	2012-10-06 13:22:34.175192	We'll be staying in Santa Fe starting Wednesday. If this tour is not available on Saturday, please email or leave a message at the hotel (phone number above) Thank you.
140	f	Anne	Christopher	3 Senda Mescal	Santa Fe	NM	87508	bachrist@msn.com	5054666922	0	0	4	2012-10-11 12:00:00	2012-10-11 07:57:49.188962	Cell phone: 858-864-2115
141	f	Cassie	Smith	6316 Broadway Street	Indianapolis	IN	46220	cannon.boom@yahoo.com	317- 696-5496	1	1	2	2012-10-12 10:00:00	2012-10-12 08:58:25.448413	Would like more information.
142	f	Cassie	Smith	6316 Broadway Street	Indianapolis	IN	46220	cannon.boom@yahoo.com	317- 696-5496	1	1	2	2012-10-12 10:00:00	2012-10-12 09:50:17.609523	Would like more information.
143	t	ggntvbvcb	ggntvbvcb	FXZEqsrhlBPXWH	New York	IN	31756	ackzme@zfxupc.com	77407630508	4	11	9	1969-12-31 17:00:00	2012-10-18 16:19:15.226956	\N
144	f	Jardon	Bouska	2219 Stephen long dr ne	Atlanta	GA	30305	Jtbouska@comcast.net	4049646913	2	0	0	2012-10-20 12:00:00	2012-10-20 10:07:16.204986	Thanks
209	f	Warren	Clem	827 Rose Harbour Court	Terre Haute	IN	47805	w.wclem@frontier.com	8122406807	0	0	2	2012-10-22 10:00:00	2012-10-21 20:47:17.24652	no comment
210	f	Robert	Dorsey	730 Humboldt st	Denver	CO	80218	Vintrk52@aol.com	303 829 4108	2	0	0	2012-10-24 12:00:00	2012-10-24 09:19:30.596399	Please call to confirm
211	f	Louis	Leung	Eldorado Hotel, 309 West San Francisco St	Santa Fe	NM	87501	lockhart411@hotmail.com	5059954567	0	0	2	2012-11-06 13:00:00	2012-10-30 11:30:35.079444	Date  is Nov.,6.  Please email if you want to contact.  We are travelling now.  Not reachable by phone.
213	f	ken	terry	157 s armijo lane	santa fe	NM	87501	kenterry@newmexico.com	5059891145	14	2	1	1969-12-31 17:00:00	2012-11-04 17:09:13.265017	date is for November 23rd @ 10:00am\r\nthanks,\r\nKen
215	t	sxtcknrn	sxtcknrn	hsJsFqEUDPiCiGiLl	DqybOaVioiyHOSOjQj	FL	46985	deogiv@inskyb.com	9257739597	24	35	2	1969-12-31 17:00:00	2012-11-17 01:39:46.498942	\N
216	f	Aarah	Logan	7065 camden ct	Saint Louis	MO	63130	aarahlogan@gmail.com	312-479-8081	1	2	0	2012-11-19 10:00:00	2012-11-19 10:02:13.017269	Would like to request Saturday November 24th, 2012
277	t	Margaret	Heaton	715 Linden 	Wilmette	IL	60091	mmartinh@sbcglobal.net	8473025492	3	1	0	2012-12-26 14:00:00	2012-12-07 15:45:49.320028	\N
278	t	ctbxppdein	ctbxppdein	http://www.eecyxtjcda.com/	Paris	AK	tyyolyoo	vlqxsvnmgb@bypusw.com	tyyolyoo	1	1	1	1969-12-31 17:00:00	2012-12-08 23:52:01.154155	\N
279	t	zxeqwqvdyk	zxeqwqvdyk	http://www.enydpqvzls.com/	New York	AK	utzokqkb	jkoshqzlkm@hvqfey.com	utzokqkb	1	1	1	1969-12-31 17:00:00	2012-12-10 02:49:13.416874	\N
280	t	zckkxzpfzz	zckkxzpfzz	http://www.qqoxlezdsd.com/	New York	AK	yayfgkgb	yfkxtlgnxt@toskbi.com	yayfgkgb	1	1	1	1969-12-31 17:00:00	2012-12-11 01:55:10.494087	\N
281	f	Jeanette	Auld	9005 Collinfield Dr.	Austin	TX	78758	jeanetteauld@gmail.com	5126239737	2	0	0	2013-01-02 11:00:00	2012-12-13 10:21:47.197364	Thanks for Any Information,\r\nJeanette Auld
282	f	tzhzgdtlul	tzhzgdtlul	ncMrMvASCBPQ	EJumuCyjv	ID	oBKGFtFVJn	tligzd@mcskav.com	sIlAsxBCu	7	7	13	1969-12-31 17:00:00	2012-12-14 06:16:14.630904	RA1i44  <a href="http://fmktkgvwsvco.com/">fmktkgvwsvco</a>, [url=http://izqjbqvtpngl.com/]izqjbqvtpngl[/url], [link=http://gfecleyawfwf.com/]gfecleyawfwf[/link], http://qrjfwxwhwenb.com/
343	t	ukfhawvbkm	ukfhawvbkm	http://www.mvnwvddwfm.com/	Los Angeles	AK	igxvlxlb	iczkaehyfm@boslgw.com	igxvlxlb	1	1	1	1969-12-31 17:00:00	2012-12-24 16:43:00.214291	\N
344	f	Jeanette	Auld	9005 Collinfield Dr.	Austin	TX	78758	jeanetteauld@gmail.com	5126239737	2	0	0	2013-01-03 11:00:00	2012-12-28 09:06:19.037068	Thanks for any information.
345	t	Hillary	Kyle	8500 W. 159th Street	Overland Park	KS	66223	Hkyle@graceks.org	913-814-7223	35	0	0	2013-03-20 11:00:00	2012-12-28 12:48:40.247613	\N
346	t	Neil E	Green	4 Wicklow Lane	Hilton Head	SC	29928	neil.e.green@Vanderbilt.Edu	843-686-4569	0	0	24	2013-07-29 10:00:00	2013-01-06 15:14:16.642724	\N
347	f	Kathryn	Udenberg	2475 Slaughters Lake Road	Hanson	KY	42413	katie.udenberg@mckesson.com	270-635-0145	6	0	0	2013-03-23 10:00:00	2013-01-09 15:04:17.435278	Thank you
348	f	Lisa	Dattilo	1531 15th Street	Santa Monica	CA	90404	Dznlisa@gmail.com	3106177882	1	0	0	2013-01-17 10:00:00	2013-01-15 23:28:23.06053	Thank you
421	t	Ashley	Deleon	300 The Fenway	Boston	MA	02115	asb@simmons.edu	8572253867	14	0	0	2013-03-13 14:00:00	2013-01-21 17:38:42.679599	\N
422	t	hfyjqkcbgz	hfyjqkcbgz	http://www.mmxpvhnnrv.com/	Rome	AK	cltjqwrg	tdjxhhglpu@ktfwvl.com	cltjqwrg	1	1	1	1969-12-31 17:00:00	2013-01-22 09:00:52.324589	\N
423	f	Susan	Holbrook	1393 S York Street	Denver	CO	80210	sbhballet@gmail.com	3039210418	0	0	1	2013-01-31 11:00:00	2013-01-24 15:17:57.213004	Looking forward to it
424	t	zbkgzatwur	zbkgzatwur	http://www.dpisgbrimw.com/	Brussels	AK	njueybcf	klgfnannae@txyzmr.com	njueybcf	1	1	1	1969-12-31 17:00:00	2013-01-25 16:25:05.375335	\N
425	t	flyinepbhk	flyinepbhk	http://www.zankwfskva.com/	Lyon	AK	itzhzdqi	dqyvzuchpz@ohnoia.com	itzhzdqi	1	1	1	1969-12-31 17:00:00	2013-01-27 13:01:02.698426	\N
426	t	Thomas	Kuzmic	Oklahoma State University, 08C Ag Hall	Stillwater	OK	74078	thomas.kuzmic@okstate.edu	405-744-5463	12	0	0	2013-05-16 10:00:00	2013-02-04 16:32:47.918463	\N
\.


--
-- Data for Name: reservations_tours; Type: TABLE DATA; Schema: public; Owner: puye
--

COPY reservations_tours (reservation_id, tours_id) FROM stdin;
1	3
2	2
3	2
5	2
6	2
7	1
8	1
9	1
10	1
11	2
13	1
14	1
15	1
16	1
17	2
18	1
19	1
20	2
21	2
22	2
23	1
23	2
23	3
23	4
24	1
25	1
26	3
27	1
28	1
29	1
30	2
31	2
32	2
33	1
34	2
35	1
36	2
40	1
42	1
44	2
47	2
48	2
49	2
50	1
51	1
52	1
53	1
54	1
56	1
57	4
58	1
59	2
60	1
61	2
62	2
63	1
63	2
63	3
130	2
131	3
132	1
133	1
134	1
135	1
136	4
136	2
136	3
136	1
137	1
139	2
140	1
141	2
142	2
144	2
209	2
210	1
211	1
213	3
216	4
216	3
277	1
277	2
277	3
281	1
344	1
345	1
345	2
346	1
346	2
346	3
347	1
348	3
421	2
423	1
426	1
\.


--
-- Data for Name: shop_cart; Type: TABLE DATA; Schema: public; Owner: puye
--

COPY shop_cart (id, session_name, created) FROM stdin;
3	om9t0bsn50bibpm3q30jtolrf7	2012-03-30 00:12:55.7396
4	om9t0bsn50bibpm3q30jtolrf7	2012-03-30 01:30:57.562852
5	b2itebjvs1it4l1ervuutg6ll6	2012-04-05 14:41:22.202759
6	b2itebjvs1it4l1ervuutg6ll6	2012-04-05 16:26:13.052462
7	vusba8o2vma57ecpgmk6a59c84	2012-04-06 15:43:15.48866
8	ccbhnughggq3jt91sdacehrjs0	2012-04-12 13:13:06.922369
9	58124h4g4rnaugjirscp5ul0r2	2012-04-20 08:29:13.003769
10	uhhfj9d8g0jb0dohrf2saq6792	2012-04-20 08:29:27.528679
11	r4ku7r2j499s92ra4ishr314o3	2012-04-20 08:29:29.105294
12	blkq78devuh0faal2q23q28f06	2012-04-20 08:30:02.309874
13	l395gierlo5d3ehe83ipvvp8q4	2012-04-20 08:30:12.20392
14	9j5sihr31pj5cao70osv4bgv62	2012-04-20 13:59:04.438463
15	t0m0kvakrap4k4g9rs0inrki27	2012-04-21 16:44:04.000878
16	qk6k1s02moqo0ff19nnv8lc330	2012-04-25 15:09:16.957469
17	69i8bu9042cfkbqkbbp5fh4qd1	2012-04-25 16:57:22.949132
18	75a4o5kkm3dirsffmkmb8rvvr1	2012-05-03 23:55:50.386425
19	frujbc684ief7gam183704kmu7	2012-05-04 13:33:40.552503
\.


--
-- Data for Name: shop_cart_items; Type: TABLE DATA; Schema: public; Owner: puye
--

COPY shop_cart_items (id, item_id, cart_id, quantity, price) FROM stdin;
3	1	3	2	6.00
4	1	4	1	6.00
5	2	4	2	8.00
6	2	5	1	8.00
7	1	5	1	6.00
8	2	7	1	8.00
9	1	14	1	6.00
10	3	15	1	29.99
11	4	16	1	1.00
12	3	17	3	29.99
13	2	19	2	8.00
\.


--
-- Data for Name: shop_categories; Type: TABLE DATA; Schema: public; Owner: puye
--

COPY shop_categories (id, name, active) FROM stdin;
1	Clothing	t
2	Paper	t
3	Books	t
4	Donations	t
\.


--
-- Data for Name: shop_item_categories; Type: TABLE DATA; Schema: public; Owner: puye
--

COPY shop_item_categories (category_id, item_id) FROM stdin;
2	1
4	4
1	2
\.


--
-- Data for Name: shop_items; Type: TABLE DATA; Schema: public; Owner: puye
--

COPY shop_items (id, name, sku, details, price, active, image_path, free_shipping, weight, quantity, available_online) FROM stdin;
1	Puye Cliffs Dwellings Post Card	pstcrd	Postcard of Puye Cliffs Dwellings	6.00	t	http://beta.puyecliffs.biz/files/product-photo-card.png	t	0.60	10	10
3	Rain	0513242	Follow the journey of our ancestors through the 	29.99	f	http://beta.puyecliffs.biz/files/IMG_1499.JPG	f	1.00	50	24
4	Donation	donate	Donate to Puye Cliffs	1.00	t		t	0.00	10000	100
2	Puye Cliffs Dwellings leather logo bracelet	pcdlb	Puye Cliff Dwellings leather logo bracelet. 9" long, 3/4" wide.  One size. Brown. leather with metal snap.	8.00	t	http://beta.puyecliffs.biz/files/product-photo-band.png	f	0.50	10	10
\.


--
-- Data for Name: slideshow; Type: TABLE DATA; Schema: public; Owner: puye
--

COPY slideshow (id, image_path, link_to, sort_order) FROM stdin;
10	/files/slideshow/puye_inside.png		9
7	/files/slideshow/puye_ladder.png		6
4	/files/slideshow/puye_cliff.png		3
5	/files/slideshow/puye_dancers3.png		4
6	/files/slideshow/puye_dancers2.png		5
9	/files/slideshow/puye_ruins.png		8
8	/files/slideshow/puye_hawk.png		7
3	/files/slideshow/puye_dancers.png		2
1	/files/slideshow/puye_dancers4.png	\N	1
\.


--
-- Data for Name: tours; Type: TABLE DATA; Schema: public; Owner: puye
--

COPY tours (id, name, active) FROM stdin;
1	Puye Adventure Tour	t
2	One-hour Cliff Dwelling	t
3	One-hour Mesa Tour	t
4	Harvey House Interpretive Center	t
\.


--
-- Data for Name: videos; Type: TABLE DATA; Schema: public; Owner: puye
--

COPY videos (id, video_id, active) FROM stdin;
1	gW1OrpUwdC8	t
\.


--
-- Name: addresses_pkey; Type: CONSTRAINT; Schema: public; Owner: puye; Tablespace: 
--

ALTER TABLE ONLY addresses
    ADD CONSTRAINT addresses_pkey PRIMARY KEY (id);


--
-- Name: events_pkey; Type: CONSTRAINT; Schema: public; Owner: puye; Tablespace: 
--

ALTER TABLE ONLY events
    ADD CONSTRAINT events_pkey PRIMARY KEY (id);


--
-- Name: orders_pkey; Type: CONSTRAINT; Schema: public; Owner: puye; Tablespace: 
--

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


--
-- Name: partners_pkey; Type: CONSTRAINT; Schema: public; Owner: puye; Tablespace: 
--

ALTER TABLE ONLY partners
    ADD CONSTRAINT partners_pkey PRIMARY KEY (id);


--
-- Name: reservations_pkey; Type: CONSTRAINT; Schema: public; Owner: puye; Tablespace: 
--

ALTER TABLE ONLY reservations
    ADD CONSTRAINT reservations_pkey PRIMARY KEY (id);


--
-- Name: shop_cart_items_pkey; Type: CONSTRAINT; Schema: public; Owner: puye; Tablespace: 
--

ALTER TABLE ONLY shop_cart_items
    ADD CONSTRAINT shop_cart_items_pkey PRIMARY KEY (id);


--
-- Name: shop_cart_pkey; Type: CONSTRAINT; Schema: public; Owner: puye; Tablespace: 
--

ALTER TABLE ONLY shop_cart
    ADD CONSTRAINT shop_cart_pkey PRIMARY KEY (id);


--
-- Name: shop_categories_pkey; Type: CONSTRAINT; Schema: public; Owner: puye; Tablespace: 
--

ALTER TABLE ONLY shop_categories
    ADD CONSTRAINT shop_categories_pkey PRIMARY KEY (id);


--
-- Name: shop_items_pkey; Type: CONSTRAINT; Schema: public; Owner: puye; Tablespace: 
--

ALTER TABLE ONLY shop_items
    ADD CONSTRAINT shop_items_pkey PRIMARY KEY (id);


--
-- Name: slideshow_pkey; Type: CONSTRAINT; Schema: public; Owner: puye; Tablespace: 
--

ALTER TABLE ONLY slideshow
    ADD CONSTRAINT slideshow_pkey PRIMARY KEY (id);


--
-- Name: tours_pkey; Type: CONSTRAINT; Schema: public; Owner: puye; Tablespace: 
--

ALTER TABLE ONLY tours
    ADD CONSTRAINT tours_pkey PRIMARY KEY (id);


--
-- Name: videos_pkey; Type: CONSTRAINT; Schema: public; Owner: puye; Tablespace: 
--

ALTER TABLE ONLY videos
    ADD CONSTRAINT videos_pkey PRIMARY KEY (id);


--
-- Name: addresses_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: puye
--

ALTER TABLE ONLY addresses
    ADD CONSTRAINT addresses_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(id);


--
-- Name: event_dates_event_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: puye
--

ALTER TABLE ONLY event_dates
    ADD CONSTRAINT event_dates_event_id_fkey FOREIGN KEY (event_id) REFERENCES events(id);


--
-- Name: orders_billing_address_fkey; Type: FK CONSTRAINT; Schema: public; Owner: puye
--

ALTER TABLE ONLY orders
    ADD CONSTRAINT orders_billing_address_fkey FOREIGN KEY (billing_address) REFERENCES addresses(id);


--
-- Name: orders_cart_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: puye
--

ALTER TABLE ONLY orders
    ADD CONSTRAINT orders_cart_id_fkey FOREIGN KEY (cart_id) REFERENCES shop_cart(id);


--
-- Name: orders_shipping_address_fkey; Type: FK CONSTRAINT; Schema: public; Owner: puye
--

ALTER TABLE ONLY orders
    ADD CONSTRAINT orders_shipping_address_fkey FOREIGN KEY (shipping_address) REFERENCES addresses(id);


--
-- Name: orders_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: puye
--

ALTER TABLE ONLY orders
    ADD CONSTRAINT orders_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(id);


--
-- Name: reservations_tours_reservation_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: puye
--

ALTER TABLE ONLY reservations_tours
    ADD CONSTRAINT reservations_tours_reservation_id_fkey FOREIGN KEY (reservation_id) REFERENCES reservations(id);


--
-- Name: reservations_tours_tours_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: puye
--

ALTER TABLE ONLY reservations_tours
    ADD CONSTRAINT reservations_tours_tours_id_fkey FOREIGN KEY (tours_id) REFERENCES tours(id);


--
-- Name: shop_cart_items_cart_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: puye
--

ALTER TABLE ONLY shop_cart_items
    ADD CONSTRAINT shop_cart_items_cart_id_fkey FOREIGN KEY (cart_id) REFERENCES shop_cart(id);


--
-- Name: shop_cart_items_item_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: puye
--

ALTER TABLE ONLY shop_cart_items
    ADD CONSTRAINT shop_cart_items_item_id_fkey FOREIGN KEY (item_id) REFERENCES shop_items(id);


--
-- Name: shop_item_categories_category_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: puye
--

ALTER TABLE ONLY shop_item_categories
    ADD CONSTRAINT shop_item_categories_category_id_fkey FOREIGN KEY (category_id) REFERENCES shop_categories(id);


--
-- Name: shop_item_categories_item_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: puye
--

ALTER TABLE ONLY shop_item_categories
    ADD CONSTRAINT shop_item_categories_item_id_fkey FOREIGN KEY (item_id) REFERENCES shop_items(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;


--
--

