<?php
	$application =& kApplication::Instance();

	// set Categories Name & Description to their multilingual equialents
	$ml_formatter =& $application->recallObject('kMultiLanguage');
	$table_name = $application->getUnitOption('c', 'TableName');

	$sql = 'UPDATE '.$table_name.'
			SET '.$ml_formatter->LangFieldName('Name').' = Name, '.$ml_formatter->LangFieldName('Description').' = Description';
	$application->Conn->Query($sql);

	// locating possible duplicate records in CategoryItems
	$query = 'SELECT CategoryId, ItemResourceId, COUNT(*) AS Dups
						FROM '.TABLE_PREFIX.'CategoryItems
						GROUP BY CategoryId, ItemResourceId
						HAVING Dups > 1';

	$dups = $application->Conn->Query($query);

	// removing duplicate records
	foreach ($dups as $a_dup) {
		$query = 'DELETE FROM '.TABLE_PREFIX.'CategoryItems
							WHERE
								CategoryId = '.$query['CategoryId'].'
								AND
								ItemResourceId = '.$query['ItemResourceId'].'
							LIMIT '.($query['Dups'] - 1);
		$application->Conn->Query($query);

	}

	// creating unique index
	$queries[] = 'ALTER TABLE `'.TABLE_PREFIX.'CategoryItems` DROP INDEX `CategoryId` ';
	$queries[] = 'ALTER TABLE `'.TABLE_PREFIX.'CategoryItems` DROP INDEX `ItemResourceId` ';
	$queries[] = 'ALTER TABLE `'.TABLE_PREFIX.'CategoryItems` ADD UNIQUE ( `CategoryId` , `ItemResourceId` )';
	$queries[] = 'ALTER TABLE `'.TABLE_PREFIX.'CategoryItems` ADD INDEX ( `Filename` ) ';
	$queries[] = 'ALTER TABLE `'.TABLE_PREFIX.'CategoryItems` ADD INDEX ( `ItemPrefix` ) ';

	foreach ($queries as $query) {
		$application->Conn->Query($query);
	}

?>