createflagpoleposition.sql

天之炼狱OpenDE_SQL.tar.gz

DROP TABLE IF EXISTS FlagPolePosition;
#铰疙捞 官焊

CREATE TABLE FlagPolePosition (
 ZoneID		smallint(5)	unsigned NOT NULL DEFAULT 0,
 CenterX	int(10)		unsigned NOT NULL DEFAULT 0,
 CenterY	int(10)		unsigned NOT NULL DEFAULT 0,
 Width		int(10)		unsigned NOT NULL DEFAULT 0,
 Height		int(10)		unsigned NOT NULL DEFAULT 0,
 Race		enum('SLAYER','VAMPIRE','OUSTERS') NOT NULL DEFAULT 'SLAYER',
 MonsterType smallint(5)	unsigned NOT NULL DEFAULT 0
);

#INSERT INTO FlagPolePosition VALUES (12, 162, 190, 10, 10, 'SLAYER', 670);
#INSERT INTO FlagPolePosition VALUES (24, 234, 58, 10, 10, 'VAMPIRE', 670);
#INSERT INTO FlagPolePosition VALUES (23, 240, 190, 10, 10, 'OUSTERS', 670);

INSERT INTO FlagPolePosition VALUES (32, 109, 156, 5, 5, 'OUSTERS', 670);
INSERT INTO FlagPolePosition VALUES (32, 132, 126, 5, 5, 'OUSTERS', 670);
INSERT INTO FlagPolePosition VALUES (32, 138, 152, 5, 5, 'OUSTERS', 670);
INSERT INTO FlagPolePosition VALUES (32, 106, 130, 5, 5, 'OUSTERS', 670);

INSERT INTO FlagPolePosition VALUES (12, 154, 182, 5, 5, 'SLAYER', 670);
INSERT INTO FlagPolePosition VALUES (12, 124, 147, 5, 5, 'SLAYER', 670);
INSERT INTO FlagPolePosition VALUES (12, 172, 197, 5, 5, 'SLAYER', 670);
INSERT INTO FlagPolePosition VALUES (12, 138, 167, 5, 5, 'SLAYER', 670);

INSERT INTO FlagPolePosition VALUES (23, 7, 56, 5, 5, 'VAMPIRE', 670);
INSERT INTO FlagPolePosition VALUES (23, 26, 65, 5, 5, 'VAMPIRE', 670);
INSERT INTO FlagPolePosition VALUES (23, 52, 23, 5, 5, 'VAMPIRE', 670);
INSERT INTO FlagPolePosition VALUES (23, 61, 70, 5, 5, 'VAMPIRE', 670);