gQ78FNie

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;