sql

mtojek · mtojek · commit 42f4bd77a7bc · 2024-08-02T09:37:26.000+02:00
diff --git a/coderd/database/migrations/000234_notifications_user_deleted.down.sql b/coderd/database/migrations/000234_notifications_user_deleted.down.sql
@@ -0,0 +1 @@
+DELETE FROM notification_templates WHERE id = 'f44d9314-ad03-4bc8-95d0-5cad491da6b6';
diff --git a/coderd/database/migrations/000234_notifications_user_deleted.up.sql b/coderd/database/migrations/000234_notifications_user_deleted.up.sql
@@ -0,0 +1,9 @@
+INSERT INTO notification_templates (id, name, title_template, body_template, "group", actions)
+VALUES ('f44d9314-ad03-4bc8-95d0-5cad491da6b6', 'User account deleted', E'User account "{{.Labels.deleted_account_name}}" deleted',
+        E'Hi {{.UserName}},\n\User account **{{.Labels.created_account_name}}** has been deleted.',
+        'Workspace Events', '[
+        {
+            "label": "View accounts",
+            "url": "{{ base_url }}/deployment/users?filter=status%3Aactive"
+        }
+    ]'::jsonb);

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1 @@`
	`1`	`+DELETE FROM notification_templates WHERE id = 'f44d9314-ad03-4bc8-95d0-5cad491da6b6';`