createousterscircletinfo.sql

天之炼狱OpenDE_SQL.tar.gz

################################################################################
#
#  Project : Online Game DARKEDEN
#  Module  : Sql - Item Info
#
#  FileName    :  CreateOustersCircletInfo.sql
#  Description :  酒快胶磐胶 辑努复 沥焊 抛捞喉
#
#  History      Writer          Description
# ------------ -------------- -----------------------------------------------
# 2003.05.21    硅犁屈        脚痹 颇老 积己 
#
################################################################################


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

CREATE TABLE OustersCircletInfo (
  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 OustersCircletInfo VALUES ( 0, 1, '银制发圈',			'Silver Circlet',				   400, 5, 2, 60000,  100,  3,  2,  '(LEV,5)', 1, '', 50, 130, 18, 62);
INSERT INTO OustersCircletInfo VALUES ( 1, 2, '圆月发圈',			'Circlet of Full Moon',			   960, 5, 2, 20000,  500,  5,  3, '(LEV,10)', 1, '', 50, 130, 18, 62);
INSERT INTO OustersCircletInfo VALUES ( 2, 3, '五星发圈',			'Pentacle Circlet',				  3200, 5, 2, 15000, 1000,  8,  4, '(LEV,15)', 3, '', 50, 130, 18, 62);
INSERT INTO OustersCircletInfo VALUES ( 3, 4, '树森之冠',			'Sylvana Circlet',				  8000, 5, 2,  3700, 1600, 10,  5, '(LEV,22)', 3, '', 50, 130, 18, 62);
INSERT INTO OustersCircletInfo VALUES ( 4, 5, '水苍之冠',	'Column of Water Circlet',		 17600, 5, 2,   800, 2200, 12,  6, '(LEV,30)', 5, '', 50, 130, 18, 62);
INSERT INTO OustersCircletInfo VALUES ( 5, 6, '秩序之冠',			'Lothar Circlet',				 40000, 5, 2,   330, 2800, 14,  7, '(LEV,40)', 5, '', 50, 130, 18, 62);
INSERT INTO OustersCircletInfo VALUES ( 6, 7, '月神之冠',		'Cretra Circlet',				 68000, 5, 2,   135, 3400, 16,  8, '(LEV,52)', 7, '', 50, 130, 18, 62);
INSERT INTO OustersCircletInfo VALUES ( 7, 8, '首领之冠',			'Hunz Circlet',					 80000, 5, 2,    22, 4000, 18,  9, '(LEV,64)', 7, '', 50, 130, 18, 62);
INSERT INTO OustersCircletInfo VALUES ( 8, 9, '太阳神发圈',			'Prominence Circlet',			120000, 5, 2,     8, 4600, 20, 10, '(LEV,80)', 9, '', 50, 130, 18, 62);
INSERT INTO OustersCircletInfo VALUES ( 9, 9, '王权之冠',		'Diadem Circlet',				184000, 5, 2,     5, 5600, 24, 12, '(LEV,92)', 9, '', 50, 130, 18, 62);