From e51423d1d5b062e66df12840ab600b07665515c8 Mon Sep 17 00:00:00 2001
From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Date: Thu, 29 Jul 2021 16:12:02 +0200
Subject: [PATCH] Bug 28786: DBIC schema changes

Sponsored-by: Orex Digital
---
 Koha/Schema/Result/Borrower.pm        | 29 +++++++++++++++++++++++++--
 Koha/Schema/Result/Deletedborrower.pm | 29 +++++++++++++++++++++++++--
 2 files changed, 54 insertions(+), 4 deletions(-)

diff --git a/Koha/Schema/Result/Borrower.pm b/Koha/Schema/Result/Borrower.pm
index 68abbc11aae..12a0f800313 100644
--- a/Koha/Schema/Result/Borrower.pm
+++ b/Koha/Schema/Result/Borrower.pm
@@ -386,6 +386,22 @@ patron/borrower's gender
 
 patron/borrower's Bcrypt encrypted password
 
+=head2 secret
+
+  data_type: 'mediumtext'
+  is_nullable: 1
+
+Secret for 2FA
+
+=head2 auth_method
+
+  data_type: 'enum'
+  default_value: 'password'
+  extra: {list => ["password","two-factor"]}
+  is_nullable: 0
+
+Authentication method
+
 =head2 flags
 
   data_type: 'integer'
@@ -720,6 +736,15 @@ __PACKAGE__->add_columns(
   { data_type => "varchar", is_nullable => 1, size => 1 },
   "password",
   { data_type => "varchar", is_nullable => 1, size => 60 },
+  "secret",
+  { data_type => "mediumtext", is_nullable => 1 },
+  "auth_method",
+  {
+    data_type => "enum",
+    default_value => "password",
+    extra => { list => ["password", "two-factor"] },
+    is_nullable => 0,
+  },
   "flags",
   { data_type => "integer", is_nullable => 1 },
   "userid",
@@ -1875,8 +1900,8 @@ Composing rels: L</aqorder_users> -> ordernumber
 __PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");
 
 
-# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-07-12 13:40:00
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:IKPb4912o8oCHtmFAi6FPQ
+# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-07-29 14:11:53
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:mG8Tg7EtHXrq5OvB99yViw
 
 __PACKAGE__->add_columns(
     '+anonymized'    => { is_boolean => 1 },
diff --git a/Koha/Schema/Result/Deletedborrower.pm b/Koha/Schema/Result/Deletedborrower.pm
index f0d7395d8dd..4145e50cf31 100644
--- a/Koha/Schema/Result/Deletedborrower.pm
+++ b/Koha/Schema/Result/Deletedborrower.pm
@@ -384,6 +384,22 @@ patron/borrower's gender
 
 patron/borrower's encrypted password
 
+=head2 secret
+
+  data_type: 'mediumtext'
+  is_nullable: 1
+
+Secret for 2FA
+
+=head2 auth_method
+
+  data_type: 'enum'
+  default_value: 'password'
+  extra: {list => ["password","two-factor"]}
+  is_nullable: 0
+
+Authentication method
+
 =head2 flags
 
   data_type: 'integer'
@@ -705,6 +721,15 @@ __PACKAGE__->add_columns(
   { data_type => "varchar", is_nullable => 1, size => 1 },
   "password",
   { data_type => "varchar", is_nullable => 1, size => 60 },
+  "secret",
+  { data_type => "mediumtext", is_nullable => 1 },
+  "auth_method",
+  {
+    data_type => "enum",
+    default_value => "password",
+    extra => { list => ["password", "two-factor"] },
+    is_nullable => 0,
+  },
   "flags",
   { data_type => "integer", is_nullable => 1 },
   "userid",
@@ -785,8 +810,8 @@ __PACKAGE__->add_columns(
 );
 
 
-# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-07-12 13:40:00
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:9q8LmKrfO6bAAFaJ4Z3Jrg
+# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-07-30 13:25:12
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:YgrYInf6JJRqHb91jXre/A
 
 __PACKAGE__->add_columns(
     '+anonymized'    => { is_boolean => 1 },
-- 
2.20.1