CREATE TABLE `collection_objects` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `object_id` bigint(20) NOT NULL,
  `collection_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `community_obj` (`object_id`,`collection_id`),
  KEY `comm` (`collection_id`),
  KEY `obj` (`object_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1