| 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` (
|
|
|
7 |
`id_mot_cle` INT NOT NULL ,
|
|
|
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` (
|
|
|
31 |
`id_mot_cle` INT NOT NULL ,
|
|
|
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;
|