diff options
author | Frederic Guillot <fred@kanboard.net> | 2015-08-18 21:39:43 -0400 |
---|---|---|
committer | Frederic Guillot <fred@kanboard.net> | 2015-08-18 21:39:43 -0400 |
commit | 6b4786624be70c4c024b829407a7496eec361cbb (patch) | |
tree | 51999c360f0f0c965b317ba31419118ef6ace8a3 /app/Schema | |
parent | b04cbc419b60df02ca59a9bbf87cd840614b09a4 (diff) |
Add start and end date for projects
Diffstat (limited to 'app/Schema')
-rw-r--r-- | app/Schema/Mysql.php | 8 | ||||
-rw-r--r-- | app/Schema/Postgres.php | 8 | ||||
-rw-r--r-- | app/Schema/Sqlite.php | 8 |
3 files changed, 21 insertions, 3 deletions
diff --git a/app/Schema/Mysql.php b/app/Schema/Mysql.php index 9bd610bb..0a8ede18 100644 --- a/app/Schema/Mysql.php +++ b/app/Schema/Mysql.php @@ -6,7 +6,13 @@ use PDO; use Core\Security; use Model\Link; -const VERSION = 83; +const VERSION = 84; + +function version_84($pdo) +{ + $pdo->exec("ALTER TABLE projects ADD COLUMN start_date CHAR(10) DEFAULT ''"); + $pdo->exec("ALTER TABLE projects ADD COLUMN end_date CHAR(10) DEFAULT ''"); +} function version_83($pdo) { diff --git a/app/Schema/Postgres.php b/app/Schema/Postgres.php index 143167e3..a0c71e0c 100644 --- a/app/Schema/Postgres.php +++ b/app/Schema/Postgres.php @@ -6,7 +6,13 @@ use PDO; use Core\Security; use Model\Link; -const VERSION = 63; +const VERSION = 64; + +function version_64($pdo) +{ + $pdo->exec("ALTER TABLE projects ADD COLUMN start_date CHAR(10) DEFAULT ''"); + $pdo->exec("ALTER TABLE projects ADD COLUMN end_date CHAR(10) DEFAULT ''"); +} function version_63($pdo) { diff --git a/app/Schema/Sqlite.php b/app/Schema/Sqlite.php index 15268d9a..4fb1819f 100644 --- a/app/Schema/Sqlite.php +++ b/app/Schema/Sqlite.php @@ -6,7 +6,13 @@ use Core\Security; use PDO; use Model\Link; -const VERSION = 79; +const VERSION = 80; + +function version_80($pdo) +{ + $pdo->exec("ALTER TABLE projects ADD COLUMN start_date TEXT DEFAULT ''"); + $pdo->exec("ALTER TABLE projects ADD COLUMN end_date TEXT DEFAULT ''"); +} function version_79($pdo) { |