Difference: ProductTable ( vs. 1)

Revision 12013-10-10 - JimSkon

Line: 1 to 1
Added:
>
>
META TOPICPARENT name="LaptopPreorderSystem"

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 -->
 
This site is powered by the TWiki collaboration platformCopyright &© by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback