HEX
Server: Apache
System: Linux sg241.singhost.net 2.6.32-896.16.1.lve1.4.51.el6.x86_64 #1 SMP Wed Jan 17 13:19:23 EST 2018 x86_64
User: honghock (909)
PHP: 8.0.30
Disabled: passthru,system,shell_exec,show_source,exec,popen,proc_open
$ pwd: /var/softaculous/pfn/
Upload Files
File: //var/softaculous/pfn/pfn.sql
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `pfn`
--

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]accesos`
--

CREATE TABLE `[[dbprefix]]accesos` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `login` varchar(50) NOT NULL DEFAULT '',
  `ip` varchar(15) NOT NULL DEFAULT '',
  `estado` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `donde` varchar(50) NOT NULL DEFAULT '',
  `session` varchar(100) DEFAULT NULL,
  `data` int(10) unsigned NOT NULL DEFAULT '0',
  `ultimo` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `[[dbprefix]]accesos`
--


-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]arquivos`
--

CREATE TABLE `[[dbprefix]]arquivos` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `arquivo` varchar(245) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `id_directorio` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `arquivo` (`arquivo`,`id_directorio`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `[[dbprefix]]arquivos`
--


-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]arquivos_campos_palabras`
--

CREATE TABLE `[[dbprefix]]arquivos_campos_palabras` (
  `id_arquivo` int(10) unsigned NOT NULL DEFAULT '0',
  `id_campo` smallint(6) unsigned NOT NULL DEFAULT '0',
  `id_palabra` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_arquivo`,`id_campo`,`id_palabra`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `[[dbprefix]]arquivos_campos_palabras`
--


-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]bloqueo_ip`
--

CREATE TABLE `[[dbprefix]]bloqueo_ip` (
  `ip` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `[[dbprefix]]bloqueo_ip`
--

INSERT INTO `[[dbprefix]]bloqueo_ip` VALUES('0.0.0.0');

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]campos`
--

CREATE TABLE `[[dbprefix]]campos` (
  `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `campo` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `campo` (`campo`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `[[dbprefix]]campos`
--


-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]configuracions`
--

CREATE TABLE `[[dbprefix]]configuracions` (
  `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `conf` varchar(50) NOT NULL DEFAULT '',
  `vale` tinyint(1) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Dumping data for table `[[dbprefix]]configuracions`
--

INSERT INTO `[[dbprefix]]configuracions` VALUES(1, 'basicas', 0);
INSERT INTO `[[dbprefix]]configuracions` VALUES(2, 'login', 0);
INSERT INTO `[[dbprefix]]configuracions` VALUES(3, 'default', 1);

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]configuracions_datos`
--

CREATE TABLE `[[dbprefix]]configuracions_datos` (
  `campo` varchar(50) NOT NULL DEFAULT '',
  `valor` varchar(50) NOT NULL DEFAULT '',
  `id_conf` smallint(6) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_conf`,`campo`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `[[dbprefix]]configuracions_datos`
--


-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]directorios`
--

CREATE TABLE `[[dbprefix]]directorios` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `directorio` varchar(245) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `id_raiz` smallint(6) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `directorio` (`directorio`,`id_raiz`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `[[dbprefix]]directorios`
--


-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]grupos`
--

CREATE TABLE `[[dbprefix]]grupos` (
  `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `nome` varchar(50) NOT NULL DEFAULT '',
  `id_conf` smallint(6) unsigned NOT NULL DEFAULT '0',
  `estado` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Dumping data for table `[[dbprefix]]grupos`
--

INSERT INTO `[[dbprefix]]grupos` VALUES(1, 'Administrators', 3, 1);

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]palabras`
--

CREATE TABLE `[[dbprefix]]palabras` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `palabra` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `palabra` (`palabra`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `[[dbprefix]]palabras`
--


-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]raices`
--

CREATE TABLE `[[dbprefix]]raices` (
  `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `nome` varchar(50) NOT NULL DEFAULT '',
  `path` varchar(255) NOT NULL DEFAULT '',
  `web` varchar(255) NOT NULL DEFAULT '',
  `host` varchar(255) NOT NULL DEFAULT '',
  `estado` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `mantemento` date NOT NULL DEFAULT '0000-00-00',
  `peso_maximo` bigint(20) unsigned NOT NULL DEFAULT '0',
  `peso_actual` bigint(20) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Dumping data for table `[[dbprefix]]raices`
--

INSERT INTO `[[dbprefix]]raices` VALUES(1, '[[site_name]]', '[[startpath]]/', '/', '[[domhost]]', 1, '0000-00-00', 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]raices_grupos_configuracions`
--

CREATE TABLE `[[dbprefix]]raices_grupos_configuracions` (
  `id_raiz` smallint(6) unsigned NOT NULL DEFAULT '0',
  `id_grupo` smallint(6) unsigned NOT NULL DEFAULT '0',
  `id_conf` smallint(6) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_raiz`,`id_grupo`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `[[dbprefix]]raices_grupos_configuracions`
--

INSERT INTO `[[dbprefix]]raices_grupos_configuracions` VALUES(1, 1, 3);

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]raices_usuarios`
--

CREATE TABLE `[[dbprefix]]raices_usuarios` (
  `id_raiz` smallint(6) unsigned NOT NULL DEFAULT '0',
  `id_usuario` smallint(6) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_raiz`,`id_usuario`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `[[dbprefix]]raices_usuarios`
--

INSERT INTO `[[dbprefix]]raices_usuarios` VALUES(1, 1);

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]sesions`
--

CREATE TABLE `[[dbprefix]]sesions` (
  `id` varchar(45) NOT NULL DEFAULT '',
  `tempo` int(10) unsigned NOT NULL DEFAULT '0',
  `contido` text NOT NULL,
  `ip` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `[[dbprefix]]sesions`
--


-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]usuarios`
--

CREATE TABLE `[[dbprefix]]usuarios` (
  `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `nome` varchar(50) NOT NULL DEFAULT '',
  `usuario` varchar(50) NOT NULL DEFAULT '',
  `contrasinal` varchar(50) NOT NULL DEFAULT '',
  `contrasinal_tmp` varchar(50) NOT NULL DEFAULT '',
  `email` varchar(50) NOT NULL DEFAULT '',
  `estado` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `admin` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `id_grupo` smallint(6) unsigned NOT NULL DEFAULT '0',
  `mantemento` date NOT NULL DEFAULT '0000-00-00',
  `descargas_maximo` bigint(20) unsigned NOT NULL DEFAULT '0',
  `cambiar_datos` tinyint(1) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `usuario` (`usuario`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Dumping data for table `[[dbprefix]]usuarios`
--

INSERT INTO `[[dbprefix]]usuarios` VALUES(1, '[[admin_realname]]', '[[admin_username]]', '[[admin_pass]]', '', '[[admin_email]]', 1, 1, 1, '0000-00-00', 0, 1);
@ Telegram