 /**
-* Gigs.sql
+* gigs.sql
 *
 * Use to store data from profile form
 *


CREATE TABLE Gigs(
GigsID INT UNSIGNED NOT NULL AUTO_INCREMENT,
WorkExper varchar(500) NOT NULL,
InterviewLoc varchar(255) NOT NULL,
ApptTime varchar(255) NOT NULL,
GigDesc varchar(500) NOT NULL,
ProDetail varchar(350) DEFAULT '',
PayRate varchar(50) NOT NULL,
LastUpdated TIMESTAMP DEFAULT 0 ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (CompanyID)

CompanyName varchar(100) NOT NULL,
CompanyAddress varchar(85) NOT NULL,
City varchar(40) NOT NULL,
CompanyState varchar(25) NOT NULL DEFAULT "WA",
ZipCode MEDIUMINT UNSIGNED NOT NULL,
CompanyPhone varchar(25) NOT NULL,
CompanyWebsite varchar(100) NOT NULL,
GigPostDate DATETIME,
PRIMARY KEY (CompanyID)
FOREIGN KEY (GigsID) REFERENCES Contact(ContactID)
FOREIGN KEY (ContactID) REFERENCES Gigs(GigsID)
)ENGINE=INNODB;

