-- Add BrandIcon column to tblbrand table
ALTER TABLE `tblbrand` ADD `BrandIcon` VARCHAR(255) NULL AFTER `BrandName`;

-- Update existing brands with default icons
UPDATE `tblbrand` SET `BrandIcon` = '📱' WHERE `BrandName` = 'Samsung';
UPDATE `tblbrand` SET `BrandIcon` = '🍎' WHERE `BrandName` = 'Apple';
UPDATE `tblbrand` SET `BrandIcon` = '🔵' WHERE `BrandName` = 'Oppo';
UPDATE `tblbrand` SET `BrandIcon` = '🔴' WHERE `BrandName` = 'RedMI';
UPDATE `tblbrand` SET `BrandIcon` = '📱' WHERE `BrandName` = 'LG';
UPDATE `tblbrand` SET `BrandIcon` = '📱' WHERE `BrandName` = 'Nokia';
UPDATE `tblbrand` SET `BrandIcon` = '📱' WHERE `BrandName` = 'Motorola';
