Bug 956229 - develop a system to track the lifetime of review/feedback/needinfo requests

r=dkl

1 files changed, 71 insertions, 0 deletions

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 {