From 857a7dd47a42faeee4c91e8089905b2ba7135bb7 Mon Sep 17 00:00:00 2001 From: Alexander Kavon Date: Mon, 22 Jan 2024 00:35:11 -0500 Subject: updated migrations (added rollback for function), lowered varchar to 255 length, updated packages, make dev, make halt commands for container management --- migrations/002_create_users_table.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'migrations/002_create_users_table.sql') 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() ); -- cgit v1.2.3