fZ2rzTMb

1-- MySQL Workbench Forward Engineering
2
3SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
4SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
5SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
6
7-- -----------------------------------------------------
8-- Schema the_wall2
9-- -----------------------------------------------------
10
11-- -----------------------------------------------------
12-- Schema the_wall2
13-- -----------------------------------------------------
14CREATE SCHEMA IF NOT EXISTS `the_wall2` DEFAULT CHARACTER SET latin1 ;
15USE `the_wall2` ;
16
17-- -----------------------------------------------------
18-- Table `the_wall2`.`users`
19-- -----------------------------------------------------
20CREATE TABLE IF NOT EXISTS `the_wall2`.`users` (
21  `id` INT NOT NULL AUTO_INCREMENT,
22  `first_name` VARCHAR(255) NULL,
23  `last_name` VARCHAR(255) NULL,
24  `email` VARCHAR(255) NULL,
25  `password` VARCHAR(255) NULL,
26  `created_at` DATETIME NULL,
27  `updated_at` DATETIME NULL,
28  PRIMARY KEY (`id`))
29ENGINE = InnoDB;
30
31
32-- -----------------------------------------------------
33-- Table `the_wall2`.`posts`
34-- -----------------------------------------------------
35CREATE TABLE IF NOT EXISTS `the_wall2`.`posts` (
36  `id` INT NOT NULL AUTO_INCREMENT,
37  `text` VARCHAR(500) NULL,
38  `created_at` DATETIME NULL,
39  `updated_at` DATETIME NULL,
40  `user_id` INT NOT NULL,
41  PRIMARY KEY (`id`),
42  INDEX `fk_posts_users_idx` (`user_id` ASC),
43  CONSTRAINT `fk_posts_users`
44    FOREIGN KEY (`user_id`)
45    REFERENCES `the_wall2`.`users` (`id`)
46    ON DELETE NO ACTION
47    ON UPDATE NO ACTION)
48ENGINE = InnoDB;
49
50
51-- -----------------------------------------------------
52-- Table `the_wall2`.`comments`
53-- -----------------------------------------------------
54CREATE TABLE IF NOT EXISTS `the_wall2`.`comments` (
55  `id` INT NOT NULL AUTO_INCREMENT,
56  `text` VARCHAR(255) NULL,
57  `created_at` DATETIME NULL,
58  `updated_at` DATETIME NULL,
59  `post_id` INT NOT NULL,
60  `user_id` INT NOT NULL,
61  PRIMARY KEY (`id`),
62  INDEX `fk_comments_posts1_idx` (`post_id` ASC),
63  INDEX `fk_comments_users1_idx` (`user_id` ASC),
64  CONSTRAINT `fk_comments_posts1`
65    FOREIGN KEY (`post_id`)
66    REFERENCES `the_wall2`.`posts` (`id`)
67    ON DELETE NO ACTION
68    ON UPDATE NO ACTION,
69  CONSTRAINT `fk_comments_users1`
70    FOREIGN KEY (`user_id`)
71    REFERENCES `the_wall2`.`users` (`id`)
72    ON DELETE NO ACTION
73    ON UPDATE NO ACTION)
74ENGINE = InnoDB;
75
76
77SET SQL_MODE=@OLD_SQL_MODE;
78SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
79SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;