Alguem que tenha essas tabelas na Player

[Truta190 2]

se alguem tiver pode compartilhar?

 

https://imgur.com/YxZDO13

Edited June 2, 2018 by Truta190 (see edit history)

[Karbust 1,143]

Esta é a query completa, só dares copy-past e dar run...

 

-- ----------------------------
-- Table structure for player.player & player.delete
-- ----------------------------
ALTER TABLE `player`
ADD COLUMN `combat_zone_rank`  int(4) NOT NULL DEFAULT 0 AFTER `horse_skill_point`;
ALTER TABLE `player`
ADD COLUMN `combat_zone_points`  int(4) NOT NULL DEFAULT 0 AFTER `combat_zone_rank`;

ALTER TABLE `player_deleted`
ADD COLUMN `combat_zone_rank`  int(4) NOT NULL DEFAULT 0 AFTER `horse_skill_point`;
ALTER TABLE `player_deleted`
ADD COLUMN `combat_zone_points`  int(4) NOT NULL DEFAULT 0 AFTER `combat_zone_rank`;

-- ----------------------------
-- Table structure for combat_zone_ranking_general
-- ----------------------------
DROP TABLE IF EXISTS `combat_zone_ranking_general`;
CREATE TABLE `combat_zone_ranking_general`  (
  `memberName` varchar(12) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `memberEmpire` tinyint(4) NOT NULL,
  `memberPoints` int(11) NOT NULL,
  PRIMARY KEY (`memberName`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for combat_zone_ranking_weekly
-- ----------------------------
DROP TABLE IF EXISTS `combat_zone_ranking_weekly`;
CREATE TABLE `combat_zone_ranking_weekly`  (
  `memberName` varchar(12) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `memberEmpire` tinyint(4) NOT NULL,
  `memberPoints` int(11) NOT NULL,
  PRIMARY KEY (`memberName`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for combat_zone_skills_cache
-- ----------------------------
DROP TABLE IF EXISTS `combat_zone_skills_cache`;
CREATE TABLE `combat_zone_skills_cache`  (
  `pid` int(11) NOT NULL,
  `skillLevel1` int(11) NOT NULL,
  `skillLevel2` int(11) NOT NULL,
  `skillLevel3` int(11) NOT NULL,
  `skillLevel4` int(11) NOT NULL,
  `skillLevel5` int(11) NOT NULL,
  `skillLevel6` int(11) NOT NULL,
  PRIMARY KEY (`pid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;

 

[Truta190 2]

obrigado    , tem essa https://imgur.com/33e9wh4  ?