From 59f96419500ae8c1b87b06abb0a5cca9f165b030 Mon Sep 17 00:00:00 2001
From: Byron Jones <glob@mozilla.com>
Date: Tue, 25 Aug 2015 02:03:36 +0800
Subject: Bug 1196134 - add ability for admins to force a user to change their
 password on next login (schema only)

---
 Bugzilla/DB/Schema.pm  | 2 ++
 Bugzilla/Install/DB.pm | 5 +++++
 2 files changed, 7 insertions(+)

diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm
index 49ee0ff96..a9dfa6d8e 100644
--- a/Bugzilla/DB/Schema.pm
+++ b/Bugzilla/DB/Schema.pm
@@ -950,6 +950,8 @@ use constant ABSTRACT_SCHEMA => {
             is_enabled     => {TYPE => 'BOOLEAN', NOTNULL => 1, 
                                DEFAULT => 'TRUE'}, 
             last_seen_date => {TYPE => 'DATETIME'},
+            password_change_required => { TYPE => 'BOOLEAN', NOTNULL => 1, DEFAULT => 'FALSE' },
+            password_change_reason   => { TYPE => 'varchar(64)' },
         ],
         INDEXES => [
             profiles_login_name_idx => {FIELDS => ['login_name'],
diff --git a/Bugzilla/Install/DB.pm b/Bugzilla/Install/DB.pm
index 5b8cc3992..9a329d355 100644
--- a/Bugzilla/Install/DB.pm
+++ b/Bugzilla/Install/DB.pm
@@ -747,6 +747,11 @@ sub update_table_definitions {
 
     _add_restrict_ipaddr();
 
+    $dbh->bz_add_column('profiles', 'password_change_required',
+                        { TYPE => 'BOOLEAN', NOTNULL => 1, DEFAULT => 'FALSE' });
+    $dbh->bz_add_column('profiles', 'password_change_reason',
+                        { TYPE => 'varchar(64)' });
+
     ################################################################
     # New --TABLE-- changes should go *** A B O V E *** this point #
     ################################################################
-- 
cgit v1.2.3-24-g4f1b