insert into Customer (username, password, name) values ('gavin', 'foobar', 'Gavin King')
insert into Customer (username, password, name) values ('demo', 'demo', 'Demo User')

insert into Hotel (id, name, address, city, state, zip, country) values (1, 'Marriott Courtyard', 'Tower Place, Buckhead', 'Atlanta', 'GA', '30305', 'USA')
insert into Room (id, hotel_id, name, description, price, included) values (1, 1, 'King Room', 'One king bed. Table with chairs. Complimentary high-speed Internet access. TV with premium cable and pay movies. Direct-dial speakerphone with voice mail. Coffee/tea maker. Hair dryer. Iron/ironing board.', 120, true)
insert into Room (id, hotel_id, name, description, price, included) values (2, 1, 'Double Room', 'Two double beds. Table with chairs. Complimentary high-speed Internet access. TV with premium cable and pay movies. Direct-dial speakerphone with voice mail. Coffee/tea maker. Hair dryer. Iron/ironing board.', 120, false)

insert into Hotel (id, name, address, city, state, zip, country) values (2, 'Doubletree', 'Tower Place, Buckhead', 'Atlanta', 'GA', '30305', 'USA')
insert into Room (id, hotel_id, name, description, price, included) values (3, 2, 'Standard 1 King', 'One king bed. Wireless Internet access (surcharge). TV with video games. Marble bathroom. Complimentary newspaper. Air conditioning.', 180, true)
insert into Room (id, hotel_id, name, description, price, included) values (4, 2, 'Deluxe King w/sofabed', 'One king Sweet Dreams bed and one sofa bed. Business-district view. Located on floors 36. 315 square feet. Contemporary furnishings. Ergonomic work center with dual-line phone and wireless Internet access (surcharge). Video games. Marble bathroom. Complimentary newspaper. Air conditioning.', 250, false)
insert into Room (id, hotel_id, name, description, price, included) values (5, 2, 'Standard 1 King (smoking)', 'One king bed. Wireless Internet access (surcharge). TV with video games. Marble bathroom. Complimentary newspaper. Air conditioning. Smoking.', 180, false)
insert into Room (id, hotel_id, name, description, price, included) values (6, 2, 'Standard 2 Doubles', 'Two double beds. Contemporary furnishings. Ergonomic work center with dual-line phone and wireless Internet access (surcharge). Video games. Marble bathroom. Complimentary newspaper. Air conditioning.', 180, false)
insert into Room (id, hotel_id, name, description, price, included) values (7, 2, 'Standard 2 Dbls (smoking)', 'Two double beds. Contemporary furnishings. Ergonomic work center with dual-line phone and wireless Internet access (surcharge). Video games. Marble bathroom. Complimentary newspaper. Air conditioning. Smoking.', 180, false)

insert into Hotel (id, name, address, city, state, zip, country) values (3, 'W Hotel', 'Union Square, Manhattan', 'NY', 'NY', '10011', 'USA')
insert into Room (id, hotel_id, name, description, price, included) values (8, 3, 'Cozy Room', 'One queen featherbed with pillowtop mattress, 350-thread-count linens, and goose-down comforter and pillows. Located on floors 3-14. 170-180 square feet. Decorated in earth tones, leaf motifs, and hand-painted fabrics. CD and DVD players, minibar, multi-line cordless phone, and high-speed Internet access (surcharge). Bathroom has shower only or shower/tub combination, makeup mirror, terry/pique spa robes, and Bliss bath products.', 450, true)
insert into Room (id, hotel_id, name, description, price, included) values (9, 3, 'Spectacular Room', 'No description', 600, false)

