create table customers(
c_num int(11)primary key auto_increment,
c_name varchar(50),
c_contact varchar(50),
c_city varchar(50),
c_brith datetime not null);
create table orders(
o_num int(11)primary key auto_increment ,
o_date date,
c_id varchar(50),
constraint c_customers foreign key(o_num) references customers(c_num)
);
