<?xml version="1.0" encoding="ISO-8859-1"?>
<!-- Edited by XMLSpy® -->
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">
 
  <html>
  <head>
  <link rel="stylesheet" type="text/css" href="Structure.css" />
  </head>  
  <body>
  <h1>Database</h1>
  <xsl:for-each select="database/table">
  <xsl:sort select="@tablename"/>
  <h2><xsl:value-of select="@tablename" /></h2>
  <table>
     <tr>
        <th id="columnname" class="left">Column Name</th>
        <th id="datatype" class="left">Data Type</th>
        <th id="length" class="left">Length</th>
        <th id="default" class="centre">Default</th>
        <th id="nullable" class="centre">Nullable</th>
     </tr>
     <xsl:for-each select="columns/column">
     <xsl:sort select="@seq"/>
        <tr>
           <td class="left"><xsl:value-of select="@columnname" /></td>
           <td class="left"><xsl:value-of select="@datatype" /></td>
           <td class="left"><xsl:value-of select="@length" /></td>
           <td class="centre"><xsl:value-of select="@default" /></td>
           <td class="centre"><xsl:value-of select="@nullable" /></td>
        </tr>
     </xsl:for-each>     
  </table>
  </xsl:for-each>
  </body>
  </html>
  
</xsl:template>
</xsl:stylesheet>

