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

(-)a/Koha/Schema/Result/Borrower.pm (-2 / +32 lines)
Lines 2002-2007 __PACKAGE__->has_many( Link Here
2002
  { cascade_copy => 0, cascade_delete => 0 },
2002
  { cascade_copy => 0, cascade_delete => 0 },
2003
);
2003
);
2004
2004
2005
=head2 ticket_updates_assignees
2006
2007
Type: has_many
2008
2009
Related object: L<Koha::Schema::Result::TicketUpdate>
2010
2011
=cut
2012
2013
__PACKAGE__->has_many(
2014
  "ticket_updates_assignees",
2015
  "Koha::Schema::Result::TicketUpdate",
2016
  { "foreign.assignee_id" => "self.borrowernumber" },
2017
  { cascade_copy => 0, cascade_delete => 0 },
2018
);
2019
2020
=head2 tickets_assignees
2021
2022
Type: has_many
2023
2024
Related object: L<Koha::Schema::Result::Ticket>
2025
2026
=cut
2027
2028
__PACKAGE__->has_many(
2029
  "tickets_assignees",
2030
  "Koha::Schema::Result::Ticket",
2031
  { "foreign.assignee_id" => "self.borrowernumber" },
2032
  { cascade_copy => 0, cascade_delete => 0 },
2033
);
2034
2005
=head2 tickets_reporters
2035
=head2 tickets_reporters
2006
2036
2007
Type: has_many
2037
Type: has_many
Lines 2158-2165 Composing rels: L</user_permissions> -> permission Link Here
2158
__PACKAGE__->many_to_many("permissions", "user_permissions", "permission");
2188
__PACKAGE__->many_to_many("permissions", "user_permissions", "permission");
2159
2189
2160
2190
2161
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-11-03 14:18:06
2191
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-12-29 11:05:09
2162
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:PcGXqEI1ULB+Uoclqfbxig
2192
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:U1id9VAmZO9i6P+D97N0yA
2163
2193
2164
__PACKAGE__->has_many(
2194
__PACKAGE__->has_many(
2165
  "restrictions",
2195
  "restrictions",
(-)a/Koha/Schema/Result/Ticket.pm (-2 / +32 lines)
Lines 80-85 ticket details Link Here
80
80
81
current status of the ticket
81
current status of the ticket
82
82
83
=head2 assignee_id
84
85
  data_type: 'integer'
86
  is_foreign_key: 1
87
  is_nullable: 1
88
89
id of the user who this ticket is assigned to
90
83
=head2 resolver_id
91
=head2 resolver_id
84
92
85
  data_type: 'integer'
93
  data_type: 'integer'
Lines 136-141 __PACKAGE__->add_columns( Link Here
136
  { data_type => "text", is_nullable => 0 },
144
  { data_type => "text", is_nullable => 0 },
137
  "status",
145
  "status",
138
  { data_type => "varchar", is_nullable => 1, size => 80 },
146
  { data_type => "varchar", is_nullable => 1, size => 80 },
147
  "assignee_id",
148
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
139
  "resolver_id",
149
  "resolver_id",
140
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
150
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
141
  "resolved_date",
151
  "resolved_date",
Lines 162-167 __PACKAGE__->set_primary_key("id"); Link Here
162
172
163
=head1 RELATIONS
173
=head1 RELATIONS
164
174
175
=head2 assignee
176
177
Type: belongs_to
178
179
Related object: L<Koha::Schema::Result::Borrower>
180
181
=cut
182
183
__PACKAGE__->belongs_to(
184
  "assignee",
185
  "Koha::Schema::Result::Borrower",
186
  { borrowernumber => "assignee_id" },
187
  {
188
    is_deferrable => 1,
189
    join_type     => "LEFT",
190
    on_delete     => "CASCADE",
191
    on_update     => "CASCADE",
192
  },
193
);
194
165
=head2 biblio
195
=head2 biblio
166
196
167
Type: belongs_to
197
Type: belongs_to
Lines 233-240 __PACKAGE__->has_many( Link Here
233
);
263
);
234
264
235
265
236
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-12-22 14:51:40
266
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-12-29 11:05:09
237
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:lcKWaA+k/0lw5/6JrFhB1A
267
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:CluP2ZCuByEcC3E0tLoOkA
238
268
239
269
240
# You can replace this text with custom code or comments, and it will be preserved on regeneration
270
# You can replace this text with custom code or comments, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/TicketUpdate.pm (-3 / +32 lines)
Lines 48-53 id of catalog ticket the update relates to Link Here
48
48
49
id of the user who logged the update
49
id of the user who logged the update
50
50
51
=head2 assignee_id
52
53
  data_type: 'integer'
54
  is_foreign_key: 1
55
  is_nullable: 1
56
57
id of the user who this ticket was assigned to at this update
58
51
=head2 public
59
=head2 public
52
60
53
  data_type: 'tinyint'
61
  data_type: 'tinyint'
Lines 94-99 __PACKAGE__->add_columns( Link Here
94
    is_foreign_key => 1,
102
    is_foreign_key => 1,
95
    is_nullable    => 0,
103
    is_nullable    => 0,
96
  },
104
  },
105
  "assignee_id",
106
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
97
  "public",
107
  "public",
98
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
108
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
99
  "date",
109
  "date",
Lines 123-128 __PACKAGE__->set_primary_key("id"); Link Here
123
133
124
=head1 RELATIONS
134
=head1 RELATIONS
125
135
136
=head2 assignee
137
138
Type: belongs_to
139
140
Related object: L<Koha::Schema::Result::Borrower>
141
142
=cut
143
144
__PACKAGE__->belongs_to(
145
  "assignee",
146
  "Koha::Schema::Result::Borrower",
147
  { borrowernumber => "assignee_id" },
148
  {
149
    is_deferrable => 1,
150
    join_type     => "LEFT",
151
    on_delete     => "CASCADE",
152
    on_update     => "CASCADE",
153
  },
154
);
155
126
=head2 ticket
156
=head2 ticket
127
157
128
Type: belongs_to
158
Type: belongs_to
Lines 154-161 __PACKAGE__->belongs_to( Link Here
154
);
184
);
155
185
156
186
157
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-12-22 14:51:40
187
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-12-29 11:05:09
158
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:5fRHoeJ8uIAnOmxll7BsnA
188
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:rhHYbmjhy+D3+h4nu3TuPw
159
189
160
__PACKAGE__->add_columns( '+public' => { is_boolean => 1 }, );
190
__PACKAGE__->add_columns( '+public' => { is_boolean => 1 }, );
161
191
162
- 

Return to bug 35657