# Table structure for table `products`
#

CREATE TABLE products (
products_id int(5) NOT NULL auto_increment,
products_quantity int(4) NOT NULL default '0',
products_model varchar(12) default NULL,
products_image varchar(64) default NULL,
products_price decimal(8,2) NOT NULL default '0.00',
products_retail_price decimal(8,2) NOT NULL default '0.00',
products_price_difference decimal(8,2) NOT NULL default '0.00',
products_date_added datetime default NULL,
products_last_modified datetime default NULL,
products_date_available datetime default NULL,
products_weight decimal(5,2) NOT NULL default '0.00',
products_status tinyint(1) NOT NULL default '0',
products_tax_class_id int(5) NOT NULL default '0',
manufacturers_id int(5) default NULL,
products_location varchar(255) default NULL,
PRIMARY KEY  (products_id)
) TYPE=MyISAM;
# --------------------------------------------------------

#