createcastleshrineinfo.sql

天之炼狱OpenDE_SQL.tar.gz

################################################################################
#
#  Project : Online Game DARKEDEN
#  Module  :
#
#  FileName : CreateShrineInfo.sql
#
#  History
# ------------ -------------- -----------------------------------------------
# 2003.02.11   辣康侥         脚痹 颇老 积己
#
#################################################################################

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

CREATE TABLE CastleShrineInfo
(
	ID			smallint	unsigned 	not null	default 0,

	Name		varchar(20)				not null	default '',

	ItemType	tinyint		unsigned	not null	default 0,

	GuardZoneID	smallint	unsigned	not null	default 0,
	GuardX		int			unsigned	not null	default 0,
	GuardY		int			unsigned	not null	default 0,
	GuardMType	smallint	unsigned	not null	default 0,

	HolyZoneID	smallint	unsigned	not null	default 0,
	HolyX		int			unsigned	not null	default 0,
	HolyY		int			unsigned	not null	default 0,
	HolyMType	smallint	unsigned	not null	default 0,

	PRIMARY KEY( ID )
);

# 单捞磐 持扁
INSERT INTO CastleShrineInfo VALUES ( 0, "帕拉罗斯",   0, 1212, 22, 32, 560, 1211, 93, 74, 560);
INSERT INTO CastleShrineInfo VALUES ( 1, "帕亚",     1, 1222, 22, 32, 561, 1221, 93, 74, 561);
INSERT INTO CastleShrineInfo VALUES ( 2, "爱里克",     2, 1232, 22, 32, 562, 1231, 93, 74, 562);
INSERT INTO CastleShrineInfo VALUES ( 3, "伊莫特", 3, 1242, 22, 32, 563, 1241, 93, 74, 563);

# 16, 85