ALTER TABLE `Newsletter`
  ADD COLUMN `langId` INT UNSIGNED NULL DEFAULT '1' AFTER `unsubscriptionDate`,
  ADD CONSTRAINT `FK1_newsletter_lang_id` FOREIGN KEY (`langId`) REFERENCES `Lang` (`id`) ON UPDATE NO ACTION ON DELETE NO ACTION;

ALTER TABLE `Newsletter`
  ADD COLUMN `userId` INT(10) UNSIGNED NULL DEFAULT NULL AFTER `unsubscriptionDate`,
  ADD INDEX `FK2_user_user_id` (`userId`),
  ADD CONSTRAINT `FK2_newsletter_user_id` FOREIGN KEY (`userId`) REFERENCES `User` (`id`) ON UPDATE NO ACTION ON DELETE NO ACTION;
