27 lines
1.5 KiB
MySQL
27 lines
1.5 KiB
MySQL
|
-- Populate company_classifications with common Autotask classification icons
|
||
|
|
-- Based on standard Autotask classification icons
|
||
|
|
|
||
|
|
INSERT INTO company_classifications (classification_id, name, description, is_active, is_system) VALUES
|
||
|
|
(1, 'Platinum_Service_Plan', 'Platinum Service Plan', true, false),
|
||
|
|
(2, 'Gold_Service_Plan', 'Gold Service Plan', true, false),
|
||
|
|
(3, 'Silver_Service_Plan', 'Silver Service Plan', true, false),
|
||
|
|
(4, 'Wulf 365 Essentials', 'Wulf 365 Essentials', true, false),
|
||
|
|
(5, 'Co-Managed', 'Co-Managed IT', true, false),
|
||
|
|
(6, 'Tools Only', 'Tools Only', true, false),
|
||
|
|
(7, 'Partner', 'Partner', true, false),
|
||
|
|
(8, 'Block Hour', 'Use Icon to Identify Block Hour Customer', true, false),
|
||
|
|
(9, 'T&M', 'T&M', true, false),
|
||
|
|
(10, 'Residential (no-pay)', 'Residential', true, false),
|
||
|
|
(11, 'Canceled', 'Canceled', true, false),
|
||
|
|
(12, 'Red (1)', 'Define your own. (One idea is to use it as Top Priority Customers)', true, false),
|
||
|
|
(13, 'Blue (2)', 'Define your own.', true, false),
|
||
|
|
(14, 'Gold (3)', 'Define your own.', true, false),
|
||
|
|
(15, 'Target', 'Use the TatUse the Target Icon when you have a hot deal that you want to track', true, false),
|
||
|
|
(16, 'Delinquent', 'Customers with a passed due account', true, false),
|
||
|
|
(17, 'Jeopardy Company', 'Company is in Jeopardy', true, false)
|
||
|
|
ON CONFLICT (classification_id) DO UPDATE SET
|
||
|
|
name = EXCLUDED.name,
|
||
|
|
description = EXCLUDED.description,
|
||
|
|
is_active = EXCLUDED.is_active,
|
||
|
|
updated_at = CURRENT_TIMESTAMP;
|