summaryrefslogtreecommitdiff
path: root/app/Schema/Sqlite.php
diff options
context:
space:
mode:
Diffstat (limited to 'app/Schema/Sqlite.php')
-rw-r--r--app/Schema/Sqlite.php42
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');