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


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)

* @link http://www.example.com/
* @license http://www.apache.org/licenses/LICENSE-2.0
* @see add.php
* @see gigs/add.php
* @todo none
*/

