CREATE TABLE IF NOT EXISTS Products
(
   `ID`               bigint   NOT NULL auto_increment PRIMARY KEY,
   `Name`                   varchar(255) NOT NULL default '',
   `Code`              varchar(50) NOT NULL default '',
   `Description`            text         NOT NULL default '',
   `Cost`                   double(10,2) NOT NULL default '0.00',
   `Price`                  double(10,2) NOT NULL default '0.00',
   `Sale_Price`             double(10,2) NOT NULL default '0.00'
)TYPE=MyISAM;


CREATE TABLE IF NOT EXISTS Categories
(
   `ID`               bigint   NOT NULL auto_increment PRIMARY KEY,
   `Name`             varchar(255)  NOT NULL default '',
   `Activated`        tinyint  NOT NULL default '0'
)TYPE=MyISAM;

CREATE TABLE IF NOT EXISTS m2mProductsCategories
(
   `ID`                bigint   NOT NULL auto_increment PRIMARY KEY,
   `ProductsID`        bigint   NOT NULL default '-1',
   `CategoriesID`      bigint   NOT NULL default '-1'
)TYPE=MyISAM;