API tools faq
paste
Advertisement
Rochet2

Trinitycore DBstructure

Rochet2
Dec 19th, 2011
243
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 34.27 KB | None | 0 0
raw download clone embed print report
  1. # --------------------------------------------------------
  2. # Host:                         127.0.0.1
  3. # Server version:               5.5.11 - MySQL Community Server (GPL)
  4. # Server OS:                    Win64
  5. # HeidiSQL version:             6.0.0.3975
  6. # DATE/TIME:                    2011-12-19 12:37:52
  7. # --------------------------------------------------------
  8.  
  9. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  10. /*!40101 SET NAMES utf8 */;
  11. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  12. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  13.  
  14. # Dumping STRUCTURE FOR TABLE trin_world.creature_classlevelstats
  15. CREATE TABLE IF NOT EXISTS `creature_classlevelstats` (
  16.   `level` tinyint(1) NOT NULL,
  17.   `class` tinyint(1) NOT NULL,
  18.   `basehp0` SMALLINT(2) NOT NULL,
  19.   `basehp1` SMALLINT(2) NOT NULL,
  20.   `basehp2` SMALLINT(2) NOT NULL,
  21.   `basemana` SMALLINT(2) NOT NULL,
  22.   `basearmor` SMALLINT(2) NOT NULL
  23. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  24.  
  25. # DATA exporting was unselected.
  26.  
  27.  
  28. # Dumping STRUCTURE FOR TABLE trin_world.creature_equip_template
  29. CREATE TABLE IF NOT EXISTS `creature_equip_template` (
  30.   `entry` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  31.   `itemEntry1` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  32.   `itemEntry2` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  33.   `itemEntry3` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  34.   PRIMARY KEY (`entry`)
  35. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Creature System (Equipment)';
  36.  
  37. # DATA exporting was unselected.
  38.  
  39.  
  40. # Dumping STRUCTURE FOR TABLE trin_world.creature_involvedrelation
  41. CREATE TABLE IF NOT EXISTS `creature_involvedrelation` (
  42.   `id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Identifier',
  43.   `quest` mediumint(8) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Quest Identifier',
  44.   PRIMARY KEY (`id`,`quest`)
  45. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Creature System';
  46.  
  47. # DATA exporting was unselected.
  48.  
  49.  
  50. # Dumping STRUCTURE FOR TABLE trin_world.creature_loot_template
  51. CREATE TABLE IF NOT EXISTS `creature_loot_template` (
  52.   `entry` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  53.   `item` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  54.   `ChanceOrQuestChance` FLOAT NOT NULL DEFAULT '100',
  55.   `lootmode` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '1',
  56.   `groupid` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  57.   `mincountOrRef` mediumint(9) NOT NULL DEFAULT '1',
  58.   `maxcount` tinyint(3) UNSIGNED NOT NULL DEFAULT '1',
  59.   PRIMARY KEY (`entry`,`item`)
  60. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Loot System';
  61.  
  62. # DATA exporting was unselected.
  63.  
  64.  
  65. # Dumping STRUCTURE FOR TABLE trin_world.creature_questrelation
  66. CREATE TABLE IF NOT EXISTS `creature_questrelation` (
  67.   `id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Identifier',
  68.   `quest` mediumint(8) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Quest Identifier',
  69.   PRIMARY KEY (`id`,`quest`)
  70. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Creature System';
  71.  
  72. # DATA exporting was unselected.
  73.  
  74.  
  75. # Dumping STRUCTURE FOR TABLE trin_world.creature_template
  76. CREATE TABLE IF NOT EXISTS `creature_template` (
  77.   `entry` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  78.   `difficulty_entry_1` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  79.   `difficulty_entry_2` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  80.   `difficulty_entry_3` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  81.   `KillCredit1` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  82.   `KillCredit2` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  83.   `modelid1` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  84.   `modelid2` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  85.   `modelid3` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  86.   `modelid4` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  87.   `name` CHAR(100) NOT NULL DEFAULT '0',
  88.   `subname` CHAR(100) DEFAULT NULL,
  89.   `IconName` CHAR(100) DEFAULT NULL,
  90.   `gossip_menu_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  91.   `minlevel` tinyint(3) UNSIGNED NOT NULL DEFAULT '1',
  92.   `maxlevel` tinyint(3) UNSIGNED NOT NULL DEFAULT '1',
  93.   `exp` SMALLINT(2) NOT NULL DEFAULT '0',
  94.   `faction_A` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  95.   `faction_H` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  96.   `npcflag` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  97.   `speed_walk` FLOAT NOT NULL DEFAULT '1' COMMENT 'Result of 2.5/2.5, most common value',
  98.   `speed_run` FLOAT NOT NULL DEFAULT '1.14286' COMMENT 'Result of 8.0/7.0, most common value',
  99.   `scale` FLOAT NOT NULL DEFAULT '1',
  100.   `rank` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  101.   `mindmg` FLOAT NOT NULL DEFAULT '0',
  102.   `maxdmg` FLOAT NOT NULL DEFAULT '0',
  103.   `dmgschool` tinyint(4) NOT NULL DEFAULT '0',
  104.   `attackpower` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  105.   `dmg_multiplier` FLOAT NOT NULL DEFAULT '1',
  106.   `baseattacktime` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  107.   `rangeattacktime` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  108.   `unit_class` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  109.   `unit_flags` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  110.   `dynamicflags` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  111.   `family` tinyint(4) NOT NULL DEFAULT '0',
  112.   `trainer_type` tinyint(4) NOT NULL DEFAULT '0',
  113.   `trainer_spell` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  114.   `trainer_class` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  115.   `trainer_race` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  116.   `minrangedmg` FLOAT NOT NULL DEFAULT '0',
  117.   `maxrangedmg` FLOAT NOT NULL DEFAULT '0',
  118.   `rangedattackpower` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  119.   `type` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  120.   `type_flags` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  121.   `lootid` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  122.   `pickpocketloot` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  123.   `skinloot` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  124.   `resistance1` SMALLINT(5) NOT NULL DEFAULT '0',
  125.   `resistance2` SMALLINT(5) NOT NULL DEFAULT '0',
  126.   `resistance3` SMALLINT(5) NOT NULL DEFAULT '0',
  127.   `resistance4` SMALLINT(5) NOT NULL DEFAULT '0',
  128.   `resistance5` SMALLINT(5) NOT NULL DEFAULT '0',
  129.   `resistance6` SMALLINT(5) NOT NULL DEFAULT '0',
  130.   `spell1` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  131.   `spell2` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  132.   `spell3` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  133.   `spell4` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  134.   `spell5` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  135.   `spell6` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  136.   `spell7` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  137.   `spell8` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  138.   `PetSpellDataId` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  139.   `VehicleId` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  140.   `mingold` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  141.   `maxgold` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  142.   `AIName` CHAR(64) NOT NULL DEFAULT '',
  143.   `MovementType` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  144.   `InhabitType` tinyint(3) UNSIGNED NOT NULL DEFAULT '3',
  145.   `Health_mod` FLOAT NOT NULL DEFAULT '1',
  146.   `Mana_mod` FLOAT NOT NULL DEFAULT '1',
  147.   `Armor_mod` FLOAT NOT NULL DEFAULT '1',
  148.   `RacialLeader` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  149.   `questItem1` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  150.   `questItem2` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  151.   `questItem3` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  152.   `questItem4` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  153.   `questItem5` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  154.   `questItem6` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  155.   `movementId` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  156.   `RegenHealth` tinyint(3) UNSIGNED NOT NULL DEFAULT '1',
  157.   `equipment_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  158.   `mechanic_immune_mask` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  159.   `flags_extra` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  160.   `ScriptName` CHAR(64) NOT NULL DEFAULT '',
  161.   `WDBVerified` SMALLINT(5) DEFAULT '1',
  162.   PRIMARY KEY (`entry`),
  163.   KEY `idx_name` (`name`)
  164. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Creature System';
  165.  
  166. # DATA exporting was unselected.
  167.  
  168.  
  169. # Dumping STRUCTURE FOR TABLE trin_world.gameobject_involvedrelation
  170. CREATE TABLE IF NOT EXISTS `gameobject_involvedrelation` (
  171.   `id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  172.   `quest` mediumint(8) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Quest Identifier',
  173.   PRIMARY KEY (`id`,`quest`)
  174. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  175.  
  176. # DATA exporting was unselected.
  177.  
  178.  
  179. # Dumping STRUCTURE FOR TABLE trin_world.gameobject_loot_template
  180. CREATE TABLE IF NOT EXISTS `gameobject_loot_template` (
  181.   `entry` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  182.   `item` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  183.   `ChanceOrQuestChance` FLOAT NOT NULL DEFAULT '100',
  184.   `lootmode` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '1',
  185.   `groupid` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  186.   `mincountOrRef` mediumint(9) NOT NULL DEFAULT '1',
  187.   `maxcount` tinyint(3) UNSIGNED NOT NULL DEFAULT '1',
  188.   PRIMARY KEY (`entry`,`item`)
  189. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Loot System';
  190.  
  191. # DATA exporting was unselected.
  192.  
  193.  
  194. # Dumping STRUCTURE FOR TABLE trin_world.gameobject_questrelation
  195. CREATE TABLE IF NOT EXISTS `gameobject_questrelation` (
  196.   `id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  197.   `quest` mediumint(8) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Quest Identifier',
  198.   PRIMARY KEY (`id`,`quest`)
  199. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  200.  
  201. # DATA exporting was unselected.
  202.  
  203.  
  204. # Dumping STRUCTURE FOR TABLE trin_world.gameobject_template
  205. CREATE TABLE IF NOT EXISTS `gameobject_template` (
  206.   `entry` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  207.   `type` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  208.   `displayId` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  209.   `name` VARCHAR(100) NOT NULL DEFAULT '',
  210.   `IconName` VARCHAR(100) NOT NULL DEFAULT '',
  211.   `castBarCaption` VARCHAR(100) NOT NULL DEFAULT '',
  212.   `unk1` VARCHAR(100) NOT NULL DEFAULT '',
  213.   `faction` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  214.   `flags` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  215.   `size` FLOAT NOT NULL DEFAULT '1',
  216.   `questItem1` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  217.   `questItem2` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  218.   `questItem3` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  219.   `questItem4` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  220.   `questItem5` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  221.   `questItem6` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  222.   `data0` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  223.   `data1` INT(11) NOT NULL DEFAULT '-1',
  224.   `data2` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  225.   `data3` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  226.   `data4` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  227.   `data5` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  228.   `data6` INT(11) NOT NULL DEFAULT '-1',
  229.   `data7` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  230.   `data8` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  231.   `data9` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  232.   `data10` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  233.   `data11` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  234.   `data12` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  235.   `data13` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  236.   `data14` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  237.   `data15` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  238.   `data16` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  239.   `data17` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  240.   `data18` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  241.   `data19` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  242.   `data20` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  243.   `data21` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  244.   `data22` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  245.   `data23` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  246.   `AIName` CHAR(64) NOT NULL DEFAULT '',
  247.   `ScriptName` VARCHAR(64) NOT NULL DEFAULT '',
  248.   `WDBVerified` SMALLINT(5) DEFAULT '1',
  249.   PRIMARY KEY (`entry`),
  250.   KEY `idx_name` (`name`)
  251. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Gameobject System';
  252.  
  253. # DATA exporting was unselected.
  254.  
  255.  
  256. # Dumping STRUCTURE FOR TABLE trin_world.item_loot_template
  257. CREATE TABLE IF NOT EXISTS `item_loot_template` (
  258.   `entry` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  259.   `item` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  260.   `ChanceOrQuestChance` FLOAT NOT NULL DEFAULT '100',
  261.   `lootmode` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '1',
  262.   `groupid` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  263.   `mincountOrRef` mediumint(9) NOT NULL DEFAULT '1',
  264.   `maxcount` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '1',
  265.   PRIMARY KEY (`entry`,`item`)
  266. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System';
  267.  
  268. # DATA exporting was unselected.
  269.  
  270.  
  271. # Dumping STRUCTURE FOR TABLE trin_world.item_template
  272. CREATE TABLE IF NOT EXISTS `item_template` (
  273.   `entry` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  274.   `class` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  275.   `subclass` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  276.   `unk0` INT(11) NOT NULL DEFAULT '-1',
  277.   `name` VARCHAR(255) NOT NULL DEFAULT '',
  278.   `displayid` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  279.   `Quality` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  280.   `Flags` BIGINT(20) NOT NULL DEFAULT '0',
  281.   `FlagsExtra` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  282.   `BuyCount` tinyint(3) UNSIGNED NOT NULL DEFAULT '1',
  283.   `BuyPrice` BIGINT(20) NOT NULL DEFAULT '0',
  284.   `SellPrice` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  285.   `InventoryType` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  286.   `AllowableClass` INT(11) NOT NULL DEFAULT '-1',
  287.   `AllowableRace` INT(11) NOT NULL DEFAULT '-1',
  288.   `ItemLevel` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  289.   `RequiredLevel` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  290.   `RequiredSkill` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  291.   `RequiredSkillRank` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  292.   `requiredspell` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  293.   `requiredhonorrank` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  294.   `RequiredCityRank` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  295.   `RequiredReputationFaction` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  296.   `RequiredReputationRank` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  297.   `maxcount` INT(11) NOT NULL DEFAULT '0',
  298.   `stackable` INT(11) DEFAULT '1',
  299.   `ContainerSlots` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  300.   `StatsCount` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  301.   `stat_type1` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  302.   `stat_value1` SMALLINT(6) NOT NULL DEFAULT '0',
  303.   `stat_type2` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  304.   `stat_value2` SMALLINT(6) NOT NULL DEFAULT '0',
  305.   `stat_type3` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  306.   `stat_value3` SMALLINT(6) NOT NULL DEFAULT '0',
  307.   `stat_type4` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  308.   `stat_value4` SMALLINT(6) NOT NULL DEFAULT '0',
  309.   `stat_type5` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  310.   `stat_value5` SMALLINT(6) NOT NULL DEFAULT '0',
  311.   `stat_type6` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  312.   `stat_value6` SMALLINT(6) NOT NULL DEFAULT '0',
  313.   `stat_type7` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  314.   `stat_value7` SMALLINT(6) NOT NULL DEFAULT '0',
  315.   `stat_type8` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  316.   `stat_value8` SMALLINT(6) NOT NULL DEFAULT '0',
  317.   `stat_type9` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  318.   `stat_value9` SMALLINT(6) NOT NULL DEFAULT '0',
  319.   `stat_type10` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  320.   `stat_value10` SMALLINT(6) NOT NULL DEFAULT '0',
  321.   `ScalingStatDistribution` SMALLINT(6) NOT NULL DEFAULT '0',
  322.   `ScalingStatValue` INT(6) UNSIGNED NOT NULL DEFAULT '0',
  323.   `dmg_min1` FLOAT NOT NULL DEFAULT '0',
  324.   `dmg_max1` FLOAT NOT NULL DEFAULT '0',
  325.   `dmg_type1` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  326.   `dmg_min2` FLOAT NOT NULL DEFAULT '0',
  327.   `dmg_max2` FLOAT NOT NULL DEFAULT '0',
  328.   `dmg_type2` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  329.   `armor` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  330.   `holy_res` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  331.   `fire_res` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  332.   `nature_res` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  333.   `frost_res` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  334.   `shadow_res` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  335.   `arcane_res` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  336.   `delay` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '1000',
  337.   `ammo_type` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  338.   `RangedModRange` FLOAT NOT NULL DEFAULT '0',
  339.   `spellid_1` mediumint(8) NOT NULL DEFAULT '0',
  340.   `spelltrigger_1` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  341.   `spellcharges_1` SMALLINT(4) DEFAULT NULL,
  342.   `spellppmRate_1` FLOAT NOT NULL DEFAULT '0',
  343.   `spellcooldown_1` INT(11) NOT NULL DEFAULT '-1',
  344.   `spellcategory_1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  345.   `spellcategorycooldown_1` INT(11) NOT NULL DEFAULT '-1',
  346.   `spellid_2` mediumint(8) NOT NULL DEFAULT '0',
  347.   `spelltrigger_2` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  348.   `spellcharges_2` SMALLINT(4) DEFAULT NULL,
  349.   `spellppmRate_2` FLOAT NOT NULL DEFAULT '0',
  350.   `spellcooldown_2` INT(11) NOT NULL DEFAULT '-1',
  351.   `spellcategory_2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  352.   `spellcategorycooldown_2` INT(11) NOT NULL DEFAULT '-1',
  353.   `spellid_3` mediumint(8) NOT NULL DEFAULT '0',
  354.   `spelltrigger_3` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  355.   `spellcharges_3` SMALLINT(4) DEFAULT NULL,
  356.   `spellppmRate_3` FLOAT NOT NULL DEFAULT '0',
  357.   `spellcooldown_3` INT(11) NOT NULL DEFAULT '-1',
  358.   `spellcategory_3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  359.   `spellcategorycooldown_3` INT(11) NOT NULL DEFAULT '-1',
  360.   `spellid_4` mediumint(8) NOT NULL DEFAULT '0',
  361.   `spelltrigger_4` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  362.   `spellcharges_4` SMALLINT(4) DEFAULT NULL,
  363.   `spellppmRate_4` FLOAT NOT NULL DEFAULT '0',
  364.   `spellcooldown_4` INT(11) NOT NULL DEFAULT '-1',
  365.   `spellcategory_4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  366.   `spellcategorycooldown_4` INT(11) NOT NULL DEFAULT '-1',
  367.   `spellid_5` mediumint(8) NOT NULL DEFAULT '0',
  368.   `spelltrigger_5` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  369.   `spellcharges_5` SMALLINT(4) DEFAULT NULL,
  370.   `spellppmRate_5` FLOAT NOT NULL DEFAULT '0',
  371.   `spellcooldown_5` INT(11) NOT NULL DEFAULT '-1',
  372.   `spellcategory_5` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  373.   `spellcategorycooldown_5` INT(11) NOT NULL DEFAULT '-1',
  374.   `bonding` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  375.   `description` VARCHAR(255) NOT NULL DEFAULT '',
  376.   `PageText` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  377.   `LanguageID` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  378.   `PageMaterial` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  379.   `startquest` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  380.   `lockid` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  381.   `Material` tinyint(4) NOT NULL DEFAULT '0',
  382.   `sheath` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  383.   `RandomProperty` mediumint(8) NOT NULL DEFAULT '0',
  384.   `RandomSuffix` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  385.   `block` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  386.   `itemset` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  387.   `MaxDurability` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  388.   `area` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  389.   `Map` SMALLINT(6) NOT NULL DEFAULT '0',
  390.   `BagFamily` mediumint(9) NOT NULL DEFAULT '0',
  391.   `TotemCategory` mediumint(9) NOT NULL DEFAULT '0',
  392.   `socketColor_1` tinyint(4) NOT NULL DEFAULT '0',
  393.   `socketContent_1` mediumint(9) NOT NULL DEFAULT '0',
  394.   `socketColor_2` tinyint(4) NOT NULL DEFAULT '0',
  395.   `socketContent_2` mediumint(9) NOT NULL DEFAULT '0',
  396.   `socketColor_3` tinyint(4) NOT NULL DEFAULT '0',
  397.   `socketContent_3` mediumint(9) NOT NULL DEFAULT '0',
  398.   `socketBonus` mediumint(9) NOT NULL DEFAULT '0',
  399.   `GemProperties` mediumint(9) NOT NULL DEFAULT '0',
  400.   `RequiredDisenchantSkill` SMALLINT(6) NOT NULL DEFAULT '-1',
  401.   `ArmorDamageModifier` FLOAT NOT NULL DEFAULT '0',
  402.   `Duration` INT(11) NOT NULL DEFAULT '0' COMMENT 'Duration in seconds. Negative value means realtime, postive value ingame time',
  403.   `ItemLimitCategory` SMALLINT(6) NOT NULL DEFAULT '0',
  404.   `HolidayId` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  405.   `ScriptName` VARCHAR(64) NOT NULL DEFAULT '',
  406.   `DisenchantID` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  407.   `FoodType` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  408.   `minMoneyLoot` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  409.   `maxMoneyLoot` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  410.   `WDBVerified` SMALLINT(5) DEFAULT '1',
  411.   PRIMARY KEY (`entry`),
  412.   KEY `idx_name` (`name`),
  413.   KEY `items_index` (`class`)
  414. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Item System';
  415.  
  416. # DATA exporting was unselected.
  417.  
  418.  
  419. # Dumping STRUCTURE FOR TABLE trin_world.npc_text
  420. CREATE TABLE IF NOT EXISTS `npc_text` (
  421.   `ID` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  422.   `text0_0` longtext,
  423.   `text0_1` longtext,
  424.   `lang0` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  425.   `prob0` FLOAT NOT NULL DEFAULT '0',
  426.   `em0_0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  427.   `em0_1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  428.   `em0_2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  429.   `em0_3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  430.   `em0_4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  431.   `em0_5` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  432.   `text1_0` longtext,
  433.   `text1_1` longtext,
  434.   `lang1` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  435.   `prob1` FLOAT NOT NULL DEFAULT '0',
  436.   `em1_0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  437.   `em1_1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  438.   `em1_2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  439.   `em1_3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  440.   `em1_4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  441.   `em1_5` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  442.   `text2_0` longtext,
  443.   `text2_1` longtext,
  444.   `lang2` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  445.   `prob2` FLOAT NOT NULL DEFAULT '0',
  446.   `em2_0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  447.   `em2_1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  448.   `em2_2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  449.   `em2_3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  450.   `em2_4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  451.   `em2_5` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  452.   `text3_0` longtext,
  453.   `text3_1` longtext,
  454.   `lang3` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  455.   `prob3` FLOAT NOT NULL DEFAULT '0',
  456.   `em3_0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  457.   `em3_1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  458.   `em3_2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  459.   `em3_3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  460.   `em3_4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  461.   `em3_5` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  462.   `text4_0` longtext,
  463.   `text4_1` longtext,
  464.   `lang4` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  465.   `prob4` FLOAT NOT NULL DEFAULT '0',
  466.   `em4_0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  467.   `em4_1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  468.   `em4_2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  469.   `em4_3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  470.   `em4_4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  471.   `em4_5` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  472.   `text5_0` longtext,
  473.   `text5_1` longtext,
  474.   `lang5` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  475.   `prob5` FLOAT NOT NULL DEFAULT '0',
  476.   `em5_0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  477.   `em5_1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  478.   `em5_2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  479.   `em5_3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  480.   `em5_4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  481.   `em5_5` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  482.   `text6_0` longtext,
  483.   `text6_1` longtext,
  484.   `lang6` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  485.   `prob6` FLOAT NOT NULL DEFAULT '0',
  486.   `em6_0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  487.   `em6_1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  488.   `em6_2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  489.   `em6_3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  490.   `em6_4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  491.   `em6_5` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  492.   `text7_0` longtext,
  493.   `text7_1` longtext,
  494.   `lang7` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  495.   `prob7` FLOAT NOT NULL DEFAULT '0',
  496.   `em7_0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  497.   `em7_1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  498.   `em7_2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  499.   `em7_3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  500.   `em7_4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  501.   `em7_5` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  502.   `WDBVerified` SMALLINT(5) DEFAULT '1',
  503.   PRIMARY KEY (`ID`)
  504. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  505.  
  506. # DATA exporting was unselected.
  507.  
  508.  
  509. # Dumping STRUCTURE FOR TABLE trin_world.npc_trainer
  510. CREATE TABLE IF NOT EXISTS `npc_trainer` (
  511.   `entry` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  512.   `spell` mediumint(8) NOT NULL DEFAULT '0',
  513.   `spellcost` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  514.   `reqskill` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  515.   `reqskillvalue` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  516.   `reqlevel` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  517.   PRIMARY KEY (`entry`,`spell`)
  518. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  519.  
  520. # DATA exporting was unselected.
  521.  
  522.  
  523. # Dumping STRUCTURE FOR TABLE trin_world.npc_vendor
  524. CREATE TABLE IF NOT EXISTS `npc_vendor` (
  525.   `entry` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  526.   `slot` SMALLINT(6) NOT NULL DEFAULT '0',
  527.   `item` mediumint(8) NOT NULL DEFAULT '0',
  528.   `maxcount` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  529.   `incrtime` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  530.   `ExtendedCost` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  531.   PRIMARY KEY (`entry`,`item`,`ExtendedCost`),
  532.   KEY `slot` (`slot`)
  533. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Npc System';
  534.  
  535. # DATA exporting was unselected.
  536.  
  537.  
  538. # Dumping STRUCTURE FOR TABLE trin_world.page_text
  539. CREATE TABLE IF NOT EXISTS `page_text` (
  540.   `entry` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  541.   `text` longtext NOT NULL,
  542.   `next_page` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  543.   `WDBVerified` SMALLINT(5) DEFAULT '1',
  544.   PRIMARY KEY (`entry`)
  545. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Item System';
  546.  
  547. # DATA exporting was unselected.
  548.  
  549.  
  550. # Dumping STRUCTURE FOR TABLE trin_world.quest_template
  551. CREATE TABLE IF NOT EXISTS `quest_template` (
  552.   `entry` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  553.   `Method` tinyint(3) UNSIGNED NOT NULL DEFAULT '2',
  554.   `ZoneOrSort` SMALLINT(6) NOT NULL DEFAULT '0',
  555.   `SkillOrClassMask` mediumint(8) NOT NULL DEFAULT '0',
  556.   `MinLevel` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  557.   `MaxLevel` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  558.   `QuestLevel` SMALLINT(3) NOT NULL DEFAULT '1',
  559.   `Type` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  560.   `RequiredRaces` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  561.   `RequiredSkillValue` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  562.   `RepObjectiveFaction` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  563.   `RepObjectiveValue` mediumint(9) NOT NULL DEFAULT '0',
  564.   `RepObjectiveFaction2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  565.   `RepObjectiveValue2` mediumint(9) NOT NULL DEFAULT '0',
  566.   `RequiredMinRepFaction` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  567.   `RequiredMinRepValue` mediumint(9) NOT NULL DEFAULT '0',
  568.   `RequiredMaxRepFaction` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  569.   `RequiredMaxRepValue` mediumint(9) NOT NULL DEFAULT '0',
  570.   `SuggestedPlayers` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  571.   `LimitTime` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  572.   `QuestFlags` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  573.   `SpecialFlags` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  574.   `CharTitleId` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  575.   `PlayersSlain` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  576.   `BonusTalents` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  577.   `RewardArenaPoints` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  578.   `PrevQuestId` mediumint(9) NOT NULL DEFAULT '0',
  579.   `NextQuestId` mediumint(9) NOT NULL DEFAULT '0',
  580.   `ExclusiveGroup` mediumint(9) NOT NULL DEFAULT '0',
  581.   `NextQuestInChain` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  582.   `RewXPId` tinyint(2) UNSIGNED NOT NULL DEFAULT '0',
  583.   `SrcItemId` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  584.   `SrcItemCount` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  585.   `SrcSpell` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  586.   `Title` text,
  587.   `Details` text,
  588.   `Objectives` text,
  589.   `OfferRewardText` text,
  590.   `RequestItemsText` text,
  591.   `EndText` text,
  592.   `CompletedText` text,
  593.   `ObjectiveText1` text,
  594.   `ObjectiveText2` text,
  595.   `ObjectiveText3` text,
  596.   `ObjectiveText4` text,
  597.   `ReqItemId1` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  598.   `ReqItemId2` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  599.   `ReqItemId3` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  600.   `ReqItemId4` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  601.   `ReqItemId5` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  602.   `ReqItemId6` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  603.   `ReqItemCount1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  604.   `ReqItemCount2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  605.   `ReqItemCount3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  606.   `ReqItemCount4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  607.   `ReqItemCount5` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  608.   `ReqItemCount6` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  609.   `ReqSourceId1` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  610.   `ReqSourceId2` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  611.   `ReqSourceId3` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  612.   `ReqSourceId4` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  613.   `ReqSourceCount1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  614.   `ReqSourceCount2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  615.   `ReqSourceCount3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  616.   `ReqSourceCount4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  617.   `ReqCreatureOrGOId1` mediumint(9) NOT NULL DEFAULT '0',
  618.   `ReqCreatureOrGOId2` mediumint(9) NOT NULL DEFAULT '0',
  619.   `ReqCreatureOrGOId3` mediumint(9) NOT NULL DEFAULT '0',
  620.   `ReqCreatureOrGOId4` mediumint(9) NOT NULL DEFAULT '0',
  621.   `ReqCreatureOrGOCount1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  622.   `ReqCreatureOrGOCount2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  623.   `ReqCreatureOrGOCount3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  624.   `ReqCreatureOrGOCount4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  625.   `ReqSpellCast1` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  626.   `ReqSpellCast2` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  627.   `ReqSpellCast3` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  628.   `ReqSpellCast4` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  629.   `RewChoiceItemId1` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  630.   `RewChoiceItemId2` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  631.   `RewChoiceItemId3` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  632.   `RewChoiceItemId4` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  633.   `RewChoiceItemId5` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  634.   `RewChoiceItemId6` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  635.   `RewChoiceItemCount1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  636.   `RewChoiceItemCount2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  637.   `RewChoiceItemCount3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  638.   `RewChoiceItemCount4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  639.   `RewChoiceItemCount5` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  640.   `RewChoiceItemCount6` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  641.   `RewItemId1` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  642.   `RewItemId2` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  643.   `RewItemId3` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  644.   `RewItemId4` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  645.   `RewItemCount1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  646.   `RewItemCount2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  647.   `RewItemCount3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  648.   `RewItemCount4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  649.   `RewRepFaction1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
  650.   `RewRepFaction2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
  651.   `RewRepFaction3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
  652.   `RewRepFaction4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
  653.   `RewRepFaction5` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
  654.   `RewRepValueId1` mediumint(6) NOT NULL DEFAULT '0',
  655.   `RewRepValueId2` mediumint(6) NOT NULL DEFAULT '0',
  656.   `RewRepValueId3` mediumint(6) NOT NULL DEFAULT '0',
  657.   `RewRepValueId4` mediumint(6) NOT NULL DEFAULT '0',
  658.   `RewRepValueId5` mediumint(6) NOT NULL DEFAULT '0',
  659.   `RewRepValue1` mediumint(9) NOT NULL DEFAULT '0',
  660.   `RewRepValue2` mediumint(9) NOT NULL DEFAULT '0',
  661.   `RewRepValue3` mediumint(9) NOT NULL DEFAULT '0',
  662.   `RewRepValue4` mediumint(9) NOT NULL DEFAULT '0',
  663.   `RewRepValue5` mediumint(9) NOT NULL DEFAULT '0',
  664.   `RewHonorAddition` INT(10) NOT NULL DEFAULT '0',
  665.   `RewHonorMultiplier` FLOAT NOT NULL DEFAULT '1',
  666.   `unk0` tinyint(2) UNSIGNED NOT NULL DEFAULT '0',
  667.   `RewOrReqMoney` INT(11) NOT NULL DEFAULT '0',
  668.   `RewMoneyMaxLevel` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  669.   `RewSpell` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  670.   `RewSpellCast` INT(11) NOT NULL DEFAULT '0',
  671.   `RewMailTemplateId` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  672.   `RewMailDelaySecs` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  673.   `PointMapId` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  674.   `PointX` FLOAT NOT NULL DEFAULT '0',
  675.   `PointY` FLOAT NOT NULL DEFAULT '0',
  676.   `PointOpt` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  677.   `DetailsEmote1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  678.   `DetailsEmote2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  679.   `DetailsEmote3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  680.   `DetailsEmote4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  681.   `DetailsEmoteDelay1` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  682.   `DetailsEmoteDelay2` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  683.   `DetailsEmoteDelay3` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  684.   `DetailsEmoteDelay4` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  685.   `IncompleteEmote` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  686.   `CompleteEmote` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  687.   `OfferRewardEmote1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  688.   `OfferRewardEmote2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  689.   `OfferRewardEmote3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  690.   `OfferRewardEmote4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  691.   `OfferRewardEmoteDelay1` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  692.   `OfferRewardEmoteDelay2` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  693.   `OfferRewardEmoteDelay3` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  694.   `OfferRewardEmoteDelay4` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  695.   `StartScript` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  696.   `CompleteScript` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  697.   `WDBVerified` SMALLINT(5) DEFAULT '1',
  698.   PRIMARY KEY (`entry`)
  699. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Quest System';
  700.  
  701. # DATA exporting was unselected.
  702. /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  703. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  704. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!