createousterswristletinfo.sql

天之炼狱OpenDE_SQL.tar.gz

################################################################################
#
#  Project : Online Game DARKEDEN
#  Module  : SQL - ItemInfo
#
#  FileName    : CreateOustersWristletInfo.sql 
#  Description : 酒快胶磐胶 府胶撇复 沥焊 
#
#  History      Writer          Description
# ------------ -------------- -----------------------------------------------
# 2002.05.21    硅犁屈        脚痹 颇老 积己 
#
################################################################################


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

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

  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 '',
  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酒捞袍侩

  NextItemType			tinyint(3)	unsigned NOT NULL default '0', 
  DowngradeRatio		smallint(6)			 NOT NULL default 0,

  ElementalType			tinyint(3)  unsigned NOT NULL default '0',
  Elemental             tinyint(3)  unsigned NOT NULL default '0',

  PRIMARY KEY  (ItemType)
) TYPE=MyISAM;


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



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



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



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

INSERT INTO OustersWristletInfo VALUES ( 0, '自然腕饰',		'Natural Wristlet',		    400, 6, 1, 60000,  3200, 1, 6, 0, 3, 0,  '(INT,10)', 1, 5, '', 50, 150, 18, 1, 62, 0, 1);
INSERT INTO OustersWristletInfo VALUES ( 1, '藤蔓腕饰',		'Vine Wristlet',		    880, 6, 1, 20000,  5360, 2, 8, 0, 4, 0,  '(INT,21)', 1, 5, '', 50, 150, 18, 2, 62, 0, 1);
INSERT INTO OustersWristletInfo VALUES ( 2, '黄铜之臂',		'Lardun Wristlet',		   2080, 6, 1, 15000,  7360, 2, 9, 0, 4, 0,  '(INT,43)', 3, 5, '', 50, 150, 18, 3, 62, 0, 2);
INSERT INTO OustersWristletInfo VALUES ( 3, '洪荒之臂',		'Yohwen\'s Wristlet',	   4800, 6, 1,  3700,  9120, 3,10, 0, 5, 0,  '(INT,66)', 3, 5, '', 50, 150, 18, 4, 62, 0, 2);
INSERT INTO OustersWristletInfo VALUES ( 4, '水晶腕饰',	'Nixflos Wristlet',		  11200, 6, 1,   800, 11200, 5,12, 0, 5, 0,  '(INT,82)', 5, 5, '', 50, 150, 18, 5, 62, 0, 3);
INSERT INTO OustersWristletInfo VALUES ( 5, '泪之腕饰',	'Lacrima Wristlet',		  25600, 6, 1,   330, 14000, 8,12, 0, 6, 0,  '(INT,95)', 5, 5, '', 50, 150, 18, 6, 62, 0, 3);
INSERT INTO OustersWristletInfo VALUES ( 6, '白银之臂',	'Sempitrnus Wristlet',	  60000, 6, 1,   135, 15200, 6,15, 0, 6, 0, '(INT,120)', 7, 5, '', 50, 150, 18, 7, 62, 0, 4);
INSERT INTO OustersWristletInfo VALUES ( 7, '芒杜腕饰',		'Mundus Wristlet',		 136000, 6, 1,    22, 17840, 7,17, 0, 7, 0, '(INT,145)', 7, 5, '', 50, 150, 18, 8, 62, 0, 4);
INSERT INTO OustersWristletInfo VALUES ( 8, '众神腕饰',	'Sanctus Wristlet',		 312000, 6, 1,     8, 22160,11,16, 0, 7, 0, '(INT,168)', 9, 5, '', 50, 150, 18, 9, 62, 0, 5);
INSERT INTO OustersWristletInfo VALUES ( 9, '炙炎腕饰',		'Torrid Wristlet',		 592000, 6, 1,     5, 25600,12,19, 0, 8, 0, '(INT,190)', 9, 5, '', 50, 150, 18, 9, 62, 0, 5);

