populate the user_deleted_table

SasSwart · SasSwart · commit 012f14c75f10 · 2025-01-13T10:34:25.000Z
diff --git a/coderd/database/migrations/000283_user_status_changes.up.sql b/coderd/database/migrations/000283_user_status_changes.up.sql
@@ -31,6 +31,11 @@ COMMENT ON TABLE user_deleted IS 'Tracks when users were deleted';
 
 CREATE INDEX idx_user_deleted_deleted_at ON user_deleted(deleted_at);
 
+INSERT INTO user_deleted (user_id, deleted_at)
+SELECT id, updated_at
+FROM users
+WHERE deleted;
+
 CREATE OR REPLACE FUNCTION record_user_status_change() RETURNS trigger AS $$
 BEGIN
     IF TG_OP = 'INSERT' OR OLD.status IS DISTINCT FROM NEW.status THEN
