summaryrefslogtreecommitdiff
path: root/db/migrations_backup/0056_majestic_khan.sql
diff options
context:
space:
mode:
Diffstat (limited to 'db/migrations_backup/0056_majestic_khan.sql')
-rw-r--r--db/migrations_backup/0056_majestic_khan.sql34
1 files changed, 0 insertions, 34 deletions
diff --git a/db/migrations_backup/0056_majestic_khan.sql b/db/migrations_backup/0056_majestic_khan.sql
deleted file mode 100644
index 161e1c3c..00000000
--- a/db/migrations_backup/0056_majestic_khan.sql
+++ /dev/null
@@ -1,34 +0,0 @@
-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,
-
- (
- SELECT json_agg(
- json_build_object(
- 'id', i.id,
- 'stageName', i.stage_name,
- 'planDate', i.plan_date,
- 'actualDate', i.actual_date,
- 'createdAt', i.created_at,
- 'updatedAt', i.updated_at
- )
- )
- 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