INSERT INTO OustersWristletInfo VALUES ( 10, '自然腕饰',		'Natural Wristlet',		    400, 6, 1, 60000,  3200, 1, 6, 0, 3, 0,  '(INT,10)', 1, 5, '', 50, 150, 18, 11, 62, 1, 1);
INSERT INTO OustersWristletInfo VALUES ( 11, '藤蔓腕饰',		'Vine Wristlet',		    880, 6, 1, 20000,  5360, 2, 8, 0, 4, 0,  '(INT,21)', 1, 5, '', 50, 150, 18, 12, 62, 1, 1);
INSERT INTO OustersWristletInfo VALUES ( 12, '黄铜之臂',		'Lardun Wristlet',		   2080, 6, 1, 15000,  7360, 2, 9, 0, 4, 0,  '(INT,43)', 3, 5, '', 50, 150, 18, 13, 62, 1, 2);
INSERT INTO OustersWristletInfo VALUES ( 13, '洪荒之臂',		'Yohwen\'s Wristlet',	   4800, 6, 1,  3700,  9120, 3,10, 0, 5, 0,  '(INT,66)', 3, 5, '', 50, 150, 18, 14, 62, 1, 2);
INSERT INTO OustersWristletInfo VALUES ( 14, '水晶腕饰',	'Nixflos Wristlet',		  11200, 6, 1,   800, 11200, 5,12, 0, 5, 0,  '(INT,82)', 5, 5, '', 50, 150, 18, 15, 62, 1, 3);
INSERT INTO OustersWristletInfo VALUES ( 15, '泪之腕饰',	'Lacrima Wristlet',		  25600, 6, 1,   330, 14000, 8,12, 0, 6, 0,  '(INT,95)', 5, 5, '', 50, 150, 18, 16, 62, 1, 3);
INSERT INTO OustersWristletInfo VALUES ( 16, '白银之臂',	'Sempitrnus Wristlet',	  60000, 6, 1,   135, 15200, 6,15, 0, 6, 0, '(INT,120)', 7, 5, '', 50, 150, 18, 17, 62, 1, 4);
INSERT INTO OustersWristletInfo VALUES ( 17, '芒杜腕饰',		'Mundus Wristlet',		 136000, 6, 1,    22, 17840, 7,17, 0, 7, 0, '(INT,145)', 7, 5, '', 50, 150, 18, 18, 62, 1, 4);
INSERT INTO OustersWristletInfo VALUES ( 18, '众神腕饰',	'Sanctus Wristlet',		 312000, 6, 1,     8, 22160,11,16, 0, 7, 0, '(INT,168)', 9, 5, '', 50, 150, 18, 19, 62, 1, 5);
INSERT INTO OustersWristletInfo VALUES ( 19, '炙炎腕饰',		'Torrid Wristlet',		 592000, 6, 1,     5, 25600,12,19, 0, 8, 0, '(INT,190)', 9, 5, '', 50, 150, 18, 19, 62, 1, 5);

INSERT INTO OustersWristletInfo VALUES ( 20, '自然腕饰',		'Natural Wristlet',		    400, 6, 1, 60000,  3200, 1, 6, 0, 3, 0,  '(INT,10)', 1, 5, '', 50, 150, 18, 21, 62, 2, 1);
INSERT INTO OustersWristletInfo VALUES ( 21, '藤蔓腕饰',		'Vine Wristlet',		    880, 6, 1, 20000,  5360, 2, 8, 0, 4, 0,  '(INT,21)', 1, 5, '', 50, 150, 18, 22, 62, 2, 1);
INSERT INTO OustersWristletInfo VALUES ( 22, '黄铜之臂',		'Lardun Wristlet',		   2080, 6, 1, 15000,  7360, 2, 9, 0, 4, 0,  '(INT,43)', 3, 5, '', 50, 150, 18, 23, 62, 2, 2);
INSERT INTO OustersWristletInfo VALUES ( 23, '洪荒之臂',		'Yohwen\'s Wristlet',	   4800, 6, 1,  3700,  9120, 3,10, 0, 5, 0,  '(INT,66)', 3, 5, '', 50, 150, 18, 24, 62, 2, 2);
INSERT INTO OustersWristletInfo VALUES ( 24, '水晶之臂',	'Nixflos Wristlet',		  11200, 6, 1,   800, 11200, 5,12, 0, 5, 0,  '(INT,82)', 5, 5, '', 50, 150, 18, 25, 62, 2, 3);
INSERT INTO OustersWristletInfo VALUES ( 25, '泪之腕饰',	'Lacrima Wristlet',		  25600, 6, 1,   330, 14000, 8,12, 0, 6, 0,  '(INT,95)', 5, 5, '', 50, 150, 18, 26, 62, 2, 3);
INSERT INTO OustersWristletInfo VALUES ( 26, '白银之臂',	'Sempitrnus Wristlet',	  60000, 6, 1,   135, 15200, 6,15, 0, 6, 0, '(INT,120)', 7, 5, '', 50, 150, 18, 27, 62, 2, 4);
INSERT INTO OustersWristletInfo VALUES ( 27, '芒杜腕饰',		'Mundus Wristlet',		 136000, 6, 1,    22, 17840, 7,17, 0, 7, 0, '(INT,145)', 7, 5, '', 50, 150, 18, 28, 62, 2, 4);
INSERT INTO OustersWristletInfo VALUES ( 28, '众神腕饰',	'Sanctus Wristlet',		 312000, 6, 1,     8, 22160,11,16, 0, 7, 0, '(INT,168)', 9, 5, '', 50, 150, 18, 29, 62, 2, 5);
INSERT INTO OustersWristletInfo VALUES ( 29, '炙炎腕饰',		'Torrid Wristlet',		 592000, 6, 1,     5, 25600,12,19, 0, 8, 0, '(INT,190)', 9, 5, '', 50, 150, 18, 29, 62, 2, 5);