aTia8gpD

1-- MySQL Workbench Synchronization
2-- Generated: 2016-12-01 13:33
3-- Model: New Model
4-- Version: 1.0
5-- Project: Name of the project
6-- Author: Filip
7
8SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
9SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
10SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
11
12CREATE TABLE IF NOT EXISTS `lineuplink`.`ratings` (
13  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
14  `user_id` INT(10) UNSIGNED NULL DEFAULT NULL,
15  `event_id` INT(10) UNSIGNED NULL DEFAULT NULL,
16  `comment` VARCHAR(45) NULL DEFAULT NULL,
17  `rating` INT(1) NULL DEFAULT NULL,
18  PRIMARY KEY (`id`),
19  INDEX `fk_ratings_users1_idx` (`user_id` ASC),
20  INDEX `fk_ratings_events1_idx` (`event_id` ASC),
21  CONSTRAINT `fk_ratings_users1`
22    FOREIGN KEY (`user_id`)
23    REFERENCES `lineuplink`.`users` (`id`)
24    ON DELETE NO ACTION
25    ON UPDATE NO ACTION,
26  CONSTRAINT `fk_ratings_events1`
27    FOREIGN KEY (`event_id`)
28    REFERENCES `lineuplink`.`events` (`id`)
29    ON DELETE NO ACTION
30    ON UPDATE NO ACTION)
31ENGINE = InnoDB
32DEFAULT CHARACTER SET = utf8;
33
34
35SET SQL_MODE=@OLD_SQL_MODE;
36SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
37SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;