Product Table

<-- SyntaxHighlightingPlugin -->

CREATE TABLE IF NOT EXISTS `mydb`.`Product` (
  `idProducts` INT NOT NULL,
  `Name` VARCHAR(45) NULL,
  `Description` TEXT NULL,
  `FeatureSet` VARCHAR(45) NULL,
  `PriceEstimate` DECIMAL(5,2) NULL,
  `Active` TINYINT(1) NULL,
  `Availability` ENUM('InStock','OnOrder','ByOrder','AsAvailable') NULL,
  UNIQUE INDEX `ProductName_UNIQUE` (`Name` ASC))
ENGINE = InnoDB
COMMENT = 'Products that can be ordered.  Some may be inactive\n'

<-- end SyntaxHighlightingPlugin -->