fix: sql fixes

2 files changed, 11 insertions, 11 deletions

diff --git a/bot/src/modules/notify.hpp b/bot/src/modules/notify.hpp
index 35b4d36..7bea6a6 100644
--- a/bot/src/modules/notify.hpp
+++ b/bot/src/modules/notify.hpp
@@ -100,7 +100,7 @@ namespace bot {
             work.exec(
                 "INSERT INTO event_subscriptions(event_id, user_id) VALUES (" +
                 std::to_string(event[0].as<int>()) + ", " +
-                std::to_string(request.user.get_id()));
+                std::to_string(request.user.get_id()) + ")");
             work.commit();
 
             return command::Response(
diff --git a/migrations/2024-05-11T02-53-05_init/up.sql b/migrations/2024-05-11T02-53-05_init/up.sql
index c50562f..1a23ff9 100644
--- a/migrations/2024-05-11T02-53-05_init/up.sql
+++ b/migrations/2024-05-11T02-53-05_init/up.sql
@@ -16,15 +16,15 @@ CREATE TABLE IF NOT EXISTS "users"  (
 );
 
 CREATE TABLE IF NOT EXISTS "channel_preferences" (
-  "channel_id" INTEGER NOT NULL UNIQUE PRIMARY KEY REFERENCES "channels"("id"),
+  "channel_id" INTEGER NOT NULL UNIQUE PRIMARY KEY REFERENCES "channels"("id") ON DELETE CASCADE,
   "prefix" VARCHAR,
   "locale" VARCHAR
 );
 
 CREATE TABLE IF NOT EXISTS "user_rights" (
   "id" SERIAL NOT NULL UNIQUE PRIMARY KEY,
-  "user_id" INTEGER NOT NULL REFERENCES "users"("id"),
-  "channel_id" INTEGER NOT NULL REFERENCES "channels"("id"),
+  "user_id" INTEGER NOT NULL REFERENCES "users"("id") ON DELETE CASCADE,
+  "channel_id" INTEGER NOT NULL REFERENCES "channels"("id") ON DELETE CASCADE,
   "level" INTEGER NOT NULL DEFAULT 1,
 
   CONSTRAINT "unique_user_channel" UNIQUE ("user_id", "channel_id")
@@ -32,8 +32,8 @@ CREATE TABLE IF NOT EXISTS "user_rights" (
 
 CREATE TABLE IF NOT EXISTS "actions" (
   "id" SERIAL NOT NULL UNIQUE PRIMARY KEY,
-  "user_id" INTEGER NOT NULL REFERENCES "users"("id"),
-  "channel_id" INTEGER NOT NULL REFERENCES "channels"("id"),
+  "user_id" INTEGER NOT NULL REFERENCES "users"("id") ON DELETE CASCADE,
+  "channel_id" INTEGER NOT NULL REFERENCES "channels"("id") ON DELETE CASCADE,
   "command" VARCHAR NOT NULL,
   "arguments" VARCHAR,
   "full_message" VARCHAR NOT NULL,
@@ -42,7 +42,7 @@ 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"),
+  "channel_id" INTEGER NOT NULL REFERENCES "channels"("id") ON DELETE CASCADE,
   "target_alias_id" INTEGER,
   "custom_alias_id" VARCHAR,
   "event_type" INTEGER NOT NULL,
@@ -55,20 +55,20 @@ CREATE TABLE IF NOT EXISTS "events" (
 
 CREATE TABLE IF NOT EXISTS "event_subscriptions" (
   "id" SERIAL NOT NULL UNIQUE PRIMARY KEY,
-  "event_id" INTEGER NOT NULL REFERENCES "events"("id"),
-  "user_id" INTEGER NOT NULL REFERENCES "users"("id")
+  "event_id" INTEGER NOT NULL REFERENCES "events"("id") ON DELETE CASCADE,
+  "user_id" INTEGER NOT NULL REFERENCES "users"("id") ON DELETE CASCADE
 );
 
 CREATE TABLE IF NOT EXISTS "custom_commands" (
   "id" SERIAL NOT NULL UNIQUE PRIMARY KEY,
-  "channel_id" INTEGER NOT NULL REFERENCES "channels"("id"),
+  "channel_id" INTEGER NOT NULL REFERENCES "channels"("id") ON DELETE CASCADE,
   "name" VARCHAR NOT NULL,
   "message" VARCHAR NOT NULL
 );
 
 CREATE TABLE IF NOT EXISTS "timers" (
   "id" SERIAL NOT NULL UNIQUE PRIMARY KEY,
-  "channel_id" INTEGER NOT NULL REFERENCES "channels"("id"),
+  "channel_id" INTEGER NOT NULL REFERENCES "channels"("id") ON DELETE CASCADE,
   "name" VARCHAR NOT NULL,
   "message" VARCHAR NOT NULL,
   "interval_sec" INTEGER NOT NULL,