-- Add custom SharePoint site URL column to Companies table
-- This allows each company to have lists in a dedicated subsite

ALTER TABLE Companies 
ADD COLUMN msSharepointCustomSite VARCHAR(255) NULL 
COMMENT 'Custom SharePoint site path (e.g., sites/NordSafe)';

-- Example values:
-- NULL = use root site (default)
-- 'sites/NordSafe' = use subsite at /sites/NordSafe
-- 'sites/CustomerName' = use customer-specific subsite
