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 NOT NULL AUTO_INCREMENT , |
`id_protocole` INT(11) 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 NOT NULL , |
`ce_protocole` INT(11) NOT NULL , |
`ce_utilisateur` INT NULL , |
`valeur` TINYINT(1) NOT NULL , |
`date` DATETIME NOT NULL , |