vJdfLP8c

1-- MySQL Script generated by MySQL Workbench
2-- Mon Jun 25 23:54:00 2018
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 online-music
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema online-music
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `online-music` DEFAULT CHARACTER SET utf8 ;
18USE `online-music` ;
19
20-- -----------------------------------------------------
21-- Table `online-music`.`video`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `online-music`.`video` (
24  `id` BIGINT NOT NULL AUTO_INCREMENT,
25  `name` VARCHAR(250) NULL,
26  `path` VARCHAR(250) NULL,
27  PRIMARY KEY (`id`))
28ENGINE = InnoDB;
29
30
31-- -----------------------------------------------------
32-- Table `online-music`.`clip`
33-- -----------------------------------------------------
34CREATE TABLE IF NOT EXISTS `online-music`.`clip` (
35  `id` BIGINT NOT NULL AUTO_INCREMENT,
36  `shot_name` VARCHAR(100) NULL,
37  `last_played` TIMESTAMP NULL,
38  `active` TINYINT NOT NULL DEFAULT 1,
39  `video_id` BIGINT NOT NULL,
40  PRIMARY KEY (`id`),
41  CONSTRAINT `fk_clip_video`
42    FOREIGN KEY (`video_id`)
43    REFERENCES `online-music`.`video` (`id`)
44    ON DELETE NO ACTION
45    ON UPDATE NO ACTION)
46ENGINE = InnoDB;
47
48CREATE INDEX `fk_clip_video_idx` ON `online-music`.`clip` (`video_id` ASC);
49
50
51-- -----------------------------------------------------
52-- Table `online-music`.`artist`
53-- -----------------------------------------------------
54CREATE TABLE IF NOT EXISTS `online-music`.`artist` (
55  `id` BIGINT NOT NULL AUTO_INCREMENT,
56  `name` VARCHAR(250) NULL,
57  PRIMARY KEY (`id`))
58ENGINE = InnoDB;
59
60CREATE FULLTEXT INDEX `IDXNAME` ON `online-music`.`artist` (`name` ASC);
61
62
63-- -----------------------------------------------------
64-- Table `online-music`.`artist_clip`
65-- -----------------------------------------------------
66CREATE TABLE IF NOT EXISTS `online-music`.`artist_clip` (
67  `id` BIGINT NOT NULL AUTO_INCREMENT,
68  `artist_id` BIGINT NOT NULL,
69  `clip_id` BIGINT NOT NULL,
70  PRIMARY KEY (`id`),
71  CONSTRAINT `fk_artist_clip_artist1`
72    FOREIGN KEY (`artist_id`)
73    REFERENCES `online-music`.`artist` (`id`)
74    ON DELETE NO ACTION
75    ON UPDATE NO ACTION,
76  CONSTRAINT `fk_artist_clip_clip1`
77    FOREIGN KEY (`clip_id`)
78    REFERENCES `online-music`.`clip` (`id`)
79    ON DELETE NO ACTION
80    ON UPDATE NO ACTION)
81ENGINE = InnoDB;
82
83CREATE INDEX `fk_artist_clip_artist1_idx` ON `online-music`.`artist_clip` (`artist_id` ASC);
84
85CREATE INDEX `fk_artist_clip_clip1_idx` ON `online-music`.`artist_clip` (`clip_id` ASC);
86
87
88SET SQL_MODE=@OLD_SQL_MODE;
89SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
90SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;