create table t1 (a int not null primary key, b int, c varchar(80), e enum('a','b')) engine=aria; insert into t1 (a) values (1),(2),(3); alter online table t1 page_checksum=1; alter online table t1 page_checksum=0; alter online table t1 drop column b, add b int; alter online table t1 modify b bigint; alter online table t1 modify e enum('c','a','b'); alter online table t1 modify c varchar(50); alter online table t1 modify c varchar(100); alter online table t1 add f int; alter online table t1 engine=memory; alter online table t1 checksum=1; alter online table t1 add constraint check (b > 0); show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int(11) NOT NULL, `c` varchar(100) DEFAULT NULL, `e` enum('c','a','b') DEFAULT NULL, `b` bigint(20) DEFAULT NULL, `f` int(11) DEFAULT NULL, PRIMARY KEY (`a`), CONSTRAINT `CONSTRAINT_1` CHECK (`b` > 0) ) ENGINE=MEMORY DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CHECKSUM=1 drop table t1;