Attachment #596 for bug #2274

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

Lines 2180-2185 DROP TABLE if EXISTS `message_queue`; Link Here

(-)a/installer/data/mysql/kohastructure.sql (+2 lines)
2180	CREATE TABLE `message_queue` (	2180	CREATE TABLE `message_queue` (
2181	`message_id` int(11) NOT NULL auto_increment,	2181	`message_id` int(11) NOT NULL auto_increment,
2182	`borrowernumber` int(11) NOT NULL,	2182	`borrowernumber` int(11) NOT NULL,
		2183	`to_address` mediumtext default NULL,
		2184	`from_address` mediumtext default NULL,
2183	`subject` text,	2185	`subject` text,
2184	`content` text,	2186	`content` text,
2185	`message_transport_type` varchar(20) NOT NULL,	2187	`message_transport_type` varchar(20) NOT NULL,




	print "Upgrade to $DBversion done (fix name borrower_message_preferences.wants_digest)\n";
    SetVersion ($DBversion);
}

$DBversion = '3.00.00.097';
if ( C4::Context->preference('Version') < TransformToNum($DBversion) ) {

    $dbh->do('alter table message_queue add to_address   mediumtext default NULL');
    $dbh->do('alter table message_queue add from_address mediumtext default NULL');

    print "Upgrade to $DBversion done (adding email addresses to message_queue table)\n";
    SetVersion($DBversion);
}

=item DropAllForeignKeys($table)

  Drop all foreign keys of the table $table

Lines 10-16 Link Here

(-)a/kohaversion.pl (-2 / +1 lines)
10	use strict;	10	use strict;
11		11
12	sub kohaversion {	12	sub kohaversion {
13	our $VERSION = "3.00.00.096";	13	our $VERSION = "3.00.00.097";
14	# version needs to be set this way	14	# version needs to be set this way
15	# so that it can be picked up by Makefile.PL	15	# so that it can be picked up by Makefile.PL
16	# during install	16	# during install
17	-

Return to bug 2274

Lines 1835-1840 if (C4::Context->preference("Version") < TransformToNum($DBversion)) { Link Here

(-)a/installer/data/mysql/updatedatabase.pl (+11 lines)
1835	print "Upgrade to $DBversion done (fix name borrower_message_preferences.wants_digest)\n";	1835	print "Upgrade to $DBversion done (fix name borrower_message_preferences.wants_digest)\n";
1836	SetVersion ($DBversion);	1836	SetVersion ($DBversion);
1837	}	1837	}
		1838
		1839	$DBversion = '3.00.00.097';
		1840	if ( C4::Context->preference('Version') < TransformToNum($DBversion) ) {
		1841
		1842	$dbh->do('alter table message_queue add to_address mediumtext default NULL');
		1843	$dbh->do('alter table message_queue add from_address mediumtext default NULL');
		1844
		1845	print "Upgrade to $DBversion done (adding email addresses to message_queue table)\n";
		1846	SetVersion($DBversion);
		1847	}
		1848
1838	=item DropAllForeignKeys($table)	1849	=item DropAllForeignKeys($table)
1839		1850
1840	Drop all foreign keys of the table $table	1851	Drop all foreign keys of the table $table