createshrineinfo.sql

天之炼狱OpenDE_SQL.tar.gz

################################################################################
#
#  Project : Online Game DARKEDEN
#  Module  :
#
#  FileName : CreateShrineInfo.sql
#
#  History
# ------------ -------------- -----------------------------------------------
# 2003.01.29   硅犁屈, 剧铰疙  脚痹 颇老 积己
# 2003.02.10   剧铰疙		   Slayer/Vampire 荐龋己窜 备盒, OwnerRace 鞘靛 眠啊
#
#################################################################################

# 抛捞喉 积己 
# 扁粮 table drop窍搁 救等促. 犬牢夸噶
DROP TABLE IF EXISTS ShrineInfo;

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

	Name		varchar(20)				not null	default '',

	ItemType	tinyint		unsigned	not null	default 0,

	SlayerGuardZoneID	smallint	unsigned	not null	default 0,
	SlayerGuardX		int			unsigned	not null	default 0,
	SlayerGuardY		int			unsigned	not null	default 0,
	SlayerGuardMType	smallint	unsigned	not null	default 0,

	VampireGuardZoneID	smallint	unsigned	not null	default 0,
	VampireGuardX		int			unsigned	not null	default 0,
	VampireGuardY		int			unsigned	not null	default 0,
	VampireGuardMType	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,

	OwnerRace	tinyint		unsigned	not null	default 0,

	PRIMARY KEY( ID )
);

# 单捞磐 持扁
INSERT INTO ShrineInfo VALUES ( 0, "阿尔梅加",  0, 1201, 56, 61, 526, 1204, 64, 61, 526, 72, 116,  85, 538, 0);
INSERT INTO ShrineInfo VALUES ( 1, "米豪雷",    1, 1201, 61, 78, 527, 1204, 67, 74, 527, 72, 172, 143, 539, 0);
INSERT INTO ShrineInfo VALUES ( 2, "基罗",      2, 1201, 71, 68, 528, 1204, 55, 70, 528, 72,  73, 130, 540, 0);
INSERT INTO ShrineInfo VALUES ( 3, "阿伊尼",    3, 1203, 76, 52, 529, 1202, 85, 61, 529, 72, 173, 116, 541, 1);
INSERT INTO ShrineInfo VALUES ( 4, "格雷高厉",  4, 1203, 80, 55, 530, 1202, 78, 48, 530, 72, 116, 173, 542, 1);
INSERT INTO ShrineInfo VALUES ( 5, "孔切里亚",  5, 1203, 84, 61, 531, 1202, 86, 56, 531, 72, 129,  72, 543, 1);
INSERT INTO ShrineInfo VALUES ( 6, "雷吉奥斯",  6, 1203, 91, 43, 532, 1202, 81, 60, 532, 72, 129, 186, 544, 0);
INSERT INTO ShrineInfo VALUES ( 7, "希而里",    7, 1203, 92, 50, 533, 1202, 76, 55, 533, 72, 142,  85, 545, 0);
INSERT INTO ShrineInfo VALUES ( 8, "扎夫",      8, 1203, 84, 43, 534, 1202, 75, 51, 534, 72,  86, 143, 546, 0);
INSERT INTO ShrineInfo VALUES ( 9, "内玛",      9, 1201, 68, 75, 535, 1204, 57, 63, 535, 72, 185, 130, 547, 1);
INSERT INTO ShrineInfo VALUES (10, "阿罗萨",   10, 1201, 64, 59, 536, 1204, 60, 76, 536, 72,  86, 117, 548, 1);
INSERT INTO ShrineInfo VALUES (11, "察斯法",   11, 1201, 54, 69, 537, 1204, 69, 67, 537, 72, 142, 173, 549, 1);