From e6f547abcfe684658a7498391db72d13b6aa7d9a Mon Sep 17 00:00:00 2001
From: Frederic Guillot <fred@kanboard.net>
Date: Sun, 20 Sep 2015 18:24:15 -0400
Subject: Move timetable to a plugin

Plugin repository: https://github.com/kanboard/plugin-timetable
---
 app/Schema/Mysql.php    | 46 ----------------------------------------------
 app/Schema/Postgres.php | 42 ------------------------------------------
 app/Schema/Sqlite.php   | 42 ------------------------------------------
 3 files changed, 130 deletions(-)

(limited to 'app/Schema')

diff --git a/app/Schema/Mysql.php b/app/Schema/Mysql.php
index 23a7a90a..c146eb0c 100644
--- a/app/Schema/Mysql.php
+++ b/app/Schema/Mysql.php
@@ -321,52 +321,6 @@ function version_53($pdo)
     $pdo->exec("ALTER TABLE subtask_time_tracking ADD COLUMN time_spent FLOAT DEFAULT 0");
 }
 
-function version_51($pdo)
-{
-    $pdo->exec('CREATE TABLE timetable_day (
-        id INT NOT NULL AUTO_INCREMENT,
-        user_id INT NOT NULL,
-        start VARCHAR(5) NOT NULL,
-        end VARCHAR(5) NOT NULL,
-        FOREIGN KEY(user_id) REFERENCES users(id) ON DELETE CASCADE,
-        PRIMARY KEY(id)
-    ) ENGINE=InnoDB CHARSET=utf8');
-
-    $pdo->exec('CREATE TABLE timetable_week (
-        id INT NOT NULL AUTO_INCREMENT,
-        user_id INTEGER NOT NULL,
-        day INT NOT NULL,
-        start VARCHAR(5) NOT NULL,
-        end VARCHAR(5) NOT NULL,
-        FOREIGN KEY(user_id) REFERENCES users(id) ON DELETE CASCADE,
-        PRIMARY KEY(id)
-    ) ENGINE=InnoDB CHARSET=utf8');
-
-    $pdo->exec('CREATE TABLE timetable_off (
-        id INT NOT NULL AUTO_INCREMENT,
-        user_id INT NOT NULL,
-        date VARCHAR(10) NOT NULL,
-        all_day TINYINT(1) DEFAULT 0,
-        start VARCHAR(5) DEFAULT 0,
-        end VARCHAR(5) DEFAULT 0,
-        comment TEXT,
-        FOREIGN KEY(user_id) REFERENCES users(id) ON DELETE CASCADE,
-        PRIMARY KEY(id)
-    ) ENGINE=InnoDB CHARSET=utf8');
-
-    $pdo->exec('CREATE TABLE timetable_extra (
-        id INT NOT NULL AUTO_INCREMENT,
-        user_id INT NOT NULL,
-        date VARCHAR(10) NOT NULL,
-        all_day TINYINT(1) DEFAULT 0,
-        start VARCHAR(5) DEFAULT 0,
-        end VARCHAR(5) DEFAULT 0,
-        comment TEXT,
-        FOREIGN KEY(user_id) REFERENCES users(id) ON DELETE CASCADE,
-        PRIMARY KEY(id)
-    ) ENGINE=InnoDB CHARSET=utf8');
-}
-
 function version_49($pdo)
 {
     $pdo->exec('ALTER TABLE subtasks ADD COLUMN position INTEGER DEFAULT 1');
diff --git a/app/Schema/Postgres.php b/app/Schema/Postgres.php
index cd4c295e..695d8f1f 100644
--- a/app/Schema/Postgres.php
+++ b/app/Schema/Postgres.php
@@ -314,48 +314,6 @@ function version_34($pdo)
     $pdo->exec("ALTER TABLE subtask_time_tracking ADD COLUMN time_spent REAL DEFAULT 0");
 }
 
