fix(migration): removed hardcoded public (coder#12620)

95gabor · deansheather · commit 793df2edbd29 · 2024-03-19T12:22:48.000Z
(cherry picked from commit 9c69672)
diff --git a/coderd/database/migrations/000196_external_auth_providers_jsonb.down.sql b/coderd/database/migrations/000196_external_auth_providers_jsonb.down.sql
@@ -51,7 +51,7 @@ SELECT
   template_versions.archived,
   COALESCE(visible_users.avatar_url, ''::text) AS created_by_avatar_url,
   COALESCE(visible_users.username, ''::text) AS created_by_username
-FROM (public.template_versions
+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.';
diff --git a/coderd/database/migrations/000196_external_auth_providers_jsonb.up.sql b/coderd/database/migrations/000196_external_auth_providers_jsonb.up.sql
@@ -53,7 +53,7 @@ SELECT
   template_versions.archived,
   COALESCE(visible_users.avatar_url, ''::text) AS created_by_avatar_url,
   COALESCE(visible_users.username, ''::text) AS created_by_username
-FROM (public.template_versions
+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.';
