From 07e4290192060ff9b30b03b60155396603a00547 Mon Sep 17 00:00:00 2001
From: "lpsolit%gmail.com" <>
Date: Sat, 5 Nov 2005 20:15:57 +0000
Subject: Bug 305927: [PostgreSQL] Adding a new product partly fails when
 'makeproductgroups' is enabled - Patch by Frédéric Buclin <LpSolit@gmail.com>
 r=mkanat a=justdave
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

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

diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm
index 5ffb41216..389462263 100644
--- a/Bugzilla/DB/Schema.pm
+++ b/Bugzilla/DB/Schema.pm
@@ -717,7 +717,8 @@ use constant ABSTRACT_SCHEMA => {
             description  => {TYPE => 'TEXT', NOTNULL => 1},
             isbuggroup   => {TYPE => 'BOOLEAN', NOTNULL => 1},
             last_changed => {TYPE => 'DATETIME', NOTNULL => 1},
-            userregexp   => {TYPE => 'TINYTEXT', NOTNULL => 1},
+            userregexp   => {TYPE => 'TINYTEXT', NOTNULL => 1,
+                             DEFAULT => "''"},
             isactive     => {TYPE => 'BOOLEAN', NOTNULL => 1,
                              DEFAULT => 'TRUE'},
         ],
diff --git a/checksetup.pl b/checksetup.pl
index 84c94f108..16edfae3d 100755
--- a/checksetup.pl
+++ b/checksetup.pl
@@ -4059,6 +4059,11 @@ $dbh->bz_add_column('attachments', 'isurl',
 $dbh->bz_add_column('namedqueries', 'query_type',
                     {TYPE => 'BOOLEAN', NOTNULL => 1, DEFAULT => 0});
 
+# 2005-11-04 LpSolit@gmail.com - Bug 305927
+$dbh->bz_alter_column('groups', 'userregexp', 
+                      {TYPE => 'TINYTEXT', 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