Attachment #35445 for bug #13606

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

Lines 1978-1984 CREATE TABLE `serial` ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
1978	DROP TABLE IF EXISTS sessions;	1978	DROP TABLE IF EXISTS sessions;
1979	CREATE TABLE sessions (	1979	CREATE TABLE sessions (
1980	`id` varchar(32) NOT NULL,	1980	`id` varchar(32) NOT NULL,
1981	`a_session` text NOT NULL,	1981	`a_session` mediumtext NOT NULL,
1982	PRIMARY KEY (`id`)	1982	PRIMARY KEY (`id`)
1983	) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;	1983	) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1984		1984




    SetVersion($DBversion);
}

$DBversion = "3.19.00.XXX";
if ( CheckVersion($DBversion) ) {
    $dbh->do(q|
         ALTER TABLE sessions CHANGE COLUMN a_session a_session MEDIUMTEXT
    |);
    print "Upgrade to $DBversion done (Bug 13606: Upgrade sessions.a_session to MEDIUMTEXT)\n";
    SetVersion($DBversion);
}

=head1 FUNCTIONS

=head2 TableExists($table)
- 

Return to bug 13606

Lines 9679-9684 if ( CheckVersion($DBversion) ) { Link Here

(-)a/installer/data/mysql/updatedatabase.pl (-1 / +9 lines)
9679	SetVersion($DBversion);	9679	SetVersion($DBversion);
9680	}	9680	}
9681		9681
		9682	$DBversion = "3.19.00.XXX";
		9683	if ( CheckVersion($DBversion) ) {
		9684	$dbh->do(q\|
		9685	ALTER TABLE sessions CHANGE COLUMN a_session a_session MEDIUMTEXT
		9686	\|);
		9687	print "Upgrade to $DBversion done (Bug 13606: Upgrade sessions.a_session to MEDIUMTEXT)\n";
		9688	SetVersion($DBversion);
		9689	}
		9690
9682	=head1 FUNCTIONS	9691	=head1 FUNCTIONS
9683		9692
9684	=head2 TableExists($table)	9693	=head2 TableExists($table)
9685	-