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/nice/administrator/components/com_rsfeedback/sql/mysql/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME ]     

Current File : /home/coopiak/amisdesseniors-fr/nice/administrator/components/com_rsfeedback/sql/mysql/install.sql
CREATE TABLE IF NOT EXISTS `#__rsfeedback_auto_moderation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `label` text NOT NULL,
  `flag_id` int(11) NOT NULL DEFAULT '0',
  `limit` int(11) NOT NULL DEFAULT '0',
  `action` int(4) NOT NULL DEFAULT '0',
  `target` int(4) NOT NULL DEFAULT '0',
  `published` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`(190))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `#__rsfeedback_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `description` text NOT NULL,
  `max_votes_allowed` int(11) NOT NULL DEFAULT '0',
  `anonymous_voting` tinyint(1) NOT NULL DEFAULT '0',
  `anonymous_feedbacks` tinyint(1) NOT NULL DEFAULT '0',
  `ordering` int(11) NOT NULL DEFAULT '0',
  `published` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`(190))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `#__rsfeedback_comments` (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `feedback_id` int(4) NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  `email` varchar(255) NOT NULL DEFAULT '',
  `text` text NOT NULL,
  `date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
  `published` int(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `IdFeedback` (`feedback_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `#__rsfeedback_feedbacks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cat_id` int(11) NOT NULL DEFAULT '0',
  `status_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  `title` varchar(255) NOT NULL DEFAULT '',
  `text` text NOT NULL,
  `created`  DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
  `hits` int(11) NOT NULL DEFAULT '0',
  `published` tinyint(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `cat_id` (`cat_id`),
  KEY `status_id` (`status_id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `#__rsfeedback_flags` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `default` tinyint(4) NOT NULL DEFAULT '0',
  `ordering` int(11) NOT NULL DEFAULT '0',
  `published` int(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`(190))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS`#__rsfeedback_groups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `group_acl` varchar(255) NOT NULL DEFAULT '',
  `feedback_add` tinyint(1) NOT NULL DEFAULT '0',
  `feedback_moderation` tinyint(1) NOT NULL DEFAULT '0',
  `feedback_edit` tinyint(1) NOT NULL DEFAULT '0',
  `feedback_move` tinyint(1) NOT NULL DEFAULT '0',
  `feedback_delete` tinyint(1) NOT NULL DEFAULT '0',
  `feedback_moderate_flags` tinyint(1) NOT NULL DEFAULT '0',
  `feedback_update_status` tinyint(1) NOT NULL DEFAULT '0',
  `feedback_comment` tinyint(1) NOT NULL DEFAULT '0',
  `feedback_share` tinyint(1) NOT NULL DEFAULT '0',
  `feedback_post_flags` tinyint(1) NOT NULL DEFAULT '0',
  `category_moderation` tinyint(1) NOT NULL DEFAULT '0',
  `category_add` tinyint(1) NOT NULL DEFAULT '0',
  `category_edit` tinyint(1) NOT NULL DEFAULT '0',
  `category_delete` tinyint(1) NOT NULL DEFAULT '0',
  `captcha_feedback` tinyint(1) NOT NULL DEFAULT '0',
  `captcha_category` tinyint(1) NOT NULL DEFAULT '0',
  `captcha_flag` tinyint(1) NOT NULL DEFAULT '0',
  `captcha_comment` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`(190))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `#__rsfeedback_statuses` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL DEFAULT '',
  `icon` varchar(32) NOT NULL DEFAULT '',
  `permissions` text NOT NULL,
  `default` tinyint(4) NOT NULL DEFAULT '0',
  `ordering` int(11) NOT NULL DEFAULT '0',
  `published` int(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `#__rsfeedback_subscriptions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `feedback_id` int(11) NOT NULL DEFAULT '0',
  `name` varchar(100) NOT NULL DEFAULT '',
  `email` varchar(100) NOT NULL DEFAULT '',
   PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `#__rsfeedback_tokens` (
  `user_id` int(11) NOT NULL DEFAULT '0',
  `token` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY  (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `#__rsfeedback_user_flags` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `feedback_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `flag_id` int(11) NOT NULL DEFAULT '0',
  `comment` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `feedback_id` (`feedback_id`),
  KEY `user_id` (`user_id`),
  KEY `flag_id` (`flag_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `#__rsfeedback_user_votes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `feedback_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `number_points` int(11) NOT NULL DEFAULT '0',
  `date_voted`  DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ip` varchar(50) NOT NULL DEFAULT '',
  `hash` varchar(32) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `feedback_id` (`feedback_id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;

INSERT IGNORE INTO `#__rsfeedback_flags` (`name`,`default`, `ordering` , `published`) VALUES ('Spam','1', '1', '1'), ('Inappropriate','1', '2', '1'), ('Duplicate','1',  '3', '1'), ('Wrong category','1', '4', '1');
INSERT IGNORE INTO `#__rsfeedback_groups` VALUES (1, 'Public', '{"0":"1"}', '1', '1', '0', '0', '0', '0', '0', '1', '1', '1', '0', '0', '0', '0', '1', '1', '1', '1');
INSERT IGNORE INTO `#__rsfeedback_groups` VALUES (2, 'Administrators', '{"0":"7"}', '1', '0', '1', '1', '1', '1', '1', '1', '1', '1', '0', '1', '1', '1', '0', '0', '0', '0');
INSERT IGNORE INTO `#__rsfeedback_statuses` (`name`,`icon`,`permissions`,`default`,`ordering`,`published`) VALUES ('None', 'clock', '{"allow_voting":"1","allow_commenting":"1", "automatically_remove_votes":"0"}', '1', '1', '1'), ('Accepted', 'thumbs-up', '{"allow_voting":"1","allow_commenting":"1", "automatically_remove_votes":"0"}','1', '2', '1'), ('Declined', 'thumbs-down', '{"allow_voting":"0","allow_commenting":"0", "automatically_remove_votes":"0"}','1', '3', '1'), ('Completed', 'check', '{"allow_voting":"0","allow_commenting":"0", "automatically_remove_votes":"0"}','1', '4', '1');

Anon7 - 2022
AnonSec Team