From 51bb0240866b63bb278974f1ee7bfe1b32dafb1e Mon Sep 17 00:00:00 2001 From: "mkanat%kerio.com" <> Date: Wed, 27 Apr 2005 18:08:54 +0000 Subject: Bug 286695: bugs.resolution needs a default value Patch By Tomas Kopal r=mkanat, a=justdave --- Bugzilla/DB/Schema.pm | 3 ++- checksetup.pl | 3 ++- 2 files changed, 4 insertions(+), 2 deletions(-) diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm index a58c20ade..19357b888 100644 --- a/Bugzilla/DB/Schema.pm +++ b/Bugzilla/DB/Schema.pm @@ -165,7 +165,8 @@ use constant ABSTRACT_SCHEMA => { reporter => {TYPE => 'INT3', NOTNULL => 1}, version => {TYPE => 'varchar(64)', NOTNULL => 1}, component_id => {TYPE => 'INT2', NOTNULL => 1}, - resolution => {TYPE => 'varchar(64)', NOTNULL => 1}, + resolution => {TYPE => 'varchar(64)', + NOTNULL => 1, DEFAULT => "''"}, target_milestone => {TYPE => 'varchar(20)', NOTNULL => 1, DEFAULT => "'---'"}, qa_contact => {TYPE => 'INT3'}, diff --git a/checksetup.pl b/checksetup.pl index 8349713e9..09e8dc4ba 100755 --- a/checksetup.pl +++ b/checksetup.pl @@ -3606,8 +3606,9 @@ if (!$dbh->bz_column_info('longdescs', 'already_wrapped')) { # standard varchars in the bugs table. $dbh->bz_alter_column('bugs', 'bug_status', {TYPE => 'varchar(64)', NOTNULL => 1}); +# 2005-03-23 Tomas.Kopal@altap.cz - add default value to resolution, bug 286695 $dbh->bz_alter_column('bugs', 'resolution', - {TYPE => 'varchar(64)', NOTNULL => 1}); + {TYPE => 'varchar(64)', NOTNULL => 1, DEFAULT => "''"}); $dbh->bz_alter_column('bugs', 'priority', {TYPE => 'varchar(64)', NOTNULL => 1}); $dbh->bz_alter_column('bugs', 'bug_severity', -- cgit v1.2.3-24-g4f1b