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

(-)a/Koha/Schema/Result/ItemMessage.pm (+111 lines)
Line 0 Link Here
1
use utf8;
2
package Koha::Schema::Result::ItemMessage;
3
4
# Created by DBIx::Class::Schema::Loader
5
# DO NOT MODIFY THE FIRST PART OF THIS FILE
6
7
=head1 NAME
8
9
Koha::Schema::Result::ItemMessage
10
11
=cut
12
13
use strict;
14
use warnings;
15
16
use base 'DBIx::Class::Core';
17
18
=head1 TABLE: C<item_messages>
19
20
=cut
21
22
__PACKAGE__->table("item_messages");
23
24
=head1 ACCESSORS
25
26
=head2 item_message_id
27
28
  data_type: 'integer'
29
  is_auto_increment: 1
30
  is_nullable: 0
31
32
=head2 itemnumber
33
34
  data_type: 'integer'
35
  is_foreign_key: 1
36
  is_nullable: 0
37
38
=head2 type
39
40
  data_type: 'varchar'
41
  is_nullable: 1
42
  size: 80
43
44
=head2 message
45
46
  data_type: 'text'
47
  is_nullable: 0
48
49
=head2 created_on
50
51
  data_type: 'timestamp'
52
  datetime_undef_if_invalid: 1
53
  default_value: current_timestamp
54
  is_nullable: 0
55
56
=cut
57
58
__PACKAGE__->add_columns(
59
  "item_message_id",
60
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
61
  "itemnumber",
62
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
63
  "type",
64
  { data_type => "varchar", is_nullable => 1, size => 80 },
65
  "message",
66
  { data_type => "text", is_nullable => 0 },
67
  "created_on",
68
  {
69
    data_type => "timestamp",
70
    datetime_undef_if_invalid => 1,
71
    default_value => \"current_timestamp",
72
    is_nullable => 0,
73
  },
74
);
75
76
=head1 PRIMARY KEY
77
78
=over 4
79
80
=item * L</item_message_id>
81
82
=back
83
84
=cut
85
86
__PACKAGE__->set_primary_key("item_message_id");
87
88
=head1 RELATIONS
89
90
=head2 itemnumber
91
92
Type: belongs_to
93
94
Related object: L<Koha::Schema::Result::Item>
95
96
=cut
97
98
__PACKAGE__->belongs_to(
99
  "itemnumber",
100
  "Koha::Schema::Result::Item",
101
  { itemnumber => "itemnumber" },
102
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
103
);
104
105
106
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-03-03 14:03:01
107
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:uoirWwh61T/8Y4XqgQoa1w
108
109
110
# You can replace this text with custom code or comments, and it will be preserved on regeneration
111
1;
(-)a/installer/data/mysql/atomicupdate/bug_17361.perl (+17 lines)
Line 0 Link Here
1
$DBversion = "XXX";
2
if ( CheckVersion($DBversion) ) {
3
    $dbh->do(q{
4
        CREATE TABLE `item_messages` (
5
            `item_message_id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY,
6
            `itemnumber` INT( 11 ) NOT NULL,
7
            `type` VARCHAR( 80 ) NULL, -- ITEM_MESSAGE authorised value
8
            `message` TEXT NOT NULL,
9
            `created_on` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
10
            INDEX (  `itemnumber` ),
11
            CONSTRAINT `message_item_fk` FOREIGN KEY (itemnumber) REFERENCES items (itemnumber) ON DELETE CASCADE ON UPDATE CASCADE
12
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
13
    });
14
15
    print "Upgrade to $DBversion done (Bug 17361: Give librarians the ability to add messages to an item)\n";
16
    SetVersion ($DBversion);
17
}
(-)a/installer/data/mysql/kohastructure.sql (-1 / +14 lines)
Lines 3955-3960 CREATE TABLE deletedbiblio_metadata ( Link Here
3955
    CONSTRAINT `deletedrecord_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES deletedbiblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE
3955
    CONSTRAINT `deletedrecord_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES deletedbiblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE
3956
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3956
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3957
3957
3958
--
3959
-- Table structure for table `item_messages`
3960
--
3961
3962
CREATE TABLE `item_messages` (
3963
    `item_message_id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY,
3964
    `itemnumber` INT( 11 ) NOT NULL,
3965
    `type` VARCHAR( 80 ) NULL, -- ITEM_MESSAGE authorised value
3966
    `message` TEXT NOT NULL,
3967
    `created_on` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
3968
    INDEX (  `itemnumber` ),
3969
    CONSTRAINT `message_item_fk` FOREIGN KEY (itemnumber) REFERENCES items (itemnumber) ON DELETE CASCADE ON UPDATE CASCADE
3970
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3971
3958
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3972
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3959
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3973
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3960
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
3974
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
3961
- 

Return to bug 17361