createvampirebraceletinfo.sql

天之炼狱OpenDE_SQL.tar.gz

################################################################################
#
#  Project : Online Game DARKEDEN
#  Module  : SQL - Item Info
#
#  FileName    : CreateVampireBraceletInfo.sql
#  Description : 轨颇捞绢 迫骂 酒捞袍 抛捞喉
#
#  History      Writer          Description
# ------------ -------------- -----------------------------------------------
# 2002.08.13    厘全芒        脚痹 颇老 积己 
#
# 2002.08.20    厘全芒        NextOptionRatio 漠烦 眠啊(Rare酒捞袍侩)
#
# 2002.08.23    厘全芒        蜡聪农 酒捞袍 眠啊
################################################################################


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

CREATE TABLE VampireBraceletInfo (
  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 VampireBraceletInfo VALUES (0, '花边手镯',     'Lace Bracelet',       3000, 1, 3, 70000,  1000,  1, 0, '(LEV,5)',   0, '', 50, 150, 18, 1, 62);
INSERT INTO VampireBraceletInfo VALUES (1, '饰纹手镯',   'Armorial Bracelet',   4000, 1, 2, 20000,  3000,  2, 1, '(LEV,10)',  1, '', 45, 140, 15, 2, 60);
INSERT INTO VampireBraceletInfo VALUES (2, '宝石手镯',       'Jewel Bracelet',      6000, 1, 2,  9000,  4000,  3, 1, '(LEV,15)',  2, '', 40, 130, 13, 3, 58);
INSERT INTO VampireBraceletInfo VALUES (3, '大师手镯',     'Master Bracelet',     9000, 1, 1,   550,  6000,  4, 2, '(LEV,20)',  3, '', 35, 120, 11, 4, 56);
INSERT INTO VampireBraceletInfo VALUES (4, '绿柱石手镯', 'Morganite Bracelet', 13000, 1, 1,   320,  7000,  5, 2, '(LEV,25)',  4, '', 30, 100, 9, 5, 54);
INSERT INTO VampireBraceletInfo VALUES (5, '蓝宝石手镯',         'Blue Monoeye',       19000, 1, 1,   100,  9000,  6, 3, '(LEV,30)',  5, '', 25,  90, 7, 6, 52);
INSERT INTO VampireBraceletInfo VALUES (6, '蓝水晶手镯',              'Blue Water',         28000, 1, 1,    20, 10000,  7, 3, '(LEV,35)',  6, '', 20,  80, 4, 7, 50);
INSERT INTO VampireBraceletInfo VALUES (7, '五毒手镯',     'Viper Bracelet',     42000, 1, 1,     8, 12000,  8, 4, '(LEV,40)',  7, '', 10,  70, 3, 8, 48);
INSERT INTO VampireBraceletInfo VALUES (8, '海神手镯',                'the Abyss',          63000, 1, 1,     2, 13000,  9, 4, '(LEV,45)',  9, '',  5,  60, 1, 10, 46);
INSERT INTO VampireBraceletInfo VALUES (9, '天神手镯',     'Apepi Bracelet',     99999, 1, 1,     0, 23000, 13, 8, '(LEV,55)', 10, 'DAM+4,DEX+7,HPSTL+5',  0,   0, 0, 9, 0);
INSERT INTO VampireBraceletInfo VALUES (10,'敏捷手镯',         'Keen Bracelet',      94000, 1, 1,     1, 14000, 10, 5, '(LEV,50)', 11, '',  3,  40, 1, 11, 44);
INSERT INTO VampireBraceletInfo VALUES (11,'天青石手镯',         'Lapis Lazuli',      125000, 1, 1,     1, 15000, 11, 6, '(LEV,55)', 12, '',  2,  30, 1, 11, 42);