qPpJxK3x

1-- MySQL Script generated by MySQL Workbench
2-- Tue 30 Jan 2018 06:12:40 PM CET
3-- Model: New Model    Version: 1.0
4-- MySQL Workbench Forward Engineering
5
6SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
7SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
8SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
9
10-- -----------------------------------------------------
11-- Schema videogame
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema videogame
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `videogame` DEFAULT CHARACTER SET utf8 ;
18USE `videogame` ;
19
20-- -----------------------------------------------------
21-- Table `videogame`.`videogame`
22-- -----------------------------------------------------
23DROP TABLE IF EXISTS `videogame`.`videogame` ;
24
25CREATE TABLE IF NOT EXISTS `videogame`.`videogame` (
26  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
27  `name` VARCHAR(64) NOT NULL,
28  `editor` VARCHAR(64) NULL,
29  `release_date` DATE NULL,
30  `platform` VARCHAR(32) NULL,
31  PRIMARY KEY (`id`))
32ENGINE = InnoDB;
33
34
35SET SQL_MODE=@OLD_SQL_MODE;
36SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
37SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
38
39-- -----------------------------------------------------
40-- Data for table `videogame`.`videogame`
41-- -----------------------------------------------------
42START TRANSACTION;
43USE `videogame`;
44INSERT INTO `videogame`.`videogame` (`id`, `name`, `editor`, `release_date`, `platform`) VALUES (1, 'Theme Hospital', 'Bullfrog', '1997-09-10', 'PC');
45INSERT INTO `videogame`.`videogame` (`id`, `name`, `editor`, `release_date`, `platform`) VALUES (2, 'NBA Jam', 'Midway', '1993-04-02', 'MegaDrive');
46INSERT INTO `videogame`.`videogame` (`id`, `name`, `editor`, `release_date`, `platform`) VALUES (3, 'Day of Tentacle', 'LucasArts', '1993-06-20', 'PC');
47
48COMMIT;