CREATE TABLE IF NOT EXISTS `pc_product` (
  `ID` int(11) NOT NULL auto_increment,
  `Title` varchar(255) default NULL,
  `Active` tinyint(1) default NULL,
  `Price` decimal(10,2) default NULL,
  `Price_Before` decimal(10,2) default NULL,
  `Description_Short` varchar(255) default NULL,
  `Content` text,
  `Gallery_ID` int(11) default NULL,
  `Video_URL` varchar(255) default NULL,
  `Search` text,
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  PRIMARY KEY  (`ID`),
  KEY `Title` (`Title`),
  KEY `Active` (`Active`,`ID`),
  FULLTEXT KEY `Search` (`Search`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `pc_product_category` (
  `ID` int(11) NOT NULL auto_increment,
  `Title` varchar(255) default NULL,
  `Parent` int(11) default NULL,
  `Description_Short` varchar(255) default NULL,
  `Content` text,
  `Order_By` int(11) default NULL,
  `SEO_Title` varchar(255) default NULL,
  `SEO_Keywords` varchar(255) default NULL,
  `SEO_Description` text,
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  PRIMARY KEY  (`ID`),
  KEY `Title` (`Title`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `pc_product_to_category` (
  `ID` int(11) NOT NULL auto_increment,
  `PC_Product_ID` int(11) default NULL,
  `PC_Product_Category_ID` int(11) default NULL,
  `Order_By` int(11) default NULL,
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  PRIMARY KEY  (`ID`),
  KEY `Product_ID` (`PC_Product_ID`,`PC_Product_Category_ID`,`Order_By`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;