Code:
-- MySQL dump 10.13 Distrib 5.5.8, for Linux (i686)
--
-- Host: localhost Database: zx
-- ------------------------------------------------------
-- Server version 5.5.8
/*!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 */;
/*!40103 SET @old_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @old_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @old_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @old_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @old_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `auth`
--
DROP TABLE IF EXISTS `auth`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `auth` (
`userid` int(11) NOT NULL DEFAULT '0',
`zoneid` int(11) NOT NULL DEFAULT '0',
`rid` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`userid`,`zoneid`,`rid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `forbid`
--
DROP TABLE IF EXISTS `forbid`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `forbid` (
`userid` int(11) NOT NULL DEFAULT '0',
`type` int(11) NOT NULL DEFAULT '0',
`ctime` datetime NOT NULL,
`forbid_time` int(11) NOT NULL DEFAULT '0',
`reason` blob NOT NULL,
`gmroleid` int(11) DEFAULT '0',
PRIMARY KEY (`userid`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `iplimit`
--
DROP TABLE IF EXISTS `iplimit`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `iplimit` (
`uid` int(11) NOT NULL DEFAULT '0',
`ipaddr1` int(11) DEFAULT '0',
`ipmask1` varchar(2) DEFAULT '',
`ipaddr2` int(11) DEFAULT '0',
`ipmask2` varchar(2) DEFAULT '',
`ipaddr3` int(11) DEFAULT '0',
`ipmask3` varchar(2) DEFAULT '',
`enable` char(1) DEFAULT '',
`lockstatus` char(1) DEFAULT '',
PRIMARY KEY (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `online`
--
DROP TABLE IF EXISTS `online`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `online` (
`ID` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `point`
--
DROP TABLE IF EXISTS `point`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `point` (
`uid` int(11) NOT NULL DEFAULT '0',
`aid` int(11) NOT NULL DEFAULT '0',
`time` int(11) NOT NULL DEFAULT '0',
`zoneid` int(11) DEFAULT '0',
`zonelocalid` int(11) DEFAULT '0',
`accountstart` datetime DEFAULT NULL,
`lastlogin` datetime DEFAULT NULL,
`enddate` datetime DEFAULT NULL,
PRIMARY KEY (`uid`,`aid`),
KEY `IX_point_aidzoneid` (`aid`,`zoneid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `roles`
--
DROP TABLE IF EXISTS `roles`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `roles` (
`account_id` int(11) NOT NULL,
`role_id` int(11) NOT NULL,
`role_name` varchar(32) NOT NULL,
`role_level` smallint(6) NOT NULL,
`role_race` tinyint(4) NOT NULL,
`role_occupation` tinyint(4) NOT NULL,
`role_gender` tinyint(4) NOT NULL,
`role_spouse` int(11) NOT NULL,
`faction_id` int(11) NOT NULL,
`faction_name` varchar(32) NOT NULL,
`faction_level` int(11) NOT NULL,
`faction_domains` varchar(132) NOT NULL,
`role_faction_rank` int(11) NOT NULL,
`pvp_time` int(11) NOT NULL,
`pvp_kills` int(11) NOT NULL,
`pvp_deads` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `usecashlog`
--
DROP TABLE IF EXISTS `usecashlog`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `usecashlog` (
`userid` int(11) NOT NULL DEFAULT '0',
`zoneid` int(11) NOT NULL DEFAULT '0',
`sn` int(11) NOT NULL DEFAULT '0',
`aid` int(11) NOT NULL DEFAULT '0',
`point` int(11) NOT NULL DEFAULT '0',
`cash` int(11) NOT NULL DEFAULT '0',
`status` int(11) NOT NULL DEFAULT '0',
`creatime` datetime NOT NULL,
`fintime` datetime NOT NULL,
KEY `IX_usecashlog_creatime` (`creatime`),
KEY `IX_usecashlog_uzs` (`userid`,`zoneid`,`sn`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `usecashnow`
--
DROP TABLE IF EXISTS `usecashnow`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `usecashnow` (
`userid` int(11) NOT NULL DEFAULT '0',
`zoneid` int(11) NOT NULL DEFAULT '0',
`sn` int(11) NOT NULL DEFAULT '0',
`aid` int(11) NOT NULL DEFAULT '0',
`point` int(11) NOT NULL DEFAULT '0',
`cash` int(11) NOT NULL DEFAULT '0',
`status` int(11) NOT NULL DEFAULT '0',
`creatime` datetime NOT NULL,
PRIMARY KEY (`userid`,`zoneid`,`sn`),
KEY `IX_usecashnow_creatime` (`creatime`),
KEY `IX_usecashnow_status` (`status`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
`ID` int(11) NOT NULL DEFAULT '0',
`name` varchar(32) NOT NULL DEFAULT '',
`passwd` varchar(64) NOT NULL,
`Prompt` varchar(32) NOT NULL DEFAULT '',
`answer` varchar(32) NOT NULL DEFAULT '',
`truename` varchar(32) NOT NULL DEFAULT '',
`idnumber` varchar(32) NOT NULL DEFAULT '',
`email` varchar(64) NOT NULL DEFAULT '',
`mobilenumber` varchar(32) DEFAULT '',
`province` varchar(32) DEFAULT '',
`city` varchar(32) DEFAULT '',
`phonenumber` varchar(32) DEFAULT '',
`address` varchar(64) DEFAULT '',
`postalcode` varchar(8) DEFAULT '',
`gender` int(11) DEFAULT '0',
`birthday` datetime DEFAULT NULL,
`creatime` datetime NOT NULL,
`qq` varchar(32) DEFAULT '',
`passwd2` varchar(64) DEFAULT NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `IX_users_name` (`name`),
KEY `IX_users_creatime` (`creatime`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `uwebplayers`
--
DROP TABLE IF EXISTS `uwebplayers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `uwebplayers` (
`roleid` int(11) NOT NULL,
`rolename` varchar(50) DEFAULT NULL,
`rolelevel` int(11) DEFAULT NULL,
`rolestatus` int(11) DEFAULT NULL,
`rolegender` int(11) DEFAULT NULL,
`roleprof` bigint(20) DEFAULT NULL,
`rolerep` bigint(20) DEFAULT NULL,
`redname` bigint(20) DEFAULT NULL,
`rednametime` bigint(20) DEFAULT NULL,
`pinknametime` bigint(20) DEFAULT NULL,
PRIMARY KEY (`roleid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40103 SET TIME_ZONE @old_TIME_ZONE */;
/*!40101 SET SQL_MODE @old_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS @old_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS @old_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES @old_SQL_NOTES */;
-- Dump completed on 2012-07-15 12:23:51