createoustersringinfo.sql

天之炼狱OpenDE_SQL.tar.gz

################################################################################
#
#  Project : Online Game DARKEDEN
#  Module  : SQL - Item Info
#
#  FileName    : CreateOustersRingInfo.sql
#  Description : 酒快胶磐胶 馆瘤 酒捞袍 沥焊
#
#  History      Writer          Description
# ------------ -------------- -----------------------------------------------
# 2002.05.21    硅犁屈        脚痹 颇老 积己 
#
################################################################################


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

CREATE TABLE OustersRingInfo (
  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 OustersRingInfo VALUES ( 0, '棕榈戒指',			'Hemp\'s Ring',			   800, 1, 3, 60000,  1000, 1, 0,  '(LEV,3)', 1, '', 50, 150, 18, 1, 64);
INSERT INTO OustersRingInfo VALUES ( 1, '钟鸣戒指',			'Celesta Ring',			  1200, 1, 3, 20000,  3000, 2, 1,  '(LEV,6)', 1, '', 50, 150, 18, 2, 64);
INSERT INTO OustersRingInfo VALUES ( 2, '保护之戒',		'Safeguard Ring',		  1800, 1, 3, 15000,  4000, 3, 2, '(LEV,13)', 3, '', 50, 150, 18, 3, 64);
INSERT INTO OustersRingInfo VALUES ( 3, '精灵密语',	'Whisper of Elf Ring',	  2640, 1, 3,  3700,  6000, 4, 2, '(LEV,18)', 3, '', 50, 150, 18, 4, 64);
INSERT INTO OustersRingInfo VALUES ( 4, '远古戒指',			'Mpos Ring',			  4000, 1, 3,   800,  7000, 5, 3, '(LEV,24)', 5, '', 50, 150, 18, 5, 64);
INSERT INTO OustersRingInfo VALUES ( 5, '彗星之戒',	'Tails of Shine Ring',	  6000, 1, 3,   330,  9000, 6, 3, '(LEV,30)', 5, '', 50, 150, 18, 6, 64);
INSERT INTO OustersRingInfo VALUES ( 6, '蛛眼之戒',	'Spider Eyes Ring',		  8800, 1, 3,   135, 10000, 7, 4, '(LEV,36)', 7, '', 50, 150, 18, 7, 64);
INSERT INTO OustersRingInfo VALUES ( 7, '孤星之戒',		'Solitary Star Ring',	 13600, 1, 3,    22, 13000, 8, 4, '(LEV,43)', 7, '', 50, 150, 18, 8, 64);
INSERT INTO OustersRingInfo VALUES ( 8, '幻魔戒',			'Macsan\'s Ring',		 20000, 1, 3,     8, 16000, 9, 5, '(LEV,50)', 9, '', 50, 150, 18, 9, 64);
INSERT INTO OustersRingInfo VALUES ( 9, '永恒之戒',		'Immortality Ring',		 40000, 1, 3,     5, 18000,10, 5, '(LEV,60)', 9, '', 50, 150, 18, 9, 64);