insert into Hotel (id, name, address, city, state, zip, country) values (4, 'W Hotel', 'Lexington Ave, Manhattan', 'NY', 'NY', '10011', 'USA')
insert into Room (id, hotel_id, name, description, price, included) values (10, 4, 'Wonderful Room', 'One king bed. Desk. Cable/satellite TV with pay movies and DVD player. CD player. Coffee/tea maker and minibar. Hair dryer. Iron/ironing board. In-room safe. Complimentary newspaper.', 450, false)
insert into Room (id, hotel_id, name, description, price, included) values (11, 4, 'Spectacular Room', 'One king bed. Desk. Cable/satellite TV with pay movies and DVD player. CD player. Coffee/tea maker and minibar. Hair dryer. Iron/ironing board. In-room safe. Complimentary newspaper.', 600, true)
insert into Room (id, hotel_id, name, description, price, included) values (12, 4, 'Fantastic Suite', 'One king bed. Desk. Cable/satellite TV with pay movies and DVD player. CD player. Coffee/tea maker and minibar. Hair dryer. Iron/ironing board. In-room safe. Complimentary newspaper.', 1000, false)

insert into Hotel (id, name, address, city, state, zip, country) values (5, 'Hotel Rouge', '1315 16th Street NW', 'Washington', 'DC', '20036', 'USA')
insert into Room (id, hotel_id, name, description, price, included) values (13, 5, 'Deluxe room with two queen beds', 'Two queen beds with triple-sheeted Frette-brand Italian linens and piped comforters (bedspreads). Floor-to-ceiling windows overlooking city. 260 square feet. Two armchairs and round hassock, 10-foot desk with chair. Sony flat-screen TV with premium channels. Sony CD player. Complimentary wireless and wired high-speed Internet access. Tall bureau/minibar. Foyer closet with two bathrobes. Bathroom with marble vanity, massaging showerhead, and Aveda toiletries. Nonsmoking. Handheld shower and sewing kit available upon request.', 500, true)
insert into Room (id, hotel_id, name, description, price, included) values (14, 5, 'Chill suite', 'One king bed with triple-sheeted Frette-brand Italian linens and piped comforter (bedspread). Floor-to-ceiling windows overlooking city. 260 square feet. Lounge area with extra TV and either a Sony PlayStation 3 or a Nintendo Wii. Two armchairs and round hassock, 10-foot desk with chair. Sony flat-screen TV with premium channels. Sony CD player. Complimentary wireless and wired high-speed Internet access. Tall bureau/minibar. Foyer closet with two bathrobes. Bathroom with marble vanity, massaging showerhead, and Aveda toiletries. Nonsmoking. Handheld shower and sewing kit available upon request.', 800, false)
insert into Room (id, hotel_id, name, description, price, included) values (15, 5, 'Deluxe room with king bed', 'One king bed with triple-sheeted Frette-brand Italian linens and piped comforter (bedspread). Floor-to-ceiling windows overlooking city. 260 square feet. Two armchairs and round hassock, 10-foot desk with chair. Sony flat-screen TV with premium channels. Sony CD player. Complimentary wireless and wired high-speed Internet access. Tall bureau/minibar. Foyer closet with two bathrobes. Bathroom with marble vanity, massaging showerhead, and Aveda toiletries. Nonsmoking. Handheld shower and sewing kit available upon request.', 500, false)

