File manager - Edit - /home/verseaumee/ptitsanes/plugins/solidres/limitbooking/sql/mysql/updates/0.2.0.sql
Back
ALTER TABLE `#__sr_limit_bookings` ADD COLUMN `reservation_asset_id` INT(11) UNSIGNED NULL DEFAULT NULL AFTER `title`, ADD INDEX `fk_sr_limit_bookings_sr_reservation_assets1_idx` (`reservation_asset_id` ASC); ALTER TABLE `#__sr_limit_bookings` ADD CONSTRAINT `fk_sr_limit_bookings_sr_reservation_assets1` FOREIGN KEY (`reservation_asset_id`) REFERENCES `#__sr_reservation_assets` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE `#__sr_limit_booking_details` ADD INDEX `fk_sr_limit_booking_details_sr_limit_bookings1_idx` (`limit_booking_id` ASC), ADD INDEX `fk_sr_limit_booking_details_sr_rooms1_idx` (`room_id` ASC), DROP INDEX `fk_sr_limit_booking_details_sr_rooms1` , DROP INDEX `fk_sr_limit_booking_details_sr_limit_bookings1`;
| ver. 1.4 |
Github
|
.
| PHP 8.5.7 | Generation time: 0 |
proxy
|
phpinfo
|
Settings