Subversion Repositories eFlore/Applications.cel

Rev

Rev 2063 | Blame | Last modification | View Log | RSS feed

-- -----------------------------------------------------
-- Table `cel_arbre_mots_cles_images`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `cel_arbre_mots_cles_images` ;

CREATE  TABLE IF NOT EXISTS `cel_arbre_mots_cles_images` (
  `id_mot_cle` INT NOT NULL AUTO_INCREMENT ,
  `chemin` VARCHAR(2048) NULL ,
  `mot_cle` VARCHAR(255) NULL ,
  `id_utilisateur` VARCHAR(255) NULL ,
  PRIMARY KEY (`id_mot_cle`) )
ENGINE = MyISAM;

-- -----------------------------------------------------
-- Table `cel_mots_cles_images_liaison`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `cel_mots_cles_images_liaison` ;

CREATE  TABLE IF NOT EXISTS `cel_mots_cles_images_liaison` (
  `id_element_lie` INT NOT NULL ,
  `id_mot_cle` INT NOT NULL ,
  PRIMARY KEY (`id_element_lie`, `id_mot_cle`) )
ENGINE = MyISAM;

-- -----------------------------------------------------
-- Table `cel_arbre_mots_cles_obs`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `cel_arbre_mots_cles_obs` ;

CREATE  TABLE IF NOT EXISTS `cel_arbre_mots_cles_obs` (
  `id_mot_cle` INT NOT NULL AUTO_INCREMENT ,
  `chemin` VARCHAR(2048) NULL ,
  `mot_cle` VARCHAR(255) NULL ,
  `id_utilisateur` VARCHAR(255) NULL ,
  PRIMARY KEY (`id_mot_cle`) )
ENGINE = MyISAM;

-- -----------------------------------------------------
-- Table `cel_mots_cles_obs_liaison`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `cel_mots_cles_obs_liaison` ;

CREATE  TABLE IF NOT EXISTS `cel_mots_cles_obs_liaison` (
  `id_element_lie` INT NOT NULL ,
  `id_mot_cle` INT NOT NULL ,
  PRIMARY KEY (`id_element_lie`, `id_mot_cle`) )
ENGINE = MyISAM;