coder
diff --git a/‎coderd/database/migrations/000160_delete_template_versions.down.sql b/‎coderd/database/migrations/000160_delete_template_versions.down.sql
diff --git a/‎coderd/database/migrations/000162_delete_template_versions.down.sql
Lines changed: 26 additions & 0 deletions b/‎coderd/database/migrations/000162_delete_template_versions.down.sql
Lines changed: 26 additions & 0 deletions
diff --git a/‎coderd/database/migrations/000160_delete_template_versions.up.sql renamed to ‎coderd/database/migrations/000162_delete_template_versions.up.sql b/‎coderd/database/migrations/000160_delete_template_versions.up.sql renamed to ‎coderd/database/migrations/000162_delete_template_versions.up.sql
diff --git a/‎coderd/database/queries/templateversions.sql
Lines changed: 2 additions & 0 deletions b/‎coderd/database/queries/templateversions.sql
Lines changed: 2 additions & 0 deletions
@@ -0,0 +1,26 @@
+BEGIN;
+
+-- The view will be rebuilt with the new column
+DROP VIEW template_version_with_user;
+
+ALTER TABLE template_versions
+	DROP COLUMN deleted;
+
+-- Restore the old version of the template_version_with_user view.
+CREATE VIEW
+	template_version_with_user
+AS
+SELECT
+	template_versions.*,
+	coalesce(visible_users.avatar_url, '') AS created_by_avatar_url,
+	coalesce(visible_users.username, '') AS created_by_username
+FROM
+	template_versions
+		LEFT JOIN
+	visible_users
+	ON
+		template_versions.created_by = visible_users.id;
+
+COMMENT ON VIEW template_version_with_user IS 'Joins in the username + avatar url of the created by user.';
+
+COMMIT;
@@ -180,6 +180,8 @@ FROM
 		  -- Also never delete the active template version
 		  AND active_version_id != template_versions.id
     	  AND CASE
+    	    -- Optionally, only prune versions that match a given
+    	    -- job status like 'failed'.
     	  	WHEN @job_status != '' THEN
 		  		provisioner_jobs.job_status = @job_status
 		  	ELSE