CREATE TABLE  "Products"
(
   "ID"                bigserial   NOT NULL PRIMARY KEY,
   "Name"                   varchar(255) NOT NULL default '',
   "Code"              varchar(50) NOT NULL default '',
   "Description"            text         NOT NULL default '',
   "Cost"                   money     default '0.00',
   "Price"                  money     default '0.00',
   "Sale_Price"             money     default '0.00'
);


CREATE TABLE "Categories"
(
   "ID"               bigserial   NOT NULL PRIMARY KEY,
   "Name"             varchar(255)  NOT NULL default '',
   "Activated"        boolean  default true 
);

CREATE TABLE "m2mProductsCategories"
(
   "ID"                bigserial   NOT NULL PRIMARY KEY,
   "ProductsID"        bigint   NOT NULL default '-1',
   "CategoriesID"      bigint   NOT NULL default '-1'
);