coder
diff --git a/‎coderd/database/dbauthz/dbauthz.go
+11 b/‎coderd/database/dbauthz/dbauthz.go
+11
diff --git a/‎coderd/database/dbfake/dbfake.go
+9 b/‎coderd/database/dbfake/dbfake.go
+9
diff --git a/‎coderd/database/dbmetrics/dbmetrics.go
+7 b/‎coderd/database/dbmetrics/dbmetrics.go
+7
diff --git a/‎coderd/database/dbmock/dbmock.go
+14 b/‎coderd/database/dbmock/dbmock.go
+14
diff --git a/‎coderd/database/dump.sql
+3-1 b/‎coderd/database/dump.sql
+3-1
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/000160_delete_template_versions.up.sql
+28 b/‎coderd/database/migrations/000160_delete_template_versions.up.sql
+28
diff --git a/‎coderd/database/models.go
+2 b/‎coderd/database/models.go
+2
diff --git a/‎coderd/database/querier.go
+6 b/‎coderd/database/querier.go
+6
@@ -2242,6 +2242,17 @@ func (q *querier) InsertWorkspaceResourceMetadata(ctx context.Context, arg datab
 	return q.db.InsertWorkspaceResourceMetadata(ctx, arg)
 }
 
+func (q *querier) PruneUnusedTemplateVersions(ctx context.Context, arg database.PruneUnusedTemplateVersionsParams) error {
+	tpl, err := q.db.GetTemplateByID(ctx, arg.TemplateID)
+	if err != nil {
+		return err
+	}
+	if err := q.authorizeContext(ctx, rbac.ActionUpdate, tpl); err != nil {
+		return err
+	}
+	return q.db.PruneUnusedTemplateVersions(ctx, arg)
+}
+
 func (q *querier) RegisterWorkspaceProxy(ctx context.Context, arg database.RegisterWorkspaceProxyParams) (database.WorkspaceProxy, error) {
 	fetch := func(ctx context.Context, arg database.RegisterWorkspaceProxyParams) (database.WorkspaceProxy, error) {
 		return q.db.GetWorkspaceProxyByID(ctx, arg.ID)
 
@@ -5175,6 +5175,15 @@ func (q *FakeQuerier) InsertWorkspaceResourceMetadata(_ context.Context, arg dat
 	return metadata, nil
 }
 
+func (q *FakeQuerier) PruneUnusedTemplateVersions(ctx context.Context, arg database.PruneUnusedTemplateVersionsParams) error {
+	err := validateDatabaseType(arg)
+	if err != nil {
+		return err
+	}
+
+	panic("not implemented")
+}
+
 func (q *FakeQuerier) RegisterWorkspaceProxy(_ context.Context, arg database.RegisterWorkspaceProxyParams) (database.WorkspaceProxy, error) {
 	q.mutex.Lock()
 	defer q.mutex.Unlock()
 
@@ -0,0 +1,28 @@
+BEGIN;
+
+-- The view will be rebuilt with the new column
+DROP VIEW template_version_with_user;
+
+-- Hard deleting can cause reference issues with audit logs,
+-- so we only support soft deleting this resource at this time.
+ALTER TABLE template_versions
+    ADD COLUMN deleted BOOLEAN NOT NULL DEFAULT FALSE;
+
+-- 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;