createousterspendentinfo.sql

天之炼狱OpenDE_SQL.tar.gz

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


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

CREATE TABLE OustersPendentInfo (
  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',
  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 '',
  Ratio 				int(11)              NOT NULL default '0',
  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 OustersPendentInfo VALUES ( 0, '小圆挂饰',			'Revers Dot Pendent',		   800, 1, 3, 1000, 1, 0,  '(LEV,5)', 60000, 1, '', 50, 150, 18, 1, 64);
INSERT INTO OustersPendentInfo VALUES ( 1, '奥里萨挂饰',				'Orissa Pendent',			  1200, 1, 3, 3000, 2, 1, '(LEV,10)', 20000, 1, '', 50, 150, 18, 2, 64);
INSERT INTO OustersPendentInfo VALUES ( 2, '神秘挂饰',				'Mystic Pendent',			  1800, 1, 3, 4000, 3, 2, '(LEV,15)', 15000, 3, '', 50, 150, 18, 3, 64);
INSERT INTO OustersPendentInfo VALUES ( 3, '天地挂饰',				'Yggdrasil Pendent',		  2640, 1, 3, 6000, 4, 2, '(LEV,20)',  3700, 3, '', 50, 150, 18, 4, 64);
INSERT INTO OustersPendentInfo VALUES ( 4, '圣水挂饰',			'Sinui\'s Pendent',			  4000, 1, 3, 7000, 5, 3, '(LEV,25)',   800, 5, '', 50, 150, 18, 5, 64);
INSERT INTO OustersPendentInfo VALUES ( 5, '何露斯之眼',	'Eyes of Horus Pendent',	  6000, 1, 3, 9000, 6, 3, '(LEV,30)',   330, 5, '', 50, 150, 18, 6, 64);
INSERT INTO OustersPendentInfo VALUES ( 6, '人面挂饰',		'Ent Face Pendent',			  8800, 1, 3,10000, 7, 4, '(LEV,35)',   135, 7, '', 50, 150, 18, 7, 64);
INSERT INTO OustersPendentInfo VALUES ( 7, '魔王之悲',				'Fibula Pendent',			 13600, 1, 3,13000, 8, 4, '(LEV,40)',    22, 7, '', 50, 150, 18, 8, 64);
INSERT INTO OustersPendentInfo VALUES ( 8, '菲拉尔挂饰',				'Fairie Pendent',			 20000, 1, 3,16000, 9, 5, '(LEV,45)',     8, 9, '', 50, 150, 18, 9, 64);
INSERT INTO OustersPendentInfo VALUES ( 9, '苍鹰之链',		'Egyptian Falcon Pendent',	 40000, 1, 3,18000,10, 5, '(LEV,50)',     5, 9, '', 50, 150, 18, 9, 64);