AnonSec Shell
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/amisdesseniors-fr/administrator/components/com_jlexreview/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME ]     

Current File : /home/coopiak/amisdesseniors-fr/administrator/components/com_jlexreview/install.mysql.sql
CREATE TABLE IF NOT EXISTS `#__jlexreview` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `section_id` int(5) NOT NULL DEFAULT '0',
  `entry_id` int(11) NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `rating` decimal(3,1) unsigned NOT NULL DEFAULT '5.0',
  `created` datetime NOT NULL,
  `modified` datetime DEFAULT NULL,
  `created_by` int(11) unsigned NOT NULL,
  `author_name` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `author_email` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `ip_address` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `published` tinyint(1) NOT NULL DEFAULT '0',
  `voting` tinyint(1) NOT NULL DEFAULT '0',
  `featured` tinyint(1) NOT NULL DEFAULT '0',
  `count_cm` int(11) NOT NULL DEFAULT '0',
  `count_help` int(11) NOT NULL DEFAULT '0',
  `count_unhelp` int(11) NOT NULL DEFAULT '0',
  `count_media` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `language` char(7) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '*',
  `params` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


CREATE TABLE IF NOT EXISTS `#__jlexreview_attachment` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(80) NOT NULL DEFAULT '',
  `description` varchar(255) DEFAULT '',
  `path` varchar(255) DEFAULT NULL,
  `file_name` varchar(60) NOT NULL DEFAULT '',
  `file_size` char(20) NOT NULL,
  `file_ext` char(6) NOT NULL,
  `file_type` char(20) NOT NULL DEFAULT '',
  `created_by` int(11) unsigned NOT NULL DEFAULT '0',
  `created` datetime NOT NULL,
  `review_id` int(11) unsigned NOT NULL DEFAULT '0',
  `entry_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


CREATE TABLE IF NOT EXISTS `#__jlexreview_blacklist` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `method` tinyint(1) NOT NULL DEFAULT '1',
  `userid` int(11) unsigned NOT NULL,
  `ip_address` varchar(200) NOT NULL DEFAULT '',
  `created` datetime NOT NULL,
  `reason` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


CREATE TABLE IF NOT EXISTS `#__jlexreview_cm` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `review_id` int(11) unsigned NOT NULL,
  `entry_id` int(11) DEFAULT NULL,
  `comment` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime DEFAULT NULL,
  `created_by` int(11) unsigned NOT NULL DEFAULT '0',
  `modified_by` int(11) DEFAULT NULL,
  `author_name` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `author_email` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `ip_address` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `reply_id` int(10) unsigned NOT NULL DEFAULT '0',
  `parent_id` int(10) NOT NULL DEFAULT '0',
  `published` tinyint(1) NOT NULL DEFAULT '0',
  `count_like` int(5) NOT NULL DEFAULT '0',
  `count_dislike` int(5) NOT NULL DEFAULT '0',
  `count_child` int(5) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


CREATE TABLE IF NOT EXISTS `#__jlexreview_entry` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `object_name` varchar(256) NOT NULL,
  `object` varchar(60) NOT NULL,
  `object_id` varchar(60) NOT NULL DEFAULT '',
  `section_id` int(8) unsigned NOT NULL DEFAULT '0',
  `section_file` int(5) NOT NULL,
  `created_by` int(11) unsigned NOT NULL DEFAULT '0',
  `published` tinyint(1) NOT NULL DEFAULT '1',
  `rating` decimal(3,1) NOT NULL DEFAULT '0.0',
  `count_rating` int(10) NOT NULL DEFAULT '0',
  `count_image` int(10) NOT NULL DEFAULT '0',
  `count_review` int(10) NOT NULL DEFAULT '0',
  `count_all_rating` int(10) NOT NULL DEFAULT '0',
  `count_all_review` int(10) DEFAULT '0',
  `latest_time` datetime DEFAULT NULL,
  `latest_id` int(11) NOT NULL DEFAULT '0',
  `editor_mode` tinyint(1) NOT NULL DEFAULT '0',
  `editor_content` text NOT NULL,
  `extra_content` text NOT NULL,
  `schema` varchar(30) NOT NULL DEFAULT '',
  `editor_rating` decimal(2,1) NOT NULL DEFAULT '0.0',
  `url` varchar(256) DEFAULT '',
  `url2post` varchar(250) NOT NULL DEFAULT '',
  `canonical` varchar(250) NOT NULL DEFAULT '',
  `params` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `#__jlexreview_fields` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `review_id` int(11) unsigned NOT NULL,
  `entry_id` int(11) unsigned NOT NULL DEFAULT '0',
  `field_id` varchar(10) NOT NULL DEFAULT '',
  `field_value` text NOT NULL,
  `field_multiple` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `field_type` varchar(60) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


