| 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_plans ADD recurring INT(11) DEFAULT 0;
ALTER TABLE #__djcf_plans_subscr ADD recurring INT(11) DEFAULT 0;
ALTER TABLE #__djcf_plans_subscr ADD recurr_status VARCHAR(255) DEFAULT '';
ALTER TABLE #__djcf_plans_subscr ADD recurr_data TEXT NULL;
ALTER TABLE #__djcf_fields_groups ADD access INT(11) NOT NULL DEFAULT 1;
ALTER TABLE #__djcf_fields_groups ADD published INT(11) NOT NULL DEFAULT 1;
ALTER TABLE #__djcf_regions ADD header_text varchar(1000) NOT NULL default '';
ALTER TABLE #__djcf_plans_subscr ADD notify_expired int(11) NOT NULL DEFAULT 0;
ALTER TABLE #__djcf_fields ADD attribs TEXT;
ALTER TABLE #__djcf_fields ADD all_cats INT(11) NOT NULL DEFAULT 0;
ALTER TABLE #__djcf_fields ADD input_type VARCHAR(100) NOT NULL DEFAULT '';
ALTER TABLE #__djcf_fields ADD placeholder VARCHAR(1000) NOT NULL DEFAULT '';
INSERT IGNORE INTO `#__djcf_emails` (`id`, `label`, `title`, `content`) VALUES
(37, 'COM_DJCLASSIFIEDS_ET_PLAN_EXPIRE_NOTIFICATION', 'Plan expiration notification', '<p>Hello,</p><p> </p><p>Your plan ''[[plan_name]]'' will expire in [[plan_expire_days]] days.</p>');
CREATE TABLE IF NOT EXISTS `#__djcf_fields_groups_usergroups` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`group_id` INT(11) NOT NULL,
`usergroup_id` INT(11) NOT NULL,
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;