From e51423d1d5b062e66df12840ab600b07665515c8 Mon Sep 17 00:00:00 2001 From: Jonathan Druart 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 -> 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