diff options
| author | mkanat%kerio.com <> | 2005-04-27 20:08:54 +0200 |
|---|---|---|
| committer | mkanat%kerio.com <> | 2005-04-27 20:08:54 +0200 |
| commit | 51bb0240866b63bb278974f1ee7bfe1b32dafb1e (patch) | |
| tree | 50cc297ed74b9f9875e69665b5d3413c74df0dfa | |
| parent | ef3ef0d4fd126999677694787f7fc5cac07a46a7 (diff) | |
| download | bugzilla-51bb0240866b63bb278974f1ee7bfe1b32dafb1e.tar.gz bugzilla-51bb0240866b63bb278974f1ee7bfe1b32dafb1e.tar.xz | |
Bug 286695: bugs.resolution needs a default value
Patch By Tomas Kopal <Tomas.Kopal@altap.cz> r=mkanat, a=justdave
| -rw-r--r-- | Bugzilla/DB/Schema.pm | 3 | ||||
| -rwxr-xr-x | 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', |