mysql建表語句

CREATE TABLE midprojects_producttype(
 id int(10) not null auto_increment primary key,
 name varchar(50),
 description varchar(50),
 orderid int
);

CREATE TABLE location_desc(
 id int(10) not null primary key,
 location_id int not null,
 location_name varchar(50) not null,
 location_desc varchar(50)
);

CREATE TABLE midprojects_p_location(
 id int(10) not null auto_increment primary key,
 projectname varchar(50) not null,
 location_id int,
 foreign key(location_id) references location_desc(id)
);

CREATE TABLE midprojects_p_detail(
 id int(10) not null auto_increment primary key,
 producttype_id int not null,
 p_location_id int(10) not null,
 bu_id int(10) not null,
 process_type_id int(10) not null,
 p_stage_id int(10) not null,
 FOREIGN KEY (producttype_id) REFERENCES midprojects_p_producttype(id),
 FOREIGN KEY (p_location_id) REFERENCES midprojects_p_location(id),
 FOREIGN KEY (bu_id) REFERENCES midprojects_p_bu(id),
 FOREIGN KEY (process_type_id) REFERENCES midprojects_p_process_type(id),
 FOREIGN KEY (p_stage_id) REFERENCES midprojects_p_stage(id)
);
CREATE TABLE stage_desc(
 id int(10) not null auto_increment primary key,
 stage_name varchar(50) not null,
 stage_desc varchar(50)
);

CREATE TABLE midprojects_p_stage(
 id int(10) not null auto_increment primary key,
 stage_id int(10) not null,
 updatetime date not null,
 enddatetime date not null,
 foreign key(stage_id) references stage_desc(id)
);