Author: michiel Date: 2010-05-04 15:46:43 +0200 (Tue, 04 May 2010) New Revision: 42099
Added: mmbase/trunk/core/src/main/config/storage/databases/mysql-binaryasfile-transactions-keybuffer.xml Log: another preconfigured mysql configuration Added: mmbase/trunk/core/src/main/config/storage/databases/mysql-binaryasfile-transactions-keybuffer.xml =================================================================== --- mmbase/trunk/core/src/main/config/storage/databases/mysql-binaryasfile-transactions-keybuffer.xml (rev 0) +++ mmbase/trunk/core/src/main/config/storage/databases/mysql-binaryasfile-transactions-keybuffer.xml 2010-05-04 13:46:43 UTC (rev 42099) @@ -0,0 +1,60 @@ +<?xml version="1.0"?> +<!DOCTYPE storage PUBLIC "-//MMBase//DTD storage config 1.0//EN" "http://www.mmbase.org/dtd/storage_1_0.dtd" [ + <!ENTITY type-mappings SYSTEM "mysql.type-mappings.xml"> + <!ENTITY disallowed-fields SYSTEM "mysql.disallowed-fields.xml"> + <!ENTITY collation-mappings SYSTEM "mysql.collation-mappings.xml"> +]> +<storage> + <!-- MySQLdb configuration resource. + + --> + + <storagemanagerfactory classname="org.mmbase.storage.implementation.database.DatabaseStorageManagerFactory" version="0.1" /> + <storagemanager classname="org.mmbase.storage.implementation.database.RelationalDatabaseStorageManager" version="0.1" /> + + <searchqueryhandler classname="org.mmbase.storage.search.implementation.database.MySqlSqlHandler" /> + + <attributes> + <attribute name="sequence-buffer-size">10</attribute> + <option name="database-supports-transactions" value="true" /> + + <!-- Use Blobs --> + <option name="database-supports-blob" /> + <option name="database-stores-binary-as-file" value="true" /> + + <!-- uses different syntax for creating unique key constraints --> + <scheme name="create-unique-key-scheme" >UNIQUE INDEX {2} ({2})</scheme> + <!-- MySQL does not properly support foreign keys, Still create a least an index --> + <scheme name="create-foreign-key-scheme" >INDEX {2} ({2})</scheme> + + <!-- uses different syntax for composite keys --> + <scheme name="create-unique-index-scheme" >ALTER TABLE {1} ADD UNIQUE INDEX {3} ({2})</scheme> + <scheme name="delete-unique-index-scheme" >ALTER TABLE {1} DROP INDEX {2}</scheme> + + <!-- index --> + <scheme name="create-index-scheme" >ALTER TABLE {1} ADD INDEX {3} ({2})</scheme> + <scheme name="delete-index-scheme" >ALTER TABLE {1} DROP INDEX {2}</scheme> + + <scheme name="create-table-scheme">CREATE TABLE {1} ({2} {3} {5}) character set utf8</scheme> + <scheme name="create-object-table-scheme">CREATE TABLE {1} ({2} {3} {5}) character set utf8</scheme> + + </attributes> + + <!-- List of MMBase objects where the binary data should not be stored in the database but as a + file. This option is only available if by default the database support BLOBs and the default + configuration stores binary data in the database. + Of the objects listed here, the binary data is stored as file rather than as BLOB in the database. + The name used here is the name of the table in which the objects of this type are stored. For example + 'images' or 'icaches'. + --> + <!-- + <store-binary-as-file-objects> + <store-binary-as-file-object name="icaches" /> + </store-binary-as-file-objects> + --> + + &type-mappings; + &disallowed-fields; + &collation-mappings; + +</storage> _______________________________________________ Cvs mailing list Cvs@lists.mmbase.org http://lists.mmbase.org/mailman/listinfo/cvs