35 lines
902 B
PHP
35 lines
902 B
PHP
<?php
|
|
include "db.php";
|
|
|
|
$charSet = "utf8";
|
|
$collation = "utf8_general_ci";
|
|
|
|
$tables = db_query("SHOW TABLES");
|
|
while ($row = db_fetch_array($tables)) {
|
|
$tableName = $row[0];
|
|
echo("$tableName\n");
|
|
|
|
// if ($tableName < 'hotlunch_menu_items') continue;
|
|
|
|
$columns = db_query("SHOW COLUMNS FROM $tableName");
|
|
while ($row = db_fetch_array($columns)) {
|
|
$columnName = $row['Field'];
|
|
$columnType = $row['Type'];
|
|
|
|
if ($columnType == "date") {
|
|
db_query("UPDATE $tableName SET $columnName = 'NULL' WHERE $columnName < '2000-01-01'");
|
|
$num = db_affected_rows();
|
|
echo("$columnName: $num\n");
|
|
}
|
|
|
|
if ($columnType == "datetime") {
|
|
db_query("UPDATE $tableName SET $columnName = 'NULL' WHERE $columnName < '2000-01-01 00:00:00'");
|
|
$num = db_affected_rows();
|
|
echo("$columnName: $num\n");
|
|
}
|
|
}
|
|
echo("\n");
|
|
}
|
|
|
|
?>
|