Talk:FUDforum tables

For later reference, here is the script used to document FUDforum's database tables:

<?php
 echo "<mediawiki xml:lang=\"en\">\n";
 
 $link = mysql_connect('localhost', 'root', 'mypassword');
 if ($link){
 	mysql_selectdb('fudforum', $link);
 
 	$result = mysql_query('SHOW TABLES');
 	while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
 		$table = $row[0];
 		$struct = mysql_query('SHOW FULL COLUMNS FROM '. $table);
 		$ind = mysql_query('SHOW INDEXES FROM '. $table);
 		
 		echo "<page><title>".$table."</title><revision>";
 		echo "<contributor><username>naudefj</username></contributor>";
 		echo "<text>";
 
 		echo "Description of FUDforum table '''$table'''.\n\n";
 		
 		echo "== Fields ==\n";
 		echo "{| class=\"wikitable sortable\"\n";
 		echo "|-\n! Column Name !! Datatype !! Can be Null? !! Key? || Default !! Description\n|-\n";
		while ($row2 = mysql_fetch_array($struct, MYSQL_NUM)) {
 			echo "|-\n| ";
			echo $row2[0] .' || '. $row2[1] .' || '. $row2[3] .' || '. $row2[4] .' || '. $row2[5] .' || '. $row2[6] . $row2[8];
 			echo  "\n";
		}
 		echo "|}\n\n";
 
 		echo "== Keys ==\n";
 		echo "{| class=\"wikitable sortable\"\n";
 		echo "|-\n! Index Name !! Uniqueness !! Column Name !! Seq in index !! Comments\n|-\n";
 		while ($row2 = mysql_fetch_array($ind, MYSQL_NUM)) {
 			echo "|-\n| ";
			echo $row2[2] .' || '. ($row2[1] ? 'NOT UNIQUE' : 'UNIQUE') .' || '. $row2[4] .' || '. $row2[3] .' || '. $row2[11];
 			echo  "\n";
		}
 		echo "|}\n\n";
 		echo "[[Category: FUDforum tables]]\n";
 		
 		echo "</text></revision></page>\n";
	}
 }
 
 echo "</mediawiki>\n";
 ?>