Attachment #38059 for bug #13606

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

Lines 1963-1969 CREATE TABLE `serial` ( -- issues related to subscriptions Link Here

(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
1963	DROP TABLE IF EXISTS sessions;	1963	DROP TABLE IF EXISTS sessions;
1964	CREATE TABLE sessions (	1964	CREATE TABLE sessions (
1965	`id` varchar(32) NOT NULL,	1965	`id` varchar(32) NOT NULL,
1966	`a_session` text NOT NULL,	1966	`a_session` mediumtext NOT NULL,
1967	PRIMARY KEY (`id`)	1967	PRIMARY KEY (`id`)
1968	) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;	1968	) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1969		1969




    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);
}

# DEVELOPER PROCESS, search for anything to execute in the db_update directory
# SEE bug 13068
# if there is anything in the atomicupdate, read and execute it.
- 

Return to bug 13606

Lines 10035-10040 if ( CheckVersion($DBversion) ) { Link Here

(-)a/installer/data/mysql/updatedatabase.pl (-1 / +9 lines)
10035	SetVersion ($DBversion);	10035	SetVersion ($DBversion);
10036	}	10036	}
10037		10037
		10038	$DBversion = "3.19.00.XXX";
		10039	if ( CheckVersion($DBversion) ) {
		10040	$dbh->do(q\|
		10041	ALTER TABLE sessions CHANGE COLUMN a_session a_session MEDIUMTEXT
		10042	\|);
		10043	print "Upgrade to $DBversion done (Bug 13606: Upgrade sessions.a_session to MEDIUMTEXT)\n";
		10044	SetVersion($DBversion);
		10045	}
		10046
10038	# DEVELOPER PROCESS, search for anything to execute in the db_update directory	10047	# DEVELOPER PROCESS, search for anything to execute in the db_update directory
10039	# SEE bug 13068	10048	# SEE bug 13068
10040	# if there is anything in the atomicupdate, read and execute it.	10049	# if there is anything in the atomicupdate, read and execute it.
10041	-