Adrian, I can really only think of work-arounds, what are your thoughts?
1. You already mentioned you can edit the "create table" statement. You could potentially do that in python code using the DSS API
2. Could you use DSS managed dataset instead of MySQL as the back-end? You don't have the same limitations
3. Could you use PostgreSQL instead of MySQL?