Essa apga a tabela 'accounts' e a re-cria, adicionando as novas colunas:
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for accounts
-- ----------------------------
DROP TABLE IF EXISTS `accounts`;
CREATE TABLE `accounts` (
  `login` varchar(45) NOT NULL default '',
  `password` varchar(45) default NULL,
  `lastactive` decimal(20,0) default NULL,
  `access_level` int(11) NOT NULL default '0',
  `lastIP` varchar(20) default NULL,
  `email` varchar(150) NOT NULL,
  `question` varchar(20) NOT NULL,
  `answer` varchar(20) NOT NULL,
  PRIMARY KEY  (`login`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Essa apenas altera a tabela 'accounts':
ALTER TABLE accounts ADD COLUMN email VARCHAR(150) NOT NULL AFTER lastIp;
ALTER TABLE accounts ADD COLUMN question VARCHAR(20) NOT NULL AFTER email;
ALTER TABLE accounts ADD COLUMN answer VARCHAR(20) NOT NULL AFTER question;