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/pg.sql | |
| parent | Adopt 'make install' to updated output from 'rebar list-deps' (diff) | |
Add SQL support for mod_push
Diffstat (limited to '')
| -rw-r--r-- | sql/pg.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/sql/pg.sql b/sql/pg.sql index f761e68da..e26b1111f 100644 --- a/sql/pg.sql +++ b/sql/pg.sql @@ -395,3 +395,14 @@ CREATE TABLE proxy65 ( CREATE UNIQUE INDEX i_proxy65_sid ON proxy65 USING btree (sid); CREATE INDEX i_proxy65_jid ON proxy65 USING btree (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 USING btree (username, service, node); +CREATE UNIQUE INDEX i_push_ut ON push_session USING btree (username, timestamp); |