2022-10-02 12:12:08 +02:00
|
|
|
-- Add migration script here
|
2022-10-02 14:15:45 +02:00
|
|
|
CREATE TABLE IF NOT EXISTS users (
|
|
|
|
|
id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
|
|
|
|
|
username varchar not null,
|
|
|
|
|
password_hash varchar not null
|
2022-10-02 12:12:08 +02:00
|
|
|
);
|
2022-10-02 14:15:45 +02:00
|
|
|
|
|
|
|
|
CREATE unique index users_username_idx on users(username)
|
