La1FbS6x

1-- MySQL Workbench Forward Engineering
2SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
3SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
4SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
5-- SET @SCHEMA_DATABASE_NAME = ‘YOUR_SCHEMA_NAME’;
6-- -----------------------------------------------------
7-- Schema
8-- -----------------------------------------------------
9-- DROP SCHEMA IF EXISTS ‘YOUR_SCHEMA_NAME’;
10-- -----------------------------------------------------
11-- Schema
12-- -----------------------------------------------------
13-- CREATE SCHEMA IF NOT EXISTS ‘YOUR_SCHEMA_NAME’ NAME DEFAULT CHARACTER SET utf8;
14-- USE ‘YOUR_SCHEMA_NAME’;
15-- -----------------------------------------------------
16-- Table `User`
17-- -----------------------------------------------------
18DROP TABLE IF EXISTS `User`;
19CREATE TABLE IF NOT EXISTS `User` (
20`id` INT NOT NULL AUTO_INCREMENT,
21`name` VARCHAR(10) NOT NULL,
22PRIMARY KEY (`id`))
23ENGINE = InnoDB;
24-- -----------------------------------------------------
25-- Table `Game`
26-- -----------------------------------------------------
27DROP TABLE IF EXISTS `Game`;
28CREATE TABLE IF NOT EXISTS `Game` (
29`id` INT NOT NULL AUTO_INCREMENT,
30`name` VARCHAR(20) NOT NULL,
31PRIMARY KEY (`id`))
32ENGINE = InnoDB;
33-- -----------------------------------------------------
34-- Table `Highscore`
35-- -----------------------------------------------------
36DROP TABLE IF EXISTS `Highscore`;
37CREATE TABLE IF NOT EXISTS `Highscore` (
38`User_id` INT NOT NULL,
39`Game_id` INT NOT NULL,
40`score` INT NOT NULL,
41PRIMARY KEY (`User_id`, `Game_id`),
42INDEX `fk_User_has_Game_Game1_idx` (`Game_id` ASC),
43INDEX `fk_User_has_Game_User_idx` (`User_id` ASC),
44CONSTRAINT `fk_User_has_Game_User`
45FOREIGN KEY (`User_id`)
46REFERENCES `User` (`id`)
47ON DELETE NO ACTION
48ON UPDATE NO ACTION,
49CONSTRAINT `fk_User_has_Game_Game1`
50FOREIGN KEY (`Game_id`)
51REFERENCES `Game` (`id`)
52ON DELETE NO ACTION
53ON UPDATE NO ACTION)
54ENGINE = InnoDB;
55SET SQL_MODE=@OLD_SQL_MODE;
56SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
57SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
58-- -----------------------------------------------------
59-- Data for table `User`
60-- -----------------------------------------------------
61START TRANSACTION;
62-- USE `ExampleGameDB`;
63INSERT INTO `User` (`id`, `name`) VALUES (1, 'Jack');
64INSERT INTO `User` (`id`, `name`) VALUES (2, 'Mike');
65INSERT INTO `User` (`id`, `name`) VALUES (3, 'Ben');
66INSERT INTO `User` (`id`, `name`) VALUES (4, 'Jur');
67INSERT INTO `User` (`id`, `name`) VALUES (5, 'Eric');
68COMMIT;
69-- -----------------------------------------------------
70-- Data for table `Game`
71-- -----------------------------------------------------
72START TRANSACTION;
73-- USE ‘zhofem’;
74INSERT INTO `Game` (`id`, `name`) VALUES (1, 'My FYS Game');
75INSERT INTO `Game` (`id`, `name`) VALUES (2, 'League of Luminary');
76INSERT INTO `Game` (`id`, `name`) VALUES (3, 'SunCraft');
77COMMIT;
78-- -----------------------------------------------------
79-- Data for table `Highscore`
80-- -----------------------------------------------------
81START TRANSACTION;
82-- USE ‘zhofem’;
83INSERT INTO `Highscore` (`User_id`, `Game_id`, `score`) VALUES (5, 1, 1000);
84INSERT INTO `Highscore` (`User_id`, `Game_id`, `score`) VALUES (4, 1, 1200);
85INSERT INTO `Highscore` (`User_id`, `Game_id`, `score`) VALUES (2, 1, 800);
86INSERT INTO `Highscore` (`User_id`, `Game_id`, `score`) VALUES (5, 3, 16000);
87INSERT INTO `Highscore` (`User_id`, `Game_id`, `score`) VALUES (2, 3, 4444);
88INSERT INTO `Highscore` (`User_id`, `Game_id`, `score`) VALUES (4, 2, 12);
89COMMIT;