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;