createquestinfo.sql

天之炼狱OpenDE_SQL.tar.gz

################################################################################
#
#  Project : Online Game DARKEDEN
#  Module  : SQL - GameInfo
#
#  FileName    : CreateQuestInfo.sql
#  Description : 缴敲 涅胶飘 沥焊
#
################################################################################


################################################################################
# 抛捞喉 积己 
DROP TABLE IF EXISTS QuestInfo;
CREATE TABLE QuestInfo 
( 
	QuestType			int(10)			NOT NULL		DEFAULT 0,
	TargetSType			smallint(5)		NOT NULL		DEFAULT 0,
	Goal				int(10)			NOT NULL		DEFAULT 0,
	TimeLimitSec		int(10)			NOT NULL		DEFAULT 0,

	Race				tinyint(3)		NOT NULL		DEFAULT 0,
	MinLevel			smallint(5)		NOT NULL		DEFAULT 0,
	MaxLevel			smallint(5)		NOT NULL		DEFAULT 0,

	WeaponReward		tinyint(3)		NOT NULL		DEFAULT 0,

	PRIMARY KEY (QuestType)
); 

DROP TABLE IF EXISTS QuestRewardItemInfo;
CREATE TABLE QuestRewardItemInfo
(
	ID					int(10)			NOT NULL		AUTO_INCREMENT,
	
	QuestType			int(10)			NOT NULL		DEFAULT 0,
	RewardIClass		smallint(5)		NOT NULL		DEFAULT 0,
	RewardIType			smallint(5)		NOT NULL		DEFAULT 0,
	RewardOptionType	varchar(50)		NOT NULL		DEFAULT '',

	PRIMARY KEY (ID)
);
################################################################################
# 牢郸胶 积己
CREATE INDEX QuestRewardItemInfo_QuestType ON QuestRewardItemInfo(QuestType);

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

# 单靛官叼
INSERT INTO QuestInfo VALUES (1, 5, 50, 21600, 0, 30, 70, 1);

INSERT INTO QuestRewardItemInfo VALUES (0, 1, 14, 4, '(DAM+1)');
INSERT INTO QuestRewardItemInfo VALUES (0, 1, 15, 4, '(DAM+1)');
INSERT INTO QuestRewardItemInfo VALUES (0, 1, 22, 4, '(DAM+1)');
INSERT INTO QuestRewardItemInfo VALUES (0, 1, 35, 3, '(HP+3)');
INSERT INTO QuestRewardItemInfo VALUES (0, 1, 17, 3, '(HP+3)');

# 磐醋单靛
INSERT INTO QuestInfo VALUES (2, 8, 30, 21600, 0, 30, 70, 0);

INSERT INTO QuestRewardItemInfo VALUES (0, 2, 11, 3, '(VIS+1)');
INSERT INTO QuestRewardItemInfo VALUES (0, 2, 12, 3, '(VIS+1)');
INSERT INTO QuestRewardItemInfo VALUES (0, 2, 19, 3, '(DAM+1)');
INSERT INTO QuestRewardItemInfo VALUES (0, 2, 18, 2, '(MPSTL+3)');
INSERT INTO QuestRewardItemInfo VALUES (0, 2, 13, 2, '(PORES+3)');