From 0ebea6d9fac5b7da3844829883ee76707c711061 Mon Sep 17 00:00:00 2001 From: David Lawrence Date: Tue, 27 Sep 2016 04:23:33 +0000 Subject: Bug 1268317 - Add Triage Contact to Components as an Editable Field (DB schema only) --- Bugzilla/DB/Schema.pm | 6 +++++- Bugzilla/Install/DB.pm | 4 ++++ 2 files changed, 9 insertions(+), 1 deletion(-) diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm index 39323bcb1..e115dd555 100644 --- a/Bugzilla/DB/Schema.pm +++ b/Bugzilla/DB/Schema.pm @@ -1433,8 +1433,12 @@ use constant ABSTRACT_SCHEMA => { COLUMN => 'userid', DELETE => 'SET NULL'}}, description => {TYPE => 'MEDIUMTEXT', NOTNULL => 1}, - isactive => {TYPE => 'BOOLEAN', NOTNULL => 1, + isactive => {TYPE => 'BOOLEAN', NOTNULL => 1, DEFAULT => 'TRUE'}, + triage_owner_id => {TYPE => 'INT3', + REFERENCES => {TABLE => 'profiles', + COLUMN => 'userid', + DELETE => 'SET NULL'}}, ], INDEXES => [ components_product_id_idx => {FIELDS => [qw(product_id name)], diff --git a/Bugzilla/Install/DB.pm b/Bugzilla/Install/DB.pm index ca59e778d..387e2468e 100644 --- a/Bugzilla/Install/DB.pm +++ b/Bugzilla/Install/DB.pm @@ -753,6 +753,10 @@ sub update_table_definitions { _migrate_preference_categories(); + # 2016-09-01 dkl@mozilla.com - Bug 1268317 + $dbh->bz_add_column('components', 'triage_owner_id', + {TYPE => 'INT3'}); + ################################################################ # New --TABLE-- changes should go *** A B O V E *** this point # ################################################################ -- cgit v1.2.3-24-g4f1b