createhelminfo.sql

天之炼狱OpenDE_SQL.tar.gz

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

--
-- Table structure for table 'HelmInfo'
--

DROP TABLE IF EXISTS HelmInfo;
CREATE TABLE HelmInfo (
  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 'HelmInfo'
--


INSERT INTO HelmInfo VALUES (0,1,'防护帽','Hood',100,5,2,70000,100,1,0,'(SUM,30)',0,'',50,130,18,62);
INSERT INTO HelmInfo VALUES (1,2,'铁盔','Iron Helmet',1000,5,6,20000,700,5,2,'(SUM,40)',2,'',45,120,15,60);
INSERT INTO HelmInfo VALUES (2,3,'侦察头盔','Infrared Helmet',3000,5,4,9000,1100,8,3,'(SUM,50)',4,'',40,110,13,58);
INSERT INTO HelmInfo VALUES (3,4,'导航盔','Aim Helmet',9000,5,5,550,1400,11,3,'(SUM,60)',6,'',35,100,11,56);
INSERT INTO HelmInfo VALUES (4,5,'武士盔','Combat Helmet',20000,5,6,320,2000,15,5,'(SUM,70)',8,'',30,90,9,54);
INSERT INTO HelmInfo VALUES (5,6,'冲锋盔','HeadGear',40000,5,6,100,2000,17,6,'(SUM,90)',10,'',25,80,7,52);
INSERT INTO HelmInfo VALUES (6,7,'超级冲锋盔','Combat HeadGear',80000,5,6,20,2500,20,10,'(SUM,120)',12,'',20,70,4,50);
INSERT INTO HelmInfo VALUES (7,8,'红外扫描头盔','Infrared Scanning Helmet',160000,5,6,8,2700,23,12,'(SUM,160)',14,'',10,60,3,48);
INSERT INTO HelmInfo VALUES (8,10,'战神盔','War Plate Helm',300000,5,6,2,3000,27,17,'(SUM,225)',16,'',5,50,1,46);
INSERT INTO HelmInfo VALUES (10,11,'聚合物头盔','Combination Combat Helm',500000,5,6,2,4500,30,20,'(SUM,265)',18,'',3,40,1,44);
INSERT INTO HelmInfo VALUES (11,11,'重装甲头盔','Spangen Helmet',750000,5,6,1,5000,33,23,'(SUM,285)',20,'',2,30,1,42);
INSERT INTO HelmInfo VALUES (9,9,'公爵盔','Duke Helm',999999,5,6,0,4000,33,20,'(SUM,160)',18,'RES+5,ATTR+3',0,0,0,0);