3c6fRhus

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 mydb
9-- -----------------------------------------------------
10-- -----------------------------------------------------
11-- Schema news_board
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema news_board
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `news_board` DEFAULT CHARACTER SET utf8 ;
18USE `news_board` ;
19
20-- -----------------------------------------------------
21-- Table `news_board`.`role`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `news_board`.`role` (
24  `id` INT(1) NOT NULL,
25  `name` VARCHAR(45) NULL DEFAULT NULL,
26  `priority` INT(1) NULL DEFAULT NULL,
27  `rolecol` VARCHAR(45) NULL DEFAULT NULL,
28  PRIMARY KEY (`id`),
29  UNIQUE INDEX `name_UNIQUE` (`name` ASC))
30ENGINE = InnoDB
31DEFAULT CHARACTER SET = utf8;
32
33
34-- -----------------------------------------------------
35-- Table `news_board`.`user`
36-- -----------------------------------------------------
37CREATE TABLE IF NOT EXISTS `news_board`.`user` (
38  `id` INT(11) NOT NULL AUTO_INCREMENT,
39  `login` VARCHAR(45) NOT NULL,
40  `password` VARCHAR(255) NOT NULL,
41  `firstname` VARCHAR(45) NOT NULL,
42  `lastname` VARCHAR(45) NULL DEFAULT NULL,
43  `email` VARCHAR(255) NOT NULL,
44  `role_id` INT(1) NOT NULL,
45  PRIMARY KEY (`id`),
46  UNIQUE INDEX `email_UNIQUE` (`email` ASC),
47  UNIQUE INDEX `login_UNIQUE` (`login` ASC))
48ENGINE = InnoDB
49DEFAULT CHARACTER SET = utf8;
50
51
52-- -----------------------------------------------------
53-- Table `news_board`.`post`
54-- -----------------------------------------------------
55CREATE TABLE IF NOT EXISTS `news_board`.`post` (
56  `id` INT(11) NOT NULL AUTO_INCREMENT,
57  `title` VARCHAR(45) NOT NULL,
58  `description` MEDIUMTEXT NOT NULL,
59  `author` INT(11) NOT NULL,
60  `like_count` INT(10) UNSIGNED ZEROFILL NOT NULL,
61  PRIMARY KEY (`id`))
62ENGINE = InnoDB
63DEFAULT CHARACTER SET = utf8;
64
65
66-- -----------------------------------------------------
67-- Table `news_board`.`like`
68-- -----------------------------------------------------
69CREATE TABLE IF NOT EXISTS `news_board`.`like` (
70  `id_user` INT(11) NOT NULL,
71  `id_post` INT(11) NOT NULL,
72  PRIMARY KEY (`id_user`, `id_post`))
73ENGINE = InnoDB
74DEFAULT CHARACTER SET = utf8;
75
76
77-- -----------------------------------------------------
78-- Table `news_board`.`tag`
79-- -----------------------------------------------------
80CREATE TABLE IF NOT EXISTS `news_board`.`tag` (
81  `id` INT(11) NOT NULL AUTO_INCREMENT,
82  `name` VARCHAR(100) NULL DEFAULT NULL,
83  `subscribers_count` INT(10) UNSIGNED ZEROFILL NOT NULL,
84  PRIMARY KEY (`id`),
85  UNIQUE INDEX `name_UNIQUE` (`name` ASC))
86ENGINE = InnoDB
87DEFAULT CHARACTER SET = utf8;
88
89
90-- -----------------------------------------------------
91-- Table `news_board`.`post_tag`
92-- -----------------------------------------------------
93CREATE TABLE IF NOT EXISTS `news_board`.`post_tag` (
94  `id_post` INT(11) NOT NULL,
95  `id_tag` INT(11) NOT NULL,
96  PRIMARY KEY (`id_post`, `id_tag`))
97ENGINE = InnoDB
98DEFAULT CHARACTER SET = utf8;
99
100
101-- -----------------------------------------------------
102-- Table `news_board`.`wiew`
103-- -----------------------------------------------------
104CREATE TABLE IF NOT EXISTS `news_board`.`wiew` (
105  `id_user` INT(11) NOT NULL,
106  `id_post` INT(11) NOT NULL,
107  PRIMARY KEY (`id_user`, `id_post`))
108ENGINE = InnoDB
109DEFAULT CHARACTER SET = utf8;
110
111
112SET SQL_MODE=@OLD_SQL_MODE;
113SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
114SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;