数据库问题错误代码1005，数据库名称为xuesheng
CREATE TABLE Student (Student_id INT NOT NULL PRIMARY KEY,campus_id INT NOT NULL,trainning_site_id INT NOT NULL,full_name VARCHAR(20) NOT NULL ,age INT NOT NULL,email VARCHAR(50) NOT NULL
);
CREATE TABLE car(rego_number VARCHAR(20) NOT NULL PRIMARY KEY,owner_id INT NOT NULL,owner_name VARCHAR(20) NOT NULL,
CONSTRAINT fk1_car FOREIGN KEY (owner_id) REFERENCES student (student_id)
);
CREATE TABLE campus (
campus_id INT NOT NULL PRIMARY KEY,
campus_location VARCHAR(30) NOT NULL
);
CREATE TABLE trainning site(trainning_site_id INT NOT NULL PRIMARY KEY,
trainning_site_location VARCHAR(30) NOT NULL
);
ALTER TABLE Student ADD CONSTRAINT fkl_student FOREIGN KEY (campus_id) REFERENCES campus (campus_id);
ALTER TABLE Student ADD CONSTRAINT fk2_student FOREIGN KEY (trainning_site_id) REFERENCES trainning_site(trainning_site_id);
结果：
查询：ALTER TABLE Student ADD CONSTRAINT fk2_student FOREIGN KEY (trainning_site_id) REFERENCES trainning_site(`trainning_site.
错误代码： 1005
Can't create table 'xuesheng.#sql-1158_7' (errno: 150)
解决问题
