the table should have been created in the testing server mysql database.
the create table statement for the Product Administration application type is:
CREATE TABLE `Products` (
`ProductID` int(12) NOT NULL AUTO_INCREMENT,
`ProductSKU` varchar(50) DEFAULT NULL,
`ProductName` varchar(100) NOT NULL,
`ProductPrice` float(12,2) NOT NULL,
`ProductRetailPrice` float(12,2) DEFAULT NULL,
`ProductShipping` float(12,2) DEFAULT NULL,
`ProductWeight` float(12,2) DEFAULT NULL,
`ProductCartDesc` varchar(250) DEFAULT NULL,
`ProductShortDesc` varchar(1000) DEFAULT NULL,
`ProductLongDesc` text,
`ProductThumb` varchar(100) NOT NULL,
`ProductImage` varchar(100) NOT NULL,
`ProductUpdateDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`ProductStartDate` datetime DEFAULT NULL,
`ProductEndDate` datetime DEFAULT NULL,
`ProductStock` float(12,2) DEFAULT NULL,
`ProductLive` tinyint(1) DEFAULT '0',
`ProductUnlimited` tinyint(1) DEFAULT '1',
`ProductDigital` varchar(250) DEFAULT NULL,
`ProductMaxDownloads` int(12) DEFAULT NULL,
`ProductNonTaxable` int(1) DEFAULT '0',
`ProductTitle` varchar(100) DEFAULT NULL,
`ProductMetaKeywords` varchar(255) DEFAULT NULL,
`ProductMetaDescription` varchar(255) DEFAULT NULL,
PRIMARY KEY (`ProductID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
you can find the create table statements for each application in the users configuration folder.
for help finding the configuration folder, see the common installation issues page:
common_installation_issues.php
once in the configuration folder, go to Shared/WebAssist/DataAssist/XML/Schema, there is an XML file for each application type.