-- Add logo, favicon and other details to companies table
ALTER TABLE companies 
ADD COLUMN logo VARCHAR(255) DEFAULT NULL AFTER name_ar,
ADD COLUMN favicon VARCHAR(255) DEFAULT NULL AFTER logo,
ADD COLUMN email VARCHAR(100) DEFAULT NULL AFTER favicon,
ADD COLUMN phone VARCHAR(20) DEFAULT NULL AFTER email,
ADD COLUMN address_en TEXT DEFAULT NULL AFTER phone,
ADD COLUMN address_ar TEXT DEFAULT NULL AFTER address_en,
ADD COLUMN vat_number VARCHAR(50) DEFAULT NULL AFTER address_ar;

-- Add profile_picture to users table
ALTER TABLE users 
ADD COLUMN profile_picture VARCHAR(255) DEFAULT NULL AFTER email;