From 3dffa2cfc91b73613fcb2397870be2ffb13ca6a1 Mon Sep 17 00:00:00 2001
From: Dylan William Hardison <dylan@mozilla.com>
Date: Fri, 28 Feb 2014 22:10:04 +0000
Subject: Bug 956229 - develop a system to track the lifetime of
 review/feedback/needinfo requests r=dkl

---
 extensions/Review/Extension.pm | 71 ++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 71 insertions(+)

diff --git a/extensions/Review/Extension.pm b/extensions/Review/Extension.pm
index 06f459613..c92d17d8b 100644
--- a/extensions/Review/Extension.pm
+++ b/extensions/Review/Extension.pm
@@ -555,6 +555,77 @@ sub db_schema_abstract_schema {
         ],
     };
 
+    $args->{'schema'}->{'flag_state_activity'} = {
+        FIELDS => [
+            id => {
+                TYPE       => 'MEDIUMSERIAL',
+                NOTNULL    => 1,
+                PRIMARYKEY => 1,
+            },
+
+            flag_when => {
+                TYPE    => 'DATETIME',
+                NOTNULL => 1,
+            },
+
+            type_id => {
+                TYPE       => 'INT2',
+                NOTNULL    => 1,
+                REFERENCES => {
+                    TABLE  => 'flagtypes',
+                    COLUMN => 'id',
+                    DELETE => 'CASCADE'
+                }
+            },
+
+            flag_id => {
+                TYPE    => 'INT3',
+                NOTNULL => 1,
+            },
+
+            setter_id => {
+                TYPE       => 'INT3',
+                NOTNULL    => 1,
+                REFERENCES => {
+                    TABLE  => 'profiles',
+                    COLUMN => 'userid',
+                },
+            },
+
+            requestee_id => {
+                TYPE       => 'INT3',
+                REFERENCES => {
+                    TABLE  => 'profiles',
+                    COLUMN => 'userid',
+                },
+            },
+
+            bug_id => {
+                TYPE       => 'INT3',
+                NOTNULL    => 1,
+                REFERENCES => {
+                    TABLE  => 'bugs',
+                    COLUMN => 'bug_id',
+                    DELETE => 'CASCADE'
+                }
+            },
+
+            attachment_id => {
+                TYPE       => 'INT3',
+                REFERENCES => {
+                    TABLE  => 'attachments',
+                    COLUMN => 'attach_id',
+                    DELETE => 'CASCADE'
+                }
+            },
+
+            status => {
+                TYPE    => 'CHAR(1)',
+                NOTNULL => 1,
+            },
+        ],
+    };
+
 }
 
 sub install_update_db {
-- 
cgit v1.2.3-24-g4f1b