Advertisement
Rochet2

Dress NPCs DB

Sep 27th, 2013
567
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.95 KB | None | 0 0
  1. -- --------------------------------------------------------
  2. -- Host:                         localhost
  3. -- Server version:               5.6.10 - MySQL Community Server (GPL)
  4. -- Server OS:                    Win64
  5. -- HeidiSQL Version:             8.0.0.4491
  6. -- --------------------------------------------------------
  7.  
  8. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  9. /*!40101 SET NAMES utf8 */;
  10. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  11. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  12.  
  13. -- Dumping structure for table e2_w.creature_template_outfits
  14. CREATE TABLE IF NOT EXISTS `creature_template_outfits` (
  15.   `entry` INT(10) UNSIGNED NOT NULL,
  16.   `race` tinyint(3) UNSIGNED NOT NULL DEFAULT '1',
  17.   `gender` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '0 for male, 1 for female',
  18.   `skin` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  19.   `face` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  20.   `hair` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  21.   `haircolor` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  22.   `facialhair` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  23.   `head` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  24.   `shoulders` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  25.   `body` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  26.   `chest` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  27.   `waist` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  28.   `legs` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  29.   `feet` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  30.   `wrists` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  31.   `hands` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  32.   `back` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  33.   `tabard` INT(10) UNSIGNED NOT NULL DEFAULT '0'
  34. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  35.  
  36. -- Data exporting was unselected.
  37. /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
  38. /*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
  39. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement