Database SQL 1.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 Boat_Event_Detail (
  Boat_ID             int(10) NOT NULL, 
  Event_ID            int(10) NOT NULL, 
  Phase_ID            int(10) NOT NULL, 
  Time_Taken          time NOT NULL, 
  Boat_Phase_Position int(10) NOT NULL, 
  Phase_Points        int(10) NOT NULL, 
  PRIMARY KEY (Boat_ID, 
  Event_ID, 
  Phase_ID));
CREATE TABLE Competition_Admin (
  Admin_ID         int(10) NOT NULL AUTO_INCREMENT, 
  Admin_First_Name varchar(100) NOT NULL, 
  Admin_Last_Name  varchar(100) NOT NULL, 
  Admin_Email      varchar(50) NOT NULL, 
  Admin_Phone      int(10) NOT NULL, 
  Admin_Username   varchar(50) NOT NULL, 
  Admin_Password   varchar(50) NOT NULL, 
  PRIMARY KEY (Admin_ID));
CREATE TABLE Crew_Member (
  Member_DOB        date NOT NULL, 
  Member_ID         int(10) NOT NULL AUTO_INCREMENT, 
  Member_First_Name varchar(100) NOT NULL, 
  Member_Last_Name  varchar(100) 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 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 Event_Phase (
  Phase_ID          int(10) NOT NULL AUTO_INCREMENT, 
  Phase_Description varchar(100) NOT NULL, 
  PRIMARY KEY (Phase_ID));
CREATE TABLE Event_Phase_Detail (
  Event_ID         int(10) NOT NULL, 
  Phase_ID         int(10) NOT NULL, 
  Phase_Date       date NOT NULL, 
  Phase_Start_Tine time NOT NULL, 
  PRIMARY KEY (Event_ID, 
  Phase_ID));
CREATE TABLE Event_Promotion (
  Promotion_ID          int(10) NOT NULL AUTO_INCREMENT, 
  Promotion_Description varchar(100) NOT NULL, 
  Promotion_Start_Date  datetime NOT NULL, 
  Event_End_Date        datetime NOT NULL, 
  Promotion_Budget      double NOT NULL, 
  PRIMARY KEY (Promotion_ID));
CREATE TABLE Event_Type (
  Event_Type_ID   int(10) NOT NULL AUTO_INCREMENT, 
  Event_Type_Name varchar(100) NOT NULL, 
  PRIMARY KEY (Event_Type_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 Member_Role (
  Role_ID   int(10) NOT NULL AUTO_INCREMENT, 
  Role_Name varchar(50) NOT NULL, 
  PRIMARY KEY (Role_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 Event_Phase_Detail ADD CONSTRAINT FKEvent_Phas483676 FOREIGN KEY (Event_ID) REFERENCES Event_Detail (Event_ID);
ALTER TABLE Event_Phase_Detail ADD CONSTRAINT FKEvent_Phas348983 FOREIGN KEY (Phase_ID) REFERENCES Event_Phase (Phase_ID);
ALTER TABLE Boat_Event_Detail ADD CONSTRAINT FKBoat_Event754559 FOREIGN KEY (Boat_ID) REFERENCES Boat (Boat_ID);
ALTER TABLE Boat_Event_Detail ADD CONSTRAINT FKBoat_Event98563 FOREIGN KEY (Event_ID) REFERENCES Event_Detail (Event_ID);
ALTER TABLE Boat_Event_Detail ADD CONSTRAINT FKBoat_Event7721 FOREIGN KEY (Phase_ID) REFERENCES Event_Phase (Phase_ID);
ALTER TABLE Event_Detail ADD CONSTRAINT FKEvent_Deta133869 FOREIGN KEY (Location_ID) REFERENCES Location (Location_ID);