UKEwf1MW

1CREATE  TABLE IF NOT EXISTS `mydb`.`images` (
2  `id` INT NOT NULL AUTO_INCREMENT ,
3  `filename` VARCHAR(100) NULL COMMENT 'this is a sha256 value\ncreated as \nsha256(concat(sha256(image), timestamp))\nsuffix is image type, after \'.\'' ,
4  `createtime` TIMESTAMP NULL ,
5  `blocked` TINYINT(1)  NULL ,
6  `active` TINYINT(1)  NULL ,
7  `lastchangetime` TIMESTAMP NULL COMMENT 'whenever was the last time \nthe image got blocked or\nactive flags changed' ,
8  `metainfo_id` INT NULL ,
9  PRIMARY KEY (`id`) ,
10  INDEX `fk_images_imagemetainfo1` (`metainfo_id` ASC) ,
11  CONSTRAINT `fk_images_imagemetainfo1`
12    FOREIGN KEY (`metainfo_id` )
13    REFERENCES `mydb`.`imagemetainfo` (`id` )
14    ON DELETE NO ACTION
15    ON UPDATE NO ACTION,
16  CONSTRAINT `fk_images_profiles1`
17    FOREIGN KEY (`id` )
18    REFERENCES `mydb`.`profiles` (`profileimage_id` )
19    ON DELETE NO ACTION
20    ON UPDATE NO ACTION)
21ENGINE = InnoDB;