createwaypointinfo.sql

天之炼狱OpenDE_SQL.tar.gz

##############################################################################
# CreateWayPointInfo.sql
# 浇饭捞绢啊 器呕阑 捞侩且 矫俊 捞悼且 荐 乐绰 瘤痢阑 钎矫窍绰
# 傀捞器牢飘俊 措茄 单捞磐甸捞促.
# 酒快胶磐胶狼 措瘤沥飞狼 辉档 眠啊茄促.
##############################################################################

DROP TABLE IF EXISTS WayPointInfo;

##############################################################################
# ZoneInfo
##############################################################################
CREATE TABLE WayPointInfo
(
	ZoneID      SMALLINT UNSIGNED NOT NULL,
	X           SMALLINT UNSIGNED NOT NULL,
	Y           SMALLINT UNSIGNED NOT NULL,
	Race		SMALLINT UNSIGNED NOT NULL,

	PRIMARY KEY (ZoneID, X, Y)
);

##############################################################################
# 浇饭捞绢 秋扁 器呕
##############################################################################
# 覆焊
INSERT INTO WayPointInfo VALUES (  21,227, 59,0);
INSERT INTO WayPointInfo VALUES (  21, 54,111,0);
INSERT INTO WayPointInfo VALUES (  22,120,214,0);
INSERT INTO WayPointInfo VALUES (  22,127, 12,0);
INSERT INTO WayPointInfo VALUES (  23,185, 57,0);
INSERT INTO WayPointInfo VALUES (  23, 74,192,0);
INSERT INTO WayPointInfo VALUES (  24,187,206,0);
INSERT INTO WayPointInfo VALUES (  24, 76,100,0);

# 俊浇扼聪救
INSERT INTO WayPointInfo VALUES (  11, 48,131,0);
INSERT INTO WayPointInfo VALUES (  11,223, 75,0);
INSERT INTO WayPointInfo VALUES (  12, 16, 99,0);
INSERT INTO WayPointInfo VALUES (  12,211,149,0);
INSERT INTO WayPointInfo VALUES (  13,127,163,0);
INSERT INTO WayPointInfo VALUES (  13,140, 74,0);
INSERT INTO WayPointInfo VALUES (  14, 50, 77,0);
INSERT INTO WayPointInfo VALUES (  14,233, 55,0);

# 肺凋魂
INSERT INTO WayPointInfo VALUES (  41,207,142,0);
INSERT INTO WayPointInfo VALUES (  41, 55,131,0);
INSERT INTO WayPointInfo VALUES (  42,124, 53,0);
INSERT INTO WayPointInfo VALUES (  42,119,223,0);
INSERT INTO WayPointInfo VALUES (  43, 45, 99,0);
INSERT INTO WayPointInfo VALUES (  43,217,184,0);
INSERT INTO WayPointInfo VALUES (  44, 82,103,0);
INSERT INTO WayPointInfo VALUES (  44,194,163,0);

# 靛肺海鸥
INSERT INTO WayPointInfo VALUES (  31, 27, 58,0);
INSERT INTO WayPointInfo VALUES (  31,132,211,0);
INSERT INTO WayPointInfo VALUES (  32,192,114,0);
INSERT INTO WayPointInfo VALUES (  32, 47, 63,0);
INSERT INTO WayPointInfo VALUES (  33,192,114,0);
INSERT INTO WayPointInfo VALUES (  33, 47, 63,0);
INSERT INTO WayPointInfo VALUES (  34,175,153,0);
INSERT INTO WayPointInfo VALUES (  34, 38,117,0);

# 萍葛福
INSERT INTO WayPointInfo VALUES (  54,178,237,0);
INSERT INTO WayPointInfo VALUES (  54, 70, 62,0);
INSERT INTO WayPointInfo VALUES (  51, 42, 90,0);
INSERT INTO WayPointInfo VALUES (  51,188,220,0);
INSERT INTO WayPointInfo VALUES (  52, 40, 48,0);
INSERT INTO WayPointInfo VALUES (  52,216,171,0);
INSERT INTO WayPointInfo VALUES (  53, 17,104,0);
INSERT INTO WayPointInfo VALUES (  53,199,110,0);

