createcoatinfo.sql

天之炼狱OpenDE_SQL.tar.gz

################################################################################
#
#  Project : Online Game DARKEDEN
#  Module  : SQL - ItemInfo
#
#  FileName    : CreateCoatInfo.sql
#  Description : 霸烙惑狼 Coat Item狼 description
#
#  History      Writer          Description
# ------------ -------------- -----------------------------------------------
#  2002.08.09   厘全芒        脚痹 颇老 积己 
#                             UpgradeCrashPercent column 眠啊(Enchant侩)
#
# 2002.08.20    厘全芒        NextOptionRatio 漠烦 眠啊(Rare酒捞袍侩)
################################################################################

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

CREATE TABLE CoatInfo (
  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;

################################################################################
# 牢郸胶 积己
# PRIMARY KEY 捞寇狼 牢郸胶绰 积己窍瘤 臼绰促.



################################################################################
# Sequence 积己


################################################################################
# 鼻茄 汲沥 


################################################################################
# 单捞磐 持扁

INSERT INTO CoatInfo VALUES ( 0, 2, '防弹衣(男)',      'Flak Jacket M',        3000, 6, 5, 70000,  1500, 10,  5, '(GEN,1)(SUM,30)',   1, '', 50, 130, 18, 65);
INSERT INTO CoatInfo VALUES ( 1, 3, '防弹衣(女)',      'Flak Jacket W',        3000, 6, 5, 70000,  1500, 10,  5, '(GEN,2)(SUM,30)',   1, '', 50, 130, 18, 65);
INSERT INTO CoatInfo VALUES ( 2, 4, '防弹甲(男)',         'Vest M',              10000, 6, 6, 20000,  3000, 20, 10, '(GEN,1)(SUM,45)',   3, '', 45, 110, 15, 63);
INSERT INTO CoatInfo VALUES ( 3, 5, '防弹甲(女)',         'Vest W',              10000, 6, 6, 20000,  3000, 20, 10, '(GEN,2)(SUM,45)',   3, '', 45, 110, 15, 63);
INSERT INTO CoatInfo VALUES ( 4, 6, '武士服(男)',      'Battle Suit M',       20000, 6, 6,  9100,  4500, 30, 15, '(GEN,1)(SUM,60)',   5, '', 40, 100, 12, 61);
INSERT INTO CoatInfo VALUES ( 5, 7, '武士服(女)',      'Battle Suit W',       20000, 6, 6,  9100,  4500, 30, 15, '(GEN,2)(SUM,60)',   5, '', 40, 100, 12, 61);
INSERT INTO CoatInfo VALUES ( 6, 8, '钛金战衣(男)',      'Combat Suit M',       30000, 6, 6,   655,  6000, 40, 20, '(GEN,1)(SUM,75)',   9, '', 35,  90, 10, 59);
INSERT INTO CoatInfo VALUES ( 7, 9, '钛金战衣(女)',      'Combat Suit W',       30000, 6, 6,   655,  6000, 40, 20, '(GEN,2)(SUM,75)',   9, '', 35,  90, 10, 59);
INSERT INTO CoatInfo VALUES ( 8,10, '武士甲(男)',      'Battle Mail M',       95000, 6, 6,   200,  7500, 50, 25, '(GEN,1)(SUM,115)', 11, '', 30,  80, 8, 57);
INSERT INTO CoatInfo VALUES ( 9,11, '武士甲(女)',      'Battle Mail W',       95000, 6, 6,   200,  7500, 50, 25, '(GEN,2)(SUM,115)', 11, '', 30,  80, 8, 57);
INSERT INTO CoatInfo VALUES (10,12, '铠甲(男)',      'Combat Mail M',      120000, 6, 6,    34,  9000, 60, 30, '(GEN,1)(SUM,165)', 13, '', 20,  70, 4, 55);
INSERT INTO CoatInfo VALUES (11,13, '铠甲(女)',      'Combat Mail W',      120000, 6, 6,    34,  9000, 60, 30, '(GEN,2)(SUM,165)', 13, '', 20,  70, 4, 55);
INSERT INTO CoatInfo VALUES (12,14, '神圣铠甲(男)',      'Combat Armor M',     150000, 6, 6,     9, 10000, 70, 35, '(GEN,1)(SUM,220)', 15, '', 10,  60, 2, 53);
INSERT INTO CoatInfo VALUES (13,15, '神圣铠甲(女)',      'Combat Armor W',     150000, 6, 6,     9, 10000, 70, 35, '(GEN,2)(SUM,220)', 15, '', 10,  60, 2, 53);
INSERT INTO CoatInfo VALUES (14,18, '战神甲(男)',        'War Armor M',        250000, 6, 6,     2, 15000, 80, 40, '(GEN,1)(SUM,280)', 17, '',  5,  50, 1, 51);
INSERT INTO CoatInfo VALUES (15,19, '战神甲(女)',        'War Armor W',        250000, 6, 6,     2, 15000, 80, 40, '(GEN,2)(SUM,280)', 17, '',  5,  50, 1, 51);
INSERT INTO CoatInfo VALUES (18,20, '装甲外套(男)',    'Kahraman Armor M',   400000, 6, 6,     1, 18000, 90, 45, '(GEN,1)(SUM,300)', 19, '',  3,  40, 1, 49);
INSERT INTO CoatInfo VALUES (19,21, '装甲外套(女)',    'Kahraman Armor W',   400000, 6, 6,     1, 18000, 90, 45, '(GEN,2)(SUM,300)', 19, '',  3,  40, 1, 49);
INSERT INTO CoatInfo VALUES (20,20, '重装甲外套(男)',  'Cuirassir Armor M',  800000, 6, 6,     1, 21000,100, 50, '(GEN,1)(SUM,340)', 21, '',  2,  30, 1, 47);
INSERT INTO CoatInfo VALUES (21,21, '重装甲外套(女)',  'Cuirassir Armor W',  800000, 6, 6,     1, 21000,100, 50, '(GEN,2)(SUM,340)', 21, '',  2,  30, 1, 47);

# 蜡聪农 酒捞袍
INSERT INTO CoatInfo VALUES (16,16, '龙神甲(男)', 'Dragon cor Armor M', 999999, 6, 6,     0, 25000, 90, 45, '(GEN,1)(SUM,160)', 19, 'STR+7,DEX+4,INT+5',  0,   0, 0, 0);
INSERT INTO CoatInfo VALUES (17,17, '龙神甲(女)', 'Dragon cor Armor W', 999999, 6, 6,     0, 25000, 90, 45, '(GEN,2)(SUM,160)', 19, 'STR+7,DEX+4,INT+5',  0,   0, 0, 0);