EQWiki:Source Code/Spell Table Schema

The EQWiki - Your source for random EverQuest knowledge

Jump to: navigation, search
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;
   
Personal tools