diff options
author | Frederic Guillot <fred@kanboard.net> | 2015-09-20 18:24:15 -0400 |
---|---|---|
committer | Frederic Guillot <fred@kanboard.net> | 2015-09-20 18:24:15 -0400 |
commit | e6f547abcfe684658a7498391db72d13b6aa7d9a (patch) | |
tree | 75b709c12fb03e11d7cb85558558f89f19abb284 /app/Schema/Sqlite.php | |
parent | 2021dccc5a444f60c5ba1673d94b39999912cd26 (diff) |
Move timetable to a plugin
Plugin repository: https://github.com/kanboard/plugin-timetable
Diffstat (limited to 'app/Schema/Sqlite.php')
-rw-r--r-- | app/Schema/Sqlite.php | 42 |
1 files changed, 0 insertions, 42 deletions
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'); |