Database SQL 2.sql

CREATE TABLE Boat (
  Boat_ID          int(10) NOT NULL AUTO_INCREMENT, 
  Boat_Description varchar(100) NOT NULL, 
  Boat_Model       varchar(100) NOT NULL, 
  Boat_Color       varchar(50) NOT NULL, 
  Boat_Number      int(10) NOT NULL, 
  CONSTRAINT Boat_Id 
    PRIMARY KEY (Boat_ID));
CREATE TABLE Location (
  Location_ID      int(10) NOT NULL AUTO_INCREMENT, 
  Location_Name    varchar(100) NOT NULL, 
  Location_City    varchar(100) NOT NULL, 
  Location_Country varchar(100) NOT NULL, 
  PRIMARY KEY (Location_ID));
CREATE TABLE Event_Detail (
  Event_ID          int(10) NOT NULL AUTO_INCREMENT, 
  Event_Description varchar(100) NOT NULL, 
  Event_Start_Date  datetime NOT NULL, 
  Event_End_Date    datetime NOT NULL, 
  Location_ID       int(10) NOT NULL, 
  PRIMARY KEY (Event_ID));
CREATE TABLE Crew_Member (
  Member_ID         int(10) NOT NULL AUTO_INCREMENT, 
  Member_First_Name varchar(100) NOT NULL, 
  Member_Last_Name  varchar(100) NOT NULL, 
  Member_DOB        date NOT NULL, 
  Member_Email      varchar(50) NOT NULL, 
  Member_Phone      int(10) NOT NULL, 
  Member_Username   varchar(50) NOT NULL, 
  Member_Password   varchar(50) NOT NULL, 
  Role_ID           int(10) NOT NULL, 
  Boat_ID           int(10) NOT NULL, 
  PRIMARY KEY (Member_ID));
CREATE TABLE Member_Role (
  Role_ID   int(10) NOT NULL AUTO_INCREMENT, 
  Role_Name varchar(50) NOT NULL, 
  PRIMARY KEY (Role_ID));
CREATE TABLE Reegistration (
  Boat_ID       int(10) NOT NULL, 
  Event_ID      int(10) NOT NULL, 
  Time_Taken    time NOT NULL, 
  Boat_Position int(10) NOT NULL, 
  PRIMARY KEY (Boat_ID, 
  Event_ID));
ALTER TABLE Crew_Member ADD CONSTRAINT FKCrew_Membe7779 FOREIGN KEY (Role_ID) REFERENCES Member_Role (Role_ID);
ALTER TABLE Crew_Member ADD CONSTRAINT FKCrew_Membe624333 FOREIGN KEY (Boat_ID) REFERENCES Boat (Boat_ID);
ALTER TABLE Reegistration ADD CONSTRAINT FKReegistrat785233 FOREIGN KEY (Boat_ID) REFERENCES Boat (Boat_ID);
ALTER TABLE Reegistration ADD CONSTRAINT FKReegistrat67889 FOREIGN KEY (Event_ID) REFERENCES Event_Detail (Event_ID);
ALTER TABLE Event_Detail ADD CONSTRAINT FKEvent_Deta133869 FOREIGN KEY (Location_ID) REFERENCES Location (Location_ID);