CREATE TABLE `axfw_com_catalog_categories` (
  `id_category` int(6) NOT NULL auto_increment,
  `id_parent_category` int(6) NOT NULL default '0',
  `name` varchar(250) NOT NULL default '',
  `image` varchar(250) default NULL,
  `order` int(6) NOT NULL default '0',
  `status` smallint(2) NOT NULL default '1',
  PRIMARY KEY  (`id_category`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;


CREATE TABLE `axfw_com_catalog_products_images` (
  `id_image` int(11) NOT NULL default '0',
  `id_product` int(11) NOT NULL default '0',
  `image` varchar(250) NOT NULL default '',
  `status` smallint(2) NOT NULL default '1',
  PRIMARY KEY  (`id_image`)
) TYPE=MyISAM;


CREATE TABLE `axfw_com_catalog_attributes` (
  `id_attribute` int(11) NOT NULL auto_increment,
  `name` varchar(250) NOT NULL default '',
  PRIMARY KEY  (`id_attribute`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;


CREATE TABLE `axfw_com_catalog_products` (
  `id_product` int(11) NOT NULL auto_increment,
  `id_category` int(11) NOT NULL default '0',
  `name` varchar(250) NOT NULL default '',
  `description` text NOT NULL,
  `model` varchar(250) NOT NULL default '',
  `price` int(11) NOT NULL default '0',
  `weight` int(11) NOT NULL default '0',
  `order` smallint(2) NOT NULL default '0',
  `status` smallint(2) NOT NULL default '1',
  PRIMARY KEY  (`id_product`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;


CREATE TABLE `axfw_com_catalog_products_properties` (
  `id_product_property` int(11) NOT NULL auto_increment,
  `id_product` int(11) NOT NULL default '0',
  `id_attribute` int(11) NOT NULL default '0',
  `id_attribute_value` int(11) NOT NULL default '0',
  `price` int(11) NOT NULL default '0',
  `price_prefix` smallint(2) NOT NULL default '0',
  `status` smallint(2) NOT NULL default '0',
  PRIMARY KEY  (`id_product_property`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;


CREATE TABLE `axfw_com_users` (
  `id_user` int(11) NOT NULL auto_increment,
  `username` varchar(250) NOT NULL default '',
  `password` varchar(250) NOT NULL default '',
  `name` varchar(250) NOT NULL default '',
  `email` varchar(250) NOT NULL default '',
  `comments` text NOT NULL,
  `type` smallint(2) NOT NULL default '1',
  `status` smallint(2) NOT NULL default '0',
  PRIMARY KEY  (`id_user`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;


CREATE TABLE `axfw_com_catalog_attributes_values` (
  `id_attribute_value` int(11) NOT NULL auto_increment,
  `name` char(2) NOT NULL default '',
  PRIMARY KEY  (`id_attribute_value`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;


CREATE TABLE `axfw_com_catalog_products_attributes_values` (
  `id_product_attribute_value` int(11) NOT NULL auto_increment,
  `id_attribute` int(11) NOT NULL default '0',
  `id_attribute_value` int(11) NOT NULL default '0',
  `status` smallint(2) NOT NULL default '0',
  PRIMARY KEY  (`id_product_attribute_value`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;