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 --> |