84 Commits

Author SHA1 Message Date
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
Interduo
4f887f65ea Don't declare default statement for MySQL columns in initial schema (#8485) 2022-04-10 12:06:58 +02:00
Aleksander Machniak
0c42af132e Fix installation/upgrade on MySQL 5.5 - Index column size too large (#8231) 2021-10-26 10:55:16 +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
72a3fb764b Fix compatibility with MySQL 8 - error on 'system' table use 2018-08-25 18:26:31 +02:00
Aleksander Machniak
656f979831 Fix column type (#6200) 2018-03-01 10:13:08 +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
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
3d4a482fd7 - Fix failure on MySQL database upgrade from 0.7 - text column can't have default value (#1488300) 2012-01-12 07:16:51 +00:00
alecpl
48be8f6428 - Fix SQL Error when saving a contact with many email addresses (#1488286) 2012-01-05 08:45:22 +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
d5ae9772c1 - Fix username case-insensitivity issue in MySQL (#1488021) 2011-09-06 17:18:12 +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
thomascube
09b0e36b3f Change vcard field to LONGTEXT to completely store vcards with embedded photos 2011-04-27 17:10:07 +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
alecpl
1924136b47 - fix default datetime 2010-03-27 07:31:39 +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
951c07b1b1 - Fix adding contacts SQL error on mysql (#1486459) 2010-02-24 19:46:13 +00:00