dpg94M4u

1SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
2SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
3SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';
4
5CREATE SCHEMA IF NOT EXISTS `blog` DEFAULT CHARACTER SET latin1 COLLATE latin1_general_ci ;
6USE `blog` ;
7
8-- -----------------------------------------------------
9-- Table `blog`.`Usuario`
10-- -----------------------------------------------------
11CREATE  TABLE IF NOT EXISTS `blog`.`Usuario` (
12  `id` INT NOT NULL ,
13  `email` VARCHAR(32) NULL ,
14  `avatar` VARCHAR(32) NULL ,
15  `password` VARCHAR(32) NULL ,
16  `rol` VARCHAR(8) NULL ,
17  PRIMARY KEY (`id`) )
18ENGINE = InnoDB;
19
20
21-- -----------------------------------------------------
22-- Table `blog`.`Entrada`
23-- -----------------------------------------------------
24CREATE  TABLE IF NOT EXISTS `blog`.`Entrada` (
25  `id` INT NOT NULL ,
26  `titulo` VARCHAR(32) NULL ,
27  `contenido` TEXT NULL ,
28  `creado_en` DATETIME NULL ,
29  `actualizado_en` DATETIME NULL ,
30  `usuario_id` INT NULL ,
31  PRIMARY KEY (`id`) ,
32  INDEX `fk_Entrada_Usuario` (`usuario_id` ASC) ,
33  CONSTRAINT `fk_Entrada_Usuario`
34    FOREIGN KEY (`usuario_id` )
35    REFERENCES `blog`.`Usuario` (`id` )
36    ON DELETE NO ACTION
37    ON UPDATE NO ACTION)
38ENGINE = InnoDB;
39
40
41-- -----------------------------------------------------
42-- Table `blog`.`Comentario`
43-- -----------------------------------------------------
44CREATE  TABLE IF NOT EXISTS `blog`.`Comentario` (
45  `id` INT NOT NULL ,
46  `comentario` VARCHAR(32) NULL ,
47  `creado_en` DATETIME NULL ,
48  `actualizado_en` DATETIME NULL ,
49  `usuario_id` INT NULL ,
50  `entrada_id` INT NULL ,
51  PRIMARY KEY (`id`) ,
52  INDEX `fk_Comentario_Usuario1` (`usuario_id` ASC) ,
53  INDEX `fk_Comentario_Entrada1` (`entrada_id` ASC) ,
54  CONSTRAINT `fk_Comentario_Usuario1`
55    FOREIGN KEY (`usuario_id` )
56    REFERENCES `blog`.`Usuario` (`id` )
57    ON DELETE NO ACTION
58    ON UPDATE NO ACTION,
59  CONSTRAINT `fk_Comentario_Entrada1`
60    FOREIGN KEY (`entrada_id` )
61    REFERENCES `blog`.`Entrada` (`id` )
62    ON DELETE NO ACTION
63    ON UPDATE NO ACTION)
64ENGINE = InnoDB;
65
66
67
68SET SQL_MODE=@OLD_SQL_MODE;
69SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
70SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;