Bugzilla – Attachment 123403 Details for
Bug 28786
Two-factor authentication for staff client - TOTP
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 28786: DBIC schema changes
Bug-28786-DBIC-schema-changes.patch (text/plain), 3.49 KB, created by
David Nind
on 2021-08-02 19:53:35 UTC
(
hide
)
Description:
Bug 28786: DBIC schema changes
Filename:
MIME Type:
Creator:
David Nind
Created:
2021-08-02 19:53:35 UTC
Size:
3.49 KB
patch
obsolete
>From 3f7c4034bf8950fa8cf4e5dff553c44529bbd214 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 > >Signed-off-by: David Nind <david@davidnind.com> >--- > 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 68abbc11aa..12a0f80031 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 f0d7395d8d..4145e50cf3 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
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 28786
:
123375
|
123376
|
123377
|
123378
|
123379
|
123380
|
123381
|
123397
|
123398
|
123399
|
123400
|
123401
|
123402
|
123403
|
124569
|
124770
|
124771
|
124844
|
124845
|
124846
|
124847
|
128841
|
128842
|
129383
|
129384
|
129474
|
129521
|
129557
|
129558
|
129559
|
129560
|
129561
|
129562
|
129563
|
129564
|
129565
|
129566
|
129567
|
129568
|
129569
|
129654
|
129655
|
129656
|
129657
|
129658
|
129659
|
129660
|
129661
|
129662
|
129665
|
131940
|
131941
|
131942
|
131943
|
131944
|
131945
|
131946
|
131947
|
131948
|
131949
|
131950
|
131951
|
131952
|
131953
|
131954
|
131955
|
131956
|
131957
|
131958
|
132142
|
132143
|
132144
|
132145
|
132146
|
132147
|
132148
|
132149
|
132150
|
132153
|
132154
|
132155
|
132156
|
132157
|
133222
|
133516
|
133522
|
133531
|
133533
|
133541
|
133548
|
133643
|
133686