diff options
| author | Evgeniy Khramtsov <ekhramtsov@process-one.net> | 2017-03-28 16:31:37 +0300 |
|---|---|---|
| committer | Evgeniy Khramtsov <ekhramtsov@process-one.net> | 2017-03-28 16:31:37 +0300 |
| commit | 117f31125d4d1e39f6bf639360ff37a44664dbb2 (patch) | |
| tree | c9ce313e6f7d2d82ac0f1543354ec86c2cbb978e /sql/lite.sql | |
| parent | Fix PEP issues (#1636) (diff) | |
Add SQL as router RAM backend
Diffstat (limited to 'sql/lite.sql')
| -rw-r--r-- | sql/lite.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/sql/lite.sql b/sql/lite.sql index 3e923176..bc6a6e70 100644 --- a/sql/lite.sql +++ b/sql/lite.sql @@ -319,3 +319,14 @@ CREATE TABLE oauth_token ( scope text NOT NULL, expire bigint NOT NULL ); + +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); |