creategatheritemquestinfo.sql

天之炼狱OpenDE_SQL.tar.gz

################################################################################
#
#  Project : Online Game DARKEDEN
#  Module  : SQL - GameInfo
#
#  FileName    : CreateGatherItemQuestInfo.sql
#  Description : 涅胶飘 捞亥飘
#
################################################################################


################################################################################
# 抛捞喉 积己 
DROP TABLE IF EXISTS GatherItemQuestInfo;
CREATE TABLE GatherItemQuestInfo
(
	QuestID			int(10)			NOT NULL	DEFAULT 0,
	NPC				varchar(20)		NOT NULL	DEFAULT 0,

	TargetIClass	smallint(5)		NOT NULL	DEFAULT 0,
	TargetIType		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,
	MinGrade		int(10)			NOT NULL	DEFAULT 0,
	MaxGrade		int(10)			NOT NULL	DEFAULT 0,

	RewardClass		int(10)			NOT NULL	DEFAULT 0,

	EventQuest		tinyint(3)		NOT NULL	DEFAULT 0,
	QuestLevel		smallint(5)		NOT NULL	DEFAULT 0,

	PRIMARY KEY (QuestID)
);

INSERT INTO GatherItemQuestInfo VALUES (45, '凯泽', 53, 11, 8, 0, 0, 30, 60, 10, 1, 1);
INSERT INTO GatherItemQuestInfo VALUES (46, '凯泽', 53, 12, 8, 0, 0, 61, 95, 10, 1, 1);
INSERT INTO GatherItemQuestInfo VALUES (47, '凯泽', 53, 13, 8, 0, 0, 96, 130, 10, 1, 1);
INSERT INTO GatherItemQuestInfo VALUES (48, '凯泽', 53, 14, 8, 0, 0, 131, 170, 10, 1, 1);
INSERT INTO GatherItemQuestInfo VALUES (49, '凯泽', 53, 15, 8, 0, 0, 171, 210, 10, 1, 1);
INSERT INTO GatherItemQuestInfo VALUES (50, '凯泽', 53, 16, 8, 0, 0, 211, 240, 10, 1, 1);
INSERT INTO GatherItemQuestInfo VALUES (51, '凯泽', 53, 17, 8, 0, 0, 241, 270, 10, 1, 1);
INSERT INTO GatherItemQuestInfo VALUES (52, '凯泽', 53, 18, 8, 0, 0, 271, 290, 10, 1, 1);
INSERT INTO GatherItemQuestInfo VALUES (53, '凯泽', 53, 19, 8, 0, 0, 291, 300, 10, 1, 1);
INSERT INTO GatherItemQuestInfo VALUES (54, '凯泽', 53, 20, 8, 0, 0, 301, 885, 10, 1, 1);

INSERT INTO GatherItemQuestInfo VALUES (55, '凯泽', 53, 21, 1, 0, 0, 30, 885, 10, 1, 2);

INSERT INTO GatherItemQuestInfo VALUES (56, '凯泽', 47, 41, 1, 0, 0, 30, 885, 10, 1, 3);

INSERT INTO GatherItemQuestInfo VALUES (57, '凯泽', 71, 1, 1, 0, 0, 30, 885, 10, 1, 4);

INSERT INTO GatherItemQuestInfo VALUES (60, '莱贝卡', 53, 11, 8, 0, 1, 1, 10, 10, 1, 1);
INSERT INTO GatherItemQuestInfo VALUES (61, '莱贝卡', 53, 12, 8, 0, 1, 11, 20, 10, 1, 1);
INSERT INTO GatherItemQuestInfo VALUES (62, '莱贝卡', 53, 13, 8, 0, 1, 21, 30, 10, 1, 1);
INSERT INTO GatherItemQuestInfo VALUES (63, '莱贝卡', 53, 14, 8, 0, 1, 31, 40, 10, 1, 1);
INSERT INTO GatherItemQuestInfo VALUES (64, '莱贝卡', 53, 15, 8, 0, 1, 41, 50, 10, 1, 1);
INSERT INTO GatherItemQuestInfo VALUES (65, '莱贝卡', 53, 16, 8, 0, 1, 51, 60, 10, 1, 1);
INSERT INTO GatherItemQuestInfo VALUES (66, '莱贝卡', 53, 17, 8, 0, 1, 61, 70, 10, 1, 1);
INSERT INTO GatherItemQuestInfo VALUES (67, '莱贝卡', 53, 18, 8, 0, 1, 71, 80, 10, 1, 1);
INSERT INTO GatherItemQuestInfo VALUES (68, '莱贝卡', 53, 19, 8, 0, 1, 81, 90, 10, 1, 1);
INSERT INTO GatherItemQuestInfo VALUES (69, '莱贝卡', 53, 20, 8, 0, 1, 91, 150, 10, 1, 1);

INSERT INTO GatherItemQuestInfo VALUES (70, '莱贝卡', 53, 21, 1, 0, 1, 1, 150, 10, 1, 2);

INSERT INTO GatherItemQuestInfo VALUES (71, '莱贝卡', 47, 41, 1, 0, 1, 1, 150, 10, 1, 3);

INSERT INTO GatherItemQuestInfo VALUES (72, '莱贝卡', 71, 1, 1, 0, 1, 1, 150, 10, 1, 4);

INSERT INTO GatherItemQuestInfo VALUES (75, '拉维亚', 53, 11, 8, 0, 2, 1, 10, 10, 1, 1);
INSERT INTO GatherItemQuestInfo VALUES (76, '拉维亚', 53, 12, 8, 0, 2, 11, 20, 10, 1, 1);
INSERT INTO GatherItemQuestInfo VALUES (77, '拉维亚', 53, 13, 8, 0, 2, 21, 30, 10, 1, 1);
INSERT INTO GatherItemQuestInfo VALUES (78, '拉维亚', 53, 14, 8, 0, 2, 31, 40, 10, 1, 1);
INSERT INTO GatherItemQuestInfo VALUES (79, '拉维亚', 53, 15, 8, 0, 2, 41, 50, 10, 1, 1);
INSERT INTO GatherItemQuestInfo VALUES (80, '拉维亚', 53, 16, 8, 0, 2, 51, 60, 10, 1, 1);
INSERT INTO GatherItemQuestInfo VALUES (81, '拉维亚', 53, 17, 8, 0, 2, 61, 70, 10, 1, 1);
INSERT INTO GatherItemQuestInfo VALUES (82, '拉维亚', 53, 18, 8, 0, 2, 71, 80, 10, 1, 1);
INSERT INTO GatherItemQuestInfo VALUES (83, '拉维亚', 53, 19, 8, 0, 2, 81, 90, 10, 1, 1);
INSERT INTO GatherItemQuestInfo VALUES (84, '拉维亚', 53, 20, 8, 0, 2, 91, 150, 10, 1, 1);

INSERT INTO GatherItemQuestInfo VALUES (85, '拉维亚', 53, 21, 1, 0, 2, 1, 150, 10, 1, 2);

INSERT INTO GatherItemQuestInfo VALUES (86, '拉维亚', 47, 41, 1, 0, 2, 1, 150, 10, 1, 3);

INSERT INTO GatherItemQuestInfo VALUES (87, '拉维亚', 71, 1, 1, 0, 2, 1, 150, 10, 1, 4);