File manager - Edit - /home/verseaumee/ptitsanes/administrator/components/com_solidres/sql/updates/mysql/0.6.0.sql
Back
ALTER TABLE `#__sr_reservations` ADD COLUMN `deposit_amount` DECIMAL( 12, 2 ) UNSIGNED NULL DEFAULT NULL; ALTER TABLE `#__sr_reservation_assets` CHANGE `deposit_amount` `deposit_amount` DECIMAL( 12, 2 ) UNSIGNED NULL DEFAULT NULL; -- ALTER TABLE `#__sr_reservations` DROP `invoice_number`; ALTER TABLE `#__sr_reservation_assets` DROP FOREIGN KEY `fk_sr_reservation_assets_sr_categories1`; ALTER TABLE `#__sr_reservation_assets` DROP INDEX `fk_sr_reservation_assets_sr_categories1_idx` ; ALTER TABLE `#__sr_room_types` CHANGE COLUMN `ordering` `ordering` INT(11) NOT NULL DEFAULT 0 ; ALTER TABLE `#__sr_reservation_room_extra_xref` DROP INDEX `fk_sr_reservation_room_extra_xref_sr_reservations1` , ADD INDEX `fk_sr_reservation_room_extra_xref_sr_reservations1_idx` (`reservation_id` ASC), DROP INDEX `fk_sr_reservation_room_extra_xref_sr_rooms1` , ADD INDEX `fk_sr_reservation_room_extra_xref_sr_rooms1_idx` (`room_id` ASC), DROP INDEX `fk_sr_reservation_room_extra_xref_sr_extras1` , ADD INDEX `fk_sr_reservation_room_extra_xref_sr_extras1_idx` (`extra_id` ASC); ALTER TABLE `#__sr_tariff_details` DROP INDEX `fk_sr_tariff_details_sr_tariffs1` , ADD INDEX `fk_sr_tariff_details_sr_tariffs1_idx` (`tariff_id` ASC); ALTER TABLE `#__sr_reservation_room_details` DROP INDEX `fk_sr_reservation_room_details_sr_reservation_room_xr1` , ADD INDEX `fk_sr_reservation_room_details_sr_reservation_room_xr1_idx` (`reservation_room_id` ASC); ALTER TABLE `#__sr_reservation_extra_xref` DROP INDEX `fk_sr_reservation_extra_xref_sr_reservations1` , ADD INDEX `fk_sr_reservation_extra_xref_sr_reservations1_idx` (`reservation_id` ASC); DROP TABLE IF EXISTS `#__sr_categories` ; ALTER TABLE `#__sr_currencies` ADD COLUMN `filter_range` VARCHAR( 255 ) NOT NULL ; ALTER TABLE `#__sr_reservation_extra_xref` CHANGE `extra_id` `extra_id` INT( 11 ) UNSIGNED NULL ; ALTER TABLE `#__sr_reservations` ADD COLUMN `total_paid` DECIMAL(12,2) UNSIGNED NULL DEFAULT NULL AFTER `deposit_amount`; ALTER TABLE `#__sr_extras` ADD COLUMN `tax_id` INT(11) UNSIGNED NULL DEFAULT NULL AFTER `charge_type`, ADD INDEX `fk_sr_extras_sr_taxes1_idx` (`tax_id` ASC); ALTER TABLE `#__sr_extras` ADD CONSTRAINT `fk_sr_extras_sr_taxes1` FOREIGN KEY (`tax_id`) REFERENCES `#__sr_taxes` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE `#__sr_reservation_assets` ADD COLUMN `tax_id` INT(11) UNSIGNED NULL DEFAULT NULL AFTER `currency_id`, ADD INDEX `fk_jos_sr_reservation_assets_jos_sr_taxes1_idx` (`tax_id` ASC); ALTER TABLE `#__sr_reservation_assets` ADD CONSTRAINT `fk_jos_sr_reservation_assets_jos_sr_taxes1` FOREIGN KEY (`tax_id`) REFERENCES `#__sr_taxes` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
| ver. 1.4 |
Github
|
.
| PHP 8.5.7 | Generation time: 0 |
proxy
|
phpinfo
|
Settings