summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorByron Jones <glob@mozilla.com>2015-05-27 07:09:49 +0200
committerByron Jones <glob@mozilla.com>2015-05-27 07:09:49 +0200
commit9ed52766bb2ac635ee14aadde520e50102a6d87c (patch)
tree818f323dd323e81209ff41c6e19a5d11bff5273c
parentad9f924253079bdd95721dcede870eae4c07dc61 (diff)
downloadbugzilla-9ed52766bb2ac635ee14aadde520e50102a6d87c.tar.gz
bugzilla-9ed52766bb2ac635ee14aadde520e50102a6d87c.tar.xz
Bug 1164850: add preferences to request nagging watching facility (reviews only, extended period, and skip encryption)
-rw-r--r--extensions/RequestNagger/Extension.pm32
1 files changed, 32 insertions, 0 deletions
diff --git a/extensions/RequestNagger/Extension.pm b/extensions/RequestNagger/Extension.pm
index 0ed517244..fa570edab 100644
--- a/extensions/RequestNagger/Extension.pm
+++ b/extensions/RequestNagger/Extension.pm
@@ -323,6 +323,38 @@ sub db_schema_abstract_schema {
},
],
};
+ $args->{'schema'}->{'nag_settings'} = {
+ FIELDS => [
+ id => {
+ TYPE => 'MEDIUMSERIAL',
+ NOTNULL => 1,
+ PRIMARYKEY => 1,
+ },
+ user_id => {
+ TYPE => 'INT3',
+ NOTNULL => 1,
+ REFERENCES => {
+ TABLE => 'profiles',
+ COLUMN => 'userid',
+ DELETE => 'CASCADE',
+ }
+ },
+ setting_name => {
+ TYPE => 'VARCHAR(16)',
+ NOTNULL => 1,
+ },
+ setting_value => {
+ TYPE => 'VARCHAR(16)',
+ NOTNULL => 1,
+ },
+ ],
+ INDEXES => [
+ nag_watch_idx => {
+ FIELDS => [ 'user_id', 'setting_name' ],
+ TYPE => 'UNIQUE',
+ },
+ ],
+ };
}
sub install_update_db {