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 ;