bE49e6z9

1
2-- -----------------------------------------------------
3-- Schema yoptaplay
4-- -----------------------------------------------------
5CREATE SCHEMA IF NOT EXISTS `yoptaplay` DEFAULT CHARACTER SET utf8 ;
6USE `yoptaplay` ;
7
8-- -----------------------------------------------------
9-- Table `yoptaplay`.`users`
10-- -----------------------------------------------------
11CREATE TABLE IF NOT EXISTS `yoptaplay`.`users` (
12  `timestamp_creation` DATETIME NULL,
13  `uid` INT NOT NULL AUTO_INCREMENT,
14  `login` VARCHAR(16) NULL,
15  `password` VARCHAR(64) NULL,
16  `mail` VARCHAR(32) NULL,
17  `wishlist` MEDIUMTEXT NULL,
18  `favorite_genres` LONGTEXT NULL,
19  PRIMARY KEY (`uid`))
20ENGINE = InnoDB;
21
22
23-- -----------------------------------------------------
24-- Table `yoptaplay`.`auth`
25-- -----------------------------------------------------
26CREATE TABLE IF NOT EXISTS `yoptaplay`.`auth` (
27  `id` INT NOT NULL AUTO_INCREMENT,
28  `session_key` VARCHAR(64) NULL,
29  `timestamp` DATETIME NULL,
30  `uid` INT NULL,
31  `users_uid` INT NOT NULL,
32  PRIMARY KEY (`id`),
33  INDEX `fk_auth_users_idx` (`users_uid` ASC),
34  CONSTRAINT `fk_auth_users`
35    FOREIGN KEY (`users_uid`)
36    REFERENCES `yoptaplay`.`users` (`uid`)
37    ON DELETE NO ACTION
38    ON UPDATE NO ACTION)
39ENGINE = InnoDB;
40
41
42-- -----------------------------------------------------
43-- Table `yoptaplay`.`games`
44-- -----------------------------------------------------
45CREATE TABLE IF NOT EXISTS `yoptaplay`.`games` (
46  `game_id` INT NOT NULL AUTO_INCREMENT,
47  `genres` TEXT(250) NULL,
48  `rating` VARCHAR(1) NULL,
49  `developer` VARCHAR(45) NULL,
50  `ofplayers` INT NULL,
51  `name` VARCHAR(45) NULL,
52  `img_link` VARCHAR(200) NULL,
53  `summary` LONGTEXT NULL,
54  `metascore` INT NULL,
55  `users_score` FLOAT NULL,
56  PRIMARY KEY (`game_id`))
57ENGINE = InnoDB;
58
59
60SET SQL_MODE=@OLD_SQL_MODE;
61SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
62SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;