CREATE TABLE buddylist ( uid int(10) UNSIGNED NOT NULL, buddy int(10) UNSIGNED NOT NULL, timestamp int(11) NOT NULL, `received` tinyint(1) NOT NULL default '0', `label` varchar(255) NOT NULL default 'all', UNIQUE KEY `uid-buddy-label` (`uid`,`buddy`,`label`), KEY `uid` (`uid`), KEY `label` (`label`) ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;