47d898bb8b
add support for roster pre-approval
...
Implementation of RFC 6121 section 3.4: Pre-Approving a Subscription Request
https://datatracker.ietf.org/doc/html/rfc6121#section-3.4
2026-01-30 10:36:38 +01:00
5f94b5252b
Update copyright year to 2026
2026-01-05 12:22:57 +01:00
7862c6a7db
Add support for storing multiple passwords formats per user
...
This adds option 'auth_stored_password_types' that can be used to setup
storage of multiple passwords for each user. When this is set, on each
password set, database will now store password in each format specified.
2025-03-26 11:03:39 +01:00
8ebbb45a19
Update copyright year to 2025 ( #4139 )
2025-01-03 11:49:37 +01:00
589521bfd8
Update copyright year to 2024 ( #4139 )
2024-01-22 17:29:13 +01:00
97568195d6
Update SQL schema files
2023-12-27 17:01:57 +03:00
d5bf051e79
Fix minor SQL schema inconsistencies
2023-01-19 23:36:42 +00:00
06ffe995e1
Remove unnecessary indexes
...
For columns are already included in a compound index there is no
benefit to having a separate index with a subset of the same columns in
the same order, it just wastes space.
2023-01-19 23:36:42 +00:00
5e94fdcfd5
MS SQL schema fixes
...
* Add missing 'mix' tables and indexes
* Fix text vs varchar issues
Various tests triggered this error:
The data types text and varchar are incompatible in the equal to operator.
Caused by incompatible 'text' columns in muc_online_room,
muc_online_users, pubsub_node_option, and pubsub_node tables.
* Fix definition of mqtt_pub table
This table incorrectly included 'server_host' column in old schema, and
had other inconsistencies.
2023-01-19 23:35:05 +00:00
243697e25a
Update copyright year to 2023 ( #3967 )
2023-01-10 13:52:04 +01:00
f86055378d
Optimize room_unused_* commands
...
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-18 14:02:04 +01:00
b3211b1f71
Update copyright year to 2022
2022-02-11 09:39:25 +01:00
3b30d5b0ed
Fix support for MSSQL testing
2022-02-03 18:21:49 +01:00
8b7da70b57
Handle user removal in mod_muc
2021-12-14 09:55:55 +03:00
c2d8bc7b2f
Add mqtt_pub table definition for MSSQL ( #3097 )
2021-06-14 12:22:21 +02:00
6e0161470e
Update newest copyright year to 2021 ( #3464 )
2021-01-27 17:02:06 +01:00
b02506eaaf
Merge pull request #3132 from area-42/publisher_mssql_text_to_varchar
...
change PubSub publisher from text to varchar for mssql
2020-04-10 16:20:43 +02:00
3947e64524
Merge pull request #3127 from area-42/allow_emojis_with_mssql
...
allow storage of emojis in archive on mssql
2020-02-20 16:28:24 +01:00
2d32c66fd7
Update copyright to 2020 ( #3149 )
2020-01-28 15:49:23 +01:00
248cc2d013
change publisher from text to varchar for mssql
2019-12-28 15:49:37 +01:00
00ccb119ea
allow storage of emojis in archive on mssql
2019-12-27 13:06:06 +01:00
f0cf63de15
Manually update 2017 copyright dates ( #2756 )
2019-01-08 22:52:26 +01:00
109ed8f2f6
Keep info about carbons inside session table
...
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-12-01 13:33:44 +03:00
b199b68380
Update mssql.sql
...
Fixed:
- conflicting clustered indexes on 2 tables
- semicolon type
- Azure SQL incompatibility
2018-07-18 17:12:17 +02:00
3a5d2dbed8
Move mod_irc to ejabberd-contrib
2018-06-20 12:27:44 +03:00
61dee97738
Pubsub creation/modification use varchar ( #2397 )
2018-04-24 14:44:52 +02:00
f7566bd00e
sql/*: Add username to peer indexes
...
The username is available for all MAM queries in question, and adding it
to the indexes can improve the lookup performance significantly.
2018-02-24 00:50:20 +01:00
44700d91ba
PubSub: Cleanup tree requests, rename pubsub_node.type->pubsub_node.plugin
2017-11-16 11:38:04 +01:00
0452ffc1df
Optimize muc subscriptions handling
2017-10-31 14:00:41 +01:00
e1c8e88d87
Update SQL archive index to match mysql.sql
2017-10-27 15:20:29 +03:00
db57394399
Add SQL support for mod_push
2017-10-26 20:11:43 +03:00
6691c59a7a
Clean up database code related to mod_vcard_xupdate
2017-05-17 19:29:19 +03:00
31fd83b2ae
Add SQL as mod_carboncopy RAM backend
2017-03-30 10:31:51 +03:00
12e01a5119
Add SQL as mod_muc RAM backend
2017-03-29 12:58:01 +03:00
e5815553cb
Add SQL as mod_bosh RAM backend
2017-03-28 20:33:57 +03:00
117f31125d
Add SQL as router RAM backend
2017-03-28 16:31:37 +03:00
56df6e7ba8
Add missing NOT NULL restrictions
2017-02-22 15:47:36 +01:00
5fdd1c39fe
Update copyright date automatically ( #1442 )
2017-01-02 21:42:06 +01:00
ed679279fd
Cleanup file headers
2016-12-27 10:57:50 +01:00
4add262090
Add OAUTH SQL backend
2016-08-01 16:55:43 +03:00
c5dbdfc71a
'serverkey' and 'salt' should have empty string as default
2016-04-08 13:02:08 +03:00
e386bf6b58
In SQL files create Users table with SCRAM support by default ( #956 )
2016-03-29 12:37:49 +02:00
b0ef3e66a8
Update MSSQL schema
2016-03-29 11:53:13 +03:00
ab857b1a5e
Improve MSSQL schema
2015-09-14 14:05:07 +03:00
25791cfde8
Fix MSSQL support
2015-09-13 18:31:49 +03:00
Stefan Strigler