Nvx2ab8Y

1/*
2*********************************************************************
3SMH
4MySQL - 5.5.42-cll : Database - cphulkd
514/09/2015 14:49PM GMT+1
6Host:Topofgames.com
7*********************************************************************
8*/
9
10
11/*!40101 SET NAMES utf8 */;
12
13/*!40101 SET SQL_MODE=''*/;
14
15/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
16/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
17/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
18/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
19CREATE DATABASE /*!32312 IF NOT EXISTS*/`cphulkd` /*!40100 DEFAULT CHARACTER SET latin1 */;
20
21USE `cphulkd`;
22
23/*Table structure for table `auths` */
24
25DROP TABLE IF EXISTS `auths`;
26
27CREATE TABLE `auths` (
28  `SERVER` char(128) NOT NULL,
29  `USER` char(128) NOT NULL,
30  `PASS` char(128) NOT NULL,
31  PRIMARY KEY (`SERVER`,`USER`)
32) ENGINE=MyISAM DEFAULT CHARSET=latin1;
33
34/*Data for the table `auths` */
35
36insert  into `auths`(`SERVER`,`USER`,`PASS`) values ('srv01.topofgames.com','courier','UcaefoaJeGwtLkyQ'),('srv01.topofgames.com','dovecot','sWccB40ENMvVtfKU'),('srv01.topofgames.com','exim','gXd_NbIn5wLylj6t'),('srv01.topofgames.com','pure-ftpd','Z1jHaRx07FJie7h4'),('srv01.topofgames.com','cpaneld','7bgt9ESW6KjxePiM'),('srv01.topofgames.com','webmaild','HcMzFqkG3mwrvi8p'),('srv01.topofgames.com','whostmgrd','XWY_Sm4QvYRssWWj'),('srv01.topofgames.com','pam','lxBlwfK7X5VDYf7L'),('srv01.topofgames.com','cpdavd','Ka0n2mP7mUW3Nocr'),('srv01.topofgames.com','cppop','um3I3sCMMDpO7rDY'),('srv01.topofgames.com','cpanelpasswd','FQYG9ZfNDc0mHCzz');
37
38/*Table structure for table `blacklist` */
39
40DROP TABLE IF EXISTS `blacklist`;
41
42CREATE TABLE `blacklist` (
43  `IP` char(128) NOT NULL,
44  `ISPREFIX` int(1) DEFAULT '0',
45  UNIQUE KEY `IP` (`IP`),
46  KEY `ISPREFIX_index` (`ISPREFIX`),
47  KEY `IP_index` (`IP`)
48) ENGINE=MyISAM DEFAULT CHARSET=latin1;
49
50/*Data for the table `blacklist` */
51
52/*Table structure for table `brutes` */
53
54DROP TABLE IF EXISTS `brutes`;
55
56CREATE TABLE `brutes` (
57  `IP` char(255) NOT NULL DEFAULT '',
58  `NOTES` text,
59  `BRUTETIME` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
60  `EXPTIME` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
61  PRIMARY KEY (`IP`),
62  KEY `EXPTIME_index` (`EXPTIME`)
63) ENGINE=MyISAM DEFAULT CHARSET=latin1;
64
65/*Data for the table `brutes` */
66
67/*Table structure for table `good_logins` */
68
69DROP TABLE IF EXISTS `good_logins`;
70
71CREATE TABLE `good_logins` (
72  `USER` char(128) NOT NULL,
73  `IP` char(255) DEFAULT NULL,
74  `LOGINSERVICE` char(64) DEFAULT NULL,
75  `LOGINTIME` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
76  KEY `LOGINTIME_LOGINSERVICE_USER_index` (`LOGINTIME`,`LOGINSERVICE`,`USER`)
77) ENGINE=MyISAM DEFAULT CHARSET=latin1;
78
79/*Data for the table `good_logins` */
80
81/*Table structure for table `ip_lists` */
82
83DROP TABLE IF EXISTS `ip_lists`;
84
85CREATE TABLE `ip_lists` (
86  `STARTADDRESS` varbinary(16) NOT NULL DEFAULT '',
87  `ENDADDRESS` varbinary(16) NOT NULL DEFAULT '',
88  `TYPE` int(1) NOT NULL DEFAULT '0',
89  `COMMENT` char(255) DEFAULT NULL,
90  PRIMARY KEY (`STARTADDRESS`,`ENDADDRESS`)
91) ENGINE=MyISAM DEFAULT CHARSET=latin1;
92
93/*Data for the table `ip_lists` */
94
95/*Table structure for table `known_netblocks` */
96
97DROP TABLE IF EXISTS `known_netblocks`;
98
99CREATE TABLE `known_netblocks` (
100  `USER` char(128) NOT NULL,
101  `STARTADDRESS` varbinary(16) NOT NULL DEFAULT '',
102  `ENDADDRESS` varbinary(16) NOT NULL DEFAULT '',
103  `LOGINTIME` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
104  PRIMARY KEY (`USER`,`STARTADDRESS`,`ENDADDRESS`),
105  KEY `LOGINTIME_index` (`LOGINTIME`),
106  KEY `USER_index` (`USER`)
107) ENGINE=MyISAM DEFAULT CHARSET=latin1;
108
109/*Data for the table `known_netblocks` */
110
111/*Table structure for table `login_track` */
112
113DROP TABLE IF EXISTS `login_track`;
114
115CREATE TABLE `login_track` (
116  `USER` char(128) NOT NULL,
117  `ADDRESS` varbinary(16) DEFAULT NULL,
118  `SERVICE` char(64) DEFAULT NULL,
119  `TYPE` int(1) DEFAULT NULL,
120  `LOGINTIME` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
121  `EXPTIME` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
122  `NOTES` text,
123  `AUTHSERVICE` char(64) DEFAULT NULL,
124  `AUTHTOKEN_HASH` char(86) DEFAULT '',
125  KEY `EXPTIME_ADDRESS_index` (`EXPTIME`,`ADDRESS`),
126  KEY `EXPTIME_USER_SERVICE_index` (`EXPTIME`,`USER`,`SERVICE`)
127) ENGINE=MyISAM DEFAULT CHARSET=latin1;
128
129/*Data for the table `login_track` */
130
131/*Table structure for table `logins` */
132
133DROP TABLE IF EXISTS `logins`;
134
135CREATE TABLE `logins` (
136  `USER` char(128) NOT NULL,
137  `IP` char(255) DEFAULT NULL,
138  `SERVICE` char(64) DEFAULT NULL,
139  `STATUS` int(1) DEFAULT NULL,
140  `LOGINTIME` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
141  KEY `LOGINTIME_SERVICE_STATUS_USER_index` (`LOGINTIME`,`SERVICE`,`STATUS`,`USER`),
142  KEY `LOGINTIME_IP_index` (`LOGINTIME`,`IP`)
143) ENGINE=MyISAM DEFAULT CHARSET=latin1;
144
145/*Data for the table `logins` */
146
147/*Table structure for table `report` */
148
149DROP TABLE IF EXISTS `report`;
150
151CREATE TABLE `report` (
152  `type` char(16) NOT NULL,
153  `service` char(16) NOT NULL,
154  `login_service` char(16) DEFAULT NULL,
155  `ip` char(200) DEFAULT NULL,
156  `user` char(100) DEFAULT NULL,
157  `failcount` int(11) DEFAULT NULL,
158  `logintime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
159) ENGINE=MyISAM DEFAULT CHARSET=latin1;
160
161/*Data for the table `report` */
162
163/*Table structure for table `whitelist` */
164
165DROP TABLE IF EXISTS `whitelist`;
166
167CREATE TABLE `whitelist` (
168  `IP` char(128) NOT NULL,
169  `ISPREFIX` int(1) DEFAULT '0',
170  UNIQUE KEY `IP` (`IP`),
171  KEY `ISPREFIX_index` (`ISPREFIX`),
172  KEY `IP_index` (`IP`)
173) ENGINE=MyISAM DEFAULT CHARSET=latin1;
174
175/*Data for the table `whitelist` */
176
177/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
178/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
179/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
180/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;