ALTER TABLE `new_registration` ADD `vat` VARCHAR(20) NULL AFTER `admin_email`, ADD `address` TEXT NULL AFTER `vat`;
ALTER TABLE `new_registration` ADD `postalcode` VARCHAR(1000) NULL AFTER `address`, ADD `country` VARCHAR(100) NULL AFTER `postalcode`;
ALTER TABLE `institute` ADD `postalcode` VARCHAR(100) NULL AFTER `active`, ADD `country` VARCHAR(100) NULL AFTER `postalcode`;

 CREATE TABLE `qrcode_tokens` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11) NOT NULL,
  `token` varchar(200) COLLATE utf8_bin NOT NULL,
  `salt` bigint(24) NOT NULL,
  `proj_id` varchar(45) COLLATE utf8_bin NOT NULL,
  `active` tinyint(4) NOT NULL,
  `date_created` datetime NOT NULL,
  `expiration_date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;