ALTER TABLE `#__sr_experiences` ADD COLUMN `params` TEXT NULL AFTER `deposit_amount`;
ALTER TABLE `#__sr_experience_reservations` MODIFY COLUMN `state` TINYINT(1) NOT NULL DEFAULT 3;
CREATE TABLE IF NOT EXISTS `#__sr_experience_reservation_guests` (
  `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `reservation_id` INT(11) UNSIGNED NULL,
  `adult` TINYINT(1) UNSIGNED NULL,
  `range_age` VARCHAR(45) NULL,
  `first_name` VARCHAR(45) NULL,
  `middle_name` VARCHAR(45) NULL,
  `last_name` VARCHAR(45) NULL,
  `dob` DATE NULL,
  `gender` TINYINT(2) UNSIGNED NULL,
  `nationality` VARCHAR(45) NULL,
  `single_room` TINYINT(2) UNSIGNED NULL,
  `columns` TEXT NOT NULL,
  PRIMARY KEY (`id`),
  INDEX `fk_exp_reservation_guests_exp_idx` (`reservation_id` ASC),
  CONSTRAINT `fk_exp_reservation_guests_exp_res1`
    FOREIGN KEY (`reservation_id`)
    REFERENCES `#__sr_experience_reservations` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;