X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=config%2Fdb.inc.php.dist;h=c1464f91470bcef76ae7b11ddba0e2aa660ea502;hb=76507f7c63a660742e76889ad6e3919f3dde3bb0;hp=895aa45f23e6a81a25e5bc865fc90b955d4c19df;hpb=8bb10dbda276f4c5f1050a05786ba5a5a6cc787d;p=roundcube.git diff --git a/config/db.inc.php.dist b/config/db.inc.php.dist index 895aa45..c1464f9 100644 --- a/config/db.inc.php.dist +++ b/config/db.inc.php.dist @@ -4,8 +4,8 @@ +-----------------------------------------------------------------------+ | Configuration file for database access | | | - | This file is part of the RoundCube Webmail client | - | Copyright (C) 2005-2007, RoundCube Dev. - Switzerland | + | This file is part of the Roundcube Webmail client | + | Copyright (C) 2005-2009, The Roundcube Dev Team | | Licensed under the GNU GPL | | | +-----------------------------------------------------------------------+ @@ -15,52 +15,49 @@ $rcmail_config = array(); // PEAR database DSN for read/write operations -// format is db_provider://user:password@host/databse -// currentyl suported db_providers: mysql, pgsql, sqlite +// format is db_provider://user:password@host/database +// For examples see http://pear.php.net/manual/en/package.database.mdb2.intro-dsn.php +// currently supported db_providers: mysql, mysqli, pgsql, sqlite, mssql or sqlsrv $rcmail_config['db_dsnw'] = 'mysql://roundcube:pass@localhost/roundcubemail'; // postgres example: 'pgsql://roundcube:pass@localhost/roundcubemail'; -// sqlite example: 'sqlite://./sqlite.db?mode=0646'; +// Warning: for SQLite use absolute path in DSN: +// sqlite example: 'sqlite:////full/path/to/sqlite.db?mode=0646'; // PEAR database DSN for read only operations (if empty write database will be used) // useful for database replication $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 // use persistent db-connections -$rcmail_config['db_persistent'] = TRUE; +// beware this will not "always" work as expected +// see: http://www.php.net/manual/en/features.persistent-connections.php +$rcmail_config['db_persistent'] = FALSE; // you can define specific table names used to store webmail data $rcmail_config['db_table_users'] = 'users'; - $rcmail_config['db_table_identities'] = 'identities'; - $rcmail_config['db_table_contacts'] = 'contacts'; - +$rcmail_config['db_table_contactgroups'] = 'contactgroups'; +$rcmail_config['db_table_contactgroupmembers'] = 'contactgroupmembers'; $rcmail_config['db_table_session'] = 'session'; - $rcmail_config['db_table_cache'] = 'cache'; - -$rcmail_config['db_table_messages'] = 'messages'; +$rcmail_config['db_table_cache_index'] = 'cache_index'; +$rcmail_config['db_table_cache_thread'] = 'cache_thread'; +$rcmail_config['db_table_cache_messages'] = 'cache_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_contactgroups'] = 'contactgroups_ids'; $rcmail_config['db_sequence_cache'] = 'cache_ids'; - -$rcmail_config['db_sequence_messages'] = 'message_ids'; +$rcmail_config['db_sequence_searches'] = 'search_ids'; // end db config file -?> \ No newline at end of file +