createringinfo.sql

天之炼狱OpenDE_SQL.tar.gz

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

--
-- Table structure for table 'RingInfo'
--

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


INSERT INTO RingInfo VALUES (0,1,'青铜戒','Bronze Ring',1000,1,1,70000,1000,1,0,'(SUM,30)',0,'',50,150,18,64);
INSERT INTO RingInfo VALUES (1,2,'黑光戒','Black Ring',1500,1,2,20000,3000,2,0,'(SUM,40)',1,'',45,140,15,62);
INSERT INTO RingInfo VALUES (2,3,'牧士戒','Priest Ring',2250,1,1,8000,4000,3,1,'(SUM,50)',2,'',40,130,13,60);
INSERT INTO RingInfo VALUES (3,4,'金戒','Gold Ring',3300,1,1,1500,6000,4,2,'(SUM,60)',3,'',35,120,11,58);
INSERT INTO RingInfo VALUES (4,5,'亚金戒','Aurous Ring',5000,1,2,350,7000,5,2,'(SUM,70)',4,'',30,100,9,56);
INSERT INTO RingInfo VALUES (5,6,'幸运之戒','Lucky Ring',7500,1,2,110,9000,6,3,'(SUM,80)',5,'',25,90,7,54);
INSERT INTO RingInfo VALUES (6,7,'罗撒里傲戒','Rosario',11000,1,2,30,10000,7,3,'(SUM,90)',6,'',20,80,4,52);
INSERT INTO RingInfo VALUES (7,8,'钻石戒','Golden Diamond Ring',17000,1,2,7,12000,8,4,'(SUM,100)',7,'',15,70,3,50);
INSERT INTO RingInfo VALUES (8,9,'白金戒','Platinum Spiral',25000,1,2,2,13000,9,4,'(SUM,110)',8,'',10,60,2,48);
INSERT INTO RingInfo VALUES (9,11,'圣十字戒','Ankh Ring',50000,1,2,1,15000,10,5,'(SUM,120)',9,'',5,50,1,46);
INSERT INTO RingInfo VALUES (11,12,'尊从之戒','Esteem Ring',75000,1,2,1,16000,11,5,'(SUM,130)',11,'',3,40,1,44);
INSERT INTO RingInfo VALUES (12,12,'赤红之星','Kabollefa',100000,1,2,1,18000,12,6,'(SUM,140)',12,'',2,30,1,42);
INSERT INTO RingInfo VALUES (10,10,'天神戒','Operio Ring',99999,1,2,0,25000,11,6,'(SUM,30)',10,'INT+8,HP+4,PRO+7',0,0,0,0);