mysql table options in generation and test update
database creation and usage statements
updated test constants
updated mysql options
updated script generation tests