diff options
| author | mkanat%kerio.com <> | 2005-08-18 03:24:44 +0200 |
|---|---|---|
| committer | mkanat%kerio.com <> | 2005-08-18 03:24:44 +0200 |
| commit | d11ebe02d5e293f88992090878db4c95523f1809 (patch) | |
| tree | 7ba47b9a9bcf60a9598f3529acfda3f072febf68 | |
| parent | d8000a5968b530e499bae2006d62e9300d8e8491 (diff) | |
| download | bugzilla-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.pm | 3 | ||||
| -rwxr-xr-x | checksetup.pl | 6 |
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. # |