| 14,7 → 14,7 |
|---|
| `nom` VARCHAR(255) NOT NULL , |
| `courriel` VARCHAR(255) NOT NULL , |
| `mot_de_passe` VARCHAR(45) NULL , |
| `licence_acceptee` TINYINT(1) NULL , |
| `licence_acceptee` TINYINT(1) NULL , |
| PRIMARY KEY (`id_utilisateur`) ) |
| ENGINE = MyISAM |
| DEFAULT CHARACTER SET = utf8 |
| 37,7 → 37,7 |
|---|
| `nom_original` VARCHAR(255) NULL , |
| `date_modification` DATETIME NOT NULL , |
| `date_creation` DATETIME NOT NULL , |
| `publiable_eflore` TINYINT(1) NULL , |
| `publiable_eflore` TINYINT(1) NULL , |
| PRIMARY KEY (`id_image`) ) |
| ENGINE = MyISAM |
| DEFAULT CHARACTER SET = utf8 |
| 82,7 → 82,7 |
|---|
| DROP TABLE IF EXISTS `del_image_protocole` ; |
| |
| CREATE TABLE IF NOT EXISTS `del_image_protocole` ( |
| `id_protocole` INT(11) NOT NULL AUTO_INCREMENT , |
| `id_protocole` INT NOT NULL AUTO_INCREMENT , |
| `intitule` VARCHAR(255) NOT NULL , |
| `descriptif` TEXT NULL , |
| PRIMARY KEY (`id_protocole`) ) |
| 99,7 → 99,7 |
|---|
| CREATE TABLE IF NOT EXISTS `del_image_vote` ( |
| `id_vote` BIGINT NOT NULL AUTO_INCREMENT , |
| `ce_image` BIGINT NOT NULL , |
| `ce_protocole` INT(11) NOT NULL , |
| `ce_protocole` INT NOT NULL , |
| `ce_utilisateur` INT NULL , |
| `valeur` TINYINT(1) NOT NULL , |
| `date` DATETIME NOT NULL , |