<?php

	linkCustomFields('In-Link', 'l', 2);

	linkCustomFields('KERNEL', 'c', 1);

	$application =& kApplication::Instance();

	$query = 'REPLACE INTO '.TABLE_PREFIX.'CategoryItems (CategoryId, ItemResourceid, Primarycat, ItemPrefix, Filename)
						SELECT
							ci.CategoryId,
							ci.ItemResourceId,
							ci.PrimaryCat,
							\'l\' AS ItemPrefix,
							i.Filename as Filename
						FROM `'.TABLE_PREFIX.'Link` as i
						LEFT JOIN '.TABLE_PREFIX.'CategoryItems as ci
						ON ci.ItemResourceId = i.ResourceId;';

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

	moveItemTemplatesToCustom('In-Link', 'l');

?>