Pablo Zmdl
f32fb5e3d2
Fix renaming SQL index in sqlite migration
2025-12-10 15:13:40 +01:00
Pablo Zmdl
42a5289958
Fix table name in SQL migration
2025-12-10 15:13:40 +01:00
Pablo Zmdl
202daa6f97
Replace changed by expires_at in session handling
...
This prepares using extended session lifetimes configurable per session
2025-12-04 14:47:16 +01:00
Aleksander Machniak
80404a8674
Store uploads metadata in a separate sql database table instead of a session ( #8415 )
2022-10-09 11:35:14 +02:00
Aleksander Machniak
c56d7342fe
Fix bug where it wasn't possible to create more than one response record on SQLite and Postgres ( #8664 )
2022-08-12 19:45:40 +02:00
Aleksander Machniak
48fbf110af
SQLite: Use foreign keys, require SQLite >= 3.6.19 ( #8159 )
2021-10-03 12:10:14 +02:00
Aleksander Machniak
cb37d14c5c
Support responses (snippets) in HTML format ( #5315 )
2021-08-28 19:17:19 +02:00
Aleksander Machniak
6cddb27456
Allow NULL in users.preferences column in postgres and sqlite db, the same as for other engines ( #7767 )
2020-12-29 16:21:14 +01:00
Aleksander Machniak
9713ce364c
Automatically collected recipients and trusted senders ( #6904 )
...
Added configurable Collected Recipients addressbook source (#4971 )
Added configurable Trusted Senders addressbook source (#5046 )
Added 'contact_exists' hook
2020-09-20 10:00:08 +02:00
Aleksander Machniak
9d9901ee51
Fix sqlite/2020020100.sql ( #7516 )
2020-07-29 07:43:59 +02:00
Aleksander Machniak
b606d81cdf
MySQL: Use utf8mb4 charset and utf8mb4_unicode_ci collation ( #6535 , #7113 )
...
Fixes support for utf8 emoji in html signature.
2020-02-01 17:19:04 +01:00
Aleksander Machniak
50d6ea30e0
Support for language codes up to 16 chars long (e.g. es-419) in database schema ( #6851 )
2020-02-01 09:40:11 +01:00
Aleksander Machniak
3841f63fbd
Make cache keys case-sensitive on MySQL/MSSQL ( #6942 )
2019-09-29 13:18:46 +02:00
Aleksander Machniak
0e640e95c9
Enigma: Fixed multi-host syncronization of private and deleted keys and pubring.kbx file
...
Added context column to filestore table for easier listing of stored files.
2018-12-23 13:51:39 +01:00
Aleksander Machniak
7b1f0f020b
Enigma: Multi-host support
2018-02-28 09:36:25 +01:00
Aleksander Machniak
a1f679adca
Fixed redundancy in sql caching system and compatibility with Galera Cluster ( #5439 )
...
- Removed redundant 'created' column from cache and cache_shared tables
- Removed use of redundant data records
- Added missing primary keys (dictionary, cache, cache_shared tables)
2016-11-26 09:14:16 +01:00
Aleksander Machniak
32ffc4e637
Bump database version
2016-10-12 09:07:01 +02:00
Aleksander Machniak
0836b213db
Removed useless 'created' column from 'session' table ( #5389 )
2016-08-12 13:02:39 +02:00
Aleksander Machniak
a15d877ba8
Added brute-force attack prevention via login rate limit ( #1490566 )
2015-11-11 18:53:43 +01:00
Aleksander Machniak
f06f4b8424
Fix storing signatures with big images in MySQL database ( #1490306 )
2015-03-08 12:49:36 +01:00
Aleksander Machniak
b6f7304d69
Fix too small length of users.preferences column data type on MySQL
2014-04-29 12:12:26 +02:00
Aleksander Machniak
60b6d7c389
Fix database cache expunge issues ( #1489149 ) - added 'expires' column
2013-06-09 11:07:46 +02:00
Aleksander Machniak
50abd55718
Added shared (cross-user) cache
2013-05-25 15:37:46 +02:00
Aleksander Machniak
311e82652a
Add lost files for "db_prefix related changes" commit
2013-04-28 14:30:34 +02:00
Thomas Bruederli
bcfdac6660
Add 'if not exists' to system table creation. Just in case some previous db update routine was aborted or failed
2013-03-28 17:42:09 +01:00
Aleksander Machniak
474d9d49df
Drop tmp_users table ( #1488910 )
2013-01-17 08:49:18 +01:00
Aleksander Machniak
b7e7c8f950
Added new database upgrade script, converted DDL scripts to new format
2013-01-09 15:57:29 +01:00