YdWiKkDy

1CREATE TABLE IF NOT EXISTS `tin_database`.`discovery` (
2  `discovery_id` INT NOT NULL AUTO_INCREMENT,
3  `name` VARCHAR(100) NOT NULL,
4  `description` VARCHAR(250) NOT NULL,
5  `url` VARCHAR(200) NOT NULL,
6  `user_id` INT NOT NULL,
7  `date` TIMESTAMP NOT NULL,
8  `up_vote` INT NOT NULL,
9  `down_vote` INT NOT NULL,
10  `vote_count` INT NOT NULL,
11  PRIMARY KEY (`discovery_id`, `user_id`),
12  UNIQUE INDEX `discovery_id_UNIQUE` (`discovery_id` ASC),
13  UNIQUE INDEX `url_UNIQUE` (`url` ASC),
14  INDEX `fk_discovery_user_idx` (`user_id` ASC),
15  CONSTRAINT `fk_discovery_user`
16    FOREIGN KEY (`user_id`)
17    REFERENCES `tin_database`.`user` (`user_id`)
18    ON DELETE NO ACTION
19    ON UPDATE NO ACTION)
20ENGINE = InnoDB;
21
22
23-- -----------------------------------------------------
24-- Table `tin_project`.`role`
25-- -----------------------------------------------------
26DROP TABLE IF EXISTS `tin_database`.`role` ;
27
28CREATE TABLE IF NOT EXISTS `tin_database`.`role` (
29  `role_name` VARCHAR(45) NOT NULL,
30  `description` VARCHAR(255) NULL,
31  UNIQUE INDEX `role_name_UNIQUE` (`role_name` ASC),
32  PRIMARY KEY (`role_name`))
33ENGINE = InnoDB;
34
35
36-- -----------------------------------------------------
37-- Table `tin_project`.`vote`
38-- -----------------------------------------------------
39DROP TABLE IF EXISTS `tin_database`.`vote` ;
40
41CREATE TABLE IF NOT EXISTS `tin_database`.`vote` (
42  `vote_id` INT NOT NULL AUTO_INCREMENT,
43  `discovery_id` INT NOT NULL,
44  `user_id` INT NOT NULL,
45  `date` TIMESTAMP NOT NULL,
46  `type` VARCHAR(30) NOT NULL,
47  PRIMARY KEY (`vote_id`, `discovery_id`, `user_id`),
48  INDEX `fk_user_has_discovery_discovery1_idx` (`discovery_id` ASC),
49  INDEX `fk_user_has_discovery_user1_idx` (`user_id` ASC),
50  CONSTRAINT `fk_user_has_discovery_user1`
51    FOREIGN KEY (`user_id`)
52    REFERENCES `tin_database`.`user` (`user_id`)
53    ON DELETE NO ACTION
54    ON UPDATE NO ACTION,
55  CONSTRAINT `fk_user_has_discovery_discovery1`
56    FOREIGN KEY (`discovery_id`)
57    REFERENCES `tin_database`.`discovery` (`discovery_id`)
58    ON DELETE NO ACTION
59    ON UPDATE NO ACTION)
60ENGINE = InnoDB;