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;