createtrouserinfo.sql

天之炼狱OpenDE_SQL.tar.gz

################################################################################
#
#  Project : Online Game DARKEDEN
#  Module  : SQL - Item Info
#
#  FileName    : CreateTrouserObject.sql
#  Description : 官瘤 酒捞袍 沥焊
#
#  History      Writer          Description
# ------------ -------------- -----------------------------------------------
# 2002.08.13    厘全芒        脚痹 颇老 积己 
#
# 2002.08.20    厘全芒        NextOptionRatio 漠烦 眠啊(Rare酒捞袍侩)
################################################################################


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

CREATE TABLE TrouserInfo (
  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 TrouserInfo VALUES ( 0, 2, '防弹裤(男)',               'Slacks M',               2500, 6, 4, 70000,  1200,  8,  4, '(GEN,1)(SUM,30)',   1, '', 50, 130, 16, 65);
INSERT INTO TrouserInfo VALUES ( 1, 3, '防弹裤(女)',               'Slacks W',               2500, 6, 4, 70000,  1200,  8,  4, '(GEN,2)(SUM,30)',   1, '', 50, 130, 16, 65);
INSERT INTO TrouserInfo VALUES ( 2, 4, '防弹甲裤(男)',           'Trouser M',              8000, 6, 4, 20000,  2400, 16,  8, '(GEN,1)(SUM,45)',   3, '', 45, 110, 14, 63);
INSERT INTO TrouserInfo VALUES ( 3, 5, '防弹甲裤(女)',           'Trouser W',              8000, 6, 4, 20000,  2400, 16,  8, '(GEN,2)(SUM,45)',   3, '', 45, 110, 14, 63);
INSERT INTO TrouserInfo VALUES ( 4, 6, '武士裤(男)',             'Leggings M',            16000, 6, 4,  9100,  3600, 24, 12, '(GEN,1)(SUM,60)',   5, '', 40, 100, 12, 61);
INSERT INTO TrouserInfo VALUES ( 5, 7, '武士裤(女)',             'Leggings W',            16000, 6, 4,  9100,  3600, 24, 12, '(GEN,2)(SUM,60)',   5, '', 40, 100, 12, 61);
INSERT INTO TrouserInfo VALUES ( 6, 8, '锁子甲裤(男)',        'Battle Leggings M',     24000, 6, 4,   655,  4800, 32, 16, '(GEN,1)(SUM,75)',   9, '', 35,  90, 10, 59);
INSERT INTO TrouserInfo VALUES ( 7, 9, '锁子甲裤(女)',        'Battle Leggings W',     24000, 6, 4,   655,  4800, 32, 16, '(GEN,2)(SUM,75)',   9, '', 35,  90, 10, 59);
INSERT INTO TrouserInfo VALUES ( 8,10, '武士甲裤(男)',        'Battle Gaiters M',      75000, 6, 4,   200,  6000, 40, 20, '(GEN,1)(SUM,115)', 11, '', 30,  80, 8, 57);
INSERT INTO TrouserInfo VALUES ( 9,11, '武士甲裤(女)',        'Battle Gaiters W',      75000, 6, 4,   200,  6000, 40, 20, '(GEN,2)(SUM,115)', 11, '', 30,  80, 8, 57);
INSERT INTO TrouserInfo VALUES (10,12, '铠甲裤(男)',        'Combat Gaiters M',      95000, 6, 4,    34,  7200, 48, 24, '(GEN,1)(SUM,165)', 13, '', 20,  70, 4, 55);
INSERT INTO TrouserInfo VALUES (11,13, '铠甲裤(女)',        'Combat Gaiters W',      95000, 6, 4,    34,  7200, 48, 24, '(GEN,2)(SUM,165)', 13, '', 20,  70, 4, 55);
INSERT INTO TrouserInfo VALUES (12,14, '神圣铠甲裤(男)',          'Combat Guards M',      145000, 6, 4,     9,  8400, 56, 28, '(GEN,1)(SUM,220)', 15, '', 10,  60, 2, 53);
INSERT INTO TrouserInfo VALUES (13,15, '神圣铠甲裤(女)',          'Combat Guards W',      145000, 6, 4,     9,  8400, 56, 28, '(GEN,2)(SUM,220)', 15, '', 10,  60, 2, 53);
INSERT INTO TrouserInfo VALUES (14,18, '战神甲裤(男)',            'War Guards M', 	     180000, 6, 4,     2, 10000, 64, 32, '(GEN,1)(SUM,280)', 17, '',  5,  50, 1, 51);
INSERT INTO TrouserInfo VALUES (15,19, '战神甲裤(女)',            'War Guards W',		 180000, 6, 4,     2, 10000, 64, 32, '(GEN,2)(SUM,280)', 17, '',  5,  50, 1, 51);
INSERT INTO TrouserInfo VALUES (18,20, '装甲护腿(男)',        'Kahraman Guards M',    250000, 6, 4,     2, 12000, 72, 36, '(GEN,1)(SUM,300)', 19, '',  3,  40, 1, 49);
INSERT INTO TrouserInfo VALUES (19,21, '装甲护腿(女)',        'Kahraman Guards W',    250000, 6, 4,     2, 12000, 72, 36, '(GEN,2)(SUM,300)', 19, '',  3,  40, 1, 49);
INSERT INTO TrouserInfo VALUES (20,20, '重装甲护腿(男)',      'Cuirassir Cuisse M',     500000, 6, 4,     1, 14000, 80, 40, '(GEN,1)(SUM,340)', 21, '',  2,  30, 1, 47);
INSERT INTO TrouserInfo VALUES (21,21, '重装甲护腿(女)',      'Cuirassir Cuisse W',     500000, 6, 4,     1, 14000, 80, 40, '(GEN,2)(SUM,340)', 21, '',  2,  30, 1, 47);
#蜡聪农 酒捞袍
INSERT INTO TrouserInfo VALUES (16,16, '龙神甲裤(男)', 'Dragon Scale Guard M', 999999, 6, 4,     0, 20000, 72, 36, '(GEN,1)(SUM,120)', 19, 'HP+5,DEF+5,PRO+5',  0,   0, 0, 0);
INSERT INTO TrouserInfo VALUES (17,17, '龙神甲裤(女)', 'Dragon Scale Guard W', 999999, 6, 4,     0, 20000, 72, 36, '(GEN,2)(SUM,120)', 19, 'HP+5,DEF+5,PRO+5',  0,   0, 0, 0);