Re: ERROR 1005: Can't create table (errno: 150)

[Arturs Pelniks]

CREATE TABLE fields (
L_id TINYINT UNSIGNED NOT NULL, -- Foreign key to table "languages". Determines in what language this word, phrase, sentence or text is writen in. it is part of full field key.
F_key VARCHAR(50) NOT NULL, -- Word, phrase, sentence or text identifieing key. It is part of full field key.
F_content LONGTEXT NOT NULL, -- Translated word, phrase, sentence or text in appropriate language.
F_copy BOOLEAN NOT NULL, -- Determines wheather field will be copied when new language is created.
F_type ENUM('public', 'private') NOT NULL,
F_translated BOOLEAN NOT NULL, -- Tells whether this field is already translated.
G_id INT UNSIGNED, -- Foreign key to table "groups". It is part of full field key.
PRIMARY KEY (L_id, F_key, G_id),
UNIQUE INDEX (L_id, F_key, G_id),
INDEX (L_id),
FOREIGN KEY field_language_id (L_id) REFERENCES languages (L_id)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8
COLLATE=utf8_unicode_ci;



CREATE TABLE groups (
G_id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, -- ID
F_key VARCHAR(50) NOT NULL, -- Foreign key to table "fields". Used to identify group name in different langauges.
G_type ENUM('public', 'private') NOT NULL,
G_parent INT UNSIGNED, -- Used to create tree structure for groups. e.g. Main menu tree for webpage.
UNIQUE INDEX unique_group_field_key (F_key ASC),
INDEX index_parent_group (G_parent ASC),
FOREIGN KEY group_field_key (F_key) REFERENCES fields (F_key)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=latin1
COLLATE=latin1_swedish_ci
AUTO_INCREMENT=1;

Cannot create table groups. The same ERROR. Please help!
Thank you!