Commit message (Collapse) | Author | Age | Files | Lines | |
---|---|---|---|---|---|
* | Sync old-to-new schema script with reality (#3790) | Stu Tomlinson | 2022-03-08 | 1 | -0/+18 |
| | | | Update the update_sql function to match current "new" sql schema | ||||
* | Fix sqlite schema | Paweł Chmielowski | 2022-02-18 | 2 | -2/+2 |
| | |||||
* | Optimize room_unused_* commands | Paweł Chmielowski | 2022-02-18 | 7 | -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 2022 | Badlop | 2022-02-11 | 7 | -7/+7 |
| | |||||
* | Fix support for MSSQL testing | Badlop | 2022-02-03 | 1 | -1/+1 |
| | |||||
* | Handle user removal in mod_muc | Alexey Shchepin | 2021-12-14 | 7 | -0/+7 |
| | |||||
* | Fix vcard_search definition in pgsql new schema (thanks to Stu Tomlinson)(#3695) | Badlop | 2021-10-14 | 1 | -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 script | Badlop | 2021-09-27 | 1 | -0/+2 |
| | |||||
* | Merge pull request #3656 from pitchum/master | badlop | 2021-08-16 | 1 | -0/+6 |
|\ | | | | | Add missing pgsql migration for table push_session | ||||
| * | Add missing SQL migration for table push_session | pitchum | 2021-08-01 | 1 | -0/+6 |
| | | |||||
* | | Fix typo when creating index (thanks to Millesimus) | Badlop | 2021-08-05 | 1 | -1/+1 |
|/ | | | | Reference: https://github.com/processone/ejabberd/commit/95fa43aa96514b7e8b77fa7c29d2c0b5b1c1331a#r54157330 | ||||
* | Add mqtt_pub table definition for MSSQL (#3097) | Badlop | 2021-06-14 | 1 | -0/+20 |
| | |||||
* | MySQL Backend Patch for scram-sha512 (#3582) | Nikat | 2021-05-20 | 2 | -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 tables | Paweł Chmielowski | 2021-05-18 | 6 | -0/+15 |
| | |||||
* | Fix specified key was too long (#3513) | Divine | 2021-02-01 | 2 | -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) | Badlop | 2021-01-27 | 7 | -7/+7 |
| | |||||
* | Add sql script to migrate mysql from old schema to new | Paweł Chmielowski | 2021-01-07 | 1 | -0/+160 |
| | |||||
* | Merge pull request #3132 from area-42/publisher_mssql_text_to_varchar | Jérôme Sautret | 2020-04-10 | 1 | -1/+1 |
|\ | | | | | change PubSub publisher from text to varchar for mssql | ||||
| * | change publisher from text to varchar for mssql | Christoph Scholz | 2019-12-28 | 1 | -1/+1 |
| | | |||||
* | | Merge pull request #3127 from area-42/allow_emojis_with_mssql | Mickaël Rémond | 2020-02-20 | 1 | -2/+2 |
|\ \ | | | | | | | allow storage of emojis in archive on mssql | ||||
| * | | allow storage of emojis in archive on mssql | Christoph Scholz | 2019-12-27 | 1 | -2/+2 |
| |/ | |||||
* | | Add missing oauth_client table declaration in lite.new.sql | Paweł Chmielowski | 2020-01-31 | 1 | -0/+7 |
| | | |||||
* | | Update copyright to 2020 (#3149) | Badlop | 2020-01-28 | 7 | -7/+7 |
|/ | |||||
* | Make PostgreSQL schema compatible with CockroachDB | Evgeny Khramtsov | 2019-10-23 | 2 | -2/+2 |
| | |||||
* | Check redirect_uri for OAUTH implicit grant | Alexey Shchepin | 2019-10-03 | 5 | -6/+20 |
| | |||||
* | Support OAUTH client authentication | Alexey Shchepin | 2019-09-27 | 3 | -0/+21 |
| | |||||
* | Change type of server_host column in mysql.new.sql | Paweł Chmielowski | 2019-07-31 | 1 | -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 tables | Evgeny Khramtsov | 2019-02-27 | 6 | -0/+97 |
| | |||||
* | MySQL: Increase index prefix length for PEP nodes | Holger Weiss | 2019-02-26 | 2 | -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 Khramtsov | 2019-02-21 | 6 | -0/+321 |
|\ | |||||
| * | Update MIX code to reflect newest specification | Evgeny Khramtsov | 2018-12-05 | 6 | -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) | Badlop | 2019-01-08 | 7 | -7/+7 |
|/ | |||||
* | Keep info about carbons inside session table | Evgeny Khramtsov | 2018-12-01 | 7 | -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 payload | Holger Weiss | 2018-09-26 | 2 | -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 messages | Holger Weiss | 2018-09-16 | 2 | -6/+6 |
| | | | | | Let MySQL/MariaDB accept message stanzas with a size of up to 16 MiB, rather than truncating at 64 KiB. | ||||
* | Update mssql.sql | rouen-sk | 2018-07-18 | 1 | -4/+4 |
| | | | | | | Fixed: - conflicting clustered indexes on 2 tables - semicolon type - Azure SQL incompatibility | ||||
* | Move mod_irc to ejabberd-contrib | Evgeniy Khramtsov | 2018-06-20 | 7 | -70/+0 |
| | |||||
* | Pubsub creation/modification use varchar (#2397) | Christophe Romain | 2018-04-24 | 7 | -14/+14 |
| | |||||
* | Use length on fields in mysql indexes | Paweł Chmielowski | 2018-02-26 | 2 | -6/+6 |
| | |||||
* | sql/*: Add username to peer indexes | Holger Weiss | 2018-02-24 | 7 | -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 length | phejman | 2018-02-05 | 1 | -2/+2 |
| | |||||
* | Add new schemas for SQLite and MySQL | Alexey Shchepin | 2017-12-26 | 2 | -0/+882 |
| | |||||
* | Add missed server_host column in pg.new.sql | Alexey Shchepin | 2017-11-30 | 1 | -0/+1 |
| | |||||
* | PubSub: Cleanup tree requests, rename pubsub_node.type->pubsub_node.plugin | Christophe Romain | 2017-11-16 | 5 | -5/+5 |
| | |||||
* | Add SQL_INSERT macro and update SQL queries to use server_host field | Alexey Shchepin | 2017-11-02 | 1 | -0/+604 |
| | |||||
* | Fix sql syntax error in lite.sql | Paweł Chmielowski | 2017-10-31 | 1 | -2/+2 |
| | |||||
* | Optimize muc subscriptions handling | Christophe Romain | 2017-10-31 | 4 | -0/+48 |
| | |||||
* | Update SQL archive index to match mysql.sql | Alexey Shchepin | 2017-10-27 | 3 | -3/+3 |
| | |||||
* | Add SQL support for mod_push | Evgeniy Khramtsov | 2017-10-26 | 4 | -0/+47 |
| | |||||
* | mysql.sql: Use multi-column index on username/ID | Holger Weiss | 2017-09-27 | 1 | -1/+1 |
| |