foreign key does not working in mysql

See more:

database

Hello and good day everyone,

i got a problem in my database. i'm trying to create 2 table and one of these table have foreign key to other table. my problem is, the data that i make it as foreign key does not working, and the column text field remain null. i have try alter the table, drop the table and even using this command 'set foreign_key_checks=0'; but still the column text field remain null. FYI, i have try manually and use script to do that and yet the same result occur. i'm using mysql workbench 6.1.6.Could someone help me since i'm newbie in mysql,thank you.

sample code i've done:

create table if not exists Tenant_dummydata.Zone_details(
Zone_id int not null auto_increment;
Zone_name varchar(10),
primary key(Zone_id));

insert into Zone_details(Zone_name) values ('A');
insert into Zone_details(Zone_name) values ('B');
insert into Zone_details(Zone_name) values ('C');
insert into Zone_details(Zone_name) values ('D');
insert into Zone_details(Zone_name) values ('E');

create table if not exists Tenant_dummydata.Lot_details(
Lot_id int not null auto_increment,
Lot_size bigint,
Zone_id int,
primary key(Lot_id),
CONSTRAINT Zone_id foreign key(Zone_id) 
	references Zone_details(Zone_id));

insert into Lot_details(Lot_size) values ('11450');
insert into Lot_details(Lot_size) values ('23890');
insert into Lot_details(Lot_size) values ('35000');
insert into Lot_details(Lot_size) values('38450');
insert into Lot_details(Lot_size) values ('49800');