kBj6LTaV

1DROP DATABASE IF EXISTS `e0_bdd_inno`;
2
3
4CREATE DATABASE IF NOT EXISTS `e0_bdd_inno`;
5
6
7USE `e0_bdd_inno`;
8
9
10DROP TABLE IF EXISTS `users`;
11
12
13CREATE TABLE IF NOT EXISTS `users`
14(
15`id` INT (11) NOT NULL,
16`login` VARCHAR (255) NOT NULL,
17`password` VARCHAR (255) NOT NULL,
18`email` VARCHAR (255) NOT NULL,
19PRIMARY KEY (`id`)
20);
21
22
23DROP TABLE IF EXISTS `posts`;
24
25
26CREATE TABLE IF NOT EXISTS `posts`
27(
28`id` INT (11) NOT NULL,
29`user_id` INT (11) NOT NULL,
30`title` VARCHAR (255) NOT NULL,
31`content` VARCHAR (255) NOT NULL,
32`date` DATETIME NOT NULL,
33PRIMARY KEY (`id`)
34);
35
36
37DROP TABLE IF EXISTS `comments`;
38
39
40CREATE TABLE IF NOT EXISTS `comments`
41(
42`id` INT (11) NOT NULL,
43`user_id` INT (11) NOT NULL,
44`post_id` INT (11) NOT NULL,
45`content` VARCHAR (255) NOT NULL,
46`date` DATETIME NOT NULL,
47PRIMARY KEY (`id`)
48);
49
50
51ALTER TABLE `users` ENGINE = innodb;
52
53
54ALTER TABLE `posts` ENGINE = innodb;
55
56
57ALTER TABLE `comments` ENGINE = innodb;