summaryrefslogtreecommitdiff
path: root/roundcubemail/SQL/mssql.initial.sql
AgeCommit message (Collapse)Author
2011-09-07- Rewritten messages caching (merged devel-mcache branch):alec
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 git-svn-id: https://svn.roundcube.net/trunk@5190 208e9e7b-5314-0410-a742-e7e81cd9613c
2011-09-06- Merge devel-saved_search branch (Addressbook Saved Searches)alec
git-svn-id: https://svn.roundcube.net/trunk@5182 208e9e7b-5314-0410-a742-e7e81cd9613c
2011-09-06- Merge devel-spellcheck branch:alec
- Added spellchecker exceptions dictionary (shared or per-user) - Added possibility to ignore words containing caps, numbers, symbols (spellcheck_ignore_* options) git-svn-id: https://svn.roundcube.net/trunk@5181 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
2010-11-15- Fix error in MSSQL DDL scripts (#1487112): use trigger instead of foreign ↵alec
key constraint git-svn-id: https://svn.roundcube.net/trunk@4226 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-08-11- Fixes in SQL init script + added update script for MSSQL databasealec
git-svn-id: https://svn.roundcube.net/trunk@3891 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-23- added foreign keys in mssql DDLalec
git-svn-id: https://svn.roundcube.net/trunk@3542 208e9e7b-5314-0410-a742-e7e81cd9613c
2010-04-23Updated mssql schema (I have no clue if this is correct)thomasb
git-svn-id: https://svn.roundcube.net/trunk@3540 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
2009-08-03- Fix MS SQL DDL (#1486020)alec
git-svn-id: https://svn.roundcube.net/trunk@2829 208e9e7b-5314-0410-a742-e7e81cd9613c
2008-12-03- added lost column in mssql DDLalec
git-svn-id: https://svn.roundcube.net/trunk@2111 208e9e7b-5314-0410-a742-e7e81cd9613c
2008-11-25#1485420: remove default (and not null) for users.language column in DDLalec
git-svn-id: https://svn.roundcube.net/trunk@2090 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-22- fix r2076: removed cache.session_id column, removed DELETEs from cache in ↵alec
session_gc - trust DB server's time when "touching" cache and messages tables git-svn-id: https://svn.roundcube.net/trunk@2077 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
2007-09-19IPv6 Compatabilitythomasb
git-svn-id: https://svn.roundcube.net/trunk@803 208e9e7b-5314-0410-a742-e7e81cd9613c
2007-05-24upgrade to TinyMCE v2.1.1.1estadtherr
git-svn-id: https://svn.roundcube.net/trunk@584 208e9e7b-5314-0410-a742-e7e81cd9613c
2006-08-30Added MSSQL supportthomasb
git-svn-id: https://svn.roundcube.net/trunk@328 208e9e7b-5314-0410-a742-e7e81cd9613c
generated by cgit v1.2.3 (git 2.51.0) at 2026-05-16 17:33:43 +0000