/* Hotel Application Table Loading
   Authors: Philippe Bonnet, Dennis Shasha 
   $Log$

   Script to load data in the ReserveWithUs schema
*/

/* HOTEL */
LOAD DATA LOCAL INFILE 'hotel.data'
    REPLACE
    INTO TABLE HOTEL
    FIELDS
        TERMINATED BY '|'
    LINES
        TERMINATED BY '\n'
    IGNORE 1 LINES
    (hotel_id, name, street, city, zip_code, state, country, rating, distance_to_center);

/* CUSTOMER */
LOAD DATA LOCAL INFILE 'customer.data'
    REPLACE
    INTO TABLE CUSTOMER
    FIELDS
    	TERMINATED BY '|'
    LINES
	TERMINATED BY '\n'
    IGNORE 1 LINES
    (customer_id, username, password, first_name, last_name, home_street, home_city, home_zip_code, home_state, business_street, business_city, business_zip_code, business_state,home_phone,business_phone,email, language);

/* ROOM_TYPE */
LOAD DATA LOCAL INFILE 'roomtype.data'
    REPLACE
    INTO TABLE ROOM_TYPE
    FIELDS
    	TERMINATED BY '|'
    LINES
	TERMINATED BY '\n'
    IGNORE 1 LINES
    (room_type_id, hotel_id, room_type);