Edit File by line

[0] Fix | Delete

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

[1] Fix | Delete

SET time_zone = "+00:00";

[2] Fix | Delete

[3] Fix | Delete

[4] Fix | Delete

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

[5] Fix | Delete

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

[6] Fix | Delete

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

[7] Fix | Delete

/*!40101 SET NAMES utf8 */;

[8] Fix | Delete

[9] Fix | Delete

[10] Fix | Delete

-- Database: `net2ftp13`

[11] Fix | Delete

[12] Fix | Delete

[13] Fix | Delete

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

[14] Fix | Delete

[15] Fix | Delete

[16] Fix | Delete

-- Table structure for table `net2ftp_log_access`

[17] Fix | Delete

[18] Fix | Delete

[19] Fix | Delete

CREATE TABLE `net2ftp_log_access` (

[20] Fix | Delete

`id` int(10) unsigned NOT NULL AUTO_INCREMENT,

[21] Fix | Delete

`date` date NOT NULL,

[22] Fix | Delete

`time` time NOT NULL,

[23] Fix | Delete

`page` text NOT NULL,

[24] Fix | Delete

`state` text NOT NULL,

[25] Fix | Delete

`state2` text NOT NULL,

[26] Fix | Delete

`screen` text NOT NULL,

[27] Fix | Delete

`skin` text NOT NULL,

[28] Fix | Delete

`language` text NOT NULL,

[29] Fix | Delete

`protocol` text NOT NULL,

[30] Fix | Delete

`ftpserver` varchar(254) NOT NULL,

[31] Fix | Delete

`ftpserver_ipaddress` varchar(15) NOT NULL,

[32] Fix | Delete

`ftpserver_country` char(2) NOT NULL,

[33] Fix | Delete

`ftpserverport` varchar(5) NOT NULL,

[34] Fix | Delete

`username` varchar(254) NOT NULL,

[35] Fix | Delete

`directory` text NOT NULL,

[36] Fix | Delete

`entry` text NOT NULL,

[37] Fix | Delete

`user_email` varchar(254) NOT NULL,

[38] Fix | Delete

`user_ipaddress` varchar(15) NOT NULL,

[39] Fix | Delete

`user_country` char(2) NOT NULL,

[40] Fix | Delete

`user_port` text NOT NULL,

[41] Fix | Delete

`user_http_user_agent` text NOT NULL,

[42] Fix | Delete

`datatransfer` int(10) unsigned DEFAULT NULL,

[43] Fix | Delete

`executiontime` int(10) unsigned DEFAULT NULL,

[44] Fix | Delete

PRIMARY KEY (`id`),

[45] Fix | Delete

KEY `user_email` (`user_email`),

[46] Fix | Delete

KEY `ftpserver` (`ftpserver`),

[47] Fix | Delete

KEY `user_ip` (`user_ipaddress`),

[48] Fix | Delete

KEY `username` (`username`)

[49] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

[50] Fix | Delete

[51] Fix | Delete

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

[52] Fix | Delete

[53] Fix | Delete

[54] Fix | Delete

-- Table structure for table `net2ftp_log_consumption_ftpserver`

[55] Fix | Delete

[56] Fix | Delete

[57] Fix | Delete

CREATE TABLE `net2ftp_log_consumption_ftpserver` (

[58] Fix | Delete

`date` date NOT NULL,

[59] Fix | Delete

`ftpserver` varchar(254) NOT NULL,

[60] Fix | Delete

`datatransfer` int(10) unsigned NOT NULL,

[61] Fix | Delete

`executiontime` int(10) unsigned NOT NULL,

[62] Fix | Delete

PRIMARY KEY (`date`,`ftpserver`)

[63] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[64] Fix | Delete

[65] Fix | Delete

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

[66] Fix | Delete

[67] Fix | Delete

[68] Fix | Delete

-- Table structure for table `net2ftp_log_consumption_ipaddress`

[69] Fix | Delete

[70] Fix | Delete

[71] Fix | Delete

CREATE TABLE `net2ftp_log_consumption_ipaddress` (

[72] Fix | Delete

`date` date NOT NULL,

[73] Fix | Delete

`user_ipaddress` varchar(15) NOT NULL,

[74] Fix | Delete

`datatransfer` int(10) unsigned NOT NULL,

[75] Fix | Delete

`executiontime` int(10) unsigned NOT NULL,

[76] Fix | Delete

PRIMARY KEY (`date`,`user_ipaddress`)

[77] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[78] Fix | Delete

[79] Fix | Delete

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

[80] Fix | Delete

[81] Fix | Delete

[82] Fix | Delete

-- Table structure for table `net2ftp_log_error`

[83] Fix | Delete

[84] Fix | Delete

[85] Fix | Delete

CREATE TABLE `net2ftp_log_error` (

[86] Fix | Delete

`id` int(10) unsigned NOT NULL AUTO_INCREMENT,

[87] Fix | Delete

`date` date NOT NULL,

[88] Fix | Delete

`time` time NOT NULL,

[89] Fix | Delete

`page` text NOT NULL,

[90] Fix | Delete

`state` text NOT NULL,

[91] Fix | Delete

`state2` text NOT NULL,

[92] Fix | Delete

`screen` text NOT NULL,

[93] Fix | Delete

`skin` text NOT NULL,

[94] Fix | Delete

`language` text NOT NULL,

[95] Fix | Delete

`protocol` text NOT NULL,

[96] Fix | Delete

`ftpserver` varchar(254) NOT NULL,

[97] Fix | Delete

`ftpserver_ipaddress` varchar(15) NOT NULL,

[98] Fix | Delete

`ftpserver_country` char(2) NOT NULL,

[99] Fix | Delete

`ftpserverport` varchar(5) NOT NULL,

[100] Fix | Delete

`username` varchar(254) NOT NULL,

[101] Fix | Delete

`directory` text NOT NULL,

[102] Fix | Delete

`entry` text NOT NULL,

[103] Fix | Delete

`user_email` varchar(254) NOT NULL,

[104] Fix | Delete

`user_ipaddress` varchar(15) NOT NULL,

[105] Fix | Delete

`user_country` char(2) NOT NULL,

[106] Fix | Delete

`user_port` text NOT NULL,

[107] Fix | Delete

`user_http_user_agent` text NOT NULL,

[108] Fix | Delete

`datatransfer` int(10) unsigned DEFAULT NULL,

[109] Fix | Delete

`executiontime` int(10) unsigned DEFAULT NULL,

[110] Fix | Delete

`message` text NOT NULL,

[111] Fix | Delete

`backtrace` text NOT NULL,

[112] Fix | Delete

PRIMARY KEY (`id`),

[113] Fix | Delete

KEY `user_email` (`user_email`)

[114] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

[115] Fix | Delete

[116] Fix | Delete

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

[117] Fix | Delete

[118] Fix | Delete

[119] Fix | Delete

-- Table structure for table `net2ftp_log_status`

[120] Fix | Delete

[121] Fix | Delete

[122] Fix | Delete

CREATE TABLE `net2ftp_log_status` (

[123] Fix | Delete

`month` varchar(6) NOT NULL,

[124] Fix | Delete

`status` int(3) NOT NULL,

[125] Fix | Delete

`changelog` text NOT NULL,

[126] Fix | Delete

PRIMARY KEY (`month`)

[127] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[128] Fix | Delete

[129] Fix | Delete

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

[130] Fix | Delete

/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

[131] Fix | Delete

/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

[132] Fix | Delete

[133] Fix | Delete