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 71-76 ticket details Link Here
71
71
72
current status of the ticket
72
current status of the ticket
73
73
74
=head2 assignee_id
75
76
  data_type: 'integer'
77
  is_foreign_key: 1
78
  is_nullable: 1
79
80
id of the user who this ticket is assigned to
81
74
=head2 resolver_id
82
=head2 resolver_id
75
83
76
  data_type: 'integer'
84
  data_type: 'integer'
Lines 120-125 __PACKAGE__->add_columns( Link Here
120
  { data_type => "text", is_nullable => 0 },
128
  { data_type => "text", is_nullable => 0 },
121
  "status",
129
  "status",
122
  { data_type => "varchar", is_nullable => 1, size => 80 },
130
  { data_type => "varchar", is_nullable => 1, size => 80 },
131
  "assignee_id",
132
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
123
  "resolver_id",
133
  "resolver_id",
124
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
134
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
125
  "resolved_date",
135
  "resolved_date",
Lines 146-151 __PACKAGE__->set_primary_key("id"); Link Here
146
156
147
=head1 RELATIONS
157
=head1 RELATIONS
148
158
159
=head2 assignee
160
161
Type: belongs_to
162
163
Related object: L<Koha::Schema::Result::Borrower>
164
165
=cut
166
167
__PACKAGE__->belongs_to(
168
  "assignee",
169
  "Koha::Schema::Result::Borrower",
170
  { borrowernumber => "assignee_id" },
171
  {
172
    is_deferrable => 1,
173
    join_type     => "LEFT",
174
    on_delete     => "CASCADE",
175
    on_update     => "CASCADE",
176
  },
177
);
178
149
=head2 biblio
179
=head2 biblio
150
180
151
Type: belongs_to
181
Type: belongs_to
Lines 217-224 __PACKAGE__->has_many( Link Here
217
);
247
);
218
248
219
249
220
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-12-22 14:51:40
250
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-12-29 11:05:09
221
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:lcKWaA+k/0lw5/6JrFhB1A
251
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:CluP2ZCuByEcC3E0tLoOkA
222
252
223
253
224
# You can replace this text with custom code or comments, and it will be preserved on regeneration
254
# 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