38 lines
1.5 KiB
MySQL
38 lines
1.5 KiB
MySQL
|
-- Add comprehensive fields to resources table based on Autotask Resources API
|
||
|
|
-- Reference: https://autotask.net/help/developerhelp/Content/APIs/REST/Entities/ResourcesEntity.htm
|
||
|
|
|
||
|
|
ALTER TABLE resources
|
||
|
|
-- Name fields
|
||
|
|
ADD COLUMN IF NOT EXISTS middle_initial VARCHAR(10),
|
||
|
|
ADD COLUMN IF NOT EXISTS name_prefix VARCHAR(20),
|
||
|
|
ADD COLUMN IF NOT EXISTS name_suffix VARCHAR(20),
|
||
|
|
|
||
|
|
-- Contact information
|
||
|
|
ADD COLUMN IF NOT EXISTS email_address VARCHAR(255),
|
||
|
|
ADD COLUMN IF NOT EXISTS email_address2 VARCHAR(255),
|
||
|
|
ADD COLUMN IF NOT EXISTS email_address3 VARCHAR(255),
|
||
|
|
ADD COLUMN IF NOT EXISTS home_phone VARCHAR(50),
|
||
|
|
|
||
|
|
-- Employment details
|
||
|
|
ADD COLUMN IF NOT EXISTS accounting_reference_id VARCHAR(100),
|
||
|
|
ADD COLUMN IF NOT EXISTS payroll_identifier VARCHAR(100),
|
||
|
|
ADD COLUMN IF NOT EXISTS payroll_type INTEGER,
|
||
|
|
ADD COLUMN IF NOT EXISTS internal_cost DECIMAL(15,2),
|
||
|
|
|
||
|
|
-- Location and availability
|
||
|
|
ADD COLUMN IF NOT EXISTS default_service_desk_role_id BIGINT,
|
||
|
|
|
||
|
|
-- System fields
|
||
|
|
ADD COLUMN IF NOT EXISTS email_type_code INTEGER,
|
||
|
|
ADD COLUMN IF NOT EXISTS gender INTEGER,
|
||
|
|
ADD COLUMN IF NOT EXISTS license_type INTEGER,
|
||
|
|
ADD COLUMN IF NOT EXISTS number_format VARCHAR(50),
|
||
|
|
ADD COLUMN IF NOT EXISTS time_format VARCHAR(50),
|
||
|
|
ADD COLUMN IF NOT EXISTS date_format VARCHAR(50),
|
||
|
|
|
||
|
|
-- Security
|
||
|
|
ADD COLUMN IF NOT EXISTS security_level INTEGER;
|
||
|
|
|
||
|
|
-- Add comment to track migration
|
||
|
|
COMMENT ON TABLE resources IS 'Expanded with all Autotask API fields - Migration 015';
|