CREATE TABLE IF NOT EXISTS `users_subscriptions` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `user_id` INT(11) NOT NULL,
  `subscription_id` INT(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `subscriber_id` (`subscription_id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;