-- Make company_id nullable for tickets
-- Some tickets in Autotask may not have a company association

ALTER TABLE tickets 
ALTER COLUMN company_id DROP NOT NULL;

COMMENT ON COLUMN tickets.company_id IS 'Company ID (nullable - some tickets may not be associated with a company)';