File manager - Edit - /var/softaculous/net2ftp/net2ftp.sql
Back
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 */;
| ver. 1.4 |
Github
|
.
| PHP 8.0.30 | Generation time: 3.01 |
proxy
|
phpinfo
|
Settings