-- Migration: Add company_website field to system_settings
-- Purpose: Store company website URL for use in email signatures, invoices, and other documents
-- Date: 2025-11-27

-- Add company_website setting if it doesn't exist
INSERT INTO system_settings (setting_key, setting_value, updated_at)
SELECT 'company_website', '', NOW()
WHERE NOT EXISTS (
    SELECT 1 FROM system_settings WHERE setting_key = 'company_website'
);