inventory/backend/database/add_vat_column.sql

-- Add VAT percentage column to chart_of_accounts table
ALTER TABLE chart_of_accounts 
ADD COLUMN vat_percentage DECIMAL(5,2) DEFAULT 0.00 
AFTER current_balance;

-- Update existing revenue accounts to have default VAT rates (24% for Finland)
UPDATE chart_of_accounts 
SET vat_percentage = 24.00 
WHERE account_type = 'revenue';

-- Update existing expense accounts that typically have VAT
UPDATE chart_of_accounts 
SET vat_percentage = 24.00 
WHERE account_type = 'expense' AND (
    account_name LIKE '%rent%' OR 
    account_name LIKE '%utilities%' OR 
    account_name LIKE '%supplies%' OR
    account_name LIKE '%services%'
);