/** * 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; }