5rnnTu8G

1'1', 'Male'
2'2', 'Male'
3'3', 'Female'
4	
5'1', 'Male'
6'2', 'Female'
7	
8CREATE TABLE IF NOT EXISTS `bi_person` (
9        `id_person` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
10        `name` VARCHAR(50) NOT NULL,
11        `last_name` VARCHAR(100) NOT NULL,
12         `additional_info` VARCHAR(50) NOT NULL,
13        `gender_id` VARCHAR (50) UNIQUE REFERENCES bi_gender
14    ) COLLATE='utf8_bin';
15	
16CREATE TABLE IF NOT EXISTS `bi_gender` (
17        `id_gender` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
18        `name`  VARCHAR(10) NOT NULL  
19    ) COLLATE='utf8_bin';
20	
21CREATE TABLE IF NOT EXISTS `bi_country` (
22        `id_country` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
23        `name`  VARCHAR(10) NOT NULL 
24    ) COLLATE='utf8_bin';