summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authormkanat%kerio.com <>2005-08-18 03:24:44 +0200
committermkanat%kerio.com <>2005-08-18 03:24:44 +0200
commitd11ebe02d5e293f88992090878db4c95523f1809 (patch)
tree7ba47b9a9bcf60a9598f3529acfda3f072febf68
parentd8000a5968b530e499bae2006d62e9300d8e8491 (diff)
downloadbugzilla-d11ebe02d5e293f88992090878db4c95523f1809.tar.gz
bugzilla-d11ebe02d5e293f88992090878db4c95523f1809.tar.xz
Bug 296054: [PostgreSQL] Cannot add a new query for event/whining
Patch By Max Kanat-Alexander <mkanat@bugzilla.org> r=LpSolit, a=justdave
-rw-r--r--Bugzilla/DB/Schema.pm3
-rwxr-xr-xchecksetup.pl6
2 files changed, 8 insertions, 1 deletions
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.
#