github.com/oinume/lekcije@v0.0.0-20231017100347-5b4c5eb6ab24/backend/db/migrations/20161109110000_add_followed_teacher_at.sql (about) 1 -- +goose Up 2 -- SQL in section 'Up' is executed when this migration is applied 3 ALTER TABLE user ADD COLUMN `followed_teacher_at` datetime DEFAULT NULL AFTER `plan_id`; 4 UPDATE user SET followed_teacher_at = created_at WHERE followed_teacher_at IS NULL; 5 6 -- +goose Down 7 -- SQL section 'Down' is executed when this migration is rolled back 8 ALTER TABLE user DROP COLUMN `followed_teacher_at`;