-- VetNet: Merge pet_owner + farm_owner → client
-- Run this ONCE in phpMyAdmin after uploading files

-- Step 1: Update existing users
UPDATE baitari_users 
SET role = 'client' 
WHERE role IN ('pet_owner', 'farm_owner');

-- Step 2: Verify
SELECT role, COUNT(*) as total 
FROM baitari_users 
GROUP BY role;
