upd: events table

1 files changed, 2 insertions, 6 deletions

diff --git a/migrations/2024-05-11T02-53-05_init/up.sql b/migrations/2024-05-11T02-53-05_init/up.sql
index 1a23ff9..2d4d8c2 100644
--- a/migrations/2024-05-11T02-53-05_init/up.sql
+++ b/migrations/2024-05-11T02-53-05_init/up.sql
@@ -43,14 +43,10 @@ CREATE TABLE IF NOT EXISTS "actions" (
 CREATE TABLE IF NOT EXISTS "events" (
   "id" SERIAL NOT NULL UNIQUE PRIMARY KEY,
   "channel_id" INTEGER NOT NULL REFERENCES "channels"("id") ON DELETE CASCADE,
-  "target_alias_id" INTEGER,
-  "custom_alias_id" VARCHAR,
+  "name" VARCHAR NOT NULL,
   "event_type" INTEGER NOT NULL,
   "flags" INTEGER[] NOT NULL DEFAULT ARRAY[]::INTEGER[],
-  "message" VARCHAR NOT NULL,
-
-  CONSTRAINT check_target_alias_id CHECK (("target_alias_id" IS NULL AND "custom_alias_id" IS NOT NULL) OR ("target_alias_id" IS NOT NULL AND "custom_alias_id" IS NULL)),
-  CONSTRAINT check_event_type CHECK (("target_alias_id" IS NOT NULL AND "event_type" != 99) OR ("custom_alias_id" IS NOT NULL AND "event_type" = 99))
+  "message" VARCHAR NOT NULL
 );
 
 CREATE TABLE IF NOT EXISTS "event_subscriptions" (