taskcafe/migrations/0002_add-user_account-table.up.sql

10 lines
269 B
MySQL
Raw Permalink Normal View History

2020-04-10 04:40:22 +02:00
CREATE TABLE user_account (
user_id uuid PRIMARY KEY DEFAULT uuid_generate_v4(),
created_at timestamptz NOT NULL,
2020-04-20 05:02:55 +02:00
first_name text NOT NULL,
last_name text NOT NULL,
2020-04-10 04:40:22 +02:00
email text NOT NULL UNIQUE,
username text NOT NULL UNIQUE,
password_hash text NOT NULL
);