diff options
| author | Frédéric Guillot <fred@kanboard.net> | 2014-09-28 18:23:21 -0400 |
|---|---|---|
| committer | Frédéric Guillot <fred@kanboard.net> | 2014-09-28 18:23:21 -0400 |
| commit | 33f9cdbc976e0f97c3dd24658dc7d0097497c6d7 (patch) | |
| tree | 3a5dc8ca9a6b3db268ba95aec357a2e5a8aad80e /app/Schema/Postgres.php | |
| parent | 03fa01ac7b036820ee232d893ec63241918c6012 (diff) | |
Add support for Github Issue Webhooks
Diffstat (limited to 'app/Schema/Postgres.php')
| -rw-r--r-- | app/Schema/Postgres.php | 17 |
1 files changed, 13 insertions, 4 deletions
diff --git a/app/Schema/Postgres.php b/app/Schema/Postgres.php index 3341d4a1..33859513 100644 --- a/app/Schema/Postgres.php +++ b/app/Schema/Postgres.php @@ -4,7 +4,16 @@ namespace Schema; use Core\Security; -const VERSION = 8; +const VERSION = 9; + +function version_9($pdo) +{ + $pdo->exec("ALTER TABLE tasks ADD COLUMN reference VARCHAR(50) DEFAULT ''"); + $pdo->exec("ALTER TABLE comments ADD COLUMN reference VARCHAR(50) DEFAULT ''"); + + $pdo->exec('CREATE INDEX tasks_reference_idx ON tasks(reference)'); + $pdo->exec('CREATE INDEX comments_reference_idx ON comments(reference)'); +} function version_8($pdo) { @@ -22,7 +31,7 @@ function version_6($pdo) CREATE TABLE task_has_events ( id SERIAL PRIMARY KEY, date_creation INTEGER NOT NULL, - event_name TEXT NOT NULL, + event_name VARCHAR(50) NOT NULL, creator_id INTEGER, project_id INTEGER, task_id INTEGER, @@ -37,7 +46,7 @@ function version_6($pdo) CREATE TABLE subtask_has_events ( id SERIAL PRIMARY KEY, date_creation INTEGER NOT NULL, - event_name TEXT NOT NULL, + event_name VARCHAR(50) NOT NULL, creator_id INTEGER, project_id INTEGER, subtask_id INTEGER, @@ -54,7 +63,7 @@ function version_6($pdo) CREATE TABLE comment_has_events ( id SERIAL PRIMARY KEY, date_creation INTEGER NOT NULL, - event_name TEXT NOT NULL, + event_name VARCHAR(50) NOT NULL, creator_id INTEGER, project_id INTEGER, comment_id INTEGER, |