| Server IP : 46.105.57.169 / Your IP : 216.73.216.67 Web Server : Apache System : Linux webm002.cluster120.gra.hosting.ovh.net 6.18.42-ovh-vps-grsec-zfs+ #1 SMP PREEMPT_DYNAMIC Wed Aug 5 15:59:48 CEST 2026 x86_64 User : verseaumee ( 152031) PHP Version : 8.5.7 Disable Function : _dyuweyrj4,_dyuweyrj4r,dl MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/verseaumee/ptitsanes/administrator/components/com_solidres/sql/updates/mysql/ |
Upload File : |
CREATE TABLE IF NOT EXISTS `#__sr_extra_coupon_xref` (
`extra_id` INT(11) UNSIGNED NOT NULL,
`coupon_id` INT(11) UNSIGNED NOT NULL,
PRIMARY KEY (`extra_id`, `coupon_id`),
INDEX `fk_extra_coupon_xref_coupons1_idx` (`coupon_id` ASC),
CONSTRAINT `fk_extra_coupon_xref_coupons1`
FOREIGN KEY (`coupon_id`)
REFERENCES `#__sr_coupons` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_extra_coupon_xref_extras1`
FOREIGN KEY (`extra_id`)
REFERENCES `#__sr_extras` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
ALTER TABLE `#__sr_reservation_assets`
ADD COLUMN `deposit_include_extra_cost` TINYINT(3) UNSIGNED NOT NULL DEFAULT 1 AFTER `deposit_by_stay_length`;