summaryrefslogtreecommitdiff
path: root/SQL/mysql.initial.sql
AgeCommit message (Collapse)Author
2015-03-08Fix storing signatures with big images in MySQL database (#1490306)Aleksander Machniak
2014-04-29Fix too small length of users.preferences column data type on MySQLAleksander Machniak
2013-06-09Fix database cache expunge issues (#1489149) - added 'expires' columnAleksander Machniak
2013-05-25Added shared (cross-user) cacheAleksander Machniak
2013-04-28Add lost files for "db_prefix related changes" commitAleksander Machniak
2013-02-19Fix typo in DB version strings (there should be no .sql suffix)Aleksander Machniak
2013-01-17Bump version number in *.initial.sqlAleksander Machniak
2013-01-09Added new database upgrade script, converted DDL scripts to new formatAleksander Machniak
2012-08-06Removed users.alias column, added option ('user_aliases')Aleksander Machniak
to use email address from identities as username (#1488581)
2012-08-06- Removed redundant cache.cache_id column (#1488528)Aleksander Machniak
2012-01-12- Fix failure on MySQL database upgrade from 0.7 - text column can't have ↵alecpl
default value (#1488300)
2012-01-05- Fix SQL Error when saving a contact with many email addresses (#1488286)alecpl
2011-11-22- Fixed bug where session ID's length was limited to 40 characters. Since ↵alecpl
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-09-18- Cache synchronization using QRESYNC/CONDSTOREalecpl
- Fixed message ID updates in cache - Changed message flags handling + some fixes (e.g. fixed messages listing after delete)
2011-09-07- Rewritten messages caching (merged devel-mcache branch):alecpl
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-06- Fix username case-insensitivity issue in MySQL (#1488021)alecpl
2011-09-06- Merge devel-saved_search branch (Addressbook Saved Searches)alecpl
2011-09-06- Merge devel-spellcheck branch:alecpl
- Added spellchecker exceptions dictionary (shared or per-user) - Added possibility to ignore words containing caps, numbers, symbols (spellcheck_ignore_* options)
2011-04-27Change vcard field to LONGTEXT to completely store vcards with embedded photosthomascube
2011-02-23- Add index on contactgroupmembers.contact_id column.alecpl
Improves performance and fixes problem with contactgroupmembers table creation on MySQL 4.x
2011-02-14Fulltext search over contact fields. Attention: DATABASE SCHEMA CHANGED\!thomascube
2010-11-02- Support contact's email addresses up to 255 characters long (#1487095)alecpl
- Added email format checks when saving contacts data
2010-10-06- Add unique index on users.username+users.mail_hostalecpl
2010-09-25- s/RoundCube/Roundcube/alecpl
2010-04-28- Set DEFAULT NULL for users.last_loginalecpl
2010-04-15Always set changed date when marking a DB record as deleted + provide a ↵thomascube
cleanup script
2010-03-27- fix default datetimealecpl
2010-03-26Added basic contact groups featurethomascube
2010-03-06- re-fix (#1486474) + require MySQL 4.0.8 + add index/update in identities tablealecpl
2010-02-24- Fix adding contacts SQL error on mysql (#1486459)alecpl
2010-02-06- Add workaround for MySQL bug [http://bugs.mysql.com/bug.php?id=46293] ↵alecpl
(#1486474)
2009-09-29- use better index for contacts tablealecpl
2009-09-17- Change MySQL data type to avoid problems with big session varsvbenincasa
2009-09-07- added index in messages tablealecpl
2009-05-14- remove version number from *.initial.sqlalecpl
2009-03-04- Fix datetime columns defaults in mysql's DDL (#1485641)alecpl
2008-11-29Simplify MYSQL database initialization instructionsthomascube
2008-11-29Add conditional comments to mysql initial script (#1485517); remove old ↵thomascube
mysql 4.0 init script
2008-11-25#1485420: remove default (and not null) for users.language column in DDLalecpl
2008-11-24- Added index on cache.created + small fixes in mssql DDL scriptalecpl
2008-11-22- fix r2076: removed cache.session_id column, removed DELETEs from cache in ↵alecpl
session_gc - trust DB server's time when "touching" cache and messages tables
2008-11-21- Increase speed of session destroy and garbage clean upalecpl
- Fix session timeout when DB server got clock skew (#1485490)
2008-06-12#1485125: added index on messages.createdalecpl
2008-06-12- #1485120 (text column can't have a default value)alecpl
2008-05-19-Fixed Mysql DDL for default identities creation (#1485070)alecpl
2008-04-03#1484854alecpl
2008-03-25Optimize database schema; get rid of unnecessary indexesthomascube
2007-10-10Set prefs field in user table to null (#1484386)thomascube
2007-09-19IPv6 Compatabilitythomascube
2007-05-17Updated description files and version infothomascube