ALTER TABLE `#__sr_limit_bookings`
ADD COLUMN `reservation_asset_id` INT(11) UNSIGNED NULL DEFAULT NULL AFTER `title`,
ADD INDEX `fk_sr_limit_bookings_sr_reservation_assets1_idx` (`reservation_asset_id` ASC);


ALTER TABLE `#__sr_limit_bookings`
ADD CONSTRAINT `fk_sr_limit_bookings_sr_reservation_assets1`
  FOREIGN KEY (`reservation_asset_id`)
  REFERENCES `#__sr_reservation_assets` (`id`)
  ON DELETE NO ACTION
  ON UPDATE NO ACTION;


ALTER TABLE `#__sr_limit_booking_details`
ADD INDEX `fk_sr_limit_booking_details_sr_limit_bookings1_idx` (`limit_booking_id` ASC),
ADD INDEX `fk_sr_limit_booking_details_sr_rooms1_idx` (`room_id` ASC),
DROP INDEX `fk_sr_limit_booking_details_sr_rooms1` ,
DROP INDEX `fk_sr_limit_booking_details_sr_limit_bookings1`;