From 7749b8ed569f6d27b0bb2ed4c2040e8b61ed4422 Mon Sep 17 00:00:00 2001
From: Frédéric Guillot <fguillot@users.noreply.github.com>
Date: Sun, 9 Mar 2014 23:21:23 -0400
Subject: Automatic actions

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

(limited to 'models/schema.php')

diff --git a/models/schema.php b/models/schema.php
index 14604e60..621bc981 100644
--- a/models/schema.php
+++ b/models/schema.php
@@ -2,6 +2,29 @@
 
 namespace Schema;
 
+function version_10($pdo)
+{
+    $pdo->exec(
+        'CREATE TABLE actions (
+            id INTEGER PRIMARY KEY,
+            project_id INTEGER,
+            event_name TEXT,
+            action_name TEXT,
+            FOREIGN KEY(project_id) REFERENCES projects(id) ON DELETE CASCADE
+        )'
+    );
+
+    $pdo->exec(
+        'CREATE TABLE action_has_params (
+            id INTEGER PRIMARY KEY,
+            action_id INTEGER,
+            name TEXT,
+            value TEXT,
+            FOREIGN KEY(action_id) REFERENCES actions(id) ON DELETE CASCADE
+        )'
+    );
+}
+
 function version_9($pdo)
 {
     $pdo->exec("ALTER TABLE tasks ADD COLUMN date_due INTEGER");
-- 
cgit v1.2.3