The EQWiki - Your source for random EverQuest knowledge
CREATE TABLE `eqspells` (
`id` int(10) unsigned NOT NULL default '0',
`name` varchar(255) default NULL,
`activated` tinyint(4) default NULL,
`aeduration` mediumint(8) unsigned default NULL,
`aerange` mediumint(8) unsigned default NULL,
`attack_open` int(11) default NULL,
`attrib1` tinyint(3) unsigned default NULL,
`attrib2` tinyint(3) unsigned default NULL,
`attrib3` tinyint(3) unsigned default NULL,
`attrib4` tinyint(3) unsigned default NULL,
`attrib5` tinyint(3) unsigned default NULL,
`attrib6` tinyint(3) unsigned default NULL,
`attrib7` tinyint(3) unsigned default NULL,
`attrib8` tinyint(3) unsigned default NULL,
`attrib9` tinyint(3) unsigned default NULL,
`attrib10` tinyint(3) unsigned default NULL,
`attrib11` tinyint(3) unsigned default NULL,
`attrib12` tinyint(3) unsigned default NULL,
`autocast` smallint(5) unsigned default NULL,
`autocasttext` varchar(255) default NULL,
`base1` int(11) default NULL,
`base10` int(11) default NULL,
`base11` int(11) default NULL,
`base12` int(11) default NULL,
`base2` int(11) default NULL,
`base2_1` int(11) default NULL,
`base2_10` int(11) default NULL,
`base2_11` int(11) default NULL,
`base2_12` int(11) default NULL,
`base2_2` int(11) default NULL,
`base2_3` int(11) default NULL,
`base2_4` int(11) default NULL,
`base2_5` int(11) default NULL,
`base2_6` int(11) default NULL,
`base2_7` int(11) default NULL,
`base2_8` int(11) default NULL,
`base2_9` int(11) default NULL,
`base3` int(11) default NULL,
`base4` int(11) default NULL,
`base5` int(11) default NULL,
`base6` int(11) default NULL,
`base7` int(11) default NULL,
`base8` int(11) default NULL,
`base9` int(11) default NULL,
`berlevel` tinyint(3) unsigned default NULL,
`bookicon` smallint(5) unsigned default NULL,
`brdlevel` tinyint(3) unsigned default NULL,
`bstlevel` tinyint(3) unsigned default NULL,
`calc1` varchar(255) default NULL,
`calc2` varchar(255) default NULL,
`calc3` varchar(255) default NULL,
`calc4` varchar(255) default NULL,
`calc5` varchar(255) default NULL,
`calc6` varchar(255) default NULL,
`calc7` varchar(255) default NULL,
`calc8` varchar(255) default NULL,
`calc9` varchar(255) default NULL,
`calc10` varchar(255) default NULL,
`calc11` varchar(255) default NULL,
`calc12` varchar(255) default NULL,
`castinganim` smallint(5) unsigned default NULL,
`castingtime` float(4,1) default NULL,
`castmsg1` varchar(255) default NULL,
`castmsg2` varchar(255) default NULL,
`castmsg3` varchar(255) default NULL,
`castmsg4` varchar(255) default NULL,
`castmsg5` varchar(255) default NULL,
`classes` varchar(255) default NULL,
`clrlevel` tinyint(3) unsigned default NULL,
`defense_open` int(11) default NULL,
`deities` enum('Bertoxxulous','Brell Serilis','Bristlebane','Cazic-Thule','Erollisi Marr','Innoruuk','Karana','Mithaniel Marr','Prexus','Quellious','Rallos Zek','Rodcet Nife','Solusek Ro','Tribunal','Tunare') default NULL,
`deletable` tinyint(4) default NULL,
`desc1` varchar(255) default NULL,
`desc2` varchar(255) default NULL,
`desc3` varchar(255) default NULL,
`desc4` varchar(255) default NULL,
`desc5` varchar(255) default NULL,
`desc6` varchar(255) default NULL,
`desc7` varchar(255) default NULL,
`desc8` varchar(255) default NULL,
`desc9` varchar(255) default NULL,
`desc10` varchar(255) default NULL,
`desc11` varchar(255) default NULL,
`desc12` varchar(255) default NULL,
`descnum` int(11) default NULL,
`dotstackingexempt` tinyint(4) default NULL,
`drulevel` tinyint(3) unsigned default NULL,
`duration` smallint(5) unsigned default NULL,
`durationformula` smallint(5) unsigned default NULL,
`durationtext` varchar(255) default NULL,
`enclevel` tinyint(3) unsigned default NULL,
`enduranceupkeep` int(11) default NULL,
`environment` smallint(6) default NULL,
`error_open` int(11) default NULL,
`extra` varchar(255) default NULL,
`fizzleadj` tinyint(3) unsigned default NULL,
`fizzletime` float(4,2) default NULL,
`foci` varchar(255) default NULL,
`focus1` int(10) unsigned default NULL,
`focus2` int(10) unsigned default NULL,
`focus3` int(10) unsigned default NULL,
`focus4` int(10) unsigned default NULL,
`focusitems` varchar(255) default NULL,
`gemicon` smallint(5) unsigned default NULL,
`lighttype` tinyint(4) default NULL,
`location` enum('Any','Dungeons','Outdoors') default NULL,
`maglevel` tinyint(3) unsigned default NULL,
`manacost` smallint(6) default NULL,
`max1` int(11) default NULL,
`max2` int(11) default NULL,
`max3` int(11) default NULL,
`max4` int(11) default NULL,
`max5` int(11) default NULL,
`max6` int(11) default NULL,
`max7` int(11) default NULL,
`max8` int(11) default NULL,
`max9` int(11) default NULL,
`max10` int(11) default NULL,
`max11` int(11) default NULL,
`max12` int(11) default NULL,
`maxduration` smallint(6) default NULL,
`minduration` smallint(6) default NULL,
`minlevel` tinyint(3) unsigned default NULL,
`mnklevel` tinyint(3) unsigned default NULL,
`neclevel` tinyint(3) unsigned default NULL,
`pallevel` tinyint(3) unsigned default NULL,
`pushback` float(4,1) default NULL,
`pushup` float(4,1) default NULL,
`range` mediumint(9) default NULL,
`reagentcount1` tinyint(4) default NULL,
`reagentcount2` tinyint(4) default NULL,
`reagentcount3` tinyint(4) default NULL,
`reagentcount4` tinyint(4) default NULL,
`reagentid1` int(10) unsigned default NULL,
`reagentid2` int(10) unsigned default NULL,
`reagentid3` int(10) unsigned default NULL,
`reagentid4` int(10) unsigned default NULL,
`reagents` varchar(255) default NULL,
`recasttime` float(4,1) default NULL,
`resist` enum('Cold','Disease','Fire','Magic','Poison','Unresistable') default NULL,
`resistadj` smallint(6) default NULL,
`rnglevel` tinyint(3) unsigned default NULL,
`roglevel` tinyint(3) unsigned default NULL,
`shdlevel` tinyint(3) unsigned default NULL,
`shmlevel` tinyint(3) unsigned default NULL,
`shortbuff` tinyint(4) default NULL,
`skill` enum('Abjuration','Alteration','Brass','Conjuration','Divination','Evocation','Innate','Percussion','Singing','Stringed','Wind') default NULL,
`skill_open` int(11) default NULL,
`source` enum('Live','Test') default NULL,
`spaindex` smallint(6) default NULL,
`spellanim` smallint(5) unsigned default NULL,
`spellicon` smallint(5) unsigned default NULL,
`spelltype` enum('Beneficial','Beneficial, Group Only','Detrimental') default NULL,
`targetanim` smallint(5) unsigned default NULL,
`targettype` varchar(255) default NULL,
`targname` varchar(25) default NULL,
`timeofday` enum('Any','Nighttime') default NULL,
`traveltype` tinyint(4) default NULL,
`uninterruptable` tinyint(4) default NULL,
`unknown112` varchar(255) default NULL,
`unknown113` varchar(255) default NULL,
`unknown129` varchar(255) default NULL,
`unknown130` varchar(255) default NULL,
`unknown131` varchar(255) default NULL,
`unknown139` varchar(255) default NULL,
`unknown140` varchar(255) default NULL,
`unknown141` varchar(255) default NULL,
`unknown142` varchar(255) default NULL,
`unknown143` varchar(255) default NULL,
`unknown144` varchar(255) default NULL,
`unknown145` varchar(255) default NULL,
`unknown146` varchar(255) default NULL,
`unknown147` varchar(255) default NULL,
`unknown148` varchar(255) default NULL,
`unknown149` varchar(255) default NULL,
`unknown150` varchar(255) default NULL,
`unknown151` varchar(255) default NULL,
`unknown152` varchar(255) default NULL,
`unknown153` varchar(255) default NULL,
`unknown154` varchar(255) default NULL,
`unknown155` varchar(255) default NULL,
`unknown156` varchar(255) default NULL,
`unknown161` varchar(255) default NULL,
`unknown176` varchar(255) default NULL,
`unknown177` varchar(255) default NULL,
`updated` date default NULL,
`warlevel` tinyint(3) unsigned default NULL,
`wizlevel` tinyint(3) unsigned default NULL,
`bonushate` int(11) default NULL,
`can_mgb` tinyint(4) default NULL,
`category` text,
`hateamount` int(11) default NULL,
`nodispell` tinyint(4) default NULL,
`npc_category` tinyint(4) default NULL,
`npc_usefulness` int(11) default NULL,
`numhits` int(11) default NULL,
`pvpresistbase` int(11) default NULL,
`pvpresistcalc` int(11) default NULL,
`pvpresistcap` int(11) default NULL,
`timer` int(11) default NULL,
`unknown182` varchar(255) default NULL,
`unknown183` varchar(255) default NULL,
`unknown184` varchar(255) default NULL,
`unknown185` varchar(255) default NULL,
`unknown186` varchar(255) default NULL,
`unknown187` varchar(255) default NULL,
`unknown188` varchar(255) default NULL,
`unknown189` varchar(255) default NULL,
`unknown190` varchar(255) default NULL,
`unknown191` varchar(255) default NULL,
`unknown192` varchar(255) default NULL,
`unknown193` varchar(255) default NULL,
`unknown194` varchar(255) default NULL,
`unknown195` varchar(255) default NULL,
`unknown196` varchar(255) default NULL,
`unknown197` varchar(255) default NULL,
`unknown198` varchar(255) default NULL,
`unknown199` varchar(255) default NULL,
`unknown200` varchar(255) default NULL,
`unknown201` varchar(255) default NULL,
`unknown202` varchar(255) default NULL,
`unknown203` varchar(255) default NULL,
`unknown204` varchar(255) default NULL,
`unknown205` varchar(255) default NULL,
`unknown206` varchar(255) default NULL,
`unknown207` varchar(255) default NULL,
`unknown208` varchar(255) default NULL,
`unknown209` varchar(255) default NULL,
`unknown210` varchar(255) default NULL,
`unknown211` varchar(255) default NULL,
`unknown212` varchar(255) default NULL,
`unknown213` varchar(255) default NULL,
`unknown214` varchar(255) default NULL,
`unknown215` varchar(255) default NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;
![[Content is available under Attribution-ShareAlike]](http://www.eqwiki.net/w/images/Somerights.png)