From f5d8bcfb3d8634fa6cf399dcf7c613c4295027c4 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Thu, 24 Mar 2022 14:25:43 +0100 Subject: [PATCH] Bug 28786: DBIC schema changes --- 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 d2b5c6015fe..175710d0f5e 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", @@ -1930,8 +1955,8 @@ Composing rels: L -> permission __PACKAGE__->many_to_many("permissions", "user_permissions", "permission"); -# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-03-15 06:51:43 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ozDOfb67H7/GHLI0o4DdyA +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-03-24 10:20:07 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:srYT5wjg7Jhy5CpmDjWv/g __PACKAGE__->has_many( "extended_attributes", diff --git a/Koha/Schema/Result/Deletedborrower.pm b/Koha/Schema/Result/Deletedborrower.pm index f0d7395d8dd..85ce2b707f9 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 @ 2022-03-24 10:20:07 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:JvVxPJOrg5reWvl+gg9Q2A __PACKAGE__->add_columns( '+anonymized' => { is_boolean => 1 }, -- 2.25.1