/Script/psquare_v1.sql

 1# --------------------------------------------------------
 2# Host:                         127.0.0.1
 3# Database:                     psquare
 4# Server version:               5.1.44-community
 5# Server OS:                    Win32
 6# HeidiSQL version:             5.0.0.3272
 7# Date/time:                    2010-11-20 23:17:02
 8# --------------------------------------------------------
 9
10/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
11/*!40101 SET NAMES utf8 */;
12/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
13/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
14# Dumping database structure for psquare
15CREATE DATABASE IF NOT EXISTS `psquare` /*!40100 DEFAULT CHARACTER SET latin1 */;
16USE `psquare`;
17
18# Dumping structure for table psquare.role
19CREATE TABLE IF NOT EXISTS `player` (
20  `pid` int(10) unsigned NOT NULL COMMENT 		'player unique id',
21  `name` varchar(32) NOT NULL COMMENT				'player unique name',
22  `gender` tinyint(5) unsigned NOT NULL COMMENT 'player  Gender',
23  `features` tinyint(5) unsigned NOT NULL COMMENT 'player  features ',
24  `money_g` int(10) unsigned NOT NULL COMMENT 'player money gold',
25  `money_s` int(10) unsigned NOT NULL COMMENT 'player money silver',
26  `datax` int(10) unsigned DEFAULT NULL COMMENT 'player extension data x',
27  `datay` int(10) unsigned DEFAULT NULL COMMENT 'player extension data y',
28  `dataz` int(10) unsigned DEFAULT NULL COMMENT 'player extension data z',
29  PRIMARY KEY (`pid`),
30  UNIQUE KEY `pid` (`pid`)
31) ENGINE=MyISAM DEFAULT CHARSET=latin1;
32
33# Dumping structure for table psquare.role
34CREATE TABLE IF NOT EXISTS `role` (
35  `rid` int(10) unsigned NOT NULL COMMENT 'role unique id',
36  `hid` smallint(10) NOT NULL COMMENT 'hero static id that the role belongs to',
37  `level` smallint(5) unsigned NOT NULL COMMENT 'role unique age',
38  `datax` int(10) unsigned DEFAULT NULL COMMENT 'role extension data x',
39  `datay` int(10) unsigned DEFAULT NULL COMMENT 'role extension data y',
40  `dataz` int(10) unsigned DEFAULT NULL COMMENT 'role extension data z',
41  PRIMARY KEY (`rid`),
42  UNIQUE KEY `rid` (`rid`)
43) ENGINE=MyISAM DEFAULT CHARSET=latin1;
44
45
46# Dumping structure for table psquare.item
47CREATE TABLE IF NOT EXISTS `item` (
48  `iid` int(10) unsigned NOT NULL COMMENT 'item id',
49  `pid` int(10) unsigned NOT NULL COMMENT 'owner player id',
50  `sid` int(10) unsigned NOT NULL COMMENT 'item static id',
51  `endurance` smallint(5) unsigned NOT NULL COMMENT 'item endurance',
52  `count` smallint(5) unsigned NOT NULL COMMENT 'item count',
53  `elvl` tinyint(5) unsigned NOT NULL COMMENT 'item enchant level',
54  `slotcnt` tinyint(5) unsigned NOT NULL COMMENT 'item slot count',
55  `slot1` int(10) unsigned DEFAULT NULL COMMENT 'stones on item slot1',
56  `slot2` int(10) unsigned DEFAULT NULL COMMENT 'stones on item slot2',
57  `slot3` int(10) unsigned DEFAULT NULL COMMENT 'stones on item slot3',
58  `datax` int(10) unsigned DEFAULT NULL COMMENT 'item extension data x',
59  `datay` int(10) unsigned DEFAULT NULL COMMENT 'item extension data y',
60  `dataz` int(10) unsigned DEFAULT NULL COMMENT 'item extension data z'
61) ENGINE=MyISAM DEFAULT CHARSET=latin1;
62
63
64
65
66# Data exporting was unselected.
67/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
68/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
69/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;