QdRaDP6b

1/*
2Navicat MySQL Data Transfer
3
4Source Server         : VIPMTRELOOAD
5Source Server Version : 50092
6Source Host           : root1.xzanderx.de:3306
7Source Database       : player
8
9Target Server Type    : MYSQL
10Target Server Version : 50092
11File Encoding         : 65001
12
13Date: 2011-10-07 17:13:06
14*/
15
16SET FOREIGN_KEY_CHECKS=0;
17
18-- ----------------------------
19-- Table structure for `affect`
20-- ----------------------------
21DROP TABLE IF EXISTS `affect`;
22CREATE TABLE `affect` (
23  `dwPID` int(10) unsigned NOT NULL default '0',
24  `bType` smallint(5) unsigned NOT NULL default '0',
25  `bApplyOn` tinyint(4) unsigned NOT NULL default '0',
26  `lApplyValue` int(11) NOT NULL default '0',
27  `dwFlag` int(10) unsigned NOT NULL default '0',
28  `lDuration` int(11) NOT NULL default '0',
29  `lSPCost` int(11) NOT NULL default '0',
30  PRIMARY KEY  (`dwPID`,`bType`,`bApplyOn`,`lApplyValue`)
31) ENGINE=MyISAM DEFAULT CHARSET=latin1;
32
33-- ----------------------------
34-- Records of affect
35-- ----------------------------
36INSERT INTO `affect` VALUES ('74', '512', '0', '0', '0', '536868831', '0');