* on each person's local.
*
* The Variables $dbhost, $databaseName, $dbuser, $dbpass need to be filled with your local settings.
*
* If you are more than one version number behind, set it to the version right after the one you got before. If you already have 2, set it
* to 3 (for example!). This will trigger the for() loop which should add all the updates for you till the most recent version number.
*
* Before running this script, make sure to up the version number by 1 (or to the latest version (located at the bottom));
*/
$version = 1;
$databaseName = "lala";
$dbhost = "localhost:8889";
$dbuser = "******";
$dbpass = "******";
//Do NOT EDIT THIS PORTION OF THE CODE.
$dbConfig = new databaseProperties($databaseName, $dbhost, $dbuser, $dbpass);
$totalVersions = 15;
for ($i = $version; $i <= $totalVersions; $i++) {
/**
* CollegeID Table + ProfessorID Table
*/
if ($i == 1) {
$dbConfig->createDatabase("CollegeSummary");
$dbConfig->setDb("CollegeSummary");
$array1 = array();
$array1[0] = array("CollegeID", "int", "NOT NULL", "AUTO_INCREMENT");
$array1[1] = array("PRIMARY KEY(CollegeID)", "");
$array1[2] = array("CollegeName", "TEXT");
$array1[3] = array("CollegeUrl", "TEXT");
$array1[4] = array("CollegeAvgGPA", "FLOAT(9, 8)");
$array1[5] = array("College50SAT", "INT");
// no reason to change this
// do not use a dbUtil call to replace this, as this is being used for something other than a regular dbConnection
$dbArr = file("dbParameters.txt");
$dbName = str_replace(array("\r", "\r\n", "\n"), '', $dbArr[0]);
$dbHost = str_replace(array("\r", "\r\n", "\n"), '', $dbArr[1]);
$dbUser = str_replace(array("\r", "\r\n", "\n"), '', $dbArr[2]);
$dbPass = "";
// declares variable to prevent error
if (count($dbArr) > 3) {
$dbPass = str_replace(array("\r", "\r\n", "\n"), '', $dbArr[3]);
}
if (is_null($dbPass)) {
$dbPass = "";
// ensures password field gets sent, even if empty
}
$dbConfig = new databaseProperties($dbName, $dbHost, $dbUser, $dbPass);
$totalVersions = 5;
for ($i = $version; $i <= $totalVersions; $i++) {
/**
* RoboUsers Table
*/
if ($i == 1) {
$array1 = array();
$array1[] = array("UserID", "int", "NOT NULL", "AUTO_INCREMENT");
$array1[] = array("PRIMARY KEY(UserID)", "");
$array1[] = array("Username", "TEXT");
$array1[] = array("UserFullName", "TINYTEXT");
// $array1[] = array("UserDescription", "TEXT"); // needed?
$array1[] = array("UserPhoneNumber", "TINYTEXT");
$array1[] = array("UserYear", "INT");
// $array1[] = array("UserMomEmail", "TINYTEXT"); // split into mom/dad email?
