-- Script to drop old numeric primary key columns
-- This is an intermediate step between step 3 and step 4

-- Drop old numeric primary key columns in key tables
ALTER TABLE users DROP COLUMN user_id;
ALTER TABLE companies DROP COLUMN company_id;
ALTER TABLE beach_places DROP COLUMN beach_place_id;
ALTER TABLE restaurants DROP COLUMN restaurant_id;
ALTER TABLE restaurant_items DROP COLUMN item_id;
ALTER TABLE markets DROP COLUMN market_id;
ALTER TABLE market_items DROP COLUMN item_id;
ALTER TABLE adventures DROP COLUMN adventure_id;
ALTER TABLE bookings DROP COLUMN booking_id;
ALTER TABLE reviews DROP COLUMN review_id;