public function get_table_ddl($full_table_name)
{
$engine = $this->get_sql_engine();
if ($engine != 'sqlite') {
$qs = 'SHOW CREATE TABLE ' . $full_table_name;
$sql = DB::select($qs);
if (isset($sql[0])) {
$sql[0] = (array) $sql[0];
$row = array_values($sql[0]);
if (isset($row[1])) {
return $row[1];
}
}
} else {
$sql = DB::select("SELECT * FROM sqlite_master WHERE type='table' and (tbl_name='{$full_table_name}');");
if (is_array($sql) and !empty($sql)) {
foreach ($sql as $item) {
$item = (array) $item;
if (isset($item['sql'])) {
return $item['sql'];
}
}
}
}
}