-- ============================================
-- ADD EXTERNAL IMAGE URL FIELDS
-- Simple URL-based image system
-- ============================================

-- Add external URL fields to stores
ALTER TABLE `stores` 
ADD COLUMN `store_image_url` VARCHAR(500) DEFAULT '' COMMENT 'External image URL';

-- Add external URL fields to coupons
ALTER TABLE `coupons` 
ADD COLUMN `coupon_image_url` VARCHAR(500) DEFAULT '' COMMENT 'External image URL';

-- Add external URL fields to campaigns
ALTER TABLE `campaigns` 
ADD COLUMN `campaign_image_url` VARCHAR(500) DEFAULT '' COMMENT 'External image URL';

-- Add external URL fields to sliders
ALTER TABLE `sliders` 
ADD COLUMN `slider_image_url` VARCHAR(500) DEFAULT '' COMMENT 'External image URL';

-- Add external URL fields to popups
ALTER TABLE `popups` 
ADD COLUMN `popup_image_url` VARCHAR(500) DEFAULT '' COMMENT 'External image URL';

-- Add external URL fields to categories
ALTER TABLE `categories` 
ADD COLUMN `category_image_url` VARCHAR(500) DEFAULT '' COMMENT 'External image URL';

-- ============================================
-- VERIFICATION
-- ============================================
SELECT 'External Image URL fields added successfully!' as status;
