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
Michael Voříšek
28c778b7a0
Modernize more CS III ( #9270 )
...
* fix "single_trait_insert_per_statement"
* fix "empty_loop_condition"
* fix "backtick_to_shell_exec"
* fix "phpdoc_to_comment"
* fix "no_empty_statement"
* fix "heredoc_to_nowdoc"
* fix "class_reference_name_casing"
* fix "align_multiline_comment"
* fix "heredoc_indentation"
* fix "constant_case"
* fix "single_line_comment_style"
* fix "no_null_property_initialization"
* fix "standardize_increment"
* fix "no_unneeded_control_parentheses"
* fix missing NL after "<?php"
* fix php in *.sh files too
* fix trailing spaces from all text files
* fix "explicit_indirect_variable"
* Revert "fix "align_multiline_comment""
This reverts commit 42e584f8e3 .
* fix "align_multiline_comment" properly
* Revert "fix trailing spaces from all text files" - diff files only
* Revert "Revert "fix trailing spaces from all text files" - diff files only"
This reverts commit 2101c2a3a3 .
* rm useless "setup-php" config
2023-12-18 07:46:51 +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
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
8483de8bdf
Fix typo
2013-07-08 08:21:20 +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
Aleksander Machniak
9e46fb535d
Fix typo in DB version strings (there should be no .sql suffix)
2013-02-19 14:27:26 +01:00
Aleksander Machniak
aa691c40ed
Bump version number in *.initial.sql
2013-01-17 18:08:24 +01:00
Aleksander Machniak
b7e7c8f950
Added new database upgrade script, converted DDL scripts to new format
2013-01-09 15:57:29 +01:00
Aleksander Machniak
565c472918
Removed users.alias column, added option ('user_aliases')
...
to use email address from identities as username (#1488581 )
2012-08-06 11:08:58 +02:00
Aleksander Machniak
83121ece33
- Removed redundant cache.cache_id column ( #1488528 )
2012-08-06 10:32:37 +02:00
alecpl
48be8f6428
- Fix SQL Error when saving a contact with many email addresses ( #1488286 )
2012-01-05 08:45:22 +00:00
alecpl
bd9190a660
- Fix broken CREATE INDEX queries in SQLite DDL files ( #1488255 )
2011-12-14 18:25:44 +00:00
alecpl
b8ae0ecb22
- Fixed bug where session ID's length was limited to 40 characters. Since PHP5.3 it's possible
...
to set session.hash_function to any hash algorithm that would produce strings
up to 128 characters long (#1488196 )
2011-11-22 08:36:29 +00:00
alecpl
609d3923d7
- Cache synchronization using QRESYNC/CONDSTORE
...
- Fixed message ID updates in cache
- Changed message flags handling + some fixes (e.g. fixed messages listing after delete)
2011-09-18 09:02:35 +00:00
alecpl
80152b333c
- Rewritten messages caching (merged devel-mcache branch):
...
Indexes are stored in a separate table, so there's no need to store all messages in a folder
Added threads data caching
Flags are stored separately, so flag change doesn't cause DELETE+INSERT, just UPDATE
- Partial QRESYNC support
- Improved FETCH response handling
- Improvements in response tokenization method
2011-09-07 11:07:03 +00:00
alecpl
f8e48df715
- Merge devel-saved_search branch (Addressbook Saved Searches)
2011-09-06 16:35:14 +00:00
alecpl
66df084203
- Merge devel-spellcheck branch:
...
- Added spellchecker exceptions dictionary (shared or per-user)
- Added possibility to ignore words containing caps, numbers, symbols (spellcheck_ignore_* options)
2011-09-06 13:39:45 +00:00
alecpl
3a5476d150
- Add index on contactgroupmembers.contact_id column.
...
Improves performance and fixes problem with contactgroupmembers table creation on MySQL 4.x
2011-02-23 08:13:02 +00:00
thomascube
3e2637351d
Fulltext search over contact fields. Attention: DATABASE SCHEMA CHANGED\!
2011-02-14 20:46:48 +00:00
alecpl
6f096812c9
- Support contact's email addresses up to 255 characters long ( #1487095 )
...
- Added email format checks when saving contacts data
2010-11-02 09:27:03 +00:00
alecpl
ace511a771
- Add unique index on users.username+users.mail_host
2010-10-06 13:00:12 +00:00
alecpl
e019f2d0f2
- s/RoundCube/Roundcube/
2010-09-25 13:03:53 +00:00
alecpl
e2402ef99a
- Set DEFAULT NULL for users.last_login
2010-04-28 10:34:33 +00:00
thomascube
a35062a1eb
Always set changed date when marking a DB record as deleted + provide a cleanup script
2010-04-15 06:33:30 +00:00
thomascube
a61bbb24aa
Added basic contact groups feature
2010-03-26 16:38:20 +00:00
alecpl
94fe9ca1a8
- re-fix ( #1486474 ) + require MySQL 4.0.8 + add index/update in identities table
2010-03-06 14:13:25 +00:00
alecpl
23b76563dc
- use better index for contacts table
2009-09-29 07:59:25 +00:00
alecpl
3d601d267d
- added index in messages table
2009-09-07 12:40:05 +00:00
alecpl
798ad5ea8e
- remove version number from *.initial.sql
2009-05-14 08:28:11 +00:00
alecpl
debdda0117
#1485420 : remove default (and not null) for users.language column in DDL
2008-11-25 10:17:57 +00:00
alecpl
e4d9f05e41
- Added index on cache.created + small fixes in mssql DDL script
2008-11-24 07:59:10 +00:00
alecpl
dcf780a6bd
- fix r2076: removed cache.session_id column, removed DELETEs from cache in session_gc
...
- trust DB server's time when "touching" cache and messages tables
2008-11-22 18:06:13 +00:00