Hi Jeff, since MyISAM metadata does not support foreign keys, the software will not be able to acquire those relationships in the same ways as for InnoDB, Oracle, Postgres etc. You need to follow the BioMart naming convention for MyISAM foreign keys. This will allow the software to pick up relationships automatically. Please refer to the documentation
a On Tue, Jun 19, 2012 at 2:28 AM, xiong zhao <[email protected]> wrote: > in fact the storage engine is MYISAM, but the Schema Editor can't acquire > the relations, how should i do? > > Best regards, > Jeff > > > On Fri, Jun 15, 2012 at 7:39 AM, Arek Kasprzyk <[email protected]>wrote: > >> Hi Jeff, >> your DDL defines a InnoDB schema. Please make sure that MyISaM option is >> not checked in >> >> a >> >> On Thu, Jun 14, 2012 at 1:56 AM, xiong zhao <[email protected]> wrote: >> >>> hi all, >>> the attached file is the create table script of our database, but i >>> can't acquire the relations between the tables by Schema Editor. what's >>> the problem? >>> >>> Thanks, >>> >>> Jeff >>> >>> _______________________________________________ >>> Users mailing list >>> [email protected] >>> https://lists.biomart.org/mailman/listinfo/users >>> >>> >> >> > -- Arek Kasprzyk, MD, MSc, PhD BioMart Project Lead www.biomart.org
_______________________________________________ Users mailing list [email protected] https://lists.biomart.org/mailman/listinfo/users
