<?php
	linkCustomFields('In-Bulletin', 'bb', 2);

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

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

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

	moveItemTemplatesToCustom('In-Bulletin', 'bb');
?>