Go Back   EQEmulator Home > EQEmulator Forums > Archives > Archive::Support > Archive::Windows Servers

Archive::Windows Servers Archive area for Windows Servers's posts that were moved here after an inactivity period of 90 days.

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 11-10-2003, 12:36 PM
mByte
Hill Giant
 
Join Date: Feb 2002
Posts: 206
Default

Here is the Current 0.5.0 items table

Code:
--
-- v.0.5.0
--

--
-- Table structure for table 'items'
--

CREATE TABLE items (
  id int(11) NOT NULL default '0',
  minstatus smallint(5) NOT NULL default '0',
  name varchar(64) default NULL,
  aagi int(11) default NULL,
  ac int(11) default NULL,
  accuracy int(11) default NULL,
  acha int(11) default NULL,
  adex int(11) default NULL,
  aint int(11) default NULL,
  asta int(11) default NULL,
  astr int(11) default NULL,
  augtype tinyint(3) default NULL,
  augslot1type tinyint(3) default NULL,
  augslot2type tinyint(3) default NULL,
  augslot3type tinyint(3) default NULL,
  augslot4type tinyint(3) default NULL,
  augslot5type tinyint(3) default NULL,
  avoidance int(11) default NULL,
  awis int(11) default NULL,
  bagsize int(11) default NULL,
  bagslots int(11) default NULL,
  bagtype int(11) default NULL,
  bagwr int(11) default NULL,
  banedmgamt int(11) default NULL,
  banedmgbody int(11) default NULL,
  banedmgrace int(11) default NULL,
  bardtype int(11) default NULL,
  bardvalue int(11) default NULL,
  booktype int(11) default NULL,
  casttime int(11) default NULL,
  casttime2 int(11) default NULL,
  charmfile varchar(32) default NULL,
  classes int(11) default NULL,
  color int(11) default NULL,
  combateffects varchar(10) default NULL,
  cost int(11) default NULL,
  cr int(11) default NULL,
  damage int(11) default NULL,
  deity int(11) default NULL,
  delay int(11) default NULL,
  dr int(11) default NULL,
  effecttype int(11) default NULL,
  elemdmgamt int(11) default NULL,
  elemdmgtype int(11) default NULL,
  factionamt1 int(11) default NULL,
  factionamt2 int(11) default NULL,
  factionamt3 int(11) default NULL,
  factionamt4 int(11) default NULL,
  factionmod1 int(11) default NULL,
  factionmod2 int(11) default NULL,
  factionmod3 int(11) default NULL,
  factionmod4 int(11) default NULL,
  filename varchar(15) default NULL,
  focusid int(11) default NULL,
  fr int(11) default NULL,
  gmflag int(11) NOT NULL,
  hp int(11) default NULL,
  icon int(11) default NULL,
  idfile varchar(30) default NULL,
  itemclass int(11) NOT NULL,
  itemtype int(11) default NULL,
  hasteproclvl int(11) default NULL,
  light int(11) default NULL,
  lore varchar(80) default NULL,
  magic int(11) default NULL,
  mana int(11) default NULL,
  material int(11) default NULL,
  maxcharges int(11) default NULL,
  mr int(11) default NULL,
  nodrop int(11) NOT NULL,
  norent int(11) NOT NULL,
  pr int(11) default NULL,
  races int(11) default NULL,
  range int(11) default NULL,
  reclevel int(11) default NULL,
  recskill int(11) default NULL,
  reqlevel int(11) default NULL,
  sellrate float default NULL,
  shielding int(11) default NULL,
  size int(11) NOT NULL,
  skillmodtype int(11) default NULL,
  skillmodvalue int(11) default NULL,
  slots int(11) NOT NULL,
  spellid int(11) default NULL,
  spellshield int(11) default NULL,
  strikethrough int(11) default NULL,
  stunresist int(11) default NULL,
  tradeskills int(11) default NULL,
  unknown002 int(11) default NULL,
  unknown004 int(11) default NULL,
  unknown005 int(11) default NULL,
  unknown018 int(11) default NULL,
  unknown019 int(11) default NULL,
  unknown020 int(11) default NULL,
  unknown044 int(11) default NULL,
  unknown061 int(11) default NULL,
  unknown067 int(11) default NULL,
  unknown069 int(11) default NULL,
  unknown070 int(11) default NULL,
  unknown076 int(11) default NULL,
  unknown077 int(11) default NULL,
  unknown089 int(11) default NULL,
  unknown091 int(11) default NULL,
  unknown097 int(11) default NULL,
  unknown098 int(11) default NULL,
  unknown099 int(11) default NULL,
  unknown105 int(11) default NULL,
  unknown107 int(11) default NULL,
  unknown108 int(11) default NULL,
  updated datetime default NULL,
  md5sum tinyblob NULL,
  weight int(11) NULL,
  comment varchar(255) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;


--
-- Dumping data for table 'items'
--
__________________
mByte
Reply With Quote
 


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 07:50 AM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3