--
-- Table structure for table `skill_spellbooks`
--
DROP TABLE IF EXISTS skill_spellbooks;
CREATE TABLE `skill_spellbooks` (
  `skill_id` int(11) NOT NULL default '-1',
  `item_id` int(11) NOT NULL default '-1',
  KEY `skill_id` (`skill_id`,`item_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `skill_spellbooks`
--

-- NOTES:
-- (0,1393),
-- Spellbook: Quickness unable to find a matching skill_id possibly never used
INSERT INTO `skill_spellbooks` VALUES 
(2,1512), -- Spellbook: Confusion
(10,3039), -- Spellbook: Summon Storm Cubic
(13,3940), -- Blueprint: Summon Siege Golem
(15,1513), -- Spellbook: Charm
(21,1377), -- Spellbook: Poison Recovery
(22,3040), -- Spellbook: Summon Vampiric Cubic
(25,3038), -- Blueprint: Summon Mechanic Golem
(33,3041), -- Spellbook: Summon Phantom Cubic
(44,3432), -- Spellbook: Remedy
(45,1378), -- Spellbook: Divine Heal
(46,3042), -- Spellbook: Life Scavenge
(49,3043), -- Spellbook: Holy Strike
(58,1096), -- Spellbook: Elemental Heal
(61,1379), -- Spellbook: Cure Bleeding
(65,3044), -- Spellbook: Horror
(67,3045), -- Spellbook: Summon Life Cubic
(69,3046), -- Spellbook: Sacrifice
(70,1097), -- Spellbook: Drain Health
(72,3047), -- Spellbook: Iron Will
(77,1095), -- Spellbook: Attack Aura
(86,3048), -- Spellbook: Reflect Damage
(91,1294), -- Spellbook: Defense Aura
(102,1380), -- Spellbook: Entangle
(103,3049), -- Spellbook: Corpse Plague
(105,1381), -- Spellbook: Freezing Strike
(115,1382), -- Spellbook: Power Break
(122,3050), -- Spellbook: Hex
(123,3051), -- Spellbook: Spirit Barrier
(127,3052), -- Spellbook: Hamstring
(129,1383), -- Spellbook: Poison
(230,1384), -- Spellbook: Sprint
(262,3053), -- Spellbook: Holy Blessing
(278,3054), -- Spellbook: Summon Viper Cubic
(279,3055), -- Spellbook: Lightening Strike
(283,3056), -- Spellbook: Summon Dark Panther
(289,4203), -- Spellbook: Life Leech
(301,4921), -- Blueprint: Summon Big Boom
(1002,1518), -- Amulet: Flame Chant
(1003,1519), -- Amulet: Pa'agrio's Gift
(1004,3103), -- Amulet: Pa'agrio's Wisdom
(1005,1520), -- Amulet: Pa'agrio's Blessing
(1006,1521), -- Amulet: Chant of Fire
(1007,1522), -- Amulet: Chant of Battle
(1008,3104), -- Amulet: Pa'agrio's Glory
(1009,1523), -- Amulet: Chant of Shielding
(1010,1524), -- Amulet: Soul Shield
(1011,1152), -- Spellbook: Heal
(1012,1053), -- Spellbook: Cure Poison
(1013,1385), -- Spellbook: Recharge
(1015,1050), -- Spellbook: Battle Heal
(1016,1514), -- Spellbook: Resurrection
(1018,3072), -- Spellbook: Purify
(1020,3068), -- Spellbook: Vitalize
(1027,1054), -- Spellbook: Group Heal
(1028,3073), -- Spellbook: Might of Heaven
(1031,1386), -- Spellbook: Disrupt Undead
(1032,3094), -- Spellbook: Invigor
(1033,1387), -- Spellbook: Resist Poison
(1034,3069), -- Spellbook: Repose
(1035,1388), -- Spellbook: Mental Shield
(1036,3095), -- Spellbook: Magic Barrier
(1040,1058), -- Spellbook: Shield
(1042,3070), -- Spellbook: Hold Undead
(1043,1389), -- Spellbook: Holy Weapon
(1044,1390), -- Spellbook: Regeneration
(1045,3096), -- Spellbook: Blessed Body
(1047,4207), -- Spellbook: Mana Regeneration
(1048,3097), -- Spellbook: Blessed Soul
(1049,3071), -- Spellbook: Requiem
(1050,3098), -- Spellbook: Return
(1056,3079), -- Spellbook: Cancel
(1059,1391), -- Spellbook: Empower
(1062,1392), -- Spellbook: Berserker Spirit
(1064,3064), -- Spellbook: Silence
(1068,1048), -- Spellbook: Might
(1069,1394), -- Spellbook: Sleep
(1071,3082), -- Spellbook: Surrender to Water
(1072,3080), -- Spellbook: Sleeping Cloud
(1073,1515), -- Spellbook: Kiss of Eva
(1074,3074), -- Spellbook: Surrender to Wind
(1075,1397), -- Spellbook: Peace
(1077,1398), -- Spellbook: Focus
(1078,1399), -- Spellbook: Concentration
(1085,1401), -- Spellbook: Acumen
(1086,3099), -- Spellbook: Haste
(1087,1402), -- Spellbook: Agility
(1090,1525), -- Amulet: Life Drain
(1092,1526), -- Amulet: Fear
(1095,1527), -- Amulet: Venom
(1096,1528), -- Amulet: Seal of Chaos
(1097,1529), -- Amulet: Dreaming Spirit
(1099,1530), -- Amulet: Seal of Slow
(1100,1531), -- Amulet: Chill Flame
(1101,1532), -- Amulet: Blaze Quake
(1102,1533), -- Amulet: Aura Sink
(1104,3105), -- Amulet: Seal of Winter
(1105,1534), -- Amulet: Madness
(1107,1535), -- Amulet: Frost Flame
(1108,3106), -- Amulet: Seal of Flame
(1111,1403), -- Spellbook: Summon Kat the Cat
(1126,1404), -- Spellbook: Servitor Recharge
(1127,1405), -- Spellbook: Servitor Heal
(1128,1667), -- Spellbook: Summon Shadow
(1129,3057), -- Spellbook: Summon Reanimated Man
(1139,3091), -- Spellbook: Servitor Magic Shield
(1140,3092), -- Spellbook: Servitor Physical Shield
(1141,3093), -- Spellbook: Servitor Haste
(1144,1406), -- Spellbook: Servitor Wind Walk
(1145,1407), -- Spellbook: Servitor Magic Boost
(1146,1408), -- Spellbook: Mighty Servitor
(1147,1051), -- Spellbook: Vampiric Touch
(1148,3065), -- Spellbook: Death Spike
(1151,1516), -- Spellbook: Corpse Life Drain
(1154,3058), -- Spellbook: Summon Corrupted Man
(1155,3059), -- Spellbook: Corpse Burst
(1156,3060), -- Spellbook: Forget
(1157,1517), -- Spellbook: Body To Mind
(1159,3066), -- Spellbook: Curse Death Link
(1160,1409), -- Spellbook: Slow
(1163,3061), -- Spellbook: Curse Discord
(1164,1056), -- Spellbook: Curse: Weakness
(1167,1410), -- Spellbook: Poisonous Cloud
(1168,1055), -- Spellbook: Curse: Poison
(1169,3062), -- Spellbook: Curse Fear
(1170,3063), -- Spellbook: Anchor
(1171,3075), -- Spellbook: Blazing Circle
(1172,1411), -- Spellbook: Aura Burn
(1174,3083), -- Spellbook: Frost Wall
(1175,1370), -- Spellbook: Aqua Swirl
(1176,3089), -- Spellbook: Tempest
(1178,1371), -- Spellbook: Twister
(1181,1052), -- Spellbook: Flame Strike
(1182,1412), -- Spellbook: Resist Aqua
(1183,3084), -- Spellbook: Freezing Shackle
(1184,1049), -- Spellbook: Ice Bolt
(1189,1413), -- Spellbook: Resist Wind
(1191,1414), -- Spellbook: Resist Fire
(1201,1415), -- Spellbook: Dryad Root
(1204,1098), -- Spellbook: Wind Walk
(1206,1099), -- Spellbook: Wind Shackle
(1208,1536), -- Amulet: Seal of Binding
(1209,1537), -- Amulet: Seal of Poison
(1210,3107), -- Amulet: Seal of Gloom
(1213,3108), -- Amulet: Seal of Mirage
(1217,3429), -- Spellbook: Greater Heal
(1218,3430), -- Spellbook: Greater Battle Heal
(1219,3431), -- Spellbook: Greater Group Heal
(1220,1372), -- Spellbook: Blaze
(1222,1416), -- Spellbook: Curse of Chaos
(1223,1417), -- Spellbook: Surrender To Earth
(1224,1418), -- Spellbook: Surrender To Poison
(1225,1668), -- Spellbook: Summon Mew the Cat
(1226,1669), -- Spellbook: Summon Boxer the Unicorn
(1227,1670), -- Spellbook: Summon Mirage the Unicorn
(1228,1671), -- Spellbook: Summon Silhouette
(1229,1856), -- Amulet: Chant of Life
(1230,3076), -- Spellbook: Prominence
(1231,3081), -- Spellbook: Aura Flare
(1232,3077), -- Spellbook: Blazing Skin
(1233,3078), -- Spellbook: Decay
(1234,3067), -- Spellbook: Vampiric Claw
(1235,3085), -- Spellbook: Hydro Blast
(1236,3086), -- Spellbook: Frost Bolt
(1237,3087), -- Spellbook: Ice Dagger
(1238,3088), -- Spellbook: Freezing Skin
(1239,3090), -- Spellbook: Hurricane
(1240,3100), -- Spellbook: Guidance
(1242,3101), -- Spellbook: Death Whisper
(1243,3102), -- Spellbook: Bless Shield
(1244,3115), -- Amulet: Freezing Flame
(1245,3114), -- Amulet: Steal Essence
(1246,3109), -- Amulet: Seal of Silence
(1247,3110), -- Amulet: Seal of Scourge
(1248,3111), -- Amulet: Seal of Suspension
(1249,3112), -- Amulet: Pa'agrio's Eye
(1250,3113), -- Amulet: Pa'agrio's Protection
(1251,3116), -- Amulet: Chant of Fury
(1252,3117), -- Amulet: Chant of Evasion
(1253,3118), -- Amulet: Chant of Rage
(1254,3941), -- Spellbook: Mass Resurrection
(1256,3943), -- Amulet: Pa'agrio's Heart
(1257,3944), -- Spellbook: Decrease Weight
(1258,4200), -- Spellbook: Restore Life
(1259,4201), -- Spellbook: Resist Shock
(1260,4204), -- Amulet: Pa'agrio's Tact
(1261,4205), -- Amulet: Pa'agrio's Rage
(1262,4206), -- Spellbook: Transfer Pain
(1263,4208), -- Spellbook: Curse Gloom

-- c3 skill spellbooks (most of them anyway - thx Luno)

(1264,4906), -- Spellbook: Solar Spark
(1265,4907), -- Spellbook: Solar Flare
(1266,4908), -- Spellbook: Shadow Spark
(1267,4909), -- Spellbook: Shadow Flare
(1268,4910), -- Spellbook: Vampiric Rage
(1269,4911), -- Spellbook: Curse Disease
(1271,4912), -- Spellbook: Benediction
(1272,4913), -- Spellbook: Word of Fear
(1273,4914), -- Spellbook: Serenade of Eva
(299,4915), -- Blueprint: Summon Wild Hog Cannon
(1274,4916), -- Spellbook: Energy Bolt
(1275,4917), -- Spellbook: Aura Bolt
(1276,4918), -- Spellbook: Summon Kai the Cat
(1277,4919), -- Spellbook: Summon Merrow the Unicorn
(1278,4920), -- Spellbook: Summon Soulless
(1279,4922), -- Spellbook: Summon Binding Cubic
(1280,4923), -- Spellbook: Summon Aqua Cubic
(1281,4924), -- Spellbook: Summon Spark Cubic
(1282,4925), -- Amulet: Pa'agrio's Haste
(1283,4926), -- Amulet: Soul Guard
(1284,4927), -- Amulet: Chant of Revenge
(1285,4928), -- Spellbook: Seed of Fire
(1286,4929), -- Spellbook: Seed of Water
(1287,4930), -- Spellbook: Seed of Wind
(1288,4931), -- Spellbook: Aura Symphony
(1289,4932), -- Spellbook: Inferno
(1290,4933), -- Spellbook: Blizzard
(1291,4934), -- Spellbook: Demon Wind
(1292,5013), -- Spellbook: Elemental Assault
(1293,5014), -- Spellbook: Elemental Symphony
(1294,5015), -- Spellbook: Elemental Storm
(1295,5809), -- Spellbook: Aqua Splash
(1296,5810), -- Spellbook: Rain of Fire
(1298,5811), -- Spellbook: Mass Slow
(1299,5812), -- Spellbook: Servitor Empowerment
(1300,5813), -- Spellbook: Servitor Cure
(1301,5814), -- Spellbook: Servitor Blessing
(1303,5815), -- Spellbook: Wild Magic
(1304,5816), -- Spellbook: Advanced Block
(1305,6350), -- Amulet: Pa'agrio's Honor
(1306,6351), -- Amulet: Ritual of Life
(1307,6352), -- Spellbook: Prayer
(1308,6395), -- Amulet: Chant of Predator
(1309,6396), -- Amulet: Chant of Eagle
(1310,6397), -- Amulet: Chant of Vampire
(1311,6398), -- Spellbook: Body of Avatar

-- C4 Spellbooks and Amulets

(1328,7638), -- Spellbook - Mass Summon Storm Cubic
(1329,7639), -- Spellbook - Mass Summon Aqua Cubic
(1330,7640), -- Spellbook - Mass Summon Phantom Cubic
(1331,7641), -- Spellbook - Summon Feline Queen
(1332,7642), -- Spellbook - Summon Unicorn Seraphim
(1333,7643), -- Spellbook - Summon Nightshade
(1334,7644), -- Spellbook - Summon Cursed Man
(1335,7645), -- Spellbook - Balance Life
(1336,7646), -- Spellbook - Curse of Doom
(1337,7647), -- Spellbook - Curse of Abyss
(1338,7648), -- Spellbook - Arcane Chaos
(1339,7649), -- Spellbook - Fire Vortex
(1340,7650), -- Spellbook - Ice Vortex
(1341,7651), -- Spellbook - Wind Vortex
(1342,7652), -- Spellbook - Light Vortex
(1343,7653), -- Spellbook - Dark Vortex
(1344,7654), -- Spellbook - Mass Warrior Bane
(1345,7655), -- Spellbook - Mass Mage Bane
(1346,7656), -- Spellbook - Warrior Servitor
(1347,7657), -- Spellbook - Wizard Servitor
(1348,7658), -- Spellbook - Assassin Servitor
(1349,7659), -- Spellbook - Final Servitor
(1350,7660), -- Spellbook - Warrior Bane
(1351,7661), -- Spellbook - Mage Bane
(1352,7662), -- Spellbook - Elemental Protection
(1353,7663), -- Spellbook - Divine Protection
(1354,7664), -- Spellbook - Arcane Protection
(1355,7665), -- Spellbook - Prophecy of Water
(1356,7666), -- Spellbook - Prophecy of Fire
(1357,7667), -- Spellbook - Prophecy of Wind
(1358,7668), -- Spellbook - Block Shield
(1359,7669), -- Spellbook - Block Wind Walk
(1360,7670), -- Spellbook - Mass Block Shield
(1361,7671), -- Spellbook - Mass Block Wind Walk
(1362,7672), -- Amulet - Chant of Spirit
(1363,7673), -- Amulet - Chant of Victory
(1364,7674), -- Amulet - Pa'agrio's Eye
(1365,7675), -- Amulet - Pa'agrio's Soul
(1366,7676), -- Amulet - Seal of Despair
(1367,7835); -- Amulet: Seal of Disease

-- C5 Spellbooks and Amulets (tnx ThePhoenixBird)

INSERT INTO `skill_spellbooks` VALUES
(1380,8380), -- Spellbook: Betray
(1381,8381), -- Spellbook: Mass Curse Fear
(1382,8382), -- Spellbook: Mass Curse Gloom
(1383,8383), -- Spellbook: Mass Surrender to Fire
(1384,8384), -- Spellbook: Mass Surrender to Water
(1385,8385), -- Spellbook: Mass Surrender to Wind
(1386,8386), -- Spellbook - Arcane Disruption
(1387,8387), -- Spellbook - Summon Cursed Bones
(1388,8388), -- Spellbook: Greater Might
(1389,8389), -- Spellbook: Greater Shield
(1390,8390), -- Amulet: War Chant
(1391,8391), -- Amulet: Earth Chant
(1392,8392), -- Spellbook: Holy Resistance
(1393,8393), -- Spellbook: Unholy Resistance
(1394,8394), -- Spellbook: Trance
(1395,8395), -- Spellbook: Erase
(1396,8396), -- Spellbook: Magical Backfire
(1397,8397), -- Spellbook: Clarity
(1398,8398), -- Spellbook: Mana Burn
(1399,8399), -- Spellbook: Mana Storm
(1400,8400), -- Spellbook: Turn Undead
(1401,8401), -- Spellbook: Major Heal
(1402,8402); -- Spellbook: Major Group Heal

-- Late C5 Spellbooks and Amulets

INSERT INTO `skill_spellbooks` VALUES 
(1403,8616), -- Spellbook: Summon Friend
(1404,8617); -- Spellbook: Word of Invitation

-- Interlude Spellbooks and Amulets

INSERT INTO `skill_spellbooks` VALUES 
(438,8877), -- Spellbook: Soul of the Phoenix
(1406,8878), -- Spellbook: Summon Feline King
(1407,8879), -- Spellbook: Summon Magnus the Unicorn
(1408,8880), -- Spellbook: Summon Spectral Knight
(1409,8881), -- Spellbook: Cleanse
(1410,8882), -- Spellbook: Salvation
(1411,8883), -- Spellbook: Mystic Immunity
(1412,8884), -- Spellbook: Spell Turning
(1413,8885), -- Amulet: Magnus' Chant
(1414,8886), -- Amulet: Victories of Pa'agrio
(1415,8887), -- Amulet: Pa'agrio's Emblem
(1416,8888), -- Amulet: Pa'agrio's Fist
(1429,8889), -- Amulet: Gate Chant
(449,8890), -- Spellbook: Summon Attractive Cubic
(1417,8891), -- Spellbook: Aura Flash
(454,8892), -- Ancient Tactical Manual: Symbol of Defense
(455,8893), -- Ancient Tactical Manual: Symbol of Noise
(456,8894), -- Ancient Tactical Manual: Symbol of Resistance
(457,8895), -- Ancient Tactical Manual: Symbol of Honor
(458,8896), -- Ancient Tactical Manual: Symbol of Energy
(459,8897), -- Ancient Tactical Manual: Symbol of the Sniper
(460,8898), -- Ancient Tactical Manual: Symbol of the Assassin
(1419,8899), -- Ancient Spellbook: Volcano
(1420,8900), -- Ancient Spellbook: Cyclone
(1421,8901), -- Ancient Spellbook: Raging Waves
(1422,8902), -- Ancient Spellbook: Day of Doom
(1423,8903), -- Ancient Spellbook: Gehenna
(1424,8904), -- Ancient Spellbook: Anti-Summoning Field
(1425,8905), -- Ancient Spellbook: Purification Field
(1426,8906), -- Ancient Spellbook: Miracle
(1427,8907), -- Ancient Spellbook: Flames of Invincibility
(1428,8908), -- Ancient Spellbook: Mass Recharge
(448,8909), -- Blueprint: Summon Swoop Cannon
(1418,8945), -- Spellbook: Celestial Shield
(1430,8946); -- Spellbook: Invocation