I never was very good at MySQL syntax. If you have access to PhpMyAdmin, perhaps you could manually create it there and compare the query it executes to yours? Sorry I could be of more help.