# 其肺唱
INSERT INTO WayPointInfo VALUES (  61, 44,139,0);
INSERT INTO WayPointInfo VALUES (  62, 93, 89,0);
INSERT INTO WayPointInfo VALUES (  63, 57,102,0);
INSERT INTO WayPointInfo VALUES (  64, 40,243,0);

##############################################################################
# 酒快胶磐令 措瘤沥飞狼 辉
##############################################################################
# 覆焊
INSERT INTO WayPointInfo VALUES (22,30,202,2);			# 覆焊合辑
INSERT INTO WayPointInfo VALUES (22,216,36,2);			# 覆焊合辑
INSERT INTO WayPointInfo VALUES (21,131,39,2);			# 覆焊合悼
INSERT INTO WayPointInfo VALUES (21,100,216,2);			# 覆焊合悼
INSERT INTO WayPointInfo VALUES (24,37,204,2);			# 覆焊巢辑
INSERT INTO WayPointInfo VALUES (24,218,203,2);			# 覆焊巢辑
INSERT INTO WayPointInfo VALUES (23,129,162,2);			# 覆焊巢悼
INSERT INTO WayPointInfo VALUES (23,242,207,2);			# 覆焊巢悼
INSERT INTO WayPointInfo VALUES (1004,71,68,2);			# 覆焊带傈
INSERT INTO WayPointInfo VALUES (1101,48,69,2);			# 官配府2摸
INSERT INTO WayPointInfo VALUES (1102,61,31,2);			# 官配府3摸
INSERT INTO WayPointInfo VALUES (1103,91,49,2);			# 官配府4摸
INSERT INTO WayPointInfo VALUES (1105,95,201,2);		# 绊福绊官磐澄
INSERT INTO WayPointInfo VALUES (1105,165,89,2);		# 绊福绊官磐澄
INSERT INTO WayPointInfo VALUES (1123,90,42,2);			# 鳃扼仇己瘤
INSERT INTO WayPointInfo VALUES (1011,14,107,2);		# 肺胶飘鸥捞踞1摸
INSERT INTO WayPointInfo VALUES (1012,56,76,2);			# 肺胶飘鸥捞踞2摸

# 俊浇扼聪酒
INSERT INTO WayPointInfo VALUES (12,143,14,2);			# 俊浇合辑
INSERT INTO WayPointInfo VALUES (12,36,202,2);			# 俊浇合辑
INSERT INTO WayPointInfo VALUES (11,81,43,2);			# 俊浇合悼
INSERT INTO WayPointInfo VALUES (11,167,226,2);			# 俊浇合悼
INSERT INTO WayPointInfo VALUES (14,125,124,2);			# 俊浇巢辑
INSERT INTO WayPointInfo VALUES (14,25,211,2);			# 俊浇巢辑
INSERT INTO WayPointInfo VALUES (13,43,215,2);			# 俊浇巢悼
INSERT INTO WayPointInfo VALUES (13,217,47,2);			# 俊浇巢悼
INSERT INTO WayPointInfo VALUES (1122,33,40,2);			# 抛皋府俊己瘤
INSERT INTO WayPointInfo VALUES (1001,221,47,2);		# 瘤窍荐肺
INSERT INTO WayPointInfo VALUES (1001,139,134,2);		# 瘤窍荐肺
INSERT INTO WayPointInfo VALUES (1002,56,64,2);			# 局浇带傈
INSERT INTO WayPointInfo VALUES (1010,111,88,2);		# 其捞厩磐澄

