Most table options were not covered by any test.
The data provider replaces testBuilderCompressed and checks that each
option is rebuilt and does not consume the tokens following it.

Co-Authored-By: Claude Opus 5.5 (1M context) <[email protected]>
Signed-off-by: Maximilian Krög <[email protected]>

Options not in the list were dropped when building the statement,
together with all the options following them.

Added options documented by MySQL and MariaDB:
PAGE_CHECKSUM, TRANSACTIONAL, ENCRYPTED, ENCRYPTION_KEY_ID, ENCRYPTION,
COMPRESSION, STATS_AUTO_RECALC, STATS_PERSISTENT, STATS_SAMPLE_PAGES,
AUTOEXTEND_SIZE, IETF_QUOTES, SEQUENCE, ENGINE_ATTRIBUTE,
SECONDARY_ENGINE_ATTRIBUTE and ADAPTIVE_HASH_INDEX.

Co-Authored-By: Claude Opus 5.5 (1M context) <[email protected]>
Signed-off-by: Maximilian Krög <[email protected]>

MariaDB quotes engine-defined table options in SHOW CREATE TABLE, e.g.
`PAGE_COMPRESSED`='ON'. These were not recognized, so they were dropped
together with all the options following them. phpMyAdmin rebuilds the
statement when exporting the table structure, losing these options.

Quoted names are only accepted where the options array enables it with
`_ALLOW_QUOTED`, so quoted identifiers like SELECT `DISTINCT` are not
mistaken for options.

Co-Authored-By: Claude Opus 5.5 (1M context) <[email protected]>
Signed-off-by: Maximilian Krög <[email protected]>