9Bk4Qj5j

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 `superhero` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
6USE `superhero` ;
7
8-- -----------------------------------------------------
9-- Table `superhero`.`users`
10-- -----------------------------------------------------
11CREATE  TABLE IF NOT EXISTS `superhero`.`users` (
12  `id` INT NOT NULL AUTO_INCREMENT ,
13  `pseudo` VARCHAR(50) NULL ,
14  `password` VARCHAR(45) NULL ,
15  `email` VARCHAR(50) NULL ,
16  PRIMARY KEY (`id`) )
17ENGINE = InnoDB
18DEFAULT CHARACTER SET = utf8
19COLLATE = utf8_unicode_ci;
20
21
22-- -----------------------------------------------------
23-- Table `superhero`.`news`
24-- -----------------------------------------------------
25CREATE  TABLE IF NOT EXISTS `superhero`.`news` (
26  `id` INT NOT NULL AUTO_INCREMENT ,
27  `titre` VARCHAR(255) NULL ,
28  `date_crea` DATETIME NULL ,
29  `date_modif` DATETIME NULL ,
30  `contenu` LONGTEXT NULL ,
31  `level` INT NULL ,
32  `auteur` VARCHAR(50) NULL ,
33  `users_id` INT NOT NULL ,
34  PRIMARY KEY (`id`) ,
35  INDEX `fk_news_users` (`users_id` ASC) )
36ENGINE = InnoDB
37DEFAULT CHARACTER SET = utf8
38COLLATE = utf8_unicode_ci;
39
40
41-- -----------------------------------------------------
42-- Table `superhero`.`commentaires`
43-- -----------------------------------------------------
44CREATE  TABLE IF NOT EXISTS `superhero`.`commentaires` (
45  `id` INT NOT NULL AUTO_INCREMENT ,
46  `auteur` VARCHAR(50) NULL ,
47  `date_crea` DATETIME NULL ,
48  `date_modif` DATETIME NULL ,
49  `contenu` MEDIUMTEXT NULL ,
50  `news_id` INT NOT NULL ,
51  PRIMARY KEY (`id`) ,
52  INDEX `fk_commentaires_news1` (`news_id` ASC) )
53ENGINE = InnoDB
54DEFAULT CHARACTER SET = utf8
55COLLATE = utf8_unicode_ci;
56
57
58
59SET SQL_MODE=@OLD_SQL_MODE;
60SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
61SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;