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

     1  -- +goose Up
     2  -- SQL in section 'Up' is executed when this migration is applied
     3  BEGIN;
     4  UPDATE `m_country` SET name_ja='ロシア連邦' WHERE id =643;
     5  UPDATE `m_country` SET name_ja='マケドニア共和国' WHERE id = 807;
     6  COMMIT;
     7  
     8  ALTER TABLE teacher
     9    MODIFY COLUMN `years_of_experience` TINYINT NOT NULL DEFAULT -1;
    10  
    11  -- +goose Down
    12  -- SQL section 'Down' is executed when this migration is rolled back
    13  ALTER TABLE teacher
    14    MODIFY COLUMN `years_of_experience` TINYINT UNSIGNED NOT NULL DEFAULT 0;