· 7 years ago · Nov 22, 2018, 11:26 AM
1CREATE TABLE IF NOT EXISTS `testDB`.`Sensoriarvot` (
2 `ID` INT NOT NULL AUTO_INCREMENT,
3 `Kosteus` FLOAT NULL,
4 `Lampo` FLOAT NULL,
5 `Valo` FLOAT NULL,
6 `Aikaleima` TIMESTAMP GENERATED ALWAYS AS () VIRTUAL,
7 PRIMARY KEY (`ID`),
8 UNIQUE INDEX `Aikaleima_UNIQUE` (`Aikaleima` ASC))
9ENGINE = InnoDB