BCYE2DW4

1CREATE TABLE IF NOT EXISTS `people` (
2  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
3  `name` varchar(100) NOT NULL,
4  PRIMARY KEY (`id`) USING BTREE
5) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
6 
7INSERT INTO `people` (`id`, `name`) VALUES
8    (1, 'myname');
9 
10CREATE TABLE IF NOT EXISTS `people_link` (
11  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
12  `id_people` int(11) unsigned NOT NULL DEFAULT '1',
13  `id_unit` int(11) unsigned NOT NULL DEFAULT '1',
14  PRIMARY KEY (`id`) USING BTREE
15) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
16
17INSERT INTO `people_link` (`id`, `id_people`, `id_unit`) VALUES
18	(1, 1, 1),
19	(2, 1, 10);