12,16 → 12,14 |
`id_image` BIGINT NOT NULL , |
`id_observation` BIGINT NOT NULL , |
`date_liaison` DATETIME NOT NULL , |
PRIMARY KEY (`id_image`, `id_observation`) ) |
PRIMARY KEY (`id_image`, `id_observation`) , |
INDEX `observation` (`id_observation` ASC) , |
INDEX `image` (`id_image` ASC) ) |
ENGINE = MyISAM |
DEFAULT CHARACTER SET = utf8 |
COLLATE = utf8_unicode_ci; |
|
CREATE INDEX `observation` ON `cel_obs_images` (`id_observation` ASC) ; |
|
CREATE INDEX `image` ON `cel_obs_images` (`id_image` ASC) ; |
|
|
-- ----------------------------------------------------- |
-- Table `cel_utilisateurs` |
-- ----------------------------------------------------- |
99,15 → 97,14 |
`date_modification` DATETIME NOT NULL , |
`date_creation` DATETIME NOT NULL COMMENT 'Date d\'ajout de l\'image au CEL.' , |
`publiable_eflore` TINYINT(1) NOT NULL DEFAULT 1 , |
PRIMARY KEY (`id_image`) ) |
PRIMARY KEY (`id_image`) , |
INDEX `id_image` (`id_image` ASC, `ordre` ASC, `ce_utilisateur` ASC) ) |
ENGINE = MyISAM |
AUTO_INCREMENT = 265 |
DEFAULT CHARACTER SET = utf8 |
COLLATE = utf8_general_ci; |
|
CREATE INDEX `id_image` ON `cel_images` (`id_image` ASC, `ordre` ASC, `ce_utilisateur` ASC) ; |
|
|
-- ----------------------------------------------------- |
-- Table `cel_zones_geo` |
-- ----------------------------------------------------- |
127,14 → 124,13 |
`bg` BIGINT NULL , |
`bd` BIGINT NULL , |
`niveau` INT NULL , |
PRIMARY KEY (`id_zone_geo`) ) |
PRIMARY KEY (`id_zone_geo`) , |
INDEX `nom` (`nom` ASC) ) |
ENGINE = MyISAM |
DEFAULT CHARACTER SET = utf8 |
COLLATE = utf8_general_ci; |
|
CREATE INDEX `nom` ON `cel_zones_geo` (`nom` ASC) ; |
|
|
-- ----------------------------------------------------- |
-- Table `cel_obs_etendues` |
-- ----------------------------------------------------- |
216,28 → 212,20 |
`certitude` VARCHAR(255) NULL DEFAULT NULL , |
`phenologie` VARCHAR(255) NULL DEFAULT NULL , |
`code_insee_calcule` VARCHAR(5) NULL DEFAULT NULL COMMENT 'Code INSEE calculé par un scrip CRON.' , |
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*/' ) |
PRIMARY KEY (`id_observation`) , |
UNIQUE INDEX `id_obs` (`ce_utilisateur` ASC, `ordre` ASC) , |
INDEX `date_creation` (`ce_utilisateur`(10) ASC, `date_creation` ASC) , |
INDEX `coordonnees` (`latitude` ASC, `longitude` ASC) , |
INDEX `nom_retenu` (`nom_ret` ASC) , |
INDEX `date_observation` (`date_observation` ASC) COMMENT ' /* comment truncated */ /*Index sur (bdtfx,bdtfx,isfan)*/' , |
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*/' , |
INDEX `date_transmission` (`date_transmission` DESC) COMMENT ' /* comment truncated */ /*Nécessaire à CEL/DEL qui officie avec transmission = 1*/' , |
INDEX `transmission` (`transmission` ASC) ) |
ENGINE = MyISAM |
DEFAULT CHARACTER SET = utf8 |
COLLATE = utf8_general_ci; |
|
CREATE UNIQUE INDEX `id_obs` ON `cel_obs` (`ce_utilisateur` ASC, `ordre` ASC) ; |
|
CREATE INDEX `date_creation` ON `cel_obs` (`ce_utilisateur`(10) ASC, `date_creation` ASC) ; |
|
CREATE INDEX `coordonnees` ON `cel_obs` (`latitude` ASC, `longitude` ASC) ; |
|
CREATE INDEX `nom_retenu` ON `cel_obs` (`nom_ret` ASC) ; |
|
CREATE INDEX `date_observation` ON `cel_obs` (`date_observation` ASC) ; |
|
CREATE INDEX `nom_referentiel` ON `cel_obs` (`nom_referentiel`(5) ASC) ; |
|
CREATE INDEX `date_transmission` ON `cel_obs` (`date_transmission` DESC) ; |
|
CREATE INDEX `transmission` ON `cel_obs` (`transmission` ASC) ; |
|
|
-- ----------------------------------------------------- |
-- Table `cel_utilisateurs_infos` |
-- ----------------------------------------------------- |
294,6 → 282,7 |
`label` VARCHAR(255) NULL , |
`invisible` TINYINT(1) NULL , |
`groupe` TINYINT(1) NULL , |
`prive` TINYINT(1) NULL , |
PRIMARY KEY (`cle`) ) |
ENGINE = InnoDB; |
|