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/001_create_timestamp_trigger.sql | 4 ++++ migrations/002_create_users_table.sql | 4 ++-- 2 files changed, 6 insertions(+), 2 deletions(-) (limited to 'migrations') diff --git a/migrations/001_create_timestamp_trigger.sql b/migrations/001_create_timestamp_trigger.sql index 4fa369a..f181510 100644 --- a/migrations/001_create_timestamp_trigger.sql +++ b/migrations/001_create_timestamp_trigger.sql @@ -5,3 +5,7 @@ BEGIN RETURN NEW; END; $$ LANGUAGE plpgsql; + +---- create above / drop below ---- + +DROP FUNCTION trigger_set_timestamp() 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