<?xml version='1.0'?>
<!DOCTYPE xsl:stylesheet SYSTEM "xsl.dtd">
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">


<xsl:output method ="html" version="1.0" encoding="UTF-8" omit-xml-declaration="no" standalone="yes" />

<!--
///////////////////////////////////////////////////////////////////////////////
///// BEGIN DESC TEMPLATE /////////////////////////////////////////////////////
///////////////////////////////////////////////////////////////////////////////
-->
<xsl:template match="/">
	<html>
	<head>
	<title>Mysql Table: <xsl:value-of select="mysql_table/@tbl_name" /></title>
	<link href="style.css" rel="stylesheet" type="text/css" />
	</head>
	<body>
		<div id="contain">	
			<xsl:apply-templates />
		<p>Return to the <a href="index.php">main page</a>.</p>	
		</div>
	</body>
	</html>
</xsl:template>

<xsl:template match="table_definition">
	<table cellspacing="0" cellpadding="3">
		<tr>
			<td colspan="3" class="name">
			Table: <xsl:value-of select="/mysql_table/@tbl_name" />
			</td>
		</tr>
		<tr class="header">
			<td>Name</td>
			<td>Type</td>
			<td>Comment</td>
		</tr>
		<xsl:apply-templates />
		<tr class="header">
			<td colspan="3">
				<xsl:value-of select="count(column_definition)" /> column<xsl:if test="count(column_definition)!=1">s</xsl:if>
			</td>
		</tr>
	</table>
</xsl:template>

<xsl:template match="column_definition[position() mod 2 = 0]">
	<tr class="hilite">
		<td>
			<xsl:value-of select="@col_name" />
		</td>
		<td>
			<xsl:value-of select="name(type/*)" />
		</td>
		<td>
			<xsl:value-of select="@COMMENT" />
		</td>
	</tr>
</xsl:template>

<xsl:template match="column_definition[position() mod 2 = 1]">
	<tr>
		<td>
			<xsl:value-of select="@col_name" />
		</td>
		<td>
			<xsl:value-of select="name(type/*)" />
		</td>
		<td>
			<xsl:value-of select="@COMMENT" />
		</td>
	</tr>
</xsl:template>


<!-- GET RID OF THESE -->
<xsl:template match="PRIMARY_KEY|KEY|INDEX|UNIQUE|FOREIGN_KEY|CHECK">
</xsl:template>

</xsl:stylesheet>

