diff options
author | Frédéric Guillot <fred@kanboard.net> | 2014-09-09 20:39:45 +0200 |
---|---|---|
committer | Frédéric Guillot <fred@kanboard.net> | 2014-09-09 20:39:45 +0200 |
commit | 9bde377bbe85617dde280af985e033cf7de61803 (patch) | |
tree | 2d2c080a86542206f862bd6d1c14ce622aa225a8 /app/Schema | |
parent | ef95c7c28479a22e41fff35a893f05eb084e1f2c (diff) |
Start to implement task history and project activity
Diffstat (limited to 'app/Schema')
-rw-r--r-- | app/Schema/Sqlite.php | 19 |
1 files changed, 18 insertions, 1 deletions
diff --git a/app/Schema/Sqlite.php b/app/Schema/Sqlite.php index 21b6ed4d..e18d35e9 100644 --- a/app/Schema/Sqlite.php +++ b/app/Schema/Sqlite.php @@ -4,7 +4,24 @@ namespace Schema; use Core\Security; -const VERSION = 24; +const VERSION = 25; + +function version_25($pdo) +{ + $pdo->exec(" + CREATE TABLE task_has_events ( + id INTEGER PRIMARY KEY, + date_creation INTEGER, + event_name TEXT NOT NULL, + creator_id INTEGER, + project_id INTEGER, + task_id INTEGER, + FOREIGN KEY(creator_id) REFERENCES users(id) ON DELETE CASCADE, + FOREIGN KEY(project_id) REFERENCES projects(id) ON DELETE CASCADE, + FOREIGN KEY(task_id) REFERENCES tasks(id) ON DELETE CASCADE + ); + "); +} function version_24($pdo) { |