Advertisement
Guest User

Untitled

a guest
Nov 22nd, 2018
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.40 KB | None | 0 0
  1. CREATE TABLE IF NOT EXISTS `testDB2`.`Sensoriarvot` (
  2. `idSensoriarvot` INT(11) NOT NULL AUTO_INCREMENT,
  3. `Kosteus` FLOAT NULL DEFAULT NULL,
  4. `Lampo` FLOAT NULL DEFAULT NULL,
  5. `Valo` FLOAT NULL DEFAULT NULL,
  6. `Aikaleima` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  7. PRIMARY KEY (`idSensoriarvot`))
  8. ENGINE = InnoDB
  9. AUTO_INCREMENT = 4
  10. DEFAULT CHARACTER SET = latin1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement