We're updating the issue view to help you get more done. 

Current mysql schema doesn't load

Description

Loading the schema version as of revision 2637 makes mysql quit with errno 150 while creating ca_object_events:

stefan@peter:~/Arbeit/collectiveaccess/trunk/install/inc$ mysql -u root -p trunk < schema_mysql.sql
Enter password:
ERROR 1005 (HY000) at line 549: Can't create table 'trunk.ca_object_events' (errno: 150)

I suppose something is wrong with the object_id foreign key but I couldnt figure out what it is yet.... usually it's something silly like the foreign key being signed while the primary key that is referenced is unsigned that causes errno 150 ...

Environment

MySQL 5.1.37-1ubuntu5 (Ubuntu)

Assignee

User known

Reporter

Stefan Keidel

Labels

None

Components

Fix versions

Affects versions

Priority

Blocker
Configure