tableFields.txt

teamName
collegeName
p1Name
p1Email
p1Gender
p1Dob
p1Contact
p1Github
p1Linkedin
p1Twitter
p1Facebook
p2Name
p2Email
p2Gender
p2Dob
p2Contact
p2Github
p2Linkedin
p2Twitter
p2Facebook
p3Name
p3Email
p3Gender
p3Dob
p3Contact
p3Github
p3Linkedin
p3Twitter
p3Facebook
newToHackathon
heardAboutHackathon
intrestedInWorkshop
specialNeeds

CREATE TABLE `dotSlash`.`registration` ( `_id` INT NOT NULL AUTO_INCREMENT , `teamName` VARCHAR(50) NOT NULL , `collegeName` VARCHAR(100) NOT NULL , `p1Name` VARCHAR(50) NOT NULL , `p1Email` VARCHAR(50) NOT NULL , `p1Gender` VARCHAR(10) NOT NULL , `p1Dob` DATE NOT NULL , `p1Github` VARCHAR(50) NOT NULL , `p1Linkedin` VARCHAR(50) NOT NULL , `p1Twitter` VARCHAR(50) NOT NULL , `p1Facebook` VARCHAR(50) NOT NULL , `p2Name` VARCHAR(50) NOT NULL , `p2Email` VARCHAR(50) NOT NULL , `p2Gender` VARCHAR(10) NOT NULL , `p2Dob` DATE NOT NULL , `p2Github` VARCHAR(50) NOT NULL , `p2Linkedin` VARCHAR(50) NOT NULL , `p2Twitter` VARCHAR(50) NOT NULL , `p2Facebook` VARCHAR(50) NOT NULL , `p3Name` VARCHAR(50) NOT NULL , `p3Email` VARCHAR(50) NOT NULL , `p3Gender` VARCHAR(10) NOT NULL , `p3Dob` DATE NOT NULL , `p3Github` VARCHAR(50) NOT NULL , `p3Linkedin` VARCHAR(50) NOT NULL , `p3Twitter` VARCHAR(50) NOT NULL , `p3Facebook` VARCHAR(50) NOT NULL , `newToHackathon` VARCHAR(10) NOT NULL , `heardAboutHackathon` VARCHAR(100) NOT NULL , `intrestedInWorkshop` VARCHAR(100) NOT NULL , `specialNeeds` VARCHAR(250) NOT NULL , PRIMARY KEY (`_id`(11))) ENGINE = MyISAM;