From 25f18d11caa537430ee85adfe6d9e55920fda812 Mon Sep 17 00:00:00 2001
From: Dylan William Hardison <dylan@hardison.net>
Date: Fri, 5 Apr 2019 14:55:26 -0400
Subject: [PATCH] Bug 1541555 - Schema only

---
 Bugzilla/DB/Schema.pm  | 1 +
 Bugzilla/Install/DB.pm | 3 +++
 2 files changed, 4 insertions(+)

diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm
index 7304f7c66..5ecc186cf 100644
--- a/Bugzilla/DB/Schema.pm
+++ b/Bugzilla/DB/Schema.pm
@@ -1787,6 +1787,7 @@ use constant ABSTRACT_SCHEMA => {
       last_used    => {TYPE => 'DATETIME'},
       last_used_ip => {TYPE => 'varchar(40)'},
       app_id       => {TYPE => 'varchar(64)'},
+      sticky       => {TYPE => 'BOOLEAN', NOTNULL => 1, DEFAULT => 'FALSE'}
     ],
     INDEXES => [
       user_api_keys_api_key_idx        => {FIELDS => ['api_key'], TYPE => 'UNIQUE'},
diff --git a/Bugzilla/Install/DB.pm b/Bugzilla/Install/DB.pm
index 216e47bd3..a62fa5eb6 100644
--- a/Bugzilla/Install/DB.pm
+++ b/Bugzilla/Install/DB.pm
@@ -726,6 +726,9 @@ sub update_table_definitions {
   $dbh->bz_add_index('user_api_keys', 'user_api_keys_user_id_app_id_idx',
     [qw(user_id app_id)]);
 
+  $dbh->bz_add_column('user_api_keys', 'sticky',
+    {TYPE => 'BOOLEAN', NOTNULL => 1, DEFAULT => 'FALSE'});
+
   _add_attach_size();
 
   _fix_disable_mail();
-- 
2.47.3