Subversion Repositories eFlore/Applications.cel

Rev

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

Rev 2395 Rev 2404
Line 10... Line 10...
10 
 
 10 
 
11 
CREATE  TABLE IF NOT EXISTS `cel_obs_images` (
 11 
CREATE  TABLE IF NOT EXISTS `cel_obs_images` (
12 
  `id_image` BIGINT NOT NULL ,
 12 
  `id_image` BIGINT NOT NULL ,
13 
  `id_observation` BIGINT NOT NULL ,
 13 
  `id_observation` BIGINT NOT NULL ,
14 
  `date_liaison` DATETIME NOT NULL ,
 14 
  `date_liaison` DATETIME NOT NULL ,
- 
 
 15 
  PRIMARY KEY (`id_image`, `id_observation`) ,
- 
 
 16 
  INDEX `observation` (`id_observation` ASC) ,
15 
  PRIMARY KEY (`id_image`, `id_observation`) )
 17 
  INDEX `image` (`id_image` ASC) )
16 
ENGINE = MyISAM
 18 
ENGINE = MyISAM
17 
DEFAULT CHARACTER SET = utf8
 19 
DEFAULT CHARACTER SET = utf8
Line 18... Line -...
18 
COLLATE = utf8_unicode_ci;
 - 
 
19 
 
 - 
 
20 
CREATE INDEX `observation` ON `cel_obs_images` (`id_observation` ASC) ;
 - 
 
21 
 
 - 
 
Line 22... Line 20...
22 
CREATE INDEX `image` ON `cel_obs_images` (`id_image` ASC) ;
 20 
COLLATE = utf8_unicode_ci;
23 
 
 21 
 
24 
 
 22 
 
25 
-- -----------------------------------------------------
 23 
-- -----------------------------------------------------
Line 97... Line 95...
97 
  `meta_makernote` LONGTEXT NULL DEFAULT NULL ,
 95 
  `meta_makernote` LONGTEXT NULL DEFAULT NULL ,
98 
  `meta_autres` LONGTEXT NULL DEFAULT NULL ,
 96 
  `meta_autres` LONGTEXT NULL DEFAULT NULL ,
99 
  `date_modification` DATETIME NOT NULL ,
 97 
  `date_modification` DATETIME NOT NULL ,
100 
  `date_creation` DATETIME NOT NULL COMMENT 'Date d\'ajout de l\'image au CEL.' ,
 98 
  `date_creation` DATETIME NOT NULL COMMENT 'Date d\'ajout de l\'image au CEL.' ,
101 
  `publiable_eflore` TINYINT(1) NOT NULL DEFAULT 1 ,
 99 
  `publiable_eflore` TINYINT(1) NOT NULL DEFAULT 1 ,
102 
  PRIMARY KEY (`id_image`) )
 100 
  PRIMARY KEY (`id_image`) ,
- 
 
 101 
  INDEX `id_image` (`id_image` ASC, `ordre` ASC, `ce_utilisateur` ASC) )
103 
ENGINE = MyISAM
 102 
ENGINE = MyISAM
104 
AUTO_INCREMENT = 265
 103 
AUTO_INCREMENT = 265
105 
DEFAULT CHARACTER SET = utf8
 104 
DEFAULT CHARACTER SET = utf8
106 
COLLATE = utf8_general_ci;
 105 
COLLATE = utf8_general_ci;
Line 107... Line -...
107 
 
 - 
 
108 
CREATE INDEX `id_image` ON `cel_images` (`id_image` ASC, `ordre` ASC, `ce_utilisateur` ASC) ;
 - 
 
Line 109... Line 106...
109 
 
 106 
 
110 
 
 107 
 
111 
-- -----------------------------------------------------
 108 
-- -----------------------------------------------------
112 
-- Table `cel_zones_geo`
 109 
-- Table `cel_zones_geo`
Line 125... Line 122...
125 
  `date_modification` DATETIME NOT NULL ,
 122 
  `date_modification` DATETIME NOT NULL ,
126 
  `ce_zone_geo_parente` VARCHAR(50) NULL DEFAULT NULL ,
 123 
  `ce_zone_geo_parente` VARCHAR(50) NULL DEFAULT NULL ,
127 
  `bg` BIGINT NULL ,
 124 
  `bg` BIGINT NULL ,
128 
  `bd` BIGINT NULL ,
 125 
  `bd` BIGINT NULL ,
129 
  `niveau` INT NULL ,
 126 
  `niveau` INT NULL ,
130 
  PRIMARY KEY (`id_zone_geo`) )
 127 
  PRIMARY KEY (`id_zone_geo`) ,
- 
 
 128 
  INDEX `nom` (`nom` ASC) )
131 
ENGINE = MyISAM
 129 
ENGINE = MyISAM
132 
DEFAULT CHARACTER SET = utf8
 130 
DEFAULT CHARACTER SET = utf8
133 
COLLATE = utf8_general_ci;
 131 
COLLATE = utf8_general_ci;
Line 134... Line -...
134 
 
 - 
 
135 
CREATE INDEX `nom` ON `cel_zones_geo` (`nom` ASC) ;
 - 
 
Line 136... Line 132...
136 
 
 132 
 
137 
 
 133 
 
138 
-- -----------------------------------------------------
 134 
-- -----------------------------------------------------
139 
-- Table `cel_obs_etendues`
 135 
-- Table `cel_obs_etendues`
Line 214... Line 210...
214 
  `date_transmission` DATETIME NULL DEFAULT NULL ,
 210 
  `date_transmission` DATETIME NULL DEFAULT NULL ,
