createbraceletinfo.sql

天之炼狱OpenDE_SQL.tar.gz

################################################################################
#
#  Project : Online Game DARKEDEN
#  Module  : SQL - ItemInfo
#
#  FileName    : CreateBraceletInfo.sql 
#  Description : 霸烙惑狼 迫骂 酒捞袍 沥焊 SQL
#
#  History      Writer          Description
# ------------ -------------- -----------------------------------------------
# 2002.08.09    厘全芒        脚痹 颇老 积己 
#
# 2002.08.20    厘全芒        NextOptionRatio 漠烦 眠啊(Rare酒捞袍侩)
################################################################################


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

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

  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', # Rare酒捞袍侩
  DowngradeRatio		smallint(6)			 NOT NULL default 0,

  PRIMARY KEY  (ItemType)
) TYPE=MyISAM;


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



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



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



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

INSERT INTO BraceletInfo VALUES ( 0, 1, '铁手镯',     'Metal Bracelet',   1000, 1, 2, 70000,  1000,  1, 0, '(SUM,30)',   0, '', 50, 150, 18, 64);
INSERT INTO BraceletInfo VALUES ( 1, 2, '铜手镯',     'Steel Bracelet',   1500, 1, 2, 20000,  3000,  2, 1, '(SUM,40)',   1, '', 45, 140, 15, 62);
INSERT INTO BraceletInfo VALUES ( 2, 3, '合金手镯',       'Ring Bracelet',    2250, 1, 2,  8000,  4000,  3, 1, '(SUM,50)',   2, '', 40, 130, 13, 60);
INSERT INTO BraceletInfo VALUES ( 3, 4, '金刚手镯', 'Plate Bracelet',   3300, 1, 1,  1500,  6000,  4, 2, '(SUM,60)',   3, '', 35, 120, 11, 58);
INSERT INTO BraceletInfo VALUES ( 4, 5, '亚金手镯',   'Aurous Bracelet',  5000, 1, 1,   350,  7000,  5, 2, '(SUM,70)',   4, '', 30, 100, 9, 56);
INSERT INTO BraceletInfo VALUES ( 5, 6, '女神手镯',     'Laurel Bracelet',  7500, 1, 1,   110,  9000,  6, 3, '(SUM,80)',   5, '', 25,  90, 7, 54);
INSERT INTO BraceletInfo VALUES ( 6, 7, '神圣手镯',           'Bracelet of Job', 11000, 1, 1,    30, 10000,  7, 3, '(SUM,90)',   6, '', 20,  80, 4, 52);
INSERT INTO BraceletInfo VALUES ( 7, 8, '奴隶手镯',       'Slave Bangle',    17000, 1, 1,     7, 12000,  8, 4, '(SUM,100)',  7, '', 15,  70, 3, 50);
INSERT INTO BraceletInfo VALUES ( 8, 9, '圣十字手镯',   'Cross Bracelet',  25000, 1, 1,     2, 13000,  9, 4, '(SUM,110)',  8, '', 10,  60, 2, 48);
INSERT INTO BraceletInfo VALUES ( 9,11, '圣灵手镯',       'Holy Spirit',     50000, 1, 1,     1, 15000, 10, 5, '(SUM,120)',  9, '',  5,  50, 1, 46);
INSERT INTO BraceletInfo VALUES (11,12, '宝石手镯',   'Solis Bracelet',  75000, 1, 1,     1, 16000, 11, 5, '(SUM,130)', 11, '',  3,  40, 1, 44);
INSERT INTO BraceletInfo VALUES (12,12, '达佩尔手镯',  'Dhampir Bracelet',100000, 1, 1,     1, 18000, 12, 6, '(SUM,140)', 12, '',  2,  30, 1, 42);
# 蜡聪农 酒捞袍
INSERT INTO BraceletInfo VALUES (10,10, '天鹰手镯',   'Aquila Bracelet', 99999, 1, 1,      0, 25000, 11, 5, '(SUM,120)', 10, 'DAM+3,STR+5,RES+3',  0,   0, 0, 0);