46 lines
1.0 KiB
PHP
46 lines
1.0 KiB
PHP
<?php
|
|
|
|
include "db.php";
|
|
include "table.php";
|
|
|
|
|
|
$query = "show tables";
|
|
$results = db_query($query);
|
|
|
|
$TableList = array();
|
|
while ($row = db_fetch_assoc($results)) {
|
|
$TableList[] = $row['Tables_in_hotlunch'];
|
|
}
|
|
|
|
for ($j = 0; $j < count($TableList); $j++) {
|
|
$TableName = $TableList[$j];
|
|
|
|
$pflag = false;
|
|
$table = new Table($TableName);
|
|
|
|
for ($i = 0; $i < count($table->column_names); $i++) {
|
|
|
|
if ($table->column_types[$i] == 'enum') {
|
|
$fname = $table->column_names[$i];
|
|
$fvalues = $table->column_values[$i];
|
|
$fdefault = $table->column_defaults[$i];
|
|
|
|
if (strlen($fdefault) == 0) {
|
|
// if ($pflag == false) echo("$TableName:\n");
|
|
// $pflag = true;
|
|
|
|
// echo(" - $fname $fvalues\n");
|
|
$values = explode(",", $fvalues);
|
|
$default = $values[0];
|
|
|
|
$query = "alter table $TableName change $fname $fname enum($fvalues) default $default";
|
|
echo("$query;\n");
|
|
}
|
|
}
|
|
}
|
|
|
|
// echo("\n");
|
|
}
|
|
|
|
?>
|