summaryrefslogtreecommitdiff
path: root/plugins/Timetrackingeditor/Schema/Mysql.php
diff options
context:
space:
mode:
Diffstat (limited to 'plugins/Timetrackingeditor/Schema/Mysql.php')
-rw-r--r--plugins/Timetrackingeditor/Schema/Mysql.php16
1 files changed, 16 insertions, 0 deletions
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");
+}