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;