SET NAMES utf8mb4;
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`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;
SET FOREIGN_KEY_CHECKS = 1;