diff options
Diffstat (limited to 'app/Schema/Mysql.php')
-rw-r--r-- | app/Schema/Mysql.php | 16 |
1 files changed, 15 insertions, 1 deletions
diff --git a/app/Schema/Mysql.php b/app/Schema/Mysql.php index edf63919..852dca92 100644 --- a/app/Schema/Mysql.php +++ b/app/Schema/Mysql.php @@ -6,7 +6,21 @@ use PDO; use Kanboard\Core\Security; use Kanboard\Model\Link; -const VERSION = 91; +const VERSION = 92; + +function version_92($pdo) +{ + $pdo->exec(" + CREATE TABLE project_has_notification_types ( + id INT NOT NULL AUTO_INCREMENT, + project_id INT NOT NULL, + notification_type VARCHAR(50), + PRIMARY KEY(id), + FOREIGN KEY(project_id) REFERENCES projects(id) ON DELETE CASCADE + UNIQUE(project_id, notification_type), + ) ENGINE=InnoDB CHARSET=utf8 + "); +} function version_91($pdo) { |