bug with foreign keys

2004-10-13 Thread Thomas Markus
Hi, i got a problem with foreign keys in 7.4.3-032 2 tables with 2 fks if i run ALTER TABLE TABLE1 ADD FOREIGN KEY FBTABLE1_1 ( REFCOL1 ) REFERENCES TABLE2 (ID) ON DELETE RESTRICT; ALTER TABLE TABLE1 ADD FOREIGN KEY FBTABLE1_2 ( REFCOL1 ) REFERENCES TABLE2 (ID)

bug with foreign keys

2004-09-23 Thread Thomas Markus
Hi, i got a problem with foreign keys in 7.4.3-032 2 tables with 2 fks if i run ALTER TABLE TABLE1 ADD FOREIGN KEY FBTABLE1_1 ( REFCOL1 ) REFERENCES TABLE2 (ID) ON DELETE RESTRICT; ALTER TABLE TABLE1 ADD FOREIGN KEY FBTABLE1_2 ( REFCOL1 ) REFERENCES TABLE2 (ID)