ALTER TABLE `security_person` MODIFY COLUMN `nationality` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL AFTER `marriage`; ALTER TABLE `security_company_person` MODIFY COLUMN `org_id` int(11) NOT NULL AFTER `company_id`, MODIFY COLUMN `role_id` int(11) NOT NULL AFTER `org_id`;