From ff8c2c11f79f69e8f6ac1944cce7dd41fa6660ff Mon Sep 17 00:00:00 2001
From: "bbaetz%student.usyd.edu.au" <>
Date: Tue, 30 Jul 2002 21:05:20 +0000
Subject: Bug 158236 - Remove 'watchfordiffs' column from namedqueries table
 r=preed, jouni

---
 checksetup.pl | 20 +++++++-------------
 1 file changed, 7 insertions(+), 13 deletions(-)

(limited to 'checksetup.pl')

diff --git a/checksetup.pl b/checksetup.pl
index 5a522643d..ea4377fe9 100755
--- a/checksetup.pl
+++ b/checksetup.pl
@@ -1504,22 +1504,10 @@ $table{profiles_activity} =
 $table{namedqueries} =
     'userid mediumint not null,
      name varchar(64) not null,
-     watchfordiffs tinyint not null,
      linkinfooter tinyint not null,
      query mediumtext not null,
 
-     unique(userid, name),
-     index(watchfordiffs)';
-
-# This isn't quite cooked yet...
-#
-#  $table{diffprefs} =
-#     'userid mediumint not null,
-#      fieldid mediumint not null,
-#      mailhead tinyint not null,
-#      maildiffs tinyint not null,
-#
-#      index(userid)';
+     unique(userid, name)';
 
 $table{fielddefs} =
    'fieldid mediumint not null auto_increment primary key,
@@ -3047,6 +3035,12 @@ if (-e 'data/comments.bak' && !$renamed_comments_file) {
     print "The data/comments.bak file can be removed, as it's no longer
            used.\n\n";
 }
+
+# 2002-07-31 bbaetz@student.usyd.edu.au bug 158236
+# Remove unused column
+if (GetFieldDef("namedqueries", "watchfordiffs")) {
+    DropField("namedqueries", "watchfordiffs");
+}
         
 # If you had to change the --TABLE-- definition in any way, then add your
 # differential change code *** A B O V E *** this comment.
-- 
cgit v1.2.3-24-g4f1b