9
3

raw_spells.sql 3.3 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071
  1. CREATE TABLE `raw_spells` (
  2. `id` int(10) unsigned NOT NULL,
  3. `tier` tinyint(3) unsigned NOT NULL default '0',
  4. `name` varchar(128) NOT NULL default ' ',
  5. `description` varchar(512) NOT NULL default ' ',
  6. `icon` smallint(5) unsigned NOT NULL default '0',
  7. `icon2` smallint(5) unsigned NOT NULL default '0',
  8. `icontype` smallint(5) unsigned NOT NULL default '0',
  9. `type` tinyint(3) unsigned NOT NULL default '0',
  10. `class_skill` int(10) unsigned NOT NULL default '0',
  11. `mastery_skill` int(10) unsigned NOT NULL default '0',
  12. `unknown2` tinyint(3) unsigned NOT NULL default '0',
  13. `spell_text_color` int(10) unsigned NOT NULL default '0',
  14. `friendly_spell` smallint(5) unsigned NOT NULL default '0',
  15. `display_spell_tier` tinyint(3) unsigned NOT NULL default '0',
  16. `duration_flag` tinyint(3) unsigned NOT NULL default '0',
  17. `target` tinyint(3) unsigned NOT NULL default '0',
  18. `group_spell` tinyint(3) unsigned NOT NULL default '0',
  19. `language_type` tinyint(3) unsigned NOT NULL default '0',
  20. `log_file` varchar(64) default NULL,
  21. `processed` tinyint(3) unsigned NOT NULL default '0',
  22. PRIMARY KEY (`id`,`tier`)
  23. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  24. CREATE TABLE `raw_spell_details` (
  25. `spell_id` int(10) unsigned NOT NULL default '0',
  26. `tier` tinyint(3) unsigned NOT NULL default '0',
  27. `health_req` smallint(5) unsigned NOT NULL default '0',
  28. `health_upkeep` smallint(5) unsigned NOT NULL default '0',
  29. `power_req` smallint(5) unsigned NOT NULL default '0',
  30. `power_upkeep` smallint(5) unsigned NOT NULL default '0',
  31. `req_concentration` smallint(5) unsigned NOT NULL default '0',
  32. `cast_time` smallint(5) unsigned NOT NULL default '0',
  33. `recovery` smallint(5) unsigned NOT NULL default '0',
  34. `recast` float unsigned NOT NULL default '0',
  35. `radius` float unsigned NOT NULL default '0',
  36. `max_aoe_targets` smallint(5) unsigned NOT NULL default '0',
  37. `unknown8` int(10) unsigned NOT NULL default '0',
  38. `range` float unsigned NOT NULL default '0',
  39. `duration1` int(10) unsigned NOT NULL default '0',
  40. `duration2` int(10) unsigned NOT NULL default '0',
  41. `unknown9` tinyint(3) unsigned NOT NULL default '0',
  42. `unknown10` smallint(5) unsigned NOT NULL default '0',
  43. `resistibility` float NOT NULL default '0',
  44. `hit_bonus` float NOT NULL default '0',
  45. `language_type` tinyint(3) unsigned NOT NULL default '0',
  46. `log_file` varchar(64) default NULL,
  47. PRIMARY KEY (`spell_id`,`tier`)
  48. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  49. CREATE TABLE `raw_spell_effects` (
  50. `spell_id` int(10) unsigned NOT NULL default '0',
  51. `tier` tinyint(3) unsigned NOT NULL default '0',
  52. `subbulletflag` tinyint(3) unsigned NOT NULL default '0',
  53. `effect` varchar(512) NOT NULL,
  54. `percentage` tinyint(3) unsigned NOT NULL default '100',
  55. `language_type` tinyint(3) unsigned NOT NULL default '0',
  56. `log_file` varchar(64) default NULL,
  57. PRIMARY KEY (`spell_id`,`tier`)
  58. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  59. CREATE TABLE `raw_spell_levels` (
  60. `spell_id` int(10) unsigned NOT NULL,
  61. `tier` tinyint(3) unsigned NOT NULL default '0',
  62. `class_id` tinyint(3) unsigned NOT NULL default '0',
  63. `spell_level` smallint(5) unsigned NOT NULL default '0',
  64. `language_type` tinyint(3) unsigned NOT NULL default '0',
  65. `log_file` varchar(64) default NULL,
  66. PRIMARY KEY (`spell_id`,`tier`,`class_id`)
  67. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;