Re-design of caching (new database table added\!); some bugfixes; Postgres support

2 files changed, 19 insertions, 1 deletions

diff --git a/config/db.inc.php.dist b/config/db.inc.php.dist
index 6db417860..c797168db 100644
--- a/config/db.inc.php.dist
+++ b/config/db.inc.php.dist
@@ -19,6 +19,7 @@ $rcmail_config = array();
 // currentyl suported db_providers: mysql, sqlite
 
 $rcmail_config['db_dsnw'] = 'mysql://roundcube:pass@localhost/roundcubemail';
+// postgres example: 'pgsql://roundcube:pass@localhost/roundcubemail';
 // sqlite example: 'sqlite://./sqlite.db?mode=0646';
 
 // PEAR database DSN for read only operations (if empty write database will be used)
@@ -28,6 +29,9 @@ $rcmail_config['db_dsnr'] = '';
 // database backend to use (only db or mdb2 are supported)
 $rcmail_config['db_backend'] = 'db';
 
+// maximum length of a query in bytes
+$rcmail_config['db_max_length'] = 512000;  // 500K
+
 // you can define specific table names used to store webmail data
 $rcmail_config['db_table_users'] = 'users';
 
@@ -39,6 +43,20 @@ $rcmail_config['db_table_session'] = 'session';
 
 $rcmail_config['db_table_cache'] = 'cache';
 
+$rcmail_config['db_table_messages'] = 'messages';
+
+
+// you can define specific sequence names used in PostgreSQL
+$rcmail_config['db_sequence_users'] = 'user_ids';
+
+$rcmail_config['db_sequence_identities'] = 'identity_ids';
+
+$rcmail_config['db_sequence_contacts'] = 'contact_ids';
+
+$rcmail_config['db_sequence_cache'] = 'cache_ids';
+
+$rcmail_config['db_sequence_messages'] = 'message_ids';
+
 
 // end db config file
 ?>
diff --git a/config/main.inc.php.dist b/config/main.inc.php.dist
index 6a0ada4c5..ec1614e18 100644
--- a/config/main.inc.php.dist
+++ b/config/main.inc.php.dist
@@ -88,7 +88,7 @@ $rcmail_config['date_short'] = 'D H:i';
 $rcmail_config['date_long'] = 'd.m.Y H:i';
 
 // add this user-agent to message headers when sending
-$rcmail_config['useragent'] = 'RoundCube Webmail/0.1-20051021';
+$rcmail_config['useragent'] = 'RoundCube Webmail/0.1b';
 
 // only list folders within this path
 $rcmail_config['imap_root'] = '';