createrareenchantinfo.sql

天之炼狱OpenDE_SQL.tar.gz

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


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

CREATE TABLE RareEnchantInfo (
	ID						int(11)		NOT NULL auto_increment,

	Level					int(11)		NOT NULL default 0, # 可记狼 鞭荐
	TotalGrade				int(11)		NOT NULL default 0,	# 可记狼 醚 窜拌 荐
	Grade					int(11)		NOT NULL default 0,	# 窜拌 荐

	RatioWhenFail			int(11)		NOT NULL default 0, # 霉锅犁 可记捞 角菩沁阑 锭 犬伏
	RatioWhenSuccess		int(11)		NOT NULL default 0, # 霉锅掳 可记捞 己傍沁阑 锭 犬伏

	PRIMARY KEY  (ID)

) TYPE=MyISAM;


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



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



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



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

INSERT INTO RareEnchantInfo VALUES (0, 4, 5, 0, 30, 18);
INSERT INTO RareEnchantInfo VALUES (0, 4, 5, 1, 17, 10);
INSERT INTO RareEnchantInfo VALUES (0, 4, 5, 2,  5,  3);
INSERT INTO RareEnchantInfo VALUES (0, 4, 5, 3,  1,  1);
INSERT INTO RareEnchantInfo VALUES (0, 4, 5, 4,  0,  0);

INSERT INTO RareEnchantInfo VALUES (0, 4, 3, 0, 15,  9);
INSERT INTO RareEnchantInfo VALUES (0, 4, 3, 1,  5,  3);
INSERT INTO RareEnchantInfo VALUES (0, 4, 3, 2,  0,  0);

INSERT INTO RareEnchantInfo VALUES (0, 3, 3, 0, 20, 12);
INSERT INTO RareEnchantInfo VALUES (0, 3, 3, 1,  7,  4);
INSERT INTO RareEnchantInfo VALUES (0, 3, 3, 2,  0,  0);

INSERT INTO RareEnchantInfo VALUES (0, 2, 5, 0, 35, 21);
INSERT INTO RareEnchantInfo VALUES (0, 2, 5, 1, 20, 12);
INSERT INTO RareEnchantInfo VALUES (0, 2, 5, 2,  7,  4);
INSERT INTO RareEnchantInfo VALUES (0, 2, 5, 3,  1,  1);
INSERT INTO RareEnchantInfo VALUES (0, 2, 5, 4,  0,  0);

INSERT INTO RareEnchantInfo VALUES (0, 2, 3, 0, 22, 13);
INSERT INTO RareEnchantInfo VALUES (0, 2, 3, 1,  7,  4);
INSERT INTO RareEnchantInfo VALUES (0, 2, 3, 2,  0,  0);

INSERT INTO RareEnchantInfo VALUES (0, 1, 5, 0, 40, 24);
INSERT INTO RareEnchantInfo VALUES (0, 1, 5, 1, 30, 18);
INSERT INTO RareEnchantInfo VALUES (0, 1, 5, 2, 20, 12);
INSERT INTO RareEnchantInfo VALUES (0, 1, 5, 3, 10,  6);
INSERT INTO RareEnchantInfo VALUES (0, 1, 5, 4,  0,  0);

INSERT INTO RareEnchantInfo VALUES (0, 0, 3, 0, 30, 18);
INSERT INTO RareEnchantInfo VALUES (0, 0, 3, 1, 20, 12);
INSERT INTO RareEnchantInfo VALUES (0, 0, 3, 2,  0,  0);

INSERT INTO RareEnchantInfo VALUES (0, 0, 5, 0, 45, 27);
INSERT INTO RareEnchantInfo VALUES (0, 0, 5, 1, 35, 21);
INSERT INTO RareEnchantInfo VALUES (0, 0, 5, 2, 25, 15);
INSERT INTO RareEnchantInfo VALUES (0, 0, 5, 3, 10,  6);
INSERT INTO RareEnchantInfo VALUES (0, 0, 5, 4,  0,  0);