File manager - Edit - /home/verseaumee/ptitsanes/administrator/components/com_solidres/sql/updates/mysql/0.5.0.sql
Back
ALTER TABLE `#__sr_extras` ADD COLUMN `mandatory` TINYINT(3) UNSIGNED NOT NULL DEFAULT 0; ALTER TABLE `#__sr_extras` ADD COLUMN `charge_type` TINYINT(3) UNSIGNED NOT NULL DEFAULT 0; DROP TABLE `#__sr_prices` IF EXISTS; CREATE TABLE IF NOT EXISTS `#__sr_tariffs` ( `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT , `currency_id` INT(11) UNSIGNED NOT NULL DEFAULT 0 , `customer_group_id` INT(11) UNSIGNED NULL DEFAULT NULL COMMENT 'price for each user groups' , `valid_from` DATE NOT NULL , `valid_to` DATE NOT NULL , `room_type_id` INT(11) UNSIGNED NULL , `title` VARCHAR(45) NULL , `description` VARCHAR(255) NULL , `d_min` TINYINT NULL , `d_max` TINYINT NULL , `p_min` TINYINT NULL , `p_max` TINYINT NULL , `type` TINYINT UNSIGNED NOT NULL DEFAULT 0 , PRIMARY KEY (`id`) , INDEX `fk_sr_prices_sr_currencies1_idx` (`currency_id` ASC) , INDEX `fk_sr_prices_sr_room_types1_idx` (`room_type_id` ASC) , INDEX `fk_sr_prices_sr_customer_groups1_idx` (`customer_group_id` ASC) , CONSTRAINT `fk_sr_prices_sr_currencies1` FOREIGN KEY (`currency_id` ) REFERENCES `#__sr_currencies` (`id` ) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_sr_prices_sr_room_types1` FOREIGN KEY (`room_type_id` ) REFERENCES `#__sr_room_types` (`id` ) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_sr_prices_sr_customer_groups1` FOREIGN KEY (`customer_group_id` ) REFERENCES `#__sr_customer_groups` (`id` ) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB; CREATE TABLE IF NOT EXISTS `#__sr_tariff_details` ( `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT , `tariff_id` INT(11) UNSIGNED NOT NULL , `price` DECIMAL(12,2) UNSIGNED NULL , `w_day` TINYINT UNSIGNED NULL , `guest_type` VARCHAR(10) NULL COMMENT 'Adults or children' , `from_age` TINYINT UNSIGNED NULL DEFAULT NULL , `to_age` TINYINT UNSIGNED NULL DEFAULT NULL , PRIMARY KEY (`id`) , INDEX `fk_sr_tariff_details_sr_tariffs1` (`tariff_id` ASC) , CONSTRAINT `fk_sr_tariff_details_sr_tariffs1` FOREIGN KEY (`tariff_id` ) REFERENCES `#__sr_tariffs` (`id` ) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB; ALTER TABLE `#__sr_room_types` ADD COLUMN `smoking` TINYINT( 2 ) NOT NULL DEFAULT '0'; ALTER TABLE `#__sr_reservations` ADD COLUMN `customer_title` VARCHAR( 45 ) NULL; -- ----------------------------------------------------- -- Table `#__sr_reservation_room_details` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `#__sr_reservation_room_details` ( `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT , `reservation_room_id` INT(11) UNSIGNED NOT NULL , `key` VARCHAR(255) NULL , `value` TEXT NULL , PRIMARY KEY (`id`) , INDEX `fk_sr_reservation_room_details_sr_reservation_room_xr1` (`reservation_room_id` ASC) , CONSTRAINT `fk_sr_reservation_room_details_sr_reservation_room_xr1` FOREIGN KEY (`reservation_room_id` ) REFERENCES `#__sr_reservation_room_xref` (`id` ) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB; -- ----------------------------------------------------- -- Table `#__sr_reservation_extra_xref` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `#__sr_reservation_extra_xref` ( `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT , `reservation_id` INT(11) UNSIGNED NOT NULL , `extra_id` INT(11) UNSIGNED NOT NULL , `extra_name` VARCHAR(255) NULL , `extra_quantity` INT(11) NULL , `extra_price` DECIMAL(12,2) NULL , PRIMARY KEY (`id`) , INDEX `fk_sr_reservation_extra_xref_sr_reservations1` (`reservation_id` ASC) , INDEX `fk_sr_reservation_extra_xref_sr_extras1` (`extra_id` ASC) , CONSTRAINT `fk_sr_reservation_extra_xref_sr_reservations1` FOREIGN KEY (`reservation_id` ) REFERENCES `#__sr_reservations` (`id` ) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_sr_reservation_extra_xref_sr_sr_extras1` FOREIGN KEY (`extra_id` ) REFERENCES `#__sr_extras` (`id` ) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB; ALTER TABLE `#__sr_reservations` CHANGE `payment_method_id` `payment_method_id` VARCHAR( 255 ) NOT NULL; ALTER TABLE `#__sr_reservations` ADD COLUMN `payment_method_txn_id` VARCHAR( 255 ) NULL DEFAULT NULL AFTER `payment_method_id`; ALTER TABLE `#__sr_reservations` ADD COLUMN `payment_status` TINYINT( 2 ) NULL DEFAULT '0' AFTER `payment_method_txn_id`; -- ----------------------------------------------------- -- Table `#__sr_reseravtions` -- ----------------------------------------------------- ALTER TABLE `#__sr_reservations` DROP COLUMN `invoice_number`;
| ver. 1.4 |
Github
|
.
| PHP 8.5.7 | Generation time: 0 |
proxy
|
phpinfo
|
Settings