Attachment #123403 for bug #28786

View | Details | Raw Unified | Return to bug 28786
Collapse All | Expand All





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'

  { 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",

__PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");


# 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 },





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'

  { 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",

);


# 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 },
- 

Return to bug 28786

Lines 386-391 patron/borrower's gender Link Here

(-)a/Koha/Schema/Result/Borrower.pm (-2 / +27 lines)
386		386
387	patron/borrower's Bcrypt encrypted password	387	patron/borrower's Bcrypt encrypted password
388		388
		389	=head2 secret
		390
		391	data_type: 'mediumtext'
		392	is_nullable: 1
		393
		394	Secret for 2FA
		395
		396	=head2 auth_method
		397
		398	data_type: 'enum'
		399	default_value: 'password'
		400	extra: {list => ["password","two-factor"]}
		401	is_nullable: 0
		402
		403	Authentication method
		404
389	=head2 flags	405	=head2 flags
390		406
391	data_type: 'integer'	407	data_type: 'integer'
Lines 720-725 __PACKAGE__->add_columns( Link Here
720	{ data_type => "varchar", is_nullable => 1, size => 1 },	736	{ data_type => "varchar", is_nullable => 1, size => 1 },
721	"password",	737	"password",
722	{ data_type => "varchar", is_nullable => 1, size => 60 },	738	{ data_type => "varchar", is_nullable => 1, size => 60 },
		739	"secret",
		740	{ data_type => "mediumtext", is_nullable => 1 },
		741	"auth_method",
		742	{
		743	data_type => "enum",
		744	default_value => "password",
		745	extra => { list => ["password", "two-factor"] },
		746	is_nullable => 0,
		747	},
723	"flags",	748	"flags",
724	{ data_type => "integer", is_nullable => 1 },	749	{ data_type => "integer", is_nullable => 1 },
725	"userid",	750	"userid",
Lines 1875-1882 Composing rels: L</aqorder_users> -> ordernumber Link Here
1875	__PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");	1900	__PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");
1876		1901
1877		1902
1878	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-07-12 13:40:00	1903	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-07-29 14:11:53
1879	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:IKPb4912o8oCHtmFAi6FPQ	1904	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:mG8Tg7EtHXrq5OvB99yViw
1880		1905
1881	__PACKAGE__->add_columns(	1906	__PACKAGE__->add_columns(
1882	'+anonymized' => { is_boolean => 1 },	1907	'+anonymized' => { is_boolean => 1 },

Lines 384-389 patron/borrower's gender Link Here

(-)a/Koha/Schema/Result/Deletedborrower.pm (-3 / +27 lines)
384		384
385	patron/borrower's encrypted password	385	patron/borrower's encrypted password
386		386
		387	=head2 secret
		388
		389	data_type: 'mediumtext'
		390	is_nullable: 1
		391
		392	Secret for 2FA
		393
		394	=head2 auth_method
		395
		396	data_type: 'enum'
		397	default_value: 'password'
		398	extra: {list => ["password","two-factor"]}
		399	is_nullable: 0
		400
		401	Authentication method
		402
387	=head2 flags	403	=head2 flags
388		404
389	data_type: 'integer'	405	data_type: 'integer'
Lines 705-710 __PACKAGE__->add_columns( Link Here
705	{ data_type => "varchar", is_nullable => 1, size => 1 },	721	{ data_type => "varchar", is_nullable => 1, size => 1 },
706	"password",	722	"password",
707	{ data_type => "varchar", is_nullable => 1, size => 60 },	723	{ data_type => "varchar", is_nullable => 1, size => 60 },
		724	"secret",
		725	{ data_type => "mediumtext", is_nullable => 1 },
		726	"auth_method",
		727	{
		728	data_type => "enum",
		729	default_value => "password",
		730	extra => { list => ["password", "two-factor"] },
		731	is_nullable => 0,
		732	},
708	"flags",	733	"flags",
709	{ data_type => "integer", is_nullable => 1 },	734	{ data_type => "integer", is_nullable => 1 },
710	"userid",	735	"userid",
Lines 785-792 __PACKAGE__->add_columns( Link Here
785	);	810	);
786		811
787		812
788	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-07-12 13:40:00	813	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-07-30 13:25:12
789	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:9q8LmKrfO6bAAFaJ4Z3Jrg	814	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:YgrYInf6JJRqHb91jXre/A
790		815
791	__PACKAGE__->add_columns(	816	__PACKAGE__->add_columns(
792	'+anonymized' => { is_boolean => 1 },	817	'+anonymized' => { is_boolean => 1 },
793	-