View Single Post
  #9  
Old 02-04-2022, 10:36 AM
Huppy's Avatar
Huppy
Demi-God
 
Join Date: Oct 2010
Posts: 1,332
Default

I apologize, missing that one merc player table when I dumped it all. Here's what you need:

Code:
DROP TABLE IF EXISTS `mercs`;
CREATE TABLE `mercs`  (
  `MercID` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `OwnerCharacterID` int(10) UNSIGNED NOT NULL,
  `Slot` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `Name` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `TemplateID` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `SuspendedTime` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `IsSuspended` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `TimerRemaining` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `Gender` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
  `MercSize` float NOT NULL DEFAULT 5,
  `StanceID` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
  `HP` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `Mana` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `Endurance` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `Face` int(10) UNSIGNED NOT NULL DEFAULT 1,
  `LuclinHairStyle` int(10) UNSIGNED NOT NULL DEFAULT 1,
  `LuclinHairColor` int(10) UNSIGNED NOT NULL DEFAULT 1,
  `LuclinEyeColor` int(10) UNSIGNED NOT NULL DEFAULT 1,
  `LuclinEyeColor2` int(10) UNSIGNED NOT NULL DEFAULT 1,
  `LuclinBeardColor` int(10) UNSIGNED NOT NULL DEFAULT 1,
  `LuclinBeard` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `DrakkinHeritage` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `DrakkinTattoo` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `DrakkinDetails` int(10) UNSIGNED NOT NULL DEFAULT 0,
  PRIMARY KEY (`MercID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;

SET FOREIGN_KEY_CHECKS = 1;
Reply With Quote