I'm getting an error trying to create a table but can't find any error codes
listed in the online mysql documentation.
Does anyone know a good source for this?
Also is the cause of my error recognisable to anyone? I just successfully
created the tables listed but this one bounced. All tables are InnoDB
tables.
mysql> show tables;
+--------------------+
| Tables_in_coredb |
+--------------------+
| company_t |
| encryption_level_t |
| realm_t |
| user_type_t |
+--------------------+
4 rows in set (0.00 sec)
mysql> create table user_t (
-> user_key integer not null auto_increment,
-> company_key integer,
-> realm_key integer,
-> user_id char(24) not null,
-> password char(20) binary,
-> last_active timestamp,
-> created timestamp not null,
-> type char(20) not null,
-> enabled char(1) not null,
-> -- CHECK (enabled IN ('Y', 'N')),
-> foreign key(type)
-> references user_type_t(user_type),
-> foreign key(company_key)
-> references company_t(company_key),
-> foreign key(realm_key)
-> references realm_t(realm_key),
-> primary key (user_key),
-> unique user_rcut_i (realm_key, company_key, user_id, type),
-> index user_c_i (company_key)
-> )
-> type = innodb;
ERROR 1005: Can't create table './coredb/user_t.frm' (errno: 150)
mysql>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
