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

(-)a/Koha/Schema/Result/MessageQueue.pm (-10 / +13 lines)
Lines 1-21 Link Here
1
use utf8;
2
package Koha::Schema::Result::MessageQueue;
1
package Koha::Schema::Result::MessageQueue;
3
2
4
# Created by DBIx::Class::Schema::Loader
3
# Created by DBIx::Class::Schema::Loader
5
# DO NOT MODIFY THE FIRST PART OF THIS FILE
4
# DO NOT MODIFY THE FIRST PART OF THIS FILE
6
5
7
=head1 NAME
8
9
Koha::Schema::Result::MessageQueue
10
11
=cut
12
13
use strict;
6
use strict;
14
use warnings;
7
use warnings;
15
8
16
use base 'DBIx::Class::Core';
9
use base 'DBIx::Class::Core';
17
10
18
=head1 TABLE: C<message_queue>
11
12
=head1 NAME
13
14
Koha::Schema::Result::MessageQueue
19
15
20
=cut
16
=cut
21
17
Lines 82-87 __PACKAGE__->table("message_queue"); Link Here
82
  data_type: 'mediumtext'
78
  data_type: 'mediumtext'
83
  is_nullable: 1
79
  is_nullable: 1
84
80
81
=head2 sentto_address
82
83
  data_type: 'mediumtext'
84
  is_nullable: 1
85
85
=head2 from_address
86
=head2 from_address
86
87
87
  data_type: 'mediumtext'
88
  data_type: 'mediumtext'
Lines 125-130 __PACKAGE__->add_columns( Link Here
125
  },
126
  },
126
  "to_address",
127
  "to_address",
127
  { data_type => "mediumtext", is_nullable => 1 },
128
  { data_type => "mediumtext", is_nullable => 1 },
129
  "sentto_address",
130
  { data_type => "mediumtext", is_nullable => 1 },
128
  "from_address",
131
  "from_address",
129
  { data_type => "mediumtext", is_nullable => 1 },
132
  { data_type => "mediumtext", is_nullable => 1 },
130
  "content_type",
133
  "content_type",
Lines 169-176 __PACKAGE__->belongs_to( Link Here
169
);
172
);
170
173
171
174
172
# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21
175
# Created by DBIx::Class::Schema::Loader v0.07010 @ 2014-03-06 17:18:09
173
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:+gmGYPCtwCYKHAzfd9xByQ
176
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:OaACpykpEpfqrUXXZxNWSQ
174
177
175
178
176
# You can replace this text with custom content, and it will be preserved on regeneration
179
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/installer/data/mysql/kohastructure.sql (+1 lines)
Lines 2524-2529 CREATE TABLE `message_queue` ( Link Here
2524
  `status` enum('sent','pending','failed','deleted') NOT NULL default 'pending',
2524
  `status` enum('sent','pending','failed','deleted') NOT NULL default 'pending',
2525
  `time_queued` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
2525
  `time_queued` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
2526
  `to_address` mediumtext,
2526
  `to_address` mediumtext,
2527
  `sentto_address` mediumtext,
2527
  `from_address` mediumtext,
2528
  `from_address` mediumtext,
2528
  `content_type` text,
2529
  `content_type` text,
2529
  KEY `message_id` (`message_id`),
2530
  KEY `message_id` (`message_id`),
(-)a/installer/data/mysql/updatedatabase.pl (-2 / +2 lines)
Lines 8015-8021 if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { Link Here
8015
$DBversion = "3.15.00.XXX";
8015
$DBversion = "3.15.00.XXX";
8016
if ( CheckVersion($DBversion) ) {
8016
if ( CheckVersion($DBversion) ) {
8017
    $dbh->do("INSERT INTO systempreferences (variable,value,options,explanation,type) VALUES ('SendAllEmailsTo','',NULL,'This email will replace the To address in every message sent by the system.  This is meant to help testing and validation only.','Textarea')");
8017
    $dbh->do("INSERT INTO systempreferences (variable,value,options,explanation,type) VALUES ('SendAllEmailsTo','',NULL,'This email will replace the To address in every message sent by the system.  This is meant to help testing and validation only.','Textarea')");
8018
    print "Upgrade to $DBversion done (Bug 8000 - system preferences to override the destination of every email sent by the system.)\n";
8018
    $dbh->do( qw{ ALTER TABLE message_queue ADD sentto_address mediumtext AFTER to_address } );
8019
    print "Upgrade to $DBversion done (Bug 8000 - add method to override the destination of every email sent by the system.)\n";
8019
    SetVersion ($DBversion);
8020
    SetVersion ($DBversion);
8020
}
8021
}
8021
8022
8022
- 

Return to bug 8000