Bug 253721: Add group-based lists to whining

Patch by Erik Stambaugh <erik@dasbistro.com>
r=joel, r,a=justdave

1 files changed, 7 insertions, 1 deletions

diff --git a/checksetup.pl b/checksetup.pl
index 287b0baa6..7404b5912 100755
--- a/checksetup.pl
+++ b/checksetup.pl
@@ -2108,7 +2108,8 @@ $table{whine_schedules} =
      run_day        varchar(32),
      run_time       varchar(32),
      run_next       datetime,
-     mailto_userid  mediumint       not null,
+     mailto         mediumint       not null,
+     mailto_type    smallint        not null default 0,
      
      index(run_next),
      index(eventid)';
@@ -4223,6 +4224,11 @@ AddField("profiles", "extern_id", "varchar(64)");
 AddField('flagtypes', 'grant_group_id', 'mediumint null');
 AddField('flagtypes', 'request_group_id', 'mediumint null');
 
+# 2004-01-03 - bug 253721 erik@dasbistro.com
+# mailto is no longer just userids
+RenameField('whine_schedules', 'mailto_userid', 'mailto');
+AddField('whine_schedules', 'mailto_type', 'smallint not null default 0');
+
 # 2005-01-29 - mkanat@kerio.com
 if (!GetFieldDef('longdescs', 'already_wrapped')) {
     AddField('longdescs', 'already_wrapped', 'tinyint not null default 0');