CREATE TABLE IF NOT EXISTS `#__jlexreview_form` (
  `id` int(4) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `params` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


CREATE TABLE IF NOT EXISTS `#__jlexreview_helpful` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `type_id` int(11) unsigned NOT NULL,
  `type_ob` tinyint(1) NOT NULL DEFAULT '1',
  `rate_match` tinyint(1) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL,
  `created_by` int(11) unsigned NOT NULL,
  `ip_address` varchar(200) NOT NULL DEFAULT '',
  `rate_limit` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


CREATE TABLE IF NOT EXISTS `#__jlexreview_notification` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `entry_id` int(11) unsigned NOT NULL,
  `type_id` varchar(20) NOT NULL DEFAULT '',
  `action_type` varchar(20) NOT NULL DEFAULT 'REPLY',
  `user_remind` int(10) unsigned NOT NULL,
  `user_email` varchar(60) DEFAULT NULL,
  `guest_name` varchar(30) NOT NULL DEFAULT '',
  `created_by` int(11) unsigned NOT NULL,
  `created_time` datetime NOT NULL,
  `unread` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `sent` tinyint(1) NOT NULL DEFAULT '0',
  `published` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


CREATE TABLE IF NOT EXISTS `#__jlexreview_notification_off` (
  `uid` int(11) unsigned NOT NULL,
  `created_time` datetime NOT NULL,
  `published` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


CREATE TABLE IF NOT EXISTS `#__jlexreview_replacer` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `caption` varchar(60) NOT NULL DEFAULT '',
  `regexClause` varchar(250) NOT NULL DEFAULT '',
  `replaceClause` varchar(250) NOT NULL DEFAULT '',
  `created_by` int(11) unsigned NOT NULL,
  `created` datetime NOT NULL,
  `published` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `area` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `params` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


CREATE TABLE IF NOT EXISTS `#__jlexreview_report` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `type_ob` tinyint(1) NOT NULL DEFAULT '1',
  `type_id` int(11) unsigned NOT NULL,
  `created_by` int(11) unsigned NOT NULL,
  `ip_address` varchar(200) NOT NULL DEFAULT '',
  `created` datetime NOT NULL,
  `reason_msg` varchar(256) NOT NULL DEFAULT '',
  `guest_name` varchar(60) DEFAULT NULL,
  `guest_email` varchar(60) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `#__jlexreview_roles` (
  `id` int(3) unsigned NOT NULL AUTO_INCREMENT,
  `method` tinyint(1) NOT NULL DEFAULT '1',
  `group_id` int(3) unsigned NOT NULL,
  `condition_file` varchar(30) NOT NULL,
  `title` varchar(40) NOT NULL DEFAULT '',
  `colour` char(20) NOT NULL DEFAULT '',
  `published` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `created` datetime NOT NULL,
  `created_by` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `#__jlexreview_section` (
  `id` int(5) unsigned NOT NULL AUTO_INCREMENT,
  `object` varchar(60) NOT NULL,
  `section_id` int(11) unsigned NOT NULL,
  `section_file` int(4) unsigned NOT NULL,
  `created` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `review_section_id` (`object`,`section_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `#__jlexreview_subscribe` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `sub_type` tinyint(1) unsigned DEFAULT '1',
  `userid` int(11) unsigned DEFAULT NULL,
  `guest_name` varchar(60) NOT NULL DEFAULT '',
  `guest_email` varchar(60) NOT NULL DEFAULT '',
  `sub_value` int(11) unsigned NOT NULL DEFAULT '0',
  `created` datetime NOT NULL,
  `point` int(11) NOT NULL DEFAULT '0',
  `point_created` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


CREATE TABLE IF NOT EXISTS `#__jlexreview_users` (
  `userid` int(11) unsigned NOT NULL,
  `created` datetime DEFAULT NULL,
  `auth` varchar(10) NOT NULL,
  `auth_id` varchar(60) DEFAULT '',
  `auth_url` varchar(200) DEFAULT '',
  `auth_picture` varchar(200) DEFAULT '',
  `count_rating` int(10) NOT NULL DEFAULT '0',
  `count_cm` int(10) NOT NULL DEFAULT '0',
  `count_helpful` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


CREATE TABLE IF NOT EXISTS `#__jlexreview_sync` (
  `id` int(3) unsigned NOT NULL AUTO_INCREMENT,
  `object` varchar(40) NOT NULL,
  `entry_details` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `cb_entry_details` text NOT NULL,
  `entry_updated` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `cb_entry_updated` text NOT NULL,
  `author_follow` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `cb_author_follow` text NOT NULL,
  `latest_log` text,
  `published` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `created_by` int(10) unsigned NOT NULL DEFAULT '0',
  `created_time` datetime NOT NULL,
  `modified_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Anon7 - 2022
AnonSec Team