aboutsummaryrefslogtreecommitdiff
path: root/sql (unfollow)
Commit message (Collapse)AuthorFilesLines
2022-03-08Sync old-to-new schema script with reality (#3790)Stu Tomlinson1-0/+18
Update the update_sql function to match current "new" sql schema
2022-02-18Fix sqlite schemaPaweł Chmielowski2-2/+2
2022-02-18Optimize room_unused_* commandsPaweł Chmielowski7-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.
2022-02-11Update copyright year to 2022Badlop7-7/+7
2022-02-03Fix support for MSSQL testingBadlop1-1/+1
2021-12-14Handle user removal in mod_mucAlexey Shchepin7-0/+7
2021-10-14Fix vcard_search definition in pgsql new schema (thanks to Stu Tomlinson)(#3695)Badlop1-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);
2021-09-27Add indexes from 95fa43aa to the old-to-new MySQL schema update scriptBadlop1-0/+2
2021-08-05Fix typo when creating index (thanks to Millesimus)Badlop1-1/+1
Reference: https://github.com/processone/ejabberd/commit/95fa43aa96514b7e8b77fa7c29d2c0b5b1c1331a#r54157330
2021-08-01Add missing SQL migration for table push_sessionpitchum1-0/+6
2021-06-14Add mqtt_pub table definition for MSSQL (#3097)Badlop1-0/+20
2021-05-20MySQL Backend Patch for scram-sha512 (#3582)Nikat2-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
2021-05-18Add missing indexes to sql sr_group tablesPaweł Chmielowski6-0/+15
2021-02-01Fix specified key was too long (#3513)Divine2-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
2021-01-27Update newest copyright year to 2021 (#3464)Badlop7-7/+7
2021-01-07Add sql script to migrate mysql from old schema to newPaweł Chmielowski1-0/+160
2020-01-31Add missing oauth_client table declaration in lite.new.sqlPaweł Chmielowski1-0/+7
2020-01-28Update copyright to 2020 (#3149)Badlop7-7/+7
2019-12-28change publisher from text to varchar for mssqlChristoph Scholz1-1/+1
2019-12-27allow storage of emojis in archive on mssqlChristoph Scholz1-2/+2
2019-10-23Make PostgreSQL schema compatible with CockroachDBEvgeny Khramtsov2-2/+2
2019-10-03Check redirect_uri for OAUTH implicit grantAlexey Shchepin5-6/+20
2019-09-27Support OAUTH client authenticationAlexey Shchepin3-0/+21
2019-07-31Change type of server_host column in mysql.new.sqlPaweł Chmielowski1-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.
2019-02-27Add SQL schemas for MQTT tablesEvgeny Khramtsov6-0/+97
2019-02-26MySQL: Increase index prefix length for PEP nodesHolger Weiss2-2/+2
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)Badlop7-7/+7
2018-12-05Update MIX code to reflect newest specificationEvgeny Khramtsov6-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
2018-12-01Keep info about carbons inside session tableEvgeny Khramtsov7-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
2018-09-26MySQL: Use MEDIUMTEXT for PubSub payloadHolger Weiss2-2/+2
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 Weiss2-6/+6
Let MySQL/MariaDB accept message stanzas with a size of up to 16 MiB, rather than truncating at 64 KiB.
2018-07-18Update mssql.sqlrouen-sk1-4/+4
Fixed: - conflicting clustered indexes on 2 tables - semicolon type - Azure SQL incompatibility
2018-06-20Move mod_irc to ejabberd-contribEvgeniy Khramtsov7-70/+0
2018-04-24Pubsub creation/modification use varchar (#2397)Christophe Romain7-14/+14
2018-02-26Use length on fields in mysql indexesPaweł Chmielowski2-6/+6
2018-02-24sql/*: Add username to peer indexesHolger Weiss7-22/+21
The username is available for all MAM queries in question, and adding it to the indexes can improve the lookup performance significantly.
2018-02-05Fix MySQL error server_host used in key specification without a key lengthphejman1-2/+2
2017-12-26Add new schemas for SQLite and MySQLAlexey Shchepin2-0/+882
2017-11-30Add missed server_host column in pg.new.sqlAlexey Shchepin1-0/+1
2017-11-16PubSub: Cleanup tree requests, rename pubsub_node.type->pubsub_node.pluginChristophe Romain5-5/+5
2017-11-02Add SQL_INSERT macro and update SQL queries to use server_host fieldAlexey Shchepin1-0/+604
2017-10-31Fix sql syntax error in lite.sqlPaweł Chmielowski1-2/+2
2017-10-31Optimize muc subscriptions handlingChristophe Romain4-0/+48
2017-10-27Update SQL archive index to match mysql.sqlAlexey Shchepin3-3/+3
2017-10-26Add SQL support for mod_pushEvgeniy Khramtsov4-0/+47
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 Khramtsov4-28/+0
2017-03-31Add SQL as mod_proxy65 RAM backendEvgeniy Khramtsov3-0/+36
2017-03-30Add SQL as mod_carboncopy RAM backendEvgeniy Khramtsov4-1/+44
2017-03-29Add SQL as mod_muc RAM backendEvgeniy Khramtsov4-0/+87
generated by cgit v1.2.3 (git 2.25.1) at 2024-12-04 19:04:05 +0000