-function version_32($pdo)
-{
-    $pdo->exec('CREATE TABLE timetable_day (
-        "id" SERIAL PRIMARY KEY,
-        "user_id" INTEGER NOT NULL,
-        "start" VARCHAR(5) NOT NULL,
-        "end" VARCHAR(5) NOT NULL,
-        FOREIGN KEY(user_id) REFERENCES users(id) ON DELETE CASCADE
-    )');
-
-    $pdo->exec('CREATE TABLE timetable_week (
-        "id" SERIAL PRIMARY KEY,
-        "user_id" INTEGER NOT NULL,
-        "day" INTEGER NOT NULL,
-        "start" VARCHAR(5) NOT NULL,
-        "end" VARCHAR(5) NOT NULL,
-        FOREIGN KEY(user_id) REFERENCES users(id) ON DELETE CASCADE
-    )');
-
-    $pdo->exec('CREATE TABLE timetable_off (
-        "id" SERIAL PRIMARY KEY,
-        "user_id" INTEGER NOT NULL,
-        "date" VARCHAR(10) NOT NULL,
-        "all_day" BOOLEAN DEFAULT \'0\',
-        "start" VARCHAR(5) DEFAULT 0,
-        "end" VARCHAR(5) DEFAULT 0,
-        "comment" TEXT,
-        FOREIGN KEY(user_id) REFERENCES users(id) ON DELETE CASCADE
-    )');
-
-    $pdo->exec('CREATE TABLE timetable_extra (
-        "id" SERIAL PRIMARY KEY,
-        "user_id" INTEGER NOT NULL,
-        "date" VARCHAR(10) NOT NULL,
-        "all_day" BOOLEAN DEFAULT \'0\',
-        "start" VARCHAR(5) DEFAULT 0,
-        "end" VARCHAR(5) DEFAULT 0,
-        "comment" TEXT,
-        FOREIGN KEY(user_id) REFERENCES users(id) ON DELETE CASCADE
-    )');
-}
-
 function version_30($pdo)
 {
     $pdo->exec('ALTER TABLE subtasks ADD COLUMN position INTEGER DEFAULT 1');
diff --git a/app/Schema/Sqlite.php b/app/Schema/Sqlite.php
index 175a583c..26ad96c7 100644
--- a/app/Schema/Sqlite.php
+++ b/app/Schema/Sqlite.php
@@ -291,48 +291,6 @@ function version_52($pdo)
     $pdo->exec("ALTER TABLE subtask_time_tracking ADD COLUMN time_spent REAL DEFAULT 0");
 }
 
-function version_50($pdo)
-{
-    $pdo->exec('CREATE TABLE timetable_day (
-        "id" INTEGER PRIMARY KEY,
-        "user_id" INTEGER NOT NULL,
-        "start" TEXT NOT NULL,
-        "end" TEXT NOT NULL,
-        FOREIGN KEY(user_id) REFERENCES users(id) ON DELETE CASCADE
-    )');
-
-    $pdo->exec('CREATE TABLE timetable_week (
-        "id" INTEGER PRIMARY KEY,
-        "user_id" INTEGER NOT NULL,
-        "day" INTEGER NOT NULL,
-        "start" TEXT NOT NULL,
-        "end" TEXT NOT NULL,
-        FOREIGN KEY(user_id) REFERENCES users(id) ON DELETE CASCADE
-    )');
-
-    $pdo->exec('CREATE TABLE timetable_off (
-        "id" INTEGER PRIMARY KEY,
-        "user_id" INTEGER NOT NULL,
-        "date" TEXT NOT NULL,
-        "all_day" INTEGER DEFAULT 0,
-        "start" TEXT DEFAULT 0,
-        "end" TEXT DEFAULT 0,
-        "comment" TEXT,
-        FOREIGN KEY(user_id) REFERENCES users(id) ON DELETE CASCADE
-    )');
-
-    $pdo->exec('CREATE TABLE timetable_extra (
-        "id" INTEGER PRIMARY KEY,
-        "user_id" INTEGER NOT NULL,
-        "date" TEXT NOT NULL,
-        "all_day" INTEGER DEFAULT 0,
-        "start" TEXT DEFAULT 0,
-        "end" TEXT DEFAULT 0,
-        "comment" TEXT,
-        FOREIGN KEY(user_id) REFERENCES users(id) ON DELETE CASCADE
-    )');
-}
-
 function version_48($pdo)
 {
     $pdo->exec('ALTER TABLE subtasks ADD COLUMN position INTEGER DEFAULT 1');
-- 
cgit v1.2.3