createvampireearringinfo.sql

天之炼狱OpenDE_SQL.tar.gz

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


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

CREATE TABLE VampireEarringInfo (
  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 VampireEarringInfo VALUES ( 0, '青铜耳环',             'Bronze Earring',           3000, 1, 3, 70000,  1000,   3, 1, '(LEV,5)',  0, '', 50, 150, 18, 1, 64);
INSERT INTO VampireEarringInfo VALUES ( 1, '银耳环',               'Silver Earring',           4000, 1, 3, 20000,  2000,   4, 1, '(LEV,10)', 0, '', 45, 140, 15, 2, 62);
INSERT INTO VampireEarringInfo VALUES ( 2, '金耳环',               'Gold Earring',             6000, 1, 3,  8000,  4000,   5, 2, '(LEV,15)', 0, '', 40, 130, 13, 3, 60);
INSERT INTO VampireEarringInfo VALUES ( 3, '死亡之光',            'Death Sun Earring',        9000, 1, 3,  1500,  5000,   6, 2, '(LEV,20)', 0, '', 35, 120, 11, 4, 58);
INSERT INTO VampireEarringInfo VALUES ( 4, '神秘之环',          'Bats Circle Earring',     13000, 1, 3,   350,  7000,   7, 3, '(LEV,25)', 0, '', 30, 100, 9, 5, 56);
INSERT INTO VampireEarringInfo VALUES ( 5, '暗黑护身符',        'Shield of Darkness',      19000, 1, 3,   110,  8000,   8, 3, '(LEV,30)', 0, '', 25,  90, 7, 6, 54);
INSERT INTO VampireEarringInfo VALUES ( 6, '血光之环',             'Bloody Feast',            28000, 1, 3,    30, 10000,  10, 5, '(LEV,35)', 0, '', 20,  80, 4, 7, 52);
INSERT INTO VampireEarringInfo VALUES ( 7, '永生之环', 'Earring of Eternal Life', 42000, 1, 3,     7, 11000,  11, 5, '(LEV,40)', 0, '', 15,  70, 3, 8, 50);
INSERT INTO VampireEarringInfo VALUES ( 8, '猫眼',              'The Cats Eyes',           63000, 1, 3,     2, 13000,  12, 7, '(LEV,45)', 0, '', 10,  60, 2, 9, 48);
INSERT INTO VampireEarringInfo VALUES ( 9, '末日审判',      'Skull of Destruction',    94000, 1, 3,     1, 14000,  13, 7, '(LEV,50)', 0, '',  5,  50, 1, 11, 46);
INSERT INTO VampireEarringInfo VALUES (10, '灵动之环',             'Ates Earring',            99999, 1, 3,     0, 23000,  10, 5, '(LEV,50)', 0, 'HP+4,INT+9,HPRGN+3', 0,  0, 0, 10, 0);
INSERT INTO VampireEarringInfo VALUES (11, '调和的宣言',      			'The Oath of Harmony', 	  125000, 1, 3,     1, 15000,  14, 9, '(LEV,65)', 0, '',  3,  40, 1, 12, 44);
INSERT INTO VampireEarringInfo VALUES (12, '青玉',      			'Hyacinth', 			  150000, 1, 3,     1, 17500,  15,10, '(LEV,70)', 0, '',  2,  30, 1, 12, 42);