From 882dcc873146d665f2d1257b89e588ae6e6356f0 Mon Sep 17 00:00:00 2001
From: "gerv%gerv.net" <>
Date: Wed, 30 Mar 2005 05:42:53 +0000
Subject: Bug 73665 - migrate email preferences to their own table, and
 rearchitect email internals. Patch by gerv; r=jake, a=justdave.

---
 Bugzilla/DB/Schema.pm | 15 ++++++++++++++-
 1 file changed, 14 insertions(+), 1 deletion(-)

(limited to 'Bugzilla/DB/Schema.pm')

diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm
index 801f353d7..564d8c7a0 100644
--- a/Bugzilla/DB/Schema.pm
+++ b/Bugzilla/DB/Schema.pm
@@ -584,7 +584,6 @@ use constant ABSTRACT_SCHEMA => {
             disabledtext   => {TYPE => 'MEDIUMTEXT', NOTNULL => 1},
             mybugslink     => {TYPE => 'BOOLEAN', NOTNULL => 1,
                                DEFAULT => 'TRUE'},
-            emailflags     => {TYPE => 'MEDIUMTEXT'},
             refreshed_when => {TYPE => 'DATETIME', NOTNULL => 1},
             extern_id      => {TYPE => 'varchar(64)'},
         ],
@@ -610,6 +609,20 @@ use constant ABSTRACT_SCHEMA => {
         ],
     },
 
+    email_setting => {
+        FIELDS => [
+            user_id      => {TYPE => 'INT3', NOTNULL => 1},
+            relationship => {TYPE => 'INT1', NOTNULL => 1},
+            event        => {TYPE => 'INT1', NOTNULL => 1},
+        ],
+        INDEXES => [
+            email_settings_user_id_idx => ['user_id'],
+            email_settings_unique_idx  =>
+                                    {FIELDS => [qw(user_id relationship event)],
+                                     TYPE => 'UNIQUE'},
+        ],
+    },
+
     watch => {
         FIELDS => [
             watcher => {TYPE => 'INT3', NOTNULL => 1},
-- 
cgit v1.2.3-24-g4f1b