Path

projects / org / ezproject2010 / fezmetadata / forum / general / default database engine for...

Default database engine for mysql

You need to be logged in to post messages in the forums. New users may register here.

Olivier Clavel

Member since:
24 July 2008

Posts: 3

Thursday 15 October 2009 12:13:55 am

Your sql/schema.sql file should declare the default engine so that the table creation is consistent with the rest of an eZ 4 database regardless of the mysql server config.

CREATE TABLE fezmeta_data (
id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
contentobject_id INT( 11 ) NOT NULL ,
meta_name VARCHAR( 255 ) NOT NULL ,
meta_value VARCHAR( 255 ) NOT NULL
) ENGINE=InnoDB

Cheers !

Olivier Clavel - Kaliop Interactive Media
Silver Partner - http://www.kaliop.com
Up

You need to be logged in to post messages in the forums. New users may register here.