$array1[7] = array("College25SAT", "INT");
$array1[8] = array("CollegeAPCredit", "TINYTEXT");
$array1[9] = array("CollegeLocation", "TEXT");
$array1[10] = array("CollegeAthletics", "Text");
$array1[11] = array("CollegePostGrads", "TINYTEXT");
$array1[12] = array("CollegeAcademicStaff", "TINYTEXT");
$array1[13] = array("CollegeEndowmentFund", "TINYTEXT");
$array1[14] = array("CollegeType", "TINYTEXT");
$array1[15] = array("CollegeEstablished", "INT");
$array1[16] = array("CollegePresident", "TINYTEXT");
$array1[17] = array("CollegeCampus", "TEXT");
$array1[18] = array("CollegeRating", "INT");
$array1[19] = array("CollegeRaters", "INT");
$array1[20] = array("CollegeUnderGrads", "TINYTEXT");
$array1[21] = array("CollegeSummary", "TEXT");
if ($dbConfig->createINNODBTable("CollegeSummary", $array1)) {
echo "Success! Your CollegeSummary Table is now set up! <br />";
}
//print_r($dbConfig->createINNODBTable("CollegeSummary", $array1));
//The Next Table's set up file.
// The CollegeProfessors table.
$array = array();
$array[0] = array("ProfessorID", "int", "NOT NULL", "AUTO_INCREMENT");
$array[1] = array("PRIMARY KEY(ProfessorID)");
$array[2] = array("CollegeProfessor", "TEXT");
$array[3] = array("CollegeID", "INT");
if ($dbConfig->createINNODBTable("CollegeProfessors", $array)) {
echo "Success! Your CollegeProfessor Table is now set up! <br />";
}
//print_r($dbConfig->createINNODBTable("CollegeProfessors", $array));
if ($dbConfig->setRelation("CollegeProfessors", "CollegeSummary", "CollegeID")) {
$array1[] = array("UserYear", "INT");
// $array1[] = array("UserMomEmail", "TINYTEXT"); // split into mom/dad email?
$array1[] = array("UserParentsEmail", "TINYTEXT");
// split into mom/dad email?
$array1[] = array("UserEmail", "TINYTEXT");
// $array1[] = array("UserTitle", "TINYTEXT"); // needed?
// $array1[] = array("UserPicture", "TINYTEXT"); // needed?
$array1[] = array("UserPassword", "TINYTEXT");
$array1[] = array("ActivationCode", "TINYTEXT");
$array1[] = array("Activated", "INT");
// nonzero val is true
$array1[] = array("UserSubteam", "TINYTEXT");
// vals: Mechanical, Electronics, Programming, Operational
$array1[] = array("UserType", "TINYTEXT");
// vals: Regular, VP, Admin, Mentor
if ($dbConfig->createINNODBTable("RoboUsers", $array1)) {
echo "Success! Your RoboUsers Table is now set up! <br />";
}
//print_r($dbConfig->createINNODBTable("CollegeSummary", $array1));
//The Next Table's set up file.
// The CollegeProfessors table.
$array = array();
$array[] = array("BadgeID", "int", "NOT NULL", "AUTO_INCREMENT");
$array[] = array("PRIMARY KEY(BadgeID)");
$array[] = array("BadgeName", "TEXT");
$array[] = array("UserID", "INT");
if ($dbConfig->createINNODBTable("UserBadges", $array)) {
echo "Success! Your UserBadges Table is now set up! <br />";
}
//print_r($dbConfig->createINNODBTable("CollegeProfessors", $array));
if ($dbConfig->setRelation("UserBadges", "RoboUsers", "UserID")) {
