summaryrefslogtreecommitdiff
path: root/roundcubemail/SQL/sqlite.update.sql
AgeCommit message (Collapse)Author
2011-02-25Create interactive update script with improved DB schema check; udated ↵thomasb
installer with new features and styles git-svn-id: https://svn.roundcube.net/trunk@4573 208e9e7b-5314-0410-a742-e7e81cd9613c
2011-02-23- Add index on contactgroupmembers.contact_id column.alec
Improves performance and fixes problem with contactgroupmembers table creation on MySQL 4.x git-svn-id: https://svn.roundcube.net/trunk@4567 208e9e7b-5314-0410-a742-e7e81cd9613c
2011-02-14Fulltext search over contact fields. Attention: DATABASE SCHEMA CHANGED\!thomasb
git-svn-id: https://svn.roundcube.net/trunk@4541 208e9e7b-5314-0410-a742-e7e81cd9613c
2011-01-26Clear message cache table when upgradingthomasb
git-svn-id: https://svn.roundcube.net/trunk@4459 208e9e7b-5314-0410-a742-e7e81cd9613c
2010-11-02- Support contact's email addresses up to 255 characters long (#1487095)alec
- Added email format checks when saving contacts data git-svn-id: https://svn.roundcube.net/trunk@4166 208e9e7b-5314-0410-a742-e7e81cd9613c
2010-10-06- Add unique index on users.username+users.mail_hostalec
git-svn-id: https://svn.roundcube.net/trunk@4053 208e9e7b-5314-0410-a742-e7e81cd9613c
2010-09-25- s/RoundCube/Roundcube/alec
git-svn-id: https://svn.roundcube.net/trunk@3989 208e9e7b-5314-0410-a742-e7e81cd9613c
2010-08-10- Fix upgrade script for SQLite (#1486903)alec
git-svn-id: https://svn.roundcube.net/trunk@3889 208e9e7b-5314-0410-a742-e7e81cd9613c
2010-04-28- Set DEFAULT NULL for users.last_loginalec
git-svn-id: https://svn.roundcube.net/trunk@3572 208e9e7b-5314-0410-a742-e7e81cd9613c
2010-04-20Replace ALTER TABLE statement in Sqlite schema update script; more precise ↵thomasb
instructions for db updates and about new cleaning script git-svn-id: https://svn.roundcube.net/trunk@3508 208e9e7b-5314-0410-a742-e7e81cd9613c
2010-04-15Always set changed date when marking a DB record as deleted + provide a ↵thomasb
cleanup script git-svn-id: https://svn.roundcube.net/trunk@3489 208e9e7b-5314-0410-a742-e7e81cd9613c
2010-03-26Added basic contact groups featurethomasb
git-svn-id: https://svn.roundcube.net/trunk@3425 208e9e7b-5314-0410-a742-e7e81cd9613c
2010-03-06- re-fix (#1486474) + require MySQL 4.0.8 + add index/update in identities tablealec
git-svn-id: https://svn.roundcube.net/trunk@3333 208e9e7b-5314-0410-a742-e7e81cd9613c
2009-12-17- don't use TRUNCATE on sqlite (#1486374)alec
git-svn-id: https://svn.roundcube.net/trunk@3184 208e9e7b-5314-0410-a742-e7e81cd9613c
2009-12-11- move TRUNCATE before CREATE INDEX (#1486362)alec
git-svn-id: https://svn.roundcube.net/trunk@3174 208e9e7b-5314-0410-a742-e7e81cd9613c
2009-09-29- use better index for contacts tablealec
git-svn-id: https://svn.roundcube.net/trunk@2999 208e9e7b-5314-0410-a742-e7e81cd9613c
2009-09-13- "TRUNCATE messages" is required to remove buggy cache entries alec
git-svn-id: https://svn.roundcube.net/trunk@2952 208e9e7b-5314-0410-a742-e7e81cd9613c
2009-09-07- added index in messages tablealec
git-svn-id: https://svn.roundcube.net/trunk@2931 208e9e7b-5314-0410-a742-e7e81cd9613c
2008-11-24- Added index on cache.created + small fixes in mssql DDL scriptalec
git-svn-id: https://svn.roundcube.net/trunk@2087 208e9e7b-5314-0410-a742-e7e81cd9613c
2008-11-21- Increase speed of session destroy and garbage clean upalec
- Fix session timeout when DB server got clock skew (#1485490) git-svn-id: https://svn.roundcube.net/trunk@2076 208e9e7b-5314-0410-a742-e7e81cd9613c
2008-06-12#1485125: added index on messages.createdalec
git-svn-id: https://svn.roundcube.net/trunk@1522 208e9e7b-5314-0410-a742-e7e81cd9613c
2008-04-03#1484854alec
git-svn-id: https://svn.roundcube.net/trunk@1242 208e9e7b-5314-0410-a742-e7e81cd9613c
2008-03-25Optimize database schema; get rid of unnecessary indexesthomasb
git-svn-id: https://svn.roundcube.net/trunk@1218 208e9e7b-5314-0410-a742-e7e81cd9613c
2006-08-25Finalized new message parsing. Attention: changes in database schemathomasb
git-svn-id: https://svn.roundcube.net/trunk@325 208e9e7b-5314-0410-a742-e7e81cd9613c
generated by cgit v1.2.3 (git 2.51.0) at 2026-05-16 11:12:54 +0000