IP : 3.15.208.103 Hostname : host45.registrar-servers.com Kernel : Linux host45.registrar-servers.com 4.18.0-513.18.1.lve.2.el8.x86_64 #1 SMP Sat Mar 30 15:36:11 UTC 2024 x86_64 Disable Function : None :) OS : Linux PATH: / home/ ../ var/ softaculous/ hablator/ ../ classicpress/ ../ ./ moodle310/ ../ vtiger72/ ../ net2ftp/ net2ftp.sql/ /

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!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: `net2ftp13`
--

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

--
-- Table structure for table `net2ftp_log_access`
--

CREATE TABLE `net2ftp_log_access` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`date` date NOT NULL,
`time` time NOT NULL,
`page` text NOT NULL,
`state` text NOT NULL,
`state2` text NOT NULL,
`screen` text NOT NULL,
`skin` text NOT NULL,
`language` text NOT NULL,
`protocol` text NOT NULL,
`ftpserver` varchar(254) NOT NULL,
`ftpserver_ipaddress` varchar(15) NOT NULL,
`ftpserver_country` char(2) NOT NULL,
`ftpserverport` varchar(5) NOT NULL,
`username` varchar(254) NOT NULL,
`directory` text NOT NULL,
`entry` text NOT NULL,
`user_email` varchar(254) NOT NULL,
`user_ipaddress` varchar(15) NOT NULL,
`user_country` char(2) NOT NULL,
`user_port` text NOT NULL,
`user_http_user_agent` text NOT NULL,
`datatransfer` int(10) unsigned DEFAULT NULL,
`executiontime` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `user_email` (`user_email`),
KEY `ftpserver` (`ftpserver`),
KEY `user_ip` (`user_ipaddress`),
KEY `username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `net2ftp_log_consumption_ftpserver`
--

CREATE TABLE `net2ftp_log_consumption_ftpserver` (
`date` date NOT NULL,
`ftpserver` varchar(254) NOT NULL,
`datatransfer` int(10) unsigned NOT NULL,
`executiontime` int(10) unsigned NOT NULL,
PRIMARY KEY (`date`,`ftpserver`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `net2ftp_log_consumption_ipaddress`
--

CREATE TABLE `net2ftp_log_consumption_ipaddress` (
`date` date NOT NULL,
`user_ipaddress` varchar(15) NOT NULL,
`datatransfer` int(10) unsigned NOT NULL,
`executiontime` int(10) unsigned NOT NULL,
PRIMARY KEY (`date`,`user_ipaddress`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `net2ftp_log_error`
--

CREATE TABLE `net2ftp_log_error` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`date` date NOT NULL,
`time` time NOT NULL,
`page` text NOT NULL,
`state` text NOT NULL,
`state2` text NOT NULL,
`screen` text NOT NULL,
`skin` text NOT NULL,
`language` text NOT NULL,
`protocol` text NOT NULL,
`ftpserver` varchar(254) NOT NULL,
`ftpserver_ipaddress` varchar(15) NOT NULL,
`ftpserver_country` char(2) NOT NULL,
`ftpserverport` varchar(5) NOT NULL,
`username` varchar(254) NOT NULL,
`directory` text NOT NULL,
`entry` text NOT NULL,
`user_email` varchar(254) NOT NULL,
`user_ipaddress` varchar(15) NOT NULL,
`user_country` char(2) NOT NULL,
`user_port` text NOT NULL,
`user_http_user_agent` text NOT NULL,
`datatransfer` int(10) unsigned DEFAULT NULL,
`executiontime` int(10) unsigned DEFAULT NULL,
`message` text NOT NULL,
`backtrace` text NOT NULL,
PRIMARY KEY (`id`),
KEY `user_email` (`user_email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `net2ftp_log_status`
--

CREATE TABLE `net2ftp_log_status` (
`month` varchar(6) NOT NULL,
`status` int(3) NOT NULL,
`changelog` text NOT NULL,
PRIMARY KEY (`month`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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