Attachment #37465 for bug #8000

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

Lines 82-87 __PACKAGE__->table("message_queue"); Link Here

(-)a/Koha/Schema/Result/MessageQueue.pm (-2 / +9 lines)
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

Lines 2574-2579 CREATE TABLE `message_queue` ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (+1 lines)
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`),




$DBversion = "3.19.00.XXX";
if ( CheckVersion($DBversion) ) {
    $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')");
    $dbh->do( qw{ ALTER TABLE message_queue ADD sentto_address mediumtext AFTER to_address } );
    print "Upgrade to $DBversion done (Bug 8000 - add method to override the destination of every email sent by the system.)\n";
    SetVersion ($DBversion);
}


    my $rv = $installer->load_sql( $update_dir . $file ) ? 0 : 1;
}


=head1 FUNCTIONS

=head2 TableExists($table)
- 

Return to bug 8000

Lines 9974-9980 if ( CheckVersion($DBversion) ) { Link Here

(-)a/installer/data/mysql/updatedatabase.pl (-3 / +2 lines)
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	-