eF1sQ3hy

1-- -----------------------------------------------------
2-- Table `mydb`.`images`
3-- -----------------------------------------------------
4CREATE  TABLE IF NOT EXISTS `mydb`.`images` (
5  `id` INT NOT NULL AUTO_INCREMENT ,
6  `filename` VARCHAR(100) NULL COMMENT 'this is a sha256 value\ncreated as \nsha256(concat(sha256(image), timestamp))\nsuffix is image type, after \'.\'' ,
7  `createtime` TIMESTAMP NULL ,
8  `blocked` TINYINT(1)  NULL ,
9  `active` TINYINT(1)  NULL ,
10  `lastchangetime` TIMESTAMP NULL COMMENT 'whenever was the last time \nthe image got blocked or\nactive flags changed' ,
11  `metainfo_id` INT NULL ,
12  PRIMARY KEY (`id`) ,
13  INDEX `indexindex2` (`id` ASC) ),
14  INDEX `fk_images_imagemetainfo1` (`metainfo_id` ASC) ,
15  CONSTRAINT `fk_images_imagemetainfo1`
16    FOREIGN KEY (`metainfo_id` )
17    REFERENCES `mydb`.`imagemetainfo` (`id` )
18    ON DELETE NO ACTION
19    ON UPDATE NO ACTION,
20  CONSTRAINT `fk_images_profiles1`
21    FOREIGN KEY (`id` )
22    REFERENCES `mydb`.`profiles` (`profileimage_id` )
23    ON DELETE NO ACTION
24    ON UPDATE NO ACTION)
25ENGINE = InnoDB;
26
27
28-- -----------------------------------------------------
29-- Table `mydb`.`profiles`
30-- -----------------------------------------------------
31CREATE  TABLE IF NOT EXISTS `mydb`.`profiles` (
32  `id` INT NOT NULL AUTO_INCREMENT ,
33  `username` VARCHAR(100) NULL ,
34  `password` VARCHAR(100) NULL ,
35  `email` VARCHAR(100) NULL ,
36  `birthday` DATETIME NULL ,
37  `city_id` INT NULL ,
38  `zipcode_id` INT NULL ,
39  `partnerstatus` INT NULL ,
40  `height_cm` INT NULL ,
41  `weight_kg` INT NULL ,
42  `haircolor_id` INT NULL ,
43  `bodytype_id` INT NULL ,
44  `eyecolor_id` INT NULL ,
45  `childrencount` INT NULL ,
46  `smoker_id` INT NULL ,
47  `jobtype_id` INT NULL ,
48  `business_id` INT NULL ,
49  `education_id` INT NULL ,
50  `religion_id` INT NULL ,
51  `political_direction_id` INT NULL ,
52  `music_style_id` INT NULL ,
53  `searching_for_id` INT NULL ,
54  `searching_in_area_id` INT NULL ,
55  `searching_for_min_age` INT NULL ,
56  `searching_for_max_age` INT NULL ,
57  `profileimage_id` INT NULL ,
58  PRIMARY KEY (`id`) ,
59  INDEX `indexindex` (`profileimage_id` ASC) )
60ENGINE = InnoDB;