Mdb2 - foreign keys

[voda]

Hello,
I am trying to create foreign keys in a mysql db. I am using the following code:

[voda]

No one can help?
Maybe a working example would be enough.

[kingmaker]

thanks for the coding...
_________________
COSHH risk assessment | CDM coordinator

[Dschordschdabbelju]

Hello,

I've got the same problem with the definitions array for foreign key contraint.

I searched the whole web, but found no solution.

Declaration has been contructed following http://78.129.214.25/manual/en/package.database.mdb2.intro-manager-module.php.

Code:

$table_options = array(
'comment' => 'books',
'charset' => 'latin1',
'collate' => 'latin1_german1_ci',
'type' => 'innodb',
);

$fields = array(
'lfdnr' => array(
'type' => 'integer',
'unsigned' => true,
'notnull' => 1,
// 'autoincrement' => true,
),
'reihenid' => array(
'type' => 'integer',
'unsigned' => true,
'notnull' => 1,
),
'text' => array(
'type' => 'text',
'length' => 3000,
),
);

$create = $mdb2->CreateTable('buecher', $fields, $table_options);
if (PEAR::isError($create)){
die ("(3):".$create->getMessage()."<br><br>".$create->getUserInfo());
}

$definition = array (
'primary' => true,
'fields' => array (
'lfdnr' => array(),
),
);
$constr = $mdb2->createConstraint('buecher', 'PRIMARY', $definition);
if (PEAR::isError($constr)){
die ("(4):".$constr->getMessage()."<br><br>".$constr->getUserInfo());
}
$definition = array (
'foreign' => true,
'fields' => array(
'reihenid' => array(),
),
'references' => array(
'table' => 'reihen',
'fields' => array(
'id' => array(),
),
),
);

$definition = array (
'primary' => false,
'unique' => false,
'foreign' => true,
'check' => false,
'fields' => array (
'reihenid' => array(
// 'sorting' => 'ascending',
'position' => 2,
),
),
'references' => array(
'table' => 'reihen',
'fields' => array(
'id' => array( //one entry per each referenced field
'position' => 1,
),
),
),
'deferrable' => false,
'initiallydeferred' => false,
'onupdate' => 'CASCADE',
'ondelete' => 'CASCADE',
'match' => 'SIMPLE',
);

$constr = $mdb2->createConstraint('buecher', 'reihen_ibfk_2', $definition);

if (PEAR::isError($constr)){
die ("(:".$constr->getMessage()."<br><br>".$constr->getUserInfo());
}

Error message:

(:MDB2 Error: insufficient data supplied

createConstraint: [Error message: invalid definition, could not create constraint] ...