diff options
| author | Alexander Kavon <me+git@alexkavon.com> | 2024-01-22 00:35:11 -0500 |
|---|---|---|
| committer | Alexander Kavon <me+git@alexkavon.com> | 2024-01-22 00:35:11 -0500 |
| commit | 857a7dd47a42faeee4c91e8089905b2ba7135bb7 (patch) | |
| tree | b5ef9b9bae1eb26542eec898ee28591ae6d4942b /migrations/002_create_users_table.sql | |
| parent | bc47e526e962c1c5bce850de312c6e5fbaf16458 (diff) | |
updated migrations (added rollback for function), lowered varchar to 255 length, updated packages, make dev, make halt commands for container management
Diffstat (limited to 'migrations/002_create_users_table.sql')
| -rw-r--r-- | migrations/002_create_users_table.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/migrations/002_create_users_table.sql b/migrations/002_create_users_table.sql index d2322f9..3ac92b3 100644 --- a/migrations/002_create_users_table.sql +++ b/migrations/002_create_users_table.sql @@ -1,8 +1,8 @@ CREATE TABLE users( id SERIAL NOT NULL PRIMARY KEY, username VARCHAR(50) UNIQUE NOT NULL, - secret VARCHAR(256) NOT NULL, - email VARCHAR(256) UNIQUE NOT NULL, + secret VARCHAR(255) NOT NULL, + email VARCHAR(255) UNIQUE NOT NULL, created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(), updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW() ); |