CREATE TABLE IF NOT EXISTS `#__sr_experience_date_xref` (
  `experience_id` INT(11) UNSIGNED NOT NULL,
  `date` DATETIME NOT NULL,
  PRIMARY KEY (`experience_id`, `date`)
)
  ENGINE = InnoDB;

ALTER TABLE `#__sr_experiences` ADD COLUMN `deposit_incl_extra_cost` TINYINT(1) UNSIGNED NOT NULL DEFAULT 1 AFTER `deposit_amount`;
ALTER TABLE `#__sr_experience_reservations` ADD COLUMN `payment_method_surcharge` DECIMAL(12,2) UNSIGNED NOT NULL DEFAULT 0.00 AFTER `deposit_amount`;
ALTER TABLE `#__sr_experience_reservations` ADD COLUMN `payment_method_discount` DECIMAL(12,2) UNSIGNED NOT NULL DEFAULT 0.00 AFTER `payment_method_surcharge`;