Wiki:EQ2 Database Layouts
The following tables define the EverQuest II db tables that can be referenced using the Database Access Functions.
| Contents [hide] |
EverQuest II
quests
| Field | Type(length) | Description |
|---|---|---|
| created | datetime | Date and Time this quest db record was first created |
| updated | datetime | Date and Time this quest db record was last modified |
| id | smallint(6) | A unique number, assigned sequentially by the system at the time the quest is added to the database. |
| quest_name | varchar(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_type | list | A 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_level | smallint(6) | |
| rating | tinyint(4) | |
| experience | tinyint(4) | |
| description | text | Obsolete! Use wiki instead! |
| statuspoints | int(11) | |
| repeatable | tinyint(4) | If this field is NOT null,the quest is repeatable. |
| picture | text | full 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) |
| submitted | varchar(100) | |
| coin | varchar(25) | |
| heroic | tinyint(4) | If this field is NOT null, the quest is Heroic |
| epic | tinyint(4) | If this field is NOT null, the quest is Epic |
| statuspointsmax | int(10) unsigned | |
| obsolete | tinyint(3) unsigned | If this field is NOT null, the quest is Obsolete |
| isBeta | tinyint(3) unsigned | If this field is NOT null, the quest is Beta and will NOT be displayed in ANY way except to admins. |
items
| Field | Type(length) | Description |
|---|---|---|
| created | datetime | Date and Time this item db record was first created |
| updated | datetime | Date and Time this item db record was last modified |
| id | int(11) | A unique number, assigned sequentially by the system at the time the item is added to the database. |
| name | varchar(120) | The name of this item exactly as it appears in-game. |
| type | list | A 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_type | varchar(50) | |
| weapon_type | list | A value in the following list: Main Hand, One-Hand, Two-Hand, Ranged, Off Hand |
| skill | list | A 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 |
| charges | tinyint(4) | If this is a charm, how many charges does it have? 0=unlimited |
| lore | tinyint(4) | If this is not NULL, this item is flagged as Lore |
| notrade | tinyint(4) | If this is not NULL, this item is flagged as NOTRADE |
| attuneable | tinyint(4) | If this is not NULL, this item is flagged as ATTUNEABLE |
| storebought | tinyint(4) | If this is not NULL, this item can be bought from merchants |
| harvested | tinyint(4) | If this is not NULL, this item is harvested from resource nodes |
| temporary | tinyint(4) | If this is not NULL, this item is flagged as TEMPORARY |
| quest | tinyint(4) | If this is not NULL, this item is obtained as a quest reward |
| questcomponent | tinyint(4) | If this is not NULL, this item is obtained and is used during a quest |
| shieldfactor | smallint(6) | Protection |
| ac | smallint(6) | Mitigation |
| wt | float | Weight |
| mindmg | smallint(6) | Minimum Damage |
| maxdmg | smallint(6) | Maximum Damage |
| dmgrating | float | Damage Rating |
| delay | float | Delay |
| range | smallint(6) | Range (in meters) |
| capacity | tinyint(4) | For containers, this is the number of slots |
| weightreduction | tinyint(4) | Amount of weight reduction (for containers) as a percentage |
| agi | tinyint(4) | Amount of boost to Agility |
| int | tinyint(4) | Amount of boost to Intelligence |
| sta | tinyint(4) | Amount of boost to Stamina |
| str | tinyint(4) | Amount of boost to Strength |
| wis | tinyint(4) | Amount of boost to Wisdom |
| svmen | smallint(6) | Amount of boost to Resistance to Mental Damage |
| svcold | smallint(6) | Amount of boost to Resistance to Cold Damage |
| svdis | smallint(6) | Amount of boost to Resistance to Disease Damage |
| svfire | smallint(6) | Amount of boost to Resistance to Heat Damage |
| svmag | smallint(6) | Amount of boost to Resistance to Magic Damage |
| svpoi | smallint(6) | Amount of boost to Resistance to Poison Damage |
| svdv | smallint(6) | Amount of boost to Resistance to Divine Damage |
| health | smallint(6) | Amount of boost to Health Pool |
| power | smallint(6) | Amount of boost to Power Pool |
| required | smallint(6) | Required level to use |
| recommended | smallint(6) | Recommended level (not used) |
| description | text | |
| rarity | list | A value in the following list: Handcrafted, Treasured, Legendary, Fabled, Mythical, Mastercrafted, Uncommon or null |
| food_level | tinyint(4) | |
| satiation | list | A value in the following list: Average, Superior, High or null |
| duration | smallint(6) | How many minutes does the food or drink last? |
| image | text | full 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) |
| submitted | varchar(100) | |
| skillmod | varchar(80) | |
| rentreduction | smallint(6) | If this field is NOT null, the quest is Heroic |
| effect1 | varchar(200) | |
| effecttype1 | list | A value in the list: Activatable, Permanent, Proc, Reactive Proc |
| effect2 | varchar(200) | |
| effecttype2 | list | A value in the list: Activatable, Permanent, Proc, Reactive Proc |
| level | int(11) | Minimum level to use this item? |
| novalue | tinyint(4) | |
| maxrange | smallint(6) | |
| ornate | tinyint(4) | If NOT null, this item is flagged as ORNATE |
| foodduration | varchar(22) | How long the food or drink lasts (text) |
| isBeta | tinyint(3) unsigned | If 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
