updated migrations (added rollback for function), lowered varchar to 255 length, updated packages, make dev, make halt commands for container management

2 files changed, 6 insertions, 2 deletions

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()
 );