<?xml version='1.0'?>
<!DOCTYPE mysql_table SYSTEM "mysqltable.dtd" >
<?xml-stylesheet type="text/xsl" href="form.xsl" ?>
<mysql_table tbl_name='anc_products'>
<table_definition>
<column_definition col_name='id' null='NOT_NULL' AUTO_INCREMENT='yes' COMMENT='Auto-incrementing unique id for this table.'>
<type>
<INT length='11'/>
</type>
</column_definition><column_definition col_name='SKU' null='NOT_NULL' DEFAULT='0' COMMENT='SKU number of the product'>
<type>
<INT length='11'/>
</type>
</column_definition><column_definition col_name='sName' null='NOT_NULL' COMMENT='Product Name'>
<type>
<TEXT/>
</type>
</column_definition><column_definition col_name='sDescription' COMMENT='Product Description'>
<type>
<TEXT/>
</type>
</column_definition><column_definition col_name='bFreeShipping' null='NOT_NULL' DEFAULT='0' COMMENT='If this product has free shipping'>
<type>
<TINYINT length='1'/>
</type>
</column_definition><column_definition col_name='nCategory' null='NOT_NULL' DEFAULT='-1' COMMENT='Link to the category ID'><type>
<INT length='11'/>
</type></column_definition><column_definition col_name='eGender' null='NOT_NULL' DEFAULT='u' COMMENT='Which gender this product is for'><type>
<ENUM>
<SET_ITEM value='m'/>
<SET_ITEM value='w'/>
<SET_ITEM value='u'/>
</ENUM>
</type></column_definition><column_definition col_name='nOrder' null='NOT_NULL' DEFAULT='1' COMMENT='Order of the product'><type>
<INT length='11'/>
</type></column_definition><column_definition col_name='sFeatureColor' COMMENT='The featured color of this product'><type>
<TEXT/>
</type></column_definition><PRIMARY_KEY>
<index_col_name>id</index_col_name>
</PRIMARY_KEY>
<KEY index_name='ix_sname'><index_col_name>sName</index_col_name>
</KEY>
<KEY index_name='ix_sku'><index_col_name>SKU</index_col_name></KEY>
</table_definition><table_options AUTO_INCREMENT='7'>
<TYPE value='MyISAM'/>
</table_options>
</mysql_table>
