From 9ed52766bb2ac635ee14aadde520e50102a6d87c Mon Sep 17 00:00:00 2001
From: Byron Jones <glob@mozilla.com>
Date: Wed, 27 May 2015 13:09:49 +0800
Subject: Bug 1164850: add preferences to request nagging watching facility
 (reviews only, extended period, and skip encryption)

---
 extensions/RequestNagger/Extension.pm | 32 ++++++++++++++++++++++++++++++++
 1 file changed, 32 insertions(+)

(limited to 'extensions/RequestNagger')

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 {
-- 
cgit v1.2.3-24-g4f1b