createoustersstoneinfo.sql

天之炼狱OpenDE_SQL.tar.gz

################################################################################
#
#  Project : Online Game DARKEDEN
#  Module  : SQL - Item Info
#
#  FileName    : CreateOustersStoneInfo.sql
#  Description : 酒快胶磐胶 沥飞籍 沥焊 抛捞喉
#
#  History      Writer          Description
# ------------ -------------- -----------------------------------------------
# 2002.05.21    硅犁屈        脚痹 颇老 积己 
#
################################################################################


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

CREATE TABLE OustersStoneInfo (
  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', # 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 OustersStoneInfo VALUES ( 0, '火灵石1', 'Fire ElementalStone 1',  2400, 1, 3, 70000, 4000, 0, 1,  '(LEV,4)', 1, '', 50, 150, 18, 1, 64, 0, 1);
INSERT INTO OustersStoneInfo VALUES ( 1, '火灵石2', 'Fire ElementalStone 2',  4000, 1, 3, 50000, 6000, 1, 1, '(LEV,15)', 3, '', 50, 150, 18, 2, 64, 0, 2);
INSERT INTO OustersStoneInfo VALUES ( 2, '火灵石3', 'Fire ElementalStone 3',  8800, 1, 3, 30000, 9000, 2, 1, '(LEV,24)', 5, '', 50, 150, 18, 3, 64, 0, 3);
INSERT INTO OustersStoneInfo VALUES ( 3, '火灵石4', 'Fire ElementalStone 4', 16000, 1, 3, 10000,12000, 3, 2, '(LEV,38)', 7, '', 50, 150, 18, 4, 64, 0, 4);
INSERT INTO OustersStoneInfo VALUES ( 4, '火灵石5', 'Fire ElementalStone 5', 34400, 1, 3,  5000,15000, 5, 3, '(LEV,51)', 9, '', 50, 150, 18, 4, 64, 0, 5);

INSERT INTO OustersStoneInfo VALUES ( 5, '水灵石1', 'Water ElementalStone 1',  2400, 1, 3, 70000, 4000, 0, 1,  '(LEV,4)', 1, '', 50, 150, 18, 6, 64, 1, 1);
INSERT INTO OustersStoneInfo VALUES ( 6, '水灵石2', 'Water ElementalStone 2',  4000, 1, 3, 50000, 6000, 1, 1, '(LEV,15)', 3, '', 50, 150, 18, 7, 64, 1, 2);
INSERT INTO OustersStoneInfo VALUES ( 7, '水灵石3', 'Water ElementalStone 3',  8800, 1, 3, 30000, 9000, 2, 1, '(LEV,24)', 5, '', 50, 150, 18, 8, 64, 1, 3);
INSERT INTO OustersStoneInfo VALUES ( 8, '水灵石4', 'Water ElementalStone 4', 16000, 1, 3, 10000,12000, 3, 2, '(LEV,38)', 7, '', 50, 150, 18, 9, 64, 1, 4);
INSERT INTO OustersStoneInfo VALUES ( 9, '水灵石5', 'Water ElementalStone 5', 34400, 1, 3,  5000,15000, 5, 3, '(LEV,51)', 9, '', 50, 150, 18, 9, 64, 1, 5);

INSERT INTO OustersStoneInfo VALUES ( 10, '土元素石1', 'Earth ElementalStone 1',  2400, 1, 3, 70000, 4000, 0, 1,  '(LEV,4)', 1, '', 50, 150, 18, 11, 64, 2, 1);
INSERT INTO OustersStoneInfo VALUES ( 11, '土元素石2', 'Earth ElementalStone 2',  4000, 1, 3, 50000, 6000, 1, 1, '(LEV,15)', 3, '', 50, 150, 18, 12, 64, 2, 2);
INSERT INTO OustersStoneInfo VALUES ( 12, '土元素石3', 'Earth ElementalStone 3',  8800, 1, 3, 30000, 9000, 2, 1, '(LEV,24)', 5, '', 50, 150, 18, 13, 64, 2, 3);
INSERT INTO OustersStoneInfo VALUES ( 13, '土元素石4', 'Earth ElementalStone 4', 16000, 1, 3, 10000,12000, 3, 2, '(LEV,38)', 7, '', 50, 150, 18, 14, 64, 2, 4);
INSERT INTO OustersStoneInfo VALUES ( 14, '土元素石5', 'Earth ElementalStone 5', 34400, 1, 3,  5000,15000, 5, 3, '(LEV,51)', 9, '', 50, 150, 18, 14, 64, 2, 5);