MySQL Howto

Table create options

The MySQL templates can handle create options for tables. For example, the desired create-sql output is 

CREATE TABLE book
(
    ...
) COLLATE=latin1_german2_ci ENGINE=InnoDB;

For this, specify the desired options in the option elements of the table to create:

Torque recognizes the following keys to be separated with an equals character("=") between key and value:

  • ENGINE
  • AVG_ROW_LENGTH
  • CHARACTER SET
  • DEFAULT CHARACTER SET
  • CHECKSUM
  • COLLATE
  • DEFAULT COLLATE
  • CONNECTION
  • DATA DIRECTORY
  • DELAY_KEY_WRITE
  • INDEX DIRECTORY
  • INSERT_METHOD
  • KEY_BLOCK_SIZE
  • MAX_ROWS
  • MIN_ROWS
  • PACK_KEYS
  • PASSWORD
  • ROW_FORMAT
  • TABLESPACE
  • UNION

Torque recognizes the following keys to be separated with a space character(" ") between key and value:

  • PARTITION BY

All other keys are ignored.