I am not enterely sure this post belongs here, but I’ll give it a try.
I am developing some code to integrate an ajax-chat into EE. For this purpose, I need to create 3 additional tables. One of them, ‘chatUsers’ is basically an extension of exp_members. This is how I set it up:
CREATE TABLE exp_chatUsers
userId INT(10) UNSIGNED NOT NULL,
role ENUM(‘AJAX_CHAT_GUEST’,‘AJAX_CHAT_SPEAKER’,‘AJAX_CHAT_USER’,‘AJAX_CHAT_MODERATOR’,‘AJAX_CHAT_ADMIN’) NOT NULL,
PRIMARY KEY (userId),
FOREIGN KEY (userId) REFERENCES exp_members (unique_id)
ENGINE = InnoDB;
I keep getting an error message “Can’t create table (errno 150)”. I have looked around, I just can’t find what might be wrong with this statement. Does anyone have a suggestions?
Moved to Howto by Moderator