MDB2 trigger problem on multiple table references

[email protected] (Mario Gzuk)
Newsgroups php.pear.general
Message-ID <[email protected]>
Hi,
I have multiple tables which referes to one main tables "id". So I use:
             'fk_fusioninventory_antivirus_hardware_id'=>array(
                   'primary' => 0,
                   'unique'  => 0,
                   'foreign' => 1,
                   'check'   => 0,
                   'fields' => array (
                       'hardware_id' => array(
                             'position' => 1
                       )
                     ),
                   'references' => array(
                       'table' => 'fusioninventory_hardware',
                       'fields' => array(
                           'id' => array(
                             'position' => 1
                           )
                       )
                   ),
                   'deferrable' => 0,
                   'initiallydeferred' => 0,
                   'onupdate' => 'CASCADE',
                   'ondelete' => 'CASCADE'
                   )
on each table. For the first table which will be created and which 
depends on the main table, there will be created an trigger which says 
that if the fusioninventory_hardware.id is changed please update also 
this first table. As mysql doesnt support more than one trigger for the 
same action, the second table which has the same foreign key - there 
will be no trigger created.

The (damn) effect is that only the first table is updated if I change 
the id of the main table. If I delete the 2 triggers (update/delete) so 
that there is no more trigger on the main table, all works fine. All 
tables which has the foreign key will be updated.

If you want to reproduce that, the table definitions are located here:
http://uranos.svn.sourceforge.net/viewvc/uranos/www/modules/fusioninventory/tables.php

I use the latest version of MDB2:
MDB2                2.5.0b5 beta
MDB2_Driver_mysql   1.5.0b4 beta
MDB2_Driver_mysqli  1.5.0b4 beta

mysqld  Ver 5.5.29-0ubuntu0.12.04.2 for debian-linux-gnu on x86_64 
((Ubuntu))

How can I prevent that the mgCreateConstraint creates this triggers or 
does it come from mysql? I can not find any documentation about that.

Thank you
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.