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
[email protected]
http://lists.mmbase.org/mailman/listinfo/cvs
