aboutsummaryrefslogtreecommitdiff
path: root/sql/mysql.sql (unfollow)
Commit message (Collapse)AuthorFilesLines
2022-02-18Optimize room_unused_* commandsPaweł Chmielowski1-0/+1
Previously to check if hibernated room was old enough we had to fetch info about all rooms from database. Now we repurpose created_at field in sql to store that info, that allow us to have more efficient query just for it.
2022-02-11Update copyright year to 2022Badlop1-1/+1
2021-12-14Handle user removal in mod_mucAlexey Shchepin1-0/+1
2021-05-20MySQL Backend Patch for scram-sha512 (#3582)Nikat1-2/+2
* Update mysql.new.sql scram-sha512 does not work, because serverkey is longer, then that array. All passwords was unhashed. * Update mysql.sql
2021-05-18Add missing indexes to sql sr_group tablesPaweł Chmielowski1-0/+2
2021-02-01Fix specified key was too long (#3513)Divine1-2/+2
* Fix specified key was too long This adds the correct engine and sets it to utf8mb4 collate. Prevents "Specified key was too long; max key length is 1000 bytes" from happening. * Make two import SQL files consistent As suggested by @prefiks
2021-01-27Update newest copyright year to 2021 (#3464)Badlop1-1/+1
2020-01-28Update copyright to 2020 (#3149)Badlop1-1/+1
2019-10-03Check redirect_uri for OAUTH implicit grantAlexey Shchepin1-2/+2
2019-09-27Support OAUTH client authenticationAlexey Shchepin1-0/+7
2019-02-27Add SQL schemas for MQTT tablesEvgeny Khramtsov1-0/+15
2019-02-26MySQL: Increase index prefix length for PEP nodesHolger Weiss1-1/+1
For PEP nodes, the "host" column holds the user JID, where the first 20 characters may well not be unique.
2019-01-08Manually update 2017 copyright dates (#2756)Badlop1-1/+1
2018-12-05Update MIX code to reflect newest specificationEvgeny Khramtsov1-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
2018-12-01Keep info about carbons inside session tableEvgeny Khramtsov1-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
2018-09-26MySQL: Use MEDIUMTEXT for PubSub payloadHolger Weiss1-1/+1
Let MySQL/MariaDB accept PubSub payloads with a size of up to 16 MiB, rather than truncating at 64 KiB.
2018-09-16MySQL: Use MEDIUMTEXT for MAM/offline messagesHolger Weiss1-3/+3
Let MySQL/MariaDB accept message stanzas with a size of up to 16 MiB, rather than truncating at 64 KiB.
2018-06-20Move mod_irc to ejabberd-contribEvgeniy Khramtsov1-9/+0
2018-04-24Pubsub creation/modification use varchar (#2397)Christophe Romain1-2/+2
2018-02-26Use length on fields in mysql indexesPaweł Chmielowski1-3/+3
2018-02-24sql/*: Add username to peer indexesHolger Weiss1-3/+3
The username is available for all MAM queries in question, and adding it to the indexes can improve the lookup performance significantly.
2017-11-16PubSub: Cleanup tree requests, rename pubsub_node.type->pubsub_node.pluginChristophe Romain1-1/+1
2017-10-31Optimize muc subscriptions handlingChristophe Romain1-0/+12
2017-10-26Add SQL support for mod_pushEvgeniy Khramtsov1-0/+11
2017-09-27mysql.sql: Use multi-column index on username/IDHolger Weiss1-1/+1
2017-05-17Clean up database code related to mod_vcard_xupdateEvgeniy Khramtsov1-6/+0
2017-03-31Add SQL as mod_proxy65 RAM backendEvgeniy Khramtsov1-0/+12
2017-03-30Add SQL as mod_carboncopy RAM backendEvgeniy Khramtsov1-0/+10
2017-03-29Add SQL as mod_muc RAM backendEvgeniy Khramtsov1-0/+21
2017-03-28Add SQL as mod_bosh RAM backendEvgeniy Khramtsov1-0/+8
2017-03-28Add SQL as router RAM backendEvgeniy Khramtsov1-0/+11
2017-02-23Fix pubsub MySQL schemaJerome Sautret1-3/+3
2017-02-22Add missing NOT NULL restrictionsChristophe Romain1-16/+16
2017-01-02Update copyright date automatically (#1442)Badlop1-1/+1
2016-08-01Add OAUTH SQL backendAlexey Shchepin1-0/+7
2016-05-02Use MEDIUMTEXT type for muc_room.opts in MySQL schemaJuan Pablo Carlino1-1/+1
2016-04-12Synchronizing master changesMickael Remond1-4/+4
2016-04-08Switch to varchar(64) in mysql user.server/salt as text can't have default ↵Paweł Chmielowski1-4/+4
values
2016-03-29In SQL files create Users table with SCRAM support by default (#956)Badlop1-1/+4
2016-01-13Update copyright to 2016 (#901)Badlop1-1/+1
2015-12-11Use UTF8MB4 character set in MySQL tablesEvgeniy Khramtsov1-71/+71
2015-12-11Use BLOB instead of TEXT on mysql in stanza storagePablo Polvorin1-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.
2015-08-08Add support for MUC MAMEvgeniy Khramtsov1-0/+2
2015-06-22Add MAM (XEP-0313) supportEvgeniy Khramtsov1-0/+25
2015-03-21Remove duplicate CREATE INDEX in mysql.sqlAlexey Shchepin1-2/+1
2015-03-20Add SCRAM support to ejabberd_auth_odbcAlexey Shchepin1-0/+4
2015-03-20Add a missed SQL index on privacy_list_data tableAlexey Shchepin1-0/+2
2015-03-20Added MySQL support for delete_old_messages (offline) command.Jerome Sautret1-0/+1
2015-03-09Make it possible to use SQL as an SM backendEvgeniy Khramtsov1-0/+14
2015-01-08Update copyright dates to 2015 (EJAB-1733)Badlop1-1/+1