From bdaf609c71b6b75b0a3182f087b3cd3805e5a199 Mon Sep 17 00:00:00 2001 From: Dylan William Hardison Date: Wed, 13 May 2015 14:49:40 -0400 Subject: Backport bug 69267 to BMO (Add the ability to deactivate keywords) - schema only r=glob --- Bugzilla/DB/Schema.pm | 2 ++ Bugzilla/Install/DB.pm | 4 ++++ 2 files changed, 6 insertions(+) diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm index 0f57f5a11..e400879ca 100644 --- a/Bugzilla/DB/Schema.pm +++ b/Bugzilla/DB/Schema.pm @@ -593,6 +593,8 @@ use constant ABSTRACT_SCHEMA => { PRIMARYKEY => 1}, name => {TYPE => 'varchar(64)', NOTNULL => 1}, description => {TYPE => 'MEDIUMTEXT', NOTNULL => 1}, + is_active => {TYPE => 'BOOLEAN', NOTNULL => 1, + DEFAULT => 'TRUE'}, ], INDEXES => [ keyworddefs_name_idx => {FIELDS => ['name'], diff --git a/Bugzilla/Install/DB.pm b/Bugzilla/Install/DB.pm index beac0ae5a..ba08a3537 100644 --- a/Bugzilla/Install/DB.pm +++ b/Bugzilla/Install/DB.pm @@ -721,6 +721,10 @@ sub update_table_definitions { # 2014-10-?? dkl@mozilla.com - Bug 1062940 $dbh->bz_alter_column('bugs', 'alias', { TYPE => 'varchar(40)' }); + # 2015-05-13 dylan@mozilla.com - Bug 1160430 + $dbh->bz_add_column('keyworddefs', 'is_active', + {TYPE => 'BOOLEAN', NOTNULL => 1, DEFAULT => 'TRUE'}); + ################################################################ # New --TABLE-- changes should go *** A B O V E *** this point # ################################################################ -- cgit v1.2.3-24-g4f1b