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")) {
echo "Success! Your CollegeProfessors and CollegeSummary tables have been linked via CollegeID.<br />";
}
}
/**
* PictureID Table
*/
if ($i == 2) {
$array = array();
$array[0] = array("PictureID", "int", "NOT NULL", "AUTO_INCREMENT");
$array[1] = array("PRIMARY KEY(PictureID)");
$array[2] = array("CollegePicture", "TEXT");
$array[3] = array("CollegeID", "INT");
if ($dbConfig->createINNODBTable("CollegePictures", $array)) {
echo "Success! Your CollegePictures Table is now set up! <br />";
}
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")) {
echo "Success! Your UserBadges and RoboUsers tables have been linked via UserID.<br />";
}
}
/**
* UserHistories Table
*/
if ($i == 2) {
$array = array();
$array[] = array("HistoryID", "int", "NOT NULL", "AUTO_INCREMENT");
$array[] = array("PRIMARY KEY(HistoryID)");
$array[] = array("HistoryTimeStamp", "TINYTEXT");
$array[] = array("NumericTimeStamp", "TINYTEXT");
$array[] = array("UserID", "INT");
if ($dbConfig->createINNODBTable("UserHistories", $array)) {
echo "Success! Your UserHistory Table is now set up! <br />";
