drop api table, add columns to brewery