File manager - Edit - /home/verseaumee/ptitsanes/plugins/solidres/invoice/sql/mysql/updates/0.1.1.sql
Back
ALTER TABLE `#__sr_invoices` CHANGE `invoice_number` `invoice_number` INT(11) NULL; ALTER TABLE `#__sr_invoices` DROP FOREIGN KEY `fk_sr_invoices_sr_reservations1`; ALTER TABLE `#__sr_invoices` DROP INDEX `fk_sr_invoices_sr_reservations1_idx`; ALTER TABLE `#__sr_invoices` CHANGE `reservations_id` `reservation_id` INT(11) UNSIGNED NOT NULL; ALTER TABLE `#__sr_invoices` ADD INDEX `fk_sr_invoices_sr_reservations1_idx` (`reservation_id` ASC); ALTER TABLE `#__sr_invoices` ADD CONSTRAINT `fk_sr_invoices_sr_reservations1` FOREIGN KEY (`reservation_id`) REFERENCES `#__sr_reservations` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
| ver. 1.4 |
Github
|
.
| PHP 8.5.7 | Generation time: 0 |
proxy
|
phpinfo
|
Settings