summaryrefslogtreecommitdiff
path: root/db/migrations_backup/0005_loud_whizzer.sql
diff options
context:
space:
mode:
authorjoonhoekim <26rote@gmail.com>2025-10-10 11:45:48 +0900
committerjoonhoekim <26rote@gmail.com>2025-10-10 11:45:48 +0900
commitfed3dc0349be8faa5a94048e2ce2d96e432bf734 (patch)
tree1c81e9b2e98d9869225a2897fd2a0d2c9398a556 /db/migrations_backup/0005_loud_whizzer.sql
parent631b09172b48ec24c4f0131bc97017b87ddf0c47 (diff)
(김준회) chore: migrations_backup 경로 제거
Diffstat (limited to 'db/migrations_backup/0005_loud_whizzer.sql')
-rw-r--r--db/migrations_backup/0005_loud_whizzer.sql1
1 files changed, 0 insertions, 1 deletions
diff --git a/db/migrations_backup/0005_loud_whizzer.sql b/db/migrations_backup/0005_loud_whizzer.sql
deleted file mode 100644
index cfd7a735..00000000
--- a/db/migrations_backup/0005_loud_whizzer.sql
+++ /dev/null
@@ -1 +0,0 @@
-CREATE VIEW "public"."role_view" AS (select "roles"."id", "roles"."name", "roles"."description", "roles"."domain", "roles"."created_at", "roles"."company_id", "companies"."name", COUNT("users"."id") as "user_count" from "roles" left join "user_roles" on "user_roles"."role_id" = "roles"."id" left join "users" on "users"."id" = "user_roles"."user_id" left join "companies" on "roles"."company_id" = "companies"."id" group by "roles"."id", "companies"."id"); \ No newline at end of file