wiki:EQ2 Database Layouts  

< Database Layouts

Unfortunately, with the eq2.zam.com revamp, these tables are no longer even remotely accurate. The Raw Dump tab on each db page can be useful for finding the db field names, but if you cannot find it or are not sure it is working correctly, please contact Bludwyng and I will help.

The following tables define the EverQuest II db tables that can be referenced using the Database Access Functions.

Contents [hide]

EverQuest II

quests

FieldType(length)Description
createddatetimeDate and Time this quest db record was first created
updateddatetimeDate and Time this quest db record was last modified
idsmallint(6)A unique number, assigned sequentially by the system at the time the quest is added to the database.
quest_namevarchar(255)The title of this quest exactly as it appears in-game. If the quest name ends in a Question Mark (?), the question mark must be omitted.
quest_typelistA value in the following list: Access Quest, Catalog, City Task, Collection, Hallmark, Heritage, Language, Lore and Legend, Miscellaneous, Prestige, Signature, Deity, Betrayal, Citizenship, Tradeskill, or null
recommended_levelsmallint(6)
ratingtinyint(4)
experiencetinyint(4)
descriptiontextObsolete! Use wiki instead!
statuspointsint(11)
repeatabletinyint(4)If this field is NOT null,the quest is repeatable.
picturetextfull path to an image on our server (without http://eq2.allakhazam.com) or a filename expected to reside in /images/quests (an extension of .jpg is assumed if not provided)
submittedvarchar(100)
coinvarchar(25)
heroictinyint(4)If this field is NOT null, the quest is Heroic
epictinyint(4)If this field is NOT null, the quest is Epic
statuspointsmaxint(10) unsigned
obsoletetinyint(3) unsignedIf this field is NOT null, the quest is Obsolete
isBetatinyint(3) unsignedIf this field is NOT null, the quest is Beta and will NOT be displayed in ANY way except to admins.

items

FieldType(length)Description
createddatetimeDate and Time this item db record was first created
updateddatetimeDate and Time this item db record was last modified
idint(11)A unique number, assigned sequentially by the system at the time the item is added to the database.
namevarchar(120)The name of this item exactly as it appears in-game.
typelistA value in the following list: Armor, Avatar, Charm, Container, Drink, Food, House Item, Knowledge, Miscellaneous, Mount, Poison, Quest Starter, Scroll, Weapon, Adornment, Symbol, Collection, Ammo, Jewelry, Potion, SHield, Sales Container or null
recipe_comp_typevarchar(50)
weapon_typelistA value in the following list: Main Hand, One-Hand, Two-Hand, Ranged, Off Hand
skilllistA value in the following list: Bow, Buckler, Chain Armor, Cloth Armor, Crushing, Leather Armor, Magic Afinity, Piercing, Plate Armor, Poisoning, Round Shield, Slashing, Symbols, Thrown Weapon, Tower Shield or null
chargestinyint(4)If this is a charm, how many charges does it have? 0=unlimited
loretinyint(4)If this is not NULL, this item is flagged as Lore
notradetinyint(4)If this is not NULL, this item is flagged as NOTRADE
attuneabletinyint(4)If this is not NULL, this item is flagged as ATTUNEABLE
storeboughttinyint(4)If this is not NULL, this item can be bought from merchants
harvestedtinyint(4)If this is not NULL, this item is harvested from resource nodes
temporarytinyint(4)If this is not NULL, this item is flagged as TEMPORARY
questtinyint(4)If this is not NULL, this item is obtained as a quest reward
questcomponenttinyint(4)If this is not NULL, this item is obtained and is used during a quest
shieldfactorsmallint(6)Protection
acsmallint(6)Mitigation
wtfloatWeight
mindmgsmallint(6)Minimum Damage
maxdmgsmallint(6)Maximum Damage
dmgratingfloatDamage Rating
delayfloatDelay
rangesmallint(6)Range (in meters)
capacitytinyint(4)For containers, this is the number of slots
weightreductiontinyint(4)Amount of weight reduction (for containers) as a percentage
agitinyint(4)Amount of boost to Agility
inttinyint(4)Amount of boost to Intelligence
statinyint(4)Amount of boost to Stamina
strtinyint(4)Amount of boost to Strength
wistinyint(4)Amount of boost to Wisdom
svmensmallint(6)Amount of boost to Resistance to Mental Damage
svcoldsmallint(6)Amount of boost to Resistance to Cold Damage
svdissmallint(6)Amount of boost to Resistance to Disease Damage
svfiresmallint(6)Amount of boost to Resistance to Heat Damage
svmagsmallint(6)Amount of boost to Resistance to Magic Damage
svpoismallint(6)Amount of boost to Resistance to Poison Damage
svdvsmallint(6)Amount of boost to Resistance to Divine Damage
healthsmallint(6)Amount of boost to Health Pool
powersmallint(6)Amount of boost to Power Pool
requiredsmallint(6)Required level to use
recommendedsmallint(6)Recommended level (not used)
descriptiontext
raritylistA value in the following list: Handcrafted, Treasured, Legendary, Fabled, Mythical, Mastercrafted, Uncommon or null
food_leveltinyint(4)
satiationlistA value in the following list: Average, Superior, High or null
durationsmallint(6)How many minutes does the food or drink last?
imagetextfull path to an image on our server (without http://eq2.allakhazam.com) or a filename expected to reside in /images/quests (an extension of .jpg is assumed if not provided)
submittedvarchar(100)
skillmodvarchar(80)
rentreductionsmallint(6)If this field is NOT null, the quest is Heroic
effect1varchar(200)
effecttype1listA value in the list: Activatable, Permanent, Proc, Reactive Proc
effect2varchar(200)
effecttype2listA value in the list: Activatable, Permanent, Proc, Reactive Proc
levelint(11)Minimum level to use this item?
novaluetinyint(4)
maxrangesmallint(6)
ornatetinyint(4)If NOT null, this item is flagged as ORNATE
fooddurationvarchar(22)How long the food or drink lasts (text)
isBetatinyint(3) unsignedIf this field is NOT null, the quest is Beta and will NOT be displayed in ANY way except to admins.

mobs

zones

objects

abilities

EverQuest II
Wikibase™

Category: EverQuest II
This page last modified 2009-05-14 11:52:10.