ALTER TABLE `stureg` ADD `visa` VARCHAR(32) NULL AFTER `ic`, ADD `vdate` DATE NULL AFTER `visa`;

ALTER TABLE `stureg` ADD `ppdate` DATE NOT NULL AFTER `ic`;

ALTER TABLE `stureg` ADD `attachment` TEXT NOT NULL AFTER `json_data`;

ALTER TABLE `stureg` CHANGE `json_data` `json_data` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL;

ALTER TABLE `stureg`  ADD `others` TEXT NOT NULL  AFTER `attachment`;