File manager - Edit - /home/verseaumee/ptitsanes/plugins/solidres/experience/sql/mysql/updates/0.6.0.sql
Back
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;
| ver. 1.4 |
Github
|
.
| PHP 8.5.7 | Generation time: 0 |
proxy
|
phpinfo
|
Settings