ALTER TABLE `sub` ADD `examreg` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL;