-- Add image upload settings to system_settings table

INSERT INTO system_settings (setting_key, setting_value, description) VALUES
('max_product_images', '7', 'Maximum number of images allowed per product'),
('max_image_size_mb', '2.0', 'Maximum file size in MB for each product image'),
('image_upload_guidelines', 'Upload high-quality images:\n• Minimum 800x800 pixels recommended\n• Use well-lit, clear photos\n• Show product from multiple angles\n• Avoid blurry or pixelated images\n• White or neutral background preferred', 'Guidelines text shown to sellers during image upload')
ON DUPLICATE KEY UPDATE setting_value = VALUES(setting_value);