Attachment #133072 for bug #9525

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




  is_auto_increment: 1
  is_nullable: 0

unique id for each group

=head2 parent_id

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

if this is a child group, the id of the parent group

=head2 branchcode

  data_type: 'varchar'

  is_nullable: 1
  size: 10

The branchcode of a branch belonging to the parent group

=head2 title

  data_type: 'varchar'
  is_nullable: 1
  size: 100

Short description of the goup

=head2 description

  data_type: 'mediumtext'
  is_nullable: 1

Longer explanation of the group, if necessary

=head2 ft_hide_patron_info

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

Turn on the feature 'Hide patron's info' for this group

=head2 ft_search_groups_opac

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

Use this group for staff side search groups

=head2 ft_search_groups_staff

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

Use this group for opac side search groups

=head2 ft_local_hold_group

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

=head2 ft_local_float_group

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

=head2 created_on


  datetime_undef_if_invalid: 1
  is_nullable: 1

Date and time of creation

=head2 updated_on

  data_type: 'timestamp'

  default_value: current_timestamp
  is_nullable: 0

Date and time of last

=cut

__PACKAGE__->add_columns(

  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
  "ft_local_hold_group",
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
  "ft_local_float_group",
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
  "created_on",
  {
    data_type => "timestamp",

);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-09-07 09:36:34
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:KODdfRcMd+9BxbebV11q1Q

sub koha_object_class {
    'Koha::Library::Group';
- 

Return to bug 9525

Lines 29-44 __PACKAGE__->table("library_groups"); Link Here

(-)a/Koha/Schema/Result/LibraryGroup.pm (-24 / +9 lines)
29	is_auto_increment: 1	29	is_auto_increment: 1
30	is_nullable: 0	30	is_nullable: 0
31		31
32	unique id for each group
33
34	=head2 parent_id	32	=head2 parent_id
35		33
36	data_type: 'integer'	34	data_type: 'integer'
37	is_foreign_key: 1	35	is_foreign_key: 1
38	is_nullable: 1	36	is_nullable: 1
39		37
40	if this is a child group, the id of the parent group
41
42	=head2 branchcode	38	=head2 branchcode
43		39
44	data_type: 'varchar'	40	data_type: 'varchar'
Lines 46-99 if this is a child group, the id of the parent group Link Here
46	is_nullable: 1	42	is_nullable: 1
47	size: 10	43	size: 10
48		44
49	The branchcode of a branch belonging to the parent group
50
51	=head2 title	45	=head2 title
52		46
53	data_type: 'varchar'	47	data_type: 'varchar'
54	is_nullable: 1	48	is_nullable: 1
55	size: 100	49	size: 100
56		50
57	Short description of the goup
58
59	=head2 description	51	=head2 description
60		52
61	data_type: 'mediumtext'	53	data_type: 'mediumtext'
62	is_nullable: 1	54	is_nullable: 1
63		55
64	Longer explanation of the group, if necessary
65
66	=head2 ft_hide_patron_info	56	=head2 ft_hide_patron_info
67		57
68	data_type: 'tinyint'	58	data_type: 'tinyint'
69	default_value: 0	59	default_value: 0
70	is_nullable: 0	60	is_nullable: 0
71		61
72	Turn on the feature 'Hide patron's info' for this group
73
74	=head2 ft_search_groups_opac	62	=head2 ft_search_groups_opac
75		63
76	data_type: 'tinyint'	64	data_type: 'tinyint'
77	default_value: 0	65	default_value: 0
78	is_nullable: 0	66	is_nullable: 0
79		67
80	Use this group for staff side search groups
81
82	=head2 ft_search_groups_staff	68	=head2 ft_search_groups_staff
83		69
84	data_type: 'tinyint'	70	data_type: 'tinyint'
85	default_value: 0	71	default_value: 0
86	is_nullable: 0	72	is_nullable: 0
87		73
88	Use this group for opac side search groups
89
90	=head2 ft_local_hold_group	74	=head2 ft_local_hold_group
91		75
92	data_type: 'tinyint'	76	data_type: 'tinyint'
93	default_value: 0	77	default_value: 0
94	is_nullable: 0	78	is_nullable: 0
95		79
96	Use this group to identify libraries as pick up location for holds	80	=head2 ft_local_float_group
		81
		82	data_type: 'tinyint'
		83	default_value: 0
		84	is_nullable: 0
97		85
98	=head2 created_on	86	=head2 created_on
99		87
Lines 101-108 Use this group to identify libraries as pick up location for holds Link Here
101	datetime_undef_if_invalid: 1	89	datetime_undef_if_invalid: 1
102	is_nullable: 1	90	is_nullable: 1
103		91
104	Date and time of creation
105
106	=head2 updated_on	92	=head2 updated_on
107		93
108	data_type: 'timestamp'	94	data_type: 'timestamp'
Lines 110-117 Date and time of creation Link Here
110	default_value: current_timestamp	96	default_value: current_timestamp
111	is_nullable: 0	97	is_nullable: 0
112		98
113	Date and time of last
114
115	=cut	99	=cut
116		100
117	__PACKAGE__->add_columns(	101	__PACKAGE__->add_columns(
Lines 133-138 __PACKAGE__->add_columns( Link Here
133	{ data_type => "tinyint", default_value => 0, is_nullable => 0 },	117	{ data_type => "tinyint", default_value => 0, is_nullable => 0 },
134	"ft_local_hold_group",	118	"ft_local_hold_group",
135	{ data_type => "tinyint", default_value => 0, is_nullable => 0 },	119	{ data_type => "tinyint", default_value => 0, is_nullable => 0 },
		120	"ft_local_float_group",
		121	{ data_type => "tinyint", default_value => 0, is_nullable => 0 },
136	"created_on",	122	"created_on",
137	{	123	{
138	data_type => "timestamp",	124	data_type => "timestamp",
Lines 246-253 __PACKAGE__->belongs_to( Link Here
246	);	232	);
247		233
248		234
249	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29	235	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-09-07 09:36:34
250	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:WOqjMuJNt1Sh2FUvt3NGxA	236	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:KODdfRcMd+9BxbebV11q1Q
251		237
252	sub koha_object_class {	238	sub koha_object_class {
253	'Koha::Library::Group';	239	'Koha::Library::Group';
254	-