-- rename restaurant_id to venue_id
ALTER TABLE scans CHANGE restaurant_id venue_id VARCHAR(255);
-- add user_id column
ALTER TABLE scans ADD COLUMN user_id VARCHAR(255);