CREATE TABLE `linkage` (
  `linknr` int(11) NOT NULL,
  `portal_chanid` int(11) NOT NULL,
  `chanid` int(11) NOT NULL,
  `subevent` varchar(255) character set utf8 NOT NULL,
  KEY `portal_chanid` (`linknr`,`portal_chanid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;