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;