mirror of
https://github.com/processone/ejabberd
synced 2025-10-03 17:59:31 +02:00
10 lines
274 B
SQL
10 lines
274 B
SQL
CREATE TABLE route (
|
|
domain text NOT NULL,
|
|
server_host text NOT NULL,
|
|
node text NOT NULL,
|
|
pid text NOT NULL,
|
|
local_hint text NOT NULL
|
|
);
|
|
|
|
CREATE UNIQUE INDEX i_route ON route(domain, server_host, node, pid);
|
|
CREATE INDEX i_route_domain ON route(domain);
|