Attachment #132157 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("permissions", "user_permissions", "permission");


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





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 @ 2022-03-24 10:20:07
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:JvVxPJOrg5reWvl+gg9Q2A

__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 1930-1937 Composing rels: L</user_permissions> -> permission Link Here
1930	__PACKAGE__->many_to_many("permissions", "user_permissions", "permission");	1955	__PACKAGE__->many_to_many("permissions", "user_permissions", "permission");
1931		1956
1932		1957
1933	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-03-15 06:51:43	1958	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-03-24 10:20:07
1934	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ozDOfb67H7/GHLI0o4DdyA	1959	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:srYT5wjg7Jhy5CpmDjWv/g
1935		1960
1936	__PACKAGE__->has_many(	1961	__PACKAGE__->has_many(
1937	"extended_attributes",	1962	"extended_attributes",

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 @ 2022-03-24 10:20:07
789	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:9q8LmKrfO6bAAFaJ4Z3Jrg	814	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:JvVxPJOrg5reWvl+gg9Q2A
790		815
791	__PACKAGE__->add_columns(	816	__PACKAGE__->add_columns(
792	'+anonymized' => { is_boolean => 1 },	817	'+anonymized' => { is_boolean => 1 },
793	-