aboutsummaryrefslogtreecommitdiff
path: root/sql (follow)
Commit message (Collapse)AuthorAgeFilesLines
* Sync old-to-new schema script with reality (#3790)Stu Tomlinson2022-03-081-0/+18
| | | Update the update_sql function to match current "new" sql schema
* Fix sqlite schemaPaweł Chmielowski2022-02-182-2/+2
|
* Optimize room_unused_* commandsPaweł Chmielowski2022-02-187-16/+24
| | | | | | 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-117-7/+7
|
* Fix support for MSSQL testingBadlop2022-02-031-1/+1
|
* Handle user removal in mod_mucAlexey Shchepin2021-12-147-0/+7
|
* Fix vcard_search definition in pgsql new schema (thanks to Stu Tomlinson)(#3695)Badlop2021-10-141-1/+1
| | | | | | How to update an existing database: ALTER TABLE vcard_search DROP CONSTRAINT vcard_search_pkey; ALTER TABLE vcard_search ADD PRIMARY KEY (server_host, lusername);
* Add indexes from 95fa43aa to the old-to-new MySQL schema update scriptBadlop2021-09-271-0/+2
|
* Merge pull request #3656 from pitchum/masterbadlop2021-08-161-0/+6
|\ | | | | Add missing pgsql migration for table push_session
| * Add missing SQL migration for table push_sessionpitchum2021-08-011-0/+6
| |
* | Fix typo when creating index (thanks to Millesimus)Badlop2021-08-051-1/+1
|/ | | | Reference: https://github.com/processone/ejabberd/commit/95fa43aa96514b7e8b77fa7c29d2c0b5b1c1331a#r54157330
* Add mqtt_pub table definition for MSSQL (#3097)Badlop2021-06-141-0/+20
|
* MySQL Backend Patch for scram-sha512 (#3582)Nikat2021-05-202-4/+4
| | | | | | | * 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-186-0/+15
|
* Fix specified key was too long (#3513)Divine2021-02-012-4/+4
| | | | | | | | | * 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-277-7/+7
|
* Add sql script to migrate mysql from old schema to newPaweł Chmielowski2021-01-071-0/+160
|
* Merge pull request #3132 from area-42/publisher_mssql_text_to_varcharJérôme Sautret2020-04-101-1/+1
|\ | | | | change PubSub publisher from text to varchar for mssql
| * change publisher from text to varchar for mssqlChristoph Scholz2019-12-281-1/+1
| |
* | Merge pull request #3127 from area-42/allow_emojis_with_mssqlMickaël Rémond2020-02-201-2/+2
|\ \ | | | | | | allow storage of emojis in archive on mssql
| * | allow storage of emojis in archive on mssqlChristoph Scholz2019-12-271-2/+2
| |/
* | Add missing oauth_client table declaration in lite.new.sqlPaweł Chmielowski2020-01-311-0/+7
| |
* | Update copyright to 2020 (#3149)Badlop2020-01-287-7/+7
|/
* Make PostgreSQL schema compatible with CockroachDBEvgeny Khramtsov2019-10-232-2/+2
|
* Check redirect_uri for OAUTH implicit grantAlexey Shchepin2019-10-035-6/+20
|
* Support OAUTH client authenticationAlexey Shchepin2019-09-273-0/+21
|
* 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-276-0/+97
|
* MySQL: Increase index prefix length for PEP nodesHolger Weiss2019-02-262-2/+2
| | | | | 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-216-0/+321
|\
| * Update MIX code to reflect newest specificationEvgeny Khramtsov2018-12-056-0/+321
| | | | | | | | | | | | 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-087-7/+7
|/
* Keep info about carbons inside session tableEvgeny Khramtsov2018-12-017-83/+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-262-2/+2
| | | | | 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-162-6/+6
| | | | | Let MySQL/MariaDB accept message stanzas with a size of up to 16 MiB, rather than truncating at 64 KiB.
* Update mssql.sqlrouen-sk2018-07-181-4/+4
| | | | | | Fixed: - conflicting clustered indexes on 2 tables - semicolon type - Azure SQL incompatibility
* Move mod_irc to ejabberd-contribEvgeniy Khramtsov2018-06-207-70/+0
|
* Pubsub creation/modification use varchar (#2397)Christophe Romain2018-04-247-14/+14
|
* Use length on fields in mysql indexesPaweł Chmielowski2018-02-262-6/+6
|
* sql/*: Add username to peer indexesHolger Weiss2018-02-247-22/+21
| | | | | 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-262-0/+882
|
* Add missed server_host column in pg.new.sqlAlexey Shchepin2017-11-301-0/+1
|
* PubSub: Cleanup tree requests, rename pubsub_node.type->pubsub_node.pluginChristophe Romain2017-11-165-5/+5
|
* Add SQL_INSERT macro and update SQL queries to use server_host fieldAlexey Shchepin2017-11-021-0/+604
|
* Fix sql syntax error in lite.sqlPaweł Chmielowski2017-10-311-2/+2
|
* Optimize muc subscriptions handlingChristophe Romain2017-10-314-0/+48
|
* Update SQL archive index to match mysql.sqlAlexey Shchepin2017-10-273-3/+3
|
* Add SQL support for mod_pushEvgeniy Khramtsov2017-10-264-0/+47
|
* mysql.sql: Use multi-column index on username/IDHolger Weiss2017-09-271-1/+1
|