Attachment 129565 Details for Bug 28786 – Bug 28786: DO NOT PUSH - DBIx schema changes

[patch] Bug 28786: DO NOT PUSH - DBIx schema changes

Bug-28786-DO-NOT-PUSH---DBIx-schema-changes.patch (text/plain), 3.53 KB, created by Marcel de Rooy on 2022-01-18 12:57:58 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Marcel de Rooy

Created: 2022-01-18 12:57:58 UTC

Size: 3.53 KB

patch

obsolete

>From f92a8a9541166f2788e55814af8c264257a03c8d Mon Sep 17 00:00:00 2001
>From: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
>Date: Tue, 21 Dec 2021 14:55:28 +0000
>Subject: [PATCH] Bug 28786: DO NOT PUSH - DBIx schema changes
>Content-Type: text/plain; charset=utf-8
>
>Added for testing purposes.
>
>Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
>---
> 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 d4c13f1f3d..42daca002b 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",
>@@ -1905,8 +1930,8 @@ Composing rels: L</aqorder_users> -> ordernumber
> __PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");
> 
> 
>-# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-09-20 12:00:15
>-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:9g9WsdsdPINi2NP4H2A+CA
>+# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-12-21 14:55:00
>+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:gmBr6bg1ATR4OGvh53768Q
> 
> __PACKAGE__->add_columns(
>     '+anonymized'    => { is_boolean => 1 },
>diff --git a/Koha/Schema/Result/Deletedborrower.pm b/Koha/Schema/Result/Deletedborrower.pm
>index f0d7395d8d..106dc95a43 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-12-21 14:55:00
>+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:V5wizufHpsIz4qEBvhwfFw
> 
> __PACKAGE__->add_columns(
>     '+anonymized'    => { is_boolean => 1 },
>-- 
>2.20.1

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