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

     1  -- +goose Up
     2  -- SQL in section 'Up' is executed when this migration is applied
     3  DROP TABLE IF EXISTS auth_google;
     4  CREATE TABLE IF NOT EXISTS user_google (
     5    `google_id` varchar(255) NOT NULL,
     6    `user_id` int unsigned NOT NULL,
     7    `created_at` datetime NOT NULL,
     8    `updated_at` datetime NOT NULL,
     9    PRIMARY KEY (`google_id`),
    10    UNIQUE KEY (`user_id`)
    11  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
    12  
    13  
    14  -- +goose Down
    15  -- SQL section 'Down' is executed when this migration is rolled back
    16  DROP TABLE IF EXISTS user_google;
    17  CREATE TABLE IF NOT EXISTS `auth_google` (
    18    `user_id` int(10) unsigned NOT NULL DEFAULT '0',
    19    `access_token` varchar(255) COLLATE utf8mb4_bin NOT NULL,
    20    `id_token` varchar(1024) COLLATE utf8mb4_bin NOT NULL,
    21    `created_at` datetime NOT NULL,
    22    `updated_at` datetime NOT NULL,
    23    PRIMARY KEY (`user_id`),
    24    UNIQUE KEY `access_token` (`access_token`)
    25  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC
    26