diff options
Diffstat (limited to 'app/Schema/Mysql.php')
-rw-r--r-- | app/Schema/Mysql.php | 46 |
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'); |