tablestructure.php

  function tableStructure($tableName)
  {
    try
      {
	// Retrieve field names and types
	$sql="DESCRIBE $tableName";
	$resultSet=$this->query($sql);
	$list=array();
	while($row=mysql_fetch_array($resultSet,MYSQL_ASSOC))
	  {
	    if($row['Default']=='CURRENT_TIMESTAMP')
	      {
		array_unshift($list,$row);
	      }
	    else
	      {
		array_push($list,$row);
	      }
	  }

	$html="";
	foreach($list as $row)
	  {
	    $field=$row['Field'];
	    $type=strtoupper($row['Type']);
	    if($row['Null']==0)
	      {
		$null=" NOT NULL";
	      }
	    $default="";
	    if($row['Default']!=NULL)
	      {
		if($row['Default']=='CURRENT_TIMESTAMP')
		  {
		    $default=" DEFAULT ".$row['Default'];
		  }
		else
		  {
		    $default=" DEFAULT '".$row['Default']."'";
		  }
	      }
	    $extra="";
	    if($row['Extra']!="")
	      {
		$extra=" ".$row['Extra'];
	      }
	    if($row['Key']=="PRI")
	      {
		if(!empty($html))
		  {
		    $html.=",\n";
		  }
		$html.="PRIMARY KEY (`$field`)";
	      }
	    if(!empty($html))
	      {
		$html.=",\n";
	      }
	    $html.="`$field` $type$null$default$extra";	    
	  }
	$html=<<<END
DROP TABLE IF EXISTS `$tableName`;
CREATE TABLE `$tableName` (
$html
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
END;
      }
    catch(Exception $e)
      {
	echo trace(debug_backtrace());
      }
    return $html;
  }