Bnei-Baruch/mdb

View on GitHub
migrations/2017-11-12_140013_add_clips_type.sql

Summary

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

WITH data(name) AS (VALUES
  ('CLIPS')
)
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 ('CLIPS');