$query=mysql_query("SHOW FIELDS FROM ".$i[0]);

$key="";
$field="";
while($j=mysql_fetch_array($query))
{

	$field .= $j['Field']." ".$j['Type'];
	
	if(strlen($j['Default'])>0)
		$field .= " DEFAULT '".$j['Default']."'";
	if(strlen($j['Null'])==0)
		$field .= " NOT NULL";
	if(!empty($j['Extra']))
		$field .=" ".$j['Extra'];
	/*if($j['Key']=="PRI")
		$key .= ", PRIMARY KEY (".$j['Field'].")";
	if($j['Key']=="MUL")
		$key .= ", KEY ".$j['Field']." (".$j['Field'].")";*/
	$field .=", ";
}

$query=mysql_query("SHOW INDEX FROM ".$i[0]);

while($j=mysql_fetch_array($query))
{
	if($j['Key_name']=="PRIMARY")
		$key .= ", PRIMARY KEY (".$j['Column_name'].")";
	elseif($j['Non_unique']==0)
		$key .= ", UNIQUE KEY (".$j['Column_name'].")";
	else
		$key .= ", KEY (".$j['Column_name'].")";
}

$chaine.=substr($field,0,-2).$key.");\n\n";