MySQL support (alter/drop/rename table)

[nene]

• [ ] ALTER TABLE
  • [x] ADD [COLUMN] name definition
    • [ ] FIRST | AFTER col_name
    • [ ] ADD COLUMN (...)
  • [ ] ADD {INDEX | KEY} [index_name] [index_type] (key_part,...) [index_option] ...
  • [ ] ADD {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ...
  • [x] ADD CONSTRAINT
  • [x] DROP {CONSTRAINT | CHECK}
  • [x] ALTER {CONSTRAINT | CHECK}
  • [ ] ALGORITHM [=] {DEFAULT | INSTANT | INPLACE | COPY}
  • [x] ALTER COLUMN
    • [x] SET {VISIBLE | INVISIBLE}
    • [x] SET DEFAULT
    • [x] DROP DEFAULT
  • [ ] ALTER INDEX index_name {VISIBLE | INVISIBLE}
  • [ ] CHANGE COLUMN old_col_name new_col_name column_definition [FIRST | AFTER col_name]
  • [ ] [DEFAULT] CHARACTER SET [=] charset_name [COLLATE [=] collation_name]
  • [ ] CONVERT TO CHARACTER SET charset_name [COLLATE collation_name]
  • [ ] {DISABLE | ENABLE} KEYS
  • [ ] {DISCARD | IMPORT} TABLESPACE
  • [x] DROP [COLUMN]
  • [ ] DROP {INDEX | KEY}
  • [ ] DROP PRIMARY KEY
  • [ ] DROP FOREIGN KEY name
  • [ ] FORCE
  • [ ] LOCK [=] {DEFAULT | NONE | SHARED | EXCLUSIVE}
  • [ ] MODIFY [COLUMN] name definition [FIRST | AFTER col_name]
  • [ ] ORDER BY col_name, ...
  • [x] RENAME COLUMN old TO new
  • [ ] RENAME {INDEX | KEY} old TO new
  • [x] RENAME [TO | AS]
  • [ ] {WITHOUT | WITH} VALIDATION
  • [ ] partition options:
    • [ ] ADD PARTITION (partition_definition)
    • [ ] DROP PARTITION partition_names
    • [ ] DISCARD PARTITION {partition_names | ALL} TABLESPACE
    • [ ] IMPORT PARTITION {partition_names | ALL} TABLESPACE
    • [ ] TRUNCATE PARTITION {partition_names | ALL}
    • [ ] COALESCE PARTITION number
    • [ ] REORGANIZE PARTITION partition_names INTO (partition_definitions)
    • [ ] EXCHANGE PARTITION partition_name WITH TABLE tbl_name [{WITH | WITHOUT} VALIDATION]
    • [ ] ANALYZE PARTITION {partition_names | ALL}
    • [ ] CHECK PARTITION {partition_names | ALL}
    • [ ] OPTIMIZE PARTITION {partition_names | ALL}
    • [ ] REBUILD PARTITION {partition_names | ALL}
    • [ ] REPAIR PARTITION {partition_names | ALL}
    • [ ] REMOVE PARTITIONING
• [x] DROP TABLE
  • [x] TEMPORARY
  • [x] IF EXISTS
  • [x] CASCADE | RESTRICT
  • [x] multiple tables
• [x] RENAME TABLE