Attachment #131958 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-21 09:55:08
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:S06iXy+eYMq2qEkE4MhK4Q

__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-21 09:55:08
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:JG+WuQbfSB830wRDlncB0A

__PACKAGE__->add_columns(
    '+anonymized'    => { is_boolean => 1 },




  extra: {list => ["requested","overdue","waiting","in_transit","cancelled","expired","fulfilled"]}
  is_nullable: 1

Request status

=head2 timestamp

  data_type: 'timestamp'


  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

=head2 item_level_recall


    is_nullable => 1,
  },
  "old",
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
  "item_level_recall",
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
);

);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-03-21 09:55:08
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:E3qCbGM+iyoUMfJnzZ4C9w

__PACKAGE__->add_columns(
    '+old' => { 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-21 09:55:08
1934	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ozDOfb67H7/GHLI0o4DdyA	1959	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:S06iXy+eYMq2qEkE4MhK4Q
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 (-2 / +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-21 09:55:08
789	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:9q8LmKrfO6bAAFaJ4Z3Jrg	814	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:JG+WuQbfSB830wRDlncB0A
790		815
791	__PACKAGE__->add_columns(	816	__PACKAGE__->add_columns(
792	'+anonymized' => { is_boolean => 1 },	817	'+anonymized' => { is_boolean => 1 },

Lines 79-86 __PACKAGE__->table("recalls"); Link Here

(-)a/Koha/Schema/Result/Recall.pm (-7 / +4 lines)
79	extra: {list => ["requested","overdue","waiting","in_transit","cancelled","expired","fulfilled"]}	79	extra: {list => ["requested","overdue","waiting","in_transit","cancelled","expired","fulfilled"]}
80	is_nullable: 1	80	is_nullable: 1
81		81
82	Request status
83
84	=head2 timestamp	82	=head2 timestamp
85		83
86	data_type: 'timestamp'	84	data_type: 'timestamp'
Lines 110-116 Request status Link Here
110		108
111	data_type: 'tinyint'	109	data_type: 'tinyint'
112	default_value: 0	110	default_value: 0
113	is_nullable: 1	111	is_nullable: 0
114		112
115	=head2 item_level_recall	113	=head2 item_level_recall
116		114
Lines 194-200 __PACKAGE__->add_columns( Link Here
194	is_nullable => 1,	192	is_nullable => 1,
195	},	193	},
196	"old",	194	"old",
197	{ data_type => "tinyint", default_value => 0, is_nullable => 1 },	195	{ data_type => "tinyint", default_value => 0, is_nullable => 0 },
198	"item_level_recall",	196	"item_level_recall",
199	{ data_type => "tinyint", default_value => 0, is_nullable => 0 },	197	{ data_type => "tinyint", default_value => 0, is_nullable => 0 },
200	);	198	);
Lines 284-291 __PACKAGE__->belongs_to( Link Here
284	);	282	);
285		283
286		284
287	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-03-15 06:51:43	285	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-03-21 09:55:08
288	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:nG6sAMWzjgfD+r6aUsITzA	286	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:E3qCbGM+iyoUMfJnzZ4C9w
289		287
290	__PACKAGE__->add_columns(	288	__PACKAGE__->add_columns(
291	'+old' => { is_boolean => 1 },	289	'+old' => { is_boolean => 1 },
292	-