summaryrefslogtreecommitdiff
path: root/db/migrations_backup/0057_fancy_serpent_society.sql
diff options
context:
space:
mode:
Diffstat (limited to 'db/migrations_backup/0057_fancy_serpent_society.sql')
-rw-r--r--db/migrations_backup/0057_fancy_serpent_society.sql29
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