Skip to content

Instantly share code, notes, and snippets.

@devrsantos

devrsantos/video.sql

Last active March 7, 2022 13:27
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save devrsantos/e9a2f0b955ffec5ea0e1848bccf3063b to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save devrsantos/e9a2f0b955ffec5ea0e1848bccf3063b to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. devrsantos revised this gist Mar 7, 2022. 1 changed file with 5 additions and 5 deletions.
    10 changes: 5 additions & 5 deletions video.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -15,16 +15,16 @@ CREATE TABLE IF NOT EXISTS 'DHTube', 'video' (
    );

    CREATE TABLE IF NOT EXISTS `DHTube`.`playlist`(
    `idPlaylist` INT(11) NOT NULL AUTO_INCREMENT,
    `nome` VARCHAR(45) NULL,
    `dataCriacao` DATETIME,
    `privado` SMALLINT(6),
    `idPlaylist` INT(11) NOT NULL AUTO_INCREMENT,
    `nome` VARCHAR(45) NULL,
    `dataCriacao` DATETIME,
    `privado` SMALLINT(6),
    PRIMARY KEY (`idPlaylist`),
    CONSTRAINT `FKId_idUsuario` FOREIGN KEY (`idUsuario`) REFERENCES `DHTube`.`usuario`(`idUsuario`)
    );

    CREATE TABLE avatar(
    avatar_id INT (11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
    avatar_id INT (11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
    nome VARCHAR(45) NULL,
    urlImagem VARCHAR(100)
    );
  2. devrsantos revised this gist Mar 7, 2022. 1 changed file with 12 additions and 0 deletions.
    12 changes: 12 additions & 0 deletions video.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -22,3 +22,15 @@ CREATE TABLE IF NOT EXISTS `DHTube`.`playlist`(
    PRIMARY KEY (`idPlaylist`),
    CONSTRAINT `FKId_idUsuario` FOREIGN KEY (`idUsuario`) REFERENCES `DHTube`.`usuario`(`idUsuario`)
    );

    CREATE TABLE avatar(
    avatar_id INT (11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
    nome VARCHAR(45) NULL,
    urlImagem VARCHAR(100)
    );

    CREATE TABLE pais(
    pais_id INT (11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
    nome VARCHAR(100)
    );

  3. devrsantos revised this gist Mar 7, 2022. 1 changed file with 10 additions and 1 deletion.
    11 changes: 10 additions & 1 deletion video.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -12,4 +12,13 @@ CREATE TABLE IF NOT EXISTS 'DHTube', 'video' (
    qtdDislikes INT(11),
    privado SMALLINT(6),
    dataPublicacao DATETIME
    );
    );

    CREATE TABLE IF NOT EXISTS `DHTube`.`playlist`(
    `idPlaylist` INT(11) NOT NULL AUTO_INCREMENT,
    `nome` VARCHAR(45) NULL,
    `dataCriacao` DATETIME,
    `privado` SMALLINT(6),
    PRIMARY KEY (`idPlaylist`),
    CONSTRAINT `FKId_idUsuario` FOREIGN KEY (`idUsuario`) REFERENCES `DHTube`.`usuario`(`idUsuario`)
    );
  4. devrsantos created this gist Mar 7, 2022.
    15 changes: 15 additions & 0 deletions video.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,15 @@
    CREATE TABLE IF NOT EXISTS 'DHTube', 'video' (
    idVideo INT(11),
    Usuario_idUsuario INT(11),
    titulo VARCHAR(100),
    descricao TEXT,
    tamanho DOUBLE,
    nomeArquivo VARCHAR(100),
    duracao DOUBLE,
    imagem VARCHAR(100),
    qtdReproducoes INT(11),
    qtdLikes INT(11),
    qtdDislikes INT(11),
    privado SMALLINT(6),
    dataPublicacao DATETIME
    );