dCa5Huks

1SQLException: Can't create table errno 150/foreign key
2CREATE TABLE IF NOT EXISTS Users 
3(
4    id INT UNSIGNED NOT NULL AUTO_INCREMENT,
5    fooType INT UNSIGNED NOT NULL DEFAULT 0,
6    ...More columns, nothing special...
7    PRIMARY KEY (`id`), 
8    CONSTRAINT Users_fooType_fk 
9        FOREIGN KEY (fooType) 
10        REFERENCES FooTypes (id)
11        ON DELETE CASCADE
12) ENGINE = InnoDB#
13
14CREATE TABLE IF NOT EXISTS FooTypes
15(
16    id INT UNSIGNED NOT NULL AUTO_INCREMENT,
17    ...More columns, nothing special...
18    PRIMARY KEY (`id`) 
19) ENGINE = InnoDB#