-- phpMyAdmin SQL Dump
-- version 3.3.5.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Mar 15, 2014 at 01:33 AM
-- Server version: 5.0.95
-- PHP Version: 5.3.3
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET [USER=1333464006]old[/USER]_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET [USER=1333464006]old[/USER]_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET [USER=1333464006]old[/USER]_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `pw`
--
-- --------------------------------------------------------
--
-- Table structure for table `auth`
--
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `auth`
--
INSERT INTO `auth` (`userid`, `zoneid`, `rid`) VALUES
-- --------------------------------------------------------
--
-- Table structure for table `forbid`
--
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `forbid`
--
-- --------------------------------------------------------
--
-- Table structure for table `iplimit`
--
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `iplimit`
--
-- --------------------------------------------------------
--
-- Table structure for table `online`
--
CREATE TABLE IF NOT EXISTS `online` (
`ID` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `online`
--
-- --------------------------------------------------------
--
-- Table structure for table `point`
--
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `point`
--
INSERT INTO `point` (`uid`, `aid`, `time`, `zoneid`, `zonelocalid`, `accountstart`, `lastlogin`, `enddate`) VALUES
-- --------------------------------------------------------
--
-- Table structure for table `roles`
--
CREATE TABLE IF NOT EXISTS `roles` (
`account_id` int(11) NOT NULL,
`role_id` int(11) NOT NULL,
`role_name` varchar(64) 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(64) 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;
--
-- Dumping data for table `roles`
--
INSERT INTO `roles` (`account_id`, `role_id`, `role_name`, `role_level`, `role_race`, `role_occupation`, `role_gender`, `role_spouse`, `faction_id`, `faction_name`, `faction_level`, `faction_domains`, `role_faction_rank`, `pvp_time`, `pvp_kills`, `pvp_deads`) VALUES
-- --------------------------------------------------------
--
-- Table structure for table `usecashlog`
--
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `usecashlog`
--
-- --------------------------------------------------------
--
-- Table structure for table `usecashnow`
--
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `usecashnow`
--
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`ID`, `name`, `passwd`, `Prompt`, `answer`, `truename`, `idnumber`, `email`, `mobilenumber`, `province`, `city`, `phonenumber`, `address`, `postalcode`, `gender`, `birthday`, `creatime`, `qq`, `passwd2`) VALUES
-- --------------------------------------------------------
--
-- Table structure for table `uwebplayers`
--
CREATE TABLE IF NOT EXISTS `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;
--
-- Dumping data for table `uwebplayers`
--