--
--

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: home_cycle; Type: TABLE; Schema: public; Owner: santaclaran; Tablespace: 
--

CREATE TABLE home_cycle (
    id integer NOT NULL,
    path character varying(255) NOT NULL,
    link_to character varying(255) NOT NULL,
    sort_order integer DEFAULT 1 NOT NULL
);


ALTER TABLE public.home_cycle OWNER TO santaclaran;

--
-- Name: home_cycle_id_seq; Type: SEQUENCE; Schema: public; Owner: santaclaran
--

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


ALTER TABLE public.home_cycle_id_seq OWNER TO santaclaran;

--
-- Name: home_cycle_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: santaclaran
--

ALTER SEQUENCE home_cycle_id_seq OWNED BY home_cycle.id;


--
-- Name: hotel_images; Type: TABLE; Schema: public; Owner: santaclaran; Tablespace: 
--

CREATE TABLE hotel_images (
    id integer NOT NULL,
    path character varying(255) NOT NULL,
    description character varying(255) NOT NULL,
    sort_order integer DEFAULT 1 NOT NULL
);


ALTER TABLE public.hotel_images OWNER TO santaclaran;

--
-- Name: hotel_images_id_seq; Type: SEQUENCE; Schema: public; Owner: santaclaran
--

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


ALTER TABLE public.hotel_images_id_seq OWNER TO santaclaran;

--
-- Name: hotel_images_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: santaclaran
--

ALTER SEQUENCE hotel_images_id_seq OWNED BY hotel_images.id;


--
-- Name: hotel_specials; Type: TABLE; Schema: public; Owner: santaclaran; Tablespace: 
--

CREATE TABLE hotel_specials (
    id integer NOT NULL,
    title character varying(255) NOT NULL,
    path character varying(255),
    description text NOT NULL,
    special_id integer NOT NULL,
    sort_order integer DEFAULT 1 NOT NULL
);


ALTER TABLE public.hotel_specials OWNER TO santaclaran;

--
-- Name: hotel_specials_id_seq; Type: SEQUENCE; Schema: public; Owner: santaclaran
--

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


ALTER TABLE public.hotel_specials_id_seq OWNER TO santaclaran;

--
-- Name: hotel_specials_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: santaclaran
--

ALTER SEQUENCE hotel_specials_id_seq OWNED BY hotel_specials.id;


--
-- Name: promotions; Type: TABLE; Schema: public; Owner: santaclaran; Tablespace: 
--

CREATE TABLE promotions (
    id integer NOT NULL,
    title character varying(255) NOT NULL,
    when_it_is character varying(255) NOT NULL,
    description text NOT NULL,
    path character varying(255) NOT NULL,
    sort_order integer DEFAULT 1 NOT NULL
);


ALTER TABLE public.promotions OWNER TO santaclaran;

--
-- Name: promotions_id_seq; Type: SEQUENCE; Schema: public; Owner: santaclaran
--

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


ALTER TABLE public.promotions_id_seq OWNER TO santaclaran;

--
-- Name: promotions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: santaclaran
--

ALTER SEQUENCE promotions_id_seq OWNED BY promotions.id;


--
-- Name: testimonials; Type: TABLE; Schema: public; Owner: santaclaran; Tablespace: 
--

CREATE TABLE testimonials (
    id integer NOT NULL,
    title character varying(255) NOT NULL,
    description text NOT NULL,
    link character varying(255) NOT NULL
);


ALTER TABLE public.testimonials OWNER TO santaclaran;

--
-- Name: testimonials_id_seq; Type: SEQUENCE; Schema: public; Owner: santaclaran
--

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


ALTER TABLE public.testimonials_id_seq OWNER TO santaclaran;

--
-- Name: testimonials_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: santaclaran
--

ALTER SEQUENCE testimonials_id_seq OWNED BY testimonials.id;

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

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

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

ALTER SEQUENCE users_id_seq OWNED BY users.id;


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

ALTER TABLE home_cycle ALTER COLUMN id SET DEFAULT nextval('home_cycle_id_seq'::regclass);


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

ALTER TABLE hotel_images ALTER COLUMN id SET DEFAULT nextval('hotel_images_id_seq'::regclass);


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

ALTER TABLE hotel_specials ALTER COLUMN id SET DEFAULT nextval('hotel_specials_id_seq'::regclass);


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

ALTER TABLE promotions ALTER COLUMN id SET DEFAULT nextval('promotions_id_seq'::regclass);


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

ALTER TABLE testimonials ALTER COLUMN id SET DEFAULT nextval('testimonials_id_seq'::regclass);


--
-- Data for Name: home_cycle; Type: TABLE DATA; Schema: public; Owner: santaclaran
--

COPY home_cycle (id, path, link_to, sort_order) FROM stdin;
5	1322244139puye.jpg	http://www.santaclaran.com/attractions.php#puye-cliff-dwellings	6
6	1322244174santa_claran_dance.jpg	http://www.santaclaran.com/attractions.php#the-santa-clara-pueblo	5
3	1322244106hotel_lobby.jpg	http://www.santaclaran.com/information.php	4
2	1322244086golf_couse.jpg	http://www.santaclaran.com/attractions.php#black-mesa-golf-club	3
1	1322244011casino.jpg	http://www.santaclaran.com/gaming.php	2
4	1322244117hotel_outside.jpg	http://www.santaclaran.com/information.php	1
\.


--
-- Data for Name: hotel_images; Type: TABLE DATA; Schema: public; Owner: santaclaran
--

