From d11ebe02d5e293f88992090878db4c95523f1809 Mon Sep 17 00:00:00 2001
From: "mkanat%kerio.com" <>
Date: Thu, 18 Aug 2005 01:24:44 +0000
Subject: Bug 296054: [PostgreSQL] Cannot add a new query for event/whining
 Patch By Max Kanat-Alexander <mkanat@bugzilla.org> r=LpSolit, a=justdave

---
 Bugzilla/DB/Schema.pm | 3 ++-
 checksetup.pl         | 6 ++++++
 2 files changed, 8 insertions(+), 1 deletion(-)

diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm
index f86f47965..3e86cc50d 100644
--- a/Bugzilla/DB/Schema.pm
+++ b/Bugzilla/DB/Schema.pm
@@ -915,7 +915,8 @@ use constant ABSTRACT_SCHEMA => {
                               DEFAULT => '0'},
             onemailperbug => {TYPE => 'BOOLEAN', NOTNULL => 1,
                               DEFAULT => 'FALSE'},
-            title         => {TYPE => 'varchar(128)', NOTNULL => 1},
+            title         => {TYPE => 'varchar(128)', NOTNULL => 1,
+                              DEFAULT => "''"},
         ],
         INDEXES => [
             whine_queries_eventid_idx => ['eventid'],
diff --git a/checksetup.pl b/checksetup.pl
index 60a3e8f11..1b3c5d094 100755
--- a/checksetup.pl
+++ b/checksetup.pl
@@ -4011,6 +4011,12 @@ if (Param('defaultopsys') eq 'other') {
         . "         uses 'Other' (capital O).\n";
 }
 
+# Add a DEFAULT to whine_queries stuff so that editwhines.cgi
+# works on PostgreSQL.
+$dbh->bz_alter_column('whine_queries', 'title', {TYPE => 'varchar(128)', 
+                      NOTNULL => 1, DEFAULT => "''"});
+
+
 # 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