github.com/oinume/lekcije@v0.0.0-20231017100347-5b4c5eb6ab24/backend/db/migrations/20160730215400_create_following_teacher.sql (about) 1 2 -- +goose Up 3 -- SQL in section 'Up' is executed when this migration is applied 4 CREATE TABLE IF NOT EXISTS teacher ( 5 id int unsigned NOT NULL, 6 name varchar(255) NOT NULL DEFAULT '', 7 created_at datetime NOT NULL, 8 updated_at datetime NOT NULL, 9 PRIMARY KEY (`id`) 10 ) ROW_FORMAT=DYNAMIC; 11 12 CREATE TABLE IF NOT EXISTS following_teacher ( 13 user_id int unsigned NOT NULL, 14 teacher_id int unsigned NOT NULL, 15 created_at datetime NOT NULL, 16 updated_at datetime NOT NULL, 17 PRIMARY KEY (`user_id`, `teacher_id`) 18 ) ROW_FORMAT=DYNAMIC; 19 20 -- +goose Down 21 -- SQL section 'Down' is executed when this migration is rolled back 22 DROP TABLE IF EXISTS teacher; 23 DROP TABLE IF EXISTS following_teacher;