ALTER TABLE `gender`
    ADD `singular_pronoun` VARCHAR(10) NOT NULL DEFAULT 'them',
    ADD `possessive_pronoun` VARCHAR(10) NOT NULL DEFAULT 'their'; 

BEGIN;
UPDATE `gender` SET `singular_pronoun` = 'him' WHERE `gender`.`id` = 1;
UPDATE `gender` SET `singular_pronoun` = 'her' WHERE `gender`.`id` = 2; 
UPDATE `gender` SET `possessive_pronoun` = 'his' WHERE `gender`.`id` = 1;
UPDATE `gender` SET `possessive_pronoun` = 'her' WHERE `gender`.`id` = 2; 
COMMIT;