From 62827e6cf470449c117624058fb36ad94804bcc0 Mon Sep 17 00:00:00 2001
From: emkael <emkael@tlen.pl>
Date: Tue, 5 May 2020 14:25:42 +0200
Subject: Time tracking related plugins

---
 plugins/Timetrackingeditor/Schema/Mysql.php    | 16 ++++++++++++++++
 plugins/Timetrackingeditor/Schema/Postgres.php | 16 ++++++++++++++++
 plugins/Timetrackingeditor/Schema/Sqlite.php   | 16 ++++++++++++++++
 3 files changed, 48 insertions(+)
 create mode 100644 plugins/Timetrackingeditor/Schema/Mysql.php
 create mode 100644 plugins/Timetrackingeditor/Schema/Postgres.php
 create mode 100644 plugins/Timetrackingeditor/Schema/Sqlite.php

(limited to 'plugins/Timetrackingeditor/Schema')

diff --git a/plugins/Timetrackingeditor/Schema/Mysql.php b/plugins/Timetrackingeditor/Schema/Mysql.php
new file mode 100644
index 00000000..8fda41c7
--- /dev/null
+++ b/plugins/Timetrackingeditor/Schema/Mysql.php
@@ -0,0 +1,16 @@
+<?php
+
+namespace Kanboard\Plugin\Timetrackingeditor\Schema;
+
+const VERSION = 2;
+
+function version_2($pdo)
+{
+  $pdo->exec("ALTER TABLE subtasks add time_billable INT default 0");
+}
+
+function version_1($pdo)
+{
+  $pdo->exec("ALTER TABLE subtask_time_tracking add comment TEXT");
+  $pdo->exec("ALTER TABLE subtask_time_tracking add is_billable TINYINT");
+}
diff --git a/plugins/Timetrackingeditor/Schema/Postgres.php b/plugins/Timetrackingeditor/Schema/Postgres.php
new file mode 100644
index 00000000..b735e931
--- /dev/null
+++ b/plugins/Timetrackingeditor/Schema/Postgres.php
@@ -0,0 +1,16 @@
+<?php
+
+namespace Kanboard\Plugin\Timetrackingeditor\Schema;
+
+const VERSION = 2;
+
+function vesion_2($pdo)
+{
+  $pdo->exec("ALTER TABLE subtasks add time_billable INTEGER default 0");
+}
+
+function version_1($pdo)
+{
+  $pdo->exec("ALTER TABLE subtask_time_tracking add comment TEXT");
+  $pdo->exec("ALTER TABLE subtask_time_tracking add is_billable BOOLEAN");
+}
diff --git a/plugins/Timetrackingeditor/Schema/Sqlite.php b/plugins/Timetrackingeditor/Schema/Sqlite.php
new file mode 100644
index 00000000..ffbeac85
--- /dev/null
+++ b/plugins/Timetrackingeditor/Schema/Sqlite.php
@@ -0,0 +1,16 @@
+<?php
+
+namespace Kanboard\Plugin\Timetrackingeditor\Schema;
+
+const VERSION = 2;
+
+function version_2($pdo)
+{
+  $pdo->exec("ALTER TABLE subtasks add time_billable NUMERIC default 0");
+}
+
+function version_1($pdo)
+{
+  $pdo->exec("ALTER TABLE subtask_time_tracking add comment TEXT");
+  $pdo->exec("ALTER TABLE subtask_time_tracking add is_billable INTEGER");
+}
-- 
cgit v1.2.3