Bnei-Baruch/mdb

View on GitHub
migrations/2021-01-20_120:14:30_add_cu_source_type.sql

Summary

Maintainability
Test Coverage
-- MDB generated migration file
-- rambler up

WITH data(name) AS (VALUES ('SOURCE'))
INSERT
INTO content_types (name)
SELECT d.name
FROM data AS d
WHERE NOT EXISTS(SELECT ct.name
                 FROM content_types AS ct
                 WHERE ct.name = d.name);

-- rambler down

DELETE
FROM content_types
WHERE name IN ('SOURCE');