aboutsummaryrefslogtreecommitdiff
path: root/sql (follow)
Commit message (Collapse)AuthorAgeFilesLines
* 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
|
* Clean up database code related to mod_vcard_xupdateEvgeniy Khramtsov2017-05-174-28/+0
|
* Add SQL as mod_proxy65 RAM backendEvgeniy Khramtsov2017-03-313-0/+36
|
* Add SQL as mod_carboncopy RAM backendEvgeniy Khramtsov2017-03-304-1/+44
|
* Add SQL as mod_muc RAM backendEvgeniy Khramtsov2017-03-294-0/+87
|
* Add SQL as mod_bosh RAM backendEvgeniy Khramtsov2017-03-284-0/+34
|
* Add SQL as router RAM backendEvgeniy Khramtsov2017-03-284-0/+47
|
* Fix pubsub MySQL schemaJerome Sautret2017-02-231-3/+3
|
* Add missing NOT NULL restrictionsChristophe Romain2017-02-224-68/+68
|
* Move archive tables into lite.sql for better comparison with other schemasChristophe Romain2017-02-221-26/+25
|
* Update copyright date automatically (#1442)Badlop2017-01-024-4/+4
|
* Cleanup file headersChristophe Romain2016-12-272-2/+2
|
* Add OAUTH SQL backendAlexey Shchepin2016-08-014-0/+33
|
* Use MEDIUMTEXT type for muc_room.opts in MySQL schemaJuan Pablo Carlino2016-05-021-1/+1
|
* Switch to varchar(64) in mysql user.server/salt as text can't have default ↵Paweł Chmielowski2016-04-081-4/+4
| | | | values
generated by cgit v1.2.3 (git 2.25.1) at 2024-10-01 05:02:36 +0000