From 55430d087503640c7637ed8bdfe8765d5653dc85 Mon Sep 17 00:00:00 2001 From: Dave Lawrence Date: Fri, 16 Dec 2011 15:43:21 -0500 Subject: Last Comment Bug 685611 - delta_ts is updated even when no changes are made to bugs created via WebServices r/a=LpSolit --- Bugzilla/DB/Schema.pm | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'Bugzilla/DB/Schema.pm') diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm index 6d9a33ef7..adbbf7b38 100644 --- a/Bugzilla/DB/Schema.pm +++ b/Bugzilla/DB/Schema.pm @@ -255,7 +255,8 @@ use constant ABSTRACT_SCHEMA => { assigned_to => {TYPE => 'INT3', NOTNULL => 1, REFERENCES => {TABLE => 'profiles', COLUMN => 'userid'}}, - bug_file_loc => {TYPE => 'MEDIUMTEXT'}, + bug_file_loc => {TYPE => 'MEDIUMTEXT', + NOTNULL => 1, DEFAULT => "''"}, bug_severity => {TYPE => 'varchar(64)', NOTNULL => 1}, bug_status => {TYPE => 'varchar(64)', NOTNULL => 1}, creation_ts => {TYPE => 'DATETIME'}, -- cgit v1.2.3-24-g4f1b From 17a51b0772e8c6ccd43e46cb78a84122c6364d5f Mon Sep 17 00:00:00 2001 From: Frédéric Buclin Date: Mon, 19 Dec 2011 19:54:21 +0100 Subject: Bug 711925: Update from 4.0 or older to 4.2 or trunk fails when bug_see_also field is populated r=wicked a=LpSolit --- Bugzilla/DB/Schema.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'Bugzilla/DB/Schema.pm') diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm index adbbf7b38..7b7e4ffb6 100644 --- a/Bugzilla/DB/Schema.pm +++ b/Bugzilla/DB/Schema.pm @@ -502,7 +502,7 @@ use constant ABSTRACT_SCHEMA => { COLUMN => 'bug_id', DELETE => 'CASCADE'}}, value => {TYPE => 'varchar(255)', NOTNULL => 1}, - class => {TYPE => 'varchar(255)', NOTNULL => 1}, + class => {TYPE => 'varchar(255)', NOTNULL => 1, DEFAULT => "''"}, ], INDEXES => [ bug_see_also_bug_id_idx => {FIELDS => [qw(bug_id value)], -- cgit v1.2.3-24-g4f1b