createnecklaceinfo.sql

天之炼狱OpenDE_SQL.tar.gz

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

--
-- Table structure for table 'NecklaceInfo'
--

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


INSERT INTO NecklaceInfo VALUES (0,1,'十字架护身符','Cross Pendant',1000,1,1,70000,1000,1,0,'(SUM,30)',0,'',50,150,18,64);
INSERT INTO NecklaceInfo VALUES (1,2,'祖母绿护身符','Emerald Pendant',1500,1,1,20000,3000,2,1,'(SUM,40)',1,'',45,140,15,62);
INSERT INTO NecklaceInfo VALUES (2,3,'白金护身符','Platinum Pendant',2250,1,1,8000,4000,3,1,'(SUM,50)',2,'',40,130,13,60);
INSERT INTO NecklaceInfo VALUES (3,4,'亚金护身符','Aurous Pendant',3300,1,1,1500,6000,4,2,'(SUM,60)',3,'',35,120,11,58);
INSERT INTO NecklaceInfo VALUES (4,5,'新月项链','Crescent Necklace',5000,1,1,350,7000,5,2,'(SUM,70)',4,'',30,100,9,56);
INSERT INTO NecklaceInfo VALUES (5,6,'蓝光','Blue Sense',7500,1,1,110,9000,6,3,'(SUM,80)',5,'',25,90,7,54);
INSERT INTO NecklaceInfo VALUES (6,7,'圣十字架护身符','Inri Cross',11000,1,1,30,10000,7,3,'(SUM,90)',6,'',20,80,4,52);
INSERT INTO NecklaceInfo VALUES (7,8,'轮回之星','Rebirth Pentacle',17000,1,1,7,10000,8,4,'(SUM,100)',7,'',15,70,3,50);
INSERT INTO NecklaceInfo VALUES (8,9,'圣血护身符','Blood Cross',25000,1,1,2,13000,9,4,'(SUM,110)',8,'',10,60,2,48);
INSERT INTO NecklaceInfo VALUES (9,11,'圣环护身符','Silver Necklace',50000,1,1,1,15000,10,5,'(SUM,120)',9,'',5,50,1,46);
INSERT INTO NecklaceInfo VALUES (11,12,'复活之链','Trinity Necklace',75000,1,1,1,16000,11,5,'(SUM,130)',11,'',3,40,1,44);
INSERT INTO NecklaceInfo VALUES (12,12,'风暴护身符','Morgan le Fay',100000,1,1,1,18000,12,6,'(SUM,140)',12,'',2,30,1,42);
INSERT INTO NecklaceInfo VALUES (10,10,'圣恩护身符','Mercy Necklace',99999,1,1,0,25000,12,6,'(SUM,200)',10,'TOHIT+10,DEX+8,HPSTL+6',0,0,0,0);