Commit Graph

111 Commits

Author SHA1 Message Date
Aleksander Machniak
64584be909 Fix DDL update from 0.7 for MS SQL Server 2012-06-10 10:15:07 +02:00
Aleksander Machniak
16114e620d Fix operator incompat. in some queries on contacts table using MS SQL Server (#1488505) 2012-06-08 13:24:12 +02:00
alecpl
ccce87d7ce - Fix parse errors in DDL files for MS SQL Server 2012-02-07 07:41:31 +00:00
alecpl
3d4a482fd7 - Fix failure on MySQL database upgrade from 0.7 - text column can't have default value (#1488300) 2012-01-12 07:16:51 +00:00
alecpl
323f15b289 - Disable FOREIGN_KEY_CHECKS for update from 0.7 2012-01-11 09:44:19 +00:00
alecpl
48be8f6428 - Fix SQL Error when saving a contact with many email addresses (#1488286) 2012-01-05 08:45:22 +00:00
alecpl
5f481d1f0c - Fix wrong postgres sequence name in upgrade from 0.6 2011-12-19 07:27:27 +00:00
alecpl
d2d94ac6df - Disable FOREIGN_KEY_CHECKS in update from 0.6 (#1488209) 2011-12-15 07:13:44 +00:00
alecpl
bd9190a660 - Fix broken CREATE INDEX queries in SQLite DDL files (#1488255) 2011-12-14 18:25:44 +00:00
alecpl
f45074341c - Add version markers 2011-11-23 10:02:46 +00:00
alecpl
b8ae0ecb22 - Fixed bug where session ID's length was limited to 40 characters. Since PHP5.3 it's possible
to set session.hash_function to any hash algorithm that would produce strings
  up to 128 characters long (#1488196)
2011-11-22 08:36:29 +00:00
thomascube
502436dad0 We're on the road towards 0.7 now 2011-09-29 07:00:34 +00:00
alecpl
7b2bf71c33 - Add lost cache_index.valid column definition 2011-09-19 06:15:58 +00:00
alecpl
609d3923d7 - Cache synchronization using QRESYNC/CONDSTORE
- Fixed message ID updates in cache
- Changed message flags handling + some fixes (e.g. fixed messages listing after delete)
2011-09-18 09:02:35 +00:00
alecpl
80152b333c - Rewritten messages caching (merged devel-mcache branch):
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-07 11:07:03 +00:00
alecpl
d5ae9772c1 - Fix username case-insensitivity issue in MySQL (#1488021) 2011-09-06 17:18:12 +00:00
alecpl
f8e48df715 - Merge devel-saved_search branch (Addressbook Saved Searches) 2011-09-06 16:35:14 +00:00
alecpl
66df084203 - Merge devel-spellcheck branch:
- Added spellchecker exceptions dictionary (shared or per-user)
  - Added possibility to ignore words containing caps, numbers, symbols (spellcheck_ignore_* options)
2011-09-06 13:39:45 +00:00
thomascube
faf10e8fec Fix automatic db updates; trigger contact indexing after upgrade 2011-08-14 19:02:33 +00:00
alecpl
83b20a3b49 - Change version number 0.5.2 -> 0.5.X to not confuse users 2011-08-11 07:17:28 +00:00
alecpl
d08333ea57 - Fix problems with subfolders of INBOX folder on some IMAP servers (#1487725)
- Fix handling of folders that doesn't belong to any namespace (#1487637)
2011-05-05 12:46:54 +00:00
thomascube
09b0e36b3f Change vcard field to LONGTEXT to completely store vcards with embedded photos 2011-04-27 17:10:07 +00:00
alecpl
8381ec1254 - Force names of unique constraints in PostgreSQL DDL (postgres 9.x uses different naming convention than older versions) 2011-03-10 12:30:42 +00:00
thomascube
e6bb836e05 Create interactive update script with improved DB schema check; udated installer with new features and styles 2011-02-25 16:37:22 +00:00
alecpl
3a5476d150 - Add index on contactgroupmembers.contact_id column.
Improves performance and fixes problem with contactgroupmembers table creation on MySQL 4.x
2011-02-23 08:13:02 +00:00
thomascube
3e2637351d Fulltext search over contact fields. Attention: DATABASE SCHEMA CHANGED\! 2011-02-14 20:46:48 +00:00
thomascube
cdb8b96e31 Clear message cache table when upgrading 2011-01-26 11:53:18 +00:00
alecpl
8710133250 - Fix error in MSSQL DDL scripts (#1487112): use trigger instead of foreign key constraint 2010-11-15 14:03:22 +00:00
alecpl
6f096812c9 - Support contact's email addresses up to 255 characters long (#1487095)
- Added email format checks when saving contacts data
2010-11-02 09:27:03 +00:00
alecpl
ace511a771 - Add unique index on users.username+users.mail_host 2010-10-06 13:00:12 +00:00
alecpl
e019f2d0f2 - s/RoundCube/Roundcube/ 2010-09-25 13:03:53 +00:00
alecpl
fc552950d3 - Added warning about tables engine, per discussion in #1486794 2010-09-14 06:28:43 +00:00
alecpl
ac1898173b - Fixes in SQL init script + added update script for MSSQL database 2010-08-11 09:22:14 +00:00
alecpl
5807133b88 - Fix upgrade script for SQLite (#1486903) 2010-08-10 13:33:09 +00:00
alecpl
161bb97f45 - Added ALTER TABLE .. ENGINE=InnoDB, per discussion in #1486794 2010-06-15 09:46:51 +00:00
alecpl
1aaeaaaaa6 - fix foreign keys defs unintentionally broken in r3333 2010-06-14 18:56:52 +00:00
alecpl
e2402ef99a - Set DEFAULT NULL for users.last_login 2010-04-28 10:34:33 +00:00
alecpl
3cf0993fa1 - added foreign keys in mssql DDL 2010-04-23 08:01:35 +00:00
thomascube
96f9653eb9 Updated mssql schema (I have no clue if this is correct) 2010-04-23 07:38:05 +00:00
thomascube
23362230b5 Replace ALTER TABLE statement in Sqlite schema update script; more precise instructions for db updates and about new cleaning script 2010-04-20 07:26:11 +00:00
alecpl
8a79f224c2 - Fix: postgres doens't support AFTER clause 2010-04-15 07:54:44 +00:00
thomascube
a35062a1eb Always set changed date when marking a DB record as deleted + provide a cleanup script 2010-04-15 06:33:30 +00:00
alecpl
22d6b5346b - contactgroups DDL for postgres 2010-03-27 07:40:43 +00:00
alecpl
1924136b47 - fix default datetime 2010-03-27 07:31:39 +00:00
thomascube
a61bbb24aa Added basic contact groups feature 2010-03-26 16:38:20 +00:00
alecpl
ac756e8858 - fix add index 2010-03-09 06:57:39 +00:00
alecpl
94fe9ca1a8 - re-fix (#1486474) + require MySQL 4.0.8 + add index/update in identities table 2010-03-06 14:13:25 +00:00
alecpl
951c07b1b1 - Fix adding contacts SQL error on mysql (#1486459) 2010-02-24 19:46:13 +00:00
alecpl
5cec0c6078 - typo 2010-02-06 12:41:05 +00:00
alecpl
8248e4a642 - Add workaround for MySQL bug [http://bugs.mysql.com/bug.php?id=46293] (#1486474) 2010-02-06 12:34:16 +00:00