Hey mike
thanks for the help
u must be aware of the bug in mysql that a composite foreign key comprising of say 2 columns is broken into 2 foreign keys having the same name but having different columns.
eg.
key1 comprising of column1,column2 is broken down into
keyA which consists of column 1,
keyA which consists of column 2.
now we are trying to delete one of these duplicated foreign keys and are trying to add column2 to keyA ( keyA already consists of column1 ).
to achieve the above, we have to add a column to the columns list in the foreign keys.
the ID of this column has to be the same as that of the column in the original table.
ie.
ID of column 2 in the foreign keys list = ID of column 2 in table->tablename->columns
but we are not able to do so.
following is the sample code and the errors generated:
grtV.addObj("db.mysql.Column","<name>","<columnID>","<ownerID>")
grtV.insert(<add this object to corresponding list>)
grtV.setGlobal("path/column2/_id",<value>)
the above line raises an 'invalid path' error for 'path/column2/_id.
so can u suggest a way to add a column to a foreign key so as to make it composite?
or is there any way to make a foreign key composite?
thanks for the help