On 28 Mar 2007, at 15:12, John Siracusa wrote: > On 3/28/07, Adrian Howard <[EMAIL PROTECTED]> wrote: >> CREATE TABLE products ( >> id SERIAL NOT NULL PRIMARY KEY, >> name VARCHAR(255) NOT NULL, >> vendor_id INT REFERENCES vendors (id), >> UNIQUE(name) >> ) TYPE = InnoDB; > > While it will happily accept almost anything reasonable looking in a > CREATE TABLE statement, MySQL is quite picky about how it wants you to > express the creation of foreign keys. See this post and then the one > that it links to for some tips: > > http://www.mail-archive.com/rose-db-object@lists.sourceforge.net/ > msg01338.html > > If, after following those instructions, the Loader *still* doesn't > make the expected method(s), post again :)
I <heart> MySQL.... grumble. Many thanks. I'm now getting weird MySQL errors - but that's not this lists problem :-) Adrian ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object
