From e6d0658a0eedeb6a641c003d1c492af0f9a7502c Mon Sep 17 00:00:00 2001 From: Frédéric Guillot Date: Mon, 1 Sep 2014 19:36:40 -0800 Subject: Add the possibility to duplicate a task to another project --- app/Schema/Mysql.php | 2 +- app/Schema/Postgres.php | 2 +- app/Schema/Sqlite.php | 2 +- 3 files changed, 3 insertions(+), 3 deletions(-) (limited to 'app/Schema') 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 )" -- cgit v1.2.3