I'm not 100% sure. I've found the faulty behavior with 2 keys on both DEFAULT NULL columns.
This bug has (had) a lot of different effects and is fixed (as already mentioned) in 5.1.53 -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.1 in ubuntu. https://bugs.launchpad.net/bugs/706988 Title: Major Bug in MySQL 5.1.49 up to 5.1.52 -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs