Evgeniy Khramtsov
e47475fff6
Reorganize SQL schema files
2018-07-19 10:24:19 +03:00
Evgeniy Khramtsov
223f0c4ac8
Initial SQL auto-update version
2018-07-18 14:01:29 +03:00
Evgeniy Khramtsov
3a5d2dbed8
Move mod_irc to ejabberd-contrib
2018-06-20 12:27:44 +03:00
Christophe Romain
61dee97738
Pubsub creation/modification use varchar ( #2397 )
2018-04-24 14:44:52 +02:00
Paweł Chmielowski
5912c573ea
Use length on fields in mysql indexes
2018-02-26 09:43:04 +01:00
Holger Weiss
f7566bd00e
sql/*: Add username to peer indexes
...
The username is available for all MAM queries in question, and adding it
to the indexes can improve the lookup performance significantly.
2018-02-24 00:50:20 +01:00
phejman
bef7d1ba66
Fix MySQL error server_host used in key specification without a key length
2018-02-05 12:33:59 +01:00
Alexey Shchepin
34d09018a7
Add new schemas for SQLite and MySQL
2017-12-26 20:48:15 +03:00
Alexey Shchepin
cf67b9ec54
Add missed server_host column in pg.new.sql
2017-11-30 13:08:38 +03:00
Christophe Romain
44700d91ba
PubSub: Cleanup tree requests, rename pubsub_node.type->pubsub_node.plugin
2017-11-16 11:38:04 +01:00
Alexey Shchepin
78dfb832b8
Add SQL_INSERT macro and update SQL queries to use server_host field
2017-11-02 18:21:40 +03:00
Paweł Chmielowski
ce98843dd4
Fix sql syntax error in lite.sql
2017-10-31 14:43:36 +01:00
Christophe Romain
0452ffc1df
Optimize muc subscriptions handling
2017-10-31 14:00:41 +01:00
Alexey Shchepin
e1c8e88d87
Update SQL archive index to match mysql.sql
2017-10-27 15:20:29 +03:00
Evgeniy Khramtsov
db57394399
Add SQL support for mod_push
2017-10-26 20:11:43 +03:00
Holger Weiss
1c6aa5e84e
mysql.sql: Use multi-column index on username/ID
2017-09-27 15:30:23 +02:00
Evgeniy Khramtsov
6691c59a7a
Clean up database code related to mod_vcard_xupdate
2017-05-17 19:29:19 +03:00
Evgeniy Khramtsov
f449df161a
Add SQL as mod_proxy65 RAM backend
2017-03-31 08:16:28 +03:00
Evgeniy Khramtsov
31fd83b2ae
Add SQL as mod_carboncopy RAM backend
2017-03-30 10:31:51 +03:00
Evgeniy Khramtsov
12e01a5119
Add SQL as mod_muc RAM backend
2017-03-29 12:58:01 +03:00
Evgeniy Khramtsov
e5815553cb
Add SQL as mod_bosh RAM backend
2017-03-28 20:33:57 +03:00
Evgeniy Khramtsov
117f31125d
Add SQL as router RAM backend
2017-03-28 16:31:37 +03:00
Jerome Sautret
bc9f178b6d
Fix pubsub MySQL schema
2017-02-23 16:04:29 +01:00
Christophe Romain
56df6e7ba8
Add missing NOT NULL restrictions
2017-02-22 15:47:36 +01:00
Christophe Romain
c0b346e0b8
Move archive tables into lite.sql for better comparison with other schemas
2017-02-22 15:44:03 +01:00
Badlop
5fdd1c39fe
Update copyright date automatically ( #1442 )
2017-01-02 21:42:06 +01:00
Christophe Romain
ed679279fd
Cleanup file headers
2016-12-27 10:57:50 +01:00
Alexey Shchepin
4add262090
Add OAUTH SQL backend
2016-08-01 16:55:43 +03:00
Juan Pablo Carlino
671bc4e573
Use MEDIUMTEXT type for muc_room.opts in MySQL schema
2016-05-02 15:06:40 +02:00
Paweł Chmielowski
b4739396ec
Switch to varchar(64) in mysql user.server/salt as text can't have default values
2016-04-08 17:50:59 +02:00
Evgeniy Khramtsov
c5dbdfc71a
'serverkey' and 'salt' should have empty string as default
2016-04-08 13:02:08 +03:00
Badlop
e386bf6b58
In SQL files create Users table with SCRAM support by default ( #956 )
2016-03-29 12:37:49 +02:00
Evgeniy Khramtsov
b0ef3e66a8
Update MSSQL schema
2016-03-29 11:53:13 +03:00
Evgeniy Khramtsov
4b0860e7de
Make it possible to define 'sm_db_type' per virtual host
2016-02-19 16:38:43 +03:00
Badlop
f448ff608a
Update copyright to 2016 ( #901 )
2016-01-13 12:29:14 +01:00
Evgeniy Khramtsov
7d1c75d0e8
Use UTF8MB4 character set in MySQL tables
2015-12-11 16:13:48 +01:00
Pablo Polvorin
aaa718741e
Use BLOB instead of TEXT on mysql in stanza storage
...
Mysql 'utf8' do not support 4-bytes UTF8 chars.
Characters like 'KISS MARK' (U+1F48B) causes mysql
to cut the string at that point.
There is utf8mb4 encoding available on newer mysql
versions that do support 4-bytes utf8. But for storing
stanzas, that doesn't need to be indexed or searched or
inspected in any way, it was easier to use BLOB
(the bytes stored are utf8 encoded anyway, like all XMPP),
and avoids the need to redefine indexes (as allowed size
is shorter on utf8mb4) or having mixed utf8 and utf8mb4
encodings on the same table.
2015-12-11 16:07:39 +01:00
Evgeniy Khramtsov
ab857b1a5e
Improve MSSQL schema
2015-09-14 14:05:07 +03:00
Evgeniy Khramtsov
25791cfde8
Fix MSSQL support
2015-09-13 18:31:49 +03:00
Evgeniy Khramtsov
40feed723d
Add support for MUC MAM
2015-08-08 22:15:36 +03:00
Evgeniy Khramtsov
83cce468a5
Add MAM (XEP-0313) support
2015-06-22 16:56:08 +03:00
Christophe Romain
fcdb519770
Add missing sm table (thanks to Rasim Kalimullin)(EJAB-1740)
2015-05-20 13:50:59 +02:00
Evgeny Khramtsov
05011e6918
Revert "added sm table to pg.sql"
2015-05-20 13:57:44 +03:00
Matthias Rieber
0800a9733c
pg - added sm table
2015-05-17 21:38:33 +02:00
Evgeny Khramtsov
5a820aca40
Merge pull request #486 from saa/sqlite_support
...
Add SQLite support
2015-04-08 14:34:56 +03:00
Sergey Abramyan
15af88a09a
Fix lite.sql and convert binary to integer
2015-03-27 22:14:29 +03:00
Alexey Shchepin
477d27a3dc
Remove duplicate CREATE INDEX in mysql.sql
2015-03-21 23:41:43 +03:00
Alexey Shchepin
e575c87ea2
Add SCRAM support to ejabberd_auth_odbc
2015-03-20 13:45:24 +03:00
Alexey Shchepin
0eb6b942ff
Add a missed SQL index on privacy_list_data table
2015-03-20 10:40:25 +01:00
Jerome Sautret
6b67a66a1b
Added MySQL support for delete_old_messages (offline) command.
2015-03-20 10:40:19 +01:00
