· 7 years ago · Feb 16, 2019, 01:42 PM
1-- MySQL dump 10.13 Distrib 5.1.30, for pc-linux-gnu (i686)
2--
3-- Host: localhost Database: sm
4-- ------------------------------------------------------
5-- Server version 5.1.30
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Current Database: `sm`
20--
21
22CREATE DATABASE /*!32312 IF NOT EXISTS*/ `sm` /*!40100 DEFAULT CHARACTER SET latin1 */;
23
24USE `sm`;
25
26--
27-- Table structure for table `auth`
28--
29
30DROP TABLE IF EXISTS `auth`;
31SET @saved_cs_client = @@character_set_client;
32SET character_set_client = utf8;
33CREATE TABLE `auth` (
34 `userid` int(11) NOT NULL DEFAULT '0',
35 `zoneid` int(11) NOT NULL DEFAULT '0',
36 `rid` int(11) NOT NULL DEFAULT '0',
37 PRIMARY KEY (`userid`,`zoneid`,`rid`)
38) ENGINE=MyISAM DEFAULT CHARSET=utf8;
39SET character_set_client = @saved_cs_client;
40
41--
42-- Dumping data for table `auth`
43--
44
45LOCK TABLES `auth` WRITE;
46/*!40000 ALTER TABLE `auth` DISABLE KEYS */;
47INSERT INTO `auth` VALUES (1024,1,0),(1024,1,1),(1024,1,2),(1024,1,3),(1024,1,4),(1024,1,5),(1024,1,6),(1024,1,7),(1024,1,8),(1024,1,9),(1024,1,10),(1024,1,11),(1024,1,100),(1024,1,101),(1024,1,102),(1024,1,103),(1024,1,104),(1024,1,105),(1024,1,200),(1024,1,201),(1024,1,202),(1024,1,203),(1024,1,204),(1024,1,205),(1024,1,206),(1024,1,207),(1024,1,208),(1024,1,209),(1024,1,210),(1024,1,211),(1024,1,212),(1024,1,213),(1024,1,214),(1024,1,501),(1024,1,502),(1024,1,503),(1024,1,504),(1024,1,505),(1024,1,506),(1024,1,507),(1024,1,508),(1024,1,509),(1024,1,510),(1024,1,511),(1024,1,512),(1024,1,513),(1024,1,514),(1024,1,515),(1024,1,516),(1024,1,517),(1024,1,518);
48/*!40000 ALTER TABLE `auth` ENABLE KEYS */;
49UNLOCK TABLES;
50
51--
52-- Table structure for table `forbid`
53--
54
55DROP TABLE IF EXISTS `forbid`;
56SET @saved_cs_client = @@character_set_client;
57SET character_set_client = utf8;
58CREATE TABLE `forbid` (
59 `userid` int(11) NOT NULL DEFAULT '0',
60 `type` int(11) NOT NULL DEFAULT '0',
61 `ctime` datetime NOT NULL,
62 `forbid_time` int(11) NOT NULL DEFAULT '0',
63 `reason` blob NOT NULL,
64 `gmroleid` int(11) DEFAULT '0',
65 PRIMARY KEY (`userid`,`type`)
66) ENGINE=MyISAM DEFAULT CHARSET=utf8;
67SET character_set_client = @saved_cs_client;
68
69--
70-- Dumping data for table `forbid`
71--
72
73LOCK TABLES `forbid` WRITE;
74/*!40000 ALTER TABLE `forbid` DISABLE KEYS */;
75/*!40000 ALTER TABLE `forbid` ENABLE KEYS */;
76UNLOCK TABLES;
77
78--
79-- Table structure for table `iplimit`
80--
81
82DROP TABLE IF EXISTS `iplimit`;
83SET @saved_cs_client = @@character_set_client;
84SET character_set_client = utf8;
85CREATE TABLE `iplimit` (
86 `uid` int(11) NOT NULL DEFAULT '0',
87 `ipaddr1` int(11) DEFAULT '0',
88 `ipmask1` varchar(2) DEFAULT '',
89 `ipaddr2` int(11) DEFAULT '0',
90 `ipmask2` varchar(2) DEFAULT '',
91 `ipaddr3` int(11) DEFAULT '0',
92 `ipmask3` varchar(2) DEFAULT '',
93 `enable` char(1) DEFAULT '',
94 `lockstatus` char(1) DEFAULT '',
95 PRIMARY KEY (`uid`)
96) ENGINE=MyISAM DEFAULT CHARSET=utf8;
97SET character_set_client = @saved_cs_client;
98
99--
100-- Dumping data for table `iplimit`
101--
102
103LOCK TABLES `iplimit` WRITE;
104/*!40000 ALTER TABLE `iplimit` DISABLE KEYS */;
105/*!40000 ALTER TABLE `iplimit` ENABLE KEYS */;
106UNLOCK TABLES;
107
108--
109-- Table structure for table `online`
110--
111
112DROP TABLE IF EXISTS `online`;
113SET @saved_cs_client = @@character_set_client;
114SET character_set_client = utf8;
115CREATE TABLE `online` (
116 `ID` int(11) DEFAULT NULL
117) ENGINE=MyISAM DEFAULT CHARSET=latin1;
118SET character_set_client = @saved_cs_client;
119
120--
121-- Dumping data for table `online`
122--
123
124LOCK TABLES `online` WRITE;
125/*!40000 ALTER TABLE `online` DISABLE KEYS */;
126/*!40000 ALTER TABLE `online` ENABLE KEYS */;
127UNLOCK TABLES;
128
129--
130-- Table structure for table `point`
131--
132
133DROP TABLE IF EXISTS `point`;
134SET @saved_cs_client = @@character_set_client;
135SET character_set_client = utf8;
136CREATE TABLE `point` (
137 `uid` int(11) NOT NULL DEFAULT '0',
138 `aid` int(11) NOT NULL DEFAULT '0',
139 `time` int(11) NOT NULL DEFAULT '0',
140 `zoneid` int(11) DEFAULT '0',
141 `zonelocalid` int(11) DEFAULT '0',
142 `accountstart` datetime DEFAULT NULL,
143 `lastlogin` datetime DEFAULT NULL,
144 `enddate` datetime DEFAULT NULL,
145 PRIMARY KEY (`uid`,`aid`),
146 KEY `IX_point_aidzoneid` (`aid`,`zoneid`)
147) ENGINE=MyISAM DEFAULT CHARSET=utf8;
148SET character_set_client = @saved_cs_client;
149
150--
151-- Dumping data for table `point`
152--
153
154LOCK TABLES `point` WRITE;
155/*!40000 ALTER TABLE `point` DISABLE KEYS */;
156INSERT INTO `point` VALUES (1024,19,0,NULL,NULL,NULL,'2012-03-20 23:12:05',NULL),(1024,11,0,NULL,NULL,NULL,'2012-03-24 01:43:09',NULL);
157/*!40000 ALTER TABLE `point` ENABLE KEYS */;
158UNLOCK TABLES;
159
160--
161-- Table structure for table `usecashlog`
162--
163
164DROP TABLE IF EXISTS `usecashlog`;
165SET @saved_cs_client = @@character_set_client;
166SET character_set_client = utf8;
167CREATE TABLE `usecashlog` (
168 `userid` int(11) NOT NULL DEFAULT '0',
169 `zoneid` int(11) NOT NULL DEFAULT '0',
170 `sn` int(11) NOT NULL DEFAULT '0',
171 `aid` int(11) NOT NULL DEFAULT '0',
172 `point` int(11) NOT NULL DEFAULT '0',
173 `cash` int(11) NOT NULL DEFAULT '0',
174 `status` int(11) NOT NULL DEFAULT '0',
175 `creatime` datetime NOT NULL,
176 `fintime` datetime NOT NULL,
177 KEY `IX_usecashlog_creatime` (`creatime`),
178 KEY `IX_usecashlog_uzs` (`userid`,`zoneid`,`sn`)
179) ENGINE=MyISAM DEFAULT CHARSET=utf8;
180SET character_set_client = @saved_cs_client;
181
182--
183-- Dumping data for table `usecashlog`
184--
185
186LOCK TABLES `usecashlog` WRITE;
187/*!40000 ALTER TABLE `usecashlog` DISABLE KEYS */;
188INSERT INTO `usecashlog` VALUES (1024,1,1,1,0,99999900,4,'2012-03-20 22:55:15','2012-03-20 23:10:28'),(1024,1,1,1,0,99999900,4,'2012-03-24 00:20:06','2012-03-24 00:32:39'),(1072,1,1,1,0,99999900,4,'2012-03-26 14:45:39','2012-03-26 14:50:15');
189/*!40000 ALTER TABLE `usecashlog` ENABLE KEYS */;
190UNLOCK TABLES;
191
192--
193-- Table structure for table `usecashnow`
194--
195
196DROP TABLE IF EXISTS `usecashnow`;
197SET @saved_cs_client = @@character_set_client;
198SET character_set_client = utf8;
199CREATE TABLE `usecashnow` (
200 `userid` int(11) NOT NULL DEFAULT '0',
201 `zoneid` int(11) NOT NULL DEFAULT '0',
202 `sn` int(11) NOT NULL DEFAULT '0',
203 `aid` int(11) NOT NULL DEFAULT '0',
204 `point` int(11) NOT NULL DEFAULT '0',
205 `cash` int(11) NOT NULL DEFAULT '0',
206 `status` int(11) NOT NULL DEFAULT '0',
207 `creatime` datetime NOT NULL,
208 PRIMARY KEY (`userid`,`zoneid`,`sn`),
209 KEY `IX_usecashnow_creatime` (`creatime`),
210 KEY `IX_usecashnow_status` (`status`)
211) ENGINE=MyISAM DEFAULT CHARSET=utf8;
212SET character_set_client = @saved_cs_client;
213
214--
215-- Dumping data for table `usecashnow`
216--
217
218LOCK TABLES `usecashnow` WRITE;
219/*!40000 ALTER TABLE `usecashnow` DISABLE KEYS */;
220/*!40000 ALTER TABLE `usecashnow` ENABLE KEYS */;
221UNLOCK TABLES;
222
223--
224-- Table structure for table `users`
225--
226
227DROP TABLE IF EXISTS `users`;
228SET @saved_cs_client = @@character_set_client;
229SET character_set_client = utf8;
230CREATE TABLE `users` (
231 `ID` int(11) NOT NULL DEFAULT '0',
232 `name` varchar(32) NOT NULL DEFAULT '',
233 `passwd` varchar(64) NOT NULL,
234 `Prompt` varchar(32) NOT NULL DEFAULT '',
235 `answer` varchar(32) NOT NULL DEFAULT '',
236 `truename` varchar(32) NOT NULL DEFAULT '',
237 `idnumber` varchar(32) NOT NULL DEFAULT '',
238 `email` varchar(64) NOT NULL DEFAULT '',
239 `mobilenumber` varchar(32) DEFAULT '',
240 `province` varchar(32) DEFAULT '',
241 `city` varchar(32) DEFAULT '',
242 `phonenumber` varchar(32) DEFAULT '',
243 `address` varchar(64) DEFAULT '',
244 `postalcode` varchar(8) DEFAULT '',
245 `gender` int(11) DEFAULT '0',
246 `birthday` datetime DEFAULT NULL,
247 `creatime` datetime NOT NULL,
248 `qq` varchar(32) DEFAULT '',
249 `passwd2` varchar(64) DEFAULT NULL,
250 PRIMARY KEY (`ID`),
251 UNIQUE KEY `IX_users_name` (`name`),
252 KEY `IX_users_creatime` (`creatime`)
253) ENGINE=MyISAM DEFAULT CHARSET=utf8;
254SET character_set_client = @saved_cs_client;
255
256--
257-- Dumping data for table `users`
258--
259
260LOCK TABLES `users` WRITE;
261/*!40000 ALTER TABLE `users` DISABLE KEYS */;
262INSERT INTO `users` VALUES (1024,'rain','«þ¡h\0H0)qÆ$r·œZ','0','0','΢æ','0','admin@mcncc.com ','0','0','0','0','0','0',0,'0000-00-00 00:00:00','2012-03-20 21:47:18','','«þ¡h\0H0)qÆ$r·œZ'),(1040,'test','¦qÆjïêLÀ‹vêm0»','0','0','0','0','test@test.com','0','0','0','0','0','0',0,'0000-00-00 00:00:00','2012-03-26 13:17:48','','¦qÆjïêLÀ‹vêm0»'),(1056,'testt','?bê‚Ÿ™«Úd‡uåÇKãÃ','0','0','0','0','test@test.com','0','0','0','0','0','0',0,'0000-00-00 00:00:00','2012-03-26 13:22:06','','?bê‚Ÿ™«Úd‡uåÇKãÃ'),(1072,'xtestx','8j%ú°hwD‚K5ÒÕ','0','0','0','0','xtestx@xtestx.com','0','0','0','0','0','0',0,'0000-00-00 00:00:00','2012-03-26 14:45:13','','8j%ú°hwD‚K5ÒÕ');
263/*!40000 ALTER TABLE `users` ENABLE KEYS */;
264UNLOCK TABLES;
265/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
266
267/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
268/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
269/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
270/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
271/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
272/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
273/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
274
275-- Dump completed on 2019-02-16 2:28:26