createvampireweaponinfo.sql

天之炼狱OpenDE_SQL.tar.gz

################################################################################
#
#  Project : Online Game DARKEDEN
#  Module  : SQL - ItemInfo
#
#  FileName    : CreateVampireWeaponInfo.sql 
#  Description : 轨颇捞绢 公扁 沥焊 
#
#  History      Writer          Description
# ------------ -------------- -----------------------------------------------
# 2002.08.09    厘全芒        脚痹 颇老 积己 
#
# 2002.08.21    厘全芒        NextOptionRatio 漠烦 眠啊(Rare酒捞袍侩)
#
# 2002.08.23    厘全芒        蜡聪农 酒捞袍 眠啊
#
################################################################################


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

CREATE TABLE VampireWeaponInfo (
  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',

  minDamage 			smallint(5) unsigned NOT NULL default '0',
  maxDamage 			smallint(5) unsigned NOT NULL default '0',
  ToHitBonus 			tinyint(3)  unsigned NOT NULL default '0',
  Range 				tinyint(3)  unsigned NOT NULL default '0',
  Speed 				smallint(5) unsigned NOT NULL default '0',
  ReqAbility 			varchar(50)          NOT NULL default '',
  ItemLevel 			tinyint(3)  unsigned NOT NULL default '0',
  CriticalBonus 		int(10)     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', # Rare酒捞袍侩

  NextItemType			tinyint(3)	unsigned NOT NULL default '0', 
  DowngradeRatio		smallint(6)			 NOT NULL default 0,

  PRIMARY KEY  (ItemType)
) TYPE=MyISAM;


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



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



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



################################################################################
# 单捞磐 持扁
INSERT INTO VampireWeaponInfo VALUES ( 0, '破碎拳套',       'Knuckle Part',            2000, 5, 1, 60000,  6000,  1,  3, 0, 1, 30, '(LEV,15)',  0,  5, '', 50, 150, 18, 1, 62);
INSERT INTO VampireWeaponInfo VALUES ( 1, '简易拳套',         'Thumb Grab',              4000, 5, 1, 20000,  9500,  1,  4, 0, 1, 30, '(LEV,20)',  1, 10, '', 47, 145, 17, 2, 61);
INSERT INTO VampireWeaponInfo VALUES ( 2, '强力拳套',       'Force Knuckle',           8000, 5, 1,  9000, 13000,  1,  5, 0, 1, 30, '(LEV,25)',  2, 15, '', 43, 140, 16, 3, 60);
INSERT INTO VampireWeaponInfo VALUES ( 3, '合金拳套',  'Geminal Ring Knuckle',   16000, 5, 1,  4500, 16500,  1,  6, 0, 1, 30, '(LEV,28)',  3, 20, '', 40, 130, 15, 4, 59);
INSERT INTO VampireWeaponInfo VALUES ( 4, '野人刺',     'Yeti''s Craw',           32000, 5, 1,  3000, 20000,  1,  7, 0, 1, 35, '(LEV,30)',  4, 25, '', 38, 120, 14, 5, 58);
INSERT INTO VampireWeaponInfo VALUES ( 5, '猫之拳套',     'Cat''s Craw',            70000, 5, 1,  1500, 23500,  2,  8, 0, 1, 30, '(LEV,33)',  5, 30, '', 35, 110, 13, 6, 57);
INSERT INTO VampireWeaponInfo VALUES ( 6, '鹰之拳套',     'Fist Knuckle',          140000, 5, 1,   900, 27000,  4,  9, 0, 1, 25, '(LEV,35)',  6, 35, '', 32, 100, 12, 7, 56);
INSERT INTO VampireWeaponInfo VALUES ( 7, '破坏拳套',     'APE Knuckle',           210000, 5, 1,   536, 30500,  4, 10, 0, 1, 25, '(LEV,38)',  7, 40, '', 28,  90, 11, 8, 55);
INSERT INTO VampireWeaponInfo VALUES ( 8, '强力拳套',       'SAV Knuckle',           300000, 5, 1,   300, 34000,  4, 11, 0, 1, 30, '(LEV,40)',  8, 45, '', 25,  80, 10, 9, 54);
INSERT INTO VampireWeaponInfo VALUES ( 9, '夺命拳套',  'Sif''s Hand Knuckle',   400000, 5, 1,   150, 37500,  3, 13, 0, 1, 35, '(LEV,45)',  9, 50, '', 22,  75, 8, 10, 53);
INSERT INTO VampireWeaponInfo VALUES (10, '索魂刺',  'Loon Diver Knuckle',    500000, 5, 1,    80, 41000,  4, 13, 0, 1, 35, '(LEV,50)', 10, 50, '', 19,  70, 6, 11, 52);
INSERT INTO VampireWeaponInfo VALUES (11, '显贵拳套',     'Might Knuckle',         700000, 5, 1,    24, 44500,  5, 13, 0, 1, 30, '(LEV,55)', 11, 50, '', 15,  65, 5, 12, 51);
INSERT INTO VampireWeaponInfo VALUES (12, '死神拳套',        'Zamadar',               900000, 5, 1,     7, 48000,  7, 14, 0, 1, 30, '(LEV,60)', 12, 50, '', 10,  60, 3, 13, 50);
INSERT INTO VampireWeaponInfo VALUES (13, '地狱火拳套',          'Katar',                1200000, 5, 1,     2, 51500,  8, 15, 0, 1, 30, '(LEV,65)', 13, 50, '',  7,  55, 2, 14, 49);
INSERT INTO VampireWeaponInfo VALUES (14, '暗黑狂魔拳套', 'Amemet''s Craw',       1500000, 5, 1,     1, 55000, 10, 15, 0, 1, 30, '(LEV,70)', 14, 50, '',  5,  50, 1, 16, 48);
INSERT INTO VampireWeaponInfo VALUES (15, '天使刺',          'MARAX',                2000000, 5, 1,     0, 27750,  8, 13, 0, 1, 10, '(LEV,60)', 15, 50, 'DAM+3,STR+8,ASPD+3',  0,  0, 0, 17, 0);
INSERT INTO VampireWeaponInfo VALUES (16, '扎坎之牙', 			 'Zagan',       		 1800000, 5, 1,     1, 58500, 12, 17, 0, 1, 25, '(LEV,75)', 16, 50, '',  3,  40, 1, 17, 47);
INSERT INTO VampireWeaponInfo VALUES (17, '巴格纳之爪', 		 'Bagh Nakh',      		 2400000, 5, 1,     1, 62000, 14, 20, 0, 1, 25, '(LEV,80)', 17, 50, '',  2,  30, 1, 17, 46);