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

(-)a/Koha/Schema/Result/MessageQueue.pm (-2 / +9 lines)
Lines 82-87 __PACKAGE__->table("message_queue"); Link Here
82
  data_type: 'mediumtext'
82
  data_type: 'mediumtext'
83
  is_nullable: 1
83
  is_nullable: 1
84
84
85
=head2 sentto_address
86
87
  data_type: 'mediumtext'
88
  is_nullable: 1
89
85
=head2 from_address
90
=head2 from_address
86
91
87
  data_type: 'mediumtext'
92
  data_type: 'mediumtext'
Lines 125-130 __PACKAGE__->add_columns( Link Here
125
  },
130
  },
126
  "to_address",
131
  "to_address",
127
  { data_type => "mediumtext", is_nullable => 1 },
132
  { data_type => "mediumtext", is_nullable => 1 },
133
  "sentto_address",
134
  { data_type => "mediumtext", is_nullable => 1 },
128
  "from_address",
135
  "from_address",
129
  { data_type => "mediumtext", is_nullable => 1 },
136
  { data_type => "mediumtext", is_nullable => 1 },
130
  "content_type",
137
  "content_type",
Lines 169-176 __PACKAGE__->belongs_to( Link Here
169
);
176
);
170
177
171
178
172
# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21
179
# Created by DBIx::Class::Schema::Loader v0.07025 @ 2014-03-06 22:50:19
173
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:+gmGYPCtwCYKHAzfd9xByQ
180
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:fL7N2f/cS1ff4rsqQGHX9w
174
181
175
182
176
# You can replace this text with custom content, and it will be preserved on regeneration
183
# 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