mirror of
https://github.com/kevin-DL/football_info_api.git
synced 2026-01-11 18:14:28 +00:00
25 lines
531 B
SQL
25 lines
531 B
SQL
-- +goose Up
|
|
-- +goose StatementBegin
|
|
SELECT 'up SQL query';
|
|
create table profiles
|
|
(
|
|
id uuid not null
|
|
constraint profiles_pk
|
|
primary key,
|
|
display_name varchar not null,
|
|
user_id uuid not null ,
|
|
created_at timestamptz not null,
|
|
updated_at timestamptz not null
|
|
);
|
|
|
|
create unique index profiles_user_id_index
|
|
on profiles (user_id);
|
|
|
|
-- +goose StatementEnd
|
|
|
|
-- +goose Down
|
|
-- +goose StatementBegin
|
|
SELECT 'down SQL query';
|
|
drop table profiles;
|
|
-- +goose StatementEnd
|