/**
* Return an array with tables, with arrays of foreign keys.
*
* @return array|mixed
*/
protected function getAllForeignKeysOrderedByTable()
{
$results = Database::getAllForeignKeys();
$results = ArrayHelpers::orderArrayByValue($results, 'TABLE_NAME');
return $results;
}
/**
* Execute a describe table query.
*
* @param $table
*
* @return mixed
*/
public static function describeTable($table)
{
$result = DB::select('SHOW FULL COLUMNS FROM ' . $table);
$result = ArrayHelpers::indexArrayByValue($result, 'Field');
return $result;
}
