Hi Victoria, 2003年 6月 10日 火曜日 19:16、Victoria Reznichenko さんは書きました: > "Nils Valentin" <[EMAIL PROTECTED]> wrote: > > I try to create foreign keys in a innodb database. I read through some > > threats and the manual, and several online resources, but somehow I am > > missing something. > > > > What I try to do is recreate the keys and their functions of the mysql > > database (privilege database) as a innodb database, including foreign > > keys to illustrate the relations. > > You shouln't convert privilege tables to the InnoDB.
My description was probably not precise enough. I converted copies of the privilege tables (in a new datbase) - but thank you for mentioning it. > > > The copy of the mysql privilege database is called > > mysql_privileges_db_inno. > > > > The 6 tables structure host, user, db etc. was copied to the innodb > > database and then modified with ALTER. > > > > Now when I try to create a foreign key I get the famous Error 1105 which > > tells me that I didnt form the request for the foreign key proberly. > > > > mysql> ALTER TABLE db ADD FOREIGN KEY (User) REFERENCES user (User); > > ERROR 1005: Can't create table > > './mysql_privileges_db_inno/#sql-2e8_10.frm' (errno: 150) > > Column User in the table User must be indexed. I see thank you very much ;-). I understood that an Index already exists from the orginal datbase, but I am going to check it once more. > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.net http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Victoria Reznichenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net > <___/ www.mysql.com -- ================================================ Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp ================================================ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
