ejabberd_router.sql « pgsql « sql - github.com/processone/ejabberd.git - Unnamed repository; edit this file 'description' to name the repository.

Welcome to mirror list, hosted at ThFree Co, Russian Federation.

ejabberd_router.sql « pgsql « sql - github.com/processone/ejabberd.git - Unnamed repository; edit this file 'description' to name the repository.

summary refs log tree commit diff

path: root/sql/pgsql/ejabberd_router.sql

blob: d6f1778b639a404a4fd9db5fcc0de4da0f6952ba (plain)

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