aboutsummaryrefslogtreecommitdiff
path: root/sql/mysql.new.sql (follow)
Commit message (Collapse)AuthorAgeFilesLines
* Optimize room_unused_* commandsPaweł Chmielowski2022-02-181-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.
* Update copyright year to 2022Badlop2022-02-111-1/+1
|
* Handle user removal in mod_mucAlexey Shchepin2021-12-141-0/+1
|
* Fix typo when creating index (thanks to Millesimus)Badlop2021-08-051-1/+1
| | | | Reference: https://github.com/processone/ejabberd/commit/95fa43aa96514b7e8b77fa7c29d2c0b5b1c1331a#r54157330
* MySQL Backend Patch for scram-sha512 (#3582)Nikat2021-05-201-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
* Add missing indexes to sql sr_group tablesPaweł Chmielowski2021-05-181-0/+3
|
* Fix specified key was too long (#3513)Divine2021-02-011-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
* Update newest copyright year to 2021 (#3464)Badlop2021-01-271-1/+1
|
* Update copyright to 2020 (#3149)Badlop2020-01-281-1/+1
|
* Check redirect_uri for OAUTH implicit grantAlexey Shchepin2019-10-031-0/+7
|
* Change type of server_host column in mysql.new.sqlPaweł Chmielowski2019-07-311-24/+24
| | | | | | Indexes are done only on 191 byte slice of that (to fit in index limits), and since server_host could theoretically be bigger this causes mysql engine don't use indexes in full potential.
* Add SQL schemas for MQTT tablesEvgeny Khramtsov2019-02-271-0/+16
|
* 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/+54
|\
| * Update MIX code to reflect newest specificationEvgeny Khramtsov2018-12-051-0/+54
| | | | | | | | | | | | 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-11/+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-10/+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.
* Fix MySQL error server_host used in key specification without a key lengthphejman2018-02-051-2/+2
|
* Add new schemas for SQLite and MySQLAlexey Shchepin2017-12-261-0/+449