Unknown question

CREATE DATABASE HSRM_ZAMBIA;

CREATE TABLE province(

p_id INT (15) NOT NULL AUTO_INCREMENT,

p_name VARCHAR (15) NOT NULL,

PRIMARY KEY (p_id)

) Engine=InnoDB;

CREATE TABLE district (

d_id INT (15) NOT NULL AUTO_INCREMENT,

d_name VARCHAR (15) NOT NULL,

PRIMARY KEY(d_id)

) Engine=InnoDB;

CREATE TABLE town (

t_id INT (15) NOT NULL AUTO_INCREMENT,

t_name VARCHAR (15) NOT NULL,

PRIMARY KEY(t_id)

) Engine=InnoDB;

CREATE TABLE assign_province(

assign_id INT(15) NOT NULL AUTO_INCREMENT,

p_idd INT (15) NOT NULL,

d_idd INT (15) NOT NULL,

Hello there,

I have changed your title, and moved this post to a different sub-forum.

You have not asked a question, nor given any information. Please edit your post to include some information.