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

github.com/processone/ejabberd.git - Unnamed repository; edit this file 'description' to name the repository.
summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
Diffstat (limited to 'sql/sqlite/mod_proxy65.sql')
-rw-r--r--sql/sqlite/mod_proxy65.sql11
1 files changed, 11 insertions, 0 deletions
diff --git a/sql/sqlite/mod_proxy65.sql b/sql/sqlite/mod_proxy65.sql
new file mode 100644
index 000000000..57f623575
--- /dev/null
+++ b/sql/sqlite/mod_proxy65.sql
@@ -0,0 +1,11 @@
+CREATE TABLE proxy65 (
+ sid text NOT NULL,
+ pid_t text NOT NULL,
+ pid_i text NOT NULL,
+ node_t text NOT NULL,
+ node_i text NOT NULL,
+ jid_i text NOT NULL
+);
+
+CREATE UNIQUE INDEX i_proxy65_sid ON proxy65 (sid);
+CREATE INDEX i_proxy65_jid ON proxy65 (jid_i);