# 肺凋魂
INSERT INTO WayPointInfo VALUES (42,39,140,2);			# 肺凋合辑
INSERT INTO WayPointInfo VALUES (42,202,170,2);			# 肺凋合辑
INSERT INTO WayPointInfo VALUES (41,184,35,2);			# 肺凋合悼
INSERT INTO WayPointInfo VALUES (41,11,211,2);			# 肺凋合悼
INSERT INTO WayPointInfo VALUES (44,42,217,2);			# 肺凋巢辑
INSERT INTO WayPointInfo VALUES (44,208,89,2);			# 肺凋巢辑
INSERT INTO WayPointInfo VALUES (43,185,67,2);			# 肺凋巢悼
INSERT INTO WayPointInfo VALUES (43,63,211,2);			# 肺凋巢悼
INSERT INTO WayPointInfo VALUES (1008,40,81,2);			# 漠府籍奔
INSERT INTO WayPointInfo VALUES (1008,225,209,2);		# 漠府籍奔
INSERT INTO WayPointInfo VALUES (1111,23,50,2);			# 扼季寇己1摸
INSERT INTO WayPointInfo VALUES (1112,72,44,2);			# 扼季郴己1摸
INSERT INTO WayPointInfo VALUES (1113,89,45,2);			# 扼季郴己2摸

# 靛肺海鸥傍窜
INSERT INTO WayPointInfo VALUES (32,124,144,2);			# 靛肺海鸥合辑
INSERT INTO WayPointInfo VALUES (32,211,15,2);			# 靛肺海鸥合辑
INSERT INTO WayPointInfo VALUES (31,213,139,2);			# 靛肺海鸥合悼
INSERT INTO WayPointInfo VALUES (31,15,218,2);			# 靛肺海鸥合悼
INSERT INTO WayPointInfo VALUES (34,193,100,2);			# 靛肺海鸥巢辑
INSERT INTO WayPointInfo VALUES (34,98,231,2);			# 靛肺海鸥巢辑
INSERT INTO WayPointInfo VALUES (33,32,189,2);			# 靛肺海鸥巢悼
INSERT INTO WayPointInfo VALUES (33,239,166,2);			# 靛肺海鸥巢悼
INSERT INTO WayPointInfo VALUES (1125,108,108,2);		# 扼咳1摸
INSERT INTO WayPointInfo VALUES (1121,74,76,2);			# 扼咳2摸
INSERT INTO WayPointInfo VALUES (1126,53,70,2);			# 酒捞季1摸
INSERT INTO WayPointInfo VALUES (1124,68,59,2);			# 酒捞季2摸

# 其肺唱
INSERT INTO WayPointInfo VALUES (62,15,132,2);			# 其肺唱合辑
INSERT INTO WayPointInfo VALUES (61,75,115,2);			# 其肺唱合悼
INSERT INTO WayPointInfo VALUES (64,61,42,2);			# 其肺唱巢辑
INSERT INTO WayPointInfo VALUES (63,70,170,2);			# 其肺唱巢悼
INSERT INTO WayPointInfo VALUES (1013,55,78,2);			# 酒角府柯 带傈

# 萍葛福
INSERT INTO WayPointInfo VALUES (52,169,96,2);			# 萍葛福合辑
INSERT INTO WayPointInfo VALUES (52,32,176,2);			# 萍葛福合辑
INSERT INTO WayPointInfo VALUES (51,54,203,2);			# 萍葛福合悼
INSERT INTO WayPointInfo VALUES (51,206,64,2);			# 萍葛福合悼
INSERT INTO WayPointInfo VALUES (54,204,90,2);			# 萍葛福巢辑
INSERT INTO WayPointInfo VALUES (54,87,208,2);			# 萍葛福巢辑
INSERT INTO WayPointInfo VALUES (53,93,53,2);			# 萍葛福巢悼
INSERT INTO WayPointInfo VALUES (53,152,228,2);			# 萍葛福巢悼

# 酒快胶磐令 付阑
INSERT INTO WayPointInfo VALUES (1311,115,79,2);		# 酒快胶磐令付阑
INSERT INTO WayPointInfo VALUES (1322,98,76,2);			# 窍聪舅 带傈 2摸
INSERT INTO WayPointInfo VALUES (1323,109,69,2);		# 窍聪舅 带傈 3摸
#INSERT INTO WayPointInfo VALUES (1324,15,55,2);			# 窍聪舅 带傈 4摸
INSERT INTO WayPointInfo VALUES (81,127,128,2);			# 墨胶呕肺合悼