note the single quotes in your code: that is where it all goes wrong. i don't know where you got that quotes from, but this is not a valid SQLsyntax for `CREATE TABLE`. ;-)
Thank you, I thought it might be something obvious - that will teach me to cut and paste code! :D