| Server IP : 54.36.91.62 / Your IP : 216.73.217.112 Web Server : Apache System : Linux webm013.cluster127.gra.hosting.ovh.net 5.15.206-ovh-vps-grsec-zfs-classid #1 SMP Fri May 15 02:41:25 UTC 2026 x86_64 User : coopiak ( 151928) PHP Version : 8.3.23 Disable Function : _dyuweyrj4,_dyuweyrj4r,dl MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/coopiak/plats-individuels/lyon/administrator/components/com_djclassifieds/sql/updates/ |
Upload File : |
ALTER TABLE `#__djcf_categories` ADD `points` int(11) NOT NULL; ALTER TABLE `#__djcf_days` ADD `points_renew` int(11) NOT NULL; ALTER TABLE `#__djcf_regions` ADD `latitude` varchar(255) NOT NULL, ADD `longitude` varchar(255) NOT NULL; ALTER TABLE `#__djcf_payments` ADD `price` float(12,2) NOT NULL, ADD `ip_address` varchar(55) NOT NULL, ADD `type` int(11) NOT NULL; CREATE TABLE IF NOT EXISTS `#__djcf_points` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `price` float(12,2) NOT NULL, `points` int(11) NOT NULL, `ordering` int(11) NOT NULL, `published` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; CREATE TABLE IF NOT EXISTS `#__djcf_points_groups` ( `id` int(11) NOT NULL AUTO_INCREMENT, `points_id` int(11) NOT NULL, `group_id` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; CREATE TABLE IF NOT EXISTS `#__djcf_users_points` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `points` float(12,0) NOT NULL, `description` text NOT NULL, `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;