summaryrefslogtreecommitdiff
path: root/roundcubemail/SQL
AgeCommit message (Collapse)Author
2012-02-07- Fix parse errors in DDL files for MS SQL Serveralec
git-svn-id: https://svn.roundcube.net/trunk@5856 208e9e7b-5314-0410-a742-e7e81cd9613c
2012-01-12- Fix failure on MySQL database upgrade from 0.7 - text column can't have ↵alec
default value (#1488300) git-svn-id: https://svn.roundcube.net/trunk@5755 208e9e7b-5314-0410-a742-e7e81cd9613c
2012-01-11- Disable FOREIGN_KEY_CHECKS for update from 0.7alec
git-svn-id: https://svn.roundcube.net/trunk@5753 208e9e7b-5314-0410-a742-e7e81cd9613c
2012-01-05- Fix SQL Error when saving a contact with many email addresses (#1488286)alec
git-svn-id: https://svn.roundcube.net/trunk@5711 208e9e7b-5314-0410-a742-e7e81cd9613c
2011-12-19- Fix wrong postgres sequence name in upgrade from 0.6alec
git-svn-id: https://svn.roundcube.net/trunk@5627 208e9e7b-5314-0410-a742-e7e81cd9613c
2011-12-15- Disable FOREIGN_KEY_CHECKS in update from 0.6 (#1488209)alec
git-svn-id: https://svn.roundcube.net/trunk@5618 208e9e7b-5314-0410-a742-e7e81cd9613c
2011-12-14- Fix broken CREATE INDEX queries in SQLite DDL files (#1488255)alec
git-svn-id: https://svn.roundcube.net/trunk@5615 208e9e7b-5314-0410-a742-e7e81cd9613c
2011-11-23- Add version markersalec
git-svn-id: https://svn.roundcube.net/trunk@5468 208e9e7b-5314-0410-a742-e7e81cd9613c
2011-11-22- Fixed bug where session ID's length was limited to 40 characters. Since ↵alec
PHP5.3 it's possible to set session.hash_function to any hash algorithm that would produce strings up to 128 characters long (#1488196) git-svn-id: https://svn.roundcube.net/trunk@5460 208e9e7b-5314-0410-a742-e7e81cd9613c
2011-09-29We're on the road towards 0.7 nowthomasb
git-svn-id: https://svn.roundcube.net/trunk@5294 208e9e7b-5314-0410-a742-e7e81cd9613c
2011-09-19- Add lost cache_index.valid column definitionalec
git-svn-id: https://svn.roundcube.net/trunk@5234 208e9e7b-5314-0410-a742-e7e81cd9613c
2011-09-18- Cache synchronization using QRESYNC/CONDSTOREalec
- Fixed message ID updates in cache - Changed message flags handling + some fixes (e.g. fixed messages listing after delete) git-svn-id: https://svn.roundcube.net/trunk@5233 208e9e7b-5314-0410-a742-e7e81cd9613c
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- Fix username case-insensitivity issue in MySQL (#1488021)alec
git-svn-id: https://svn.roundcube.net/trunk@5183 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-08-14Fix automatic db updates; trigger contact indexing after upgradethomasb
git-svn-id: https://svn.roundcube.net/trunk@5069 208e9e7b-5314-0410-a742-e7e81cd9613c
2011-08-11- Change version number 0.5.2 -> 0.5.X to not confuse usersalec
git-svn-id: https://svn.roundcube.net/trunk@5045 208e9e7b-5314-0410-a742-e7e81cd9613c
2011-05-05- Fix problems with subfolders of INBOX folder on some IMAP servers ↵alec
(#1487725) - Fix handling of folders that doesn't belong to any namespace (#1487637) git-svn-id: https://svn.roundcube.net/trunk@4733 208e9e7b-5314-0410-a742-e7e81cd9613c
2011-04-27Change vcard field to LONGTEXT to completely store vcards with embedded photosthomasb
git-svn-id: https://svn.roundcube.net/trunk@4709 208e9e7b-5314-0410-a742-e7e81cd9613c
2011-03-10- Force names of unique constraints in PostgreSQL DDL (postgres 9.x uses ↵alec
different naming convention than older versions) git-svn-id: https://svn.roundcube.net/trunk@4603 208e9e7b-5314-0410-a742-e7e81cd9613c
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-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-09-25- s/RoundCube/Roundcube/alec
git-svn-id: https://svn.roundcube.net/trunk@3989 208e9e7b-5314-0410-a742-e7e81cd9613c
2010-09-14- Added warning about tables engine, per discussion in #1486794alec
git-svn-id: https://svn.roundcube.net/trunk@3961 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-08-10- Fix upgrade script for SQLite (#1486903)alec
git-svn-id: https://svn.roundcube.net/trunk@3889 208e9e7b-5314-0410-a742-e7e81cd9613c
2010-06-15- Added ALTER TABLE .. ENGINE=InnoDB, per discussion in #1486794alec
git-svn-id: https://svn.roundcube.net/trunk@3753 208e9e7b-5314-0410-a742-e7e81cd9613c
2010-06-14- fix foreign keys defs unintentionally broken in r3333alec
git-svn-id: https://svn.roundcube.net/trunk@3751 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-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-15- Fix: postgres doens't support AFTER clausealec
git-svn-id: https://svn.roundcube.net/trunk@3491 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-27- contactgroups DDL for postgresalec
git-svn-id: https://svn.roundcube.net/trunk@3431 208e9e7b-5314-0410-a742-e7e81cd9613c
2010-03-27- fix default datetimealec
git-svn-id: https://svn.roundcube.net/trunk@3430 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-09- fix add indexalec
git-svn-id: https://svn.roundcube.net/trunk@3341 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
2010-02-24- Fix adding contacts SQL error on mysql (#1486459)alec
git-svn-id: https://svn.roundcube.net/trunk@3288 208e9e7b-5314-0410-a742-e7e81cd9613c
2010-02-06- typoalec
git-svn-id: https://svn.roundcube.net/trunk@3256 208e9e7b-5314-0410-a742-e7e81cd9613c
2010-02-06- Add workaround for MySQL bug [http://bugs.mysql.com/bug.php?id=46293] ↵alec
(#1486474) git-svn-id: https://svn.roundcube.net/trunk@3255 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
generated by cgit v1.2.3 (git 2.51.0) at 2026-05-16 00:47:29 +0000