관리-도구

편집 파일: 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 */;