/addition/161_mangos_spell_dbc.sql

https://github.com/Gengeru/mangos · SQL · 104 lines · 103 code · 1 blank · 0 comment · 0 complexity · effcfaba6936237bf5def2df983d3e0a MD5 · raw file 

    

  1. DROP TABLE IF EXISTS `spell_dbc`;
    2. 

  2. CREATE TABLE `spell_dbc` (
    3. 

  3.   `Id` int(10) unsigned NOT NULL,
    4. 

  4.   `Dispel` tinyint(3) unsigned NOT NULL DEFAULT '0',
    5. 

  5.   `Mechanic` tinyint(3) unsigned NOT NULL DEFAULT '0',
    6. 

  6.   `Attributes` int(10) unsigned NOT NULL DEFAULT '0',
    7. 

  7.   `AttributesEx` int(10) unsigned NOT NULL DEFAULT '0',
    8. 

  8.   `AttributesEx2` int(10) unsigned NOT NULL DEFAULT '0',
    9. 

  9.   `AttributesEx3` int(10) unsigned NOT NULL DEFAULT '0',
    10. 

  10.   `AttributesEx4` int(10) unsigned NOT NULL DEFAULT '0',
    11. 

  11.   `AttributesEx5` int(10) unsigned NOT NULL DEFAULT '0',
    12. 

  12.   `Stances` tinyint(3) unsigned NOT NULL DEFAULT '0',
    13. 

  13.   `Targets` int(10) unsigned NOT NULL DEFAULT '0',
    14. 

  14.   `CastingTimeIndex` tinyint(3) unsigned NOT NULL DEFAULT '1',
    15. 

  15.   `AuraInterruptFlags` int(10) unsigned NOT NULL DEFAULT '0',
    16. 

  16.   `ProcFlags` int(10) unsigned NOT NULL DEFAULT '0',
    17. 

  17.   `ProcChance` tinyint(3) unsigned NOT NULL DEFAULT '0',
    18. 

  18.   `ProcCharges` tinyint(3) unsigned NOT NULL DEFAULT '0',
    19. 

  19.   `MaxLevel` tinyint(3) unsigned NOT NULL DEFAULT '0',
    20. 

  20.   `BaseLevel` tinyint(3) unsigned NOT NULL DEFAULT '0',
    21. 

  21.   `SpellLevel` tinyint(3) unsigned NOT NULL DEFAULT '0',
    22. 

  22.   `DurationIndex` smallint(5) unsigned NOT NULL DEFAULT '0',
    23. 

  23.   `RangeIndex` tinyint(3) unsigned NOT NULL DEFAULT '1',
    24. 

  24.   `StackAmount` tinyint(3) unsigned NOT NULL DEFAULT '0',
    25. 

  25.   `EquippedItemClass` int(11) NOT NULL DEFAULT '-1',
    26. 

  26.   `EquippedItemSubClassMask` int(11) NOT NULL DEFAULT '0',
    27. 

  27.   `EquippedItemInventoryTypeMask` int(11) NOT NULL DEFAULT '0',
    28. 

  28.   `Effect1` tinyint(3) unsigned NOT NULL DEFAULT '0',
    29. 

  29.   `Effect2` tinyint(3) unsigned NOT NULL DEFAULT '0',
    30. 

  30.   `Effect3` tinyint(3) unsigned NOT NULL DEFAULT '0',
    31. 

  31.   `EffectDieSides1` int(11) NOT NULL DEFAULT '0',
    32. 

  32.   `EffectDieSides2` int(11) NOT NULL DEFAULT '0',
    33. 

  33.   `EffectDieSides3` int(11) NOT NULL DEFAULT '0',
    34. 

  34.   `EffectRealPointsPerLevel1` float NOT NULL DEFAULT '0',
    35. 

  35.   `EffectRealPointsPerLevel2` float NOT NULL DEFAULT '0',
    36. 

  36.   `EffectRealPointsPerLevel3` float NOT NULL DEFAULT '0',
    37. 

  37.   `EffectBasePoints1` int(11) NOT NULL DEFAULT '0',
    38. 

  38.   `EffectBasePoints2` int(11) NOT NULL DEFAULT '0',
    39. 

  39.   `EffectBasePoints3` int(11) NOT NULL DEFAULT '0',
    40. 

  40.   `EffectMechanic1` tinyint(3) unsigned NOT NULL DEFAULT '0',
    41. 

  41.   `EffectMechanic2` tinyint(3) unsigned NOT NULL DEFAULT '0',
    42. 

  42.   `EffectMechanic3` tinyint(3) unsigned NOT NULL DEFAULT '0',
    43. 

  43.   `EffectImplicitTargetA1` tinyint(3) unsigned NOT NULL DEFAULT '0',
    44. 

  44.   `EffectImplicitTargetA2` tinyint(3) unsigned NOT NULL DEFAULT '0',
    45. 

  45.   `EffectImplicitTargetA3` tinyint(3) unsigned NOT NULL DEFAULT '0',
    46. 

  46.   `EffectImplicitTargetB1` tinyint(3) unsigned NOT NULL DEFAULT '0',
    47. 

  47.   `EffectImplicitTargetB2` tinyint(3) unsigned NOT NULL DEFAULT '0',
    48. 

  48.   `EffectImplicitTargetB3` tinyint(3) unsigned NOT NULL DEFAULT '0',
    49. 

  49.   `EffectRadiusIndex1` tinyint(3) unsigned NOT NULL DEFAULT '0',
    50. 

  50.   `EffectRadiusIndex2` tinyint(3) unsigned NOT NULL DEFAULT '0',
    51. 

  51.   `EffectRadiusIndex3` tinyint(3) unsigned NOT NULL DEFAULT '0',
    52. 

  52.   `EffectApplyAuraName1` smallint(5) unsigned NOT NULL DEFAULT '0',
    53. 

  53.   `EffectApplyAuraName2` smallint(5) unsigned NOT NULL DEFAULT '0',
    54. 

  54.   `EffectApplyAuraName3` smallint(5) unsigned NOT NULL DEFAULT '0',
    55. 

  55.   `EffectAmplitude1` int(11) NOT NULL DEFAULT '0',
    56. 

  56.   `EffectAmplitude2` int(11) NOT NULL DEFAULT '0',
    57. 

  57.   `EffectAmplitude3` int(11) NOT NULL DEFAULT '0',
    58. 

  58.   `EffectMultipleValue1` float NOT NULL DEFAULT '0',
    59. 

  59.   `EffectMultipleValue2` float NOT NULL DEFAULT '0',
    60. 

  60.   `EffectMultipleValue3` float NOT NULL DEFAULT '0',
    61. 

  61.   `EffectMiscValue1` int(11) NOT NULL DEFAULT '0',
    62. 

  62.   `EffectMiscValue2` int(11) NOT NULL DEFAULT '0',
    63. 

  63.   `EffectMiscValue3` int(11) NOT NULL DEFAULT '0',
    64. 

  64.   `EffectMiscValueB1` int(11) NOT NULL DEFAULT '0',
    65. 

  65.   `EffectMiscValueB2` int(11) NOT NULL DEFAULT '0',
    66. 

  66.   `EffectMiscValueB3` int(11) NOT NULL DEFAULT '0',
    67. 

  67.   `EffectTriggerSpell1` int(10) unsigned NOT NULL DEFAULT '0',
    68. 

  68.   `EffectTriggerSpell2` int(10) unsigned NOT NULL DEFAULT '0',
    69. 

  69.   `EffectTriggerSpell3` int(10) unsigned NOT NULL DEFAULT '0',
    70. 

  70.   `EffectSpellClassMaskA1` int(10) unsigned NOT NULL DEFAULT '0',
    71. 

  71.   `EffectSpellClassMaskA2` int(10) unsigned NOT NULL DEFAULT '0',
    72. 

  72.   `EffectSpellClassMaskA3` int(10) unsigned NOT NULL DEFAULT '0',
    73. 

  73.   `EffectSpellClassMaskB1` int(10) unsigned NOT NULL DEFAULT '0',
    74. 

  74.   `EffectSpellClassMaskB2` int(10) unsigned NOT NULL DEFAULT '0',
    75. 

  75.   `EffectSpellClassMaskB3` int(10) unsigned NOT NULL DEFAULT '0',
    76. 

  76.   `EffectSpellClassMaskC1` int(10) unsigned NOT NULL DEFAULT '0',
    77. 

  77.   `EffectSpellClassMaskC2` int(10) unsigned NOT NULL DEFAULT '0',
    78. 

  78.   `EffectSpellClassMaskC3` int(10) unsigned NOT NULL DEFAULT '0',
    79. 

  79.   `MaxTargetLevel` tinyint(3) unsigned NOT NULL DEFAULT '0',
    80. 

  80.   `SpellFamilyName` tinyint(3) unsigned NOT NULL DEFAULT '0',
    81. 

  81.   `SpellFamilyFlags1` int(10) unsigned NOT NULL DEFAULT '0',
    82. 

  82.   `SpellFamilyFlags2` int(10) unsigned NOT NULL DEFAULT '0',
    83. 

  83.   `SpellFamilyFlags3` int(10) unsigned NOT NULL DEFAULT '0',
    84. 

  84.   `MaxAffectedTargets` tinyint(3) unsigned NOT NULL DEFAULT '0',
    85. 

  85.   `DmgClass` tinyint(3) unsigned NOT NULL DEFAULT '0',
    86. 

  86.   `PreventionType` tinyint(3) unsigned NOT NULL DEFAULT '0',
    87. 

  87.   `DmgMultiplier1` float NOT NULL DEFAULT '0',
    88. 

  88.   `DmgMultiplier2` float NOT NULL DEFAULT '0',
    89. 

  89.   `DmgMultiplier3` float NOT NULL DEFAULT '0',
    90. 

  90.   `AreaGroupId` int(11) NOT NULL DEFAULT '0',
    91. 

  91.   `SchoolMask` int(10) unsigned NOT NULL DEFAULT '0',
    92. 

  92.   `Comment` text NOT NULL,
    93. 

  93.   PRIMARY KEY (`Id`)
    94. 

  94. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Custom spell.dbc entries';
    95. 

  95. 

  96. INSERT INTO `spell_dbc` VALUES
    97. 

  97. ('24395', '0', '0', '536936848', '32768', '4', '0', '0', '0', '0', '1', '1', '0', '0', '101', '0', '0', '40', '40', '85', '1', '0', '-1', '0', '0', '6', '6', '6', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '1', '1', '0', '0', '0', '0', '0', '0', '77', '77', '77', '0', '0', '0', '0', '0', '0', '1', '5', '17', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '9', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Bestial Wrath - Immunity'),
    98. 

  98. ('24396', '0', '0', '536936848', '32768', '4', '0', '0', '0', '0', '1', '1', '0', '0', '101', '0', '0', '40', '40', '85', '1', '0', '-1', '0', '0', '6', '6', '6', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '1', '1', '0', '0', '0', '0', '0', '0', '77', '77', '77', '0', '0', '0', '0', '0', '0', '14', '13', '24', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '9', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Bestial Wrath - Immunity'),
    99. 

  99. ('24397', '0', '0', '536936848', '268468224', '4', '0', '0', '0', '0', '1', '1', '0', '0', '101', '0', '0', '40', '40', '85', '1', '0', '-1', '0', '0', '6', '6', '6', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '1', '1', '0', '0', '0', '0', '0', '0', '77', '77', '77', '0', '0', '0', '0', '0', '0', '7', '10', '11', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '9', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Bestial Wrath - Immunity'),
    100. 

  100. ('26592', '0', '0', '536936848', '268468224', '4', '0', '0', '0', '0', '1', '1', '0', '0', '101', '0', '0', '40', '40', '85', '1', '0', '-1', '0', '0', '6', '6', '6', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '1', '1', '0', '0', '0', '0', '0', '0', '77', '77', '77', '0', '0', '0', '0', '0', '0', '2', '18', '30', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '9', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Bestial Wrath - Immunity'),
    101. 

  101. ('24900', '0', '0', '400', '1024', '0', '0', '2097152', '0', '1', '0', '1', '0', '0', '101', '0', '0', '0', '0', '21', '1', '0', '-1', '0', '0', '6', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '166', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Heart of the Wild - Cat Bonus'),
    102. 

  102. ('24899', '0', '0', '400', '1024', '0', '0', '2097152', '0', '144', '0', '1', '0', '0', '101', '0', '0', '0', '0', '21', '1', '0', '-1', '0', '0', '6', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '137', '0', '0', '0', '0', '0', '0', '0', '0', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Heart of the Wild - Bear Bonus'),
    103. 

  103. ('56817', '0', '0', '384', '0', '0', '0', '0', '0', '0', '0', '1', '0', '16', '100', '1', '0', '67', '67', '1', '0', '0', '-1', '0', '0', '6', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '15', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Rune Strike - Aura for 56815'),
    104. 

  104. ('62388', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '21', '1', '0', '-1', '0', '0', '6', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Demonic Circle: Teleport(48020) - casterAuraSpell');
    105.