w9zNzFZk

1-- MySQL Script generated by MySQL Workbench
2-- 11/16/17 10:10:51
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 Twitch
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema Twitch
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `Twitch` DEFAULT CHARACTER SET utf8 ;
18USE `Twitch` ;
19
20-- -----------------------------------------------------
21-- Table `Twitch`.`Streamer`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `Twitch`.`Streamer` (
24  `streamerID` INT NOT NULL AUTO_INCREMENT,
25  `ChannelName` VARCHAR(13) NOT NULL,
26  `totalViews` INT NOT NULL,
27  `totalFollowers` INT NOT NULL,
28  `subscriptionButton` TINYINT(1) NOT NULL,
29  `totalSubscriptions` INT NOT NULL,
30  `pcSpecs` LONGTEXT NULL,
31  `Mature` TINYINT(1) NOT NULL,
32  `Donations` DECIMAL NULL,
33  `subIcon` TINYINT(1) NOT NULL,
34  `Moderators` MEDIUMTEXT NULL,
35  PRIMARY KEY (`streamerID`),
36  UNIQUE INDEX `ChannelName_UNIQUE` (`ChannelName` ASC),
37  UNIQUE INDEX `streamerID_UNIQUE` (`streamerID` ASC))
38ENGINE = InnoDB;
39
40
41-- -----------------------------------------------------
42-- Table `Twitch`.`Viewer`
43-- -----------------------------------------------------
44CREATE TABLE IF NOT EXISTS `Twitch`.`Viewer` (
45  `viewerID` INT NOT NULL AUTO_INCREMENT,
46  `JoinDate` DATETIME NOT NULL,
47  `Doners` TINYINT(1) NOT NULL,
48  `Moderator` TINYINT(1) NULL,
49  PRIMARY KEY (`viewerID`))
50ENGINE = InnoDB;
51
52
53-- -----------------------------------------------------
54-- Table `Twitch`.`Game`
55-- -----------------------------------------------------
56CREATE TABLE IF NOT EXISTS `Twitch`.`Game` (
57  `gameID` INT NOT NULL AUTO_INCREMENT,
58  `Genre` MEDIUMTEXT NOT NULL,
59  `gameName` MEDIUMTEXT NOT NULL,
60  PRIMARY KEY (`gameID`))
61ENGINE = InnoDB;
62
63
64-- -----------------------------------------------------
65-- Table `Twitch`.`Moderator`
66-- -----------------------------------------------------
67CREATE TABLE IF NOT EXISTS `Twitch`.`Moderator` (
68  `streamerID` INT NOT NULL,
69  `viewerID` INT NOT NULL,
70  INDEX `streamerID_idx` (`streamerID` ASC),
71  INDEX `viewerID_idx` (`viewerID` ASC),
72  CONSTRAINT `streamerID`
73    FOREIGN KEY (`streamerID`)
74    REFERENCES `Twitch`.`Streamer` (`streamerID`)
75    ON DELETE NO ACTION
76    ON UPDATE NO ACTION,
77  CONSTRAINT `viewerID`
78    FOREIGN KEY (`viewerID`)
79    REFERENCES `Twitch`.`Viewer` (`viewerID`)
80    ON DELETE NO ACTION
81    ON UPDATE NO ACTION)
82ENGINE = InnoDB;
83
84
85-- -----------------------------------------------------
86-- Table `Twitch`.`GameStreaming`
87-- -----------------------------------------------------
88CREATE TABLE IF NOT EXISTS `Twitch`.`GameStreaming` (
89  `streamerID` INT NOT NULL,
90  `gameID` INT NOT NULL,
91  INDEX `streamerID_idx` (`streamerID` ASC),
92  INDEX `gameID_idx` (`gameID` ASC))
93 
94ENGINE = InnoDB;
95
96
97SET SQL_MODE=@OLD_SQL_MODE;
98SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
99SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;