7ZnyEDhY

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