pdo_query("ALTER TABLE test ADD INDEX (name)"); } // Add the testtimethreshold if (!pdo_query("SELECT testtimestdthreshold FROM project LIMIT 1")) { pdo_query("ALTER TABLE project ADD testtimestdthreshold float(3,1) default '1.0'"); } // Add an option to show the testtime or not if (!pdo_query("SELECT showtesttime FROM project LIMIT 1")) { pdo_query("ALTER TABLE project ADD showtesttime tinyint(4) default '0'"); } return; } if (isset($_GET['upgrade-1-2'])) { // Replace the field 'output' in the table test from 'text' to 'mediumtext' $result = pdo_query("SELECT output FROM test LIMIT 1"); $type = pdo_field_type($result, 0); if ($type == "blob" || $type == "text") { $result = pdo_query("ALTER TABLE test CHANGE output output MEDIUMTEXT"); } // Change the file from blob to longblob $result = pdo_query("SELECT file FROM coveragefile LIMIT 1"); $length = mysql_field_len($result, 0); if ($length == 65535) { $result = pdo_query("ALTER TABLE coveragefile CHANGE file file LONGBLOB"); } // Compress the notes if (!pdo_query("SELECT crc32 FROM note LIMIT 1")) { CompressNotes(); } // Change the dates for the groups from 0000-00-00 to 1000-01-01 // This is for mySQL
function mysql_field_type($result = NULL, $field_offset = NULL) { return pdo_field_type(func_get_args()); }