diff options
Diffstat (limited to 'db/migrations/0178_icy_robin_chapel.sql')
| -rw-r--r-- | db/migrations/0178_icy_robin_chapel.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/db/migrations/0178_icy_robin_chapel.sql b/db/migrations/0178_icy_robin_chapel.sql index 0eb78a44..91951900 100644 --- a/db/migrations/0178_icy_robin_chapel.sql +++ b/db/migrations/0178_icy_robin_chapel.sql @@ -58,6 +58,7 @@ CREATE VIEW "public"."qna_answer_view" AS (select "qna_answer"."id", "qna_answer LIMIT 1 ) ) as "is_latest_answer" from "qna_answer" left join "qna" on "qna_answer"."qna_id" = "qna"."id" left join "users" on "qna_answer"."author" = "users"."id" left join "vendors" on "users"."company_id" = "vendors"."id" left join "tech_vendors" on "users"."tech_company_id" = "tech_vendors"."id" where "qna_answer"."is_deleted" = false order by "qna_answer"."created_at");--> statement-breakpoint + CREATE VIEW "public"."qna_comment_view" AS (select "qna_comments"."id", "qna_comments"."content", "qna_comments"."author", "qna_comments"."answer_id", "qna_comments"."parent_comment_id", "qna_comments"."created_at", "qna_comments"."updated_at", "qna_comments"."is_deleted", "qna_comments"."deleted_at", "qna_answer"."content", "qna_answer"."author", "qna_answer"."created_at", "qna_answer"."qna_id", "qna"."title", "qna"."author", "users"."name", "users"."email", "users"."domain", "users"."image_url", "vendors"."vendor_name", "tech_vendors"."vendor_name", COALESCE("vendors"."vendor_name", "tech_vendors"."vendor_name") as "company_name", CASE WHEN "vendors"."vendor_name" IS NOT NULL THEN 'vendor' |