insert into Hotel (id, name, address, city, state, zip, country) values (6, '70 Park Avenue Hotel', '70 Park Avenue', 'NY', 'NY', '10011', 'USA')
insert into Room (id, hotel_id, name, description, price, included) values (16, 6, 'Queen Standard Room', 'One queen bed with thick, plush-top mattress; goose-down duvet and pillows. Approximately 250-300 square feet. May have city view (not guaranteed). 42-inch plasma-screen HDTV. Surround-sound DVD/CD player. Wireless and wired high-speed Internet access (surcharges). iHome clock radio. Bedside Candela candle lamps. LOccitane bath products, waffle-weave robes. Minibar, in-room safe, complimentary newspaper delivery.', 300, true)
insert into Room (id, hotel_id, name, description, price, included) values (17, 6, 'Deluxe King Room', 'One king bed with thick, plush-top mattress; goose-down duvet and pillows. Approximately 280-325 square feet. May have city view (not guaranteed). 42-inch plasma-screen HDTV. Surround-sound DVD/CD player. Wireless and wired high-speed Internet access (surcharges). iHome clock radio. Bedside Candela candle lamps. LOccitane bath products, waffle-weave robes. Minibar, in-room safe, complimentary newspaper delivery.', 350, false)
insert into Room (id, hotel_id, name, description, price, included) values (18, 6, 'Deluxe double double', 'Two double beds with thick, plush-top mattresses, goose-down duvets and pillows. Approximately 280-325 square feet. May have city view (not guaranteed). 42-inch plasma-screen HDTV. Surround-sound DVD/CD player. Wireless and wired high-speed Internet access (surcharges). iHome clock radio. Bedside Candela candle lamps. LOccitane bath products, waffle-weave robes. Minibar, in-room safe, complimentary newspaper delivery.', 350, false)
insert into Room (id, hotel_id, name, description, price, included) values (19, 6, 'King Premier Room', 'One king bed with thick, plush-top mattress; goose-down duvet and pillows. Approximately 350-375 square feet. View of Park Avenue and Murray Hill neighborhood. Separate sitting area with sofa, coffee table. 42-inch plasma-screen HDTV. Surround-sound DVD/CD player. Wireless and wired high-speed Internet access (surcharges). iHome clock radio Bedside Candela candle lamps. Jetted tub for two, LOccitane bath products, waffle-weave robes. Minibar, in-room safe, complimentary newspaper delivery.', 400, false)

insert into Hotel (id, name, address, city, state, zip, country) values (8, 'Conrad Miami', '1395 Brickell Ave', 'Miami', 'FL', '33131', 'USA')
insert into Room (id, hotel_id, name, description, price, included) values (20, 8, 'Standard room with view', 'Two double beds with 300-thread-count Anachini linens and down comforters (bedspreads). Biscayne Bay view. Located on floors 16-22 of main building. 470 square feet. Contemporary, minimalist-style decor. Wireless Internet access (surcharge). Premium cable channels with pay movies. DVD/CD player. Multi-line phone. Voice mail and complimentary local calls. Minibar and coffee/tea maker. Complimentary bottled water. Bathrobe. Hair dryer. Makeup/shaving mirror. Complimentary newspaper. Turndown service.', 300, true)
insert into Room (id, hotel_id, name, description, price, included) values (21, 8, '1 Bedroom Condo Residence', 'One king bed with 300-thread-count Anachini linens and down comforter (bedspread) in separate bedroom. Located on floors 26-34 of main building. 850 square feet. Contemporary, minimalist-style decor. Wireless Internet access (surcharge). Premium cable channels with pay movies. DVD/CD player. Multi-line phone. Voice mail and complimentary local calls. Full kitchen with range, dishwasher, refrigerator, and coffee/tea maker. Minibar. Complimentary bottled water. Bathrobe. Hair dryer. Makeup/shaving mirror. Complimentary newspaper. Turndown service.', 350, false)

insert into Hotel (id, name, address, city, state, zip, country) values (9, 'Sea Horse Inn', '2106 N Clairemont Ave', 'Eau Claire', 'WI', '54703', 'USA')
insert into Room (id, hotel_id, name, description, price, included) values (22, 9, 'Standard room', 'No description', 80, true)

insert into Hotel (id, name, address, city, state, zip, country) values (10, 'Super 8 Eau Claire Campus Area', '1151 W Macarthur Ave', 'Eau Claire', 'WI', '54701', 'USA')
insert into Room (id, hotel_id, name, description, price, included) values (23, 10, 'One Queen', 'One queen bed. Desk. Complimentary wireless Internet access. Premium cable TV with free HBO. Free local calls.', 90, false)
insert into Room (id, hotel_id, name, description, price, included) values (24, 10, 'One Queen Non Smoking', 'One queen bed. Desk. Complimentary wireless Internet access. Premium cable TV with free HBO. Free local calls.', 90, true)
insert into Room (id, hotel_id, name, description, price, included) values (25, 10, 'Two Queens Non Smoking', 'Two queen beds. Desk. Complimentary wireless Internet access. Premium cable TV with free HBO. Free local calls.', 110, false)