Subversion Repositories eFlore/Applications.cel

Rev

Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
2063 aurelien 1 
-- -----------------------------------------------------
2 
-- Table `cel_arbre_mots_cles_images`
3 
-- -----------------------------------------------------
4 
DROP TABLE IF EXISTS `cel_arbre_mots_cles_images` ;
5 
 
6 
CREATE  TABLE IF NOT EXISTS `cel_arbre_mots_cles_images` (
2069 aurelien 7 
  `id_mot_cle` INT NOT NULL AUTO_INCREMENT ,
2063 aurelien 8 
  `chemin` VARCHAR(2048) NULL ,
9 
  `mot_cle` VARCHAR(255) NULL ,
10 
  `id_utilisateur` VARCHAR(255) NULL ,
11 
  PRIMARY KEY (`id_mot_cle`) )
12 
ENGINE = MyISAM;
13 
 
14 
-- -----------------------------------------------------
15 
-- Table `cel_mots_cles_images_liaison`
16 
-- -----------------------------------------------------
17 
DROP TABLE IF EXISTS `cel_mots_cles_images_liaison` ;
18 
 
19 
CREATE  TABLE IF NOT EXISTS `cel_mots_cles_images_liaison` (
20 
  `id_element_lie` INT NOT NULL ,
21 
  `id_mot_cle` INT NOT NULL ,
22 
  PRIMARY KEY (`id_element_lie`, `id_mot_cle`) )
23 
ENGINE = MyISAM;
24 
 
25 
-- -----------------------------------------------------
26 
-- Table `cel_arbre_mots_cles_obs`
27 
-- -----------------------------------------------------
28 
DROP TABLE IF EXISTS `cel_arbre_mots_cles_obs` ;
29 
 
30 
CREATE  TABLE IF NOT EXISTS `cel_arbre_mots_cles_obs` (
2069 aurelien 31 
  `id_mot_cle` INT NOT NULL AUTO_INCREMENT ,
2063 aurelien 32 
  `chemin` VARCHAR(2048) NULL ,
33 
  `mot_cle` VARCHAR(255) NULL ,
34 
  `id_utilisateur` VARCHAR(255) NULL ,
35 
  PRIMARY KEY (`id_mot_cle`) )
36 
ENGINE = MyISAM;
37 
 
38 
-- -----------------------------------------------------
39 
-- Table `cel_mots_cles_obs_liaison`
40 
-- -----------------------------------------------------
41 
DROP TABLE IF EXISTS `cel_mots_cles_obs_liaison` ;
42 
 
43 
CREATE  TABLE IF NOT EXISTS `cel_mots_cles_obs_liaison` (
44 
  `id_element_lie` INT NOT NULL ,
45 
  `id_mot_cle` INT NOT NULL ,
46 
  PRIMARY KEY (`id_element_lie`, `id_mot_cle`) )
47 
ENGINE = MyISAM;