summaryrefslogtreecommitdiff
path: root/SQL/postgres.update.sql
AgeCommit message (Collapse)Author
2011-09-19- Add lost cache_index.valid column definitionalecpl
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- 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-08-14Fix automatic db updates; trigger contact indexing after upgradethomascube
2011-08-11- Change version number 0.5.2 -> 0.5.X to not confuse usersalecpl
2011-05-05- Fix problems with subfolders of INBOX folder on some IMAP servers ↵alecpl
(#1487725) - Fix handling of folders that doesn't belong to any namespace (#1487637)
2011-03-10- Force names of unique constraints in PostgreSQL DDL (postgres 9.x uses ↵alecpl
different naming convention than older versions)
2011-02-25Create interactive update script with improved DB schema check; udated ↵thomascube
installer with new features and styles
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
2011-01-26Clear message cache table when upgradingthomascube
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-15- Fix: postgres doens't support AFTER clausealecpl
2010-04-15Always set changed date when marking a DB record as deleted + provide a ↵thomascube
cleanup script
2010-03-27- contactgroups DDL for postgresalecpl
2010-03-06- re-fix (#1486474) + require MySQL 4.0.8 + add index/update in identities tablealecpl
2009-12-11- move TRUNCATE before CREATE INDEX (#1486362)alecpl
2009-09-29- use better index for contacts tablealecpl
2009-09-13- "TRUNCATE messages" is required to remove buggy cache entries alecpl
2009-09-07- added index in messages tablealecpl
2008-12-03- change few "boolean" columns type from integer to smallintalecpl
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-11-21- Fix 'cache' table cleanup on session destroy (#1485516)alecpl
2008-06-12#1485125: added index on messages.createdalecpl
2008-04-03#1484854alecpl
2008-03-25Optimize database schema; get rid of unnecessary indexesthomascube
2007-11-25Fix Postgresql upgrade script (#1484668)thomascube
2007-03-18Use user_id for unique key in messages table (closes #1484074)thomascube
2006-09-14Initial TinyMCE editor support (still need to work on spellcheck and skins)svncommit
2006-08-25Finalized new message parsing. Attention: changes in database schemathomascube