Subversion Repositories eFlore/Applications.del

Rev

Rev 712 | Rev 721 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 712 Rev 715
Line 12... Line 12...
12 
  `id_utilisateur` BIGINT NOT NULL AUTO_INCREMENT COMMENT '	' ,
 12 
  `id_utilisateur` BIGINT NOT NULL AUTO_INCREMENT COMMENT '	' ,
13 
  `prenom` VARCHAR(255) NOT NULL ,
 13 
  `prenom` VARCHAR(255) NOT NULL ,
14 
  `nom` VARCHAR(255) NOT NULL ,
 14 
  `nom` VARCHAR(255) NOT NULL ,
15 
  `courriel` VARCHAR(255) NOT NULL ,
 15 
  `courriel` VARCHAR(255) NOT NULL ,
16 
  `mot_de_passe` VARCHAR(45) NULL ,
 16 
  `mot_de_passe` VARCHAR(45) NULL ,
17 
  `licence_acceptee` TINYINT(1) NULL ,
 17 
  `licence_acceptee` TINYINT(1)  NULL ,
18 
  PRIMARY KEY (`id_utilisateur`) )
 18 
  PRIMARY KEY (`id_utilisateur`) )
19 
ENGINE = MyISAM
 19 
ENGINE = MyISAM
20 
DEFAULT CHARACTER SET = utf8
 20 
DEFAULT CHARACTER SET = utf8
21 
COLLATE = utf8_general_ci;
 21 
COLLATE = utf8_general_ci;
Line 35... Line 35...
35 
  `mots_cles_texte` LONGTEXT NULL ,
 35 
  `mots_cles_texte` LONGTEXT NULL ,
36 
  `commentaire` LONGTEXT NULL ,
 36 
  `commentaire` LONGTEXT NULL ,
37 
  `nom_original` VARCHAR(255) NULL ,
 37 
  `nom_original` VARCHAR(255) NULL ,
38 
  `date_modification` DATETIME NOT NULL ,
 38 
  `date_modification` DATETIME NOT NULL ,
39 
  `date_creation` DATETIME NOT NULL ,
 39 
  `date_creation` DATETIME NOT NULL ,
40 
  `publiable_eflore` TINYINT(1) NULL ,
 40 
  `publiable_eflore` TINYINT(1)  NULL ,
41 
  PRIMARY KEY (`id_image`) )
 41 
  PRIMARY KEY (`id_image`) )
42 
ENGINE = MyISAM
 42 
ENGINE = MyISAM
43 
DEFAULT CHARACTER SET = utf8
 43 
DEFAULT CHARACTER SET = utf8
44 
COLLATE = utf8_general_ci;
 44 
COLLATE = utf8_general_ci;
Line 80... Line 80...
80 
-- Table `del_image_protocole`
 80 
-- Table `del_image_protocole`
81 
-- -----------------------------------------------------
 81 
-- -----------------------------------------------------
82 
DROP TABLE IF EXISTS `del_image_protocole` ;
 82 
DROP TABLE IF EXISTS `del_image_protocole` ;
Line 83... Line 83...
83 
 
 83 
 
84 
CREATE  TABLE IF NOT EXISTS `del_image_protocole` (
 84 
CREATE  TABLE IF NOT EXISTS `del_image_protocole` (
85 
  `id_protocole` INT(11) NOT NULL AUTO_INCREMENT ,
 85 
  `id_protocole` INT NOT NULL AUTO_INCREMENT ,
86 
  `intitule` VARCHAR(255) NOT NULL ,
 86 
  `intitule` VARCHAR(255) NOT NULL ,
87 
  `descriptif` TEXT NULL ,
 87 
  `descriptif` TEXT NULL ,
88 
  PRIMARY KEY (`id_protocole`) )
 88 
  PRIMARY KEY (`id_protocole`) )
89 
ENGINE = MyISAM
 89 
ENGINE = MyISAM
Line 97... Line 97...
97 
DROP TABLE IF EXISTS `del_image_vote` ;
 97 
DROP TABLE IF EXISTS `del_image_vote` ;
Line 98... Line 98...
98 
 
 98 
 
99 
CREATE  TABLE IF NOT EXISTS `del_image_vote` (
 99 
CREATE  TABLE IF NOT EXISTS `del_image_vote` (
100 
  `id_vote` BIGINT NOT NULL AUTO_INCREMENT ,
 100 
  `id_vote` BIGINT NOT NULL AUTO_INCREMENT ,
101 
  `ce_image` BIGINT NOT NULL ,
 101 
  `ce_image` BIGINT NOT NULL ,
102 
  `ce_protocole` INT(11) NOT NULL ,
 102 
  `ce_protocole` INT NOT NULL ,
103 
  `ce_utilisateur` INT NULL ,
 103 
  `ce_utilisateur` INT NULL ,
104 
  `valeur` TINYINT(1) NOT NULL ,
 104 
  `valeur` TINYINT(1) NOT NULL ,
105 
  `date` DATETIME NOT NULL ,
 105 
  `date` DATETIME NOT NULL ,
106 
  PRIMARY KEY (`id_vote`) )
 106 
  PRIMARY KEY (`id_vote`) )