diff options
Diffstat (limited to 'db/migrations_backup/0057_fancy_serpent_society.sql')
| -rw-r--r-- | db/migrations_backup/0057_fancy_serpent_society.sql | 29 |
1 files changed, 0 insertions, 29 deletions
diff --git a/db/migrations_backup/0057_fancy_serpent_society.sql b/db/migrations_backup/0057_fancy_serpent_society.sql deleted file mode 100644 index 780d023b..00000000 --- a/db/migrations_backup/0057_fancy_serpent_society.sql +++ /dev/null @@ -1,29 +0,0 @@ -DROP VIEW "public"."document_stages_view";--> statement-breakpoint -CREATE VIEW "public"."document_stages_view" AS ( - SELECT - d.id AS document_id, - d.doc_number, - d.title, - d.status, - d.issued_date, - d.contract_id, - - ( - SELECT COUNT(*) - FROM issue_stages - WHERE document_id = d.id - ) AS stage_count, - - COALESCE( - ( - SELECT json_agg(i.stage_name) - FROM issue_stages i - WHERE i.document_id = d.id - ), - '[]' - ) AS stage_list, - - d.created_at, - d.updated_at - FROM documents d -);
\ No newline at end of file |
