diff options
Diffstat (limited to 'migrations/002_create_users_table.sql')
| -rw-r--r-- | migrations/002_create_users_table.sql | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/migrations/002_create_users_table.sql b/migrations/002_create_users_table.sql index a561a05..d2322f9 100644 --- a/migrations/002_create_users_table.sql +++ b/migrations/002_create_users_table.sql @@ -1,7 +1,8 @@ CREATE TABLE users( id SERIAL NOT NULL PRIMARY KEY, - username VARCHAR(50) NOT NULL, - secret VARCHAR(255) NOT NULL, + username VARCHAR(50) UNIQUE NOT NULL, + secret VARCHAR(256) NOT NULL, + email VARCHAR(256) UNIQUE NOT NULL, created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(), updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW() ); |