github.com/oinume/lekcije@v0.0.0-20231017100347-5b4c5eb6ab24/backend/db/migrations/20170605050000_plus_beta.sql (about)

     1  -- +goose Up
     2  -- SQL in section 'Up' is executed when this migration is applied
     3  INSERT INTO plan VALUES (5, 'Plus', 'Plus Beta', 0, 1, 0, '2017-06-04 00:00:00', '2017-06-04 00:00:00');
     4  CREATE TABLE IF NOT EXISTS m_plan LIKE plan;
     5  INSERT INTO m_plan SELECT * FROM plan;
     6  
     7  -- +goose Down
     8  -- SQL section 'Down' is executed when this migration is rolled back
     9  DROP TABLE IF EXISTS m_plan;
    10  DELETE FROM plan WHERE id = 5;