createvampirecoatinfo.sql

天之炼狱OpenDE_SQL.tar.gz

################################################################################
#
#  Project : Online Game DARKEDEN
#  Module  : SQL - Item Info
#
#  FileName    : CreateVampireCoatInfo.sql
#  Description : 轨颇捞绢 内飘 酒捞袍 沥焊
#
#  History      Writer          Description
# ------------ -------------- -----------------------------------------------
# 2002.08.13    厘全芒        脚痹 颇老 积己 
#
# 2002.08.23    厘全芒        蜡聪农 酒捞袍 眠啊
################################################################################


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

CREATE TABLE VampireCoatInfo (
  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',

  NextItemType			tinyint(3)	unsigned NOT NULL default '0',
  DowngradeRatio		smallint(6)			 NOT NULL default 0,

  PRIMARY KEY  (ItemType)

) TYPE=MyISAM;


################################################################################
# 牢郸胶 积己



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



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



################################################################################
# 单捞磐 持扁
INSERT INTO VampireCoatInfo VALUES (0,  '披风',         'Swing Coat',        50000, 6, 6, 70000,  1500, 10,  5,'(GEN,1)(LEV,10)',  2,'', 50, 150, 17, 2, 62);
INSERT INTO VampireCoatInfo VALUES (1,  '紧身服',         'Body Suit',         50000, 6, 6, 70000,  1500, 10,  5,'(GEN,2)(LEV,10)',  2,'', 50, 150, 17, 3, 62);
INSERT INTO VampireCoatInfo VALUES (2,  '礼服',         'Frock Coat',       150000, 6, 6, 20000,  3000, 20, 10,'(GEN,1)(LEV,20)',  4,'', 40, 130, 14, 4, 59);
INSERT INTO VampireCoatInfo VALUES (3,  '暗黑紧身衣',         'Jump Suit',        150000, 6, 6, 20000,  3000, 20, 10,'(GEN,2)(LEV,20)',  4,'', 40, 130, 14, 5, 59);
INSERT INTO VampireCoatInfo VALUES (4,  '天鹅绒礼服',     'Slipery Robe',     200000, 6, 6,  9465,  4500, 30, 15,'(GEN,1)(LEV,35)',  6,'', 30, 110, 11, 6, 56);
INSERT INTO VampireCoatInfo VALUES (5,  '羽毛披风',         'Plume Cloak',      200000, 6, 6,  9465,  4500, 30, 15,'(GEN,2)(LEV,35)',  6,'', 30, 110, 11, 7, 56);
INSERT INTO VampireCoatInfo VALUES (6,  '隐身服',       'Hiding Robe',      250000, 6, 6,   400,  6000, 40, 20,'(GEN,1)(LEV,55)',  8,'', 20,  90, 8, 8, 53);
INSERT INTO VampireCoatInfo VALUES (7,  '血披风', 'Levitated Cloak',  250000, 6, 6,   400,  6000, 40, 20,'(GEN,2)(LEV,55)',  8,'', 20,  90, 8, 9, 53);
INSERT INTO VampireCoatInfo VALUES (8,  '落日法衣',        'Anti-Sun Pall',    300000, 6, 6,   120,  7500, 50, 25,'(GEN,1)(LEV,70)', 10,'', 10,  70, 3, 10, 50);
INSERT INTO VampireCoatInfo VALUES (9,  '落日披风',      'Anti-Sun Cope',    300000, 6, 6,   120,  7500, 50, 25,'(GEN,2)(LEV,70)', 10,'', 10,  70, 3, 11, 50);
INSERT INTO VampireCoatInfo VALUES (10, '大师法衣',         'Master Pall',      400000, 6, 6,    15,  9000, 60, 30,'(GEN,1)(LEV,90)', 12,'',  5,  50, 1, 14, 47);
INSERT INTO VampireCoatInfo VALUES (11, '大师披风',       'Master Cope',      400000, 6, 6,    15,  9000, 60, 30,'(GEN,2)(LEV,90)', 12,'',  5,  50, 1, 15, 47);
INSERT INTO VampireCoatInfo VALUES (12, '指挥官服(男)',       'Commander Coat M', 900000, 6, 6,     0, 19000, 80, 40,'(GEN,1)(LEV,70)', 14,'MP+4,DEF+7,DEX+6',  0,   0, 0, 12, 0);
INSERT INTO VampireCoatInfo VALUES (13, '指挥官服(女)',       'Commander Coat W', 900000, 6, 6,     0, 19000, 80, 40,'(GEN,2)(LEV,70)', 14,'MP+4,DEF+7,DEX+6',  0,   0, 0, 13, 0);
INSERT INTO VampireCoatInfo VALUES (14, '凝血之衣',         'Blood Pall',       500000, 6, 6,     5, 11000, 70, 35,'(GEN,1)(LEV,100)', 16,'',  3,  40, 1, 16, 44);
INSERT INTO VampireCoatInfo VALUES (15, '凝血之袍',         'Blood Cope',       500000, 6, 6,     5, 11000, 70, 35,'(GEN,2)(LEV,100)', 16,'',  3,  40, 1, 17, 44);
INSERT INTO VampireCoatInfo VALUES (16, '罗马胸甲(男)',       'Lorica Coat M',    850000, 6, 6,     3, 14000, 80, 40,'(GEN,1)(LEV,100)', 18,'',  2,  30, 1, 16, 41);
INSERT INTO VampireCoatInfo VALUES (17, '罗马胸甲(女)',       'Lorica Coat W',    850000, 6, 6,     3, 14000, 80, 40,'(GEN,2)(LEV,100)', 18,'',  2,  30, 1, 17, 41);