createvampireamuletinfo.sql

天之炼狱OpenDE_SQL.tar.gz

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

--
-- Table structure for table 'VampireAmuletInfo'
--

DROP TABLE IF EXISTS VampireAmuletInfo;
CREATE TABLE VampireAmuletInfo (
  ItemType 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',
  NextItemType tinyint(3) unsigned NOT NULL default '0',
  DowngradeRatio smallint(6) NOT NULL default '0',
  PRIMARY KEY  (ItemType)
) TYPE=MyISAM;

--
-- Dumping data for table 'VampireAmuletInfo'
--


INSERT INTO VampireAmuletInfo VALUES (0,'红色护身符','Rad',3000,1,3,70000,1000,0,0,'(LEV,1)',0,'',50,150,18,1,64);
INSERT INTO VampireAmuletInfo VALUES (1,'蓝色护身符','Ken',4000,1,3,20000,2000,0,1,'(LEV,1)',1,'',45,140,15,2,62);
INSERT INTO VampireAmuletInfo VALUES (2,'紫色护身符','Jera',6000,1,3,8000,4000,1,1,'(LEV,1)',2,'',40,130,13,3,60);
INSERT INTO VampireAmuletInfo VALUES (3,'橙色护身符','Eolh',9000,1,3,1500,5000,2,0,'(LEV,1)',3,'',35,120,11,4,58);
INSERT INTO VampireAmuletInfo VALUES (4,'粉色护身符','Man',13000,1,3,350,7000,2,1,'(LEV,1)',4,'',30,100,9,5,56);
INSERT INTO VampireAmuletInfo VALUES (5,'湖蓝护身符','Bu Man',19000,1,3,110,8000,2,2,'(LEV,1)',5,'',25,90,7,6,54);
INSERT INTO VampireAmuletInfo VALUES (6,'绿色护身符','Ing',28000,1,3,30,10000,3,0,'(LEV,1)',6,'',20,80,4,7,52);
INSERT INTO VampireAmuletInfo VALUES (7,'暗红护身符','Othel',42000,1,3,7,11000,3,1,'(LEV,1)',7,'',15,70,3,8,50);
INSERT INTO VampireAmuletInfo VALUES (8,'草绿护身符','Odal',63000,1,3,2,13000,3,2,'(LEV,1)',8,'',10,60,2,9,48);
INSERT INTO VampireAmuletInfo VALUES (9,'桔红护身符','Daeg',94000,1,3,1,14000,3,3,'(LEV,1)',9,'',5,50,1,11,46);
INSERT INTO VampireAmuletInfo VALUES (10,'幽黄护身符','Sigel',99999,1,3,0,24000,13,9,'(LEV,1)',10,'DAM+4,ATTR+2,VIS+5',0,0,0,10,0);
INSERT INTO VampireAmuletInfo VALUES (11,'翠绿护身符','Is',125000,1,3,1,15000,4,3,'(LEV,1)',11,'',3,40,1,12,44);
INSERT INTO VampireAmuletInfo VALUES (12,'灰色护身符','Feoh',150000,1,3,1,16000,4,4,'(LEV,1)',12,'',2,30,1,12,42);