summaryrefslogtreecommitdiff
path: root/roundcubemail/SQL/postgres.initial.sql
AgeCommit message (Collapse)Author
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-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-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-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
2009-09-29- use better index for contacts tablealec
git-svn-id: https://svn.roundcube.net/trunk@2999 208e9e7b-5314-0410-a742-e7e81cd9613c
2009-09-07- added index in messages tablealec
git-svn-id: https://svn.roundcube.net/trunk@2931 208e9e7b-5314-0410-a742-e7e81cd9613c
2009-05-14- remove version number from *.initial.sqlalec
git-svn-id: https://svn.roundcube.net/trunk@2477 208e9e7b-5314-0410-a742-e7e81cd9613c
2008-12-03- change few "boolean" columns type from integer to smallintalec
git-svn-id: https://svn.roundcube.net/trunk@2108 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
2008-11-21- Fix 'cache' table cleanup on session destroy (#1485516)alec
git-svn-id: https://svn.roundcube.net/trunk@2075 208e9e7b-5314-0410-a742-e7e81cd9613c
2008-06-12#1485125: added index on messages.createdalec
git-svn-id: https://svn.roundcube.net/trunk@1522 208e9e7b-5314-0410-a742-e7e81cd9613c
2008-04-03#1484854alec
git-svn-id: https://svn.roundcube.net/trunk@1242 208e9e7b-5314-0410-a742-e7e81cd9613c
2008-04-03fix: there's no ALTER TABLE ... ADD INDEX in postgresqlalec
git-svn-id: https://svn.roundcube.net/trunk@1240 208e9e7b-5314-0410-a742-e7e81cd9613c
2008-03-25Optimize database schema; get rid of unnecessary indexesthomasb
git-svn-id: https://svn.roundcube.net/trunk@1218 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
2007-03-18Use user_id for unique key in messages table (closes #1484074)thomasb
git-svn-id: https://svn.roundcube.net/trunk@509 208e9e7b-5314-0410-a742-e7e81cd9613c
2006-09-14Initial TinyMCE editor support (still need to work on spellcheck and skins)estadtherr
git-svn-id: https://svn.roundcube.net/trunk@344 208e9e7b-5314-0410-a742-e7e81cd9613c
2006-08-25Finalized new message parsing. Attention: changes in database schemathomasb
git-svn-id: https://svn.roundcube.net/trunk@325 208e9e7b-5314-0410-a742-e7e81cd9613c
2006-02-19Applied several patchesroundcube
git-svn-id: https://svn.roundcube.net/trunk@140 208e9e7b-5314-0410-a742-e7e81cd9613c
2006-01-25Add created date to message cacheroundcube
git-svn-id: https://svn.roundcube.net/trunk@125 208e9e7b-5314-0410-a742-e7e81cd9613c
2006-01-05Optimized loading time; added periodic mail check; added EXPUNGE commandroundcube
git-svn-id: https://svn.roundcube.net/trunk@93 208e9e7b-5314-0410-a742-e7e81cd9613c
2005-12-16Usage of virtusertable; mail_domain for new users; Chinese and Turkish ↵roundcube
localization git-svn-id: https://svn.roundcube.net/trunk@92 208e9e7b-5314-0410-a742-e7e81cd9613c
2005-12-03Re-design of caching (new database table added\!); some bugfixes; Postgres ↵roundcube
support git-svn-id: https://svn.roundcube.net/trunk@88 208e9e7b-5314-0410-a742-e7e81cd9613c
2005-10-25more pear/mdb2 integrationsparc
git-svn-id: https://svn.roundcube.net/trunk@58 208e9e7b-5314-0410-a742-e7e81cd9613c
2005-10-11Better support for Courier IMAProundcube
git-svn-id: https://svn.roundcube.net/trunk@24 208e9e7b-5314-0410-a742-e7e81cd9613c
2005-10-07Several bugfixes and feature improvementsroundcube
git-svn-id: https://svn.roundcube.net/trunk@21 208e9e7b-5314-0410-a742-e7e81cd9613c
2005-10-02more changes to reflect postgres supportsparc
git-svn-id: https://svn.roundcube.net/trunk@13 208e9e7b-5314-0410-a742-e7e81cd9613c