diff options
| author | gerv%gerv.net <> | 2005-03-30 07:42:53 +0200 |
|---|---|---|
| committer | gerv%gerv.net <> | 2005-03-30 07:42:53 +0200 |
| commit | 882dcc873146d665f2d1257b89e588ae6e6356f0 (patch) | |
| tree | ceb5ac9f6378961fbc009216e09447e45b8886e0 /Bugzilla/DB | |
| parent | 13e55e5e4b0338848274ebdf258c8e60d826e7fe (diff) | |
| download | bugzilla-882dcc873146d665f2d1257b89e588ae6e6356f0.tar.gz bugzilla-882dcc873146d665f2d1257b89e588ae6e6356f0.tar.xz | |
Bug 73665 - migrate email preferences to their own table, and rearchitect email internals. Patch by gerv; r=jake, a=justdave.
Diffstat (limited to 'Bugzilla/DB')
| -rw-r--r-- | Bugzilla/DB/Schema.pm | 15 |
1 files changed, 14 insertions, 1 deletions
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}, |