items[v1].sql.svn-base

絲路server源碼 Silk Road server source

--------------------------
Edited by hitomi2
--------------------------


CREATE TABLE `items` (
  `IID` int(11) NOT NULL auto_increment,
  `ItemID` varchar(8) NOT NULL default '',
  `ItemExtraName` varchar(50) NOT NULL default '',
  `ItemName` varchar(50) NOT NULL default '',
  `ItemType` int(3) NOT NULL default '0',
  `ItemLevel` int(8) NOT NULL default '0',
  `ItemCost` bigint(20) NOT NULL default '0',
  `ItemResell` bigint(20) NOT NULL default '0',
  `ItemData1` int(8) NOT NULL default '0',
  `ItemData2` int(8) NOT NULL default '0',
  `ItemClass` int(8) NOT NULL default '0',
  `ItemData3` varchar(15) NOT NULL default '',
  `ItemData4` varchar(15) NOT NULL default '',
  `ItemData5` varchar(15) NOT NULL default '',
  `ItemData6` varchar(15) NOT NULL default '',
  `ItemSig1` varchar(15) NOT NULL default '',
  `ItemSig2` varchar(15) NOT NULL default '',
  `ItemSig3` varchar(15) NOT NULL default '',
  PRIMARY KEY `IID` (`IID`)
) TYPE=MyISAM AUTO_INCREMENT=7778 ;