diff options
| author | Evgeniy Khramtsov <ekhramtsov@process-one.net> | 2017-10-26 20:11:43 +0300 |
|---|---|---|
| committer | Evgeniy Khramtsov <ekhramtsov@process-one.net> | 2017-10-26 20:11:43 +0300 |
| commit | db573943997dee93307acb7978f21494b9fc24a4 (patch) | |
| tree | fe998aea40258d2b0934b6ea9b9a5047227086b6 /sql/lite.sql | |
| parent | Adopt 'make install' to updated output from 'rebar list-deps' (diff) | |
Add SQL support for mod_push
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 1cc0c4dc..0789ca45 100644 --- a/sql/lite.sql +++ b/sql/lite.sql @@ -375,3 +375,14 @@ CREATE TABLE proxy65 ( CREATE UNIQUE INDEX i_proxy65_sid ON proxy65 (sid); CREATE INDEX i_proxy65_jid ON proxy65 (jid_i); + +CREATE TABLE push_session ( + username text NOT NULL, + timestamp bigint NOT NULL, + service text NOT NULL, + node text NOT NULL, + xml text NOT NULL +); + +CREATE UNIQUE INDEX i_push_usn ON push_session (username, service, node); +CREATE UNIQUE INDEX i_push_ut ON push_session (username, timestamp); |