From 95e7b1498f2c178383699f8d30208cc326b7a37b Mon Sep 17 00:00:00 2001
From: "Dzial Techniczny WMW Projekt s.c" <techniczna@wmwprojekt.pl>
Date: Wed, 15 Jan 2020 16:07:19 +0100
Subject: Displaying internal project ID for tasks

---
 plugins/InternalID/Schema/Sqlite.php | 11 +++++++++++
 1 file changed, 11 insertions(+)
 create mode 100644 plugins/InternalID/Schema/Sqlite.php

(limited to 'plugins/InternalID/Schema')

diff --git a/plugins/InternalID/Schema/Sqlite.php b/plugins/InternalID/Schema/Sqlite.php
new file mode 100644
index 00000000..2c1f4f27
--- /dev/null
+++ b/plugins/InternalID/Schema/Sqlite.php
@@ -0,0 +1,11 @@
+<?php
+
+namespace Kanboard\Plugin\InternalID\Schema;
+
+const VERSION = 1;
+
+function version_1($pdo) {
+
+    $pdo->exec('CREATE VIEW task_internal_id AS SELECT COUNT(t1.id) internal_id, t1.id id, t1.project_id project_id FROM tasks t1 JOIN tasks t2 ON t1.id >= t2.id AND t1.project_id = t2.project_id GROUP BY t1.id, t1.project_id;');
+
+}
-- 
cgit v1.2.3