USE `event`;

UPDATE TABLE `events_log` SET `users_id` =
(SELECT `id` FROM `users_cash`.`users`
WHERE `users_cash`.`users`.`login` LIKE
(
SELECT `context_data` FROM `event`.`events_log`)
);

CREATE TABLE `events_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `events_id` int(11) NOT NULL,
  `context_data` text,
  `users_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `FK_events_log` (`events_id`),
  KEY `fk_events_log_users_id` (`users_id`),
  CONSTRAINT `FK_events_log` FOREIGN KEY (`events_id`) REFERENCES `events` (`id`),
  CONSTRAINT `fk_events_log_users_id` FOREIGN KEY (`users_id`) REFERENCES `users_cash`.`users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=151270 DEFAULT CHARSET=cp1251

CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `login` varchar(15) NOT NULL DEFAULT ''
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=cp1251 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC

UPDATE`events_log` SET `users_id` =
(SELECT `id` FROM `users_cash`.`users`
WHERE `users_cash`.`users`.`login` LIKE
(
SELECT `context_data` FROM `event`.`events_log`)
);