CREATE TABLE `foo` (
	`test_id2` varchar(255),
	FOREIGN KEY(`test_id2`) REFERENCES `test` (`id2`)
);
CREATE TABLE `bar` (
	`id` int PRIMARY KEY,
	`foo` varchar(255)
);
CREATE TABLE `test_first` (
	`testid` int,
	`test_value` varchar(255),
	FOREIGN KEY(`testid`) REFERENCES `foo` (`test_id2`)
);