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
13 years ago
d5ae9772c1
- Fix username case-insensitivity issue in MySQL ( #1488021 )
13 years ago
f8e48df715
- Merge devel-saved_search branch (Addressbook Saved Searches)
13 years ago
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)
13 years ago
faf10e8fec
Fix automatic db updates; trigger contact indexing after upgrade
13 years ago
83b20a3b49
- Change version number 0.5.2 -> 0.5.X to not confuse users
13 years ago
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 )
13 years ago
09b0e36b3f
Change vcard field to LONGTEXT to completely store vcards with embedded photos
13 years ago
8381ec1254
- Force names of unique constraints in PostgreSQL DDL (postgres 9.x uses different naming convention than older versions)
13 years ago
e6bb836e05
Create interactive update script with improved DB schema check; udated installer with new features and styles
13 years ago
3a5476d150
- Add index on contactgroupmembers.contact_id column.
...
Improves performance and fixes problem with contactgroupmembers table creation on MySQL 4.x
13 years ago
3e2637351d
Fulltext search over contact fields. Attention: DATABASE SCHEMA CHANGED\!
13 years ago
cdb8b96e31
Clear message cache table when upgrading
14 years ago
8710133250
- Fix error in MSSQL DDL scripts ( #1487112 ): use trigger instead of foreign key constraint
14 years ago
6f096812c9
- Support contact's email addresses up to 255 characters long ( #1487095 )
...
- Added email format checks when saving contacts data
14 years ago
ace511a771
- Add unique index on users.username+users.mail_host
14 years ago
e019f2d0f2
- s/RoundCube/Roundcube/
14 years ago
fc552950d3
- Added warning about tables engine, per discussion in #1486794
14 years ago
ac1898173b
- Fixes in SQL init script + added update script for MSSQL database
14 years ago
5807133b88
- Fix upgrade script for SQLite ( #1486903 )
14 years ago
161bb97f45
- Added ALTER TABLE .. ENGINE=InnoDB, per discussion in #1486794
14 years ago
1aaeaaaaa6
- fix foreign keys defs unintentionally broken in r3333
14 years ago
e2402ef99a
- Set DEFAULT NULL for users.last_login
14 years ago
3cf0993fa1
- added foreign keys in mssql DDL
14 years ago
96f9653eb9
Updated mssql schema (I have no clue if this is correct)
14 years ago
23362230b5
Replace ALTER TABLE statement in Sqlite schema update script; more precise instructions for db updates and about new cleaning script
14 years ago
8a79f224c2
- Fix: postgres doens't support AFTER clause
14 years ago
a35062a1eb
Always set changed date when marking a DB record as deleted + provide a cleanup script
14 years ago
22d6b5346b
- contactgroups DDL for postgres
14 years ago
1924136b47
- fix default datetime
14 years ago
a61bbb24aa
Added basic contact groups feature
14 years ago
ac756e8858
- fix add index
14 years ago
94fe9ca1a8
- re-fix ( #1486474 ) + require MySQL 4.0.8 + add index/update in identities table
14 years ago
951c07b1b1
- Fix adding contacts SQL error on mysql ( #1486459 )
14 years ago
5cec0c6078
- typo
15 years ago
8248e4a642
- Add workaround for MySQL bug [ http://bugs.mysql.com/bug.php?id=46293 ] ( #1486474 )
15 years ago
9273c83790
- don't use TRUNCATE on sqlite ( #1486374 )
15 years ago
f47e2dc5ea
- move TRUNCATE before CREATE INDEX ( #1486362 )
15 years ago
23b76563dc
- use better index for contacts table
15 years ago
b2b8b19cf5
- Change MySQL data type to avoid problems with big session vars
15 years ago
7fec6b2de7
- "TRUNCATE messages" is required to remove buggy cache entries
15 years ago
3d601d267d
- added index in messages table
15 years ago
7c6bc1a187
- Fix MS SQL DDL ( #1486020 )
15 years ago
798ad5ea8e
- remove version number from *.initial.sql
15 years ago
37974e2490
- Fix datetime columns defaults in mysql's DDL ( #1485641 )
15 years ago
97840cb795
- added lost column in mssql DDL
16 years ago
a493ea8e48
- change few "boolean" columns type from integer to smallint
16 years ago
fa898a4a84
Simplify MYSQL database initialization instructions
16 years ago
2bedfab77a
Add conditional comments to mysql initial script ( #1485517 ); remove old mysql 4.0 init script
16 years ago
debdda0117
#1485420 : remove default (and not null) for users.language column in DDL
16 years ago
e4d9f05e41
- Added index on cache.created + small fixes in mssql DDL script
16 years ago
dcf780a6bd
- fix r2076: removed cache.session_id column, removed DELETEs from cache in session_gc
...
- trust DB server's time when "touching" cache and messages tables
16 years ago
3e48d2eee1
- Increase speed of session destroy and garbage clean up
...
- Fix session timeout when DB server got clock skew (#1485490 )
16 years ago
be7d3b6918
- Fix 'cache' table cleanup on session destroy ( #1485516 )
16 years ago
c98f3b5d6e
#1485125 : added index on messages.created
16 years ago
f18911adb4
- #1485120 (text column can't have a default value)
16 years ago
d7f3d796a2
-Fixed Mysql DDL for default identities creation ( #1485070 )
16 years ago
f5e8d23e8e
#1484962 : typo
16 years ago
6cb7786912
#1484854
16 years ago
edc63c2e38
fix: there's no ALTER TABLE ... ADD INDEX in postgresql
16 years ago
ac26b96466
Optimize database schema; get rid of unnecessary indexes
16 years ago
6223e957cc
Fix Postgresql upgrade script ( #1484668 )
17 years ago
112bff6f11
Set prefs field in user table to null ( #1484386 )
17 years ago
84d06edb06
IPv6 Compatability
17 years ago
29451cfc61
Truncate cache table before adding index
17 years ago
f09bca308e
# fixed : #1484456
17 years ago
2c633703e9
upgrade to TinyMCE v2.1.1.1
17 years ago
3c3b3517c1
Fix default value problem for MySQL ( #1483940 )
17 years ago
6ae6e41fb3
Updated description files and version info
17 years ago
5870871ae1
Changed sql scripts to allow non-ascii chars in user names ( #1483959 )
17 years ago
9e5d051e97
Set default value for col preferences; fix bug #1483978
17 years ago
43a42dcf40
Use user_id for unique key in messages table ( closes #1484074 )
17 years ago
9cdb93420e
Fixed quoting in MySQL update script
18 years ago
a0109c4933
Initial TinyMCE editor support (still need to work on spellcheck and skins)
18 years ago
107bde9cfd
Added MSSQL support
18 years ago
f7bfec96be
Finalized new message parsing. Attention: changes in database schema
18 years ago
64009eb849
Reverted files to r305
18 years ago
c145602b6e
Improvements for SVN 306 Bug (Ticket #1483950 )
18 years ago
a06be986eb
Added a few fields to the contact table and made this fields avaiable (Ticket #1332930 )
18 years ago
aade7b9804
Finalized 0.1beta2 release
18 years ago
535da27ca6
Updated installation instructions
19 years ago
f88d417c96
Applied several patches
19 years ago
fd80c1eed8
Updated initial SQL queries
19 years ago
58e3602a37
Bugfixes for encoding and sending with attachments
19 years ago
b59474133a
Add created date to message cache
19 years ago
c6e808e90c
fixed mysql SQL scripts for new created column
19 years ago
15a9d1ce67
Optimized loading time; added periodic mail check; added EXPUNGE command
19 years ago
977a295eb1
Usage of virtusertable; mail_domain for new users; Chinese and Turkish localization
19 years ago
1cded85790
Re-design of caching (new database table added\!); some bugfixes; Postgres support
19 years ago
e447cb072f
Added 'changed' col to contacts table and support for 160-bit session hashes
19 years ago
e0ddd4e6c0
Added 'changed' col to contacts table and support for 160-bit session hashes
19 years ago
d7cb77414c
more pear/mdb2 integration
19 years ago
49afbf5d69
Better support for Courier IMAP
19 years ago
79fe17fb5a
Added SQLite supprt and MySQL update script
19 years ago
42b1135149
Several bugfixes and feature improvements
19 years ago
f5dc2a42a2
more changes to reflect postgres support
19 years ago
4e17e6c9db
Initial revision
19 years ago
alecpl