added brandID to existing tables