createvampireringinfo.sql

天之炼狱OpenDE_SQL.tar.gz

################################################################################
#
#  Project : Online Game DARKEDEN
#  Module  : SQL - Item Info
#
#  FileName    : CreateVampireRingInfo.sql
#  Description : 轨颇捞绢 馆瘤 酒捞袍 沥焊
#
#  History      Writer          Description
# ------------ -------------- -----------------------------------------------
# 2002.08.13    厘全芒        脚痹 颇老 积己 
#
# 2002.08.23    厘全芒        蜡聪农 酒捞袍 眠啊
################################################################################


################################################################################
# 抛捞喉 积己 
DROP TABLE IF EXISTS VampireRingInfo;

CREATE TABLE VampireRingInfo (
  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;


################################################################################
# 牢郸胶 积己



################################################################################
# Sequence 积己



################################################################################
# 鼻茄 汲沥 



################################################################################
# 单捞磐 持扁

INSERT INTO VampireRingInfo VALUES ( 0, '铁戒',       'Iron Ring',       3000, 1, 3, 100000,  1000,  1, 0, '(LEV,5)',   0, '', 50, 150, 18, 1, 64);
INSERT INTO VampireRingInfo VALUES ( 1, '银戒',         'Silver Ring',     4000, 1, 2,  10000,  2000,  2, 0, '(LEV,10)',  1, '', 45, 140, 15, 2, 62);
INSERT INTO VampireRingInfo VALUES ( 2, '螺旋戒',         'Winkle Ring',     6000, 1, 2,   3000,  4000,  3, 1, '(LEV,15)',  2, '', 40, 130, 13, 3, 60);
INSERT INTO VampireRingInfo VALUES ( 3, '嵌金戒',         'Gilt Ring',       9000, 1, 2,    900,  5000,  4, 1, '(LEV,20)',  3, '', 35, 120, 11, 4, 58);
INSERT INTO VampireRingInfo VALUES ( 4, '落日戒',      'Anti-Sun Ring',  13000, 1, 1,    360,  7000,  5, 2, '(LEV,25)',  4, '', 30, 100, 9, 5, 56);
INSERT INTO VampireRingInfo VALUES ( 5, '蓝色诱惑',     'Blue Seduction', 19000, 1, 1,    108,  8000,  6, 2, '(LEV,30)',  5, '', 25,  90, 7, 6, 54);
INSERT INTO VampireRingInfo VALUES ( 6, '吸血魔戒',     'Blood Sucker',   28000, 1, 1,     24, 10000,  7, 3, '(LEV,35)',  6, '', 20,  80, 4, 7, 52);
INSERT INTO VampireRingInfo VALUES ( 7, '邪恶戒',     'Unholy Shield',  42000, 1, 1,      7, 11000,  8, 3, '(LEV,40)',  7, '', 15,  70, 3, 8, 50);
INSERT INTO VampireRingInfo VALUES ( 8, '骷髅戒',  'Ring of Skulls', 63000, 1, 1,      2, 13000,  9, 4, '(LEV,45)',  8, '', 10,  60, 2, 9, 48);
INSERT INTO VampireRingInfo VALUES ( 9, '蛛眼戒', 'Spider Eyes',    94000, 1, 1,      1, 14000, 10, 4, '(LEV,50)',  9, '',  5,  50, 1, 11, 46);
INSERT INTO VampireRingInfo VALUES (10, '灭绝之戒',         'Mortal Ring',    99999, 1, 1,      0, 24000, 11, 7, '(LEV,50)', 10, 'BLRES+4,ASPD+4,DEF+3',  0,   0, 0, 10, 0);
INSERT INTO VampireRingInfo VALUES (11, '芬里厄之怒',  	   'Fenrir Ring',   125000, 1, 1,      1, 15000, 11, 5, '(LEV,55)', 11, '',  3,  40, 1, 12, 44);
INSERT INTO VampireRingInfo VALUES (12, '蝮蛇之戒',  	   'Asp Ring',   	150000, 1, 1,      1, 17500, 12, 6, '(LEV,60)', 12, '',  2,  30, 1, 12, 42);