source: github/SQL/sqlite.update.sql

Revision Log Mode:


Legend:

Added
Modified
Copied or renamed
Diff Rev Age Author Log Message
(edit) @3ad2b1b   18 months alec - Applied fixes from trunk up to r5479 release-0.7
(edit) @502436d   20 months thomas We're on the road towards 0.7 now HEADcourier-fixdev-browser-capabilitiespdorelease-0.7release-0.8
(edit) @7b2bf71   20 months alec - Add lost cache_index.valid column definition HEADcourier-fixdev-browser-capabilitiespdorelease-0.7release-0.8
(edit) @609d392   20 months alec - Cache synchronization using QRESYNC/CONDSTORE - Fixed message ID updates … HEADcourier-fixdev-browser-capabilitiespdorelease-0.7release-0.8
(edit) @80152b33   21 months alec - Rewritten messages caching (merged devel-mcache branch): Indexes are … HEADcourier-fixdev-browser-capabilitiespdorelease-0.7release-0.8
(edit) @f8e48df   21 months alec - Merge devel-saved_search branch (Addressbook Saved Searches) HEADcourier-fixdev-browser-capabilitiespdorelease-0.7release-0.8
(edit) @66df084   21 months alec - Merge devel-spellcheck branch: - Added spellchecker exceptions … HEADcourier-fixdev-browser-capabilitiespdorelease-0.7release-0.8
(edit) @faf10e8   22 months thomas Fix automatic db updates; trigger contact indexing after upgrade HEADcourier-fixdev-browser-capabilitiespdorelease-0.6release-0.7release-0.8
(edit) @83b20a3   22 months alec - Change version number 0.5.2 -> 0.5.X to not confuse users HEADcourier-fixdev-browser-capabilitiespdorelease-0.6release-0.7release-0.8
(edit) @d08333e   2 years alec - Fix problems with subfolders of INBOX folder on some IMAP servers … HEADcourier-fixdev-browser-capabilitiespdorelease-0.6release-0.7release-0.8
(edit) @e6bb836   2 years thomas Create interactive update script with improved DB schema check; udated … HEADcourier-fixdev-browser-capabilitiespdorelease-0.6release-0.7release-0.8
(edit) @3a5476d1   2 years alec - Add index on contactgroupmembers.contact_id column. Improves … HEADcourier-fixdev-browser-capabilitiespdorelease-0.6release-0.7release-0.8
(edit) @3e26373   2 years thomas Fulltext search over contact fields. Attention: DATABASE SCHEMA CHANGED\! HEADcourier-fixdev-browser-capabilitiespdorelease-0.6release-0.7release-0.8
(edit) @cdb8b96   2 years thomas Clear message cache table when upgrading HEADcourier-fixdev-browser-capabilitiespdorelease-0.6release-0.7release-0.8
(edit) @6f09681   3 years alec - Support contact's email addresses up to 255 characters long (#1487095) - … HEADcourier-fixdev-browser-capabilitiespdorelease-0.6release-0.7release-0.8
(edit) @ace511a   3 years alec - Add unique index on users.username+users.mail_host HEADcourier-fixdev-browser-capabilitiespdorelease-0.6release-0.7release-0.8
(edit) @e019f2d   3 years alec - s/RoundCube/Roundcube/ HEADcourier-fixdev-browser-capabilitiespdorelease-0.6release-0.7release-0.8
(edit) @5807133   3 years alec - Fix upgrade script for SQLite (#1486903) HEADcourier-fixdev-browser-capabilitiespdorelease-0.6release-0.7release-0.8
(edit) @e2402ef9   3 years alec - Set DEFAULT NULL for users.last_login HEADcourier-fixdev-browser-capabilitiespdorelease-0.6release-0.7release-0.8
(edit) @2336223   3 years thomas Replace ALTER TABLE statement in Sqlite schema update script; more precise … HEADcourier-fixdev-browser-capabilitiespdorelease-0.6release-0.7release-0.8
(edit) @a35062a1   3 years thomas Always set changed date when marking a DB record as deleted + provide a … HEADcourier-fixdev-browser-capabilitiespdorelease-0.6release-0.7release-0.8
(edit) @a61bbb2   3 years thomas Added basic contact groups feature HEADcourier-fixdev-browser-capabilitiespdorelease-0.6release-0.7release-0.8
(edit) @94fe9ca   3 years alec - re-fix (#1486474) + require MySQL 4.0.8 + add index/update in identities … HEADcourier-fixdev-browser-capabilitiespdorelease-0.6release-0.7release-0.8
(edit) @9273c83   3 years alec - don't use TRUNCATE on sqlite (#1486374) HEADcourier-fixdev-browser-capabilitiespdorelease-0.6release-0.7release-0.8
(edit) @f47e2dc   3 years alec - move TRUNCATE before CREATE INDEX (#1486362) HEADcourier-fixdev-browser-capabilitiespdorelease-0.6release-0.7release-0.8
(edit) @23b7656   4 years alec - use better index for contacts table HEADcourier-fixdev-browser-capabilitiespdorelease-0.6release-0.7release-0.8
(edit) @7fec6b2   4 years alec - "TRUNCATE messages" is required to remove buggy cache entries HEADcourier-fixdev-browser-capabilitiespdorelease-0.6release-0.7release-0.8
(edit) @3d601d2   4 years alec - added index in messages table HEADcourier-fixdev-browser-capabilitiespdorelease-0.6release-0.7release-0.8
(edit) @e4d9f05   4 years alec - Added index on cache.created + small fixes in mssql DDL script HEADcourier-fixdev-browser-capabilitiespdorelease-0.6release-0.7release-0.8
(edit) @3e48d2ee   5 years alec - Increase speed of session destroy and garbage clean up - Fix session … HEADcourier-fixdev-browser-capabilitiespdorelease-0.6release-0.7release-0.8
(edit) @c98f3b5   5 years alec #1485125: added index on messages.created HEADcourier-fixdev-browser-capabilitiespdorelease-0.6release-0.7release-0.8
(edit) @6cb7786   5 years alec #1484854 HEADcourier-fixdev-browser-capabilitiespdorelease-0.6release-0.7release-0.8
(edit) @ac26b96   5 years thomas Optimize database schema; get rid of unnecessary indexes HEADcourier-fixdev-browser-capabilitiespdorelease-0.6release-0.7release-0.8
(add) @f7bfec9   7 years thomas Finalized new message parsing. Attention: changes in database schema HEADcourier-fixdev-browser-capabilitiespdorelease-0.6release-0.7release-0.8
Note: See TracRevisionLog for help on using the revision log.