ALTER TABLE table ADD COLUMN column VARCHAR (255) NOT NULL AFTER column;
ALTER TABLE tablename MODIFY columnname INTEGER;