ALTER TABLE `#__sr_subscription_levels`
  ADD `scope` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0'
  AFTER `second_period_unit`;
ALTER TABLE `#__sr_subscription_levels`
  ADD `tour_number` INT(10) UNSIGNED NOT NULL DEFAULT '0'
  AFTER `hotel_number`;
ALTER TABLE `#__sr_commission_rates`
  ADD `scope` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0'
  AFTER `user_groups`;
ALTER TABLE `#__sr_commissions`
  ADD `scope` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0'
  AFTER `commissions`;