Untitled

CREATE TABLE phases (
    phase_name VARCHAR(255),
    color VARCHAR(50)
);
 
INSERT INTO phases (phase_name, color)
VALUES
    ('MX301_AGITATOR', 'Red'),
    ('MX301_CHARGE_DFA', 'Blue'),
    ('MX301_CHARGE_HMIX', 'Cyan'),
    ('MX301_CHARGE_IPA', 'Yellow'),
    ('MX301_CHARGE_KOH', 'Green'),
    ('MX301_CHARGE_NACL_PREMIX', 'Orange'),
    ('MX301_CHARGE_PROCESS_WATER', 'Teal'),
    ('MX301_COOLING', 'Purple'),
    ('MX301_DFA_AGITATOR', 'Red'),
    ('MX301_IN_PROCESS_QC', 'Pink'),
    ('MX301_FINAL_QC', 'Light Pink'),
    ('MX301_MANUAL_ADDITION', 'Violet'),
    ('MX301_PRECHECK', 'Magenta'),
    ('MX301_RECIRCULATION', 'Lime'),
    ('MX301_TIMER', 'Grey'),
    ('MX301_TRANSFER', 'Beige'),
    ('MX302_AGITATOR', 'Red'),
    ('MX302_CHARGE_DFA_BT_TO_MX', 'Blue'),
    ('MX302_CHARGE_HMIX', 'Cyan'),
    ('MX302_CHARGE_IPA', 'Yellow'),
    ('MX302_CHARGE_KOH_BT_TO_MX', 'Green'),
    ('MX302_CHARGE_NACL_PREMIX', 'Orange'),
    ('MX302_CHARGE_PROCESS_WATER', 'Teal'),
    ('MX302_DFA_AGITATOR', 'Red'),
    ('MX302_IN_PROCESS_QC', 'Pink'),
    ('MX302_FINAL_QC', 'Light Pink'),
    ('MX302_MANUAL_ADDITION', 'Violet'),
    ('MX302_PRECHECK', 'Magenta'),
    ('MX302_RECIRCULATION', 'Lime'),
    ('MX302_TIMER', 'Grey'),
    ('MX302_TRANSFER', 'Beige'),
    ('MX302_CHARGE_DFA_TO_BT', 'Blue'),
    ('MX302_CHARGE_KOH_TO_BT', 'Green'),
    ('HMIX_AGITATOR', 'Red'),
    ('HMIX_CHARGE_TURPENTINE', 'Olive'),
    ('HMIX_MANUAL_ADDITION', 'Violet'),
    ('HMIX_PRECHECK', 'Magenta'),
    ('HMIX_READY_TO_TRANSFER', 'Beige'),
    ('HMIX_CHARGE_PROCESS_WATER', 'Teal'),
    ('NACL_PREMIX_CHARGE_PROCESS_WATER', 'Teal'),
    ('NACL_PREMIX_AGITATOR', 'Red'),
    ('NACL_PREMIX_READY_TO_TRANSFER', 'Beige'),
    ('NACL_PREMIX_MANUAL_ADDITION', 'Violet');