Bug 1164850: add preferences to request nagging watching facility (reviews only, extended period, and skip encryption)

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 {