| Server IP : 172.67.191.97 / Your IP : 104.23.243.196 Web Server : Apache/2.4.63 (Ubuntu) System : Linux adminpruebas-Virtual-Machine 6.14.0-37-generic #37-Ubuntu SMP PREEMPT_DYNAMIC Fri Nov 14 22:10:32 UTC 2025 x86_64 User : www-data ( 33) PHP Version : 8.4.5 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /var/www/html/fcarn/administrator/components/com_dpcalendar/sql/updates/mysql/ |
Upload File : |
CREATE TABLE IF NOT EXISTS `#__dpcalendar_events_hosts` ( `event_id` int NOT NULL DEFAULT '0', `user_id` int NOT NULL DEFAULT '0', PRIMARY KEY (`event_id`,`user_id`) ) DEFAULT CHARSET=utf8; ALTER TABLE `#__dpcalendar_locations` ADD `xreference` VARCHAR(255) NULL; ALTER TABLE `#__dpcalendar_locations` ADD INDEX `idx_xreference` (`xreference`); -- Set xreference for locations with no events UPDATE `#__dpcalendar_locations` SET `xreference`= `title` WHERE id NOT IN (SELECT location_id FROM #__dpcalendar_events_location); ALTER TABLE `#__dpcalendar_bookings` ADD `token` VARCHAR(255) NULL DEFAULT NULL AFTER `raw_data`;