Re: hierarchical relations / innodb

2005-07-07 Thread Gleb Paharenko
Hello. I think such kind of logic could be implemented on database layer, because the main task for you is to keep data integrity, and this was one of the reason of database creation. However, without triggers your task becomes difficult. Unfortunately they're available only in MySQL 5.xx, w

hierarchical relations / innodb

2005-07-07 Thread mel list_php
Hi, I want to buil a hierarchical database, with different kind of relations. I have differents elements which are linked between them by different kinds of relations. Ex: element 1 IS A element 72 element 22 IS PART OF element 36 I want to have a table "elements",for several reasons: I