9 lines
210 B
MySQL
9 lines
210 B
MySQL
|
DO $$
|
||
|
BEGIN
|
||
|
IF NOT EXISTS (
|
||
|
SELECT 1 FROM pg_enum
|
||
|
WHERE enumlabel = 'webhook' AND enumtypid = 'leadtargettype'::regtype
|
||
|
) THEN
|
||
|
ALTER TYPE quiz_status ADD VALUE 'webhook';
|
||
|
END IF;
|
||
|
END $$;
|