b1gMail/tools/db_struct.php

<?php
/**
 * db_struct.php
 * Exports the current database structure to an array
 */
error_reporting(E_ALL);
include('../src/serverlib/config.inc.php');

// result array
$structure = array();

// connect to db
$conn = mysqli_connect($mysql['host'], $mysql['user'], $mysql['pass']);
if(!$conn) die('Cannot connect to database');
mysqli_select_db($conn, $mysql['db'])
	|| die('Cannot select database');

// get tables
$tables = array();
$res = mysqli_query($conn, 'SHOW TABLES');
while($row = mysqli_fetch_array($res, MYSQLI_NUM))
{
	list($tableName) = $row;
	if(substr($tableName, 0, strlen($mysql['prefix'])) == $mysql['prefix']
		&& strpos($tableName, '_mod_taborder') === false
		&& strpos($tableName, '_mod_premium_') === false
		&& strpos($tableName, '_bms_') === false
		&& $tableName !== 'bm60_news'
		&& strpos($tableName, '_tccrn') === false
		&& strpos($tableName, '_tcspc') === false
		&& strpos($tableName, '_tcbrn_plugin_domains') === false
		&& strpos($tableName, '_mod_signatures') === false
		&& strpos($tableName, '_mod_accountmirror') === false
		&& strpos($tableName, '_modfax_') === false)
		$tables[] = $tableName;
}
mysqli_free_result($res);

echo '<div style="float:left;"><h3>Exportierte Tabellen (' . count($tables) . ')</h3>';
echo '<ul>';
foreach($tables as $table)
	echo '<li>' . $table . '</li>';
echo '</ul></div>';

// get field infos 
foreach($tables as $table)
{
	$fields = $indexes = array();
	$res = mysqli_query($conn, 'SHOW FIELDS FROM ' . $table);
	while($row = mysqli_fetch_array($res, MYSQLI_NUM))
	{
		$fields[] = $row;
	}
	mysqli_free_result($res);
	
	$res = mysqli_query($conn, 'SHOW INDEX FROM ' . $table);
	while($row = mysqli_fetch_array($res, MYSQLI_ASSOC))
	{
		if(isset($indexes[$row['Key_name']]))
			$indexes[$row['Key_name']][] = $row['Column_name'];
		else 
			$indexes[$row['Key_name']] = array($row['Column_name']);
	}
	mysqli_free_result($res);
	
	$structure[$table] = array(
		'fields' 	=> $fields,
		'indexes'	=> $indexes
	);
}

// output
$structure = json_encode($structure, JSON_PRETTY_PRINT);
echo '<div style="float:right;"><h3>Export-Daten</h3>';
echo '<br>checksum (SHA256):'.hash('sha256', $structure).'<br>';
echo '<textarea cols=90 rows=40 readonly=readonly>'. $structure . '</textarea>';
echo '</div>';

// clean up
mysqli_close($conn);