diff options
| author | Frédéric Guillot <fred@kanboard.net> | 2014-09-01 19:36:40 -0800 |
|---|---|---|
| committer | Frédéric Guillot <fred@kanboard.net> | 2014-09-01 19:36:40 -0800 |
| commit | e6d0658a0eedeb6a641c003d1c492af0f9a7502c (patch) | |
| tree | 31004fe37246e39e438fb2dc7f1d07996634f1f3 /app/Schema | |
| parent | e4965546543be040da29dc341900fa9511a158be (diff) | |
Add the possibility to duplicate a task to another project
Diffstat (limited to 'app/Schema')
| -rw-r--r-- | app/Schema/Mysql.php | 2 | ||||
| -rw-r--r-- | app/Schema/Postgres.php | 2 | ||||
| -rw-r--r-- | app/Schema/Sqlite.php | 2 |
3 files changed, 3 insertions, 3 deletions
diff --git a/app/Schema/Mysql.php b/app/Schema/Mysql.php index ca4bbbae..9b202a69 100644 --- a/app/Schema/Mysql.php +++ b/app/Schema/Mysql.php @@ -57,7 +57,7 @@ function version_18($pdo) status INT DEFAULT 0, time_estimated INT DEFAULT 0, time_spent INT DEFAULT 0, - task_id INT, + task_id INT NOT NULL, user_id INT, PRIMARY KEY (id), FOREIGN KEY(task_id) REFERENCES tasks(id) ON DELETE CASCADE diff --git a/app/Schema/Postgres.php b/app/Schema/Postgres.php index ac27f786..99774a55 100644 --- a/app/Schema/Postgres.php +++ b/app/Schema/Postgres.php @@ -143,7 +143,7 @@ function version_1($pdo) status SMALLINT DEFAULT 0, time_estimated INTEGER DEFAULT 0, time_spent INTEGER DEFAULT 0, - task_id INTEGER, + task_id INTEGER NOT NULL, user_id INTEGER, FOREIGN KEY(task_id) REFERENCES tasks(id) ON DELETE CASCADE ); diff --git a/app/Schema/Sqlite.php b/app/Schema/Sqlite.php index fed9aaf8..21b6ed4d 100644 --- a/app/Schema/Sqlite.php +++ b/app/Schema/Sqlite.php @@ -57,7 +57,7 @@ function version_18($pdo) status INTEGER DEFAULT 0, time_estimated INTEGER DEFAULT 0, time_spent INTEGER DEFAULT 0, - task_id INTEGER, + task_id INTEGER NOT NULL, user_id INTEGER, FOREIGN KEY(task_id) REFERENCES tasks(id) ON DELETE CASCADE )" |