From f0f0bc84ed98afaf3fc912911ca020d9e651ba11 Mon Sep 17 00:00:00 2001 From: Frédéric Buclin Date: Thu, 14 Oct 2010 01:11:07 +0200 Subject: Bug 505165: The flags.setter_id DB column cannot be NULL r/a=mkanat --- Bugzilla/DB/Schema.pm | 2 +- Bugzilla/Install/DB.pm | 3 +++ 2 files changed, 4 insertions(+), 1 deletion(-) diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm index 356480e3b..c8adde17f 100644 --- a/Bugzilla/DB/Schema.pm +++ b/Bugzilla/DB/Schema.pm @@ -555,7 +555,7 @@ use constant ABSTRACT_SCHEMA => { DELETE => 'CASCADE'}}, creation_date => {TYPE => 'DATETIME', NOTNULL => 1}, modification_date => {TYPE => 'DATETIME'}, - setter_id => {TYPE => 'INT3', + setter_id => {TYPE => 'INT3', NOTNULL => 1, REFERENCES => {TABLE => 'profiles', COLUMN => 'userid'}}, requestee_id => {TYPE => 'INT3', diff --git a/Bugzilla/Install/DB.pm b/Bugzilla/Install/DB.pm index df4ea737e..b6e58b857 100644 --- a/Bugzilla/Install/DB.pm +++ b/Bugzilla/Install/DB.pm @@ -634,6 +634,9 @@ sub update_table_definitions { # 2009-05-07 ghendricks@novell.com - Bug 77193 _add_isactive_to_product_fields(); + # 2010-10-09 LpSolit@gmail.com - Bug 505165 + $dbh->bz_alter_column('flags', 'setter_id', {TYPE => 'INT3', NOTNULL => 1}); + ################################################################ # New --TABLE-- changes should go *** A B O V E *** this point # ################################################################ -- cgit v1.2.3-24-g4f1b