10 lines
292 B
SQL
Executable File
10 lines
292 B
SQL
Executable File
DROP TABLE IF EXISTS world_zones;
|
|
CREATE TABLE world_zones (
|
|
id INTEGER PRIMARY KEY,
|
|
server_id INTEGER NOT NULL DEFAULT 0,
|
|
zone_id INTEGER NOT NULL DEFAULT 0,
|
|
name TEXT NOT NULL DEFAULT '',
|
|
description TEXT NOT NULL DEFAULT '',
|
|
UNIQUE(server_id, zone_id)
|
|
);
|