taskcafe/migrations/0056_add-user_account_invited-table.up.sql

7 lines
233 B
MySQL
Raw Permalink Normal View History

2020-11-22 21:11:13 +01:00
CREATE TABLE user_account_invited (
user_account_invited_id uuid PRIMARY KEY DEFAULT uuid_generate_v4(),
email text NOT NULL UNIQUE,
invited_on timestamptz NOT NULL DEFAULT NOW(),
has_joined boolean NOT NULL DEFAULT false
);