Displaying 1 result from an estimated 1 matches for "artists_ibfk_artist_type_id".
2006 Jun 21
1
Migration with foreign key won''t work
...oreign_key_constraint(:artists, :artist_type_id, :artist_types,
:artist_type, {:on_delete=>:restrict, :on_update=>:cascade})
rake aborted!
Mysql::Error: Can''t create table
''./psyguideorg_development/#sql-b0_14.frm'' (errno: 150): ALTER TABLE
artists ADD CONSTRAINT artists_ibfk_artist_type_id FOREIGN KEY
(artist_type_id) REFERENCES artist_types (artist_type) ON UPDATE CASCADE
ON DELETE RESTRICT
I can''t see where''s the problem... Can anybody help me, please?
Thanks a lot.
Joshua
--
Posted via http://www.ruby-forum.com/.