summaryrefslogtreecommitdiffstats
path: root/extensions/Review
diff options
context:
space:
mode:
authorDylan William Hardison <dylan@mozilla.com>2014-02-28 23:10:04 +0100
committerDavid Lawrence <dkl@mozilla.com>2014-02-28 23:10:04 +0100
commit3dffa2cfc91b73613fcb2397870be2ffb13ca6a1 (patch)
tree8f0d8905a634fdc91fed6c25e7ee415985e47c99 /extensions/Review
parentc022b444ed89c1d176b2a54aadf3b2096103c739 (diff)
downloadbugzilla-3dffa2cfc91b73613fcb2397870be2ffb13ca6a1.tar.gz
bugzilla-3dffa2cfc91b73613fcb2397870be2ffb13ca6a1.tar.xz
Bug 956229 - develop a system to track the lifetime of review/feedback/needinfo requests
r=dkl
Diffstat (limited to 'extensions/Review')
-rw-r--r--extensions/Review/Extension.pm71
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 {