Move budget outside of the core

The budget planning feature is now a plugin
See: https://github.com/kanboard/plugin-budget

3 files changed, 0 insertions, 74 deletions

diff --git a/app/Schema/Mysql.php b/app/Schema/Mysql.php
index 5a12bb3c..e5dff0d5 100644
--- a/app/Schema/Mysql.php
+++ b/app/Schema/Mysql.php
@@ -322,19 +322,6 @@ function version_53($pdo)
     $pdo->exec("ALTER TABLE subtask_time_tracking ADD COLUMN time_spent FLOAT DEFAULT 0");
 }
 
-function version_52($pdo)
-{
-    $pdo->exec('CREATE TABLE budget_lines (
-        `id` INT NOT NULL AUTO_INCREMENT,
-        `project_id` INT NOT NULL,
-        `amount` FLOAT NOT NULL,
-        `date` VARCHAR(10) NOT NULL,
-        `comment` TEXT,
-        FOREIGN KEY(project_id) REFERENCES projects(id) ON DELETE CASCADE,
-        PRIMARY KEY(id)
-    ) ENGINE=InnoDB CHARSET=utf8');
-}
-
 function version_51($pdo)
 {
     $pdo->exec('CREATE TABLE timetable_day (
@@ -381,19 +368,6 @@ function version_51($pdo)
     ) ENGINE=InnoDB CHARSET=utf8');
 }
 
-function version_50($pdo)
-{
-    $pdo->exec("CREATE TABLE hourly_rates (
-        id INT NOT NULL AUTO_INCREMENT,
-        user_id INT NOT NULL,
-        rate FLOAT DEFAULT 0,
-        date_effective INTEGER NOT NULL,
-        currency CHAR(3) NOT NULL,
-        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 ad460cc7..e7422e8c 100644
--- a/app/Schema/Postgres.php
+++ b/app/Schema/Postgres.php
@@ -315,18 +315,6 @@ function version_34($pdo)
     $pdo->exec("ALTER TABLE subtask_time_tracking ADD COLUMN time_spent REAL DEFAULT 0");
 }
 
-function version_33($pdo)
-{
-    $pdo->exec('CREATE TABLE budget_lines (
-        "id" SERIAL PRIMARY KEY,
-        "project_id" INTEGER NOT NULL,
-        "amount" REAL NOT NULL,
-        "date" VARCHAR(10) NOT NULL,
-        "comment" TEXT,
-        FOREIGN KEY(project_id) REFERENCES projects(id) ON DELETE CASCADE
-    )');
-}
-
 function version_32($pdo)
 {
     $pdo->exec('CREATE TABLE timetable_day (
@@ -369,18 +357,6 @@ function version_32($pdo)
     )');
 }
 
-function version_31($pdo)
-{
-    $pdo->exec("CREATE TABLE hourly_rates (
-        id SERIAL PRIMARY KEY,
-        user_id INTEGER NOT NULL,
-        rate REAL DEFAULT 0,
-        date_effective INTEGER NOT NULL,
-        currency CHAR(3) NOT NULL,
-        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 16fe0649..b76e902a 100644
--- a/app/Schema/Sqlite.php
+++ b/app/Schema/Sqlite.php
@@ -292,18 +292,6 @@ function version_52($pdo)
     $pdo->exec("ALTER TABLE subtask_time_tracking ADD COLUMN time_spent REAL DEFAULT 0");
 }
 
-function version_51($pdo)
-{
-    $pdo->exec('CREATE TABLE budget_lines (
-        "id" INTEGER PRIMARY KEY,
-        "project_id" INTEGER NOT NULL,
-        "amount" REAL NOT NULL,
-        "date" TEXT NOT NULL,
-        "comment" TEXT,
-        FOREIGN KEY(project_id) REFERENCES projects(id) ON DELETE CASCADE
-    )');
-}
-
 function version_50($pdo)
 {
     $pdo->exec('CREATE TABLE timetable_day (
@@ -346,18 +334,6 @@ function version_50($pdo)
     )');
 }
 
-function version_49($pdo)
-{
-    $pdo->exec("CREATE TABLE hourly_rates (
-        id INTEGER PRIMARY KEY,
-        user_id INTEGER NOT NULL,
-        rate REAL DEFAULT 0,
-        date_effective INTEGER NOT NULL,
-        currency TEXT NOT NULL,
-        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');