createvampirenecklaceinfo.sql

天之炼狱OpenDE_SQL.tar.gz

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


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

CREATE TABLE VampireNecklaceInfo (
  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',
  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 '',
  Ratio 				int(11)              NOT NULL default '0',
  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 VampireNecklaceInfo VALUES ( 0, '旋镖项链',   'Boomerang Necklace',  3000, 1, 3,  1000,  1, 0, '(LEV,5)',  70000,  0, '', 50, 150, 18, 1, 64);
INSERT INTO VampireNecklaceInfo VALUES ( 1, '骷髅项链',     'Skull Necklace',      4000, 1, 2,  2000,  2, 0, '(LEV,10)', 20000,  1, '', 45, 140, 15, 2, 62);
INSERT INTO VampireNecklaceInfo VALUES ( 2, '犬齿项链', 'Cuspid Necklace',     6000, 1, 2,  4000,  3, 1, '(LEV,15)',  8000,  2, '', 40, 130, 13, 3, 60);
INSERT INTO VampireNecklaceInfo VALUES ( 3, '黑玉项链',       'Jet Necklace',        9000, 1, 2,  5000,  4, 1, '(LEV,20)',  1500,  3, '', 35, 120, 11, 4, 58);
INSERT INTO VampireNecklaceInfo VALUES ( 4, '魔幻项链',     'Idol Pendant',       13000, 1, 1,  7000,  5, 2, '(LEV,25)',   350,  4, '', 30, 100, 9, 5, 56);
INSERT INTO VampireNecklaceInfo VALUES ( 5, '恶魔项链',       'Anti-cross',         19000, 1, 1,  8000,  6, 2, '(LEV,30)',   110,  5, '', 25,  90, 7, 6, 54);
INSERT INTO VampireNecklaceInfo VALUES ( 6, '死亡之星',         'Death Star',         28000, 1, 1, 10000,  7, 3, '(LEV,35)',    30,  6, '', 20,  80, 4, 7, 52);
INSERT INTO VampireNecklaceInfo VALUES ( 7, '神符',       'Amulet of Omen',     42000, 1, 1, 11000,  8, 3, '(LEV,40)',     7,  7, '', 15,  70, 3, 8, 50);
INSERT INTO VampireNecklaceInfo VALUES ( 8, '黑十字架项链',         'Black Ankh',         63000, 1, 1, 13000,  9, 4, '(LEV,45)',     2,  8, '', 10,  60, 2, 9, 48);
INSERT INTO VampireNecklaceInfo VALUES ( 9, '死神召唤',    'Wing of the Dead',   94000, 1, 1, 14000, 10, 4, '(LEV,50)',     1,  9, '',  5,  50, 1, 11, 46);
INSERT INTO VampireNecklaceInfo VALUES (10, '死之契约',           'Golden Wings',       99999, 1, 1, 24000, 12, 7, '(LEV,1)',      0, 10, 'RES+5,ATTR+3,DEF+3',  0,   0, 0, 10, 0);
INSERT INTO VampireNecklaceInfo VALUES (11, '恶魔之眼',   	 	 'Evil Eye',   		  125000, 1, 1, 15000, 11, 5, '(LEV,55)',     1, 11, '',  3,  40, 1, 12, 44);
INSERT INTO VampireNecklaceInfo VALUES (12, '阿波罗诅咒', 'Fefnir Necklace',  150000, 1, 1, 17500, 12, 6, '(LEV,60)',     1, 12, '',  2,  30, 1, 12, 42);