feat(coderd/database): add new information to the account activated notification body template

SasSwart · SasSwart · commit 41ed54af123f · 2024-10-07T07:35:32.000Z
diff --git a/coderd/database/migrations/000262_improve_notification_templates.down.sql b/coderd/database/migrations/000262_improve_notification_templates.down.sql
@@ -6,7 +6,7 @@ WHERE
 
 UPDATE notification_templates
 SET
-	body_template = REPLACE(body_template::text, E'Hi {{.UserName}},\n', 'Hi {{.UserName}},')::text
+body_template = E'Hi {{.UserName}},\nUser account **{{.Labels.activated_account_name}}** has been activated.'
 WHERE
 	id = '9f5af851-8408-4e73-a7a1-c6502ba46689';
 
diff --git a/coderd/database/migrations/000262_improve_notification_templates.up.sql b/coderd/database/migrations/000262_improve_notification_templates.up.sql
@@ -6,9 +6,11 @@ WHERE
 
 UPDATE notification_templates
 SET
-	body_template = REPLACE(body_template::text, 'Hi {{.UserName}},', E'Hi {{.UserName}},\n')::text
+body_template = E'Hi {{.UserName}},\n\n'
+               'User account **{{.Labels.activated_account_name}}** has been activated. '
+               'The newly activated account belongs to **{{.Labels.activated_account_user_name}}** and was activated by **{{.Labels.account_activator_user_name}}**.'
 WHERE
-	id = '9f5af851-8408-4e73-a7a1-c6502ba46689';
+    id = '9f5af851-8408-4e73-a7a1-c6502ba46689';
 
 UPDATE notification_templates
 SET
