# --------------------------------------------------------

# Host:                         127.0.0.1

# Database:                     psquare

# Server version:               5.1.44-community

# Server OS:                    Win32

# HeidiSQL version:             5.0.0.3272

# Date/time:                    2010-11-20 23:17:02

# --------------------------------------------------------



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

/*!40101 SET NAMES utf8 */;

/*!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' */;

# Dumping database structure for psquare

CREATE DATABASE IF NOT EXISTS `psquare` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `psquare`;



# Dumping structure for table psquare.role

CREATE TABLE IF NOT EXISTS `player` (

  `pid` int(10) unsigned NOT NULL COMMENT 		'player unique id',

  `name` varchar(32) NOT NULL COMMENT				'player unique name',

  `gender` tinyint(5) unsigned NOT NULL COMMENT 'player  Gender',

  `features` tinyint(5) unsigned NOT NULL COMMENT 'player  features ',

  `money_g` int(10) unsigned NOT NULL COMMENT 'player money gold',

  `money_s` int(10) unsigned NOT NULL COMMENT 'player money silver',

  `datax` int(10) unsigned DEFAULT NULL COMMENT 'player extension data x',

  `datay` int(10) unsigned DEFAULT NULL COMMENT 'player extension data y',

  `dataz` int(10) unsigned DEFAULT NULL COMMENT 'player extension data z',

  PRIMARY KEY (`pid`),

  UNIQUE KEY `pid` (`pid`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;



# Dumping structure for table psquare.role

CREATE TABLE IF NOT EXISTS `role` (

  `rid` int(10) unsigned NOT NULL COMMENT 'role unique id',

  `hid` smallint(10) NOT NULL COMMENT 'hero static id that the role belongs to',

  `level` smallint(5) unsigned NOT NULL COMMENT 'role unique age',

  `datax` int(10) unsigned DEFAULT NULL COMMENT 'role extension data x',

  `datay` int(10) unsigned DEFAULT NULL COMMENT 'role extension data y',

  `dataz` int(10) unsigned DEFAULT NULL COMMENT 'role extension data z',

  PRIMARY KEY (`rid`),

  UNIQUE KEY `rid` (`rid`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;





# Dumping structure for table psquare.item

CREATE TABLE IF NOT EXISTS `item` (

  `iid` int(10) unsigned NOT NULL COMMENT 'item id',

  `pid` int(10) unsigned NOT NULL COMMENT 'owner player id',

  `sid` int(10) unsigned NOT NULL COMMENT 'item static id',

  `endurance` smallint(5) unsigned NOT NULL COMMENT 'item endurance',

  `count` smallint(5) unsigned NOT NULL COMMENT 'item count',

  `elvl` tinyint(5) unsigned NOT NULL COMMENT 'item enchant level',

  `slotcnt` tinyint(5) unsigned NOT NULL COMMENT 'item slot count',

  `slot1` int(10) unsigned DEFAULT NULL COMMENT 'stones on item slot1',

  `slot2` int(10) unsigned DEFAULT NULL COMMENT 'stones on item slot2',

  `slot3` int(10) unsigned DEFAULT NULL COMMENT 'stones on item slot3',

  `datax` int(10) unsigned DEFAULT NULL COMMENT 'item extension data x',

  `datay` int(10) unsigned DEFAULT NULL COMMENT 'item extension data y',

  `dataz` int(10) unsigned DEFAULT NULL COMMENT 'item extension data z'

) ENGINE=MyISAM DEFAULT CHARSET=latin1;









# Data exporting was unselected.

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

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