6eee14f8af
- Add admin dashboard with sync controls and data browser - Implement RMM, Auvik, and Addigy organization mappings - Add chunked ticket sync with progress tracking - Implement entity sync service with rate limiting - Add analytics engine and performance optimizer - Create data browser for all PSA entities - Add navigation components and UI improvements - Implement background processing and sync services - Add comprehensive documentation and migration scripts - Update configuration items with multi-system support - Enhance contact management and purchase history - Add issue type assignment and LLM analyzer - Improve error handling and logging utilities
7 lines
282 B
SQL
7 lines
282 B
SQL
-- 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)';
|