diff options
| author | Alexander Kavon <me+git@alexkavon.com> | 2024-01-22 17:22:38 -0500 |
|---|---|---|
| committer | Alexander Kavon <me+git@alexkavon.com> | 2024-01-22 17:22:38 -0500 |
| commit | 28e420d7f8ce5dc622c5e0e28a10654f48fcbca4 (patch) | |
| tree | d6dfb28102be1adb1355a02a79d43d74041d609b /migrations/002_create_users_table.sql | |
| parent | b9de5bdd1ec704deb85232057dcc158555ff1cb8 (diff) | |
add missing semicolon, update email field to optional
Diffstat (limited to 'migrations/002_create_users_table.sql')
| -rw-r--r-- | migrations/002_create_users_table.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/migrations/002_create_users_table.sql b/migrations/002_create_users_table.sql index 3ac92b3..746dc23 100644 --- a/migrations/002_create_users_table.sql +++ b/migrations/002_create_users_table.sql @@ -2,7 +2,7 @@ CREATE TABLE users( id SERIAL NOT NULL PRIMARY KEY, username VARCHAR(50) UNIQUE NOT NULL, secret VARCHAR(255) NOT NULL, - email VARCHAR(255) UNIQUE NOT NULL, + email VARCHAR(255) UNIQUE, created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(), updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW() ); |