creategloveinfo.sql

天之炼狱OpenDE_SQL.tar.gz

-- MySQL dump 8.22
--
-- Host: localhost    Database: DARKEDEN
---------------------------------------------------------
-- Server version	3.23.54-log

--
-- Table structure for table 'GloveInfo'
--

DROP TABLE IF EXISTS GloveInfo;
CREATE TABLE GloveInfo (
  ItemType tinyint(3) unsigned NOT NULL default '0',
  NextItemType tinyint(3) unsigned NOT NULL default '0',
  Name varchar(30) NOT NULL default '',
  EName varchar(30) NOT NULL default '',
  Price int(10) unsigned NOT NULL default '0',
  Volume tinyint(3) unsigned NOT NULL default '0',
  Weight tinyint(3) unsigned NOT NULL default '0',
  Ratio int(11) NOT NULL default '0',
  Durability smallint(5) unsigned NOT NULL default '0',
  Defense tinyint(3) unsigned NOT NULL default '0',
  Protection tinyint(3) unsigned NOT NULL default '0',
  ReqAbility varchar(50) NOT NULL default '',
  ItemLevel tinyint(3) unsigned NOT NULL default '0',
  DefaultOption varchar(50) NOT NULL default '',
  UpgradeCrashPercent tinyint(4) NOT NULL default '0',
  UpgradeRatio smallint(6) NOT NULL default '0',
  NextOptionRatio tinyint(3) unsigned NOT NULL default '0',
  DowngradeRatio smallint(6) NOT NULL default '0',
  PRIMARY KEY  (ItemType)
) TYPE=MyISAM;

--
-- Dumping data for table 'GloveInfo'
--


INSERT INTO GloveInfo VALUES (0,1,'黑手套','Black Glove',300,5,3,70000,300,2,1,'(SUM,30)',0,'',50,130,18,62);
INSERT INTO GloveInfo VALUES (1,2,'青铜手套','Bronze Gauntlet',700,5,4,20000,600,4,2,'(SUM,40)',2,'',45,120,15,60);
INSERT INTO GloveInfo VALUES (2,3,'牧师手套','Priest Glove',1000,5,5,9000,800,6,2,'(SUM,50)',4,'',40,110,12,58);
INSERT INTO GloveInfo VALUES (3,4,'骑士手套','Knight Gauntlet',3000,5,4,565,1100,8,3,'(SUM,60)',6,'',35,100,10,56);
INSERT INTO GloveInfo VALUES (4,5,'古罗马手套','Cestus',7000,5,5,300,1400,10,4,'(SUM,70)',8,'',30,90,8,54);
INSERT INTO GloveInfo VALUES (5,6,'钢制拳套','Tinplate Gauntlet',20000,5,5,100,1500,11,4,'(SUM,90)',9,'',25,80,5,52);
INSERT INTO GloveInfo VALUES (6,7,'终级拳套','Active Glove',65000,5,5,27,1700,12,5,'(SUM,105)',10,'',15,70,3,50);
INSERT INTO GloveInfo VALUES (7,9,'雷神拳套','Gauntlet of Thor',135000,5,5,8,1900,13,5,'(SUM,130)',11,'',5,60,1,48);
INSERT INTO GloveInfo VALUES (9,10,'精力手套','R-energetic Gloves',270000,5,5,4,2100,14,6,'(SUM,150)',12,'',3,50,1,46);
INSERT INTO GloveInfo VALUES (10,10,'重装甲手套','Cuirassir Gauntlet',430000,5,5,2,2300,15,7,'(SUM,175)',13,'',2,40,1,44);
INSERT INTO GloveInfo VALUES (8,8,'战神拳套','Steel Gauntlet',999999,5,5,0,2900,15,6,'(SUM,30)',12,'PORES+2,BLRES+4,ASPD+3',0,0,0,0);