/*
Navicat MySQL Data Transfer

Source Server         : VIPMTRELOOAD
Source Server Version : 50092
Source Host           : root1.xzanderx.de:3306
Source Database       : player

Target Server Type    : MYSQL
Target Server Version : 50092
File Encoding         : 65001

Date: 2011-10-07 17:13:06
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `affect`
-- ----------------------------
DROP TABLE IF EXISTS `affect`;
CREATE TABLE `affect` (
  `dwPID` int(10) unsigned NOT NULL default '0',
  `bType` smallint(5) unsigned NOT NULL default '0',
  `bApplyOn` tinyint(4) unsigned NOT NULL default '0',
  `lApplyValue` int(11) NOT NULL default '0',
  `dwFlag` int(10) unsigned NOT NULL default '0',
  `lDuration` int(11) NOT NULL default '0',
  `lSPCost` int(11) NOT NULL default '0',
  PRIMARY KEY  (`dwPID`,`bType`,`bApplyOn`,`lApplyValue`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of affect
-- ----------------------------
INSERT INTO `affect` VALUES ('74', '512', '0', '0', '0', '536868831', '0');