| 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 : |
INSERT INTO `#__content_types` (`type_id`, `type_title`, `type_alias`, `table`, `rules`, `field_mappings`, `router`, `content_history_options`) VALUES (0, 'Solidres Property', 'com_solidres.property', '{"special":{"dbtable":"#__sr_reservation_assets","key":"id","type":"ReservationAsset","prefix":"SolidresTable","config":"array()"},"common":{"dbtable":"#__ucm_content","key":"ucm_id","type":"Corecontent","prefix":"JTable","config":"array()"}}', '', '{"common":{"core_content_item_id":"id","core_title":"name","core_state":"state","core_alias":"alias","core_created_time":"created_date","core_modified_time":"modified_date","core_body":"description", "core_hits":"hits","core_publish_up":"null","core_publish_down":"null","core_access":"access", "core_params":"params", "core_featured":"null", "core_metadata":"metadata", "core_language":"language", "core_images":"null", "core_urls":"null", "core_version":"null", "core_ordering":"ordering", "core_metakey":"metakey", "core_metadesc":"metadesc", "core_catid":"category_id", "core_xreference":"xreference", "asset_id":"asset_id"}, "special":{}}', 'SolidresHelperRoute::getReservationAssetRoute', '');
ALTER TABLE `#__sr_extras` ADD COLUMN `access` INT(11) UNSIGNED NOT NULL DEFAULT 0 AFTER `scope`;
ALTER TABLE `#__sr_reservations` ADD COLUMN `customer_ua` VARCHAR(255) NOT NULL DEFAULT '' AFTER `customer_language`;
ALTER TABLE `#__sr_reservations` ADD COLUMN `customer_ismobile` TINYINT(1) UNSIGNED NULL DEFAULT NULL AFTER `customer_ua`;
CREATE TABLE IF NOT EXISTS `#__sr_wishlist` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`user_id` INT(11) UNSIGNED NULL DEFAULT '0',
`scope` TEXT NULL DEFAULT NULL,
`history` MEDIUMTEXT NULL DEFAULT NULL,
`created_date` DATETIME NULL DEFAULT NULL,
`modified_date` DATETIME NULL DEFAULT NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB;
CREATE TABLE IF NOT EXISTS `#__sr_property_staff_xref` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`property_id` INT(11) UNSIGNED NOT NULL,
`staff_id` INT(11) UNSIGNED NOT NULL,
PRIMARY KEY (`id`),
INDEX `idx_property_id` (`property_id`),
INDEX `idx_staff_id` (`staff_id`)
)
ENGINE = InnoDB;
ALTER TABLE `#__sr_payment_history` ADD UNIQUE(`payment_method_txn_id`);
ALTER TABLE `#__sr_reservations` ADD UNIQUE(`payment_method_txn_id`);
CREATE TABLE IF NOT EXISTS `#__sr_origins` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`scope` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
`state` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
`tax_id` INT(11) UNSIGNED NULL,
`is_default` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
`name` VARCHAR(255) NOT NULL,
`color` VARCHAR(7) NOT NULL,
PRIMARY KEY (`id`),
INDEX `fk_sr_origins_sr_taxes1_idx` (`tax_id` ASC),
CONSTRAINT `fk_sr_origins_sr_taxes1`
FOREIGN KEY (`tax_id`)
REFERENCES `#__sr_taxes` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
ALTER TABLE `#__sr_reservations`
ADD COLUMN `origin_id` INT(11) UNSIGNED NULL DEFAULT NULL AFTER `origin`,
ADD INDEX `fk_sr_reservations_sr_origins1_idx` (`origin_id` ASC),
ADD CONSTRAINT `fk_sr_reservations_sr_origins1` FOREIGN KEY (`origin_id`) REFERENCES `#__sr_origins`(`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
INSERT INTO `#__sr_origins` (`id`, `scope`, `state`, `tax_id`, `is_default`, `name`, `color`) VALUES
(1,0,1,NULL,1,'Website', '#17748b'),
(2,0,1,NULL,0,'Walk-in', '#05386B'),
(3,0,1,NULL,0,'Phone', '#64458c'),
(4,0,1,NULL,0,'Email', '#41B3A3'),
(5,1,1,NULL,1,'Website', '#17748b'),
(6,1,1,NULL,0,'Walk-in', '#05386B'),
(7,1,1,NULL,0,'Phone', '#64458c'),
(8,1,1,NULL,0,'Email', '#41B3A3');