summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorlpsolit%gmail.com <>2005-11-05 21:15:57 +0100
committerlpsolit%gmail.com <>2005-11-05 21:15:57 +0100
commit07e4290192060ff9b30b03b60155396603a00547 (patch)
tree0ab424d046c1ab0776ec169deb77d901f17bc602
parent1afe548f9e830bcace4e06d3441bdd4b41c8d11a (diff)
downloadbugzilla-07e4290192060ff9b30b03b60155396603a00547.tar.gz
bugzilla-07e4290192060ff9b30b03b60155396603a00547.tar.xz
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
-rw-r--r--Bugzilla/DB/Schema.pm3
-rwxr-xr-xchecksetup.pl5
2 files changed, 7 insertions, 1 deletions
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.
#