createoustersarmsbandinfo.sql

天之炼狱OpenDE_SQL.tar.gz

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


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

CREATE TABLE OustersArmsbandInfo (
  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',
  PocketCount			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 OustersArmsbandInfo VALUES ( 0, 1, '木制臂环',				 'Wood Armsband',			  600,  5, 2, 60000,  800, 2, 0, 1,  '(LEV,7)', 1, '', 50, 150, 18, 64);
INSERT INTO OustersArmsbandInfo VALUES ( 1, 2, '宝石臂环',			 'Ayurvedic Armsband',		  900,  5, 2, 20000, 1600, 3, 1, 1, '(LEV,10)', 1, '', 50, 150, 18, 64);
INSERT INTO OustersArmsbandInfo VALUES ( 2, 3, '水虹臂环',	 'Rainbow Wave Armsband',	 2400,  5, 2, 15000, 2640, 4, 1, 1, '(LEV,15)', 3, '', 50, 150, 18, 64);
INSERT INTO OustersArmsbandInfo VALUES ( 3, 4, '古代臂环',			 'Guduen\'s Armsband',		 6400,  5, 2,  3700, 3200, 5, 2, 2, '(LEV,22)', 3, '', 50, 150, 18, 64);
INSERT INTO OustersArmsbandInfo VALUES ( 4, 5, '锦花臂环',			 'Blossom Armsband',		13000,  5, 2,   800, 4160, 6, 2, 2, '(LEV,30)', 5, '', 50, 150, 18, 64);
INSERT INTO OustersArmsbandInfo VALUES ( 5, 6, '斯拉格臂环',			 'Selge Armsband',			25000,  5, 2,   330, 4800, 8, 3, 2, '(LEV,41)', 5, '', 50, 150, 18, 64);
INSERT INTO OustersArmsbandInfo VALUES ( 6, 7, '悲悯臂环',	 'Priest Herihor Armsband',	44000,  5, 2,   135, 5920,10, 4, 3, '(LEV,53)', 7, '', 50, 150, 18, 64);
INSERT INTO OustersArmsbandInfo VALUES ( 7, 8, '苍月臂环',				 'Zaret Armsband',			56000,  5, 2,    22, 6880,12, 4, 3, '(LEV,65)', 7, '', 50, 150, 18, 64);
INSERT INTO OustersArmsbandInfo VALUES ( 8, 9, '圣翼天使',			 'Gurgan Armsband',			76000,  5, 2,     8, 7600,15, 5, 3, '(LEV,77)', 9, '', 50, 150, 18, 64);
INSERT INTO OustersArmsbandInfo VALUES ( 9, 9, '诸神黄昏',			 'Kugnas Armsband',			88000,  5, 2,     5, 9600,18, 6, 3, '(LEV,89)', 9, '', 50, 150, 18, 64);