32 lines
1.9 KiB
SQL
32 lines
1.9 KiB
SQL
DROP TABLE IF EXISTS starting_zones;
|
|
CREATE TABLE starting_zones (
|
|
id INTEGER PRIMARY KEY,
|
|
class_id INTEGER NOT NULL DEFAULT 255,
|
|
race_id INTEGER NOT NULL DEFAULT 255,
|
|
choice INTEGER NOT NULL DEFAULT 255,
|
|
zone_id INTEGER NOT NULL DEFAULT 253,
|
|
is_instance INTEGER NOT NULL DEFAULT 0,
|
|
min_version INTEGER NOT NULL DEFAULT 0,
|
|
max_version INTEGER NOT NULL DEFAULT 0,
|
|
x REAL NOT NULL DEFAULT -999999,
|
|
y REAL NOT NULL DEFAULT -999999,
|
|
z REAL NOT NULL DEFAULT -999999,
|
|
heading REAL NOT NULL DEFAULT -999999,
|
|
deity INTEGER NOT NULL DEFAULT 255,
|
|
ruleflag INTEGER NOT NULL DEFAULT 0,
|
|
description TEXT DEFAULT '',
|
|
start_alignment INTEGER NOT NULL DEFAULT 0
|
|
);
|
|
|
|
INSERT INTO starting_zones VALUES
|
|
(2,255,255,1,253,0,0,0,-999999,-999999,-999999,-999999,1,3,'Queens Colony, Good Deity/Alignment, skip tutorial',1),
|
|
(3,255,255,0,27,1,0,0,-999999,-999999,-999999,-999999,255,3,'Far Journey Tutorial which leads to Queens Colony, Outpost of the Overlord or Isle of Refuge',0),
|
|
(4,255,255,4,114,0,60085,65535,-999999,-999999,-999999,-999999,255,4,'Greater Faydark aka Kelethin',1),
|
|
(5,255,255,8,184,0,60085,65535,-999999,-999999,-999999,-999999,255,4,'Timorous Deep aka Gorowyn',0),
|
|
(6,255,255,16,34,0,60085,65535,-999999,-999999,-999999,-999999,255,4,'Darklight Wood aka Neriak',0),
|
|
(7,255,255,32,470,0,60085,65535,-999999,-999999,-999999,-999999,255,4,'Frostfang Sea aka New Halas',1),
|
|
(8,255,255,1,278,0,0,0,-999999,-999999,-999999,-999999,0,3,'Outpost of Overlord, Evil Deity/Alignment, skip tutorial',1),
|
|
(13,255,255,0,27,1,0,546,-999999,-999999,-999999,-999999,255,8,'DoF Client to Far Journey Freeport',0),
|
|
(14,255,255,1,325,0,0,546,-999999,-999999,-999999,-999999,255,8,'DoF Client to Isle Refuge',0),
|
|
(17,255,255,255,27,1,547,60114,-999999,-999999,-999999,-999999,255,8,'AoM and later client to Far Journey Freeport',0);
|