--------------------------------------------------------------------------------
-- Primary Keys
--------------------------------------------------------------------------------

ALTER TABLE hotel
    ADD PRIMARY KEY (hotel_id);

ALTER TABLE hotel_phone
    ADD PRIMARY KEY (hotel_id, sort);

--------------------------------------------------------------------------------
-- Foreign Keys
--------------------------------------------------------------------------------

ALTER TABLE hotel_phone
    ADD FOREIGN KEY (hotel_id) REFERENCES hotel;
