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

     1  
     2  -- +goose Up
     3  -- SQL in section 'Up' is executed when this migration is applied
     4  CREATE TABLE IF NOT EXISTS user_api_token (
     5      token varchar(128) NOT NULL,
     6      user_id int unsigned NOT NULL,
     7      created_at datetime NOT NULL,
     8      updated_at datetime NOT NULL,
     9      PRIMARY KEY (`token`)
    10  ) ROW_FORMAT=DYNAMIC;
    11  
    12  -- +goose Down
    13  -- SQL section 'Down' is executed when this migration is rolled back
    14  DROP TABLE IF EXISTS user_api_token;