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);