-- rename restaurant_id to venue_id
ALTER TABLE devices CHANGE restaurant_id venue_id VARCHAR(255);

-- add app_version column
ALTER TABLE devices ADD COLUMN app_version VARCHAR(255);

-- add app_version column
ALTER TABLE devices ADD COLUMN os_type VARCHAR(255);