createoptionclassinfo2.sql

天之炼狱OpenDE_SQL.tar.gz

################################################################################
#
#  Project : Online Game DARKEDEN
#  Module  : SQL - GameInfo
#
#  FileName    :  CreateOptionClassInfo.sql
#  Description :  OptionInfo Table
#
#  History      Writer          Description
# ------------ -------------- -----------------------------------------------
# 2002.11.29    辣康侥        脚痹 颇老 积己 
#
################################################################################


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

CREATE TABLE OptionClassInfo (
  OptionClassType 		int(11)     NOT NULL default '0',
  Name 					varchar(50) NOT NULL default '',
  HName 				varchar(50) NOT NULL default '',

  Level					int(11)		NOT NULL default 0, # 可记狼 鞭荐
  TotalGrade			int(11)		NOT NULL default 0,	# 可记狼 醚 窜拌 荐
  OptionGroup			smallint(5)	NOT NULL default 0,	# 可记狼 弊缝盒幅

  PRIMARY KEY  (OptionClassType)

) TYPE=MyISAM;


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



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



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



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

#enum OptionGroup
#{
#    OPTION_GROUP_ATTR = 0,          // 瓷仿摹 包访 可记
#    OPTION_GROUP_STAT,              // 焊炼瓷仿摹 包访 可记
#    OPTION_GROUP_SPECIAL,           // 漂荐 可记 (...?)
#    OPTION_GROUP_RESIST,            // 历亲 可记
#    OPTION_GROUP_ETC,               // 扁鸥 可记
#	 OPTION_GROUP_NOT                // 弊缝 绝澜
#};


INSERT INTO OptionClassInfo VALUES (0, "STR", "STR", 1,5,0);
INSERT INTO OptionClassInfo VALUES (1, "DEX", "DEX", 2,5,0);
INSERT INTO OptionClassInfo VALUES (2, "INT", "INT", 1,5,0);
INSERT INTO OptionClassInfo VALUES (3, "HP", "HP", 2,5,1);
INSERT INTO OptionClassInfo VALUES (4, "MP", "MP", 1,5,1);
INSERT INTO OptionClassInfo VALUES (5, "HP Steal", "HP软荐", 3,3,4);
INSERT INTO OptionClassInfo VALUES (6, "MP Steal", "MP软荐", 3,3,4);
INSERT INTO OptionClassInfo VALUES (7, "HP Regeneration", "HP犁积仿", 0,3,4 );
INSERT INTO OptionClassInfo VALUES (8, "MP Regeneration", "MP犁积仿", 0,3,4 );
INSERT INTO OptionClassInfo VALUES (9, "ToHit", "疙吝伏", 1,5,1);
INSERT INTO OptionClassInfo VALUES (10, "Defense", "叼奇胶", 1,5,1);
INSERT INTO OptionClassInfo VALUES (11, "Damage", "单固瘤", 2,5,2);
INSERT INTO OptionClassInfo VALUES (12, "Protection", "橇肺咆记", 1,5,1);
INSERT INTO OptionClassInfo VALUES (13, "Durability", "郴备己", 1,5,4);
INSERT INTO OptionClassInfo VALUES (14, "Poison Resistance", "刀 付过历亲仿", 2,3,3);
INSERT INTO OptionClassInfo VALUES (15, "Acid Resistance", "魂 付过历亲仿", 2,3,3);
INSERT INTO OptionClassInfo VALUES (16, "Curse Resistance", "历林 付过历亲仿", 2,3,3);
INSERT INTO OptionClassInfo VALUES (17, "Blood Resistance", "喉矾靛 付过历亲仿", 2,3,3);
INSERT INTO OptionClassInfo VALUES (18, "Vision", "矫具", 0,3,4);
INSERT INTO OptionClassInfo VALUES (19, "Attack Speed", "傍拜加档", 2,5,2);
INSERT INTO OptionClassInfo VALUES (20, "Critical Hit", "农府萍拿 洒飘", 0,5,2);
INSERT INTO OptionClassInfo VALUES (21, "Luck", "青款", 4,3,4);
INSERT INTO OptionClassInfo VALUES (22, "All Registance", "葛电 历亲仿", 4,5,3);
INSERT INTO OptionClassInfo VALUES (23, "All Attributes", "葛电 瓷仿摹", 4,3,0);

INSERT INTO OptionClassInfo VALUES (24, "Ater Balance", "STR to DEX", 0,1,5);
INSERT INTO OptionClassInfo VALUES (25, "Ianthinus Balance", "STR to INT", 0,1,5);
INSERT INTO OptionClassInfo VALUES (26, "Croceus Balance", "DEX to STR", 0,1,5);
INSERT INTO OptionClassInfo VALUES (27, "Cyan Balance", "DEX to INT", 0,1,5);
INSERT INTO OptionClassInfo VALUES (28, "Magenta Balance", "INT to STR", 0,1,5);
INSERT INTO OptionClassInfo VALUES (29, "Glaucus Balance", "INT to DEX", 0,1,5);

INSERT INTO OptionClassInfo VALUES (30, "Cosume MP", "MP 家葛樊", 0,1,5);
INSERT INTO OptionClassInfo VALUES (31, "Translation", "烹开", 0,1,5);
INSERT INTO OptionClassInfo VALUES (32, "Magic Damage", "付过 单固瘤", 0,1,5);
INSERT INTO OptionClassInfo VALUES (33, "Physical Damage", "拱府 单固瘤", 0,1,5);
INSERT INTO OptionClassInfo VALUES (34, "Gamble Price", "白喉 啊拜", 0,1,5);
INSERT INTO OptionClassInfo VALUES (35, "Potion Price", "器记(趋没) 啊拜", 0,1,5);