Subversion Repositories eFlore/Applications.del

Rev

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

Rev 749 Rev 784
Line 178... Line 178...
178 
-- -----------------------------------------------------
 178 
-- -----------------------------------------------------
179 
DROP TABLE IF EXISTS `del_obs_image` ;
 179 
DROP TABLE IF EXISTS `del_obs_image` ;
Line 180... Line 180...
180 
 
 180 
 
181 
CREATE  TABLE IF NOT EXISTS `del_obs_image` (
 181 
CREATE  TABLE IF NOT EXISTS `del_obs_image` (
182 
  `id_image` BIGINT NOT NULL ,
 - 
 
183 
  `id_utilisateur` INT NOT NULL ,
 182 
  `id_image` BIGINT NOT NULL ,
184 
  `id_observation` BIGINT NOT NULL ,
 183 
  `id_observation` BIGINT NOT NULL ,
185 
  `date_liaison` DATETIME NOT NULL ,
 184 
  `date_liaison` DATETIME NOT NULL ,
186 
  PRIMARY KEY (`id_image`, `id_observation`, `id_utilisateur`) )
 185 
  PRIMARY KEY (`id_image`, `id_observation`) )
187 
ENGINE = MyISAM
 186 
ENGINE = MyISAM
188 
DEFAULT CHARACTER SET = utf8
 187 
DEFAULT CHARACTER SET = utf8
Line 189... Line -...
189 
COLLATE = utf8_general_ci;
 - 
 
190 
 
 188 
COLLATE = utf8_general_ci;
191 
 
 189 
 
192 
 
 190 
 
193 
SET SQL_MODE=@OLD_SQL_MODE;
 191 
SET SQL_MODE=@OLD_SQL_MODE;