COPY hotel_images (id, path, description, sort_order) FROM stdin;
4	05.jpg	Chimayo inspired bedding adorn our luxurious suites	4
5	06.jpg	Coffee Bar in the Lobby	5
6	07.jpg	Wall sconces handmade by local artisans	6
7	10.jpg	Executive Hospitality Suite	7
8	11.jpg	Native American art in all rooms	8
9	12.jpg	Traditional Mexican tile in suites	9
10	13.jpg	A grand entry way to the lounge area	10
11	14.jpg	The wooden wall behind the front desk was hand carved	11
2	03.jpg	State of the Art Fitness Center	3
3	04.jpg	All rugs are hand woven	2
13	132191400415.jpg	Authentic architectural features throughout the hotel and casino	12
1	01.jpg	Relax in Main Lobby in front of kiva fireplace	1
\.


--
-- Data for Name: hotel_specials; Type: TABLE DATA; Schema: public; Owner: santaclaran
--

COPY hotel_specials (id, title, path, description, special_id, sort_order) FROM stdin;
\.


--
-- Data for Name: promotions; Type: TABLE DATA; Schema: public; Owner: santaclaran
--

COPY promotions (id, title, when_it_is, description, path, sort_order) FROM stdin;
10	Seniors Day	Wednesdays in February	<p>3X Points from 8am - 4pm. $50 Hot\r\nSeat drawings every half hour from\r\n8:30 am - 2pm. 99 cent breakfast served\r\nfrom 8am - 11am.</p>	seniors_day.jpeg	1
6	Military and Public Service Appreciation Day	Saturdays in February	<p>Show your Military or Public Service\r\ncredentials between 8am - 4pm and\r\nreceive $10 in Slot Play.\r\n</p>\r\n<p>99 cent&nbsp;breakfast served from 8am - 11am.</p>	military_day.jpeg	2
76	3X Points	Tuesdays in January	<p>Earn triple points on Tuesdays\r\nbetween 8am - 11pm.&nbsp;</p>	13558098223x_points.jpg	3
77	2X Points	Tuesdays in February	<p>Receive double points on&nbsp;Tuesdays between 8am - 11pm.</p>	13593960562x_points.jpg	4
79	Super Cash Bullseye	Fridays and Saturdays in February	<p>Every Friday and&nbsp;Saturday in February through March 2<sup>nd</sup></p>\r\n<p>2 Winners every hour from 7pm - 11pm</p>\r\n<p>Receive an entry for every 50 points earned</p>\r\n<p>Begin earning entries on January 26<sup>th</sup></p>	1359396132SuperBullEyeLogo_72.jpg	6
78	Hot Seat	Thursdays in February	<p>Win $250 Cash every hour&nbsp;between 7pm - 11pm.</p>	1359396091hot_seat.jpg	5
80	Slammin Slots	Sundays in February	<p>February 10th through February 24th</p>\r\n<p>Five Winners Every Hour!&nbsp;</p>\r\n<p>Drawings every hour between 4pm - 8pm</p>\r\n<p>Receive an entry for every 50 points earned</p>\r\n<p>Begin earning entries on February 8<sup>th</sup></p>	1359396164slamming_slots.jpg	7
\.


--
-- Data for Name: testimonials; Type: TABLE DATA; Schema: public; Owner: santaclaran
--

COPY testimonials (id, title, description, link) FROM stdin;
1	An incredible helping hand!  	On September 16th, 2011, My stepson Tommy and I were on a cycling tour in New Mexico. On that day, enroute from Taos to Espanola, Tommy broke a spoke on his bike. We checked in at the Santa Claran	http://www.tripadvisor.com/ShowUserReviews-g47025-d1674852-r120443236-Santa_Claran_Hotel-Espanola_New_Mexico.html
2	Great hotel, food and casino	I recently spent 4 nights and this was such a good find. Really nice people work there, beautiful big rooms, great do orations, excellent food in cafe and the Black Mesa steakhouse was excellent. Not for to drive to Taos and the Rio Grande Gorge Bridge	http://www.tripadvisor.com/ShowUserReviews-g47025-d1674852-r120443236-Santa_Claran_Hotel-Espanola_New_Mexico.html
\.


--
-- Name: home_cycle_pkey; Type: CONSTRAINT; Schema: public; Owner: santaclaran; Tablespace: 
--

ALTER TABLE ONLY home_cycle
    ADD CONSTRAINT home_cycle_pkey PRIMARY KEY (id);


--
-- Name: hotel_images_pkey; Type: CONSTRAINT; Schema: public; Owner: santaclaran; Tablespace: 
--

ALTER TABLE ONLY hotel_images
    ADD CONSTRAINT hotel_images_pkey PRIMARY KEY (id);


--
-- Name: hotel_specials_pkey; Type: CONSTRAINT; Schema: public; Owner: santaclaran; Tablespace: 
--

ALTER TABLE ONLY hotel_specials
    ADD CONSTRAINT hotel_specials_pkey PRIMARY KEY (id);


--
-- Name: promotions_pkey; Type: CONSTRAINT; Schema: public; Owner: santaclaran; Tablespace: 
--

ALTER TABLE ONLY promotions
    ADD CONSTRAINT promotions_pkey PRIMARY KEY (id);


--
-- Name: testimonials_pkey; Type: CONSTRAINT; Schema: public; Owner: santaclaran; Tablespace: 
--

ALTER TABLE ONLY testimonials
    ADD CONSTRAINT testimonials_pkey PRIMARY KEY (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;


--
--

