Device Table

<-- SyntaxHighlightingPlugin -->

CREATE TABLE IF NOT EXISTS `mydb`.`Device` (
  `idUser` INT NULL COMMENT 'CurrentOwner',
  `SystemID` VARCHAR(45) NOT NULL,
  `DateAquired` DATE NULL,
  `Comments` TEXT NULL,
  INDEX `fk_Device_User1_idx` (`idUser` ASC),
  PRIMARY KEY (`SystemID`),
  CONSTRAINT `fk_Device_User1`
    FOREIGN KEY (`idUser`)
    REFERENCES `mydb`.`User` (`idUser`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
COMMENT = 'Each device has a record\n'

<-- end SyntaxHighlightingPlugin -->