github.com/oinume/lekcije@v0.0.0-20231017100347-5b4c5eb6ab24/backend/db/migrations/20160626222200_create_tables.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 (
     5      id int unsigned NOT NULL AUTO_INCREMENT,
     6      name varchar(50) NOT NULL,
     7      email varchar(255) NOT NULL,
     8      created_at datetime NOT NULL,
     9      updated_at datetime NOT NULL,
    10      PRIMARY KEY (`id`),
    11      UNIQUE KEY (`email`)
    12  ) ROW_FORMAT=DYNAMIC;
    13  
    14  CREATE TABLE IF NOT EXISTS auth_google (
    15      user_id int unsigned NOT NULL DEFAULT 0,
    16      access_token varchar(255) NOT NULL,
    17      id_token varchar(1024) NOT NULL,
    18      created_at datetime NOT NULL,
    19      updated_at datetime NOT NULL,
    20      PRIMARY KEY (`user_id`),
    21      UNIQUE KEY (`access_token`)
    22  ) ROW_FORMAT=DYNAMIC;
    23  
    24  -- +goose Down
    25  -- SQL section 'Down' is executed when this migration is rolled back
    26  DROP TABLE IF EXISTS user;