DROP TABLE IF EXISTS tblDepartures;
CREATE TABLE tblDepartures (DeparturesID INT NOT NULL AUTO_INCREMENT, DepartureDate CHAR(19), DepLocID INT NOT NULL DEFAULT 0, DepTimeID INT NOT NULL DEFAULT 0, VesselID INT NOT NULL DEFAULT 0, DepartureStatusID INT NOT NULL DEFAULT 1, INDEX _0FB586D0_A7FB_4BAE_94A5_109E13C72B04_(DepLocID), INDEX _5E319B7E_B5E2_4243_977E_735B05453B2D_(VesselID), INDEX _8E14A579_C7AA_478F_9E5D_BF8442F866EF_(DepTimeID), INDEX _FC49F541_3B14_44AA_8A9A_BE188134362B_(DepartureStatusID), INDEX DeparturesID(DeparturesID), INDEX DepartureStatusID(DepartureStatusID), INDEX DepLocID(DepLocID), INDEX DepTimeID(DepTimeID), PRIMARY KEY PrimaryKey(DeparturesID), INDEX VesselID(VesselID));
INSERT INTO tblDepartures VALUES(1, "2001-10-22", 1, 2, 4, 7);
INSERT INTO tblDepartures VALUES(2, "2001-01-01", 1, 19, 4, 1);
INSERT INTO tblDepartures VALUES(3, "2001-01-01", 1, 5, 1, 1);
INSERT INTO tblDepartures VALUES(4, "2001-01-01", 1, 7, 2, 1);
INSERT INTO tblDepartures VALUES(5, "2001-01-01", 1, 9, 1, 1);

DROP TABLE IF EXISTS tblDepartureStatus;
CREATE TABLE tblDepartureStatus (DepartureStatusID INT NOT NULL AUTO_INCREMENT, DepartureStatus CHAR(12), INDEX DepartureStatusID(DepartureStatusID), PRIMARY KEY PrimaryKey(DepartureStatusID));
INSERT INTO tblDepartureStatus VALUES(1, "Available");
INSERT INTO tblDepartureStatus VALUES(2, "Booked");
INSERT INTO tblDepartureStatus VALUES(3, "Cancelled");
INSERT INTO tblDepartureStatus VALUES(4, "Waiting");
INSERT INTO tblDepartureStatus VALUES(5, "Overbooked");

DROP TABLE IF EXISTS tblDepLoc;
CREATE TABLE tblDepLoc (DepLocID INT NOT NULL AUTO_INCREMENT, DepLocAbbr CHAR(2), DepLoc CHAR(30), PRIMARY KEY PrimaryKey(DepLocID));
INSERT INTO tblDepLoc VALUES(1, "NL", "New London, CT");
INSERT INTO tblDepLoc VALUES(2, "OP", "Orient Point, LI");

DROP TABLE IF EXISTS tblTimes;
CREATE TABLE tblTimes (TimeID INT NOT NULL AUTO_INCREMENT, Time_ CHAR(19), PRIMARY KEY PrimaryKey(TimeID));
INSERT INTO tblTimes VALUES(1, "07:00:00");
INSERT INTO tblTimes VALUES(2, "08:00:00");
INSERT INTO tblTimes VALUES(3, "09:00:00");
INSERT INTO tblTimes VALUES(4, "10:00:00");
INSERT INTO tblTimes VALUES(5, "11:00:00");

DROP TABLE IF EXISTS tblVessels;
CREATE TABLE tblVessels (VesselID INT NOT NULL AUTO_INCREMENT, AbbrVessel CHAR(2), NameVessel CHAR(50), Capacity INT DEFAULT 0, PRIMARY KEY PrimaryKey(VesselID));
INSERT INTO tblVessels VALUES(1, "JH", "John H", 108);
INSERT INTO tblVessels VALUES(2, "SA", "Susan Anne", 75);
INSERT INTO tblVessels VALUES(3, "CH", "Cape Henlopen", 84);
INSERT INTO tblVessels VALUES(4, "NL", "New London", 47);
INSERT INTO tblVessels VALUES(5, "NS", "North Star", 33);