summaryrefslogtreecommitdiff
path: root/internal/server/api/migrations/20250109143707_on_user_delete.sql
diff options
context:
space:
mode:
authorKyren223 <Kyren223@proton.me>2025-01-09 19:14:05 +0200
committerKyren223 <Kyren223@proton.me>2025-01-09 19:14:05 +0200
commitb09a8fba647ff030b24d9ad12215ba330c13080c (patch)
treed2be54859c70a6760edb75e26ee44299b17f50dc /internal/server/api/migrations/20250109143707_on_user_delete.sql
parent936d3cf690ace9adfdfe0fb44193c11a0cb26d95 (diff)
Fixed everything on the server-side
Diffstat (limited to 'internal/server/api/migrations/20250109143707_on_user_delete.sql')
-rw-r--r--internal/server/api/migrations/20250109143707_on_user_delete.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/internal/server/api/migrations/20250109143707_on_user_delete.sql b/internal/server/api/migrations/20250109143707_on_user_delete.sql
index 940bec4..9e9bdde 100644
--- a/internal/server/api/migrations/20250109143707_on_user_delete.sql
+++ b/internal/server/api/migrations/20250109143707_on_user_delete.sql
@@ -1,6 +1,6 @@
-- +goose Up
-- +goose StatementBegin
-CREATE TRIGGER on_user_delete
+CREATE TRIGGER IF NOT EXISTS on_user_delete
AFTER UPDATE OF is_deleted ON users
WHEN NEW.is_deleted = true
BEGIN