summaryrefslogtreecommitdiff
path: root/sql/mysql.sql (follow)
Commit message (Collapse)AuthorAgeFilesLines
* Add SQL schemas for MQTT tablesEvgeny Khramtsov2019-02-271-0/+15
|
* MySQL: Increase index prefix length for PEP nodesHolger Weiss2019-02-261-1/+1
| | | | | For PEP nodes, the "host" column holds the user JID, where the first 20 characters may well not be unique.
* Merge branch 'mix'Evgeny Khramtsov2019-02-211-0/+53
|\
| * Update MIX code to reflect newest specificationEvgeny Khramtsov2018-12-051-0/+53
| | | | | | | | | | | | Note that support for older specification is completely dropped, i.e. no backward compatibility is provided since the XEPs are still very experimental and being changed drastically
* | Manually update 2017 copyright dates (#2756)Badlop2019-01-081-1/+1
|/
* Keep info about carbons inside session tableEvgeny Khramtsov2018-12-011-10/+0
| | | | | | | | | | | | | | | Accordingly, Mnesia/SQL/Riak table 'carboncopy' is not used anymore and can be safely removed. As a consequence, the commit deprecates the following options of mod_carboncopy: - ram_db_type - use_cache - cache_size - cache_missed - cache_life_time Fixes #2663
* MySQL: Use MEDIUMTEXT for PubSub payloadHolger Weiss2018-09-261-1/+1
| | | | | Let MySQL/MariaDB accept PubSub payloads with a size of up to 16 MiB, rather than truncating at 64 KiB.
* MySQL: Use MEDIUMTEXT for MAM/offline messagesHolger Weiss2018-09-161-3/+3
| | | | | Let MySQL/MariaDB accept message stanzas with a size of up to 16 MiB, rather than truncating at 64 KiB.
* Move mod_irc to ejabberd-contribEvgeniy Khramtsov2018-06-201-9/+0
|
* Pubsub creation/modification use varchar (#2397)Christophe Romain2018-04-241-2/+2
|
* Use length on fields in mysql indexesPaweł Chmielowski2018-02-261-3/+3
|
* sql/*: Add username to peer indexesHolger Weiss2018-02-241-3/+3
| | | | | The username is available for all MAM queries in question, and adding it to the indexes can improve the lookup performance significantly.
* PubSub: Cleanup tree requests, rename pubsub_node.type->pubsub_node.pluginChristophe Romain2017-11-161-1/+1
|
* Optimize muc subscriptions handlingChristophe Romain2017-10-311-0/+12
|
* Add SQL support for mod_pushEvgeniy Khramtsov2017-10-261-0/+11
|
* mysql.sql: Use multi-column index on username/IDHolger Weiss2017-09-271-1/+1
|
* Clean up database code related to mod_vcard_xupdateEvgeniy Khramtsov2017-05-171-6/+0
|
* Add SQL as mod_proxy65 RAM backendEvgeniy Khramtsov2017-03-311-0/+12
|
* Add SQL as mod_carboncopy RAM backendEvgeniy Khramtsov2017-03-301-0/+10
|
* Add SQL as mod_muc RAM backendEvgeniy Khramtsov2017-03-291-0/+21
|
* Add SQL as mod_bosh RAM backendEvgeniy Khramtsov2017-03-281-0/+8
|
* Add SQL as router RAM backendEvgeniy Khramtsov2017-03-281-0/+11
|
* Fix pubsub MySQL schemaJerome Sautret2017-02-231-3/+3
|
* Add missing NOT NULL restrictionsChristophe Romain2017-02-221-16/+16
|
* Update copyright date automatically (#1442)Badlop2017-01-021-1/+1
|
* Add OAUTH SQL backendAlexey Shchepin2016-08-011-0/+7
|
* Use MEDIUMTEXT type for muc_room.opts in MySQL schemaJuan Pablo Carlino2016-05-021-1/+1
|
* Switch to varchar(64) in mysql user.server/salt as text can't have default ↵Paweł Chmielowski2016-04-081-4/+4
| | | | values
* In SQL files create Users table with SCRAM support by default (#956)Badlop2016-03-291-1/+4
|
* Update copyright to 2016 (#901)Badlop2016-01-131-1/+1
|
* Use UTF8MB4 character set in MySQL tablesEvgeniy Khramtsov2015-12-111-71/+71
|
* Use BLOB instead of TEXT on mysql in stanza storagePablo Polvorin2015-12-111-1/+1
| | | | | | | | | | | | | | 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.
* Add support for MUC MAMEvgeniy Khramtsov2015-08-081-0/+2
|
* Add MAM (XEP-0313) supportEvgeniy Khramtsov2015-06-221-0/+25
|
* Remove duplicate CREATE INDEX in mysql.sqlAlexey Shchepin2015-03-211-2/+1
|
* Add SCRAM support to ejabberd_auth_odbcAlexey Shchepin2015-03-201-0/+4
|
* Add a missed SQL index on privacy_list_data tableAlexey Shchepin2015-03-201-0/+2
|
* Added MySQL support for delete_old_messages (offline) command.Jerome Sautret2015-03-201-0/+1
|
* Make it possible to use SQL as an SM backendEvgeniy Khramtsov2015-03-091-0/+14
|
* Update copyright dates to 2015 (EJAB-1733)Badlop2015-01-081-1/+1
|
* added privacy_list_data index for mysql database.HAMANO Tsukasa2014-04-241-0/+1
|
* Merge pull request #146 from jamielinux/masterbadlop2014-04-111-4/+3
|\ | | | | Update FSF address
| * Update FSF addressJamie Nguyen2014-02-221-4/+3
| |
* | Update copyright dates to 2014 (EJAB-1679)Badlop2014-03-131-1/+1
|/
* Get rid of deprecated MySQL variable 'table_type'Evgeniy Khramtsov2013-10-231-29/+25
|
* Switch to rebar build toolEvgeniy Khramtsov2013-06-131-0/+284
Use dynamic Rebar configuration Make iconv dependency optional Disable transient_supervisors compile option Add hipe compilation support Only compile ibrowse and lhttpc when needed Make it possible to generate an OTP application release Add --enable-debug compile option Add --enable-all compiler option Add --enable-tools configure option Add --with-erlang configure option. Add --enable-erlang-version-check configure option. Add lager support Improve the test suite
generated by cgit v1.2.3 (git 2.25.1) at 2024-07-05 21:25:48 +0000