5h2DFrx6

1SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
2
3
4/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
5/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
6/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
7/*!40101 SET NAMES utf8 */;
8
9CREATE TABLE IF NOT EXISTS `a` (
10  `a_id` int(11) NOT NULL AUTO_INCREMENT,
11  `id` int(11) DEFAULT NULL,
12  PRIMARY KEY (`a_id`),
13  KEY `IDX_E8B7BE43BF396750` (`id`)
14) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
15
16INSERT INTO `a` (`a_id`, `id`) VALUES
17(5, 10);
18
19CREATE TABLE IF NOT EXISTS `b` (
20  `id` int(11) NOT NULL AUTO_INCREMENT,
21  `name` varchar(255) DEFAULT NULL,
22  PRIMARY KEY (`id`)
23) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;
24
25INSERT INTO `b` (`id`, `name`) VALUES
26(5, 'wrong'),
27(10, 'cool');
28
29ALTER TABLE `a`
30  ADD CONSTRAINT `FK_E8B7BE43BF396750` FOREIGN KEY (`id`) REFERENCES `b` (`id`);