Subversion Repositories eFlore/Applications.cel

Compare Revisions

Ignore whitespace Rev 2062 → Rev 2063

/trunk/doc/bdd/migration_mots_cles/migration_mots_cles.sql
New file
0,0 → 1,47
-- -----------------------------------------------------
-- 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 ,
`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 ,
`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;