summaryrefslogtreecommitdiff
path: root/app/Schema/Mysql.php
diff options
context:
space:
mode:
authorFrederic Guillot <fred@kanboard.net>2015-09-20 18:24:15 -0400
committerFrederic Guillot <fred@kanboard.net>2015-09-20 18:24:15 -0400
commite6f547abcfe684658a7498391db72d13b6aa7d9a (patch)
tree75b709c12fb03e11d7cb85558558f89f19abb284 /app/Schema/Mysql.php
parent2021dccc5a444f60c5ba1673d94b39999912cd26 (diff)
Move timetable to a plugin
Plugin repository: https://github.com/kanboard/plugin-timetable
Diffstat (limited to 'app/Schema/Mysql.php')
-rw-r--r--app/Schema/Mysql.php46
1 files changed, 0 insertions, 46 deletions
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');