diff options
author | Derek Jones <derek.jones@ellislab.com> | 2010-03-10 21:18:38 +0100 |
---|---|---|
committer | Derek Jones <derek.jones@ellislab.com> | 2010-03-10 21:18:38 +0100 |
commit | ad1171a6797dc0054381327fb26a9e9e232a639e (patch) | |
tree | da843d2b07969d7a2896926e86c27269b7142d39 /user_guide/database | |
parent | 536558bdd4dd04abade1f7d8424de2abd88d978c (diff) |
added swap_pre, autoinit, and stricton database configuration explanations
Diffstat (limited to 'user_guide/database')
-rw-r--r-- | user_guide/database/configuration.html | 15 |
1 files changed, 12 insertions, 3 deletions
diff --git a/user_guide/database/configuration.html b/user_guide/database/configuration.html index 4ef76ed14..1844aa057 100644 --- a/user_guide/database/configuration.html +++ b/user_guide/database/configuration.html @@ -78,7 +78,10 @@ $db['default']['db_debug'] = FALSE;<br /> $db['default']['cache_on'] = FALSE;<br /> $db['default']['cachedir'] = "";<br /> $db['default']['char_set'] = "utf8";<br /> -$db['default']['dbcollat'] = "utf8_general_ci";</code> +$db['default']['dbcollat'] = "utf8_general_ci";<br /> +$db['default']['swap_pre'] = "";<br /> +$db['default']['autoinit'] = TRUE;<br /> +$db['default']['stricton'] = FALSE;</code> <p>The reason we use a multi-dimensional array rather than a more simple one is to permit you to optionally store multiple sets of connection values. If, for example, you run multiple environments (development, production, test, etc.) @@ -96,7 +99,10 @@ $db['test']['db_debug'] = FALSE;<br /> $db['test']['cache_on'] = FALSE;<br /> $db['test']['cachedir'] = "";<br /> $db['test']['char_set'] = "utf8";<br /> -$db['test']['dbcollat'] = "utf8_general_ci";</code> +$db['test']['dbcollat'] = "utf8_general_ci";<br /> +$db['test']['swap_pre'] = "";<br /> +$db['test']['autoinit'] = TRUE;<br /> +$db['test']['stricton'] = FALSE;</code> <p>Then, to globally tell the system to use that group you would set this variable located in the config file:</p> @@ -129,7 +135,10 @@ for the primary connection, but it too can be renamed to something more relevant <li><strong>cachedir</strong> - The absolute server path to your database query cache directory.</li> <li><strong>char_set</strong> - The character set used in communicating with the database.</li> <li><strong>dbcollat</strong> - The character collation used in communicating with the database.</li> -<li><strong>port</strong> - The database port number. Currently only used with the Postgres driver. To use this value you have to add a line to the database config array.<code>$db['default']['port'] = 5432;</code></li> +<li><strong>swap_pre</strong> - A default table prefix that should be swapped with <var>dbprefix</var>. This is useful for distributed applications where you might run manually written queries, and need the prefix to still be customizable by the end user.</li> +<li><strong>autoinit</strong> - Whether or not to automatically initialize the database.</li> +<li><strong>stricton</strong> - TRUE/FALSE (boolean) - Whether to force "Strict Mode" connections, good for ensuring strict SQL while developing an application.</li> +<li><strong>port</strong> - The database port number. Currently only used with the Postgres driver. To use this value you have to add a line to the database config array.<code>$db['default']['port'] = 5432;</code> </ul> <p class="important"><strong>Note:</strong> Depending on what database platform you are using (MySQL, Postgres, etc.) |