CREATE TABLE IF NOT EXISTS `character_contacts` ( charId INT UNSIGNED NOT NULL DEFAULT 0, contactId INT UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (`charId`,`contactId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;