CREATE TABLE

[Jeremiah Jacks]

Help! I am totally stumped.
Why won't this execute successfully?

CREATE TABLE user_shipping_info (
        user_id INT UNSIGNED NOT NULL,
        as_acct VARCHAR(8) NOT NULL,
        email_address VARCHAR(40),
        company VARCHAR(50),
        phone_number VARCHAR(15),
        fax_number VARCHAR(15),
        address_1 VARCHAR(40),
        address_2 VARCHAR(40),
        address_3 VARCHAR(40),
        address_4 VARCHAR(40),
        city VARCHAR(25),
        state_abbreviation CHAR(2),
        zip VARCHAR(12),
        country VARCHAR(25),
        UNIQUE INDEX idx_uniq (user_id, as_acct),
        FOREIGN KEY (user_id) REFERENCES `user`(id) ON DELETE CASCADE ON
UPDATE CASCADE,
        INDEX idx_state_abbreviation (state_abbreviation),
        FOREIGN KEY (state_abbreviation) REFERENCES
state(state_abbreviation) ON DELETE SET NULL ON UPDATE CASCADE
) TYPE=INNODB;

Error:
ERROR 1005: Can't create table './tamiyausa/user_shipping_info.frm' (errno:
150)

Thanks in advance!
Jer


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]