diff options
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 )" |