createbladeinfo.sql

天之炼狱OpenDE_SQL.tar.gz

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


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

CREATE TABLE BladeInfo (
  ItemType 				tinyint(3)  unsigned NOT NULL default '0',
  NextItemType			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 '',
  MaxSilver 			smallint(5) unsigned NOT NULL default '0',
  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酒捞袍侩
  DowngradeRatio		smallint(6)			 NOT NULL default 0,


  PRIMARY KEY  (ItemType)

) TYPE=MyISAM;


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



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



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



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

INSERT INTO BladeInfo VALUES ( 0, 1, '弯刀',        'Cutlass',           700, 6, 1, 70000,  5500,  1, 10, 0, 1, 60, '(SUM,20)',   550,  0,  5, '', 50, 150, 18, 64);
INSERT INTO BladeInfo VALUES ( 1, 2, '通灵刀',         'Long Shamsheer',   1500, 6, 1, 20000,  8000,  2, 14, 0, 1, 40, '(STR,21)',   800,  1, 10, '', 45, 140, 15, 62);
INSERT INTO BladeInfo VALUES ( 2, 3, '大砍刀',            'Falchion',         3400, 6, 1,  8000, 11000,  4, 18, 0, 1, 45, '(STR,31)',  1100,  2, 15, '', 40, 130, 13, 60);
INSERT INTO BladeInfo VALUES ( 3, 4, '板门刀', 'Severed Blade',    7500, 6, 1,  1500, 15000,  8, 22, 0, 1, 35, '(STR,43)',  1500,  3, 20, '', 35, 120, 11, 58);
INSERT INTO BladeInfo VALUES ( 4, 5, '妖月刀',     'Moon Blade',      16500, 6, 1,   350, 20000, 15, 25, 0, 1, 50, '(STR,57)',  2000,  4, 25, '', 30, 100, 9, 56);
INSERT INTO BladeInfo VALUES ( 5, 6, '聚灵刀',          'Savour',          36000, 6, 1,   110, 22000, 17, 27, 0, 1, 40, '(STR,63)',  2200,  5, 30, '', 25,  90, 7, 54);
INSERT INTO BladeInfo VALUES ( 6, 7, '大环刀',     'Ring Blade',      79000, 6, 1,    30, 24000, 18, 30, 0, 1, 45, '(STR,69)',  2400,  6, 35, '', 20,  80, 4, 52);
INSERT INTO BladeInfo VALUES ( 7, 8, '波斯弯刀',          'Scimitar',       175000, 6, 1,     7, 27500, 20, 35, 0, 1, 20, '(STR,79)',  2750,  7, 40, '', 15,  70, 3, 50);
INSERT INTO BladeInfo VALUES ( 8, 9, '战神刀',          'Khopesh',        380000, 6, 1,     2, 31000, 22, 40, 0, 1, 15, '(STR,89)',  3100,  8, 45, '', 10,  60, 2, 48);
INSERT INTO BladeInfo VALUES ( 9,11, '武神刀',          'Katana',         850000, 6, 1,     1, 35000, 30, 40, 0, 1, 10, '(STR,100)', 3500,  9, 50, '',  5,  50, 1, 46);
INSERT INTO BladeInfo VALUES (11,12, '科拉琴',            'Kora',          1450000, 6, 1,     1, 39000, 33, 45, 0, 1, 10, '(STR,110)', 3900, 11, 55, '',  3,  40, 1, 44);
INSERT INTO BladeInfo VALUES (12,12, 'Rhomphaia',        'Rhomphaia',     2700000, 6, 1,     1, 42000, 35, 48, 0, 1, 10, '(STR,120)', 4200, 12, 60, '',  2,  30, 1, 42);

# 蜡聪农 酒捞袍
INSERT INTO BladeInfo VALUES (10,10, '百战刀',     'Bone Blade',     999999, 6, 1,     0, 45000, 32, 38, 0, 1, 15, '(STR,120)', 4500, 10, 60, 'DAM+4,STR+3,ASPD+2', 0, 0, 0, 0);