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.07039 @ 2014-07-11 09:26:55
179
# Created by DBIx::Class::Schema::Loader v0.07025 @ 2014-03-06 22:50:19
173
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:YWxM2O2W/h34qqIOIpzOtw
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 2574-2579 CREATE TABLE `message_queue` ( Link Here
2574
  `status` enum('sent','pending','failed','deleted') NOT NULL default 'pending',
2574
  `status` enum('sent','pending','failed','deleted') NOT NULL default 'pending',
2575
  `time_queued` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
2575
  `time_queued` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
2576
  `to_address` mediumtext,
2576
  `to_address` mediumtext,
2577
  `sentto_address` mediumtext,
2577
  `from_address` mediumtext,
2578
  `from_address` mediumtext,
2578
  `content_type` text,
2579
  `content_type` text,
2579
  KEY `message_id` (`message_id`),
2580
  KEY `message_id` (`message_id`),
(-)a/installer/data/mysql/updatedatabase.pl (-3 / +2 lines)
Lines 9974-9980 if ( CheckVersion($DBversion) ) { Link Here
9974
$DBversion = "3.19.00.XXX";
9974
$DBversion = "3.19.00.XXX";
9975
if ( CheckVersion($DBversion) ) {
9975
if ( CheckVersion($DBversion) ) {
9976
    $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')");
9976
    $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')");
9977
    print "Upgrade to $DBversion done (Bug 8000 - system preferences to override the destination of every email sent by the system.)\n";
9977
    $dbh->do( qw{ ALTER TABLE message_queue ADD sentto_address mediumtext AFTER to_address } );
9978
    print "Upgrade to $DBversion done (Bug 8000 - add method to override the destination of every email sent by the system.)\n";
9978
    SetVersion ($DBversion);
9979
    SetVersion ($DBversion);
9979
}
9980
}
9980
9981
Lines 9992-9998 while ( my $file = readdir $dirh ) { Link Here
9992
    my $rv = $installer->load_sql( $update_dir . $file ) ? 0 : 1;
9993
    my $rv = $installer->load_sql( $update_dir . $file ) ? 0 : 1;
9993
}
9994
}
9994
9995
9995
9996
=head1 FUNCTIONS
9996
=head1 FUNCTIONS
9997
9997
9998
=head2 TableExists($table)
9998
=head2 TableExists($table)
9999
- 

Return to bug 8000