diff options
author | Frederic Guillot <fred@kanboard.net> | 2015-11-25 22:06:39 -0500 |
---|---|---|
committer | Frederic Guillot <fred@kanboard.net> | 2015-11-25 22:06:39 -0500 |
commit | e582d4047b061f0c17e6366fed2bf1cabd624c10 (patch) | |
tree | 4f400b1df198103fb257d468b1aab8c625f32d29 /app/Schema/Mysql.php | |
parent | a8da794b60029c23424ee330e020d18f5f9ac947 (diff) |
Add groups (teams)
Diffstat (limited to 'app/Schema/Mysql.php')
-rw-r--r-- | app/Schema/Mysql.php | 24 |
1 files changed, 23 insertions, 1 deletions
diff --git a/app/Schema/Mysql.php b/app/Schema/Mysql.php index 52a73fb1..5a451c77 100644 --- a/app/Schema/Mysql.php +++ b/app/Schema/Mysql.php @@ -5,7 +5,29 @@ namespace Schema; use PDO; use Kanboard\Core\Security\Token; -const VERSION = 94; +const VERSION = 95; + +function version_95(PDO $pdo) +{ + $pdo->exec(" + CREATE TABLE groups ( + id INT NOT NULL AUTO_INCREMENT, + external_id VARCHAR(255) DEFAULT '', + name VARCHAR(100) NOT NULL UNIQUE, + PRIMARY KEY(id) + ) ENGINE=InnoDB CHARSET=utf8 + "); + + $pdo->exec(" + CREATE TABLE group_has_users ( + group_id INT NOT NULL, + user_id INT NOT NULL, + FOREIGN KEY(group_id) REFERENCES groups(id) ON DELETE CASCADE, + FOREIGN KEY(user_id) REFERENCES users(id) ON DELETE CASCADE, + UNIQUE(group_id, user_id) + ) ENGINE=InnoDB CHARSET=utf8 + "); +} function version_94(PDO $pdo) { |