From ccc54c65cf2191e35bd0294c0ffbae761b29f151 Mon Sep 17 00:00:00 2001
From: rzeka <piotr@rzeka.net>
Date: Tue, 4 Mar 2014 20:17:26 +0100
Subject: Added basic comments on tasks

---
 models/schema.php | 15 +++++++++++++++
 1 file changed, 15 insertions(+)

(limited to 'models/schema.php')

diff --git a/models/schema.php b/models/schema.php
index f98f0e69..2c3ba7e8 100644
--- a/models/schema.php
+++ b/models/schema.php
@@ -2,6 +2,21 @@
 
 namespace Schema;
 
+function version_8($pdo)
+{
+    $pdo->exec(
+        'CREATE TABLE comments (
+            id INTEGER PRIMARY KEY,
+            task_id INTEGER,
+            user_id INTEGER,
+            date INTEGER,
+            comment TEXT,
+            FOREIGN KEY(task_id) REFERENCES tasks(id) ON DELETE CASCADE,
+            FOREIGN KEY(user_id) REFERENCES tasks(id) ON DELETE CASCADE
+        )'
+    );
+}
+
 function version_7($pdo)
 {
     $pdo->exec("
-- 
cgit v1.2.3