diff options
| author | Frédéric Buclin <LpSolit@gmail.com> | 2010-10-14 01:11:07 +0200 |
|---|---|---|
| committer | Frédéric Buclin <LpSolit@gmail.com> | 2010-10-14 01:11:07 +0200 |
| commit | f0f0bc84ed98afaf3fc912911ca020d9e651ba11 (patch) | |
| tree | a56cee4da5503d6bbf496608adc3e4c2435c2faa | |
| parent | 3854512a831ffc27ed1b2c0b6aacce4746470a0a (diff) | |
| download | bugzilla-f0f0bc84ed98afaf3fc912911ca020d9e651ba11.tar.gz bugzilla-f0f0bc84ed98afaf3fc912911ca020d9e651ba11.tar.xz | |
Bug 505165: The flags.setter_id DB column cannot be NULL
r/a=mkanat
| -rw-r--r-- | Bugzilla/DB/Schema.pm | 2 | ||||
| -rw-r--r-- | Bugzilla/Install/DB.pm | 3 |
2 files changed, 4 insertions, 1 deletions
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 # ################################################################ |