215 
  `abondance` VARCHAR(50) NULL DEFAULT NULL ,
 211 
  `abondance` VARCHAR(50) NULL DEFAULT NULL ,
216 
  `certitude` VARCHAR(255) NULL DEFAULT NULL ,
 212 
  `certitude` VARCHAR(255) NULL DEFAULT NULL ,
217 
  `phenologie` VARCHAR(255) NULL DEFAULT NULL ,
 213 
  `phenologie` VARCHAR(255) NULL DEFAULT NULL ,
218 
  `code_insee_calcule` VARCHAR(5) NULL DEFAULT NULL COMMENT 'Code INSEE calculé par un scrip CRON.' ,
 214 
  `code_insee_calcule` VARCHAR(5) NULL DEFAULT NULL COMMENT 'Code INSEE calculé par un scrip CRON.' ,
- 
 
 215 
  PRIMARY KEY (`id_observation`) ,
- 
 
 216 
  UNIQUE INDEX `id_obs` (`ce_utilisateur` ASC, `ordre` ASC) ,
- 
 
 217 
  INDEX `date_creation` (`ce_utilisateur`(10) ASC, `date_creation` ASC) ,
- 
 
 218 
  INDEX `coordonnees` (`latitude` ASC, `longitude` ASC) ,
- 
 
 219 
  INDEX `nom_retenu` (`nom_ret` ASC) ,
- 
 
 220 
  INDEX `date_observation` (`date_observation` ASC) COMMENT ' /* comment truncated */ /*Index sur (bdtfx,bdtfx,isfan)*/' ,
219 
  PRIMARY KEY (`id_observation`) COMMENT ' /* comment truncated */ /*Index sur (bdtfx,bdtfx,isfan)*/' COMMENT ' /* comment truncated */ /*Date_transmission : nécessaire à l'ORDER BY utilisé dans la liste d'observation de DEL*/' COMMENT ' /* comment truncated */ /*Nécessaire à CEL/DEL qui officie avec transmission = 1*/' )
 221 
  INDEX `nom_referentiel` (`nom_referentiel`(5) ASC) COMMENT ' /* comment truncated */ /*Date_transmission : nécessaire à l'ORDER BY utilisé dans la liste d'observation de DEL*/' ,
- 
 
 222 
  INDEX `date_transmission` (`date_transmission` DESC) COMMENT ' /* comment truncated */ /*Nécessaire à CEL/DEL qui officie avec transmission = 1*/' ,
- 
 
 223 
  INDEX `transmission` (`transmission` ASC) )
220 
ENGINE = MyISAM
 224 
ENGINE = MyISAM
221 
DEFAULT CHARACTER SET = utf8
 225 
DEFAULT CHARACTER SET = utf8
222 
COLLATE = utf8_general_ci;
 226 
COLLATE = utf8_general_ci;
Line 223... Line -...
223 
 
 - 
 
224 
CREATE UNIQUE INDEX `id_obs` ON `cel_obs` (`ce_utilisateur` ASC, `ordre` ASC) ;
 - 
 
225 
 
 - 
 
226 
CREATE INDEX `date_creation` ON `cel_obs` (`ce_utilisateur`(10) ASC, `date_creation` ASC) ;
 - 
 
227 
 
 - 
 
228 
CREATE INDEX `coordonnees` ON `cel_obs` (`latitude` ASC, `longitude` ASC) ;
 - 
 
229 
 
 - 
 
230 
CREATE INDEX `nom_retenu` ON `cel_obs` (`nom_ret` ASC) ;
 - 
 
231 
 
 - 
 
232 
CREATE INDEX `date_observation` ON `cel_obs` (`date_observation` ASC) ;
 - 
 
233 
 
 - 
 
234 
CREATE INDEX `nom_referentiel` ON `cel_obs` (`nom_referentiel`(5) ASC) ;
 - 
 
235 
 
 - 
 
236 
CREATE INDEX `date_transmission` ON `cel_obs` (`date_transmission` DESC) ;
 - 
 
237 
 
 - 
 
238 
CREATE INDEX `transmission` ON `cel_obs` (`transmission` ASC) ;
 - 
 
Line 239... Line 227...
239 
 
 227 
 
240 
 
 228 
 
241 
-- -----------------------------------------------------
 229 
-- -----------------------------------------------------
242 
-- Table `cel_utilisateurs_infos`
 230 
-- Table `cel_utilisateurs_infos`
Line 292... Line 280...
292 
CREATE  TABLE IF NOT EXISTS `cel_catalogue_champs_etendus` (
 280 
CREATE  TABLE IF NOT EXISTS `cel_catalogue_champs_etendus` (
293 
  `cle` VARCHAR(255) NOT NULL ,
 281 
  `cle` VARCHAR(255) NOT NULL ,
294 
  `label` VARCHAR(255) NULL ,
 282 
  `label` VARCHAR(255) NULL ,
295 
  `invisible` TINYINT(1) NULL ,
 283 
  `invisible` TINYINT(1) NULL ,
296 
  `groupe` TINYINT(1) NULL ,
 284 
  `groupe` TINYINT(1) NULL ,
- 
 
 285 
  `prive` TINYINT(1) NULL ,
297 
  PRIMARY KEY (`cle`) )
 286 
  PRIMARY KEY (`cle`) )
298 
ENGINE = InnoDB;
 287 
ENGINE = InnoDB;
Line 299... Line 288...
299 
 
 288